Tables and Fields for Stock - Multiple Materials module MM.

[HungNguyen_123]

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,

[HakanHaslaman · Accepted solution]

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 · Accepted solution]

thank you so much

[Venee · Accepted solution]

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

Thank you