I_OpActyCompInstceAssignment

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_OpActyCompInstceAssignment.
-- 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: IMPEOACMPINSTASS

CREATE VIEW I_OpActyCompInstceAssignment AS
SELECT
  rsnum AS Reservation,
  rspos AS ReservationItem,
  rsart AS RecordType,
  oan_instance_id AS OpActyNtwkInstance,
  oan_element_number AS OpActyNtwkElement,
  inst_guid AS OriglDgtlMockUpCharcsUUID,
  tmxguid AS DgtlMockUpCharcsUUID,
  inst_guid_reference AS ReltdOriglDgtlMockUpCharcsUUID,
  mrs_leaf_assignment_uuid AS MfgRefStrucBOMLeafAssgmtUUID,
  mrs_item_detail_uuid AS MfgRefStructureItemDetailUUID,
  mrs_item_detail_is_contextual AS MfgRefStrucItmDetIsContextual
FROM mpe_cmp_oai_inst
LEFT OUTER JOIN I_OpActyComponentAssignment AS _OpActyComponentAssignment ON Reservation = _OpActyComponentAssignment.Reservation AND ReservationItem = _OpActyComponentAssignment.ReservationItem AND RecordType = _OpActyComponentAssignment.RecordType AND OpActyNtwkInstance = _OpActyComponentAssignment.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyComponentAssignment.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic ON OpActyNtwkInstance = _OpActyNtwkInstanceBasic.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _ReservationHeader ON Reservation = _ReservationHeader.Reservation  -- association [1..1]
LEFT OUTER JOIN I_InstanceReferenceDesignator AS _InstanceReferenceDesignator ON DgtlMockUpCharcsUUID = _InstanceReferenceDesignator.DgtlMockUpCharcsUUID  -- association [0..1]
LEFT OUTER JOIN I_OpActyCompInstceAssignment AS _ReltdOpActyCompAssgmt ON OpActyNtwkInstance = _ReltdOpActyCompAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _ReltdOpActyCompAssgmt.OpActyNtwkElement AND Reservation = _ReltdOpActyCompAssgmt.Reservation AND ReservationItem = _ReltdOpActyCompAssgmt.ReservationItem AND RecordType = _ReltdOpActyCompAssgmt.RecordType AND ReltdOriglDgtlMockUpCharcsUUID = _ReltdOpActyCompAssgmt.OriglDgtlMockUpCharcsUUID  -- association [0..1]
LEFT OUTER JOIN I_DigitalMockUpCharcs AS _DigitalMockUpCharcs ON DgtlMockUpCharcsUUID = _DigitalMockUpCharcs.DgtlMockUpCharcsUUID  -- association [0..*]
LEFT OUTER JOIN I_BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt ON MfgRefStrucBOMLeafAssgmtUUID = _BOMItmMfgRefStrucItmAssgmt.MfgRefStrucBOMLeafAssgmtUUID  -- association [0..1]
LEFT OUTER JOIN I_MfgReferenceStructureItem AS _MfgReferenceStructureItem ON MfgRefStructureItemDetailUUID = _MfgReferenceStructureItem.MfgRefStructureItemUUID AND MfgRefStrucItmDetIsContextual = ''  -- association [0..1]
LEFT OUTER JOIN I_MfgReferenceHierarchyItem AS _MfgReferenceHierarchyItem ON MfgRefStructureItemDetailUUID = _MfgReferenceHierarchyItem.MfgRefHierarchyItemUUID AND MfgRefStrucItmDetIsContextual = 'X'  -- association [0..1]
LEFT OUTER JOIN I_MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefStrucItemWithDetails.MfgRefStructureItemUUID AND MfgRefStrucItmDetIsContextual = ''  -- association [0..1]
LEFT OUTER JOIN I_MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails ON MfgRefStructureItemDetailUUID = _MfgRefHierItemWithDetails.MfgRefHierarchyItemUUID AND MfgRefStrucItmDetIsContextual = 'X'  -- association [0..1]
;