VDBEKI

Transparent Table Application Table

Flow Data: Document Header for Actual Record

VDBEKI is an SAP database table in S/4HANA. Flow Data: Document Header for Actual Record. It contains 52 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LoanContrActlDocHdr view from BASIC Actual Document Header for Loan Contract
I_LoanContrActlDocHdrData view from BASIC Actual Document Header for Loan Contract

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY rbelkpfd RBELKPFD Doc no. Header
sanlf SANLF Prod. Category
ranl RANL Contract Number
dguel_kk DGUEL Cond. Eff. from
nlfd_ang NLFD_ANG Off.consec.no.
rklammer RKLAMMER Finance Project
dvorgang DVORGANG Activity date
svorgang SVORFALL Activity
nvorgang NVORGANG Activity no.
sstati SSTATI Status
rrefkont RREFKONT Acct Assign.Ref
hkont HKONT G/L Acct
gsber GSBER Business Area
sblart BLART Document Type
dbldat BLDAT Document Date
dbudat BUDAT Posting Date
dgjahr GJAHR Fiscal Year
dmonat MONAT Period
sstorno SSTORNO Reverse indic.
sstogrd SSTOGRD Reversal Reason
zuonr DZUONR Assignment
rstblg STBLG Reversed With
rzebel RZEBEL Document no.
dorder DORDER Order date
danjrnl DANJRNL Date journal
danfibu DANFIBU Dte FiAc
uanfibu UANFIBU Time fin.acc.
sspesen SSPESEN Expen.key
norder NORDER Order Number
rbankk RBANKK Int. bank acct
sstckkz SSTCKKZ Acc.int.meth.
sstcktg SSTCKTG Daily Method
peffzins PEFFZINS Effect.int.rate
seffmeth SEFFMETH Eff.Int. Method
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
dstock VVDSTOCK PRF entry date
rpnnr VVRPNNR Daybook no.
rvzblg BELNR_D Document Number
rpnsup VVRPNSUP SuperPrim.
rumblg UMBLG RefTrnDoc.
sevalpost SEVALPOST PEC run - flow
ruzbel BELNR_D Document Number
acenv ACENV_LO Source in post.area
s_compr S_COMPR Summariz. ID
cd_post FVD_CD_POST CD posting
cd_doc_type FVD_BLART_KK Document Type
cd_doc FVD_OPBEL_KK Document 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.

-- Flow Data: Document Header for Actual Record
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VDBEKI (
    MANDT,        -- Client [MANDT]
    BUKRS,        -- Company Code [BUKRS]
    RBELKPFD,     -- Doc no. Header [RBELKPFD]
    SANLF,        -- Prod. Category [SANLF]
    RANL,         -- Contract Number [RANL]
    DGUEL_KK,     -- Cond. Eff. from [DGUEL]
    NLFD_ANG,     -- Off.consec.no. [NLFD_ANG]
    RKLAMMER,     -- Finance Project [RKLAMMER]
    DVORGANG,     -- Activity date [DVORGANG]
    SVORGANG,     -- Activity [SVORFALL]
    NVORGANG,     -- Activity no. [NVORGANG]
    SSTATI,       -- Status [SSTATI]
    RREFKONT,     -- Acct Assign.Ref [RREFKONT]
    HKONT,        -- G/L Acct [HKONT]
    GSBER,        -- Business Area [GSBER]
    SBLART,       -- Document Type [BLART]
    DBLDAT,       -- Document Date [BLDAT]
    DBUDAT,       -- Posting Date [BUDAT]
    DGJAHR,       -- Fiscal Year [GJAHR]
    DMONAT,       -- Period [MONAT]
    SSTORNO,      -- Reverse indic. [SSTORNO]
    SSTOGRD,      -- Reversal Reason [SSTOGRD]
    ZUONR,        -- Assignment [DZUONR]
    RSTBLG,       -- Reversed With [STBLG]
    RZEBEL,       -- Document no. [RZEBEL]
    DORDER,       -- Order date [DORDER]
    DANJRNL,      -- Date journal [DANJRNL]
    DANFIBU,      -- Dte FiAc [DANFIBU]
    UANFIBU,      -- Time fin.acc. [UANFIBU]
    SSPESEN,      -- Expen.key [SSPESEN]
    NORDER,       -- Order Number [NORDER]
    RBANKK,       -- Int. bank acct [RBANKK]
    SSTCKKZ,      -- Acc.int.meth. [SSTCKKZ]
    SSTCKTG,      -- Daily Method [SSTCKTG]
    PEFFZINS,     -- Effect.int.rate [PEFFZINS]
    SEFFMETH,     -- Eff.Int. Method [SEFFMETH]
    RERF,         -- Entered By [RERF]
    DERF,         -- First Enterd On [DERF]
    TERF,         -- Time [TERF]
    REHER,        -- Source.In.Entry [REHER]
    DSTOCK,       -- PRF entry date [VVDSTOCK]
    RPNNR,        -- Daybook no. [VVRPNNR]
    RVZBLG,       -- Document Number [BELNR_D]
    RPNSUP,       -- SuperPrim. [VVRPNSUP]
    RUMBLG,       -- RefTrnDoc. [UMBLG]
    SEVALPOST,    -- PEC run - flow [SEVALPOST]
    RUZBEL,       -- Document Number [BELNR_D]
    ACENV,        -- Source in post.area [ACENV_LO]
    S_COMPR,      -- Summariz. ID [S_COMPR]
    CD_POST,      -- CD posting [FVD_CD_POST]
    CD_DOC_TYPE,  -- Document Type [FVD_BLART_KK]
    CD_DOC,       -- Document Number [FVD_OPBEL_KK]
    PRIMARY KEY (MANDT, BUKRS, RBELKPFD)
);