I_REValuationTerm

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 I_REValuationTerm.
-- 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.

CREATE VIEW I_REValuationTerm AS
SELECT
  _ValuationTerm.intreno AS InternalRealEstateNumber,
  _ValuationTerm.ruleguid AS REValuationRuleUUID,
  _ValuationTerm.termno AS RETermNumber,
  _ValuationTerm.termtype AS RETermType,
  cast( _ValuationTerm.validfrom as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast( _ValuationTerm.validto as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  _ValuationTerm.objnr AS REStatusObject,
  cast(_ValuationTerm.objvalidfrom as rebdvdmrelvalidfrom preserving type ) AS ObjectValidFrom,
  _ValuationTerm.cerule AS REValuationRule,
  cast(_ValuationTerm.consbeg as recevdmconsbeg preserving type ) AS REConsiderationStartDate,
  cast(_ValuationTerm.postbeg as recevdmpostbeg preserving type ) AS RECashFlowPostingFromDate,
  cast(_ValuationTerm.assetobjnr as recevdmasobjnr preserving type ) AS REStatusObjectAsset,
  _ValuationTerm.cesltype AS REValuationClassification,
  _ValuationTerm.interestrate AS REInterestRate,
  _ValuationTerm.termnorh AS REFrequencyTerm,
  _ValuationTerm.distrule AS REDistributionRule,
  _ValuationTerm.distrulepara1 AS REDistributionRuleParam1,
  _ValuationTerm.distrulepara2 AS REDistributionRuleParam2,
  cast( _ValuationTerm.probableend as recevdmprobableend preserving type ) AS REProbableEndDate,
  cast( _ValuationTerm.usefullifeend as recevdmusefullifeend preserving type ) AS REAssetRightOfUseEndDate,
  cast( _ValuationTerm.statusrule as recevdmstatusrule preserving type ) AS REValuationRuleStatus,
  cast( _ValuationTerm.statuseval as recevdmstatusevaluation preserving type ) AS REValuationStatus,
  cast( _ValuationTerm.statusreason as recevdmstatusreason preserving type ) AS REValuationStatusReason,
  _ValuationTerm.processbehavior AS REValuationBehavior,
  _ValuationTerm.taxtype AS RETaxType,
  _ValuationTerm.taxgroup AS TaxGroup,
  cast(_ValuationTerm.acctobjnr as recevdmacctobjnr preserving type ) AS REAccountingObject,
  _ValuationTerm.note AS REInfoText,
  _ValuationTerm.scopenum AS REValuationFactorNumerator,
  _ValuationTerm.scopedenom AS REValuationFactorDenominator,
  cast(_ValuationTerm.rulecurr as recevdmrulecurr preserving type ) AS REValuationCurrency,
  _ValuationTerm.queryguid AS REValuationQuestionnaireUUID,
  _REContract._CompanyCode.Country AS Country,
  _REContract._CompanyCode._Country AS _Country
FROM vicerule AS _ValuationTerm
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RETerm AS _RETerm ON InternalRealEstateNumber = _RETerm.InternalRealEstateNumber AND _RETerm.RETermType = '1500' AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_RETermType AS _RETermType ON _RETermType.RealEstateObjectType = 'IS' AND RETermType = _RETermType.RETermType  -- association [1..1]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REValuationObject ON REStatusObject = _REValuationObject.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_REValuationRule AS _REValuationRule ON REValuationRule = _REValuationRule.REValuationRule  -- association [0..1]
LEFT OUTER JOIN I_REFixedAssetRelation AS _REFixedAssetRelation ON REStatusObjectAsset = _REFixedAssetRelation.REStatusObjectAsset  -- association [0..1]
LEFT OUTER JOIN I_REValuationClassification AS _REValuationClassification ON REValuationClassification = _REValuationClassification.REValuationClassification  -- association [0..1]
LEFT OUTER JOIN I_REContrRhythmTerm AS _RERhythmTerm ON InternalRealEstateNumber = _RERhythmTerm.InternalRealEstateNumber AND _RERhythmTerm.RETermType = '1110' AND REFrequencyTerm = _RERhythmTerm.RETermNumber  -- association [0..*]
LEFT OUTER JOIN I_RECndnDistributionRuleExt AS _RECndnDistributionRuleExt ON REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule  -- association [0..1]
LEFT OUTER JOIN I_REValuationRuleStatus AS _REValuationRuleStatus ON REValuationRuleStatus = _REValuationRuleStatus.REValuationRuleStatus  -- association [0..1]
LEFT OUTER JOIN I_REValuationStatus AS _REValuationStatus ON REValuationStatus = _REValuationStatus.REValuationStatus  -- association [0..1]
LEFT OUTER JOIN I_REValuationStatusReason AS _REValuationStatusReason ON REValuationStatusReason = _REValuationStatusReason.REValuationStatusReason  -- association [0..1]
LEFT OUTER JOIN I_REValuationBehavior AS _REValuationBehavior ON REValuationBehavior = _REValuationBehavior.REValuationBehavior  -- association [0..1]
LEFT OUTER JOIN I_RETaxType AS _RETaxType ON Country = _RETaxType.Country AND RETaxType = _RETaxType.RETaxType  -- association [0..1]
LEFT OUTER JOIN I_RETaxGroup AS _RETaxGroup ON TaxGroup = _RETaxGroup.TaxGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON REValuationCurrency = _Currency.Currency  -- association [0..1]
;