SAP table reference

BKPF

Accounting Document Header

Explore another table

Enter a table code or keyword to continue exploring.

SAP table BKPF, known as the "Accounting Document Header," plays a crucial role in the SAP Financial Accounting (FI) module. It stores the header data for financial accounting documents, serving as the primary record for the overarching information of each document. This includes essential fields such as the document number, company code, fiscal year, document date, posting date, and document type. Additionally, BKPF contains information on currency, reference numbers, and reversal status, providing a comprehensive overview that links to detailed line items stored in related tables like BSEG. By consolidating this high-level data, BKPF facilitates efficient management and retrieval of financial transactions within the SAP system.

SAP table BKPF, the "Accounting Document Header," is intrinsically linked to table BSEG, the "Accounting Document Segment." BKPF stores the header information of financial documents, encompassing general data such as document number, company code, fiscal year, and document date. In contrast, BSEG contains detailed line items or segments of these documents, capturing granular transaction data like account numbers, amounts, and specific transaction details. The relationship between BKPF and BSEG is hierarchical, where each entry in BKPF, identified by a unique document number, can correspond to multiple line items in BSEG. This structure allows for efficient organization and retrieval of financial document data, with BKPF providing the summary view and BSEG offering the detailed transactional perspective.

Linking accounting entries with subledgers and other record types in SAP

The fields AWKEY and AWTYP in SAP table BKPF play pivotal roles in linking accounting entries to other records within the SAP system. AWKEY, the "Reference Key," serves as a unique identifier that connects financial transactions in BKPF to corresponding records in other tables across different modules. AWTYP, the "Reference Transaction Type," specifies the type of transaction or document being referenced, further refining the linkage.

When a financial document involves transactions that need to be linked to other records, the combination of AWKEY and AWTYP fields is used to reference the specific documents in other tables. AWKEY provides the unique reference key, while AWTYP indicates the type of transaction or document, such as those related to asset accounting, material management, or other modules. This combination ensures that all financial postings related to various transactions are accurately tracked and easily retrievable for reporting and analysis. By leveraging AWKEY and AWTYP together, users can seamlessly integrate financial accounting data with other processes, providing a comprehensive and detailed view of an organization's financial activities and related records.

SAP table BKPF has 4 primary key fields: MANDT,BUKRS,BELNR,GJAHR.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

BKPF fields.

