BSID Table

[Former Member]

What is special in the working of BSID, BSAD tables.

Is there a different way to access them..Please explain in detail

Thanks.

[Former Member]

Hi

BSID and BSAD are the table with the open and cleared items of customer account. Here you can find the data of BSEG and BKPF together.

So the main tables of FI document are BKPF and BSEG, if BSEG-KOART (account type) is D, it means it's customer item, so you can find that item in BSID or BSAD, where:

BSID/BSAD = BKPF + BSEG.

In this way it can find the customer items faster than reading directly BKPF and BSEG, because there KUNNR (customer) is not key fields.

So BSID/BSAD are like secondary index tables, to improve the performance when it needs to pick customer data.

They are transparent tables so you should use the main key fields: company and customer code.

Max

[Former Member]

Hi,

BSID (Customers)and BSAD (Cleared Items) which are secondary index tables.They are transparent tables so you should use the key fields like company and customer code.

Regards,

Kumar

[Former Member]

It says <b>Secondary Index</b> for customers..so is there anything added to it..like may be in accessing etc.