I_MfgOrderOperationBasic

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_MfgOrderOperationBasic.
-- 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: IPPMFGORDOPBASIC

CREATE VIEW I_MfgOrderOperationBasic AS
SELECT
  cast(afvc.OrderInternalID as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(afvc.OrderOperationInternalID as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  aufv.ManufacturingOrder AS ManufacturingOrder,
  afvc.Sequence AS ManufacturingOrderSequence,
  cast(afvc.Operation as co_vornr preserving type) AS ManufacturingOrderOperation,
  afvc.Operation_2 AS ManufacturingOrderOperation_2,
  aufv.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  aufv.ManufacturingOrderType AS ManufacturingOrderType,
  afvc.OperationText AS MfgOrderOperationText,
  afvc.Language AS Language,
  afvc.Plant AS ProductionPlant,
  afvc.WorkCenterInternalID AS WorkCenterInternalID,
  afvc.WorkCenterTypeCode_2 AS WorkCenterTypeCode_2,
  afvc.OperationControlProfile AS OperationControlProfile,
  afvc.FactoryCalendar AS FactoryCalendar,
  afvc.CapacityRequirement AS CapacityRequirement,
  cast(afvc.CapacityRequirementItem as pph_bedzl preserving type) AS CapacityRequirementItem,
  afvc.ChangeNumber AS ChangeNumber,
  afvc.OperationConfirmation AS OperationConfirmation,
  afvc.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  afvc.ObjectInternalID AS ObjectInternalID,
  afvc.MfgOrderOperationIsPhase AS MfgOrderOperationIsPhase,
  afvc.OperationImportance AS OperationImportance,
  afvc.OperationScrapPercent AS OperationScrapPercent,
  afvc.NumberOfOperationConfirmations AS NumberOfOperationConfirmations,
  afvc.ActualNumberOfSplits AS ActualNumberOfSplits,
  afvc.NumberOfCapacities AS NumberOfCapacities,
  afvc.BillOfOperationsSequence AS BillOfOperationsSequence,
  afvc.BillOfOperationsType AS BillOfOperationsType,
  afvc.BillOfOperationsGroup AS BillOfOperationsGroup,
  afvc.BillOfOperationsVariant AS BillOfOperationsVariant,
  afvc.BOOOperationInternalID AS BOOOperationInternalID,
  afvc.BillOfOperationsVersion AS BillOfOperationsVersion,
  afvc.SetupOpActyNtwkInstance AS SetupOpActyNtwkInstance,
  afvc.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  afvc.TeardownOpActyNtwkInstance AS TeardownOpActyNtwkInstance
FROM I_OrderOperationBasic AS afvc
INNER JOIN I_MfgOrderBasic AS aufv ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode_2 = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode_2 = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_OperationControlProfile AS _OperationControlProfile ON OperationControlProfile = _OperationControlProfile.OperationControlProfile  -- association [1..1]
LEFT OUTER JOIN I_CapacityRequirement AS _CapacityRequirement ON CapacityRequirement = _CapacityRequirement.CapacityRequirement  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirementItem AS _CapacityRequirementItem ON CapacityRequirement = _CapacityRequirementItem.CapacityRequirement AND CapacityRequirementItem = _CapacityRequirementItem.CapacityRequirementItem  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON OperationConfirmation = _ConfirmationGroup.ConfirmationGroup  -- association [1..1]
;