R_REContrSalesRuleTermTP

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 R_REContrSalesRuleTermTP.
-- 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 R_REContrSalesRuleTermTP AS
SELECT
  InternalRealEstateNumber,
  RETermNumber,
  RETermType,
  cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) AS ValidityStartEndDateValue,
  RESalesReportingTermNumber,
  RESalesItemNumberGrading,
  cast( coalesce(ValidityStartDate, '00000000') as rebdvdmvalidfrom ) AS ValidityStartDate,
  cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto ) AS ValidityEndDate,
  RETermName,
  RealEstateObjectType,
  REStatusObject,
  RESalesRule,
  REIsPeakSalesRule,
  RESalesRuleIsUsingPeriodicPost,
  RESalesCurrency,
  RESalesUnit,
  RESalesAmountType,
  RESalesQuantityAmountType,
  REMinSalesAmount,
  REMinSalesRptgIntervalAmount,
  REMinSalesQuantity,
  REMinSalesRptgIntervalQuantity,
  REMaxSalesAmount,
  REMaxSalesQuantity,
  RESalesUnitGrading,
  REMinSalesGradingAmount,
  REMaxSalesGradingAmount,
  REMinSalesGradingQuantity,
  REMaxSalesGradingQuantity,
  REPerUnitGradingPrice,
  RESalesMinRentGradingAmount,
  RESalesRentGradingPercent
;