P_BKPF_COM

Journal Entry | view: PFIBKPFCOM | Extraction: Not supported | Component: Information System
Tables used: BKPF
Column Name Description
bukrs FK Company Code
belnr Journal Entry
gjahr Fiscal Year
Column Name Description
💲 Additional Currency 2 (hwae3):
frath Unplanned delivery costs
Column Name Description
Column Name Description
bldat Journal Entry Date
budat Posting Date
cpudt Accounting Document Entry Date
cputm Creation Time
aedat Date of the Last Document Change by Transaction
upddt Last Change Date
wwert Exchange Rate Date
stodt Planned Date for the Reversal Posting
reindat Invoice Receipt Date
vatdate Tax Reporting Date
fulfilldate Tax Fulfillment Date
resubmission Date of Resubmission
ppdat Day of Parking of Accounting Document
pptme Time of Parking
co_valdt Special Valuation Date for Cost Accounting
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
Column Name Description
bstat Journal Entry Category Show values
xnetb Net Amount Is Posted 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: Reversal Is Planned for Document Show values
xmwst Tax Is Automatically Calculated Show values
curt2 Currency Type of Second Local Currency Show values
curt3 Currency Type of Third Local Currency Show values
xsnet Tax Base Amount is Net Amount 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
doccat Accounting Document Class 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 Indicator: Item is Reversing Another Item Show values
xreversed Indicator: Item is Reversed Show values
reprocessing_status_code Reprocessing status code Show values
IsBudgetaryLedgerDoc Budgetary Ledger Indicator Show values
Column Name Description Domain name
monat null
usnam User that created the journal entry
tcode Transaction Code TCODE
bvorg Intercompany Transaction Number BVORG
xblnr Document Reference ID XBLNR1
dbblg Recurring Journal Entry BELNR
stblg Reverse Document BELNR
stjah Reverse Document Fiscal Year GJAHR
bktxt Document Header Text TEXT25
kursf Exchange Rate UKURS
kzkrs Group Currency Exchange Rate KURSF
glvor Business Transaction Category FINS_BTTYPE
grpid Batch Input Session 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 Document Type AWTYP
awkey Object 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 Tax Exchange Rate KURSF
lotkz Lot Number for Requests LOTKZ
ppnam Name of User Who Parked This Document XUBNAME
numpg Number of pages of invoice J_1ANOPG
xref1_hd Internal ID of Reference Key 1 in Document Header CHAR20
xref2_hd Internal ID of Reference Key 2 in Document Header CHAR20
propmano Real Estate Management Mandate FIS_RE_MANDAT
xblnr_alt Alternative Reference Document 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 Sender Logical System LOGSYS
bukrs_sender Company Code in Sender System CHAR4
belnr_sender Sender Journal Entry BELNR
gjahr_sender Fiscal Year of an Accounting Document in the Sender System GJAHR
aworg_rev Reversal: Reference Organizations of Document to Be Reversed AWORG
awref_rev Reversal: Reference Document No. of Document to Be Reversed AWREF
ccnum Payment cards: Card number CCNUM_30F
penrc Late Payment Reason CHAR2
knumv Sales Document Condition KNUMV
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
Master Data Relations Join Conditions
Source Company Code
  • Source Company Code
  • Client
  • P_BKPF_COM.AUSBK == T001.BUKRS
  • P_BKPF_COM.MANDT == T001.MANDT
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_BKPF_COM.MANDT == T003.MANDT
  • P_BKPF_COM.BLART == T003.BLART
Company Code
  • Client
  • Company Code
  • P_BKPF_COM.MANDT == T001.MANDT
  • P_BKPF_COM.BUKRS == T001.BUKRS
Payment cards: Card type
  • Payment cards: Card type
  • Client
  • P_BKPF_COM.CCINS == TCRIN.CCINS
  • P_BKPF_COM.MANDT == TCRIN.MANDT
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • P_BKPF_COM.MANDT == TCURV.MANDT
  • P_BKPF_COM.KURST == TCURV.KURST
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • P_BKPF_COM.MANDT == TCURV.MANDT
  • P_BKPF_COM.KUTY2 == TCURV.KURST
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • P_BKPF_COM.MANDT == TCURV.MANDT
  • P_BKPF_COM.KUTY3 == TCURV.KURST
Currency Key for the Group Currency
  • Client
  • Currency Key for the Group Currency
  • P_BKPF_COM.MANDT == TCURC.MANDT
  • P_BKPF_COM.KZWRS == TCURC.WAERS
Ledger Group
  • Ledger Group
  • Client
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • P_BKPF_COM.MANDT == T041C.MANDT
  • P_BKPF_COM.STGRD == T041C.STGRD
Currency Key
  • Client
  • Currency Key
  • P_BKPF_COM.MANDT == TCURC.MANDT
  • P_BKPF_COM.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Client
  • Ledger
  • Company Code