Customer Balances Tables

[former_member626593]

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

[former_member365886 · Accepted solution]

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