Skip to Content
Sep 16, 2020 at 10:09 PM

Analysis report query

55 Views Last edit Sep 17, 2020 at 08:17 AM 2 rev

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.