P_REValuationRule

DDL: P_REVALUATIONRULE SQL: PVALRULE Type: view BASIC
33 Fields 1 Data Sources 1 Associations

P_REValuationRule is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (vicerule) and exposes 33 fields with key fields InternalRealEstateNumber, REValuationRuleUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
vicerule _ValuationRule from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RETermType _RETermType _RETermType.RealEstateObjectType = 'IS' and $projection.RETermType = _RETermType.RETermType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PVALRULE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view
VDM.private true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber vicerule intreno Source Object
KEY REValuationRuleUUID vicerule ruleguid Val. Rule
RETermNumber vicerule termno Term Number
RETermType vicerule termtype Term Type
ValidityStartDate
ValidityEndDate
REStatusObject vicerule objnr Val. Obj. No.
ObjectValidFrom
REValuationRule vicerule cerule Valuation Rule
REConsiderationStartDate
RECashFlowPostingFromDate
REStatusObjectAsset
REValuationClassification vicerule cesltype Classification
REInterestRate vicerule interestrate Percentage Rate
REFrequencyTerm vicerule termnorh Frequency Term
REDistributionRule vicerule distrule Distrib. Form.
REDistributionRuleParam1 vicerule distrulepara1 Dist.Form.Param
REDistributionRuleParam2 vicerule distrulepara2 Dist.Form.Param
REProbableEndDate
REAssetRightOfUseEndDate
REValuationRuleStatus
REValuationStatus
REValuationStatusReason
REValuationBehavior vicerule processbehavior Val. Behavior
RETaxType vicerule taxtype Tax Type
TaxGroup vicerule taxgroup Tax Group
REAccountingObject
REInfoText vicerule note TradeRequest Comment
REValuationFactorNumerator vicerule scopenum Numer. Factor
REValuationFactorDenominator vicerule scopedenom Den. Factor
REValuationCurrency
REValuationQuestionnaireUUID vicerule queryguid Questionnaire
_RETermType _RETermType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_REValuationRule.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PVALRULE

CREATE VIEW P_REValuationRule AS
SELECT
  _ValuationRule.intreno AS InternalRealEstateNumber,
  _ValuationRule.ruleguid AS REValuationRuleUUID,
  _ValuationRule.termno AS RETermNumber,
  _ValuationRule.termtype AS RETermType,
  cast( _ValuationRule.validfrom as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast( _ValuationRule.validto as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  _ValuationRule.objnr AS REStatusObject,
  cast(_ValuationRule.objvalidfrom as rebdvdmrelvalidfrom preserving type ) AS ObjectValidFrom,
  _ValuationRule.cerule AS REValuationRule,
  cast(_ValuationRule.consbeg as recevdmconsbeg preserving type ) AS REConsiderationStartDate,
  cast(_ValuationRule.postbeg as recevdmpostbeg preserving type ) AS RECashFlowPostingFromDate,
  cast(_ValuationRule.assetobjnr as recevdmasobjnr preserving type ) AS REStatusObjectAsset,
  _ValuationRule.cesltype AS REValuationClassification,
  _ValuationRule.interestrate AS REInterestRate,
  _ValuationRule.termnorh AS REFrequencyTerm,
  _ValuationRule.distrule AS REDistributionRule,
  _ValuationRule.distrulepara1 AS REDistributionRuleParam1,
  _ValuationRule.distrulepara2 AS REDistributionRuleParam2,
  cast( _ValuationRule.probableend as recevdmprobableend preserving type ) AS REProbableEndDate,
  cast( _ValuationRule.usefullifeend as recevdmusefullifeend preserving type ) AS REAssetRightOfUseEndDate,
  cast( _ValuationRule.statusrule as recevdmstatusrule preserving type ) AS REValuationRuleStatus,
  cast( _ValuationRule.statuseval as recevdmstatusevaluation preserving type ) AS REValuationStatus,
  cast( _ValuationRule.statusreason as recevdmstatusreason preserving type ) AS REValuationStatusReason,
  _ValuationRule.processbehavior AS REValuationBehavior,
  _ValuationRule.taxtype AS RETaxType,
  _ValuationRule.taxgroup AS TaxGroup,
  cast(_ValuationRule.acctobjnr as recevdmacctobjnr preserving type ) AS REAccountingObject,
  _ValuationRule.note AS REInfoText,
  _ValuationRule.scopenum AS REValuationFactorNumerator,
  _ValuationRule.scopedenom AS REValuationFactorDenominator,
  cast(_ValuationRule.rulecurr as recevdmrulecurr preserving type ) AS REValuationCurrency,
  _ValuationRule.queryguid AS REValuationQuestionnaireUUID
FROM vicerule AS _ValuationRule
LEFT OUTER JOIN I_RETermType AS _RETermType ON _RETermType.RealEstateObjectType = 'IS' AND RETermType = _RETermType.RETermType  -- association [1..1]
;

Learn More