SQVI - Comprehensive Report on Sales Document Status and Requisition Cover

[former_member1289385]

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!

[TammyPowlas]

Transaction VA06 is the Sales Order Monitor and shows the status and just about everything you are looking for - have you tried this transaction?

[former_member1289385]

Hi Tammy,

thank you for your answer!

VA06 was really my first stop before I started messing around with SQVI. For some reason, I don't get any results with "Missing Order Ack. for ind. Procurement", "Goods Receipt behind Schedule" and created 01/01/19 - 10/28/19. It doesn't make any sense but could be the same issue as EBAN-VBELN being empty...

I'm slightly bedazzled now as I have no means to find out what Sales Docs have missing replenishment elements.

[TammyPowlas]

Hi - we don't use those elements; could it possibly be an authorization issue with VA06?