SQVI Report Question
I'm trying to write a report using tcode SQVI. The report would include Customer, sales order, delivery and Invoice.
For which I'm using KAN1 -- VBAK -- VBAP -- LIPS -- VBRP -- VBRK. All the joins work well and I'm getting the desired result but how do I get results of sales order which haven't been delivered and invoice yet?
At the moment I'm getting results for sales orders which have been completed but not open sales order.
Rosh A replied
Call the transaction SQVI --> Create quick view --> Select Data source as 'Table' and input the value 'VBAKUK' in the field 'table/database view' --> select layout basis/layout ---> In the next screen select the fields VBAKUK-VBELN,VBAKUK-ERDAT-VBAKUK-LFGSK & VBAKUK-FKSTK under the data source hierarchy and tick the appropriate check boxes such as 'list fields' & 'selection fields' --> Click execute --> You'll be directed to the report, here select the overall delivery status as 'A'(Not yet processed) for getting the sale documents which have not been delivered and select the billing status as 'A" (Not yet processed) for getting the sale documents which have not been invoiced.