BKPF SAP (Accounting Document Header) Table details

Dictionary Type: Table
Description: Accounting Document Header




ABAP Code to SELECT data from BKPF
Related tables to BKPF
Access table BKPF




Table field list including key, data, relationships and ABAP select examples

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.

The BKPF table consists of various fields, each holding specific information or linking keys about Accounting Document Header data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BLART (Document Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP BKPF table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BLARTDocument Type BLARTCHAR2T003BLARTBAR
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
MONATFiscal Period MONATNUMC2MONAT
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AEDATDate of the Last Document Change by Transaction AEDAT_BKPFDATS8DATUM
UPDDTDate of the Last Document Update UPDDTDATS8DATUM
WWERTTranslation Date WWERT_DDATS8DATUM
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
BVORGNumber of Cross-Company Code Posting Transaction BVORGCHAR16BVORG
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
DBBLGRecurring Entry Document Number DBBLGCHAR10ALPHABELNR
STBLGReverse Document Number STBLGCHAR10ALPHABELNR
STJAHReverse document fiscal year STJAHNUMC4GJAHRGJAHR
BKTXTDocument Header Text BKTXTCHAR25TEXT25
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
KZWRSCurrency Key for the Group Currency KZWRSCUKY5TCURCWAERS
KZKRSGroup Currency Exchange Rate KZKRSDEC9(5) KURSF
BSTATDocument Status BSTAT_DCHAR1BSTAT
XNETBIndicator: Document posted net ? XNETBCHAR1XFELD
FRATHUnplanned delivery costs FRATHCURR13(2) WERT7
XRUEBIndicator: Document is posted to a previous period XRUEBCHAR1XFELD
GLVORBusiness Transaction GLVORCHAR4CHAR4
GRPIDBatch Input Session Name GRPID_BKPFCHAR12CHAR12
DOKIDDocument Name in the Archive System DOKID_BKPFCHAR40CHAR40
ARCIDExtract ID Document Header EXTID_BKPFCHAR10CHAR10
IBLARInternal Document Type for Document Control IBLARCHAR2IBLAR
AWTYPReference Transaction AWTYPCHAR5Assigned to domainAWTYP
AWKEYReference Key AWKEYCHAR20AWKEY
FIKRSFinancial Management Area FIKRSCHAR4Assigned to domainFIKRSFIK
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
HWAE2Currency Key of Second Local Currency HWAE2CUKY5Assigned to domainWAERS
HWAE3Currency Key of Third Local Currency HWAE3CUKY5Assigned to domainWAERS
KURS2Exchange Rate for the Second Local Currency KURS2DEC9(5) KURSF
KURS3Exchange Rate for the Third Local Currency KURS3DEC9(5) KURSF
BASW2Source Currency for Currency Translation CURSRCHAR1CURSR
BASW3Source Currency for Currency Translation CURSRCHAR1CURSR
UMRD2Translation Date Type for Second Local Currency UMRD2CHAR1CURDT
UMRD3Translation Date Type for Third Local Currency UMRD3CHAR1CURDT
XSTOVIndicator: Document is flagged for reversal XSTOVCHAR1XFELD
STODTPlanned Date for the Reverse Posting STODTDATS8DATUM
XMWSTCalculate tax automatically XMWSTCHAR1XFELDXTX
CURT2Currency Type of Second Local Currency CURT2CHAR2CURTP
CURT3Currency Type of Third Local Currency CURT3CHAR2CURTP
KUTY2Exchange Rate Type KURSTCHAR4TCURVKURSTKUT
KUTY3Exchange Rate Type KURSTCHAR4TCURVKURSTKUT
XSNETG/L account amounts entered exclude tax XSNETCHAR1XFELD
AUSBKSource Company Code AUSBKCHAR4T001BUKRS
XUSVRIndicator: US taxes changed at detail level ? XUSVR_BKPFCHAR1XFELD
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
AWSYSLogical System LOGSYSTEMCHAR10Assigned to domainALPHALOGSYS
TXKRSExchange Rate for Taxes TXKRS_BKPFDEC9(5) KURSF
LOTKZLot Number for Requests PSO_LOTKZCHAR10ALPHALOTKZLOT
XWVOFIndicator: Customer bill of exchange payment before due date XWVOFCHAR1XFELD
STGRDReason for Reversal STGRDCHAR2T041CSTGRDFSG
PPNAMName of User Who Parked this Document PPNAMCHAR12Assigned to domainXUBNAME
BRNCHBranch Number J_1ABRNCHCHAR4J_1BBRANCHJ_1BBRANCHJEA
NUMPGNumber of pages of invoice J_1ANOPGNUMC3J_1ANOPG
ADISCIndicator: entry represents a discount document J_1ADISCCHAR1ADISC
XREF1_HDReference Key 1 Internal for Document Header XREF1_HDCHAR20CHAR20
XREF2_HDReference Key 2 Internal for Document Header XREF2_HDCHAR20CHAR20
XREVERSALSpecifies whether doc. is reversal doc. or reversed doc. XREVERSALCHAR1XREVERSAL
REINDATInvoice Receipt Date REINDATDATS8DATUM
RLDNRLedger in General Ledger Accounting FAGL_RLDNRCHAR2T882GALPHARLDNRGLN_FLEXFAGL_RLDNR
LDGRPLedger Group FAGL_LDGRPCHAR4FAGL_TLDGRPFAGL_LDGRPGLDGRP_FLEX
PROPMANOReal Estate Management Mandate RE_MANDATCHAR13PRPMNRE_MANDAT
XBLNR_ALTAlternative Reference Number XBLNR_ALTCHAR26ODNITXBLNR_ALT
VATDATETax Reporting Date VATDATEDATS8DATUM
DOCCATClassification of an FI Document DOCUMENT_CATEGORYCHAR6DOCUMENT_CATEGORY
XSPLITFI Document Originates from Split Posting (Indicator) SPLIT_POSTINGCHAR1XFELD
CASH_ALLOCCash-Relevant Document FAGL_CASH_ALLOCCHAR1BOOLE
FOLLOW_ONFollow-on document indicator FAGL_FOLLOW_ONCHAR1FAGL_FOLLOW_ON
XREORGDoc. Contains Open Item that Was Transferred During Reorg. FAGL_R_XDOC_REORGCHAR1FLAG
SUBSETDefines subset of components for the FI/CO interface ACC_SUBSETCHAR4ACC_SUBSET
KURSTExchange Rate Type KURSTCHAR4TCURVKURSTKUT
KURSXMarket Data Exchange Rate GLE_FXR_DTE_RATEX28DEC28(14) EXCRXGLE_FXR_RATEX28
KUR2XMarket Data Exchange Rate 2 GLE_FXR_DTE_RATE2X28DEC28(14) EXCRXGLE_FXR_RATEX28
KUR3XMarket Data Exchange Rate 3 GLE_FXR_DTE_RATE3X28DEC28(14) EXCRXGLE_FXR_RATEX28
XMCADocument Originates from Multi Currency Accounting GLE_DTE_MCA_XMCACHAR1XFELD
.INCLU--AP 0
/SAPF15/STATUS /SAPF15/STATUSCHAR1/SAPF15/STATUS
.INCLU--AP 0
PSOTYDocument category payment requests PSOTY_DCHAR2PSOTPPSOTY
PSOAKReason PSOAKCHAR10PSO12PSOAK
PSOKSRegion PSOKSCHAR10Assigned to domainPSOKS
PSOSGReason for reversal - IS-PS requests PSOSGCHAR1PSOSG
PSOFNIS-PS: File number PSOFNCHAR30CHAR30
INTFORMInterest Formula FM_INTFORMCHAR4CHAR4
INTDATEInterest Calc. Date FM_INTDATEDATS8DATUM
PSOBTPosting Day PSOBTDATS8DATUM
PSOZLActual posting PSOZLCHAR1XFELD
PSODTChanged On AEDATDATS8DATUM
PSOTMLast changed at PSOTMTIMS6UZEIT
.INCLU--AP 0
FM_UMARTType of Payment Transfer FM_UMARTCHAR1FM_UMART
.INCLU--AP 0
CCINSPayment cards: Card type CCINS_30FCHAR4TCRINCCINS_30FCIN
CCNUMPayment cards: Card number CCNUM_30FCHAR25CCNUM_30FCNO
.INCLU--AP 0
SSBLKPayment Statistical Sampling Block SSBLKCHAR1SSBLK
BATCHLot Number for Documents LOTKZCHAR10ALPHALOTKZLOT
SNAMEUser Name UNAMECHAR12UNAME
SAMPLEDSampled Invoice by Payment Certification SAMPLEDCHAR1SSBLK
EXCLUDE_FLAGPPA Exclude Indicator EXCLUDE_FLGCHAR1XFELD
BLINDBudgetary Ledger Indicator FM_BLINDCHAR1FM_BLIND
OFFSET_STATUSTreasury Offset Status FMFG_OFFSET_STATUSCHAR2FMFG_OFFSET_STATUS
OFFSET_REFER_DATDate Record Referred to Treasury FMFG_REFERRED_OFFSET_DATDATS8DATUM
PENRCReason for late payment PENRCCHAR2CHAR2FM_PENRC
.INCLU--AP 0
KNUMVNumber of the document condition KNUMVCHAR10KNUMV

Key field Non-key field



How do I retrieve data from SAP table BKPF using ABAP code

The following ABAP code Example will allow you to do a basic selection on BKPF to SELECT all data from the table
DATA: WA_BKPF TYPE BKPF.

SELECT SINGLE *
FROM BKPF
INTO CORRESPONDING FIELDS OF WA_BKPF
WHERE...

How to access SAP table BKPF

Within an ECC or HANA version of SAP you can also view further information about BKPF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!