cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Summary Report - Should i go to BKPF table?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

You could get all the documents from the BKPF table created by ref procedure VBRK (billing docs)

former_member181995
Active Contributor
0 Kudos

>

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.

former_member183879
Active Contributor
0 Kudos

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.