cancel
Showing results for 
Search instead for 
Did you mean: 

Index field for material availabilty

Mrinal_K_Roy
Active Contributor
0 Kudos

Hi ,

Intend to prepare a report with Material availability date (MAD) from Product view . Please inform the table for the same . Getting also structures for MATD. This field should also be an index field for better performance.

Thanks in advance.

With regards,

Mrinal

Accepted Solutions (0)

Answers (2)

Answers (2)

Mrinal_K_Roy
Active Contributor
0 Kudos

Hello,

Can someone please inform how to get the MAD // Material availability date from an APO table . Could not find it in table /SAPAPO/SCHEDLIN.

With regards,

Mrinal

Former Member
0 Kudos

Hi Mrinal,

MAD is calculated at run time. you can check /SAPAPO/OM16 (live cache) if there is a selection or output field of MAD. Usually the date "Avail/Req date" in product view against sales order is the MAD date unless there are developments done to evaluate the same at some other date.

In ECC you can find the MAD date in table VBEP-field MBDAT

Regards,

Loknath

Former Member
0 Kudos

Mrinal

Sales Order schedule line data are available in /SAPAPO/SCHEDLIN - with Time type = MBDAT and event type = C (confirmed schedule lines).

Data in this table (as with other Sales Order tables) is not automatically deleted after the order is delivered (and therefore deleted from livecache).

Are you saying that in your case, the sales order was CIF'ed to APO, you can see sales order in the product view, but there are no entries in /SAPAPO/SCHEDLIN ?

Rishi Menon

Mrinal_K_Roy
Active Contributor
0 Kudos

Hello,

Can someone please inform how to get the MAD // Material availability date from an APO table . Could not find it in table /SAPAPO/SCHEDLIN.

With regards,

Mrinal