To get what I think you want you'll need to link several tables. While the destination storage location is usually taken from the GR material movement and is usually used to post the stock out, it is not reliable as the storage location can be manually changed during the stock posting if the user desires. Also a user can post some material to storage location A, and some material to storage location B and to as many other storage locations as they desire. They just have to do them one a time, I.e. run QA11/12 more than once.
Link QALS table to QAMB. Link is by inspection lot number. You can have multiple records in QAMB for each inspection lot as you can have multiple stock postings performed per inspection lot. This table shows multiple types of material documents related to UD's. So you probably only want to select Type 3's, (field QAMB-TYP).
You can then link the QAMB table to the MSEG table by the material document number, material year and item fields.
This should give you all the material documents you need. The MSEG has a lot of data in it and there can be many different types of material movements related to UD's. So you may have to narrow your query down to specific movement types. Obviously the the 321 to UR is one of the obvious ones. Once you have the subset of MSEG records you want you can use the LGORT field in MSEG to get the FROM storage location and UMLGO to get the RECEIVEING storage location.
FF
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.