Table/BAPI to get the customer overdueand balance amounts

[Former Member]

Hi Gurus,,

Can some one help me in finding the Table/BAPI to get the customer overdueand balance amounts in a period of time.

Thanks And Regards,

Abhi....

[Former Member]

Answered...

[iklovski]

Hello,

The balances for customer are stored in KNC1 table. The separate uncleared documents are stored in BSID table.

Relevant BAPIs:

BAPI_AR_ACC_GETCURRENTBALANCE

BAPI_AR_ACC_GETKEYDATEBALANCE

BAPI_AR_ACC_GETOPENITEMS

BAPI_AR_ACC_GETPERIODBALANCES

BAPI_AR_ACC_GETBALANCEDITEMS

Regards,

Eli

[Former Member]

Hi Eli,

Thanks for the answer, but my problem is actually related to Credit Control Management, where we define the Credit Limits and Risk Catagories.

Again, I wanted to know the table/BAPI where I can get the information about the Overdue Amonut (the pending amount that was supposed to be paid by Customer in a fixed period) and the total amount : Outstanding Amount

Thanks In Advance..

Abhi...

[iklovski]

Hi,

You can try operating this:

BAPI_CR_ACC_GETOLDESTOPENITEM

BAPI_CREDIT_ACCOUNT_GET_STATUS

BAPI_CR_ACC_GETHIGHESTDUNNINGL

Regards,

Eli

[Former Member]

Thanks......Eli....

Do you have any idea about the Credit terms for a Customer..Where can we find them...............?????

[iklovski]

Try this: BAPI_CR_ACC_GETDETAIL

[Former Member]

Thanks.....

Eli,,, I cannot find the value(field) credit terms in the BAPI.......Can you tell me the field i.e export paramater/field.

[Former Member]

Thanks Eli,,,,,,,

It really helped me out....

Regards,

Abhi....

[tisha_dharod]

Hi Digvijay

Please let me know how did you fetch following details

1. Credit Control data:
   1. Credit – Risk class
   2. Credit Limit
   3. Utilization
2. Financial Situation:
   1. Overdue Amount (Total Value of invoices overdue)
   2. Outstanding Amount (Total value of Invoices which are outstanding (not paid)which may be overdue or may not be overdue)
   3. Latest Payment Received date
   4. Days in Arrears

Thanks

Tisha