VICNCN_D

Transparent Table Application Table
66 Fields 1 CDS Views

Draft table for entity R_RECONTRACTTP

VICNCN_D is an SAP database table in S/4HANA. Draft table for entity R_RECONTRACTTP. It contains 66 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_REContractDraft view_entity from BASIC Real Estate Contract Draft

Fields (66)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY internalrealestatenumber RECAINTRENO RE Key
KEY draftuuid SDRAFT_UUID Draft Document ID
companycode BUKRS Company Code
realestatecontract RECNVDMCNNR Real Estate Contract
restatusobject RECAOBJNR Object Number
reinternalfinnumber RECAIMKEYFI Real Estate Key
realestatecontractoid RECNOID Real Estate Contract OID
recontractalternativeid RECNALTERNATIVEID Alternative ID
reidentificationkey RECAIDENTKEY Object ID
recreationtype RECACREATIONTYPE How Created
createdbyuser RERF Entered By
creationdate DERF First Enterd On
creationtime TERF Time
creationdatetime ABP_CREATION_TSTMPL Created On
resourceofcreation REHER Source.In.Entry
lastchangedbyuser RBEAR Last Changed By
lastchangedate DBEAR Last Edited On
lastchangetime TBEAR Last Edited At
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
resourceofchange RBHER Editing Source
responsible RECARESPONSIBLE Person Respons.
reuserexclusive RECAUSEREXCLUSIVE Change Auth.
reauthorizationgroup RECAAUTHGRP Authoriz. Group
recontracttype RECNCONTRACTTYPE Contract Type
contractstartdate RECNVDMCNBEG Contract Start Date
contractenddate RECNVDMCNENDABS Contract End Date
recontractname RECNVDMCNNAME Contract Name
recontractactivatedate RECNVDMDAKTV Active From
retenancylaw RECNVDMCNTLAW Tenancy Law
recontractnumberold RECNVDMCNTXTOLD Old Contract
remaincontractcompanycode RECNVDMCNBUKRSCODE Main Contract Company Code
remaincontract RECNNUMBERCOLLECT Main Contract
recontractcurrency RECNWAERS_CN Contract Curr.
reindustrysector BU_IND_SECTOR Industry
reissalesrelevant RECNSALESRENTRELEVANT Sales-Relevant
recontractdeposittype RECNVDMDEPOTYPE Security Deposit Type
recontractsigndate RECNDAT Contract Concl.
recontract2signdate RECNVDM2DATE Second Signature
recontractcashflowdate RECDCFSTARTFROM Cash Flow From
recontractfirstenddate RECNVDMCNEND1ST First Contract End
recontractnoticedate RECNNTPER Notice Per
recontractnoticeindate RECNNTRECEIPT Entry Date
recontractnoticereason RECNNTREASON Notice Reason
recontractnoticeactivationdate RECNNTACTIVATEDON Notice Activ.On
recashflowarchivedtodate RECDCFARCHIVEDTO CF Archived To
recashflowlockedtodate RECDCFLOCKEDTO CF Fixed Until
recashflowpostingfromdate RECDCFPOSTINGFROM 1st Posting Frm
rebusinessentity REBDVDMBENO RE Business Entity
repossessionstartdate REBDPOSSDATEFROM Possession From
repossessionenddate REBDPOSSDATETO Possession To
rehasmultipleassignments REBDHASMULTIASSIGN Mult.Assignment
reobjectavailablefromdate RECNVDMTRANSPOSSFROM Transfer of Possess. Starts At
reobjectavailabletodate RECNVDMTRANSPOSSTO Transfer of Possess. Ends On
valuationrelevance RECNRELEVANTEVAL Rel.to Valuatn
statusprofile J_STSMA Status Profile
realestateobjecttype RECAOBJTYPE Object Type
rebusinesspartnerrole1 REBPROLE BP Role
recontractisrelevantforvaln RECECEACTIVE Val. Active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_rec_ps CFD_DUMMY Dummy

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.

