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

[chladek]

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)

[prince_ebi]

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

[former_member701437]

Hi All,

Issue for production have related object and related entry of receipt from production,

[kothandaraman_nagarajan]

Why you can't get exact qty with the receipt? Did you create any query?

[chladek]

Hi Nagarajan,

The only way I found is to join the the receipt and issue by date and time (as well as with BaseEntry and other needed fields).
But I am not sure about reliability of this solution as I am not sure about what time is used (actual or of twhole transaction) because the time is rounded to minutes.

The best way is found how the SBO links the IGN1 and IGE1 it selfs.

Regards
Zdenek

[kothandaraman_nagarajan]

Hi,

Try this query for Receipt from production and same way try for Issue for production,

SELECT T0.[DocNum], T0.[ItemCode], T0.[Status], T0.[Type], T2.[DocNum], T2.[DocDate], T1.[ItemCode], T1.[Quantity] FROM OWOR T0 LEFT JOIN IGN1 T1 ON T1.[BaseEntry] = T0.DocNum INNER JOIN OIGN T2 ON T1.[DocEntry] = T2.[DocEntry] WHERE T1.[BaseType] = 202 and T0.[ItemCode] = T1.[ItemCode]

Regards,

Nagarajan

[chladek]

Hi Nagarajan, Thank you.
Your solution is well known.
The problem is that I cannot get the exact issued quantity with the receipt.