VICERULE

Transparent Table Application Table
33 Fields 8 CDS Views

Valuation Rule

VICERULE is an SAP database table in S/4HANA. Valuation Rule. It contains 33 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
FINOC_CHECK_REC_01_CCR_TO_REC view_entity inner Org. Change: From CostCtr to RE Contract
FINOC_CHECK_REC_01_ORD_TO_REC view_entity inner Org. Change: From Order to RE Contract
FINOC_CHECK_REC_01_PRCTRS view_entity left_outer Org. Change: PRCTRS of RE Contracts
FINOC_CHECK_REC_01_REC_TO_ALL view_entity inner Org. Change: From RE Contract to All
FINOC_CHECK_REC_01_WBS_TO_REC view_entity inner Org. Change: From WBS El. to RE Contract
FINOC_RT_REC_FILL_ACCTOBJ view_entity from Orgl Change: RE Contr. Val. Terms w/ OC
I_REValuationTerm view_entity from BASIC Real Estate Valuation Term
P_REValuationRule view from BASIC

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY intreno RECAINTRENO RE Key
KEY ruleguid RECERULEGUID Val. Rule
termno RETMTERMNO Number
termtype RETMTERMTYPE Term Category
validfrom RETMTERMVALIDFROM Valid From
validto RETMTERMVALIDTO Valid To
objnr RECEOBJNR Val. Obj. No.
objvalidfrom REBDRELVALIDFROM Valid From
cerule RECECERULE Valuation Rule
consbeg RECECONSBEG Start of Consid
postbeg RECEPOSTBEG 1st Posting Frm
assetobjnr RECEASOBJNR Object Number
cesltype RECECESLTYPE Classification
interestrate RECEINTERESTRATE Interest Rate
termnorh RECETERMNORH Frequency Term
distrule RECDDISTRULE Distrib. Form.
distrulepara1 RECDDISTRULEPARA Dist.Form.Param
distrulepara2 RECDDISTRULEPARA Dist.Form.Param
probableend RECEPROBABLEEND Probable End
usefullifeend RECEUSEFULLIFEEND Usage End RoU
statusrule RECESTATUSRULE Icon Rule Sts
statuseval RECESTATUSEVALUATION Ic. Val. Status
statusreason RECESTATUSREASON Status Reason
processbehavior RECEPROCESSBEHAVIOR Val. Behavior
taxtype RERATAXTYPE Tax Type
taxgroup RERATAXGROUP Tax Group
acctobjnr RECEACCTOBJNR Obj.No.Acc.Ass.
note RECENOTE Note
scopenum RECESCOPENUMERATOR Numer. Factor
scopedenom RECESCOPEDENOMINATOR Den. Factor
rulecurr RECERULECURR Val. Rule Crcy
queryguid RECEQUERYGUID Questionnaire

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.

-- Valuation Rule
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VICERULE (
    MANDT,            -- Client [MANDT]
    INTRENO,          -- RE Key [RECAINTRENO]
    RULEGUID,         -- Val. Rule [RECERULEGUID]
    TERMNO,           -- Number [RETMTERMNO]
    TERMTYPE,         -- Term Category [RETMTERMTYPE]
    VALIDFROM,        -- Valid From [RETMTERMVALIDFROM]
    VALIDTO,          -- Valid To [RETMTERMVALIDTO]
    OBJNR,            -- Val. Obj. No. [RECEOBJNR]
    OBJVALIDFROM,     -- Valid From [REBDRELVALIDFROM]
    CERULE,           -- Valuation Rule [RECECERULE]
    CONSBEG,          -- Start of Consid [RECECONSBEG]
    POSTBEG,          -- 1st Posting Frm [RECEPOSTBEG]
    ASSETOBJNR,       -- Object Number [RECEASOBJNR]
    CESLTYPE,         -- Classification [RECECESLTYPE]
    INTERESTRATE,     -- Interest Rate [RECEINTERESTRATE]
    TERMNORH,         -- Frequency Term [RECETERMNORH]
    DISTRULE,         -- Distrib. Form. [RECDDISTRULE]
    DISTRULEPARA1,    -- Dist.Form.Param [RECDDISTRULEPARA]
    DISTRULEPARA2,    -- Dist.Form.Param [RECDDISTRULEPARA]
    PROBABLEEND,      -- Probable End [RECEPROBABLEEND]
    USEFULLIFEEND,    -- Usage End RoU [RECEUSEFULLIFEEND]
    STATUSRULE,       -- Icon Rule Sts [RECESTATUSRULE]
    STATUSEVAL,       -- Ic. Val. Status [RECESTATUSEVALUATION]
    STATUSREASON,     -- Status Reason [RECESTATUSREASON]
    PROCESSBEHAVIOR,  -- Val. Behavior [RECEPROCESSBEHAVIOR]
    TAXTYPE,          -- Tax Type [RERATAXTYPE]
    TAXGROUP,         -- Tax Group [RERATAXGROUP]
    ACCTOBJNR,        -- Obj.No.Acc.Ass. [RECEACCTOBJNR]
    NOTE,             -- Note [RECENOTE]
    SCOPENUM,         -- Numer. Factor [RECESCOPENUMERATOR]
    SCOPEDENOM,       -- Den. Factor [RECESCOPEDENOMINATOR]
    RULECURR,         -- Val. Rule Crcy [RECERULECURR]
    QUERYGUID,        -- Questionnaire [RECEQUERYGUID]
    PRIMARY KEY (MANDT, INTRENO, RULEGUID)
);

Learn More