Sales Summary Report - Should i go to BKPF table?
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.