MARC table contains two fields, UMLMC and TRAME, which record the stock in transfer from Plant to Plant, either within the same Company or not. I’m trying to identify which Movements in MSEG contribute to such stock. One approach would be to look at field BWART and discriminate based on the Movement Type, but this would require hard coding these types and listing many types in the select statement.

I’m trying to identify Movements for transfer based on some general attribute. What I think I have understood is that when goods are posted to stock in transfer, the movement in MSEG is characterized by LGORT = '' AND UMWRK <> '' (LGORT = '' alone is not sufficient – think e.g. of purchases that are consumed directly, without posting to warehouse).

On the other hand I’ve been unsuccessful in finding a way to identify those movements that consume goods from stock in transfer. E.g., I’m looking at a movement of Type 305 and only a few fields in MSEG are filled with some value; basically only WERKS and LGORT, which tell me where the goods go, but I see no way to tell whether such goods come from stock in transfer or anywhere else.