Skip to Content
avatar image
Former Member

Table/BAPI to get the customer overdueand balance amounts

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 11, 2010 at 10:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Mar 12, 2010 at 12:31 PM

    Answered...

    Add comment
    10|10000 characters needed characters exceeded