Reply from hagen on Apr 16 at 1:55 AM Hello Typewriter,
this advice was helpful. Unfortunately it is more or less the way I did it
already. The problem is that you have to read the document flow and if you
have a great number of sales documents you gonna face performance problems.
I shall investigate the option you mentioned in your further mail (VA05N)
Thanks a lot.
Regards Hagen
>
> -------- Original-Nachricht --------
> Datum: Fri, 13 Apr 2012 05:18:33 -0400
| | | ---------------Original Message---------------
From: Typewriter
Sent: Friday, April 13, 2012 5:15 AM
Subject: 'Invoice Status' in SAP Query Reporting On Tables VBAK/ VBAP
Hi Hagen,
Is your process: Sales order > Delivery > Billing?
If yes, then I would achieve the above requirement by following the below –
1. Check all the delivery documents, which have been selected (say selection criterion is date range i.e. From and to date, in your selection screen).
2.
A. In each delivery document, at header level, check field "Bill. Doc" is not equal to C (completely processed) (VBUK-FKSTK) then go to VBFA, give delivery document number in VBELN (Follow on doc). and fetch VBELV (Preceding doc), this preceding document is the sales order number. Populate VBELV in the report.
B. In each delivery document, at header level, check field "Bill. Doc" is not equal to C (completely processed) (VBUK-FKSTK) then exit
Thus in the above logic going in to VBAK and VBAP is not required.
Furthermore, the status of sales order is complete when a delivery is created. The status of the sales order does not get impacted with the creation of billing document in the flow S.o > Dlv > Bill
If the process is S.O> Bill, then follow the above, in place of delivery have sales order |
| Reply to this email to post your response. __.____._ |   _.____.__ |
No comments:
Post a Comment