Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table for Storage to Storage Stock in Transit.

Dear Friends,

There are two storage locations : A and B

Created STO and Posted goods issue with VL10B & VL02N from Storage Location A but not received in Storage Location B

I can find this stock in report MB5T.

Now my requirement is to have the Table and Field for the stock in Transit for a material specific to storage Location B.

I am unable to find them in MARC or MARD and MSEG also does not give the right picture. This is for a report to be developed.

Thanks

replied

Hi Gusu.

You can use, the tables EKET, EKKO and EKPO, the report MB5T use the next criteria for extract the information.

___________________________________________________

  • Get PO's within the selection criteria, with delivering plant

  • and more goods issues than goods receipts.

SELECT matnr ekpoebeln ekpoebelp pstyp sobkz umren umrez meins werks

ekkobukrs eketmenge netwr waers wamng wemng wkurs kufix reswk

ekpo~menge AS bstmg ccomp bsakz retpo

INTO CORRESPONDING FIELDS OF TABLE xmdbs

FROM ( ekko INNER JOIN ekpo

ON ekkomandt = ekpomandt

AND ekkoebeln = ekpoebeln

)

INNER JOIN eket

ON ekpomandt = eketmandt

AND ekpoebeln = eketebeln

AND ekpoebelp = eketebelp

WHERE matnr IN xmatnr

AND werks IN xwerks

AND sobkz IN xsobkz

AND pstyp IN xpstyp

AND elikz IN xelikz

AND reswk IN xreswk

AND ekpo~loekz IN xloekz

AND ekpo~bstyp IN ('F', 'L')

AND reswk <> space

AND eketwamng <> eketwemng.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question