SAP Table BKKPF

Accounting document header

BKKPF (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 BKKPF to other SAP tables.

Source: BKKPF (Accounting document header)

BKKPF 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_BKPF CHAR 4 0
BVORG Number of Cross-Company Code Posting Transaction BVORG CHAR 16 0
XBLNR Reference Document Number XBLNR 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 Documents 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

BKKPF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BKKPF AUSBK BKKPF MANDT T001 Company Codes MANDT
BKKPF AUSBK BKKPF AUSBK T001 Company Codes BUKRS
BKKPF BLART BKKPF BLART T003 Document Types BLART
BKKPF BLART BKKPF MANDT T003 Document Types MANDT
BKKPF BRNCH BKKPF MANDT J_1BBRANCH Business Place MANDT
BKKPF BRNCH BKKPF BUKRS J_1BBRANCH Business Place BUKRS
BKKPF BRNCH BKKPF BRNCH J_1BBRANCH Business Place BRANCH
BKKPF BUKRS BKKPF BUKRS T001 Company Codes BUKRS
BKKPF BUKRS BKKPF MANDT T001 Company Codes MANDT
BKKPF KUTY2 BKKPF KUTY2 TCURV Exchange rate types for currency translation KURST
BKKPF KUTY2 BKKPF MANDT TCURV Exchange rate types for currency translation MANDT
BKKPF KUTY3 BKKPF KUTY3 TCURV Exchange rate types for currency translation KURST
BKKPF KUTY3 BKKPF MANDT TCURV Exchange rate types for currency translation MANDT
BKKPF KZWRS BKKPF KZWRS TCURC Currency Codes WAERS
BKKPF KZWRS BKKPF MANDT TCURC Currency Codes MANDT
BKKPF MANDT BKKPF MANDT T000 Clients MANDT
BKKPF STGRD BKKPF STGRD T041C Reasons for Reverse Posting STGRD
BKKPF STGRD BKKPF MANDT T041C Reasons for Reverse Posting MANDT
BKKPF WAERS BKKPF WAERS TCURC Currency Codes WAERS
BKKPF WAERS BKKPF MANDT TCURC Currency Codes MANDT