VICN01

Transparent Table Application Table
111 Fields 3 CDS Views

Real Estate Contract: Contract Data

VICN01 is an SAP database table in S/4HANA. Real Estate Contract: Contract Data. It contains 111 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FCO_COR_HSL_DER view left_outer HSL Corr. for Stat. Records in CO: Derivation of CurrKey
FCO_MIG_DERIV_P view left_outer CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields
fins_prctr_of_object_acdoca view left_outer Derive PRCTR & PPRCTR for ACDOCA object

Fields (111)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno VVINTRENO RE code
bukrs BUKRS Company Code
recntype SMVART Contract Type
recnnr RECNNR Contract No.
recndat RECNDAT Contract Concl.
recnbeg RECNBEG Contract start
recnend RECNEND Contr.end
recnadjt SMVAR Adjustment type
recntxt RECNTXT Contract Name
recndpo RECNDPO 1st posting
recnobjnr J_OBJNR Object number
recnnottype SMVKUEART Notice type
recnnotkey SKUEKEY Notic.Rule
recnnotper DKUZU Notice per
recnauthgr VVBERGRP Authoriz. Group
recnbusarea GSBER Business Area
recnprctr PRCTR Profit Center
recnaccdetval VVWERTN_ADCN Account determ.
recnadmonth VVJMABGR A/D meth. month
recnddunned MADAT Last Dunned
recndcomplnt VVKLDATUM Complaint date
recndcomplrc VVKLAKTZEI Complnt RefCode
recnjurisdic VVXGERSTD Jurisdiction
imkey IMKEY Real Estate Key
rerf RERF Entered By
derf DERF First Enterd On
terf TERF Time
reher REHER Source.In.Entry
rbear RBEAR Last Changed By
dbear DBEAR Last Edited On
tbear TBEAR Last Edited At
rbher RBHER Editing Source
recnunit RECNUNIT Area unit
recnkunnr KUNNR Customer
recnlifnr LIFNR Supplier
recntxjcd TXJCD Tax Jur.
recncurr RECNWAERS_H Local Currency
recntlaw SMIETR Tenancy law
recncurr2 RECNWAERS_D Display crrncy
recntxtold VVOSMIVE Old Contract
recndactiv DAKTV Active from
recnnrcollect RECNNRCOLLECT Main Contract
recnkostl RECNKOSTL Int.cost center
zlsch DZLSCH Pymt Meth.
recnpredata RECNPREDATA Predefined rates
spartnr BP_PARTNR BusPartner
recnnotreceipt DEKUEA Issue/receipt not.
recnnotreason RKUEGRU Notice reason
recnnotinvrea RABLGRU Rejection reas.
recnjvstopt VVJVSTOPT Inp.tax opting
recnvstsond SVSTSOND Opting reason
recnmansp MANSP Dunn. Block
recnmaber MABER Dunning Area
recnmahna MAHNA Dunn.Procedure
recnmahns_d MAHNS_D Dunning Level
recnnotcat SKUAR Notice given by
recngfzlsch RECNGFZLSCH Pmt Meth.Cred.Memo
recnzlspr DZLSPR Pmnt block
recnhbkid HBKID House Bank
recnxblnr RECNXBLNR1 Purpose
recndkuzug VVDKUZUG Approved on
recndkuabg VVDKUABG Rejected on
recndwiku VVDWIKU Object. on
recndkuerck DKUERCK Withdrawal on
recndkreueb VVDKREUEB Legal dept. on
recndaktku VVDAKTKU Activated on
recndstku VVDSTKU Reversed on
recnadjttype RECNADJTTYPE Adjustment by
recnadjtrueck RECNADJTRUECK Retroactive adj.
recnbukrscollect RECNBUKRSCOLLECT Main Contr.CoCd
recnbasisaezif RECNBASISAEZIF B.equi.no.
recnxcross RECNXCROSS Gross
recnmandat RECNMANDAT Mandate
recnmandattyp RECNMANDATTYP Mandate Role
recnflesr VVKZESR Activation POR
recnesrnrow VVESRNR_EIG POR owner no.
recnesrcuidow VVESRKUID_EIG Customer ID no.
recnvatnrow VVMWSTNR_EIG VAT no. owner
recnbukrsgkt VVBUKRS_GKT Company code
recnkzeiggkt VVKZEIGGKT Account control
relskassenz RELSKASSENZ
relsgrdnr RELSGRDNR
relssubtype RELSSUBTYPE
relsaktz RELSAKTZ
relsdat2 RELSDAT2
relswirtuebg RELSWIRTUEBG
relsnotearly RELSNOTEARLY
relsowner BP_PARTNR BusPartner
relsroletyp BP_ROLETYP Role Category
creationtype RECACREATIONTYPE How Created
recncncurr RECNWAERS_CN Contract Curr.
recnendabs RECNCNENDABS End of Term
recn2dat RECN2DAT 2nd Signature
responsible RECARESPONSIBLE Person Respons.
userexclusive RECAUSEREXCLUSIVE Change Auth.
srrelevant RECNSALESRENTRELEVANT Sales-Relevant
cfarchivedto RECDCFARCHIVEDTO CF Archived To
cflockedto RECDCFLOCKEDTO CF Fixed Until
industry BU_IND_SECTOR Industry
dptargettype RECNDPTYPE Sec. Dep. Type
birelease RELUBIRELEASE
bivalidfrom RELUBIVALIDFROM
bivalidto RELUBIVALIDTO
bireprto RELUBIREPRTO
bireprtotime RELUBIREPRTOTIME
birecat RELUBIRECAT
publictype RELUPUBLICTYPE
fileno RELUFILENO
bipurpose RELUBIPURPOSE
bipricing RELUBIPRICING

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.

