cancel
Showing results for 
Search instead for 
Did you mean: 

How to identify link between rows Goods receipt to Goods Issue (backflush)

chladek
Participant
638

Hello,

Is there any field which content the link from Production order to Goods receipt and to Goods Issue - bakcflush (resource)? In relationship map there is an arrow links this two object so system obviously knows about it so I suppose it has to be in some table/view but could not find it.

SAP B1 9.3 (HANA)

View Entire Topic
prince_ebi
Explorer
0 Kudos

Hi All,

A field in Goods Issue is available to link production goods receipts only for Blackflush.

Filed in "RelatedEnt", and "RelatedTyp" from OIGE 

You can use the below query to link the Good issue to the Production good receipt 

SELECT A."RelatedEnt", A."RelatedTyp", B."DocNum" FROM OIGE A
INNER JOIN OIGN B ON B."DocEntry"=A."RelatedEnt" AND B."ObjType"=A."RelatedTyp"
WHERE A."DocEntry"=1322