SAP BSEG
BSEG is a key SAP table in FI (Finance). It stores accounting document line items, the individual debit/credit lines of financial documents. It is a large, central FI table (a cluster table classically).
BSEG holds financial line detail.
- The key is BUKRS + BELNR + GJAHR + BUZEI.
- BUKRS/BELNR/GJAHR, the document (key).
- BUZEI, line item number (key).
- Watch out: BSEG is a cluster table, so it cannot be joined or read the way a transparent table can.
What it stores
It stores accounting document line items, the individual debit/credit lines of financial documents. It is a large, central FI table (a cluster table classically).
Key fields
- BUKRS/BELNR/GJAHR, the document (key).
- BUZEI, line item number (key).
- HKONT, G/L account; SHKZG, debit/credit.
- DMBTR, amount in local currency.
Keys and relationships
The key is BUKRS + BELNR + GJAHR + BUZEI. Each row is one posting line. Classically a cluster table (not freely queryable by non-key fields); in S/4HANA, line items live in ACDOCA and BSEG is a compatibility view.
Working with it
BSEG holds financial line detail. In S/4HANA use ACDOCA and CDS views for reporting; querying BSEG by non-key fields is slow classically because of its cluster structure. View its structure in SE11 and its data (with authorization) in SE16N.
Common pitfalls
- Reading tables directly instead of using CDS/reports where appropriate.
- Ignoring header/item relationships.
- Performance: querying large tables without indexed selection.