How do I determine in-transit inventory?

Answered

DSP User

• December 16, 2016 14:57

How do I determine in-transit inventory? I need to do this through SAP tables (not with a TCODE) because the client has requested that I set up a staging table with in-transit inventory data.

Some additional information:

The client is interested in including records whose quantities are not visible at some point in time in the MCHB table. If I am not mistaken, the 2-step movement types 313 and 314 instantly move inventories, so there really is not any amount of in-transit at a point in time.

We are interested the following:

1. Stock transfer between 2 plants, same company

2. Stock transfer between 2 plants, different companies

Yes, I understand the in-transit is “virtual,” which is the reason for creating this stStaging table. I figured we would have to calculate the difference between goods issue and goods receipt from PO history. Is this calculated in MB5T?

We need quantities by batch, so using the TRAME field from MARD for intra-company stock transfers is not good. Can we use the “difference between goods issue and goods receipt” approach for intra-company stock transfers as well as for inter-company stock transfers? If so, what are the tables and fields?

1

• Best answer

  

  DSP Expert

  • February 08, 2017 16:00

  SUddin: The system runs an availability check in the supplying plant (issuing plant) for stock transport orders. The checking rules that you define in Customizing determine which stocks (for example, stock in quality inspection and safety stock) and which receipts and issues (for example, reservations and purchase requisitions) are taken into account in the availability check. The availability check checks the issuing storage location in stock transport orders by checking the assigned MRP area.

  1
• 

  DSP Expert

  • December 15, 2016 10:01

  JValerio: It depends on what the kind of stock transfer you have if you do a 2-step movement in inventory management by only using movement types 313 and 314. Using these movement types, the transfer stock for batches will be visible in MCHB if it is a stock transfer between 2 plants in the same company. Then, the stock in transit can be seen in MARC table field TRAME (no information about batch) if it is a stock transfer between 2 plants in different companies. Then, you just have virtual stock in transit, which does not store a stock in transit in a single field; it is the difference between goods issue and goods receipt from your PO history that is calculated in MB5T.

  0

Please sign in to leave a comment.