BKPF SAP Accounting Document Header Table and data
BKPF is a standard SAP Table which is used to store Accounting Document Header data and is available within R/3 SAP systems depending on the version and release level.
Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP BKPF Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.
Delivery Class: A - Application table containing master and transaction data
Display/Maintenance via SM30: Yes but with Restrictions
Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories
==>View Table relationships
SAP BKPF Table fields within data Dictionary
| Field | Data Element | Data Type | length (Decimals) | Check table | Description | Conversion Routine |
| MANDT | MANDT | CLNT | 3 | T000 | Client | |
| BUKRS | BUKRS | CHAR | 4 | T001 | Company Code | |
| BELNR | BELNR_D | CHAR | 10 | Accounting Document Number | ALPHA | |
| GJAHR | GJAHR | NUMC | 4 | Fiscal Year | GJAHR | |
| BLART | BLART | CHAR | 2 | T003 | Document Type | |
| BLDAT | BLDAT | DATS | 8 | Document Date in Document | ||
| BUDAT | BUDAT | DATS | 8 | Posting Date in the Document | ||
| MONAT | MONAT | NUMC | 2 | Fiscal Period | ||
| CPUDT | CPUDT | DATS | 8 | Day On Which Accounting Document Was Entered | ||
| CPUTM | CPUTM | TIMS | 6 | Time of Entry | ||
| AEDAT | AEDAT_BKPF | DATS | 8 | Date of the Last Document Change by Transaction | ||
| UPDDT | UPDDT | DATS | 8 | Date of the Last Document Update | ||
| WWERT | WWERT_D | DATS | 8 | Translation Date | ||
| USNAM | USNAM | CHAR | 12 |
* | User name | |
| TCODE | TCODE | CHAR | 20 |
* | Transaction Code | |
| BVORG | BVORG | CHAR | 16 | Number of Cross-Company Code Posting Transaction | ||
| XBLNR | XBLNR1 | CHAR | 16 | Reference Document Number | ||
| DBBLG | DBBLG | CHAR | 10 | Recurring Entry Document Number | ALPHA | |
| STBLG | STBLG | CHAR | 10 | Reverse Document Number | ALPHA | |
| STJAH | STJAH | NUMC | 4 | Reverse document fiscal year | GJAHR | |
| BKTXT | BKTXT | CHAR | 25 | Document Header Text | ||
| WAERS | WAERS | CUKY | 5 | TCURC | Currency Key | |
| KURSF | KURSF | DEC | 9(5) | Exchange rate | EXCRT | |
| KZWRS | KZWRS | CUKY | 5 | TCURC | Currency Key for the Group Currency | |
| KZKRS | KZKRS | DEC | 9(5) | Group Currency Exchange Rate | EXCRT | |
| BSTAT | BSTAT_D | CHAR | 1 | Document Status | ||
| XNETB | XNETB | CHAR | 1 | Indicator: Document posted net ? | ||
| FRATH | FRATH | CURR | 13(2) | Unplanned delivery costs | ||
| XRUEB | XRUEB | CHAR | 1 | Indicator: Document is posted to a previous period | ||
| GLVOR | GLVOR | CHAR | 4 | Business Transaction | ||
| GRPID | GRPID_BKPF | CHAR | 12 | Batch Input Session Name | ||
| DOKID | DOKID_BKPF | CHAR | 40 | Document Name in the Archive System | ||
| ARCID | EXTID_BKPF | CHAR | 10 | Extract ID Document Header | ||
| IBLAR | IBLAR | CHAR | 2 | Internal Document Type for Document Control | ||
| AWTYP | AWTYP | CHAR | 5 |
* | Reference Transaction | |
| AWKEY | AWKEY | CHAR | 20 | Reference Key | ||
| FIKRS | FIKRS | CHAR | 4 |
* | Financial Management Area | |
| HWAER | HWAER | CUKY | 5 |
* | Local Currency | |
| HWAE2 | HWAE2 | CUKY | 5 |
* | Currency Key of Second Local Currency | |
| HWAE3 | HWAE3 | CUKY | 5 |
* | Currency Key of Third Local Currency | |
| KURS2 | KURS2 | DEC | 9(5) | Exchange Rate for the Second Local Currency | EXCRT | |
| KURS3 | KURS3 | DEC | 9(5) | Exchange Rate for the Third Local Currency | EXCRT | |
| BASW2 | CURSR | CHAR | 1 | Source Currency for Currency Translation | ||
| BASW3 | CURSR | CHAR | 1 | Source Currency for Currency Translation | ||
| UMRD2 | UMRD2 | CHAR | 1 | Translation Date Type for Second Local Currency | ||
| UMRD3 | UMRD3 | CHAR | 1 | Translation Date Type for Third Local Currency | ||
| XSTOV | XSTOV | CHAR | 1 | Indicator: Document is flagged for reversal | ||
| STODT | STODT | DATS | 8 | Planned Date for the Reverse Posting | ||
| XMWST | XMWST | CHAR | 1 | Calculate tax automatically | ||
| CURT2 | CURT2 | CHAR | 2 | Currency Type of Second Local Currency | ||
| CURT3 | CURT3 | CHAR | 2 | Currency Type of Third Local Currency | ||
| KUTY2 | KURST | CHAR | 4 | TCURV | Exchange Rate Type | |
| KUTY3 | KURST | CHAR | 4 | TCURV | Exchange Rate Type | |
| XSNET | XSNET | CHAR | 1 | G/L account amounts entered exclude tax | ||
| AUSBK | AUSBK | CHAR | 4 | T001 | Source Company Code | |
| XUSVR | XUSVR_BKPF | CHAR | 1 | Indicator: US taxes changed at detail level ? | ||
| DUEFL | DUEFL_BKPF | CHAR | 1 | Status of Data Transfer into Subsequent Release | ||
| AWSYS | LOGSYSTEM | CHAR | 10 |
* | Logical System | ALPHA |
| TXKRS | TXKRS_BKPF | DEC | 9(5) | Exchange Rate for Taxes | EXCRT | |
| LOTKZ | PSO_LOTKZ | CHAR | 10 | Lot Number for Requests | ALPHA | |
| XWVOF | XWVOF | CHAR | 1 | Indicator: Customer bill of exchange payment before due date | ||
| STGRD | STGRD | CHAR | 2 | T041C | Reason for Reversal | |
| PPNAM | PPNAM | CHAR | 12 |
* | Name of User Who Parked this Document | |
| BRNCH | J_1ABRNCH | CHAR | 4 | J_1BBRANCH | Branch Number | |
| NUMPG | J_1ANOPG | NUMC | 3 | Number of pages of invoice | ||
| ADISC | J_1ADISC | CHAR | 1 | Indicator: entry represents a discount document | ||
| XREF1_HD | XREF1_HD | CHAR | 20 | Reference Key 1 Internal for Document Header | ||
| XREF2_HD | XREF2_HD | CHAR | 20 | Reference Key 2 Internal for Document Header | ||
| XREVERSAL | XREVERSAL | CHAR | 1 | Specifies whether doc. is reversal doc. or reversed doc. | ||
| REINDAT | REINDAT | DATS | 8 | Invoice Receipt Date | ||
| RLDNR | FAGL_RLDNR | CHAR | 2 | T882G | Ledger in General Ledger Accounting | ALPHA |
| LDGRP | FAGL_LDGRP | CHAR | 4 | FAGL_TLDGRP | Ledger Group | |
| PROPMANO | RE_MANDAT | CHAR | 13 | Real Estate Management Mandate | PRPMN | |
| XBLNR_ALT | XBLNR_ALT | CHAR | 26 | Alternative Reference Number | ODNIT | |
| VATDATE | VATDATE | DATS | 8 | Tax Reporting Date | ||
| DOCCAT | DOCUMENT_CATEGORY | CHAR | 6 | Classification of an FI Document | ||
| XSPLIT | SPLIT_POSTING | CHAR | 1 | FI Document Originates from Split Posting (Indicator) | ||
| CASH_ALLOC | FAGL_CASH_ALLOC | CHAR | 1 | Cash-Relevant Document | ||
| FOLLOW_ON | FAGL_FOLLOW_ON | CHAR | 1 | Follow-on document indicator | ||
| XREORG | FAGL_R_XDOC_REORG | CHAR | 1 | Doc. Contains Open Item that Was Transferred During Reorg. | ||
| SUBSET | ACC_SUBSET | CHAR | 4 | Defines subset of components for the FI/CO interface | ||
| KURST | KURST | CHAR | 4 | TCURV | Exchange Rate Type | |
| KURSX | GLE_FXR_DTE_RATEX28 | DEC | 28(14) | Market Data Exchange Rate | EXCRX | |
| KUR2X | GLE_FXR_DTE_RATE2X28 | DEC | 28(14) | Market Data Exchange Rate 2 | EXCRX | |
| KUR3X | GLE_FXR_DTE_RATE3X28 | DEC | 28(14) | Market Data Exchange Rate 3 | EXCRX | |
| XMCA | GLE_DTE_MCA_XMCA | CHAR | 1 | Document Originates from Multi Currency Accounting | ||
| .APPEND | /SAPF15/BKPF_APPEND | F15 Append BKPF | ||||
| /SAPF15/STATUS | /SAPF15/STATUS | CHAR | 1 | Belegstatus | ||
| .APPEND | ABKPF_PSO | IS-PS: BKPF Append Structure for Payment Requests | ||||
| .INCLUDE | IBKPF_PSO | IS-PS: Include Structure BKPF Payment Request Doc.Header | ||||
| .INCLUDE | IVBKPF_PSO | IS-PS: Include for Append Parked Payment Request Doc.Header | ||||
| PSOTY | PSOTY_D | CHAR | 2 | PSOTP | Document category payment requests | |
| PSOAK | PSOAK | CHAR | 10 | PSO12 | Reason | |
| PSOKS | PSOKS | CHAR | 10 |
* | Region | |
| PSOSG | PSOSG | CHAR | 1 | Reason for reversal - IS-PS requests | ||
| PSOFN | PSOFN | CHAR | 30 | IS-PS: File number | ||
| INTFORM | FM_INTFORM | CHAR | 4 | Interest Formula | ||
| INTDATE | FM_INTDATE | DATS | 8 | Interest Calc. Date | ||
| PSOBT | PSOBT | DATS | 8 | Posting Day | ||
| PSOZL | PSOZL | CHAR | 1 | Actual posting | ||
| PSODT | AEDAT | DATS | 8 | Changed On | ||
| PSOTM | PSOTM | TIMS | 6 | Last changed at | ||
| .APPEND | ABKPF_UMB | IS-PS: Append Structure for Transfer Transaction FMITPO | ||||
| FM_UMART | FM_UMART | CHAR | 1 | Type of Payment Transfer | ||
| .APPEND | BKPF_CARD | Credit Card: Append for BKPF | ||||
| .INCLUDE | FCRD_VBKPF | Credit Card: Include for Appends for BKPF, VBKPF | ||||
| CCINS | CCINS_30F | CHAR | 4 | TCRIN | Payment cards: Card type | |
| CCNUM | CCNUM_30F | CHAR | 25 | Payment cards: Card number | ||
| .APPEND | BKPF_USFED | Append structure for US federal government | ||||
| SSBLK | SSBLK | CHAR | 1 | Payment Statistical Sampling Block | ||
| BATCH | LOTKZ | CHAR | 10 | Lot Number for Documents | ALPHA | |
| SNAME | UNAME | CHAR | 12 | User Name | ||
| SAMPLED | SAMPLED | CHAR | 1 | Sampled Invoice by Payment Certification | ||
| EXCLUDE_FLAG | EXCLUDE_FLG | CHAR | 1 | PPA Exclude Indicator | ||
| BLIND | FM_BLIND | CHAR | 1 | Budgetary Ledger Indicator | ||
| OFFSET_STATUS | FMFG_OFFSET_STATUS | CHAR | 2 | Treasury Offset Status | ||
| OFFSET_REFER_DAT | FMFG_REFERRED_OFFSET_DAT | DATS | 8 | Date Record Referred to Treasury | ||
| PENRC | PENRC | CHAR | 2 | Reason for late payment | ||
| .APPEND | JVBKPF | Joint Venture fields | ||||
| KNUMV | KNUMV | CHAR | 10 | Number of the document condition | ||
| Key field | |
| Non-key field |
BKPF relationships with other tables
PAKET_RRLREC-Remuneration List Recipient
DOCUMENTS-Documents for Remuneration List Recipient
DYNSEL-Selektionsdaten
FOREIGNKEY_SEL-Selection on foreign key
V_RRLE_REL-Relevant Documents
V_RRLEE_REL-Relevant External Docs
VBRK-Relevant SD Billing Docs
BKPF-Relevant AC Document Headers
BSEG-Relevant AC Document Lines
MARA-Material Master: General Data
MBEW-Material Valuation
MKPF-Header: Material Document
MSEG-Document Segment: Material
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BOSG-Uppermost Hierarchy Segment for BRF
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
BSET-Tax Data Document Segment
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
KNA1-General Data in Customer Master
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNKK-Credit Management Cust. Mstr: Control Area Data
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
LFA1-Vendor Master (General Section)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
BKPF-Accounting Document Header
BSET-Tax Data Document Segment
BSEG-Accounting Document Segment
BSEC-One-Time Account Data Document Segment
EKKO-Purchasing Document Header
EKPO-Purchasing Document Item
EKBE-Purchasing Document History
KNA1-General Data in Customer Master
ADDR1_VAL-Address Data
KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
KNKA-Customer Master Credit Management: Central Data
KNKK-Credit Management Cust. Mstr: Control Area Data
KNBK-Customer Master (Bank Details)
KNB1-Customer Master (Company Code)
KNB4-Customer Payment History
KNB5-Customer Master (Dunning Data)
KNC1-Customer Master (Transaction Figures)
KNC3-Customer Master (Special G/L Transaction Figures)
BSID-Accounting: Secondary Index for Customers
ADMI_FILES-Archive Files
BSIDEXT-Secondary Index & Additions Section (bsega)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
LFA1-Vendor Master (General Section)
ADDR1_VAL-Address Data
LFAS-Vendor Master (General Part EU Tax Number)
LFBK-Vendor Master (Bank Details)
LFB1-Vendor Master (Company Code)
LFB5-Vendor Master (Dunning Data)
LFC1-Vendor Master (Transaction Figures)
LFC3-Vendor Master (Transaction Figures) Special Ledger
BSIK-Accounting: Secondary Index for Vendors
ADMI_FILES-Archive Files
BSIKEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
GSEG-Offsetting Items for B-Segment in Reporting
SKA1-G/L Account Master Record (Chart of Accounts)
SKB1-G/L Account Master Record (Company Code)
SKC1A-G/L Sales Segment Derived from GLDB - Internal
SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-
FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
BSIS-Accounting: Secondary Index for G/L Accounts
ADMI_FILES-Archive Files
BSISEXT-Secondary Index & Additions Section (BSEGA)
BKPF-Accounting Document Header
BSEG-Accounting Document Segment
GSEG-Offsetting Items for B-Segment in Reporting