172 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key BUKRS Company CodeCHAR40 T001 BUKRS
Key BELNR Document Number of an Accounting DocumentCHAR100 BELNR_D
Key GJAHR Fiscal YearNUMC40 GJAHR
BLART Document TypeCHAR20 T003 BLART
BLDAT Document Date in DocumentDATS80 BLDAT
BUDAT Posting Date in the DocumentDATS80 BUDAT
MONAT Fiscal periodNUMC20 MONAT
CPUDT Day On Which Accounting Document Was EnteredDATS80 CPUDT
CPUTM Time of EntryTIMS60 CPUTM
AEDAT Date of the Last Document Change by TransactionDATS80 AEDAT_BKPF
UPDDT Date of the Last Document UpdateDATS80 UPDDT
WWERT Translation dateDATS80 WWERT_D
USNAM User NameCHAR120 USNAM
TCODE Transaction CodeCHAR200 TCODE
BVORG Number of Cross-Company Code Posting TransactionCHAR160 BVORG
XBLNR Reference Document NumberCHAR160 XBLNR1
DBBLG Recurring Entry Document NumberCHAR100 DBBLG
DBBLG_GJAHR Recurring Entry Document Fiscal YearNUMC40 DBBLG_GJAHR
DBBLG_BUKRS Recurring Entry Document Company CodeCHAR40 T001 DBBLG_BUKRS
STBLG Reverse Document NumberCHAR100 STBLG
STJAH Fiscal Year of Reversal DocumentNUMC40 STJAH
BKTXT Document Header TextCHAR250 BKTXT
WAERS Currency KeyCUKY50 TCURC WAERS
KURSF Exchange rateDEC95 KURSF
KZWRS Currency Key for the Group CurrencyCUKY50 TCURC KZWRS
KZKRS Group Currency Exchange RateDEC95 KZKRS
BSTAT Document StatusCHAR10 BSTAT_D
XNETB Indicator: Document posted net ?CHAR10 XNETB
FRATH Unplanned delivery costsCURR132 FRATH
XRUEB Indicator: Document Is Posted to a Previous PeriodCHAR10 XRUEB
GLVOR Business TransactionCHAR40 GLVOR
GRPID Batch Input Session NameCHAR120 GRPID_BKPF
DOKID Document Name in the Archive SystemCHAR400 DOKID_BKPF
ARCID Extract ID Document HeaderCHAR100 EXTID_BKPF
IBLAR Internal Document Type for Document ControlCHAR20 IBLAR
AWTYP Reference procedureCHAR50 AWTYP
AWKEY Reference KeyCHAR200 AWKEY
FIKRS Financial Management AreaCHAR40 FIKRS
HWAER Local CurrencyCUKY50 HWAER
HWAE2 Currency Key of Second Local CurrencyCUKY50 HWAE2
HWAE3 Currency Key of Third Local CurrencyCUKY50 HWAE3
KURS2 Exchange Rate for the Second Local CurrencyDEC95 KURS2
KURS3 Exchange Rate for the Third Local CurrencyDEC95 KURS3
BASW2 Source Currency for Currency TranslationCHAR10 CURSR
BASW3 Source Currency for Currency TranslationCHAR10 CURSR
UMRD2 Translation Date Type for Second Local CurrencyCHAR10 UMRD2
UMRD3 Translation Date Type for Third Local CurrencyCHAR10 UMRD3
XSTOV Indicator: Document Is Flagged for ReversalCHAR10 XSTOV
STODT Planned Date for the Reverse PostingDATS80 STODT
XMWST Calculate Tax AutomaticallyCHAR10 XMWST
CURT2 Currency Type of Second Local CurrencyCHAR20 CURT2
CURT3 Currency Type of Third Local CurrencyCHAR20 CURT3
KUTY2 Exchange Rate TypeCHAR40 TCURV KURST
KUTY3 Exchange Rate TypeCHAR40 TCURV KURST
XSNET G/L Account Amounts Entered Exclude TaxCHAR10 XSNET
AUSBK Source Company CodeCHAR40 T001 AUSBK
XUSVR TSP, Use, Sales Tax Entered on Detail ScreenCHAR10 XUSVR_BKPF
DUEFL Status of Data Transfer into Subsequent ReleaseCHAR10 DUEFL_BKPF
AWSYS Logical SystemCHAR100 LOGSYSTEM
TXKRS Exchange Rate for TaxesDEC95 TXKRS_BKPF
CTXKRS Rate for Tax Values in Reporting CurrencyDEC95 CTXKRS
LOTKZ Lot Number for RequestsCHAR100 PSO_LOTKZ
XWVOF Indicator: Customer Bill of Exchange Payment Before Due DateCHAR10 XWVOF
STGRD Reason for Reversal or Inverse PostingCHAR20 T041C STGRD
PPNAM Name of User Who Parked This DocumentCHAR120 PPNAM
PPDAT Day of Parking of Accounting DocumentDATS80 PPDATE
PPTME Time of ParkingTIMS60 PPTME
PPTCOD Parking TransactionCHAR200 PPTCOD
BRNCH Branch NumberCHAR40 PBUSINESSPLACE J_1ABRNCH
NUMPG Number of pages of invoiceNUMC30 J_1ANOPG
ADISC Indicator: entry represents a discount documentCHAR10 J_1ADISC
XREF1_HD Reference Key 1 Internal for Document HeaderCHAR200 XREF1_HD
XREF2_HD Reference Key 2 Internal for Document HeaderCHAR200 XREF2_HD
XREVERSAL Specifies Whether Document Is Reversal Doc. or Reversed Doc.CHAR10 XREVERSAL
REINDAT Invoice Receipt DateDATS80 REINDAT
RLDNR Ledger in General Ledger AccountingCHAR20 FINSC_LD_CMP FINS_LEDGER
LDGRP Ledger GroupCHAR40 FAGL_TLDGRP FAGL_LDGRP
PROPMANO Real Estate Management MandateCHAR130 RE_MANDAT
XBLNR_ALT Alternative Reference NumberCHAR260 XBLNR_ALT
VATDATE Tax Reporting DateDATS80 VATDATE
FULFILLDATE Tax Fulfillment DateDATS80 FOT_FULFILLDATE
DOCCAT Classification of an FI DocumentCHAR60 DOCUMENT_CATEGORY
XSPLIT FI Document Originates from Split Posting (Indicator)CHAR10 SPLIT_POSTING
CASH_ALLOC Cash-Relevant DocumentCHAR10 FAGL_CASH_ALLOC
FOLLOW_ON Follow-on document indicatorCHAR10 FAGL_FOLLOW_ON
XREORG Doc. Contains Open Item that Was Transferred During Reorg.CHAR10 FAGL_R_XDOC_REORG
SUBSET Defines Subset of Components for the FI/CO InterfaceCHAR40 ACC_SUBSET
KURST Exchange Rate TypeCHAR40 TCURV KURST
KURSX Market Data Exchange RateDEC2814 GLE_FXR_DTE_RATEX28
KUR2X Market Data Exchange Rate 2DEC2814 GLE_FXR_DTE_RATE2X28
KUR3X Market Data Exchange Rate 3DEC2814 GLE_FXR_DTE_RATE3X28
XMCA Document Originates from Multi Currency AccountingCHAR10 GLE_DTE_MCA_XMCA
RESUBMISSION Date of ResubmissionDATS80 FM_RESUBDAT
LOGSYSTEM_SENDER Logical System of the SenderCHAR100 LOGSYSTEM_SENDER
BUKRS_SENDER Company Code in Sender SystemCHAR40 BUKRS_SENDER
BELNR_SENDER Document Number of an Accounting Document in Sender SystemCHAR100 BELNR_SENDER
GJAHR_SENDER Fiscal Year of an Accounting Document in the Sender SystemNUMC40 GJAHR_SENDER
INTSUBID Internally Assigned SubID for AWKEYNUMC60 INTSUBID
AWORG_REV Reversal: Reference Organizations of Document to Be ReversedCHAR100 AWORG_REV
AWREF_REV Reversal: Reference Document No. of Document to Be ReversedCHAR100 AWREF_REV
XREVERSING Identifier for reversal documentCHAR10 CO_STFLG
XREVERSED Indicator: Document was reversedCHAR10 CO_STOKZ
GLBTGRP General Ledger Business Transaction GroupCHAR10 FINS_GLBTGRP
CO_VRGNG CO Business TransactionCHAR40 CO_VORGANG
CO_REFBT Document Type of Reference DocumentCHAR10 CO_REFBT
CO_ALEBN For ALE: CO Document Number in Generating SystemCHAR100 CO_ALEBN
CO_VALDT Special Valuation Date for Cost AccountingDATS80 CO_VALDT
CO_BELNR_SENDER CO Document Number of Controlling Document in Sender SystemCHAR100 COBELNR_SENDER
KOKRS_SENDER Controlling Area in Sender SystemCHAR40 KOKRS_SENDER
ACC_PRINCIPLE Accounting PrincipleCHAR40 ACCOUNTING_PRINCIPLE
_DATAAGING Data Filter Value for Data AgingDATS80 DATA_TEMPERATURE
TRAVA_PN Transfer Variant for Intercompany Asset TransfersCHAR40 * TRANSVAR
LDGRPSPEC_PN Indicator: Document Was Entered LDGRP-SpecificCHAR10 XLDGRPSPEC
AFABESPEC_PN Indicator: Posting with Area LimitationCHAR10 XAFABESPEC
XSECONDARY Secondary journal entryCHAR10 FINS_SECONDARY_ENTRY
REPROCESSING_STATUS_CODE Reprocessing status codeCHAR10 FINS_REPROCESSING_STATUS_CODE
TRR_PARTIAL_IND Partial Processing IndicatorCHAR10 FINS_TRR_PARTIAL_IND
ITEM_REMOVAL_STATUS Journal Entry Item Removal StatusCHAR10 FINS_ITEM_REMOVAL_STATUS
PENRC Reason for Late PaymentCHAR20 PENRC
GLO_REF1_HD Country/Region Specific Reference 1 in the DocumentCHAR800 FAC_GLO_REF1_HD
GLO_DAT1_HD Country/Region Specific Date 1 in the DocumentDATS80 FAC_GLO_DAT1_HD
GLO_REF2_HD Country/Region Specific Reference 2 in the DocumentCHAR250 FAC_GLO_REF2_HD
GLO_DAT2_HD Country/Region Specific Date 2 in the DocumentDATS80 FAC_GLO_DAT2_HD
GLO_REF3_HD Country/Region Specific Reference 3 in the DocumentCHAR250 FAC_GLO_REF3_HD
GLO_DAT3_HD Country/Region Specific Date 3 in the DocumentDATS80 FAC_GLO_DAT3_HD
GLO_REF4_HD Country/Region Specific Reference 4 in the DocumentCHAR500 FAC_GLO_REF4_HD
GLO_DAT4_HD Country/Region Specific Date 4 in the DocumentDATS80 FAC_GLO_DAT4_HD
GLO_REF5_HD Country/Region Specific Reference 5 in the DocumentCHAR500 FAC_GLO_REF5_HD
GLO_DAT5_HD Country/Region Specific Date 5 in the DocumentDATS80 FAC_GLO_DAT5_HD
GLO_BP1_HD Country/Region specific Business Partner 1 in the DocumentCHAR100 * FAC_GLO_BP1_HD
GLO_BP2_HD Country/Region Specific Business Partner 2 in the DocumentCHAR100 * FAC_GLO_BP2_HD
EV_POSTNG_CTRL Control Posting of Entry ViewCHAR10 FINS_ENTRY_VIEW_POSTNG_CONTROL
WHTDATE Withholding Tax Reporting DateDATS80 WHTDATE
CBTTYPE Business Transaction TypeCHAR40 FINS_CUSTBTTYPE
CLOSINGSTEP Closing stepNUMC30 FINS_CLOSINGSTEP
ANXTYPE Invoice TypeCHAR10 /ILE/TMTYP
ANXAMNT Annexation AmountCURR132 /ILE/TMANXA
ANXPERC Annexation PercentageDEC63 /ILE/TMANXP
ZVAT_INDC VAT indicator contain run date of vat fileDATS80 /ILE/TVAT_INDC
/SAPF15/STATUS Document StatusCHAR10 /SAPF15/STATUS
PSOTY Document category payment requestsCHAR20 PSOTP PSOTY_D
PSOAK ReasonCHAR100 PSO12 PSOAK
PSOKS RegionCHAR100 * PSOKS
PSOSG Reason for reversal - IS-PS requestsCHAR10 PSOSG
PSOFN IS-PS: File numberCHAR300 PSOFN
INTFORM Interest FormulaCHAR40 FM_INTFORM
INTDATE Interest Calc. DateDATS80 FM_INTDATE
PSOBT Posting DayDATS80 PSOBT
PSOZL Actual postingCHAR10 PSOZL
PSODT Last Changed OnDATS80 AEDAT
PSOTM Last changed atTIMS60 PSOTM
FM_UMART Type of Payment TransferCHAR10 FM_UMART
CCINS Payment cards: Card typeCHAR40 TCRIN CCINS_30F
CCNUM Payment cards: Card numberCHAR250 CCNUM_30F
SSBLK Payment Statistical Sampling BlockCHAR10 SSBLK
BATCH Lot Number for DocumentsCHAR100 LOTKZ
SNAME User NameCHAR120 UNAME
SAMPLED Sampled Invoice by Payment CertificationCHAR10 SAMPLED
EXCLUDE_FLAG PPA Exclude IndicatorCHAR10 EXCLUDE_FLG
BLIND Budgetary Ledger IndicatorCHAR10 FM_BLIND
OFFSET_STATUS Treasury Offset StatusCHAR20 FMFG_OFFSET_STATUS
OFFSET_REFER_DAT Date Record Referred to TreasuryDATS80 FMFG_REFERRED_OFFSET_DAT
KNUMV Number of the Document ConditionCHAR100 KNUMV
BLO Document blockCHAR10 PFM_1BLO
CNT Contract numberCHAR100 PFM_1CNT
PYBASTYP Type of Payment Basis DocumentCHAR20 SAFM_AP_PYBSTYP
PYBASNO Payment Basis Document NumberCHAR160 SAFM_AP_PYBSNO
PYBASDAT Payment Basis Document DateDATS80 SAFM_AP_PYBSDAT
PYIBAN IBAN (International Bank Account Number)CHAR340 IBAN
INWARDNO_HD Incoming Document NumberCHAR300 SAFM_AP_INWARD_NO
INWARDDT_HD Incoming Document DateDATS80 SAFM_AP_INWARD_DT
/ Relationships

BKPF relationships.

26 relationships
TableFieldCheck tableDescriptionCheck field
BKPFAUSBKT001Company CodesBUKRS
BKPFBLARTT003Document TypesMANDT
BKPFBRNCHPBUSINESSPLACEGenerated Table for ViewBUKRS
BKPFBRNCHPBUSINESSPLACEGenerated Table for ViewBRANCH
BKPFBUKRST001Company CodesBUKRS
BKPFCCINSTCRINPayment Cards: Card TypesMANDT
BKPFCCINSTCRINPayment Cards: Card TypesCCINS
BKPFDBBLG_BUKRST001Company CodesBUKRS
BKPFKURSTTCURVExchange rate types for currency translationMANDT
BKPFKURSTTCURVExchange rate types for currency translationKURST
BKPFKUTY2TCURVExchange rate types for currency translationMANDT
BKPFKUTY2TCURVExchange rate types for currency translationKURST
BKPFKUTY3TCURVExchange rate types for currency translationMANDT
BKPFKUTY3TCURVExchange rate types for currency translationKURST
BKPFKZWRSTCURCCurrency CodesMANDT
BKPFKZWRSTCURCCurrency CodesWAERS
BKPFLDGRPFAGL_TLDGRPLedger GroupLDGRP
BKPFMANDTT000ClientsMANDT
BKPFPSOAKPSO12Deduction reasonsMANDT
BKPFPSOAKPSO12Deduction reasonsPSOAK
BKPFRLDNRFINSC_LD_CMPCompCode-Dependent Settings for Univ. Journal Entry LedgerRLDNR
BKPFRLDNRFINSC_LD_CMPCompCode-Dependent Settings for Univ. Journal Entry LedgerBUKRS
BKPFSTGRDT041CReasons for Reverse PostingMANDT
BKPFSTGRDT041CReasons for Reverse PostingSTGRD
BKPFWAERSTCURCCurrency CodesMANDT
BKPFWAERSTCURCCurrency CodesWAERS