Skip to Content
avatar image
Former Member

Customer Balances Tables

hello

i am looking for table which store customer balances and their overdue amounts. i want to write query that displays the Total balance, Current Balance, Overdue Amount. or a FM that extracts the data. However i have 100000 customers and i fear that a FM might to be ideal.

Thomas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 06, 2017 at 04:04 AM

    Hi Thomas,

    Please find below some relevant tables that might be helpful for the query.

    BSID -Accounting: Secondary Index for Customers (Open Items)

    BSAD - Accounting: Secondary Index for Customers (Cleared Items)

    BSIK -Accounting: Secondary Index for Vendors (Open Items)

    BSAK -Accounting: Secondary Index for Vendors (Cleared Items)

    BSIS -Accounting: Secondary Index for G/L Accounts (Open Items)

    BSAS -Accounting: Secondary Index for G/L Accounts (Cleared Item)

    Regards,

    Avik

    Add comment
    10|10000 characters needed characters exceeded