Actual shipping date vs original/requested shipping date

[Former Member]

Hi Experts

We are new with SNC and want to not only measure supplier delivery performance on delivery date but also on shipping date - i.e. measure if the supplier shipped the goods on time.

Do you know how we can get a hold of these two dates (actual vs original shipping date)? Are there any table fields to obtain this info or perhaps an option to load the dates into BW info cube?

Thank you in advance.

Best regards,

Dan Bruun

[Former Member · Accepted solution]

Hi Dan,

You can get actual shipping date and original shipping date from the table /1OM/ORDR4SDL<your client name>.(if client=800 then table will be /1OM/ORDR4SDL800).

Go to table /1OM/ORDR7MP3<your client name> enter the PO number in field ORD.NO and copy ORDID use this ORDID in table /1OM/ORDR4SDL<your client name>.

select the record with ORDID(copied from above table) and field SLDType=CONF then field TSTFRFRT will give you the original shipping date and TSTFRTOT will give you original delivery date.

select the record with ORDID(copied from above table) and field SLDType=ASNC then field TSTFRFRT will give you the actual shipping date and TSTFRTOT will give you actual delivery date.

Regards,

Nikhil