R_REContractTP

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_REContractTP.
-- 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_REContractTP AS
SELECT
  InternalRealEstateNumber,
  CompanyCode,
  RealEstateContract,
  REStatusObject,
  REInternalFinNumber,
  RealEstateContractOID,
  REContractAlternativeID,
  REIdentificationKey,
  RECreationType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REUserExclusive,
  REAuthorizationGroup,
  REContractType,
  ContractStartDate,
  ContractEndDate,
  REContractName,
  REContractActivateDate,
  RETenancyLaw,
  REContractNumberOld,
  REMainContractCompanyCode,
  REMainContract,
  REContractCurrency,
  REIndustrySector,
  REIsSalesRelevant,
  REContractDepositType,
  REContractSignDate,
  REContract2SignDate,
  REContractCashFlowDate,
  REContractFirstEndDate,
  REContractNoticeDate,
  REContractNoticeInDate,
  REContractNoticeReason,
  REContractNoticeActivationDate,
  RECashFlowArchivedToDate,
  RECashFlowLockedToDate,
  RECashFlowPostingFromDate,
  REBusinessEntity,
  REPossessionStartDate,
  REPossessionEndDate,
  REHasMultipleAssignments,
  REObjectAvailableFromDate,
  REObjectAvailableToDate,
  ValuationRelevance,
  _StatusObject.StatusProfile AS StatusProfile,
  RealEstateObjectType,
  _REContractType.REBusinessPartnerRole1 AS REBusinessPartnerRole1
FROM I_REContract AS REContract
LEFT OUTER JOIN I_REContractAddl AS _REContractAddl ON InternalRealEstateNumber = _REContractAddl.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_StatusProfiletext AS _StatusProfileText ON StatusProfile = _StatusProfileText.StatusProfile  -- association [0..*]
LEFT OUTER JOIN E_REContract AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN P_REActVlnForCoCodeContrType AS _ValuationRules ON CompanyCode = _ValuationRules.CompanyCode AND REContractType = _ValuationRules.REContractType  -- association [0..1]
LEFT OUTER JOIN R_REContrPartAssgmtTP AS _REPartnerAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrObjAssgmtTP AS _REObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrOrglAssgmtTermTP AS _REOrglAssgmtTermTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_REContrPostingTermTP AS _REPostingTermTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_REContrRhythmTermTP AS _RERhythmTermTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_REContrRenewalTermAndRulesTP AS _RERenewalTermAndRulesTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrRenewalTermTP AS _RERenewalTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContractRenewalTP AS _RERenewalTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContractNoticeTP AS _RENoticeTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrNoticeTermTP AS _RENoticeTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrNoticeTermAndRulesTP AS _RENoticeTermAndRulesTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrConditionTP AS _REConditionTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrNoticeTermForObjTP AS _RENoticeTermForObjTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrAdjustmentTermTP AS _REAdjustmentTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrReminderRuleTP AS _REReminderRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrReminderRuleMainTP AS _REReminderRuleMainTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrReminderDateTP AS _REReminderDateTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrValuationTP AS _REValuationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrValuationConditionTP AS _REValuationConditionTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrSalesRuleTermTP AS _RESalesRuleTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrSalesReportingTermTP AS _RESalesReportingTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrSalesRuleFrqcyTermTP AS _RESalesRuleFrqcyTermTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrRegistryEntryTP AS _RERegistryEntryTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrValuationProcStepTP AS _REValuationProcessStepTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_REContrStatusObjectTP AS _REStatusObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
;