Skip to Content
0

Customer Balances Tables

May 29, 2017 at 01:14 PM

71

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Avik Mazumder Jul 06, 2017 at 04:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded