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