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
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BLART Document Type BLART T003 CHAR 2 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
MONAT Fiscal Period MONAT NUMC 2 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
AEDAT Date of the Last Document Change by Transaction AEDAT_BKPF DATS 8 0
UPDDT Date of the Last Document Update UPDDT DATS 8 0
WWERT Translation Date WWERT_D DATS 8 0
USNAM User name USNAM CHAR 12 0
TCODE Transaction Code TCODE CHAR 20 0
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
DBBLG Recurring Entry Document Number DBBLG CHAR 10 0
STBLG Reverse Document Number STBLG CHAR 10 0
STJAH Reverse document fiscal year STJAH NUMC 4 0
BKTXT Document Header Text BKTXT CHAR 25 0
WAERS Currency Key WAERS TCURC CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
KZWRS Currency Key for the Group Currency KZWRS TCURC CUKY 5 0
KZKRS Group Currency Exchange Rate KZKRS DEC 9 5
BSTAT Document Status BSTAT_D CHAR 1 0
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 1 0
X Yes
NULL No
FRATH Unplanned delivery costs FRATH CURR 13 2
XRUEB Indicator: Document is posted to a previous period XRUEB CHAR 1 0
X Yes
NULL No
GLVOR Business Transaction GLVOR CHAR 4 0
GRPID Batch Input Session Name GRPID_BKPF CHAR 12 0
DOKID Document Name in the Archive System DOKID_BKPF CHAR 40 0
ARCID Extract ID Document Header EXTID_BKPF CHAR 10 0
IBLAR Internal Document Type for Document Control IBLAR CHAR 2 0
AWTYP Reference Transaction AWTYP CHAR 5 0
AWKEY Reference Key AWKEY CHAR 20 0
FIKRS Financial Management Area FIKRS CHAR 4 0
HWAER Local Currency HWAER CUKY 5 0
HWAE2 Currency Key of Second Local Currency HWAE2 CUKY 5 0
HWAE3 Currency Key of Third Local Currency HWAE3 CUKY 5 0
KURS2 Exchange Rate for the Second Local Currency KURS2 DEC 9 5
KURS3 Exchange Rate for the Third Local Currency KURS3 DEC 9 5
BASW2 Source Currency for Currency Translation CURSR CHAR 1 0
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 1 0
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 1 0
1 Document date
2 Posting date
3 Translation date
UMRD3 Translation Date Type for Third Local Currency UMRD3 CHAR 1 0
1 Document date
2 Posting date
3 Translation date
XSTOV Indicator: Document is flagged for reversal XSTOV CHAR 1 0
X Yes
NULL No
STODT Planned Date for the Reverse Posting STODT DATS 8 0
XMWST Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No
CURT2 Currency Type of Second Local Currency CURT2 CHAR 2 0
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 2 0
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 4 0
KUTY3 Exchange Rate Type KURST TCURV CHAR 4 0
XSNET G/L account amounts entered exclude tax XSNET CHAR 1 0
X Yes
NULL No
AUSBK Source Company Code AUSBK T001 CHAR 4 0
XUSVR Indicator: US taxes changed at detail level ? XUSVR_BKPF CHAR 1 0
X Yes
NULL No
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1 0
NULL Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
AWSYS Logical System LOGSYSTEM CHAR 10 0
TXKRS Exchange Rate for Taxes TXKRS_BKPF DEC 9 5
LOTKZ Lot Number for Requests PSO_LOTKZ CHAR 10 0
XWVOF Indicator: Customer bill of exchange payment before due date XWVOF CHAR 1 0
X Yes
NULL No
STGRD Reason for Reversal STGRD T041C CHAR 2 0
PPNAM Name of User Who Parked this Document PPNAM CHAR 12 0
BRNCH Branch Number J_1ABRNCH J_1BBRANCH CHAR 4 0
NUMPG Number of pages of invoice J_1ANOPG NUMC 3 0
ADISC Indicator: entry represents a discount document J_1ADISC CHAR 1 0
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 20 0
XREF2_HD Reference Key 2 Internal for Document Header XREF2_HD CHAR 20 0
XREVERSAL Specifies whether doc. is reversal doc. or reversed doc. XREVERSAL CHAR 1 0
2 Reversal Document
1 Reversed Document
NULL Unknown (Old Document from Release <4.70/R/3 Enterprise)
REINDAT Invoice Receipt Date REINDAT DATS 8 0
RLDNR Ledger in General Ledger Accounting FAGL_RLDNR T882G CHAR 2 0
LDGRP Ledger Group FAGL_LDGRP FAGL_TLDGRP CHAR 4 0
PROPMANO Real Estate Management Mandate RE_MANDAT CHAR 13 0
XBLNR_ALT Alternative Reference Number XBLNR_ALT CHAR 26 0
VATDATE Tax Reporting Date VATDATE DATS 8 0
DOCCAT Classification of an FI Document DOCUMENT_CATEGORY CHAR 6 0
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 1 0
X Yes
NULL No
CASH_ALLOC Cash-Relevant Document FAGL_CASH_ALLOC CHAR 1 0
X TRUE
NULL FALSE
FOLLOW_ON Follow-on document indicator FAGL_FOLLOW_ON CHAR 1 0
X Follow-on document for Zero-balance lines
XREORG Doc. Contains Open Item that Was Transferred During Reorg. FAGL_R_XDOC_REORG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SUBSET Defines subset of components for the FI/CO interface ACC_SUBSET CHAR 4 0
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 4 0
KURSX Market Data Exchange Rate GLE_FXR_DTE_RATEX28 DEC 28 14
KUR2X Market Data Exchange Rate 2 GLE_FXR_DTE_RATE2X28 DEC 28 14
KUR3X Market Data Exchange Rate 3 GLE_FXR_DTE_RATE3X28 DEC 28 14
XMCA Document Originates from Multi Currency Accounting GLE_DTE_MCA_XMCA CHAR 1 0
X Yes
NULL No
/SAPF15/STATUS /SAPF15/STATUS CHAR 1 0
PSOTY Document category payment requests PSOTY_D PSOTP CHAR 2 0
PSOAK Reason PSOAK PSO12 CHAR 10 0
PSOKS Region PSOKS CHAR 10 0
PSOSG Reason for reversal - IS-PS requests PSOSG CHAR 1 0
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 30 0
INTFORM Interest Formula FM_INTFORM CHAR 4 0
INTDATE Interest Calc. Date FM_INTDATE DATS 8 0
PSOBT Posting Day PSOBT DATS 8 0
PSOZL Actual posting PSOZL CHAR 1 0
X Yes
NULL No
PSODT Changed On AEDAT DATS 8 0
PSOTM Last changed at PSOTM TIMS 6 0
FM_UMART Type of Payment Transfer FM_UMART CHAR 1 0
U Transfer Posting Document
E Reimbursement Document
R Returns Clearing
T Partial Payment for Invoice
CCINS Payment cards: Card type CCINS_30F TCRIN CHAR 4 0
CCNUM Payment cards: Card number CCNUM_30F CHAR 25 0
SSBLK Payment Statistical Sampling Block SSBLK CHAR 1 0
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 10 0
SNAME User Name UNAME CHAR 12 0
SAMPLED Sampled Invoice by Payment Certification SAMPLED CHAR 1 0
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 1 0
X Yes
NULL No
BLIND Budgetary Ledger Indicator FM_BLIND CHAR 1 0
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 2 0
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 8 0
PENRC Reason for late payment PENRC CHAR 2 0
KNUMV Number of the document condition KNUMV CHAR 10 0
OINETNUM Exchange - netting document number OIA_NETNUM CHAR 10 0
OINJAHR Fiscal Year GJAHR NUMC 4 0
OININD Movement-based netting indicator OIA_NET CHAR 1 0
X Yes
NULL No
RECHN Indicator: post invoice XRECH CHAR 1 0
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 BLART T003 Document Types BLART
BKPF BLART BKPF MANDT T003 Document Types MANDT
BKPF BRNCH BKPF BUKRS J_1BBRANCH Business Place BUKRS
BKPF BRNCH BKPF BRNCH J_1BBRANCH Business Place BRANCH
BKPF BRNCH BKPF MANDT J_1BBRANCH Business Place MANDT
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 MANDT TCURV Exchange rate types for currency translation MANDT
BKPF KURST BKPF KURST TCURV Exchange rate types for currency translation KURST
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 T000 MANDT PSO12 Deduction reasons MANDT
BKPF PSOAK BKPF PSOAK PSO12 Deduction reasons PSOAK
BKPF PSOTY BKPF PSOTY PSOTP Request Category Entity Table PSOTYP
BKPF RLDNR BKPF RLDNR T882G Company code - ledger assignment RLDNR
BKPF RLDNR BKPF MANDT T882G Company code - ledger assignment MANDT
BKPF RLDNR BKPF BUKRS T882G Company code - ledger assignment RBUKRS
BKPF STGRD BKPF MANDT T041C Reasons for Reverse Posting MANDT
BKPF STGRD BKPF STGRD T041C Reasons for Reverse Posting STGRD
BKPF WAERS BKPF MANDT TCURC Currency Codes MANDT
BKPF WAERS BKPF WAERS TCURC Currency Codes WAERS