I_RECondition

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_RECondition.
-- 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: IRECONDITION

CREATE VIEW I_RECondition AS
SELECT
  condguid AS REConditionUUID,
  intreno AS InternalRealEstateNumber,
  condtype AS REConditionType,
  cast(objnr as recdvdmobjnr preserving type ) AS REStatusObjectCalculation,
  cast (condvalidfrom as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast(objnrdist as recdvdmobjnrdist preserving type ) AS REStatusObjectDistribution,
  cast(objtypedistdist as recdvdmobjtypedist preserving type ) AS REObjectTypeDistribution,
  cast(objtypedistpost as recdvdmtermnopy preserving type ) AS REObjectTypePosting,
  cast ( condvalidto as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  rerf AS CreatedByUser,
  derf AS CreationDate,
  terf AS CreationTime,
  reher AS RESourceOfCreation,
  rbear AS LastChangedByUser,
  dbear AS LastChangeDate,
  tbear AS LastChangeTime,
  rbher AS RESourceOfChange,
  uniquecond AS REIsOneTimeCondition,
  cast(infocond as recdvdminfocond preserving type ) AS REConditionIsStatistical,
  termnopy AS REPostingTerm,
  cast(termnorh as recdvdmtermnrhy preserving type ) AS RERhythmTerm,
  termnoaj AS REAdjustmentNumber,
  cast(termnooa as recdvdmtermnooa preserving type ) AS REOrglAssignmentTerm,
  termnosr AS RESalesTerm,
  termnomr AS REPeakSalesTerm,
  termnopyscs AS RESrvcChrgSettlementPostingTrm,
  termnowt AS REWithholdingTaxTerm,
  calcrule AS RECalculationRule,
  unitprice AS REUnitPrice,
  cast(condcurr as recdvdmcondcurr preserving type ) AS REConditionCurrency,
  calcrulepara1 AS RECalculationRuleParam1,
  calcrulepara2 AS RECalculationRuleParam2,
  cast(distrule as recdvdmdistrule preserving type ) AS REDistributionRule,
  distrulepara1 AS REDistributionRuleParam1,
  distrulepara2 AS REDistributionRuleParam2,
  cast(condpurposeext as recdvdmcondpurposeext preserving type ) AS REExtConditionPurpose,
  chgreason AS REReasonForChange,
  cast( objnrcalcpara as recdvdmobjnrparacalc preserving type ) AS REStsObjectParamCalculation,
  cast( objnrdistpara as recdvdmobjnrparadist preserving type ) AS REStsObjectParamDistribution,
  duedatecorr AS REDueDateTotNumberOfCrrtnDays,
  duedatecorrday AS REDueDateNumberOfCrrtnDays,
  duedatecorrmonth AS REDueDateNumberOfCrrtnMonths,
  cfpostingfrom AS RECashFlowPostingFromDate,
  exduedate AS REConditionExceptionalDueDate,
  duedateup AS REConditionFollowUpDueDate,
  invalidcalc AS REConditionCalcIsInvalid,
  invaliddist AS REDistributionIsInvalid,
  termnopyscsact AS REServiceChrgSettlementIsActv,
  conddelete AS REConditionIsToBeDeleted,
  cast( left(objnr,2) as rebdbusobjtypecn preserving type ) AS REConditionObjTypeCalculation,
  cast( left(objnrdist,2) as rebdbusobjtypecn preserving type ) AS REConditionObjTypeDistribution
FROM vicdcond
LEFT OUTER JOIN I_Currency AS _Currency ON REConditionCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_REKeyAssgmt AS _REKeyAssgmt ON InternalRealEstateNumber = _REKeyAssgmt.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN I_REConditionType AS _REConditionType ON REConditionType = _REConditionType.REConditionType  -- association [0..1]
LEFT OUTER JOIN I_RECndnCalculationRuleExt AS _RECndnCalculationRuleExt ON RECalculationRule = _RECndnCalculationRuleExt.RECalculationRule  -- association [0..1]
LEFT OUTER JOIN I_REObjectTypeDistribution AS _REObjectTypeDistribution ON REObjectTypeDistribution = _REObjectTypeDistribution.REObjectTypeDistribution  -- association [0..1]
LEFT OUTER JOIN I_REObjectTypePosting AS _REObjectTypePosting ON REObjectTypePosting = _REObjectTypePosting.REObjectTypePosting  -- association [0..1]
LEFT OUTER JOIN I_RECndnDistributionRuleExt AS _RECndnDistributionRuleExt ON REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule  -- association [0..1]
LEFT OUTER JOIN I_REConditionPurposeExt AS _REConditionPurposeExt ON REExtConditionPurpose = _REConditionPurposeExt.REExtConditionPurpose  -- association [0..1]
LEFT OUTER JOIN I_REConditionChangeReason AS _REConditionChangeReason ON REReasonForChange = _REConditionChangeReason.REReasonForChange AND REConditionType = _REConditionChangeReason.REConditionType  -- association [0..1]
LEFT OUTER JOIN I_REObjectType AS _REConditionObjTypeCalculation ON REConditionObjTypeCalculation = _REConditionObjTypeCalculation.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REObjectGroup AS _REObjectGroupCalculation ON REStatusObjectCalculation = _REObjectGroupCalculation.REStatusObject  -- association [0..*]
LEFT OUTER JOIN I_REContractSubject AS _REContractSubjectCalculation ON REStatusObjectCalculation = _REContractSubjectCalculation.REStatusObject  -- association [0..*]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectCalculation ON REStatusObjectCalculation = _REObjectCalculation.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenterCalculation ON REStatusObjectCalculation = _CostCenterCalculation.ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementCalculation ON REStatusObjectCalculation = _WBSElementCalculation.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrderCalculation ON REStatusObjectCalculation = _InternalOrderCalculation.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObjectCalculation ON REStatusObjectCalculation = _TechnicalObjectCalculation.MaintObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_REObjectType AS _REConditionObjTypeDistr ON REConditionObjTypeDistribution = _REConditionObjTypeDistr.RealEstateObjectType  -- association [1..1]
LEFT OUTER JOIN I_REObjectGroup AS _REObjectGroupDistribution ON REStatusObjectDistribution = _REObjectGroupDistribution.REStatusObject  -- association [0..*]
LEFT OUTER JOIN I_REContractSubject AS _REContractSubjectDistribution ON REStatusObjectDistribution = _REContractSubjectDistribution.REStatusObject  -- association [0..*]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectDistribution ON REStatusObjectDistribution = _REObjectDistribution.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenterDistribution ON REStatusObjectDistribution = _CostCenterDistribution.ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementDistribution ON REStatusObjectDistribution = _WBSElementDistribution.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrderDistribution ON REStatusObjectDistribution = _InternalOrderDistribution.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_REConditionCalculation AS _REConditionCalculation ON REConditionUUID = _REConditionCalculation.REConditionUUID  -- association [0..*]
LEFT OUTER JOIN I_REConditionDistribution AS _REConditionDistribution ON REConditionUUID = _REConditionDistribution.REConditionUUID  -- association [0..*]
LEFT OUTER JOIN I_REOrganizationalAssgmtTerm AS _REOrganizationalAssgmtTerm ON InternalRealEstateNumber = _REOrganizationalAssgmtTerm.InternalRealEstateNumber AND REOrglAssignmentTerm = _REOrganizationalAssgmtTerm.RETermNumber  -- association [1..*]
LEFT OUTER JOIN I_REPostingTerm AS _REPostingTerm ON InternalRealEstateNumber = _REPostingTerm.InternalRealEstateNumber AND REPostingTerm = _REPostingTerm.RETermNumber  -- association [1..*]
LEFT OUTER JOIN I_RERhythmTerm AS _RERhythmTerm ON InternalRealEstateNumber = _RERhythmTerm.InternalRealEstateNumber AND RERhythmTerm = _RERhythmTerm.RETermNumber  -- association [1..*]
LEFT OUTER JOIN I_REAdjustmentTerm AS _REAdjustmentTerm ON InternalRealEstateNumber = _REAdjustmentTerm.InternalRealEstateNumber AND REAdjustmentNumber = _REAdjustmentTerm.RETermNumber  -- association [1..*]
;