The purpose of this blog post is to explain the difference between Stock in Transfer and Stock in Transit demonstrating where we can check the stock (table/tcode), and how to remove the stock if necessary.
What is the difference between Stock in Transfer and Stock in Transit?
- The Stock in Transfer > stock is moved (plant-to-plant) or (storage location-to-storage location) without a Stock Transport Order.
- The Stock in Transit > stock is moved between different plants of the same/different company code via STO.
Where we can check the stock (table)?
- The stock in transfer at storage location level is stored in MARD-UMLME.
- The stock in transfer at plant level is stored in MARC-UMLMC.
- The stock in transit is stored at MARC-TRAME. However, there is an exception:
*** In Cross-Company Stock Transport Orders there is no "real" stock in transit: we do not have stock in transit updated in any table(MARC-TRAME is only updated in the case of Intra-Company Stock Transport Orders. In the Cross-Company scenario, the stock in transit is "virtual": it is dynamically calculated by the program via the purchase order history, as the difference between the goods receipt and the goods issue quantity).
Where we can check the stock (tcode)?
> Stock in Transfer can be checked in transactions MB52 and MMBE:
MMBE:
MARD-UMLME is under column 'Transfer (SLoc)' and MARC-UMLMC is under column 'Stck trans.(plant).
MB52:
> Stock in Transit can be checked in transactions MB52(previous image column 'Stock in Transit') and MB5T below:
At MB5T it is possible to check the Material, Purchase Doc., Supplying plant (SPlt), Supplying Storage Location (StLoc), Receiving Plant (Plnt), Receiving Storage Location (SLoc), and the quantity that is currently in transit (Quantity).
The transit stock displayed by transaction MB5T is calculated based on the PO history and this does not always match the actual transit stock of the material (MARC-TRAME). This is because cross-company STO does not update the MARC-TRAME field.
How to clear the stock in transfer at storage location level (MARD-UMLME)?
The stock in transfer at storage location level is created (increased) in the receiving storage location with the movement type 313. It is decreased with the corresponding movement 315.
To remove the stock from MARD-UMLME MIGO can be used. It will be needed to perform a goods movement to receive the stock in transfer into the receiving storage location.
Steps:
MIGO - Place In Storage - Other - Movement Type 315.
Enter material / receiving plant / receiving storage location / batch (if relevant).
Enter the relevant quantity to receive from stock in transfer.
Post
The stock in transfer at storage location level (MARD-UMLME) is transferred to unrestricted use.
After this, if this material does not exist physically anymore, you need to remove it from the unrestricted stock (MARD-LABST):
Steps:
1 - create a physical inventory document in MI01
2 - enter count in MI04
3 - post physical inventory document in MI07
Or it is also possible to scrap this material in MIGO with movement type 551. If you would not like to allocate this cost to any cost center, please set KOSTL field as optional entry in OMJJ transaction before going to MIGO transaction.
How to clear the stock in transfer at plant level (MARC-UMLMC)?
The stock in transfer (MARC-UMLMC) contains quantity transferred via Inventory management (movements 303/305 and 603/605, and their corresponding reversal movements) and not via stock transport orders.
To remove the stock from MARC-UMLMC you can perform a reversal mvt 305/605 or you would have to move the stock to a storage location and scrap the stock from the storage location (if this material does not exist physically anymore), as follows:
Step 1: Move the stock from MARC-UMLMC to MARD-LABST by a 305/605 mvt, the storage location can be any in the same plant as this stock will be removed in the next step.
Step 2: Remove the stock from MARD-LABST with a goods issue movement type, e.g. 562 mvt, 551 mvt, or via a physical inventory process (701 mvt).
It is also important to mention that the system does not build any real link between these two postings(103/305 and 313/3015).
You can check more information about this on: KBA 1800451 - No link between the documents of a two step stock transfer (with movement types 303/313 and 305/315).
How to clear the stock in transit (MARC-TRAME)?
The stock in transit is increased in the receiving plant with the movement types 351 and 641 (if shipping is involved), and it is decreased when the goods receipt is posted with the movement type 101.
Before clearing the stock in transit that we can see at MB5T or at MARC-TRAME it is necessary to perform some checks to avoid any deficits in the future.
First, check MB5T for the concerned material. Let's check the example from MB5T image, why 4500020390 is being displayed at MB5T?
As the transit stock displayed by transaction MB5T is calculated based on the PO history, we need to check it at ME23N, as below:
The stock in transit is being displayed at MB5T because of Goods issue is not equal to Goods Receipt (GI <> GR).
Once we balance the STO making GR = GI, the stock in transit will be cleared.
So, to clear the stock in transit you have the following alternatives:
1. Balance the STO history, making GR equal to IR.
More details can be checked in SAP KBA
2130024 - MB5T - Stock in Transit for Intracompany
However, if we are dealing with an old PO and it is no longer possible to perform any goods movement against it, that means, you cannot balance the PO history, the alternative is to set the delivery completed indicator in the STO item (EKPO-ELIKZ).
In this case, it is necessary to check if we are dealing with cross-company stock transfers or intra-company stock transfers. This can be checked in tcode OX18 using the two plants involved.
If both plants are under the same company code, we are dealing with an intra-company STO, if not it is a cross-company STO.
Knowing that we can choose the right option below:
2. For cross-company stock transfers there is a modification to complete the STO available with Note
167795 - Completion of stock transfers with quantity of goods issues > quantity of goods received.
3. For intra-company, by standard, the sum of the GI and GR quantities must be equal to have the "Delivery Completed" indicator set.
So, in this case, it is needed to write your own report to set the EKPO-ELIKZ flag as there is no modification or workaround in standard.
You can check more information about this on:
KBA
1618453 - How to fix quantity on stock in transit?
See you in the next posting
🙂