Customer Age report - S_ALR_87012178

[Former Member]

Hi sap gurus,

Could you please explain, where (which tables) and how the S_ALR_87012178 standard Transaction pulls the data for giving report.

Let me know

I will assign the points

venu

[Former Member]

The key to the report is the open item date as you can run it as of today, last month or next month.

Whilst it does use the tables that have been mentioned it creates its own structures to work out if a specific AR item was open and how overdue it was.

[Former Member]

hi Venu,

The tables for the Tcode are

TABLES:

bhdgd,

t001,

t001s,

*t001s,

t074t,

t074u,

tbsl,

tbslt,

tcurx,

adrs,

rfpdo,

rfpdo1,

rfpdo3,

rfsdo,

faede.

b0sg,

kna1, "

• KNKA,

knb1, "

knb4,

knb5,

KNKK,

knc1,

knc3

bsid,

BKPF,

BSEG,

Regards

Ranjit

[JozsefSzikszai]

hi Venu,

the customer open items are coming from BSID, customer master data from different KN** tables (KNA1, KNB1 and some more).

let me know, if you need more details

ec