BKPF

Accounting Document Header | #header | Component: Financial Accounting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
Column Name Description
💲 Currency Key (T001.WAERS):
FRATH Unplanned delivery costs
ANXAMNT Annexation Amount
Column Name Description
Column Name Description
BLDAT Document Date in Document
BUDAT Posting Date in the Document
CPUDT Day On Which Accounting Document Was Entered
CPUTM Time of Entry
AEDAT Date of the Last Document Change by Transaction
UPDDT Date of the Last Document Update
WWERT Translation date
STODT Planned Date for the Reverse Posting
PPDAT Day of Parking of Accounting Document
PPTME Time of Parking
REINDAT Invoice Receipt Date
VATDATE Tax Reporting Date
FULFILLDATE Tax Fulfillment Date
RESUBMISSION Date of Resubmission
CO_VALDT Special Valuation Date for Cost Accounting
_DATAAGING Data Filter Value for Data Aging
GLO_DAT1_HD Country/Region Specific Date 1 in the Document
GLO_DAT2_HD Country/Region Specific Date 2 in the Document
GLO_DAT3_HD Country/Region Specific Date 3 in the Document
GLO_DAT4_HD Country/Region Specific Date 4 in the Document
GLO_DAT5_HD Country/Region Specific Date 5 in the Document
WHTDATE Withholding Tax Reporting Date
ZVAT_INDC VAT indicator contain run date of vat file
INTDATE Interest Calc. Date
PSOBT Posting Day
PSODT Last Changed On
PSOTM Last changed at
OFFSET_REFER_DAT Date Record Referred to Treasury
PYBASDAT Payment Basis Document Date
INWARDDT_HD Incoming Document Date
Column Name Description
BSTAT Document Status Show values
XNETB Indicator: Document posted net ? Show values
XRUEB Indicator: Document Is Posted to a Previous Period Show values
BASW2 Source Currency for Currency Translation Show values
BASW3 Source Currency for Currency Translation Show values
UMRD2 Translation Date Type for Second Local Currency Show values
UMRD3 Translation Date Type for Third Local Currency Show values
XSTOV Indicator: Document Is Flagged for Reversal Show values
XMWST Calculate Tax Automatically Show values
CURT2 Currency Type of Second Local Currency Show values
CURT3 Currency Type of Third Local Currency Show values
XSNET G/L Account Amounts Entered Exclude Tax Show values
XUSVR TSP, Use, Sales Tax Entered on Detail Screen Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
XWVOF Indicator: Customer Bill of Exchange Payment Before Due Date Show values
ADISC Indicator: entry represents a discount document Show values
XREVERSAL Specifies Whether Document Is Reversal Doc. or Reversed Doc. Show values
DOCCAT Classification of an FI Document Show values
XSPLIT FI Document Originates from Split Posting (Indicator) Show values
CASH_ALLOC Cash-Relevant Document Show values
FOLLOW_ON Follow-on document indicator Show values
XREORG Doc. Contains Open Item that Was Transferred During Reorg. Show values
SUBSET Defines Subset of Components for the FI/CO Interface Show values
XMCA Document Originates from Multi Currency Accounting Show values
XREVERSING Identifier for reversal document Show values
XREVERSED Indicator: Document was reversed Show values
GLBTGRP General Ledger Business Transaction Group Show values
CO_REFBT Document Type of Reference Document Show values
LDGRPSPEC_PN Indicator: Document Was Entered LDGRP-Specific Show values
AFABESPEC_PN Indicator: Posting with Area Limitation Show values
XSECONDARY Secondary journal entry Show values
REPROCESSING_STATUS_CODE Reprocessing status code Show values
TRR_PARTIAL_IND Partial Processing Indicator Show values
ITEM_REMOVAL_STATUS Journal Entry Item Removal Status Show values
EV_POSTNG_CTRL Control Posting of Entry View Show values
ANXTYPE Invoice Type Show values
PSOSG Reason for reversal - IS-PS requests Show values
PSOZL Actual posting Show values
FM_UMART Type of Payment Transfer Show values
SSBLK Payment Statistical Sampling Block Show values
SAMPLED Sampled Invoice by Payment Certification Show values
EXCLUDE_FLAG PPA Exclude Indicator Show values
BLIND Budgetary Ledger Indicator Show values
OFFSET_STATUS Treasury Offset Status Show values
Column Name Description Domain name
MONAT Fiscal period MONAT
USNAM User Name XUBNAME
TCODE Transaction Code TCODE
BVORG Number of Cross-Company Code Posting Transaction BVORG
XBLNR Reference Document Number XBLNR1
DBBLG Recurring Entry Document Number BELNR
DBBLG_GJAHR Recurring Entry Document Fiscal Year GJAHR
STBLG Reverse Document Number BELNR
STJAH Fiscal Year of Reversal Document GJAHR
BKTXT Document Header Text TEXT25
KURSF Exchange rate KURSF
KZKRS Group Currency Exchange Rate KURSF
GLVOR Business Transaction CHAR4
GRPID Batch Input Session Name CHAR12
DOKID Document Name in the Archive System CHAR40
ARCID Extract ID Document Header CHAR10
IBLAR Internal Document Type for Document Control IBLAR
AWTYP Reference procedure AWTYP
AWKEY Reference Key AWKEY
FIKRS Financial Management Area FIKRS
KURS2 Exchange Rate for the Second Local Currency KURSF
KURS3 Exchange Rate for the Third Local Currency KURSF
AWSYS Logical System LOGSYS
TXKRS Exchange Rate for Taxes KURSF
CTXKRS Rate for Tax Values in Reporting Currency KURSF
LOTKZ Lot Number for Requests LOTKZ
PPNAM Name of User Who Parked This Document XUBNAME
PPTCOD Parking Transaction TCODE
NUMPG Number of pages of invoice J_1ANOPG
XREF1_HD Reference Key 1 Internal for Document Header CHAR20
XREF2_HD Reference Key 2 Internal for Document Header CHAR20
PROPMANO Real Estate Management Mandate RE_MANDAT
XBLNR_ALT Alternative Reference Number XBLNR_ALT
KURSX Market Data Exchange Rate GLE_FXR_RATEX28
KUR2X Market Data Exchange Rate 2 GLE_FXR_RATEX28
KUR3X Market Data Exchange Rate 3 GLE_FXR_RATEX28
LOGSYSTEM_SENDER Logical System of the Sender LOGSYS
BUKRS_SENDER Company Code in Sender System CHAR4
BELNR_SENDER Document Number of an Accounting Document in Sender System BELNR
GJAHR_SENDER Fiscal Year of an Accounting Document in the Sender System GJAHR
INTSUBID Internally Assigned SubID for AWKEY INTSUBID
AWORG_REV Reversal: Reference Organizations of Document to Be Reversed AWORG
AWREF_REV Reversal: Reference Document No. of Document to Be Reversed AWREF
CO_VRGNG CO Business Transaction J_VORGANG
CO_ALEBN For ALE: CO Document Number in Generating System BELNR
CO_BELNR_SENDER CO Document Number of Controlling Document in Sender System CO_BELNR
KOKRS_SENDER Controlling Area in Sender System CACCD
ACC_PRINCIPLE Accounting Principle ACCOUNTING_PRINCIPLE
TRAVA_PN Transfer Variant for Intercompany Asset Transfers TRANSVAR
PENRC Reason for Late Payment CHAR2
GLO_REF1_HD Country/Region Specific Reference 1 in the Document FAC_GLO_REF1_HD
GLO_REF2_HD Country/Region Specific Reference 2 in the Document FAC_GLO_REF2_HD
GLO_REF3_HD Country/Region Specific Reference 3 in the Document FAC_GLO_REF3_HD
GLO_REF4_HD Country/Region Specific Reference 4 in the Document FAC_GLO_REF4_HD
GLO_REF5_HD Country/Region Specific Reference 5 in the Document FAC_GLO_REF5_HD
GLO_BP1_HD Country/Region specific Business Partner 1 in the Document BU_PARTNER
GLO_BP2_HD Country/Region Specific Business Partner 2 in the Document BU_PARTNER
CBTTYPE Business Transaction Type FINS_CUSTBTTYPE
CLOSINGSTEP Closing step FINS_CLOSINGSTEP
ANXPERC Annexation Percentage DEC3_3V
/SAPF15/STATUS Document Status /SAPF15/STATUS
PSOKS Region PSOKS
PSOFN IS-PS: File number CHAR30
INTFORM Interest Formula CHAR4
CCNUM Payment cards: Card number CCNUM_30F
BATCH Lot Number for Documents LOTKZ
SNAME User Name UNAME
KNUMV Number of the Document Condition KNUMV
BLO Document block CHAR1
CNT Contract number BELNR
PYBASTYP Type of Payment Basis Document SAFM_AP_PYBSTYP
PYBASNO Payment Basis Document Number SAFM_AP_PYBSNO
PYIBAN IBAN (International Bank Account Number) IBAN
INWARDNO_HD Incoming Document Number
Master Data Relations Join Conditions
Source Company Code
  • BKPF.MANDT == T001.MANDT
  • BKPF.AUSBK == T001.BUKRS
