SAP table VBKPF (Document Header for Document Parking)

SAP table VBKPF has 5 primary key fields being MANDT,AUSBK,BUKRS,BELNR,GJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
AUSBK Source Company Code CHAR 4 0 AUSBK
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BSTAT Document Status CHAR 1 0 BSTAT_D
BLART Document Type CHAR 2 0 T003 BLART
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
MONAT Fiscal period NUMC 2 0 MONAT
WWERT Translation date DATS 8 0 WWERT_D
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
AEDAT Date of the Last Document Change DATS 8 0 AEDT_VBKPF
UPDDT Date of the Last Document Update DATS 8 0 UPDDT
USNAM User Name CHAR 12 0 USNM_VBKPF
TCODE Transaction Code CHAR 20 0 TCODE
BVORG Number of Cross-Company Code Posting Transaction CHAR 16 0 BVORG
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BKTXT Document Header Text CHAR 25 0 BKTXT
FIKRS Financial Management Area CHAR 4 0 FIKRS
KOARS Account Types Allowed CHAR 5 0 KOARS_003
XBSET Tax Information Exists in the Document CHAR 1 0 XBSET
XSNET G/L Account Amounts Entered Exclude Tax CHAR 1 0 XSNET
XBWAE Only Transfer Document in Document Currency When Posting CHAR 1 0 XBWAE
WAERS Currency Key CUKY 5 0 WAERS
HWAER Local Currency CUKY 5 0 HWAER
HWAE2 Currency Key of Second Local Currency CUKY 5 0 HWAE2
HWAE3 Currency Key of Third Local Currency CUKY 5 0 HWAE3
KURSF Exchange rate DEC 9 5 KURSF
KURS2 Exchange Rate for the Second Local Currency DEC 9 5 KURS2
KURS3 Exchange Rate for the Third Local Currency DEC 9 5 KURS3
BASW2 Source Currency for Currency Translation CHAR 1 0 CURSR
1 Translation taking transaction currency as a basis
2 Translation taking first local currency as a basis
BASW3 Source Currency for Currency Translation CHAR 1 0 CURSR
1 Translation taking transaction currency as a basis
2 Translation taking first local currency as a basis
UMRD2 Translation Date Type for Second Local Currency CHAR 1 0 UMRD2
UMRD3 Translation Date Type for Third Local Currency CHAR 1 0 UMRD3
CURT2 Currency Type of Second Local Currency CHAR 2 0 CURT2
CURT3 Currency Type of Third Local Currency CHAR 2 0 CURT3
KUTY2 Exchange Rate Type CHAR 4 0 KURST
KUTY3 Exchange Rate Type CHAR 4 0 KURST
XMWST Calculate Tax Automatically CHAR 1 0 XMWST
PARGB Partner Business Area Default Value CHAR 4 0 TGSB PGBVW
VBLNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
VGJHR Fiscal Year NUMC 4 0 GJAHR
XFRGE Released CHAR 1 0 XFRGE
XPRFG Document Complete CHAR 1 0 XPRFG
FRATH Unplanned delivery costs CURR 13 2 FRATH
XWFFR Release Required CHAR 1 0 XWFFR
LOTKZ Lot Number for Requests CHAR 10 0 PSO_LOTKZ
FRWEG Release Approval Path CHAR 4 0 VBWF03 FRWEG
UPDTM Time of Entry TIMS 6 0 CPUTM
RELDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
RELTM Time of Entry TIMS 6 0 CPUTM
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
SUBN1_LVL Amount Release Approval Levels NUMC 2 0 SUBN1_LVL
BRNCH Branch Number CHAR 4 0 J_1BBRANCH J_1ABRNCH
NUMPG Number of pages of invoice NUMC 3 0 J_1ANOPG
USCMP Completed By CHAR 12 0 USCMP
USREL Released By CHAR 12 0 USREL
USUPD Changed By CHAR 12 0 USUPD
XINVR_CURV Indicator: Calculation allowed with inverted exchange rate ? CHAR 1 0 XINVR_CURV
AWTYP Reference procedure CHAR 5 0 AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
AWSYS Logical System CHAR 10 0 LOGSYSTEM
REINDAT Invoice Receipt Date DATS 8 0 REINDAT
TXKRS Exchange Rate for Taxes DEC 9 5 TXKRS_BKPF
CTXKRS Rate for Tax Values in Reporting Currency DEC 9 5 CTXKRS
PROPMANO Real Estate Management Mandate CHAR 13 0 RE_MANDAT
LDGRP Ledger Group CHAR 4 0 FAGL_LDGRP
VATDATE Tax Reporting Date DATS 8 0 VATDATE
FULFILLDATE Tax Fulfillment Date DATS 8 0 FOT_FULFILLDATE
KURSX Market Data Exchange Rate DEC 28 14 GLE_FXR_DTE_RATEX28
KUR2X Market Data Exchange Rate 2 DEC 28 14 GLE_FXR_DTE_RATE2X28
KUR3X Market Data Exchange Rate 3 DEC 28 14 GLE_FXR_DTE_RATE3X28
XMCA Document Originates from Multi Currency Accounting CHAR 1 0 GLE_DTE_MCA_XMCA
GRPID Batch Input Session Name CHAR 12 0 GRPID_BKPF
XREF1_HD Reference Key 1 Internal for Document Header CHAR 20 0 XREF1_HD
STODT Planned Date for the Reverse Posting DATS 8 0 STODT
STGRD Reason for Reversal or Inverse Posting CHAR 2 0 STGRD
GLO_REF1_HD Country/Region Specific Reference 1 in the Document CHAR 80 0 FAC_GLO_REF1_HD
GLO_DAT1_HD Country/Region Specific Date 1 in the Document DATS 8 0 FAC_GLO_DAT1_HD
GLO_REF2_HD Country/Region Specific Reference 2 in the Document CHAR 25 0 FAC_GLO_REF2_HD
GLO_DAT2_HD Country/Region Specific Date 2 in the Document DATS 8 0 FAC_GLO_DAT2_HD
GLO_REF3_HD Country/Region Specific Reference 3 in the Document CHAR 25 0 FAC_GLO_REF3_HD
GLO_DAT3_HD Country/Region Specific Date 3 in the Document DATS 8 0 FAC_GLO_DAT3_HD
GLO_REF4_HD Country/Region Specific Reference 4 in the Document CHAR 50 0 FAC_GLO_REF4_HD
GLO_DAT4_HD Country/Region Specific Date 4 in the Document DATS 8 0 FAC_GLO_DAT4_HD
GLO_REF5_HD Country/Region Specific Reference 5 in the Document CHAR 50 0 FAC_GLO_REF5_HD
GLO_DAT5_HD Country/Region Specific Date 5 in the Document DATS 8 0 FAC_GLO_DAT5_HD
GLO_BP1_HD Country/Region specific Business Partner 1 in the Document CHAR 10 0 * FAC_GLO_BP1_HD
GLO_BP2_HD Country/Region Specific Business Partner 2 in the Document CHAR 10 0 * FAC_GLO_BP2_HD
ANXTYPE Invoice Type CHAR 1 0 /ILE/TMTYP
EXCLUDE_FLAG PPA Exclude Indicator CHAR 1 0 EXCLUDE_FLG
PSOTY Document category payment requests CHAR 2 0 PSOTP PSOTY_D
PSOAK Reason CHAR 10 0 PSO12 PSOAK
PSOKS Region CHAR 10 0 * PSOKS
PSOSG Reason for reversal - IS-PS requests CHAR 1 0 PSOSG
1 Deferral reversed
2 Short-Term Waiver
3 Remission
4 Deferral -> can be archived
5 Temporary waiver -> can be archived
6 New Document from Deferral Reversal
PSOFN IS-PS: File number CHAR 30 0 PSOFN
INTFORM Interest Formula CHAR 4 0 FM_INTFORM
INTDATE Interest Calc. Date DATS 8 0 FM_INTDATE
PSODT Last Changed On DATS 8 0 AEDAT
PSOTM Last changed at TIMS 6 0 PSOTM
DBBLG Recurring Entry Document Number CHAR 10 0 DBBLG
PSOXWF Release via request Workflow required CHAR 1 0 PSOXWF
RESUBMISSION Date of Resubmission DATS 8 0 FM_RESUBDAT
PYBASTYP Type of Payment Basis Document CHAR 2 0 SAFM_AP_PYBSTYP
PYBASNO Payment Basis Document Number CHAR 16 0 SAFM_AP_PYBSNO
PYBASDAT Payment Basis Document Date DATS 8 0 SAFM_AP_PYBSDAT
PYIBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
INWARDNO_HD Incoming Document Number CHAR 30 0 SAFM_AP_INWARD_NO
INWARDDT_HD Incoming Document Date DATS 8 0 SAFM_AP_INWARD_DT
CCINS Payment cards: Card type CHAR 4 0 TCRIN CCINS_30F
CCNUM Payment cards: Card number CHAR 25 0 CCNUM_30F

VBKPF foreign key relationships

Table Field Check Table Check Field
0 VBKPF BLART T003 Document Types MANDT
1 VBKPF BRNCH J_1BBRANCH Business Place BUKRS
1 VBKPF BRNCH J_1BBRANCH Business Place BRANCH
1 VBKPF BRNCH J_1BBRANCH Business Place BUPLA_TYPE
0 VBKPF CCINS TCRIN Payment Cards: Card Types MANDT
0 VBKPF CCINS TCRIN Payment Cards: Card Types CCINS
1 VBKPF FRWEG VBWF03 Release Approval Paths MANDT
1 VBKPF FRWEG VBWF03 Release Approval Paths FRWEG
0 VBKPF PARGB TGSB Business Areas MANDT
0 VBKPF PARGB TGSB Business Areas GSBER
1 VBKPF PSOAK PSO12 Deduction reasons MANDT
1 VBKPF PSOAK PSO12 Deduction reasons PSOAK