Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member replied

Hi

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

Max

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question