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

Former Member
Former Member 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