How to get the table and field name for Shelf life expiry batch material?

Transaction codes:

Report tcode:

MB5M - The system will display the shelf life expiration date.
 

Batch tcodes:

MSC1N - Create Batch

MSC2N - Change Batch

MSC3N - Display Batch
 

Material tcode:

MM03 - Display Material Master

Material Master - General Plant Data / Storage 1 View to display:

Total shelf life = MARA-MHDHB
Min. Rem Shelf life = MARA-MHDRZ

Press F1 on field, you want the field and table, then click on technical information button, one with hammer and wrench button and it will tell you the table and field name of that field.
 

Tables:

MCHB - Batch Stocks

MCHBH - Batch Stocks: History Table 

MCH1 - Batches (if Batch Management Cross-Plant)

MCHA - Batches

Shelf life expiry for a material is stored in MCH1-VFDAT and MCHA-VFDAT.

SAP MM Reference Books:
SAP Material Management Interview Questions, Certification and Configuration Books

Goto:
SAP MM Purchasing

Back to:
SAP MM (Materials Management) Configuration Hints and Tips

Return to :-
SAP ABAP/4 Programming, Basis Administration, Configuration Hints and Tips