Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error : multi part identifier

hi kings

when i using this query in crystal report sql command and excute its through the error --- multi part identifier "oitm"."ItemCode" could not be bound.

SELECT '61', '', GetDate(), 'TOTAL', "wor1"."ItemCode", Sum("wor1"."IssuedQty"),Sum( Convert(numeric(20,3),("wor1"."BaseQty""owor"."CmpltQty"))) 'Consumed Qty', Sum(Convert(numeric(20,3),("wor1"."IssuedQty" - ("wor1"."BaseQty""owor"."CmpltQty")))) 'Pending Qty', Sum("wor1"."U_UBundletoKg"), "oitm"."invntryuom", "ocrd"."cardname", "T0.Warehouse" FROM "OWOR" INNER JOIN "WOR1" ON "owor".DocEntry = "wor1"."DocEntry" INNER JOIN "OITM" T2 ON "wor1"."ItemCode" = "oitm"."ItemCode" inner join "ocrd" on "owor"."U_subcontractor" = "ocrd"."cardcode" ...

Thanks & best regards


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question