ECC report for sales order status from order entry to Invoice (OTC rpt)

[Former Member]

Dear All.

Looking to see if there's a standard report or transaction that we can use to review sales order line item status.

VA05 provides a good view from sales, and VL06O provides a good view from LE, and VF05 provides a good view from billing.

But there is there something that would list sales orders and show related quantity, open, delivered, billed all in one report?

Many thanks!

[Shiva_Ram]

If you need all in one, like even billed quantity, then you need to develop your own Z-report using different tables, VBAK,VBAP, LIKP,LIPS, VBRK,VBRP, VBUK and VBUP.

Regards,

[Former Member]

Thank you Shiva.

That's what we were thinking as well. Just wanted to make sure we didn't miss something in case SAP provided a template or customizable program for this.

Thanks

[measum_kumail2]

Like Shive said, there is no standard report which matches exactly your requirements. howevver for z-report, I will recommend you using sqvi or sap query instead of abap.

regards.