topic Customer Tables in Application Development and Automation Discussions

Customer Tables

Former Member — Thu, 03 May 2007 20:50:17 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 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

Re: Customer Tables

Former Member — Fri, 04 May 2007 12:22:56 GMT

Hey Raj,

I got some of the fields..

Customer ID KNA1-KUNNR

Customer Name KNA1-NAME1

Credit Limit KNKKF1-KLIMK

Terms KNB1-ZTERM

Avg Days Outstanding RF02L-DSOIN

Date Established KNA1-ERDAT

Date of Last Sale

High A/R KNKKF1-KUNNRM

Date High Balance RF035-H06DA

A/R Balance

Current RF02L-DSOSA

30 Day Balance BSID-BUDAT

60 Day Balance BSID-BUDAT

90 Day Balance BSID-BUDAT

120 Day Balance BSID-BUDAT

Regards,

Jayaram..

Re: Customer Tables

alison_lloyd — Fri, 04 May 2007 12:35:51 GMT

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