VBKPF

Transparent Table Application Table
79 Fields 17 CDS Views

Belegkopf Belegvorerfassung

VBKPF is an SAP database table in S/4HANA. Belegkopf Belegvorerfassung. It contains 79 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
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 one document to latest workflow
P_Facvd_Ver_Diag_Max_Timestamp view from BASIC Workflow Latest Dialog timestamp
P_FACVD_WF_STATUS_MAX_TS view from BASIC max timestamp of workflow
P_Facvd_Wf_Task_Max_Timestamp view from BASIC max timestamp of workflow
P_VBKPF_COM view_entity from BASIC Operational Accounting Document

Fields (79)

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

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.

-- Belegkopf Belegvorerfassung
-- 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]
    PRIMARY KEY (MANDT, AUSBK, BUKRS, BELNR, GJAHR)
);

Learn More