topic Re: BSID Table in Application Development and Automation Discussions

BSID Table

Former Member — Mon, 27 Nov 2006 13:47:42 GMT

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

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

Thanks.

Re: BSID Table

Former Member — Mon, 27 Nov 2006 13:52:28 GMT

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

Re: BSID Table

Former Member — Mon, 27 Nov 2006 13:57:30 GMT

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

Re: BSID Table

Former Member — Mon, 27 Nov 2006 13:58:11 GMT

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