I_REObjectAssgmt

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_REObjectAssgmt.
-- 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: IREOBJECTASS

CREATE VIEW I_REObjectAssgmt AS
SELECT
  objnrsrc AS REStatusObjectSource,
  objasstype AS REObjectAssignmentType,
  objnrtrg AS REStatusObjectTarget,
  cast( coalesce(validfrom,'00000000') as rebdvdmvalidfrom preserving type ) AS ValidityStartDate,
  cast( coalesce(validto,'99991231') as rebdvdmvalidto preserving type ) AS ValidityEndDate,
  assignonlyinfo AS REOnlyInfoAssgmt,
  objnrsrcarch AS REStatusObjectSourceIsArchived,
  flgentype AS REGenerationType,
  ismainasset AS REIsMainAsset,
  ismultiassgen AS REAssignmentHasMultiple,
  possdatefrom AS REObjectPossessionStartDate,
  possdateto AS REObjectPossessionEndDate,
  isleadingobject AS REIsLeadingObject
FROM vibdobjass AS REObjectAssgmt
LEFT OUTER JOIN I_REContractSubject AS _REContractSubject ON REStatusObjectTarget = _REContractSubject.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_REObjectGroup AS _REObjectGroup ON REStatusObjectTarget = _REObjectGroup.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON REStatusObjectTarget = _REObjectTypeDetails.REStatusObject  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REStatusObjectTarget = _CostCenter.ObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REStatusObjectTarget = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REStatusObjectTarget = _InternalOrder.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_REFixedAssetRelation AS _FixedAsset ON REStatusObjectTarget = _FixedAsset.REStatusObjectAsset  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON REStatusObjectTarget = _TechnicalObject.MaintObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_REObjectAssignmentType AS _REObjectAssignmentType ON REObjectAssignmentType = _REObjectAssignmentType.REObjectAssignmentType  -- association [1..1]
LEFT OUTER JOIN I_REGenerationType AS _REGenerationType ON REGenerationType = _REGenerationType.REGenerationType  -- association [0..1]
;