VBKPF

Transparent Table Application Table
113 Fields 18 CDS Views

Document Header for Document Parking

VBKPF is an SAP database table in S/4HANA. Document Header for Document Parking. It contains 113 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
Facvd_Wf_Set_Amount_Doc view from set amount to document
FCLM_VBSEG_PRJK view inner VBSEG Projection
FGL_LIB_P_DOC_HEADER view from Parked Items: Document Header
fiscds_evpad_01 view inner Line Item Browser: DDL Source
FISVD_DOCNR_GAP_PARK_AA view from Asset Park Document Data
FISVD_DOCNR_GAP_PARK_CUSTOMER view from Customer Park Document Data
FISVD_DOCNR_GAP_PARK_GL view from G/L Park Document Data
FISVD_DOCNR_GAP_PARK_VENDOR view from Vendor Park Document Data
I_ParkedAccountingDocument view from BASIC Parked Accounting Document
I_ParkedMCAJournalEntry view inner BASIC Parked MCA Journal Entry details
I_ParkedOplAcctgDocument view_entity from BASIC Parked Accounting Document
I_ParkedPayablesItem view inner BASIC Parked Payables Item
I_ParkedReceivablesItem view inner BASIC Parked Receivables Item
P_DOCLATESTWORKFLOW view from BASIC
P_Facvd_Ver_Diag_Max_Timestamp view from BASIC
P_FACVD_WF_STATUS_MAX_TS view from BASIC
P_Facvd_Wf_Task_Max_Timestamp view from BASIC
P_VBKPF_COM view from BASIC

