Report on Payments From Customers on ABAP query
Dear SAP Experts!
A report is required to be made fro all the Payments of the Customers Document Type DZ
Customer Number
Sales District
County code
Payment amount: WRBTR.
As we Know there are 2 tables for the Customers IN BSEG
1. BSIS
2. BSID
Condition being : Debit./Credit Ind. : H
Posting Keys : 15 & 19.
Is it possible to create a query report in one feild PAYMENTS(User-defiend say in extras) to dispaly.
WRBRT of both BSIS & BSAD.
Please guide me with the logic.
Thanks & regards,
A S
chandra sekhar replied
Hi,
Use BSAD table. It has all the fields except sales district.
Standard reports
S_ALR_87012198 : click on dynamic selection, In documents section we have document type field enter DZ.
S_ALR_87012160 : select the only customer line items, in dynamic selection enter document type DZ.
Regards,
Chandra