SAP TABLES | Financial Accounting(FI) SAP FI

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




FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3T000Client
BUKRSBUKRSCHAR4T001Company Code
BELNRBELNR_DCHAR10Accounting Document NumberALPHA
GJAHRGJAHRNUMC4Fiscal YearGJAHR
BLARTBLARTCHAR2T003Document Type
BLDATBLDATDATS8Document Date in Document
BUDATBUDATDATS8Posting Date in the Document
MONATMONATNUMC2Fiscal Period
CPUDTCPUDTDATS8Day On Which Accounting Document Was Entered
CPUTMCPUTMTIMS6Time of Entry
AEDATAEDAT_BKPFDATS8Date of the Last Document Change by Transaction
UPDDTUPDDTDATS8Date of the Last Document Update
WWERTWWERT_DDATS8Translation Date
USNAMUSNAMCHAR12
*
User name
TCODETCODECHAR20
*
Transaction Code
BVORGBVORGCHAR16Number of Cross-Company Code Posting Transaction
XBLNRXBLNR1CHAR16Reference Document Number
DBBLGDBBLGCHAR10Recurring Entry Document NumberALPHA
STBLGSTBLGCHAR10Reverse Document NumberALPHA
STJAHSTJAHNUMC4Reverse document fiscal yearGJAHR
BKTXTBKTXTCHAR25Document Header Text
WAERSWAERSCUKY5TCURCCurrency Key
KURSFKURSFDEC9(5)Exchange rateEXCRT
KZWRSKZWRSCUKY5TCURCCurrency Key for the Group Currency
KZKRSKZKRSDEC9(5)Group Currency Exchange RateEXCRT
BSTATBSTAT_DCHAR1Document Status
XNETBXNETBCHAR1Indicator: Document posted net ?
FRATHFRATHCURR13(2)Unplanned delivery costs
XRUEBXRUEBCHAR1Indicator: Document is posted to a previous period
GLVORGLVORCHAR4Business Transaction
GRPIDGRPID_BKPFCHAR12Batch Input Session Name
DOKIDDOKID_BKPFCHAR40Document Name in the Archive System
ARCIDEXTID_BKPFCHAR10Extract ID Document Header
IBLARIBLARCHAR2Internal Document Type for Document Control
AWTYPAWTYPCHAR5
*
Reference Transaction
AWKEYAWKEYCHAR20Reference Key
FIKRSFIKRSCHAR4
*
Financial Management Area
HWAERHWAERCUKY5
*
Local Currency
HWAE2HWAE2CUKY5
*
Currency Key of Second Local Currency
HWAE3HWAE3CUKY5
*
Currency Key of Third Local Currency

KURS2KURS2DEC9(5)Exchange Rate for the Second Local CurrencyEXCRT
KURS3KURS3DEC9(5)Exchange Rate for the Third Local CurrencyEXCRT
BASW2CURSRCHAR1Source Currency for Currency Translation
BASW3CURSRCHAR1Source Currency for Currency Translation
UMRD2UMRD2CHAR1Translation Date Type for Second Local Currency
UMRD3UMRD3CHAR1Translation Date Type for Third Local Currency
XSTOVXSTOVCHAR1Indicator: Document is flagged for reversal
STODTSTODTDATS8Planned Date for the Reverse Posting
XMWSTXMWSTCHAR1Calculate tax automatically
CURT2CURT2CHAR2Currency Type of Second Local Currency
CURT3CURT3CHAR2Currency Type of Third Local Currency
KUTY2KURSTCHAR4TCURVExchange Rate Type
KUTY3KURSTCHAR4TCURVExchange Rate Type
XSNETXSNETCHAR1G/L account amounts entered exclude tax
AUSBKAUSBKCHAR4T001Source Company Code
XUSVRXUSVR_BKPFCHAR1Indicator: US taxes changed at detail level ?
DUEFLDUEFL_BKPFCHAR1Status of Data Transfer into Subsequent Release
AWSYSLOGSYSTEMCHAR10
*
Logical SystemALPHA
TXKRSTXKRS_BKPFDEC9(5)Exchange Rate for TaxesEXCRT
LOTKZPSO_LOTKZCHAR10Lot Number for RequestsALPHA
XWVOFXWVOFCHAR1Indicator: Customer bill of exchange payment before due date
STGRDSTGRDCHAR2T041CReason for Reversal
PPNAMPPNAMCHAR12
*
Name of User Who Parked this Document
BRNCHJ_1ABRNCHCHAR4J_1BBRANCHBranch Number
NUMPGJ_1ANOPGNUMC3Number of pages of invoice
ADISCJ_1ADISCCHAR1Indicator: entry represents a discount document
XREF1_HDXREF1_HDCHAR20Reference Key 1 Internal for Document Header
XREF2_HDXREF2_HDCHAR20Reference Key 2 Internal for Document Header
XREVERSALXREVERSALCHAR1Specifies whether doc. is reversal doc. or reversed doc.
REINDATREINDATDATS8Invoice Receipt Date
RLDNRFAGL_RLDNRCHAR2T882GLedger in General Ledger AccountingALPHA
LDGRPFAGL_LDGRPCHAR4FAGL_TLDGRPLedger Group
PROPMANORE_MANDATCHAR13Real Estate Management MandatePRPMN
XBLNR_ALTXBLNR_ALTCHAR26Alternative Reference NumberODNIT
VATDATEVATDATEDATS8Tax Reporting Date
DOCCATDOCUMENT_CATEGORYCHAR6Classification of an FI Document
XSPLITSPLIT_POSTINGCHAR1FI Document Originates from Split Posting (Indicator)
CASH_ALLOCFAGL_CASH_ALLOCCHAR1Cash-Relevant Document
FOLLOW_ONFAGL_FOLLOW_ONCHAR1Follow-on document indicator
XREORGFAGL_R_XDOC_REORGCHAR1Doc. Contains Open Item that Was Transferred During Reorg.

