Skip to Content
avatar image
Former Member

How do I run an in transit report with delivery and date it was PGI'd?

I am currently running multiple in transit reports but not getting the results I need. I need to be able to run a report that shows PO, Part number, Delivery number, and date it was PGI'd.

I am ok with running multiple reports and combining them but the specifics I need are the POs and each delivery that was created under that PO, and also when each specific delivery was PGI's.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 06 at 03:58 AM

    Stock in Transit report (MB5T and MB5TD) only shows with PO number. It doesn't show delivery details. If it is one time job, then would suggest to take additional data from table level (EKPO, LIKP, LIPS etc.). If this is a report requirement, then I would suggest to create a custom report by copying MB5T to your Z with your own logic.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09 at 01:22 PM

    Hi,

    Assuming its an intra-company STO scenario, I would like to highlight the below points:

    • As per the system design, the SIT is stored directly in plant level (MARC-TRAME) and not against delivery.
    • If multiple PGI is done and partial GR is done with PO reference, system can not identify which delivery is in transit.

    Based on the above concepts, its not feasible to track the in-transit stock based on PGI date or based on delivery.

    If its mandatory, you may assume "first PGI'd is GR'd first" and create report with own logic - you may use the EKBE table as a reference.

    Regards,

    Prasoon

    Add comment
    10|10000 characters needed characters exceeded