Skip to Content

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

Need Query Help

Hi experts,

I need user query for Warehouse wise customer billing report like AR invoices. Please do needful.

Tags:
replied

Hi,

Try with this query,

SELECT T0.[DocNum], T0.[DocType], T0.[DocStatus], T0.[DocDate], T0.[DocDueDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[WhsCode], T2.[WhsName], T0.[DocTotal] FROM OINV T0  INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OWHS T2 ON T1.[WhsCode] = T2.[WhsCode]

where T1.[WhsCode] = [%0]

Regards,

Bhushan Verma

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