P_MfgOrderCompAssemblyHistory

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 P_MfgOrderCompAssemblyHistory.
-- 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: PMPECOMPASSYHIST

CREATE VIEW P_MfgOrderCompAssemblyHistory AS
SELECT
  MfgOrderCompAssemblyAction.AssemblyDocument AS ManufacturingExecutionDocument,
  cast(MfgOrderCompAssemblyAction.AssemblyDocumentItem as mpe_doc_item preserving type) AS MfgExecutionDocumentItem,
  MfgOrderCompAssemblyAction.MfgProcgExecAction AS MfgProcgExecAction,
  cast(MfgOrderCompAssemblyAction.CreationDateTime as mpe_perform_timestamp) AS EventDateTime,
  cast(MfgOrderCompAssemblyAction.CreatedByUser as mpe_performed_by_user preserving type) AS ShopFloorExecutionUser,
  cast(MfgOrderCompAssemblyAction.CreatedByUser as mpe_create_user preserving type) AS CreatedByUser,
  cast(MfgOrderCompAssemblyAction.CreationDateTime as mpe_create_timestampl preserving type) AS CreationDateTime,
  MfgOrderCompAssemblyAction.AssemblyShopFloorItem AS ShopFloorItem,
  MfgOrderCompAssemblyAction.ExecOpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderCompAssemblyAction.ExecOpActyNtwkElement AS OpActyNtwkElement,
  cast(MfgOrderCompAssemblyAction.Material as mpe_component_matnr preserving type) AS MaterialComponent,
  MfgOrderCompAssemblyAction.ShopFloorItem AS AssembledShopFloorItem,
  cast(MfgOrderCompAssemblyAction._ShopFloorItem.SerialNumber as mpe_assembled_sernr preserving type) AS AssembledSerialNumber,
  cast(MfgOrderCompAssemblyAction._ShopFloorItem._Equipment.ManufacturerSerialNumber as mpe_assembled_mfr_sernr preserving type) AS AssembledMfrSerialNumber,
  cast(MfgOrderCompAssemblyAction.Batch as mpe_assembled_batch preserving type) AS AssembledBatch,
  OrderComponentBasic.AlternativeItemGroup AS AlternativeItemGroup,
  InstanceReferenceDesignator.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  MfgOrderCompAssemblyAction.StorageLocation AS StorageLocation,
  MfgOrderCompAssemblyAction.InventoryUsabilityCode AS InventoryUsabilityCode,
  OpActySFIGrpCompAssembly.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  PostingIsRetroactive,
  cast('MPE_EXEC_SFO' as msgid) AS SystemMessageIdentification,
  23 AS MfgExecHistMsgVarblField2
FROM P_MfgOrderCompAssemblyAction AS MfgOrderCompAssemblyAction
LEFT OUTER JOIN I_MaterialText AS _MaterialComponentText ON MaterialComponent = _MaterialComponentText.Material AND _MaterialComponentText.Language = $session.system_language  -- association [0..1]
;