-- Real Estate Contract: Contract Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICN01 (
    MANDT,             -- Client [MANDT]
    INTRENO,           -- RE code [VVINTRENO]
    BUKRS,             -- Company Code [BUKRS]
    RECNTYPE,          -- Contract Type [SMVART]
    RECNNR,            -- Contract No. [RECNNR]
    RECNDAT,           -- Contract Concl. [RECNDAT]
    RECNBEG,           -- Contract start [RECNBEG]
    RECNEND,           -- Contr.end [RECNEND]
    RECNADJT,          -- Adjustment type [SMVAR]
    RECNTXT,           -- Contract Name [RECNTXT]
    RECNDPO,           -- 1st posting [RECNDPO]
    RECNOBJNR,         -- Object number [J_OBJNR]
    RECNNOTTYPE,       -- Notice type [SMVKUEART]
    RECNNOTKEY,        -- Notic.Rule [SKUEKEY]
    RECNNOTPER,        -- Notice per [DKUZU]
    RECNAUTHGR,        -- Authoriz. Group [VVBERGRP]
    RECNBUSAREA,       -- Business Area [GSBER]
    RECNPRCTR,         -- Profit Center [PRCTR]
    RECNACCDETVAL,     -- Account determ. [VVWERTN_ADCN]
    RECNADMONTH,       -- A/D meth. month [VVJMABGR]
    RECNDDUNNED,       -- Last Dunned [MADAT]
    RECNDCOMPLNT,      -- Complaint date [VVKLDATUM]
    RECNDCOMPLRC,      -- Complnt RefCode [VVKLAKTZEI]
    RECNJURISDIC,      -- Jurisdiction [VVXGERSTD]
    IMKEY,             -- Real Estate Key [IMKEY]
    RERF,              -- Entered By [RERF]
    DERF,              -- First Enterd On [DERF]
    TERF,              -- Time [TERF]
    REHER,             -- Source.In.Entry [REHER]
    RBEAR,             -- Last Changed By [RBEAR]
    DBEAR,             -- Last Edited On [DBEAR]
    TBEAR,             -- Last Edited At [TBEAR]
    RBHER,             -- Editing Source [RBHER]
    RECNUNIT,          -- Area unit [RECNUNIT]
    RECNKUNNR,         -- Customer [KUNNR]
    RECNLIFNR,         -- Supplier [LIFNR]
    RECNTXJCD,         -- Tax Jur. [TXJCD]
    RECNCURR,          -- Local Currency [RECNWAERS_H]
    RECNTLAW,          -- Tenancy law [SMIETR]
    RECNCURR2,         -- Display crrncy [RECNWAERS_D]
    RECNTXTOLD,        -- Old Contract [VVOSMIVE]
    RECNDACTIV,        -- Active from [DAKTV]
    RECNNRCOLLECT,     -- Main Contract [RECNNRCOLLECT]
    RECNKOSTL,         -- Int.cost center [RECNKOSTL]
    ZLSCH,             -- Pymt Meth. [DZLSCH]
    RECNPREDATA,       -- Predefined rates [RECNPREDATA]
    SPARTNR,           -- BusPartner [BP_PARTNR]
    RECNNOTRECEIPT,    -- Issue/receipt not. [DEKUEA]
    RECNNOTREASON,     -- Notice reason [RKUEGRU]
    RECNNOTINVREA,     -- Rejection reas. [RABLGRU]
    RECNJVSTOPT,       -- Inp.tax opting [VVJVSTOPT]
    RECNVSTSOND,       -- Opting reason [SVSTSOND]
    RECNMANSP,         -- Dunn. Block [MANSP]
    RECNMABER,         -- Dunning Area [MABER]
    RECNMAHNA,         -- Dunn.Procedure [MAHNA]
    RECNMAHNS_D,       -- Dunning Level [MAHNS_D]
    RECNNOTCAT,        -- Notice given by [SKUAR]
    RECNGFZLSCH,       -- Pmt Meth.Cred.Memo [RECNGFZLSCH]
    RECNZLSPR,         -- Pmnt block [DZLSPR]
    RECNHBKID,         -- House Bank [HBKID]
    RECNXBLNR,         -- Purpose [RECNXBLNR1]
    RECNDKUZUG,        -- Approved on [VVDKUZUG]
    RECNDKUABG,        -- Rejected on [VVDKUABG]
    RECNDWIKU,         -- Object. on [VVDWIKU]
    RECNDKUERCK,       -- Withdrawal on [DKUERCK]
    RECNDKREUEB,       -- Legal dept. on [VVDKREUEB]
    RECNDAKTKU,        -- Activated on [VVDAKTKU]
    RECNDSTKU,         -- Reversed on [VVDSTKU]
    RECNADJTTYPE,      -- Adjustment by [RECNADJTTYPE]
    RECNADJTRUECK,     -- Retroactive adj. [RECNADJTRUECK]
    RECNBUKRSCOLLECT,  -- Main Contr.CoCd [RECNBUKRSCOLLECT]
    RECNBASISAEZIF,    -- B.equi.no. [RECNBASISAEZIF]
    RECNXCROSS,        -- Gross [RECNXCROSS]
    RECNMANDAT,        -- Mandate [RECNMANDAT]
    RECNMANDATTYP,     -- Mandate Role [RECNMANDATTYP]
    RECNFLESR,         -- Activation POR [VVKZESR]
    RECNESRNROW,       -- POR owner no. [VVESRNR_EIG]
    RECNESRCUIDOW,     -- Customer ID no. [VVESRKUID_EIG]
    RECNVATNROW,       -- VAT no. owner [VVMWSTNR_EIG]
    RECNBUKRSGKT,      -- Company code [VVBUKRS_GKT]
    RECNKZEIGGKT,      -- Account control [VVKZEIGGKT]
    RELSKASSENZ,       -- RELSKASSENZ
    RELSGRDNR,         -- RELSGRDNR
    RELSSUBTYPE,       -- RELSSUBTYPE
    RELSAKTZ,          -- RELSAKTZ
    RELSDAT2,          -- RELSDAT2
    RELSWIRTUEBG,      -- RELSWIRTUEBG
    RELSNOTEARLY,      -- RELSNOTEARLY
    RELSOWNER,         -- BusPartner [BP_PARTNR]
    RELSROLETYP,       -- Role Category [BP_ROLETYP]
    CREATIONTYPE,      -- How Created [RECACREATIONTYPE]
    RECNCNCURR,        -- Contract Curr. [RECNWAERS_CN]
    RECNENDABS,        -- End of Term [RECNCNENDABS]
    RECN2DAT,          -- 2nd Signature [RECN2DAT]
    RESPONSIBLE,       -- Person Respons. [RECARESPONSIBLE]
    USEREXCLUSIVE,     -- Change Auth. [RECAUSEREXCLUSIVE]
    SRRELEVANT,        -- Sales-Relevant [RECNSALESRENTRELEVANT]
    CFARCHIVEDTO,      -- CF Archived To [RECDCFARCHIVEDTO]
    CFLOCKEDTO,        -- CF Fixed Until [RECDCFLOCKEDTO]
    INDUSTRY,          -- Industry [BU_IND_SECTOR]
    DPTARGETTYPE,      -- Sec. Dep. Type [RECNDPTYPE]
    BIRELEASE,         -- RELUBIRELEASE
    BIVALIDFROM,       -- RELUBIVALIDFROM
    BIVALIDTO,         -- RELUBIVALIDTO
    BIREPRTO,          -- RELUBIREPRTO
    BIREPRTOTIME,      -- RELUBIREPRTOTIME
    BIRECAT,           -- RELUBIRECAT
    PUBLICTYPE,        -- RELUPUBLICTYPE
    FILENO,            -- RELUFILENO
    BIPURPOSE,         -- RELUBIPURPOSE
    BIPRICING,         -- RELUBIPRICING
    PRIMARY KEY (MANDT, INTRENO)
);

Learn More