Skip to Content

Confusion regarding Cluster table - BSEG & its index tables

Hello Friends,

I was having a look at this post: [How to get all accounts linked to a document?;

In this Max says:

When a account document is posted for a vendor or customer, the system can create an item for the reconciliation g/l account, this particular item is not stored in BSEG table but in BSIK/BSAK or BSID/BSAD tables only

Without going into functional aspect, technically i was under the impression that BSEG is the superset of all the A/C'ing docs & the index tables BSIK/BSAK & BSID/BSAD are subsets.

Can someone clarify this confusion?

BR,

Suhas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 25, 2009 at 09:45 AM

    Hi

    BKPF and BSEG table are the tables with the data of account documents:

    - BKPF header data

    - BSEG item data

    To manage the Vendor, Customer and G/l account the data of tables above are replaced in secondary index tables.

    BSEG table has the field KOART Account Type, the main values are:

    D	Customers
    K	Vendors
    S	G/L accounts

    So the data of BKPF and BSEG can be found in:

    KOART = D

    BSID - Open Item

    BSAD - Cleared Item

    KOART = K

    BSIK - Open Item

    BSAK - Cleared Item

    KOART = S

    BSIS - Open Item

    BSAS - Cleared Item

    It mean the main fields of BKPF/BSEG table are in index tables too

    If u see how the table BSEG is and how the index tables are, u can note the main difference is the field keys:

    the key fields of BSEG are the keys for account document, so BUKRS, BELNR and GJAHR

    the main key fields of index table are BUKRS and:

    - KUNNR (Customer code) for BSID/BSAD

    - LIFNR (Vendor code) for BSIK/BSAK

    - HKONT (G/l account code) for BSIS/BSAS

    So if you need to get the data of account documents starting with the document, it's better to read BKPF/BSEG table, if you need to get the data knowing the vendor or customer or g/l it's better to use the index table.

    Max

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Max,

      Thanks for sharing this info. It was definitely a nice-to-know thing.

      Currently i am looking into the sandbox(which is a prod replica) but dont find any recon a/c items. But may be next time i encounter this i will make a point to recheck.

      Thanks again.

      Cheers,

      Suhas

  • Sep 25, 2009 at 09:37 AM

    This is also my impression. Technically, all index table entries are created via move-corresponding from BKPF and BSEG values inside function module POST_DOCUMENT, as far as I understand it. So how could there be an index table entry without a corresponding BSEG entry? Let's stick to "normal" postings (BSTAT = space) for the time being.

    Thomas

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Thomas Zloch

      Thomas - remember that BSIS is for open items. I'm pretty sure that arciving only removes cleared items (and I think items for accounts that are not open item managed).

      Rob