Report on Payments From Customers on ABAP query

This question is answered

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

Correct Answer

October 01, 2008 at 07:33 AM

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

0 Likes 0 View this answer in context