P_MfgExecEventHistOperation

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_MfgExecEventHistOperation.
-- 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: PMPEEXECHISTOP

CREATE VIEW P_MfgExecEventHistOperation AS
SELECT
  cast(oper.Sequence as manufacturingordersequence preserving type) AS ManufacturingOrderSequence,
  cast(oper.Operation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  cast(oper.OperationText as mfgorderoperationtext preserving type) AS MfgOrderOperationText,
  cast(oper.WorkCenterInternalID as pph_arbid preserving type) AS WorkCenterInternalID,
  oai._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  cast(' ' as mpe_buyoff_action preserving type) AS MfgBuyOffAction,
  cast(0 as mpe_log_event) AS MfgObjectLogEventType,
  cast(act.CreatedByUser as mpe_performed_by_user preserving type) AS ShopFloorExecutionUser,
  cast(act.CreatedByUser as mpe_create_user preserving type) AS CreatedByUser,
  cast(act.CreationDateTime as mpe_create_timestampl preserving type) AS CreationDateTime,
  cast(700 as rszsort) AS SortField,
  cast('0' as mpe_oan_segment_type preserving type) AS OpActyNtwkSegmentType,
  cast(0 as mpe_oan_id) AS OperationActivityNetwork,
  cast(0 as mpe_oan_version_no) AS OpActyNtwkVersionCounter,
  cast('' as mpe_oan_element_number_ext) AS OpActyNtwkElementExternalID,
  cast(0 as mpe_oa_id) AS OperationActivity,
  cast(0 as mpe_oa_version_no) AS OperationActyVersionCounter,
  cast('' as mpe_sasname_type) AS StatusAndActionSchema,
  cast('' as mpe_component_matnr) AS MaterialComponent,
  cast('' as maktx) AS MaterialComponentName,
  cast(0 as mpe_assembled_sfi_id) AS AssembledShopFloorItem,
  cast('' as mpe_assembled_sernr) AS AssembledSerialNumber,
  cast('' as mpe_assembled_mfr_sernr) AS AssembledMfrSerialNumber,
  cast('' as mpe_assembled_batch) AS AssembledBatch,
  cast('' as vmp_ref_des) AS ReferenceDesignatorValue,
  cast(0 as mpe_replaced_sfi_id) AS ReplacedShopFloorItem,
  cast('' as mpe_replaced_sernr) AS ReplacedSerialNumber,
  cast('' as mpe_replaced_batch) AS ReplacedBatch,
  cast('' as mpe_exchanged_material) AS SubstitutedProduct,
  cast('' as maktx) AS SubstitutedProductName,
  cast(' ' as pph_alpgr preserving type ) AS AlternativeItemGroup,
  cast(' ' as lgort_d preserving type) AS StorageLocation,
  cast('' as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  cast('' as mpe_disassembly_permanence preserving type ) AS CompDisassemblyPermanence,
  cast('' as mpe_is_reassembly preserving type ) AS MaterialComponentHasReltdComp,
  cast(0 as mpe_buyoff_step) AS MfgBuyOffInternalID,
  cast('' as mpe_buyoffsqnc_desc) AS MfgBuyOffDescription,
  cast(0 as mpe_buyoff_step) AS MfgBuyOffReferencedStep,
  cast('' as mpe_buyoffsqnc_desc) AS MfgBuyOffAdhocStepDescription,
  cast('000000000000000' as mpe_buyoff_cycle_id preserving type) AS MfgBuyOffCycle,
  cast('00000000' as hrobjid preserving type) AS RespyMgmtTeamID,
  cast('' as rsm_de_function) AS RespyMgmtFunction,
  cast(0 as co_iprzs) AS BusinessProcessConfirmedQty,
  cast('' as mpe_log_unit) AS ProductionUnit,
  cast('' as mpe_is_posted_retroactively preserving type) AS PostingIsRetroactive,
  cast('' as equnr) AS Equipment,
  cast('MPE_EXEC_COMMON ' as msgid preserving type) AS SystemMessageIdentification,
  20 AS MfgExecHistMsgVarblField1,
  18 AS MfgExecHistMsgVarblField2,
  0 AS MfgExecHistMsgVarblField4,
  cast('' as qdefectid) AS Defect,
  cast(sfirwrk.OrderOperationInternalID as mpe_doc_item) AS MfgExecutionDocumentItem,
  cast('SAP_SFI_SELECTED_FOR_REWORK_OPER' as mpe_action_name_type) AS MfgProcgExecAction,
  cast(sfirwrk.CreationDateTime as mpe_perform_timestamp) AS EventDateTime,
  cast(0 as mpe_sfi_at_oai_group_id) AS OperationActivitySFIGroup,
  cast(0 as mpe_oan_instance_id) AS OpActyNtwkInstance,
  cast(0 as mpe_oan_element_number) AS OpActyNtwkElement,
  cast('' as qdefectinternalid) AS DefectInternalID,
  cast('' as qmnum) AS Notification,
  cast('0000' as felfd preserving type) AS NotificationItem,
  cast(0 as mpe_actl_exec_duration) AS OpActyActualDurnInSeconds,
  cast('' as qkatart) AS MfgActionReasonCodeGroupCtlg,
  cast('' as qcodegrp) AS MfgActionReasonCodeGroup,
  cast('' as mpe_action_reason_code) AS ManufacturingActionReasonCode,
  '' AS MfgExecutionDocumentNote,
  cast('027' as msgnr) AS SystemMessageNumber,
  0 AS MfgExecHistMsgVarblField3,
  cast('' as mpe_file_name) AS MfgProcgExecAttachmentName,
  hold.OrderInternalID AS OrderInternalID,
  hold.OrderOperationInternalID AS OrderOperationInternalID,
  hold.ShopFloorItem AS ShopFloorItem,
  LogisticsOrderBasic.OrderID AS ManufacturingOrder,
  oper.WorkCenterTypeCode AS WorkCenterTypeCode,
  act.ProductionHold AS ManufacturingExecutionDocument,
  h.MfgExecDocumentCategory AS MfgExecDocumentCategory
FROM I_OrderOperationBasic AS oper
INNER JOIN I_OpActyInstceOpActyNtwkElmnt AS oai ON /* join condition not captured in parsed metadata */
INNER JOIN P_MfgExecEventHistOpActy2 AS h ON /* join condition not captured in parsed metadata */
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationBasic AS oper ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProductionHoldAction AS act ON /* join condition not captured in parsed metadata */
INNER JOIN with ON /* join condition not captured in parsed metadata */
;