VDBEKI
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_LoanContrActlDocHdr | view | from | BASIC | Actual Document Header for Loan Contract |
| I_LoanContrActlDocHdrData | view | from | BASIC | Actual Document Header for Loan Contract |
Fields (52)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA