I_RESalesReportingTerm

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_RESalesReportingTerm.
-- 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: IRETMSALESRPTG

CREATE VIEW I_RESalesReportingTerm AS
SELECT
  intreno AS InternalRealEstateNumber,
  termtype AS RETermType,
  termno AS RETermNumber,
  validfrom AS ValidityStartDate,
  _RESalesRptgFrqcyAssgmt.RESalesRhythmType AS RESalesRhythmType,
  cast(validto as rebdvdmvalidto) AS ValidityEndDate,
  _RETerm.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt.REStatusObject AS REStatusObject,
  _RETerm.RETermName AS RETermName,
  salestype AS RESalesType,
  salesreporttype AS RESalesReportType,
  is_statistical AS REIsStatisticalRule,
  use_measpoint AS RESalesReportingIsUsingMsmt,
  meas AS REMeasurementType,
  measpoint_objnr AS REStatusObjectMeasurement,
  measpoint AS MeasuringPoint,
  loc_key AS RERgnlLocKeyHeatingValDays,
  _RESalesRptgFrqcyAssgmt.REFrequencyStartDate AS REFrequencyStartDate,
  _RESalesRptgFrqcyAssgmt.RENumberOfFrequencyUnits AS RENumberOfFrequencyUnits,
  _RESalesRptgFrqcyAssgmt.REFrequencyUnit AS REFrequencyUnit,
  _RESalesRptgFrqcyAssgmt.REFixedPeriod AS REFixedPeriod,
  _RESalesRptgFrqcyAssgmt.RESalesReportingTolerance AS RESalesReportingTolerance,
  _RESalesRptgFrqcyAssgmt.RESalesReportingToleranceUnit AS RESalesReportingToleranceUnit,
  _RESalesRptgFrqcyAssgmt.RESalesRptgToleranceCalendar AS RESalesRptgToleranceCalendar,
  _RESalesRptgFrqcyAssgmt.REFrequencyExcludedStartDate AS REFrequencyExcludedStartDate,
  _RESalesRptgFrqcyAssgmt.REFrequencyExcludedEndDate AS REFrequencyExcludedEndDate,
  _RESalesRptgFrqcyAssgmt._RESalesRhythmType AS _RESalesRhythmType,
  _RESalesRptgFrqcyAssgmt._REFixedPeriod AS _REFixedPeriod,
  _RETerm._REObjectType AS _REObjectType
FROM visrtmrp AS _SalesReportingTerm
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 RETermType = _RETerm.RETermType AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_RETermType AS _RETermType ON RETermType = _RETermType.RETermType AND RealEstateObjectType = _RETermType.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_RESalesReportingFrqcyAssgmt AS _RESalesRptgFrqcyAssgmt ON InternalRealEstateNumber = _RESalesRptgFrqcyAssgmt.InternalRealEstateNumber AND RETermNumber = _RESalesRptgFrqcyAssgmt.RESalesReportingTermNumber AND ValidityStartDate = _RESalesRptgFrqcyAssgmt.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_RESalesType AS _RESalesType ON RESalesType = _RESalesType.RESalesType  -- association [0..1]
LEFT OUTER JOIN I_RESalesReportType AS _RESalesReportType ON RESalesReportType = _RESalesReportType.RESalesReportType  -- association [0..1]
LEFT OUTER JOIN I_REMeasurementType AS _REMeasurementType ON REMeasurementType = _REMeasurementType.REMeasurementType  -- association [0..1]
LEFT OUTER JOIN I_MeasuringPoint AS _MeasuringPoint ON MeasuringPoint = _MeasuringPoint.MeasuringPoint  -- association [0..1]
LEFT OUTER JOIN I_RERgnlLocKeyHeatingValDays AS _RERgnlLocKeyHeatingDays ON RERgnlLocKeyHeatingValDays = _RERgnlLocKeyHeatingDays.RERgnlLocKeyHeatingValDays  -- association [0..1]
;