Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table BKPF

Accounting Document Header

BKPF (Accounting Document Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BKPF to other SAP tables.

BKPF stores the header lines for accounting documents. Accounting documents make up the financials of your organisation. Line items are stored in table BSEG. The link between BSEG and BKPF is made on fields MANDT, BUKRS, GJAHR, BELNR. The same document number can be used in different company codes. The same document number can also be used multiple times within the same company code in different years.

BKPF table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

T000

CLNT

BUKRS

Company Code

BUKRS

T001

CHAR

BELNR

Accounting Document Number

BELNR_D

CHAR

GJAHR

Fiscal Year

GJAHR

NUMC

BLART

Document Type

BLART

T003

CHAR

BLDAT

Document Date in Document

BLDAT

DATS

BUDAT

Posting Date in the Document

BUDAT

DATS

MONAT

Fiscal Period

MONAT

NUMC

CPUDT

Day On Which Accounting Document Was Entered

CPUDT

DATS

CPUTM

Time of Entry

CPUTM

TIMS

AEDAT

Date of the Last Document Change by Transaction

AEDAT_BKPF

DATS

UPDDT

Date of the Last Document Update

UPDDT

DATS

WWERT

Translation Date

WWERT_D

DATS

USNAM

User name

USNAM

CHAR

TCODE

Transaction Code

TCODE

CHAR

BVORG

Number of Cross-Company Code Posting Transaction

BVORG

CHAR

XBLNR

Reference Document Number

XBLNR1

CHAR

DBBLG

Recurring Entry Document Number

DBBLG

CHAR

STBLG

Reverse Document Number

STBLG

CHAR

STJAH

Reverse document fiscal year

STJAH

NUMC

BKTXT

Document Header Text

BKTXT

CHAR

WAERS

Currency Key

WAERS

TCURC

CUKY

KURSF

Exchange rate

KURSF

DEC

KZWRS

Currency Key for the Group Currency

KZWRS

TCURC

CUKY

KZKRS

Group Currency Exchange Rate

KZKRS

DEC

BSTAT

Document Status

BSTAT_D

CHAR

Value	Description
NULL	Normal document
A	Clearing Document
B	Reset clearing document
D	Recurring entry document
L	Posting Not in Leading Ledger
M	Sample document
S	Noted items
V	Parked document
W	Parked document with change of document ID
Z	Parked document which was deleted
C	Balance Carryforward Line Items

XNETB

Indicator: Document posted net ?

XNETB

CHAR

Value	Description
X	Yes
NULL	No

FRATH

Unplanned delivery costs

FRATH

CURR

XRUEB

Indicator: Document is posted to a previous period

XRUEB

CHAR

Value	Description
X	Yes
NULL	No

GLVOR

Business Transaction

GLVOR

CHAR

GRPID

Batch Input Session Name

GRPID_BKPF

CHAR

DOKID

Document Name in the Archive System

DOKID_BKPF

CHAR

ARCID

Extract ID Document Header

EXTID_BKPF

CHAR

IBLAR

Internal Document Type for Document Control

IBLAR

CHAR

AWTYP

Reference Transaction

AWTYP

CHAR

AWKEY

Reference Key

AWKEY

CHAR

FIKRS

Financial Management Area

FIKRS

CHAR

HWAER

Local Currency

HWAER

CUKY

HWAE2

Currency Key of Second Local Currency

HWAE2

CUKY

HWAE3

Currency Key of Third Local Currency

HWAE3

CUKY

KURS2

Exchange Rate for the Second Local Currency

KURS2

DEC

KURS3

Exchange Rate for the Third Local Currency

KURS3

DEC

BASW2

Source Currency for Currency Translation

CURSR

CHAR

Value	Description
1	Translation taking transaction currency as a basis
2	Translation taking first local currency as a basis

BASW3

Source Currency for Currency Translation

CURSR

CHAR

Value	Description
1	Translation taking transaction currency as a basis
2	Translation taking first local currency as a basis

UMRD2

Translation Date Type for Second Local Currency

UMRD2

CHAR

Value	Description
1	Document date
2	Posting date
3	Translation date

UMRD3

Translation Date Type for Third Local Currency

UMRD3

CHAR

Value	Description
1	Document date
2	Posting date
3	Translation date

XSTOV

Indicator: Document is flagged for reversal

XSTOV

CHAR

Value	Description
X	Yes
NULL	No

STODT

Planned Date for the Reverse Posting

STODT

DATS

XMWST

Calculate tax automatically

XMWST

CHAR

Value	Description
X	Yes
NULL	No

CURT2

Currency Type of Second Local Currency

CURT2

CHAR

Value	Description
00	Document currency
10	Company code currency
11	Company code currency, group valuation
12	Company code currency, profit center valuation
20	Controlling area currency
30	Group currency
31	Group currency, group valuation
32	Group currency, profit center valuation
40	Hard currency
50	Index-based currency
60	Global company currency
70	Controlling object currency
71	Controlling object currency, group valuation
72	Controlling object currency, profit center valuation
80	Ledger currency
81	Ledger currency, group valuation
82	Ledger currency, profit center valuation
90	Profit center invoice currency
92	Profit center accounting currency, profit center valuation
A0	Financial management area currency
B0	Operating concern currency
B2	Operating concern currency, profit center valuation
C0	Consolidation unit currency
C1	Consolidation unit currency, group valuation
C2	Consolidation unit currency, profit center valuation

CURT3

Currency Type of Third Local Currency

CURT3

CHAR

Value	Description
00	Document currency
10	Company code currency
11	Company code currency, group valuation
12	Company code currency, profit center valuation
20	Controlling area currency
30	Group currency
31	Group currency, group valuation
32	Group currency, profit center valuation
40	Hard currency
50	Index-based currency
60	Global company currency
70	Controlling object currency
71	Controlling object currency, group valuation
72	Controlling object currency, profit center valuation
80	Ledger currency
81	Ledger currency, group valuation
82	Ledger currency, profit center valuation
90	Profit center invoice currency
92	Profit center accounting currency, profit center valuation
A0	Financial management area currency
B0	Operating concern currency
B2	Operating concern currency, profit center valuation
C0	Consolidation unit currency
C1	Consolidation unit currency, group valuation
C2	Consolidation unit currency, profit center valuation

KUTY2

Exchange Rate Type

KURST

TCURV

CHAR

KUTY3

Exchange Rate Type

KURST

TCURV

CHAR

XSNET

G/L account amounts entered exclude tax

XSNET

CHAR

Value	Description
X	Yes
NULL	No

AUSBK

Source Company Code

AUSBK

T001

CHAR

XUSVR

Indicator: US taxes changed at detail level ?

XUSVR_BKPF

CHAR

Value	Description
X	Yes
NULL	No

DUEFL

Status of Data Transfer into Subsequent Release

DUEFL_BKPF

CHAR

Value	Description
NULL	Not transferred yet
A	Transfer taken place, document changed later
X	Transfer taken place, document unchanged

AWSYS

Logical System

LOGSYSTEM

CHAR

TXKRS

Exchange Rate for Taxes

TXKRS_BKPF

DEC

LOTKZ

Lot Number for Requests

PSO_LOTKZ

CHAR

XWVOF

Indicator: Customer bill of exchange payment before due date

XWVOF

CHAR

Value	Description
X	Yes
NULL	No

STGRD

Reason for Reversal

STGRD

T041C

CHAR

PPNAM

Name of User Who Parked this Document

PPNAM

CHAR

BRNCH

Branch Number

J_1ABRNCH

J_1BBRANCH

CHAR

NUMPG

Number of pages of invoice

J_1ANOPG

NUMC

ADISC

Indicator: entry represents a discount document

J_1ADISC

CHAR

Value	Description
X	Cash Discount Document Generated for Standard FI Item
S	Cash Discount Document Generated for SD Items

XREF1_HD

Reference Key 1 Internal for Document Header

XREF1_HD

CHAR

XREF2_HD

Reference Key 2 Internal for Document Header

XREF2_HD

CHAR

XREVERSAL

Specifies whether doc. is reversal doc. or reversed doc.

XREVERSAL

CHAR

Value	Description
2	Reversal Document
1	Reversed Document
NULL	Unknown (Old Document from Release <4.70/R/3 Enterprise)

REINDAT

Invoice Receipt Date

REINDAT

DATS

RLDNR

Ledger in General Ledger Accounting

FAGL_RLDNR

T882G

CHAR

LDGRP

Ledger Group

FAGL_LDGRP

FAGL_TLDGRP

CHAR

PROPMANO

Real Estate Management Mandate

RE_MANDAT

CHAR

XBLNR_ALT

Alternative Reference Number

XBLNR_ALT

CHAR

VATDATE

Tax Reporting Date

VATDATE

DATS

DOCCAT

Classification of an FI Document

DOCUMENT_CATEGORY

CHAR

Value	Description
INVREC	Invoice Receipt
INVRED	Invoice Reduction
REVAL	Revaluation
PURACC	Purchase Account Processing
RET	Retention
DPC_MM	Down Payment Clearing
PEVACR	Period-End Valuation - Posting Accrual Document
PEVRST	Period-End Valuation - Resetting Accrual Document

XSPLIT

FI Document Originates from Split Posting (Indicator)

SPLIT_POSTING

CHAR

Value	Description
X	Yes
NULL	No

CASH_ALLOC

Cash-Relevant Document

FAGL_CASH_ALLOC

CHAR

Value	Description
X	TRUE
NULL	FALSE

FOLLOW_ON

Follow-on document indicator

FAGL_FOLLOW_ON

CHAR

Value	Description
X	Follow-on document for Zero-balance lines

XREORG

Doc. Contains Open Item that Was Transferred During Reorg.

FAGL_R_XDOC_REORG

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

SUBSET

Defines subset of components for the FI/CO interface

ACC_SUBSET

CHAR

Value	Description
NULL	All Components
F001	FI-CA: Account Assignment Data
F002	FI-CA: FI-CA Totals Records
F003	FI-CA: Totals Records Originating from SD Billing Document
R001	IS-U/T: SD Billing Documents, Transfer to FI-CA
R002	IS-U/T: SD Billing Documents, Transfer to IS-U
G001	GL: Parallel Reporting with SL
BLC0	Budgetary Ledger Core (FI and FI-SL)
NOFM	EA-PS: Exclude FM Update
BL	Budgetary Ledger (Old)
COFI	Online Reconciliation CO -> FI
GLAL	Integrative FlexGL Allocation
GALE	FlexGL ALE Scenario for FI Documents
GLPA	GL in ERP: Parallel Financial Reporting
GMRE	Grants Management: Reconstruction
GPE0	FlexGL: Post in Period 0
GLBS	Simulate General Ledger View
GAL1	ALE for FlexGL + SL (for Customer Modification)
GLYC	Year End Closing Postings (Component FI + GL)
FCI1	FI-CA: SD Billing Documents, Transfer to FI-CA-INV
FCI2	FI-CA: SD Billing Documents, Processing in FI-CA-INV
R_FM	FlexGL: Reorganization (FI-AA): Exclude FM Components
GLAN	FlexGL Allocation Integrative, Non-Leading Ledger
F004	FI-CA Transfer (Distributed Systems)
F005	FI-CA Transfer (Distributed Systems) Invoicing
BLCL	BL Closing
FMAD	Average Daily Balances
FMCH	FM Reassignment

KURST

Exchange Rate Type

KURST

TCURV

CHAR

KURSX

Market Data Exchange Rate

GLE_FXR_DTE_RATEX28

DEC

KUR2X

Market Data Exchange Rate 2

GLE_FXR_DTE_RATE2X28

DEC

KUR3X

Market Data Exchange Rate 3

GLE_FXR_DTE_RATE3X28

DEC

XMCA

Document Originates from Multi Currency Accounting

GLE_DTE_MCA_XMCA

CHAR

Value	Description
X	Yes
NULL	No

/SAPF15/STATUS

CHAR

PSOTY

Document category payment requests

PSOTY_D

PSOTP

CHAR

PSOAK

Reason

PSOAK

PSO12

CHAR

PSOKS

Region

PSOKS

CHAR

PSOSG

Reason for reversal - IS-PS requests

PSOSG

CHAR

Value	Description
1	Deferral reversed
2	Short-Term Waiver
3	Remission
4	Deferral -> can be archived
5	Temporary waiver -> can be archived
6	New Document from Deferral Reversal

PSOFN

IS-PS: File number

PSOFN

CHAR

INTFORM

Interest Formula

FM_INTFORM

CHAR

INTDATE

Interest Calc. Date

FM_INTDATE

DATS

PSOBT

Posting Day

PSOBT

DATS

PSOZL

Actual posting

PSOZL

CHAR

Value	Description
X	Yes
NULL	No

PSODT

Changed On

AEDAT

DATS

PSOTM

Last changed at

PSOTM

TIMS

FM_UMART

Type of Payment Transfer

FM_UMART

CHAR

Value	Description
U	Transfer Posting Document
E	Reimbursement Document
R	Returns Clearing
T	Partial Payment for Invoice

CCINS

Payment cards: Card type

CCINS_30F

TCRIN

CHAR

CCNUM

Payment cards: Card number

CCNUM_30F

CHAR

SSBLK

Payment Statistical Sampling Block

SSBLK

CHAR

Value	Description
NULL	Sampling process is not applied
X	Invoice is blocked for Statistical Sampling process
P	Invoice is passed by Statistical Sampling process
R	Invoice is rejected by Statistical Sampling process
B	Invoice is batched for Statistical Sampling process

BATCH

Lot Number for Documents

LOTKZ

CHAR

SNAME

User Name

UNAME

CHAR

SAMPLED

Sampled Invoice by Payment Certification

SAMPLED

CHAR

Value	Description
NULL	Sampling process is not applied
X	Invoice is blocked for Statistical Sampling process
P	Invoice is passed by Statistical Sampling process
R	Invoice is rejected by Statistical Sampling process
B	Invoice is batched for Statistical Sampling process

EXCLUDE_FLAG

PPA Exclude Indicator

EXCLUDE_FLG

CHAR

Value	Description
X	Yes
NULL	No

BLIND

Budgetary Ledger Indicator

FM_BLIND

CHAR

Value	Description
NULL	Document contains no BL lines
P	Document contains some BL lines
X	Document contains only BL lines
C	Document is created by correction program
M	Document manually linked to other document

OFFSET_STATUS

Treasury Offset Status

FMFG_OFFSET_STATUS

CHAR

Value	Description
01	Eligible for Offset
02	Eligible for Offset, Under Investigation
03	Referred to Treasury, Uncollected
04	Referred to Treasury, Collected

OFFSET_REFER_DAT

Date Record Referred to Treasury

FMFG_REFERRED_OFFSET_DAT

DATS

PENRC

Reason for late payment

PENRC

CHAR

KNUMV

Number of the document condition

KNUMV

CHAR

OINETNUM

Exchange - netting document number

OIA_NETNUM

CHAR

OINJAHR

Fiscal Year

GJAHR

NUMC

OININD

Movement-based netting indicator

OIA_NET

CHAR

Value	Description
X	Yes
NULL	No

RECHN

Indicator: post invoice

XRECH

CHAR

Value	Description
X	Yes
NULL	No
.	No

BKPF foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table	Check field
BKPF	AUSBK	BKPF	MANDT	T001 Company Codes	MANDT
BKPF	AUSBK	BKPF	AUSBK	T001 Company Codes	BUKRS
BKPF	BLART	BKPF	MANDT	T003 Document Types	MANDT
BKPF	BLART	BKPF	BLART	T003 Document Types	BLART
BKPF	BRNCH	BKPF	MANDT	J_1BBRANCH Business Place	MANDT
BKPF	BRNCH	BKPF	BUKRS	J_1BBRANCH Business Place	BUKRS
BKPF	BRNCH	BKPF	BRNCH	J_1BBRANCH Business Place	BRANCH
BKPF	BUKRS	BKPF	MANDT	T001 Company Codes	MANDT
BKPF	BUKRS	BKPF	BUKRS	T001 Company Codes	BUKRS
BKPF	CCINS	SYST	MANDT	TCRIN Payment Cards: Card Types	MANDT
BKPF	CCINS	BKPF	CCINS	TCRIN Payment Cards: Card Types	CCINS
BKPF	KURST	BKPF	KURST	TCURV Exchange rate types for currency translation	KURST
BKPF	KURST	BKPF	MANDT	TCURV Exchange rate types for currency translation	MANDT
BKPF	KUTY2	BKPF	MANDT	TCURV Exchange rate types for currency translation	MANDT
BKPF	KUTY2	BKPF	KUTY2	TCURV Exchange rate types for currency translation	KURST
BKPF	KUTY3	BKPF	MANDT	TCURV Exchange rate types for currency translation	MANDT
BKPF	KUTY3	BKPF	KUTY3	TCURV Exchange rate types for currency translation	KURST
BKPF	KZWRS	BKPF	MANDT	TCURC Currency Codes	MANDT
BKPF	KZWRS	BKPF	KZWRS	TCURC Currency Codes	WAERS
BKPF	LDGRP	BKPF	MANDT	FAGL_TLDGRP Ledger Group	MANDT
BKPF	LDGRP	BKPF	LDGRP	FAGL_TLDGRP Ledger Group	LDGRP
BKPF	MANDT	BKPF	MANDT	T000 Clients	MANDT
BKPF	PSOAK	BKPF	PSOAK	PSO12 Deduction reasons	PSOAK
BKPF	PSOAK	T000	MANDT	PSO12 Deduction reasons	MANDT
BKPF	PSOTY	BKPF	PSOTY	PSOTP Request Category Entity Table	PSOTYP
BKPF	RLDNR	BKPF	MANDT	T882G Company code - ledger assignment	MANDT
BKPF	RLDNR	BKPF	BUKRS	T882G Company code - ledger assignment	RBUKRS
BKPF	RLDNR	BKPF	RLDNR	T882G Company code - ledger assignment	RLDNR
BKPF	STGRD	BKPF	STGRD	T041C Reasons for Reverse Posting	STGRD
BKPF	STGRD	BKPF	MANDT	T041C Reasons for Reverse Posting	MANDT
BKPF	WAERS	BKPF	MANDT	TCURC Currency Codes	MANDT
BKPF	WAERS	BKPF	WAERS	TCURC Currency Codes	WAERS