I_RESalesCalculationResult

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_RESalesCalculationResult.
-- 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: IREOMSRPDETN

CREATE VIEW I_RESalesCalculationResult AS
SELECT
  RESalesResultUUID,
  REProcessUUID,
  InternalRealEstateNumber,
  cast(_REContract.RealEstateContract as recnnumber preserving type) AS RealEstateContract,
  _RESalesProcess.RealEstateProcess AS RealEstateProcess,
  _RESalesProcess.REProcessType AS REProcessType,
  _REContract.CompanyCode AS CompanyCode,
  Currency,
  RETermNumber,
  _RESalesRuleTermBasic.RETermName AS RETermName,
  ValidityStartDate,
  ValidityEndDate,
  RETrnsltnRuleLoclGrossAmount,
  RETrnsltnRuleLoclNetAmount,
  RETrnsltnRuleLoclTaxAmount,
  RESalesRentReceivableNetAmount,
  RESalesRentReceivableTaxAmount,
  REAdvancePaymentNetAmount,
  REAdvancePaymentTaxAmount
FROM I_RESlsCalculationResultBasic AS _RESlsCalculationResultBasic
LEFT OUTER JOIN I_REProcess AS _RESalesProcess ON REProcessUUID = _RESalesProcess.REProcessUUID  -- association [1..*]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_RESalesReportingTerm AS _RESalesReportingTerm ON InternalRealEstateNumber = _RESalesReportingTerm.InternalRealEstateNumber  -- association [1..*]
LEFT OUTER JOIN I_RESalesRuleTermBasic AS _RESalesRuleTermBasic ON InternalRealEstateNumber = _RESalesRuleTermBasic.InternalRealEstateNumber  -- association [1..*]
;