relation between BSIK,BSIK and BSEG

[Former Member]

Hi all ,

1. what we mean by the open items table (BSIK) and item table (BSAK).

2. What is the realtion between BSIK,BSAK with mm tables ..please give me the realtionship.

3. when we post in FB01 which are tables are updated

4. IF BSEG is the superset of all the tables then why we need this..as we have smaller tables

5. what is relation ship between bSIK,BSAK and BSEG

[Former Member]

Hi.

There are a series of related tables which are quite easy to understand if you look at the table name prefixes and suffixes... the BSI prefixed tables are open items and BSA are cleared items... and the suffix is like the account type field, KOART i.e. K = "Kreditor" (vendor), D - "Debtor" (customer) items, and S = GL (can't remember the German equivalent)... thus BSAD = Cleared "Debtor" (Customer) items.

Their purpose is to act as index tables for searches - BSEG is a cluster table that cannot have indexes created directly in the database so these other tables provide access paths to the BSEG data for specific searches. They contain a blend of data from BSEG (line data) and BKPF (header data). Each pair of tables is similar to each other, and has an extensive primary key to allow access from the relevant master record i.e. you would normally only go to BSIK if you know the company & vendor number, BSAS if you have the company & GL... you would not go to BSIK if you already had the BSEG entry because the data is already available to you in BSEG (plus BKPF).

BSIK - Contains Open line items of vendors

BSAK - for vendor cleared item

[Former Member]

BSEG table contains data which are also present in

(Customer Side)

BSAD-Clear Items

BSID-open Items

(G/L Accounts)

BSAS-Clear Items

BSIS-open Items

(Vendor Side Data)

BSAK - Clear Items

BSIK - Open Items

When a document is cleared, its clearing docuement number AUGBL is maintained in BSAK.

[Former Member]

BSIK: Vendor Open Items(Account Payables)

BSAK: Vendor Closed Items(Account Payables)

BSEG: Accounting Doc. Item(Cluster Table)

if you want to know more about why we are using BSEG table you can go to following link

http://blogs.ittoolbox.com/sap/db2/archives/select-from-bsegrfblg-performance-problem-14247

<REMOVED BY MODERATOR>

thx

twinkal

Edited by: Alvaro Tejada Galindo on Jun 12, 2008 7:09 PM

[Former Member]

hi

use this link it will solve ur query

http://www.erpgenie.com/abap/tables_fi.htm

http://www.sap-img.com/financial/important-tables-in-sap-fi.htm

Cheers

Snehi Chouhan

Edited by: snehi chouhan on Jun 12, 2008 11:17 AM