I_REConditionAddl

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_REConditionAddl.
-- 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: IRECONDITIONADDL

CREATE VIEW I_REConditionAddl AS
SELECT
  InternalRealEstateNumber,
  REConditionUUID,
  REStatusObjectCalculation,
  REConditionType,
  REExtConditionPurpose,
  cast(concat(ValidityStartDate, ValidityEndDate ) as recadateperiod) AS ValidityStartEndDateValue,
  ValidityStartDate,
  ValidityEndDate,
  REStatusObjectDistribution,
  REConditionCalcIsInvalid,
  REDistributionIsInvalid,
  REConditionObjTypeCalculation,
  REConditionObjTypeDistribution,
  REPostingTerm,
  REOrglAssignmentTerm,
  RERhythmTerm,
  REConditionIsToBeDeleted,
  REObjectTypeDistribution,
  REObjectTypePosting,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  REIsOneTimeCondition,
  REConditionIsStatistical,
  REAdjustmentNumber,
  RESalesTerm,
  REPeakSalesTerm,
  RESrvcChrgSettlementPostingTrm,
  REWithholdingTaxTerm,
  RECalculationRule,
  REUnitPrice,
  REConditionCurrency,
  RECalculationRuleParam1,
  RECalculationRuleParam2,
  REDistributionRule,
  REDistributionRuleParam1,
  REDistributionRuleParam2,
  REReasonForChange,
  REStsObjectParamCalculation,
  REStsObjectParamDistribution,
  RECashFlowPostingFromDate
FROM I_RECondition
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REEntryValidity AS _REEntryValidity ON REEntryValidity = _REEntryValidity.REEntryValidity  -- association [1..1]
LEFT OUTER JOIN I_REObjectAssgmtIdnAddl AS _REStatusObjectCalculation ON InternalRealEstateNumber = _REStatusObjectCalculation.InternalRealEstateNumber AND REStatusObjectCalculation = _REStatusObjectCalculation.REStatusObjectTarget  -- association [0..1]
LEFT OUTER JOIN I_REObjectAssgmtIdnAddl AS _REStatusObjectDistribution ON InternalRealEstateNumber = _REStatusObjectDistribution.InternalRealEstateNumber AND REStatusObjectDistribution = _REStatusObjectDistribution.REStatusObjectTarget  -- association [0..1]
;