VICERULE_D

Transparent Table Application Table
52 Fields 1 CDS Views

Draft table for entity R_RECONTRVALUATIONTP

VICERULE_D is an SAP database table in S/4HANA. Draft table for entity R_RECONTRVALUATIONTP. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_REContrValuationDraft view_entity from BASIC Real Estate Valuation Term Draft

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY internalrealestatenumber RECAINTRENO RE Key
KEY retermnumber RETMTERMNO Number
KEY validitystartenddatevalue RECADATEPERIOD Validity Period
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
retermtype RETMTERMTYPE Term Category
retermname RETMXTERM Name of Term
revaluationrule RECECERULE Valuation Rule
revaluationruleuuid RECERULEGUID Val. Rule
validitystartdate REBDVDMVALIDFROM Validity Start Date
validityenddate REBDVDMVALIDTO Validity End Date
restatusobject RECEOBJNR Val. Obj. No.
realestateobjecttype REBDBUSOBJTYPECN BusObjType
objectvalidfrom REBDVDMRELVALIDFROM Relation Valid From
reconsiderationstartdate RECEVDMCONSBEG Start of Consideration
recashflowpostingfromdate RECEVDMPOSTBEG First Posting From
restatusobjectasset RECEVDMASOBJNR Asset Number
revaluationclassification RECECESLTYPE Classification
reinterestrate RECEINTERESTRATE Interest Rate
refrequencyterm RECETERMNORH Frequency Term
redistributionrule RECDDISTRULE Distrib. Form.
redistributionruleparam1 RECDDISTRULEPARA Dist.Form.Param
redistributionruleparam2 RECDDISTRULEPARA Dist.Form.Param
reprobableenddate RECEVDMPROBABLEEND Probable End
reassetrightofuseenddate RECEVDMUSEFULLIFEEND Usage End RoU
revaluationrulestatus RECEVDMSTATUSRULE Rule Status
revaluationstatus RECEVDMSTATUSEVALUATION Valuation Status
revaluationstatusreason RECEVDMSTATUSREASON Reason for Stat.
revaluationbehavior RECEPROCESSBEHAVIOR Val. Behavior
retaxtype RERATAXTYPE Tax Type
taxgroup RERATAXGROUP Tax Group
reaccountingobject RECEVDMACCTOBJNR Accounting Object
reaccountingobjecttype abap.char
reinfotext RECENOTE Note
revaluationfactornumerator RECESCOPENUMERATOR Numer. Factor
revaluationfactordenominator RECESCOPEDENOMINATOR Den. Factor
revaluationcurrency RECEVDMRULECURR Valuation Currency
revaluationquestionnaireuuid RECEQUERYGUID Questionnaire
country LAND1 Country/Reg.
reentryvalidity RECAVDMENTRYVALIDITY Entry Validity
reentryvaliditycriticality abap.int1
reidentification RECAIDENT Object
reaccountingobjidentification RECAVDMACCOBJIDENT Accounting Object ID
masterfixedasset ANLN1 Asset
fixedasset ANLN2 Sub-number
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

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_RECONTRVALUATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICERULE_D (
    MANDT,                          -- Client [MANDT]
    INTERNALREALESTATENUMBER,       -- RE Key [RECAINTRENO]
    RETERMNUMBER,                   -- Number [RETMTERMNO]
    VALIDITYSTARTENDDATEVALUE,      -- Validity Period [RECADATEPERIOD]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    RETERMTYPE,                     -- Term Category [RETMTERMTYPE]
    RETERMNAME,                     -- Name of Term [RETMXTERM]
    REVALUATIONRULE,                -- Valuation Rule [RECECERULE]
    REVALUATIONRULEUUID,            -- Val. Rule [RECERULEGUID]
    VALIDITYSTARTDATE,              -- Validity Start Date [REBDVDMVALIDFROM]
    VALIDITYENDDATE,                -- Validity End Date [REBDVDMVALIDTO]
    RESTATUSOBJECT,                 -- Val. Obj. No. [RECEOBJNR]
    REALESTATEOBJECTTYPE,           -- BusObjType [REBDBUSOBJTYPECN]
    OBJECTVALIDFROM,                -- Relation Valid From [REBDVDMRELVALIDFROM]
    RECONSIDERATIONSTARTDATE,       -- Start of Consideration [RECEVDMCONSBEG]
    RECASHFLOWPOSTINGFROMDATE,      -- First Posting From [RECEVDMPOSTBEG]
    RESTATUSOBJECTASSET,            -- Asset Number [RECEVDMASOBJNR]
    REVALUATIONCLASSIFICATION,      -- Classification [RECECESLTYPE]
    REINTERESTRATE,                 -- Interest Rate [RECEINTERESTRATE]
    REFREQUENCYTERM,                -- Frequency Term [RECETERMNORH]
    REDISTRIBUTIONRULE,             -- Distrib. Form. [RECDDISTRULE]
    REDISTRIBUTIONRULEPARAM1,       -- Dist.Form.Param [RECDDISTRULEPARA]
    REDISTRIBUTIONRULEPARAM2,       -- Dist.Form.Param [RECDDISTRULEPARA]
    REPROBABLEENDDATE,              -- Probable End [RECEVDMPROBABLEEND]
    REASSETRIGHTOFUSEENDDATE,       -- Usage End RoU [RECEVDMUSEFULLIFEEND]
    REVALUATIONRULESTATUS,          -- Rule Status [RECEVDMSTATUSRULE]
    REVALUATIONSTATUS,              -- Valuation Status [RECEVDMSTATUSEVALUATION]
    REVALUATIONSTATUSREASON,        -- Reason for Stat. [RECEVDMSTATUSREASON]
    REVALUATIONBEHAVIOR,            -- Val. Behavior [RECEPROCESSBEHAVIOR]
    RETAXTYPE,                      -- Tax Type [RERATAXTYPE]
    TAXGROUP,                       -- Tax Group [RERATAXGROUP]
    REACCOUNTINGOBJECT,             -- Accounting Object [RECEVDMACCTOBJNR]
    REACCOUNTINGOBJECTTYPE,         -- abap.char
    REINFOTEXT,                     -- Note [RECENOTE]
    REVALUATIONFACTORNUMERATOR,     -- Numer. Factor [RECESCOPENUMERATOR]
    REVALUATIONFACTORDENOMINATOR,   -- Den. Factor [RECESCOPEDENOMINATOR]
    REVALUATIONCURRENCY,            -- Valuation Currency [RECEVDMRULECURR]
    REVALUATIONQUESTIONNAIREUUID,   -- Questionnaire [RECEQUERYGUID]
    COUNTRY,                        -- Country/Reg. [LAND1]
    REENTRYVALIDITY,                -- Entry Validity [RECAVDMENTRYVALIDITY]
    REENTRYVALIDITYCRITICALITY,     -- abap.int1
    REIDENTIFICATION,               -- Object [RECAIDENT]
    REACCOUNTINGOBJIDENTIFICATION,  -- Accounting Object ID [RECAVDMACCOBJIDENT]
    MASTERFIXEDASSET,               -- Asset [ANLN1]
    FIXEDASSET,                     -- Sub-number [ANLN2]
    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]
    PRIMARY KEY (MANDT, INTERNALREALESTATENUMBER, RETERMNUMBER, VALIDITYSTARTENDDATEVALUE, DRAFTUUID)
);

Learn More