I_MfgOrderComponentAssembly

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_MfgOrderComponentAssembly.
-- 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: IMPECOMPASSEMBLE

CREATE VIEW I_MfgOrderComponentAssembly AS
SELECT
  asm.adoc_number AS AssemblyDocument,
  asm.adoc_item AS AssemblyDocumentItem,
  asm.rsnum AS Reservation,
  asm.rspos AS ReservationItem,
  asm.rsart AS RecordType,
  asm.oan_instance_id AS OpActyNtwkInstance,
  asm.oan_element_number AS OpActyNtwkElement,
  asm.parent_sfi_id AS AssemblyShopFloorItem,
  asm.sfi_id AS ShopFloorItem,
  asm.batch AS Batch,
  asm.material AS Material,
  asm.pl_quantity AS RequiredQuantity,
  asm.quantity AS MaterialComponentQuantity,
  asm.uom AS MaterialBaseUnit,
  asm.crtn_time AS CreationDateTime,
  asm.crtn_user AS CreatedByUser,
  asm.werks AS Plant,
  asm.lgort AS StorageLocation,
  cast(asm.insmk as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  asm.gm_status AS CompAssemblyGoodsMvtStatus,
  asm.is_posted_retroactively AS PostingIsRetroactive,
  asm.erfmg AS QuantityInEntryUnit,
  asm.erfme AS EntryUnit,
  asm.mblnr AS MaterialDocument,
  asm.mjahr AS MaterialDocumentYear,
  cast(asm.weblnr as pph_weblnr preserving type) AS GoodsMovementException,
  cast(asm.weblpos as pph_weblpos preserving type) AS GoodsMovementExceptionItem,
  asm.exec_oan_instance_id AS ExecOpActyNtwkInstance,
  asm.exec_oan_element_number AS ExecOpActyNtwkElement,
  asm.shkzg AS DebitCreditCode,
  asm.crrtn_doc_number AS AssemblyCorrectionDocument,
  asm.crrtn_item_type AS AssemblyCorrectionItemType,
  asm.sfi_grp_assy_doc_number AS OpActySFIGrpAssemblyDocument,
  asm.sfi_grp_assy_doc_item AS OpActySFIGrpAssyDocumentItem
FROM mpe_comp_assembl AS asm
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.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_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ParentShopFloorItem ON AssemblyShopFloorItem = _ParentShopFloorItem.ShopFloorItem  -- association [1..1]
LEFT OUTER JOIN I_BatchDistinct AS _BatchDistinct ON ( Plant = _BatchDistinct.Plant OR _BatchDistinct.Plant = ' ' ) AND Material = _BatchDistinct.Material AND Batch = _BatchDistinct.Batch  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialBaseUnit ON MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON MaterialDocument = _MaterialDocumentHeader.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementException AS _GoodsMovementException ON GoodsMovementException = _GoodsMovementException.GoodsMovementException  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementExceptionItem AS _GoodsMovementExceptionItem ON GoodsMovementException = _GoodsMovementExceptionItem.GoodsMovementException AND GoodsMovementExceptionItem = _GoodsMovementExceptionItem.GoodsMovementExceptionItem  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _ExecOpActyNtwkInstance ON ExecOpActyNtwkInstance = _ExecOpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _ExecOperationActivityInstance ON ExecOpActyNtwkInstance = _ExecOperationActivityInstance.OpActyNtwkInstance AND ExecOpActyNtwkElement = _ExecOperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCompAssyCorrection AS _MfgOrderCompAssyCorrection ON AssemblyCorrectionDocument = _MfgOrderCompAssyCorrection.AssemblyCorrectionDocument  -- association [0..1]
;