BSIK table — Vendor Open Items Index Table
BSIK holds one row per vendor accounting document line item that has been posted to a reconciliation account but not yet cleared. It is a secondary index built at the same key as BSEG, restricted to open vendor items. Once an item is cleared it disappears from BSIK and shows up instead in BSAK.
BSIK is the classic open-items index for accounts payable, used constantly for aging, payment proposal checks, and 'why is this invoice not paid' investigations. This page covers its key fields, how it joins to BSEG and BKPF, and the recurring mistakes consultants make when they treat it as the single source of truth for vendor balances.
Published 15 Sept 2026· 1,131 words
What it stores
Each row in BSIK represents one line item of a financial accounting document that was posted against a vendor reconciliation account and has not yet been cleared. It is not an independent ledger; it is a redundant, synchronously maintained copy of the relevant BSEG rows, filtered to open items only, kept so that open-item reporting and the payment program do not have to scan the full line-item table BSEG with an aggregate condition every time. The moment an item is cleared, whether by payment, credit memo offset, or manual clearing, SAP moves the corresponding row out of BSIK and writes it into BSAK instead. A vendor with heavy activity can have thousands of historical cleared items in BSAK while BSIK stays small and reflects only current exposure.
Key fields
- MANDT - client, always part of the key
- BUKRS - company code, mandatory selection field
- LIFNR - vendor account number
- GJAHR - fiscal year of the posting
- BELNR - accounting document number
- BUZEI - line item number within the document
- BUDAT - posting date
- BLDAT - document date
- SHKZG - debit/credit indicator, drives sign of amounts
- DMBTR - amount in local (company code) currency
- WRBTR - amount in document currency
- ZFBDT, ZBD1T, ZBD2T, ZBD3T - baseline date and payment terms used to compute due date and cash discount
- ZLSPR - payment block indicator
- ZLSCH - payment method
- UMSKZ - special G/L indicator (down payment, guarantee, bill of exchange)
- ZUONR - assignment field, used for clearing rules and sorting
- AUGDT, AUGBL - clearing date and clearing document, blank for genuinely open items
How it joins the data model
- BSIK-BUKRS/BELNR/GJAHR/BUZEI = BSEG-BUKRS/BELNR/GJAHR/BUZEI (BSIK is the open-item slice of BSEG at identical key)
- BSIK-BUKRS/BELNR/GJAHR = BKPF-BUKRS/BELNR/GJAHR (document header: posting date, document type, entry date, user)
- BSIK-LIFNR/BUKRS = LFC1-LIFNR/BUKRS (vendor transaction figures, used to reconcile totals against open item sums)
- BSIK-BUKRS = T001-BUKRS (company code master, currency and chart of accounts)
- BSIK and BSAK share the same key layout and are mutually exclusive: an item exists in exactly one of the two at any point in time
How to read it safely
MANDT is always implicit and rarely needs to be specified manually in a client-bound session. Always restrict on BUKRS and LIFNR together; either one alone on a large productive vendor ledger produces a slow, unselective read. GJAHR narrows further when a fiscal year is known, but be careful: an invoice posted in one year can still be open in a later year, so do not use GJAHR to prove an item does not exist unless the search also covers adjacent years. For aging or due-date work, select on BUDAT or compute due date from ZFBDT plus the payment terms rather than filtering directly on a derived date that is not stored. Avoid selecting on WRBTR or DMBTR ranges as a primary filter; they are not selective and will scan.
How to prove it in the data
Symptom: a vendor invoice is not being picked up by the payment run. Select BSIK where BUKRS equals the company code and LIFNR equals the vendor, no other restriction. Check ZLSPR on the returned row for a payment block, check ZLSCH for a payment method that does not match the run's parameters, and check ZFBDT together with the payment terms to see whether the calculated due date actually falls inside the payment run's date window. If the item is absent from BSIK entirely, check BSAK next; it may already be cleared.
ECC vs S/4HANA
In S/4HANA the line-item detail moves into the universal journal table ACDOCA, and BSIK is no longer populated by new postings. It is retained as a compatibility view that reads open vendor items out of the universal journal on the fly, so existing reports, custom ABAP, and BAPIs that select from BSIK by name generally continue to work without code changes. Consultants relying on direct table dumps or database-level tools should be aware the underlying storage and performance characteristics are different from the classic ECC table, even though the field layout looks the same.
Common pitfalls
- Concluding an item does not exist because it is not in BSIK: it may simply be cleared and sitting in BSAK. Any 'where is this invoice' investigation has to check both tables, or use BSEG directly if the clearing status is unknown.
- Forgetting UMSKZ when reading down payments, guarantees, or bills of exchange. These special G/L items sit in BSIK alongside normal invoices; an aging report that ignores UMSKZ will mix them into the regular open balance and overstate or misstate exposure.
- Mixing up DMBTR and WRBTR. Aging and balance comparisons are normally done in local currency (DMBTR); using WRBTR for a vendor with multiple document currencies produces numbers that cannot be summed meaningfully.
- Assuming BSIK is perfectly real-time and always in step with BSEG. It is maintained synchronously by standard posting logic, but direct table manipulation, faulty interfaces, or data conversion during migration can leave BSIK and BSEG out of sync; when totals do not reconcile, compare against BSEG directly rather than trusting BSIK alone.
- Reading BSIK without BUKRS and LIFNR restrictions on a large system. It behaves like any other transparent table under a full scan and can bring a productive system to a crawl.
- Ignoring sign convention on SHKZG in custom reports. Credit memos and debit memos invert the natural sign of DMBTR/WRBTR; a report that sums amounts without applying SHKZG logic will produce a balance that looks plausible but is wrong.
Whose problem this is
Questions about whether a specific vendor item is open, blocked, or due belong to accounts payable accounting, using standard vendor line item display rather than raw table access. Structural questions, custom reports built directly against BSIK, and any apparent mismatch between BSIK and BSEG belong to the FI technical or ABAP development team supporting accounts payable.
Related SAP objects
Reviewed pages this object connects to in the ERPClimb knowledge graph.
Source: ERPClimb — https://erpclimb.com/sap-tables/bsikERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.