In SAP, each financial document consists of two segments i.e.

  1. Document Header
  2. Line Items

When a financial accounting document is posted in SAP, the values are updated into two tables i.e.

  1. Document Header data in BKPF table
  2. Line Items data in BSEG table.

BKPF & BSEG tables are transparent tables. It has 1: N relationship, where one BKPF entry has multiple BSEG line items.

What is BKPF Table in SAP

The BKPF table is an accounting document header that stores the header information of a financial accounting document. The document header consists the information like

  • Company Code (BUKRS)
  • Accounting document number (BELNR)
  • Fiscal year (GJAHR)
  • Document type (BLART)
  • Document date (BLDAT)
  • posting date (BUDAT)
  • Currency key (WAERS)
  • Document header text (BKTXT)
  • Exchange rate (KURSF)

As per the below image, the bkpf table consists of more than 190 fields.

BKPF Table in SAP

 

What is BSEG Table in SAP

The BSEG table is an accounting document segment that stores the financial document line items. Each financial document has multiple line items and stored in the BSEG table.

The important key fields in BSEG Table are:

  • Document Number (BELNR)
  • Company Code (BUKRS)
  • Fiscal Year (GJAHR)
  • Number of Line Item (BUZEI)
  • Identification of line item (BUZID)
  • Posting Key (BSCHL)
  • Account type (KOART)
  • Debit/Credit Indicator (UMSKS)
  • Business Area (GSBER)
  • Amount in local currency (DMBTR)
  • Amount in document currency (WRBTR)
  • Value Date (VALUT)

BSEG Table in SAP

Relationship between BKPF & BSEG Table

The BKPF & BSEG Tables are linked through the common key fields of Company code (BUKRS), Fiscal Year (GJAHR), and Document number (BELNR). Each financial account document consists of a single document header (BKPF) and multiple line items (BSEG).