difference in bsis, bsid, bsad tables, with respect to the storage of data

[Former Member]

hi experts,

can i difference in tables bsis, bsid, bsas. i mean what data is stored in which table, i am doing customer trial balance for business area, how can i fetch the data regarding.

[Former Member]

Hi Kiran,

A  for Cleared Items
I  for Open items

D  for Customers
K  for Vendors
S  for G/L Accounts

BSAD            Accounting: Secondary Index for Customers  "(Cleared Items)
BSAK            Accounting: Secondary Index for Vendors  "(Cleared Items)
BSAS            Accounting: Secondary Index for G/L Account  "(Cleared Items)


BSID            Accounting: Secondary Index for Customers
BSIK            Accounting: Secondary Index for Vendors
BSIS            Accounting: Secondary Index for G/L Accounnts

Best regards,

raam

[Former Member]

hi,

Plz refer to the link.

http://www.sapmaterial.com/bseg_alternative.html

regards

Sumit Agarwal

[Former Member]

hi kiran

according to SAP Naming standards

D for Customer

K for vendor

S for GL

so

BSID is table to maintain the open item for customer

BSAD is table to maintain the cleared item for customer

BSIK is table to maintain the open item for vendor

BSAK is table to maintain the cleared item for vendor

BSIS is table to maintain the open item for GL Account

BSAS is table to maintain the cleared item for GL Account

you can see all these records ( customer, vendor, GL) in one cluster table BSEG...

but don't use BSEG table in program its an performance issue

[Former Member]

solved