on 09-19-2008 3:21 PM
Hi,
I am working on a sales summary report to get cost of sales, net sales and margin?
To pick all the billing documents within a date range should i go to BKPF table and get all the documents with document type = 'RX' (billing document type) and only for those documents find the relevant data. OR should i directly go to VBRK and VBRP and get all the billing documents even though they are not posted in accounting? Please let me know what is the normal procedure.
Thanks,
Maulik
You could get all the documents from the BKPF table created by ref procedure VBRK (billing docs)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>
OR should i directly go to VBRK and VBRP and get all the billing documents even though they are not posted in accounting? Please let me know what is the normal procedure.
>
> Thanks,
> Maulik
Since you said they are not posted to accounting than i think VBRK and VRP would be enough to meet your requirement.
Amit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If it is purely within SD, then just VBRK is enough.
But if you want to find otu the Receivables, Realised revenue for the given period of time, you have to use the following tables.
Use VBRK to find out the invoices created within the date range
Find out the Accounting document for them in BKPF.
To find out how many of them are paid , you have to go to the table BSAD
If you want to find out the receivables, you have to go to BSID.
Then by using proper joints, you can get your report.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.