I_REValuationRuleCondition

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_REValuationRuleCondition.
-- 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: IREVALUATIONCNDN

CREATE VIEW I_REValuationRuleCondition AS
SELECT
  intreno AS InternalRealEstateNumber,
  ruleguid AS REValuationRuleUUID,
  condguid AS REConditionUUID,
  cdprop AS REValuationCndnProperty,
  cdcons AS REValuationCndnConsdtn,
  considercond AS REIsValuationCndnConsdtn,
  condperc AS REValuationCndnSharePercent,
  condabs AS REValuationCndnShareAbsltAmt,
  cast(currency as recdvdmvalcurr preserving type ) AS REValuationCurrency,
  statuscondrule AS REValuationCndnStatus,
  note AS REInfoText,
  _REValuationTerm.REValuationRule AS REValuationRule
FROM vicecondrule
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [0..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REValuationTerm AS _REValuationTerm ON InternalRealEstateNumber = _REValuationTerm.InternalRealEstateNumber AND REValuationRuleUUID = _REValuationTerm.REValuationRuleUUID  -- association [1..1]
LEFT OUTER JOIN I_REContrCondition AS _RECondition ON REConditionUUID = _RECondition.REConditionUUID  -- association [1..1]
LEFT OUTER JOIN I_REValuationCndnProperty AS _REValuationCndnProperty ON REValuationCndnProperty = _REValuationCndnProperty.REValuationCndnProperty  -- association [0..1]
LEFT OUTER JOIN I_REValuationCndnConsdtn AS _REValuationCndnConsdtn ON REValuationCndnConsdtn = _REValuationCndnConsdtn.REValuationCndnConsdtn  -- association [0..1]
LEFT OUTER JOIN I_REValuationCndnStatus AS _REValuationCndnStatus ON REValuationCndnStatus = _REValuationCndnStatus.REValuationCndnStatus  -- association [0..1]
LEFT OUTER JOIN I_REValuationRule AS _REValuationRule ON REValuationRule = _REValuationRule.REValuationRule  -- association [0..1]
;