Report on Payments From Customers on ABAP query

[Former Member]

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

[Former Member · Accepted solution]

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

[Jelena]

BSEG is useless for queries because it can't be used in JOINs. The tables for customer documents are BSID and BSAD. You can create a query by joining them with BKPF (header-level) table or, say, KNA1 table. You don't actually have to use any fields from other tables, but this will allow you to have both BSID and BSAD in the query.

P.S. This is not an SD question.

[Former Member]

Hi,

T. Code: FBL5N

You take a reference for new development.

Best Regards,

Amit

[Former Member]

Dear Amit, Surely I am taking the references from FBL5n.

But is it possible with ABAP query.

regards,

A S