Confusion regarding Cluster table - BSEG & its index tables
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?
Yes, it's just a little SAP trick.
Every time an amount (so a document) is posted for vendor or customer, the same amount has to be posted for the reconciliation g/l (u can find it in the master data of vendor and customer, and it can't post a document for it directly).
But the reconciliation g/l doesn't belong to the document, so it's not stored in BSEG, but it needs to manage it in g/L account, so it's stored in BSIS/BSAS table.
Try to see an invoice for a vendor:
in BSEG table u can see all items u can see by trx FB03
The get the reconciliation g/l from vendor item, u can find a record in BSIS/BSAS table for the invoice, this record is not in BSEG, the field BSIS/BSAS-BUZEI has the BUZEI of vendor item.
The reconciliation g/l is used to manage/see all amount posted for vendor/customr in single account (g/l account), else it needs to see the amount in every single vendor/customer account.
So if it needs to know the total of invoices posted for a certain period, it's easier to see that data in reconciliation account