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.