SUBSETACC_SUBSETCHAR4Defines subset of components for the FI/CO interface
KURSTKURSTCHAR4TCURVExchange Rate Type
KURSXGLE_FXR_DTE_RATEX28DEC28(14)Market Data Exchange RateEXCRX
KUR2XGLE_FXR_DTE_RATE2X28DEC28(14)Market Data Exchange Rate 2EXCRX
KUR3XGLE_FXR_DTE_RATE3X28DEC28(14)Market Data Exchange Rate 3EXCRX
XMCAGLE_DTE_MCA_XMCACHAR1Document Originates from Multi Currency Accounting
.APPEND/SAPF15/BKPF_APPENDF15 Append BKPF
/SAPF15/STATUS/SAPF15/STATUSCHAR1Belegstatus
.APPENDABKPF_PSOIS-PS: BKPF Append Structure for Payment Requests
.INCLUDEIBKPF_PSOIS-PS: Include Structure BKPF Payment Request Doc.Header
.INCLUDEIVBKPF_PSOIS-PS: Include for Append Parked Payment Request Doc.Header
PSOTYPSOTY_DCHAR2PSOTPDocument category payment requests
PSOAKPSOAKCHAR10PSO12Reason
PSOKSPSOKSCHAR10
*
Region
PSOSGPSOSGCHAR1Reason for reversal - IS-PS requests
PSOFNPSOFNCHAR30IS-PS: File number
INTFORMFM_INTFORMCHAR4Interest Formula
INTDATEFM_INTDATEDATS8Interest Calc. Date
PSOBTPSOBTDATS8Posting Day
PSOZLPSOZLCHAR1Actual posting
PSODTAEDATDATS8Changed On
PSOTMPSOTMTIMS6Last changed at
.APPENDABKPF_UMBIS-PS: Append Structure for Transfer Transaction FMITPO
FM_UMARTFM_UMARTCHAR1Type of Payment Transfer
.APPENDBKPF_CARDCredit Card: Append for BKPF
.INCLUDEFCRD_VBKPFCredit Card: Include for Appends for BKPF, VBKPF
CCINSCCINS_30FCHAR4TCRINPayment cards: Card type
CCNUMCCNUM_30FCHAR25Payment cards: Card number
.APPENDBKPF_USFEDAppend structure for US federal government
SSBLKSSBLKCHAR1Payment Statistical Sampling Block
BATCHLOTKZCHAR10Lot Number for DocumentsALPHA
SNAMEUNAMECHAR12User Name
SAMPLEDSAMPLEDCHAR1Sampled Invoice by Payment Certification
EXCLUDE_FLAGEXCLUDE_FLGCHAR1PPA Exclude Indicator
BLINDFM_BLINDCHAR1Budgetary Ledger Indicator
OFFSET_STATUSFMFG_OFFSET_STATUSCHAR2Treasury Offset Status
OFFSET_REFER_DATFMFG_REFERRED_OFFSET_DATDATS8Date Record Referred to Treasury
PENRCPENRCCHAR2Reason for late payment
.APPENDJVBKPFJoint Venture fields
KNUMVKNUMVCHAR10Number 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