Hello all,
I am building a report that should display the following feilds:
Item #, Item Desc, Sales Rep name, Qty, Total Sale, Unit price, Price Level
SELECT T0.[ItemCode], T0.[ItemName], T1.[ItmsGrpNam] , (SELECT T2.[Price] FROM ITM1 T2 WHERE T2.[ItemCode] = T0.[ItemCode] and T2.[PriceList] ='3') AS 'Price C' FROM OITM T0 INNER JOIN OITB T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] INNER JOIN ITM1 T2 ON T0.[ItemCode] = T2.[ItemCode]
I need the Sales Rep name, Qty Total Sale and Unit Price Sold fields to be displayed.
I understand that Sales rep Name will come from the OLSP table.
When I try to add OSLP. SlpName, SAP crashes unexpectedly.