Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Customer Tables

Go to solution
Former Member

‎2007 May 03 9:50 PM

0 Likes
753

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2007 May 04 1:22 PM

0 Likes
690

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..

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

Reply
2 REPLIES 2
Read only

Go to solution
Former Member

‎2007 May 04 1:22 PM

0 Likes
691

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..

Read only

Go to solution
alison_lloyd
Active Participant

‎2007 May 04 1:35 PM

0 Likes
690

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