Customer Tables

[Former Member]

Dear Gurus,

I have to give the table and field names that are required for a customer report, i could get some of them... the rest i am not sure where to look for, the details of the same are given below:

Table Name Field 1

Customer ID KNA1 KUNNR

Customer Name KNA1 NAME

Credit Limit

Terms KNB1 ZTERM

Avg Days Outstanding

Date Established KNA1 ERDAT

Date of Last Sale

High A/R

Date High Balance

A/R Balance

Current RF02L OBLIG

30 Day Balance BSID BUDAT

60 Day Balance BSID BUDAT

90 Day Balance BSID BUDAT

120 Day Balance BSID BUDAT

Please guide me through the tables & fields and also let me know if the above choices are correct.

Thanks for your help and support.

regards,

Raj

[Former Member]

Hey Raj,

I got some of the fields..

Customer ID KNA1-KUNNR

<b>Customer Name KNA1-NAME1</b>

<b>Credit Limit KNKKF1-KLIMK</b>

Terms KNB1-ZTERM

<b>Avg Days Outstanding RF02L-DSOIN</b>

Date Established KNA1-ERDAT

Date of Last Sale

<b>High A/R KNKKF1-KUNNRM</b>

<b>Date High Balance RF035-H06DA</b>

A/R Balance

<b>Current RF02L-DSOSA</b>

30 Day Balance BSID-BUDAT

60 Day Balance BSID-BUDAT

90 Day Balance BSID-BUDAT

120 Day Balance BSID-BUDAT

Regards,

Jayaram..

[Former Member]

Hey Raj,

I got some of the fields..

Customer ID KNA1-KUNNR

<b>Customer Name KNA1-NAME1</b>

<b>Credit Limit KNKKF1-KLIMK</b>

Terms KNB1-ZTERM

<b>Avg Days Outstanding RF02L-DSOIN</b>

Date Established KNA1-ERDAT

Date of Last Sale

<b>High A/R KNKKF1-KUNNRM</b>

<b>Date High Balance RF035-H06DA</b>

A/R Balance

<b>Current RF02L-DSOSA</b>

30 Day Balance BSID-BUDAT

60 Day Balance BSID-BUDAT

90 Day Balance BSID-BUDAT

120 Day Balance BSID-BUDAT

Regards,

Jayaram..

[alison_lloyd]

For the following:

30 Day Balance BSID BUDAT

60 Day Balance BSID BUDAT

90 Day Balance BSID BUDAT

120 Day Balance BSID BUDAT

I think it is more likely they require sum of BSID-WRBTR where BSID-BUDAT gt 30 days etc or mabe related to the payment term date.

A/R balance is probably the sum of all these.

Date of last sale - BKPF-BUDAT for the last document for the customer i.e retrieve all the documants for the customer and read the greatest BUDAT