I_REListOfRents

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_REListOfRents.
-- 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: IRELISTOFRENTS

CREATE VIEW I_REListOfRents AS
SELECT
  rlra AS REListOfRents,
  cast (rlravalidfrom as rebdvdmvalidto) AS ValidityStartDate,
  cast (rlravalidto as rebdvdmvalidto) AS ValidityEndDate,
  rlrahasloc AS REListOfRentsHasLocationClass,
  rlrahasffct AS REListOfRentsHasFixtureCat,
  rlrahaslabel AS REListOfRentsHasLabel,
  rlrahassrch AS REListOfRentsHasCategories,
  rlravalstruc AS REListOfRentsCalcIsActivated,
  rlracurrency AS Currency,
  rlraadjmbaseind AS REListOfRentsCalcMethod,
  rlraadjmpoints AS REListOfRentsAdjmtIsBsdOnPoint,
  rlramainrlra AS REMainListOfRents,
  rlrasizmeas AS RESizeClassAreaType,
  rlrasizunit AS RESizeClassAreaUnit,
  rlrahassiz AS REListOfRentsHasSizeClass,
  rlrahasage AS REListOfRentsHasBuildingAgeCat,
  rlrachctpointweighted AS RERentCalcIsPointWeighted
FROM tivajrlra
LEFT OUTER JOIN I_REListOfRentsText AS _Text ON REListOfRents = _Text.REListOfRents  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;