Skip to Content
0
Oct 27, 2019 at 10:12 AM

SQVI - Comprehensive Report on Sales Document Status and Requisition Cover

120 Views

I've been trying for a while now to create a report that shows me the overall status of sales orders.

So far, I have produced a great report that shows all schedule lines that are "open", whether it's confirmed, unconfirmed, partially shipped or not. Pretty much everything in the pipeline. I joined VBAK, VBUK, VBAP, VBUP, MARA, and VBEP. Postprocessing in Excel delivers a comprehensive overview of what's open and when values are scheduled to turn into revenue.

As a second step, I would like to create a report that shows me all requesitions (BANF) and the respective document that covers that requisition (PO, shop order etc...). So, whenever there is a BANF that has not been converted into a PO / prod.order it would just show a blank cell. ->action needed.

Eventually, I would like to extend the "pipeline" report with this information, but separately will work for now.

I was able to get valid output by linking EBAN, EKKO, and EKPO. Unfortunately, the EBAN-VBELN was always empty.

Linking EBKN to only VBEP didn't work either. So I'm stuck...

Any input would be appreciated. Thank you!