Sales Invoice Query by "specific Items"

[larryenet]

Hello SAP Gurus,

I made a mistake in my last post and actually need this to pull information for Sales Invoice not Sales Order.

Please see query that needs to be updated to show Sales Invoice information:

SELECT T0.[DocNum],

     T0.[DocDate],

     T0.[CardName],

     T0.[NumAtCard],

     T1.[Quantity],

     T1.[ItemCode],

     T1.[Dscription],

     T1.[Price],

     T1.[Price]*T1.[Quantity] AS 'Total Price',

     T0.[DocTotal],

     T0.[GrosProfit]

FROM ORDR T0 

     INNER JOIN RDR1 T1

          ON T0.[DocEntry] = T1.[DocEntry]

WHERE T0.[DocDate] between [%0] and [%1] and 

     T1.[ItemCode] Like '%%COR%%'

Thank you.

Larry T.

[agustin_marcoscividanes · Accepted solution]

Hi

change OINV table instead ORDR table, and INV1 table instead RDR1.

Kind regards

Agustín Marcos Cividanes

[larryenet · Accepted solution]

Thank you very much!!