How link between OIBT and OBIN

[tewan_ouon]

Hi Expert

I need to know , How link between OIBT and OBIN?

Regards,

Tewan O.

[jitin_chawla]

Hi,

Check below join if that helps with your requirement:

OIBT T0  INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode] 

INNER JOIN OBIN T2 ON T1.[ItemCode] = T2.[SpcItmCode] 

INNER JOIN IBT1 T3 ON T1.[ItemCode] = T3.[ItemCode]

Kr,

Jitin

[tewan_ouon]

Thank Jitin