Document Type
  • Document Type
  • Client
  • BKPF.BLART == T003.BLART
  • BKPF.MANDT == T003.MANDT
Company Code
  • BKPF.MANDT == T001.MANDT
  • BKPF.BUKRS == T001.BUKRS
Payment cards: Card type
  • Payment cards: Card type
  • Client
  • BKPF.CCINS == TCRIN.CCINS
  • BKPF.MANDT == TCRIN.MANDT
Recurring Entry Document Company Code
  • BKPF.MANDT == T001.MANDT
  • BKPF.DBBLG_BUKRS == T001.BUKRS
Exchange Rate Type
  • BKPF.MANDT == TCURV.MANDT
  • BKPF.KURST == TCURV.KURST
Exchange Rate Type
  • BKPF.MANDT == TCURV.MANDT
  • BKPF.KUTY2 == TCURV.KURST
Exchange Rate Type
  • BKPF.MANDT == TCURV.MANDT
  • BKPF.KUTY3 == TCURV.KURST
Currency Key for the Group Currency
  • BKPF.MANDT == TCURC.MANDT
  • BKPF.KZWRS == TCURC.WAERS
Ledger Group
  • Ledger Group
  • Client
Client BKPF.MANDT == T000.MANDT
Reason
  • BKPF.MANDT == PSO12.MANDT
  • BKPF.PSOAK == PSO12.PSOAK
Document category payment requests BKPF.PSOTY == PSOTP.PSOTYP
Reason for Reversal or Inverse Posting
  • Reason for Reversal or Inverse Posting
  • Client
  • BKPF.STGRD == T041C.STGRD
  • BKPF.MANDT == T041C.MANDT
Currency Key
  • BKPF.MANDT == TCURC.MANDT
  • BKPF.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger in General Ledger Accounting
  • Company Code
  • Client
  • Ledger in General Ledger Accounting