Skip to Content
0
Jun 21, 2020 at 08:35 AM

SAP B1 Link between OINM and OITL

1668 Views

Hi there,

I am writing a query that should join OINM with OITL(For batches info). I am probably missing a link here because every time I execute OINM it shows less number of records, but when I join OITL, it shows more number of records and some TransNum duplicates.

SELECT B.*
          FROM OITM AS A
          LEFT JOIN OINM AS B ON A."ItemCode" = B."ItemCode"
          LEFT OUTER JOIN OUSR AS C ON B."UserSign" = C.INTERNAL_K
          LEFT OUTER JOIN V_OBJ AS D ON B."TransType" = D."Object"
          
         LEFT JOIN OITL AS E ON B."CreatedBy" = E."DocEntry" AND B."TransType" = E."DocType" AND B."Warehouse" = E."LocCode" AND B."DocLineNum" = E."DocLine" AND B."AppObjLine" = E."BaseLine" AND B."ApplObj" = E."BaseType"
         LEFT JOIN IT1 AS F ON E."LogEntry" = F."LogEntry" AND E."ItemCode" = F."ItemCode"
         LEFT JOIN OBTN AS G ON F."MdAbsEntry" = G."AbsEntry"

This is my query. Kindly suggest correct linking.

Any help is appreciated.