Fields (113)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ausbk AUSBK Source CoCode
KEY bukrs BUKRS Company Code
KEY belnr BELNR_D Document Number
KEY gjahr GJAHR Fiscal Year
bstat BSTAT_D Document Status
blart BLART Document Type
bldat BLDAT Document Date
budat BUDAT Posting Date
monat MONAT Period
wwert WWERT_D Translatn Date
cpudt CPUDT Entered On
cputm CPUTM Entered at
aedat AEDT_VBKPF Changed On
upddt UPDDT Last Update
usnam USNM_VBKPF User
tcode TCODE Transaction Code
bvorg BVORG Cross-CC Number
xblnr XBLNR1 Reference
bktxt BKTXT Doc.Header Text
fikrs FIKRS FM Area
koars KOARS_003 Account Types
xbset XBSET Tax
xsnet XSNET Net Entry
xbwae XBWAE Doc. Currency
waers WAERS Currency
hwaer HWAER Local Currency
hwae2 HWAE2 Local curr. 2
hwae3 HWAE3 Local curr. 3
kursf KURSF Exchange rate
kurs2 KURS2 Exchange Rate 2
kurs3 KURS3 Exchange Rate 3
basw2 CURSR Source Currency
basw3 CURSR Source Currency
umrd2 UMRD2 Trans. Date
umrd3 UMRD3 Trans. Date
curt2 CURT2 LC2 Crcy Type
curt3 CURT3 LC3 Crcy Type
kuty2 KURST Exch. Rate Type
kuty3 KURST Exch. Rate Type
xmwst XMWST Calculate Tax
pargb PGBVW Par. BA. Def.
vblnr BELNR_D Document Number
vgjhr GJAHR Fiscal Year
xfrge XFRGE Released
xprfg XPRFG Doc. Complete
frath FRATH Unpl.del.costs
xwffr XWFFR Release Req.
lotkz PSO_LOTKZ Request Number
frweg FRWEG Rel. Appr. Path
updtm CPUTM Entered at
reldt CPUDT Entered On
reltm CPUTM Entered at
vbund RASSC Trading Partner
subn1_lvl SUBN1_LVL Release Levels
brnch J_1ABRNCH Branch number
numpg J_1ANOPG Number of Pages
uscmp USCMP Completed By
usrel USREL Released By
usupd USUPD Changed By
xinvr_curv XINVR_CURV Inverse
awtyp AWTYP Ref. procedure
awkey AWKEY Reference Key
awsys LOGSYSTEM Logical System
reindat REINDAT Inv. Recpt Date
txkrs TXKRS_BKPF Rate for Taxes
ctxkrs CTXKRS Tax Rate: RC
propmano RE_MANDAT Mandate
ldgrp FAGL_LDGRP Ledger Group
vatdate VATDATE Tax Reporting Date
fulfilldate FOT_FULFILLDATE Tax Fulfill. Date
kursx GLE_FXR_DTE_RATEX28 MD Exchange Rate
kur2x GLE_FXR_DTE_RATE2X28 MD Exch. Rate 2
kur3x GLE_FXR_DTE_RATE3X28 MD Exch. Rate 3
xmca GLE_DTE_MCA_XMCA Doc. from MCA
grpid GRPID_BKPF Session Name
xref1_hd XREF1_HD Ref.key(head) 1
stodt STODT Reversal Date
stgrd STGRD Reversal Reason
glo_ref1_hd FAC_GLO_REF1_HD Country/Region Specific Reference 1
glo_dat1_hd FAC_GLO_DAT1_HD Country/Region Specific Date 1
glo_ref2_hd FAC_GLO_REF2_HD Country/Region Specific Reference 2
glo_dat2_hd FAC_GLO_DAT2_HD Country/Region Specific Date 2
glo_ref3_hd FAC_GLO_REF3_HD Country/Region Specific Reference 3
glo_dat3_hd FAC_GLO_DAT3_HD Country/Region Specific Date 3
glo_ref4_hd FAC_GLO_REF4_HD Country/Region Specific Reference 4
glo_dat4_hd FAC_GLO_DAT4_HD Country/Region Specific Date 4
glo_ref5_hd FAC_GLO_REF5_HD Country/Region Specific Reference 5
glo_dat5_hd FAC_GLO_DAT5_HD Country/Region Specific Date 5
glo_bp1_hd FAC_GLO_BP1_HD Ctry/Reg. Specific Business Partner 1
glo_bp2_hd FAC_GLO_BP2_HD Ctry/Reg. Specific Business Partner 2
anxtype /ILE/TMTYP invoice type
exclude_flag EXCLUDE_FLG PPA Exclude
psoty PSOTY_D Request Cat.
psoak PSOAK Reason
psoks PSOKS Region
psosg PSOSG Reversal reason
psofn PSOFN File number
intform FM_INTFORM Int.formula
intdate FM_INTDATE Interest Calc. Date
psodt AEDAT Changed On
psotm PSOTM Changed at
dbblg DBBLG Rec.Entry Doc.
psoxwf PSOXWF Release Request
resubmission FM_RESUBDAT Resubmission Date
pybastyp SAFM_AP_PYBSTYP Payt. Against
pybasno SAFM_AP_PYBSNO Payt. Ground No.
pybasdat SAFM_AP_PYBSDAT Payt. Ground Date
pyiban IBAN IBAN
inwardno_hd SAFM_AP_INWARD_NO Incg Doc. Nmbr
inwarddt_hd SAFM_AP_INWARD_DT Incg Doc. Date
ccins CCINS_30F Card type
ccnum CCNUM_30F Card Number

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Document Header for Document Parking
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBKPF (
    MANDT,         -- Client [MANDT]
    AUSBK,         -- Source CoCode [AUSBK]
    BUKRS,         -- Company Code [BUKRS]
    BELNR,         -- Document Number [BELNR_D]
    GJAHR,         -- Fiscal Year [GJAHR]
    BSTAT,         -- Document Status [BSTAT_D]
    BLART,         -- Document Type [BLART]
    BLDAT,         -- Document Date [BLDAT]
    BUDAT,         -- Posting Date [BUDAT]
    MONAT,         -- Period [MONAT]
    WWERT,         -- Translatn Date [WWERT_D]
    CPUDT,         -- Entered On [CPUDT]
    CPUTM,         -- Entered at [CPUTM]
    AEDAT,         -- Changed On [AEDT_VBKPF]
    UPDDT,         -- Last Update [UPDDT]
    USNAM,         -- User [USNM_VBKPF]
    TCODE,         -- Transaction Code [TCODE]
    BVORG,         -- Cross-CC Number [BVORG]
    XBLNR,         -- Reference [XBLNR1]
    BKTXT,         -- Doc.Header Text [BKTXT]
    FIKRS,         -- FM Area [FIKRS]
    KOARS,         -- Account Types [KOARS_003]
    XBSET,         -- Tax [XBSET]
    XSNET,         -- Net Entry [XSNET]
    XBWAE,         -- Doc. Currency [XBWAE]
    WAERS,         -- Currency [WAERS]
    HWAER,         -- Local Currency [HWAER]
    HWAE2,         -- Local curr. 2 [HWAE2]
    HWAE3,         -- Local curr. 3 [HWAE3]
    KURSF,         -- Exchange rate [KURSF]
    KURS2,         -- Exchange Rate 2 [KURS2]
    KURS3,         -- Exchange Rate 3 [KURS3]
    BASW2,         -- Source Currency [CURSR]
    BASW3,         -- Source Currency [CURSR]
    UMRD2,         -- Trans. Date [UMRD2]
    UMRD3,         -- Trans. Date [UMRD3]
    CURT2,         -- LC2 Crcy Type [CURT2]
    CURT3,         -- LC3 Crcy Type [CURT3]
    KUTY2,         -- Exch. Rate Type [KURST]
    KUTY3,         -- Exch. Rate Type [KURST]
    XMWST,         -- Calculate Tax [XMWST]
    PARGB,         -- Par. BA. Def. [PGBVW]
    VBLNR,         -- Document Number [BELNR_D]
    VGJHR,         -- Fiscal Year [GJAHR]
    XFRGE,         -- Released [XFRGE]
    XPRFG,         -- Doc. Complete [XPRFG]
    FRATH,         -- Unpl.del.costs [FRATH]
    XWFFR,         -- Release Req. [XWFFR]
    LOTKZ,         -- Request Number [PSO_LOTKZ]
    FRWEG,         -- Rel. Appr. Path [FRWEG]
    UPDTM,         -- Entered at [CPUTM]
    RELDT,         -- Entered On [CPUDT]
    RELTM,         -- Entered at [CPUTM]
    VBUND,         -- Trading Partner [RASSC]
    SUBN1_LVL,     -- Release Levels [SUBN1_LVL]
    BRNCH,         -- Branch number [J_1ABRNCH]
    NUMPG,         -- Number of Pages [J_1ANOPG]
    USCMP,         -- Completed By [USCMP]
    USREL,         -- Released By [USREL]
    USUPD,         -- Changed By [USUPD]
    XINVR_CURV,    -- Inverse [XINVR_CURV]
    AWTYP,         -- Ref. procedure [AWTYP]
    AWKEY,         -- Reference Key [AWKEY]
    AWSYS,         -- Logical System [LOGSYSTEM]
    REINDAT,       -- Inv. Recpt Date [REINDAT]
    TXKRS,         -- Rate for Taxes [TXKRS_BKPF]
    CTXKRS,        -- Tax Rate: RC [CTXKRS]
    PROPMANO,      -- Mandate [RE_MANDAT]
    LDGRP,         -- Ledger Group [FAGL_LDGRP]
    VATDATE,       -- Tax Reporting Date [VATDATE]
    FULFILLDATE,   -- Tax Fulfill. Date [FOT_FULFILLDATE]
    KURSX,         -- MD Exchange Rate [GLE_FXR_DTE_RATEX28]
    KUR2X,         -- MD Exch. Rate 2 [GLE_FXR_DTE_RATE2X28]
    KUR3X,         -- MD Exch. Rate 3 [GLE_FXR_DTE_RATE3X28]
    XMCA,          -- Doc. from MCA [GLE_DTE_MCA_XMCA]
    GRPID,         -- Session Name [GRPID_BKPF]
    XREF1_HD,      -- Ref.key(head) 1 [XREF1_HD]
    STODT,         -- Reversal Date [STODT]
    STGRD,         -- Reversal Reason [STGRD]
    GLO_REF1_HD,   -- Country/Region Specific Reference 1 [FAC_GLO_REF1_HD]
    GLO_DAT1_HD,   -- Country/Region Specific Date 1 [FAC_GLO_DAT1_HD]
    GLO_REF2_HD,   -- Country/Region Specific Reference 2 [FAC_GLO_REF2_HD]
    GLO_DAT2_HD,   -- Country/Region Specific Date 2 [FAC_GLO_DAT2_HD]
    GLO_REF3_HD,   -- Country/Region Specific Reference 3 [FAC_GLO_REF3_HD]
    GLO_DAT3_HD,   -- Country/Region Specific Date 3 [FAC_GLO_DAT3_HD]
    GLO_REF4_HD,   -- Country/Region Specific Reference 4 [FAC_GLO_REF4_HD]
    GLO_DAT4_HD,   -- Country/Region Specific Date 4 [FAC_GLO_DAT4_HD]
    GLO_REF5_HD,   -- Country/Region Specific Reference 5 [FAC_GLO_REF5_HD]
    GLO_DAT5_HD,   -- Country/Region Specific Date 5 [FAC_GLO_DAT5_HD]
    GLO_BP1_HD,    -- Ctry/Reg. Specific Business Partner 1 [FAC_GLO_BP1_HD]
    GLO_BP2_HD,    -- Ctry/Reg. Specific Business Partner 2 [FAC_GLO_BP2_HD]
    ANXTYPE,       -- invoice type [/ILE/TMTYP]
    EXCLUDE_FLAG,  -- PPA Exclude [EXCLUDE_FLG]
    PSOTY,         -- Request Cat. [PSOTY_D]
    PSOAK,         -- Reason [PSOAK]
    PSOKS,         -- Region [PSOKS]
    PSOSG,         -- Reversal reason [PSOSG]
    PSOFN,         -- File number [PSOFN]
    INTFORM,       -- Int.formula [FM_INTFORM]
    INTDATE,       -- Interest Calc. Date [FM_INTDATE]
    PSODT,         -- Changed On [AEDAT]
    PSOTM,         -- Changed at [PSOTM]
    DBBLG,         -- Rec.Entry Doc. [DBBLG]
    PSOXWF,        -- Release Request [PSOXWF]
    RESUBMISSION,  -- Resubmission Date [FM_RESUBDAT]
    PYBASTYP,      -- Payt. Against [SAFM_AP_PYBSTYP]
    PYBASNO,       -- Payt. Ground No. [SAFM_AP_PYBSNO]
    PYBASDAT,      -- Payt. Ground Date [SAFM_AP_PYBSDAT]
    PYIBAN,        -- IBAN [IBAN]
    INWARDNO_HD,   -- Incg Doc. Nmbr [SAFM_AP_INWARD_NO]
    INWARDDT_HD,   -- Incg Doc. Date [SAFM_AP_INWARD_DT]
    CCINS,         -- Card type [CCINS_30F]
    CCNUM,         -- Card Number [CCNUM_30F]
    PRIMARY KEY (MANDT, AUSBK, BUKRS, BELNR, GJAHR)
);

Learn More