Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Stock in transit

Former Member

‎2007 Jul 19 1:52 PM

0 Kudos
111

Hi all,

can anybody tell me where i can find all the movements of materials IN TRANSIT?

I found all movements in table S031 but i don't know how to discriminate the transits from the entrances and the exits relevant for the stock and the inventory.

I need them cause i'm recostructing the stock in a particular date substracting and adding entrances and exits from the actual stock.

I've been asked to add the detail of the transits too.

I've found the actual stock in transit in MARC. What Have i to subtract and add to get the stock in a given date??

Thanks in advance.

2 REPLIES 2

Former Member

‎2007 Jul 19 1:58 PM

0 Kudos
72

Hi,

U can check MB5B t.code..

Regards

Former Member

‎2007 Jul 19 1:59 PM

0 Kudos
72

Hi,

You can find transit qty in table VBBE.

Field - OMENG.

For calculating the transit qty use aggregate function SUM while fetching the data.

Example:

SELECT SUM( OMENG ) INTO TR_MENGE

FROM VBBE

WHERE MATNR = I_MATNR

AND WERKS = I_WERKS

AND VBTYP = 'J'

AND LGORT = '0001'.

TR_MENGE - is the transit quantity.

Hope this will solve your problem.

Reward if helpful.