topic Re: Customer Tables/ Fields in Application Development and Automation Discussions

Customer Tables/ Fields

Former Member — Tue, 01 May 2007 14:41:51 GMT

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

Re: Customer Tables/ Fields

RichHeilman — Tue, 01 May 2007 14:47:58 GMT

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

Re: Customer Tables/ Fields

Former Member — Tue, 01 May 2007 15:55:34 GMT

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

Re: Customer Tables/ Fields

Former Member — Wed, 09 May 2007 20:10:07 GMT

Check the above link for the answer