Basicallt therez a report for sd module in my company where they requiire to compare the sales by the customer with the payment that they have done .Which tables will I need to add in the sap query to track the payment for the customer.
Please use the following SAP standard table for developing the Custom report. You can easily frame logic depending upon the requirement for example --> you can reproduce all the un-paid billing document with respect to a Sold-To-Party ID (Fetch all the uncleared item from BSID) for perod range.
BSID (Standard table containing uncleared item)
BSAD (Standard table containing cleared item)
BSEG (Table of Accounting docs)
Also don't forget to use "SQVI" technique for table joining so that performance of the Custom report would be better.
Pls check the entries in BSAD table. When the invoices are paid by customers, the relevant records are moved from BSID (Open items) to BSAD (Cleared items)
BKPF, BSEG and BSAD will help to link accounting to invoices. Hope this helps you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.