-- Draft table for entity R_RECONTRACTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICNCN_D (
    MANDT,                           -- Client [MANDT]
    INTERNALREALESTATENUMBER,        -- RE Key [RECAINTRENO]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    COMPANYCODE,                     -- Company Code [BUKRS]
    REALESTATECONTRACT,              -- Real Estate Contract [RECNVDMCNNR]
    RESTATUSOBJECT,                  -- Object Number [RECAOBJNR]
    REINTERNALFINNUMBER,             -- Real Estate Key [RECAIMKEYFI]
    REALESTATECONTRACTOID,           -- Real Estate Contract OID [RECNOID]
    RECONTRACTALTERNATIVEID,         -- Alternative ID [RECNALTERNATIVEID]
    REIDENTIFICATIONKEY,             -- Object ID [RECAIDENTKEY]
    RECREATIONTYPE,                  -- How Created [RECACREATIONTYPE]
    CREATEDBYUSER,                   -- Entered By [RERF]
    CREATIONDATE,                    -- First Enterd On [DERF]
    CREATIONTIME,                    -- Time [TERF]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    RESOURCEOFCREATION,              -- Source.In.Entry [REHER]
    LASTCHANGEDBYUSER,               -- Last Changed By [RBEAR]
    LASTCHANGEDATE,                  -- Last Edited On [DBEAR]
    LASTCHANGETIME,                  -- Last Edited At [TBEAR]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    RESOURCEOFCHANGE,                -- Editing Source [RBHER]
    RESPONSIBLE,                     -- Person Respons. [RECARESPONSIBLE]
    REUSEREXCLUSIVE,                 -- Change Auth. [RECAUSEREXCLUSIVE]
    REAUTHORIZATIONGROUP,            -- Authoriz. Group [RECAAUTHGRP]
    RECONTRACTTYPE,                  -- Contract Type [RECNCONTRACTTYPE]
    CONTRACTSTARTDATE,               -- Contract Start Date [RECNVDMCNBEG]
    CONTRACTENDDATE,                 -- Contract End Date [RECNVDMCNENDABS]
    RECONTRACTNAME,                  -- Contract Name [RECNVDMCNNAME]
    RECONTRACTACTIVATEDATE,          -- Active From [RECNVDMDAKTV]
    RETENANCYLAW,                    -- Tenancy Law [RECNVDMCNTLAW]
    RECONTRACTNUMBEROLD,             -- Old Contract [RECNVDMCNTXTOLD]
    REMAINCONTRACTCOMPANYCODE,       -- Main Contract Company Code [RECNVDMCNBUKRSCODE]
    REMAINCONTRACT,                  -- Main Contract [RECNNUMBERCOLLECT]
    RECONTRACTCURRENCY,              -- Contract Curr. [RECNWAERS_CN]
    REINDUSTRYSECTOR,                -- Industry [BU_IND_SECTOR]
    REISSALESRELEVANT,               -- Sales-Relevant [RECNSALESRENTRELEVANT]
    RECONTRACTDEPOSITTYPE,           -- Security Deposit Type [RECNVDMDEPOTYPE]
    RECONTRACTSIGNDATE,              -- Contract Concl. [RECNDAT]
    RECONTRACT2SIGNDATE,             -- Second Signature [RECNVDM2DATE]
    RECONTRACTCASHFLOWDATE,          -- Cash Flow From [RECDCFSTARTFROM]
    RECONTRACTFIRSTENDDATE,          -- First Contract End [RECNVDMCNEND1ST]
    RECONTRACTNOTICEDATE,            -- Notice Per [RECNNTPER]
    RECONTRACTNOTICEINDATE,          -- Entry Date [RECNNTRECEIPT]
    RECONTRACTNOTICEREASON,          -- Notice Reason [RECNNTREASON]
    RECONTRACTNOTICEACTIVATIONDATE,  -- Notice Activ.On [RECNNTACTIVATEDON]
    RECASHFLOWARCHIVEDTODATE,        -- CF Archived To [RECDCFARCHIVEDTO]
    RECASHFLOWLOCKEDTODATE,          -- CF Fixed Until [RECDCFLOCKEDTO]
    RECASHFLOWPOSTINGFROMDATE,       -- 1st Posting Frm [RECDCFPOSTINGFROM]
    REBUSINESSENTITY,                -- RE Business Entity [REBDVDMBENO]
    REPOSSESSIONSTARTDATE,           -- Possession From [REBDPOSSDATEFROM]
    REPOSSESSIONENDDATE,             -- Possession To [REBDPOSSDATETO]
    REHASMULTIPLEASSIGNMENTS,        -- Mult.Assignment [REBDHASMULTIASSIGN]
    REOBJECTAVAILABLEFROMDATE,       -- Transfer of Possess. Starts At [RECNVDMTRANSPOSSFROM]
    REOBJECTAVAILABLETODATE,         -- Transfer of Possess. Ends On [RECNVDMTRANSPOSSTO]
    VALUATIONRELEVANCE,              -- Rel.to Valuatn [RECNRELEVANTEVAL]
    STATUSPROFILE,                   -- Status Profile [J_STSMA]
    REALESTATEOBJECTTYPE,            -- Object Type [RECAOBJTYPE]
    REBUSINESSPARTNERROLE1,          -- BP Role [REBPROLE]
    RECONTRACTISRELEVANTFORVALN,     -- Val. Active [RECECEACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_REC_PS,                    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, INTERNALREALESTATENUMBER, DRAFTUUID)
);

Learn More