cancel
Showing results for 
Search instead for 
Did you mean: 

Tables and Fields for Stock - Multiple Materials module MM.

HungNguyen_123
Discoverer
0 Kudos
292

Dear all,

I am trying to build the data model for "Stock - Multiple Materials".

I really need help finding tables and fields that contain the following fields: Reporting Date, Sales Order, Shelf Life Expiration Date, Supplier Name, and Customer.

I have attached the image below.

Thanks and Best Regards,

View Entire Topic
HakanHaslaman
Product and Topic Expert
Product and Topic Expert

As I know:

1. Reporting Date: Derived from system or document date in the MKPF table's BUDAT field.
2. Sales Order: Stored in the VBAK table's VBELN field.
3. Shelf Life Expiration Date: Stored in the MCHB table's VFDAT field.
4. Supplier Name: Stored in the LFA1 table's NAME1 field.
5. Customer: Stored in the KNA1 table's NAME1 field.

These are standard SAP tables and fields. Your system's actual tables and fields may differ.

HungNguyen_123
Discoverer
0 Kudos
thank you so much
Venee
Explorer
0 Kudos

Hello -- please also could you give details on these fields:
Special Stock type
Material
Material Description

Thank you