I_REContrRhythmTerm

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_REContrRhythmTerm.
-- 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: IRERHYTHMTERM

CREATE VIEW I_REContrRhythmTerm AS
SELECT
  intreno AS InternalRealEstateNumber,
  termtype AS RETermType,
  termno AS RETermNumber,
  cast(validfrom as rebdvdmvalidfrom preserving type) AS ValidityStartDate,
  cast(validto as rebdvdmvalidto preserving type) AS ValidityEndDate,
  cast( frequency as recdvdmfrequency preserving type ) AS RENumberOfFrequencyUnits,
  cast(frequencyunit as recdvdmfrequencyunit) AS REFrequencyUnit,
  cast(weekfrom as recdvdmweekfrom) AS REStartFrequencyWeek,
  cast(monthfrom as recdvdmmonthfrom) AS REFrequencyStart,
  cast(condvaluerefer as recdvdmcondvaluerefer ) AS REConditionAmountReference,
  cast(condvaluerefdif as retmvdmcondvaluerefdif) AS REConditionAmountDiff,
  cast(prorate as recdvdmprorate) AS REProRataMethod,
  cast(calcmethper as recdvdmcalcmethper) AS REProRataMethodCalc,
  cast(paymentformrh as recdvdmpaymentformrh) AS REPaymentForm,
  rhythmbegin AS REFrequencyStartDate,
  duedatecorrrule AS REDueDateCorrectionRule,
  duedatecorrday AS REDueDateNumberOfCrrtnDays,
  duedatecorrmonth AS REDueDateNumberOfCrrtnMonths,
  duedatecorryear AS REDueDateNumberOfCrrtnYears,
  duedatecorrcal AS REDueDateNumberOfCrrtnCalendar,
  cast(duedatecorrcalun as recdvdmduedatecorrcalunit ) AS REDueDateCrrtnCalendarUnit,
  duedatecalender AS FactoryCalendar,
  duedatemovebegin AS REDueDateIsAtBeginning,
  duedatemoveend AS REDueDateIsAtEnd,
  fixper AS REFixedPeriod,
  _REKeyAssgmt.RealEstateObjectType AS RealEstateObjectType,
  _REKeyAssgmt._REObjectType AS _REObjectType
FROM vitmrh
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- 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_RETerm AS _RETerm ON InternalRealEstateNumber = _RETerm.InternalRealEstateNumber AND RETermType = _RETerm.RETermType AND RETermNumber = _RETerm.RETermNumber  -- association [1..1]
LEFT OUTER JOIN I_REFrequencyUnit AS _REFrequencyUnit ON REFrequencyUnit = _REFrequencyUnit.REFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_REStartFrequencyWeek AS _REStartFrequencyWeek ON REStartFrequencyWeek = _REStartFrequencyWeek.REStartFrequencyWeek  -- association [0..1]
LEFT OUTER JOIN I_REFrequencyStart AS _REFrequencyStart ON REFrequencyStart = _REFrequencyStart.REFrequencyStart  -- association [0..1]
LEFT OUTER JOIN I_REConditionAmtRef AS _REConditionAmtRef ON REConditionAmountReference = _REConditionAmtRef.REConditionAmountReference  -- association [0..1]
LEFT OUTER JOIN I_REConditionAmtDiff AS _REConditionAmtDiff ON REConditionAmountDiff = _REConditionAmtDiff.REConditionAmountDiff  -- association [0..1]
LEFT OUTER JOIN I_REProRataMethod AS _REProRataMethod ON REProRataMethod = _REProRataMethod.REProRataMethod  -- association [0..1]
LEFT OUTER JOIN I_REProRataMethodCalc AS _REProRataMethodCalc ON REProRataMethodCalc = _REProRataMethodCalc.REProRataMethodCalc  -- association [0..1]
LEFT OUTER JOIN I_REPaymentForm AS _REPaymentForm ON REPaymentForm = _REPaymentForm.REPaymentForm  -- association [0..1]
LEFT OUTER JOIN I_REDueDateCrrtnRule AS _REDueDateCrrtnRule ON REDueDateCorrectionRule = _REDueDateCrrtnRule.REDueDateCorrectionRule  -- association [0..1]
LEFT OUTER JOIN I_REDueDateCrrtnCalUnit AS _REDueDateCrrtnCalendarUnit ON REDueDateCrrtnCalendarUnit = _REDueDateCrrtnCalendarUnit.REDueDateCrrtnCalendarUnit  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_REFixedPeriod AS _REFixedPeriod ON REFixedPeriod = _REFixedPeriod.REFixedPeriod  -- association [0..1]
;