VICNCN

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICNCN (
    MANDT,             -- Client [MANDT]
    INTRENO,           -- RE Key [RECAINTRENO]
    BUKRS,             -- Company Code [BUKRS]
    RECNNR,            -- Contract [RECNNUMBER]
    OBJNR,             -- Object Number [RECAOBJNR]
    IMKEY,             -- Real Estate Key [RECAIMKEY]
    OID,               -- Real Estate Contract OID [RECNOID]
    ALTERNATIVEID,     -- Alternative ID [RECNALTERNATIVEID]
    CREATIONTYPE,      -- How Created [RECACREATIONTYPE]
    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]
    RESPONSIBLE,       -- Person Respons. [RECARESPONSIBLE]
    USEREXCLUSIVE,     -- Change Auth. [RECAUSEREXCLUSIVE]
    AUTHGRP,           -- Authoriz. Group [RECAAUTHGRP]
    RECNTYPE,          -- Contract Type [RECNCONTRACTTYPE]
    RECNBEG,           -- Contract Start [RECNCNBEG]
    RECNENDABS,        -- End of Term [RECNCNENDABS]
    RECNTXT,           -- Contract Name [RECNTXT]
    RECNDACTIV,        -- Active from [DAKTV]
    RECNTLAW,          -- Tenancy law [SMIETR]
    RECNTXTOLD,        -- Old Contract [VVOSMIVE]
    RECNBUKRSCOLLECT,  -- Main Contr.CoCd [RECNBUKRSCOLLECT]
    RECNNRCOLLECT,     -- Main Contract [RECNNUMBERCOLLECT]
    RECNCNCURR,        -- Contract Curr. [RECNWAERS_CN]
    INDUSTRY,          -- Industry [BU_IND_SECTOR]
    SRRELEVANT,        -- Sales-Relevant [RECNSALESRENTRELEVANT]
    DPTARGETTYPE,      -- Sec. Dep. Type [RECNDPTYPE]
    RECNDAT,           -- Contract Concl. [RECNDAT]
    RECN2DAT,          -- 2nd Signature [RECN2DAT]
    RECNDPO,           -- Cash Flow From [RECDCFSTARTFROM]
    RECNEND1ST,        -- 1st Contr. End [RECNCNEND1ST]
    RECNNOTPER,        -- Notice Per [RECNNTPER]
    RECNNOTRECEIPT,    -- Entry Date [RECNNTRECEIPT]
    RECNNOTREASON,     -- Notice Reason [RECNNTREASON]
    RECNDAKTKU,        -- Notice Activ.On [RECNNTACTIVATEDON]
    CFARCHIVEDTO,      -- CF Archived To [RECDCFARCHIVEDTO]
    CFLOCKEDTO,        -- CF Fixed Until [RECDCFLOCKEDTO]
    CFPOSTINGFROM,     -- 1st Posting Frm [RECDCFPOSTINGFROM]
    BENOCN,            -- BE for Contract [RECNBENOCN]
    TRANSPOSSFROM,     -- Transf.of Poss. [RECNTRANSPOSSFROM]
    TRANSPOSSTO,       -- Trsf.Poss.End [RECNTRANSPOSSTO]
    HASMULTIASSIGN,    -- Mult.Assignment [REBDHASMULTIASSIGN]
    POSSDATEFROM,      -- Possession From [REBDPOSSDATEFROM]
    POSSDATETO,        -- Possession To [REBDPOSSDATETO]
    RELEVANTEVAL,      -- Rel.to Valuatn [RECNRELEVANTEVAL]
    DUMMY_REC_PS,      -- Dummy [CFD_DUMMY]
    SECDEPRELEVANT,    -- Rel. to Sec.Dep. [REXCESCDREL]
    NOTADJSDCN,        -- No Data Change [REXCESCDNOTADJ]
    PRIMARY KEY (MANDT, INTRENO)
);