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!