Customer Tables/ Fields

[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

30 Day Balance

60 Day Balance

90 Day Balance

120 Day Balance

If you could guide me through the tables & fields that i have to look for it would be great.

Thanks for your help and support.

regards,

Raj

[RichHeilman]

For credit limit, check table KNKK field KLIMK, I found this out by using transactoin FD32 and checking the "Status" checkbox. You may find others on this screen as well.

Regards,

Rich Heilman

[Former Member]

Hi

The following fields are to be known from the customer Account Receivables tables BSID and BSAD .

check them

And you have to calculate the Due date for each document and based on ZBD1T field that the time days 30,60,90 etc have to be calculated.

Avg Days Outstanding

Date of Last Sale

High A/R

Date High Balance

A/R Balance

Current

30 Day Balance

60 Day Balance

90 Day Balance

120 Day Balance

reward if useful

regards

Anji

[Former Member]

Check the above link for the answer