C_MfgOrdOpDetsForOpActyExec

DDL: C_MFGORDOPDETSFOROPACTYEXEC SQL: CMPEOPDETSOAEX Type: view CONSUMPTION
27 Fields 3 Data Sources

Manufacturing order operation details for OA execution

C_MfgOrdOpDetsForOpActyExec is a Consumption CDS View that provides data about "Manufacturing order operation details for OA execution" in SAP S/4HANA. It reads from 3 data sources (I_MfgOrder, I_OrderOperation, I_OrderSequence) and exposes 27 fields with key fields OrderInternalBillOfOperations, OrderIntBillOfOperationsItem.

Data Sources (3)

SourceAliasJoin Type
I_MfgOrder MfgOrder inner
I_OrderOperation OrderOperation from
I_OrderSequence OrderSequence inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOPDETSOAEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label Manufacturing order operation details for OA execution view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations I_OrderOperation OrderInternalID Plan No.f.Oper.
KEY OrderIntBillOfOperationsItem I_OrderOperation OrderOperationInternalID
ManufacturingOrder I_MfgOrder ManufacturingOrder Order
ManufacturingOrderOperation I_OrderOperation Operation Transaction
MfgOrderOperationText I_OrderOperation OperationText Description
ProduceOpActyNtwkInstance I_OrderOperation ProduceOpActyNtwkInstance
Material I_MfgOrder Material Vehicle Model
MaterialName
WorkCenterInternalID I_OrderOperation WorkCenterInternalID Work Center
WorkCenterTypeCode I_OrderOperation WorkCenterTypeCode_2
WorkCenter
WorkCenterText
OpPlannedTotalQuantity I_OrderOperation OpPlannedTotalQuantity
OpExecutionCompletedQuantity
OperationUnit I_OrderOperation OperationUnit Act/op UoM
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
ProductionPlant I_MfgOrder ProductionPlant Prod plnt
EffectivityParameterVariant I_MfgOrder EffectivityParameterVariant
EffectivityParameterDesc
EffctyTypeCnctntdParamDesc
_OrderInternalID I_OrderOperation _OrderInternalID
_WorkCenter I_OrderOperation _WorkCenter
_Plant I_MfgOrder _Plant
_Material I_MfgOrder _Material
_MfgOrderCategory I_MfgOrder _MfgOrderCategory
_MfgOrderType I_MfgOrder _MfgOrderType

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 C_MfgOrdOpDetsForOpActyExec.
-- 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: CMPEOPDETSOAEX

CREATE VIEW C_MfgOrdOpDetsForOpActyExec AS
SELECT
  OrderOperation.OrderInternalID AS OrderInternalBillOfOperations,
  OrderOperation.OrderOperationInternalID AS OrderIntBillOfOperationsItem,
  MfgOrder.ManufacturingOrder AS ManufacturingOrder,
  OrderOperation.Operation AS ManufacturingOrderOperation,
  OrderOperation.OperationText AS MfgOrderOperationText,
  OrderOperation.ProduceOpActyNtwkInstance AS ProduceOpActyNtwkInstance,
  MfgOrder.Material AS Material,
  MfgOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OrderOperation.WorkCenterInternalID AS WorkCenterInternalID,
  OrderOperation.WorkCenterTypeCode_2 AS WorkCenterTypeCode,
  OrderOperation._WorkCenter.WorkCenter AS WorkCenter,
  OrderOperation._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OrderOperation.OpPlannedTotalQuantity AS OpPlannedTotalQuantity,
  cast( 0 as lmnga) AS OpExecutionCompletedQuantity,
  OrderOperation.OperationUnit AS OperationUnit,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder.ProductionPlant AS ProductionPlant,
  MfgOrder.EffectivityParameterVariant AS EffectivityParameterVariant,
  cast('' as mpe_effectivity_parameter_desc) AS EffectivityParameterDesc,
  cast('' as mpe_effectivity_parameter_desc) AS EffctyTypeCnctntdParamDesc,
  OrderOperation._OrderInternalID AS _OrderInternalID,
  OrderOperation._WorkCenter AS _WorkCenter,
  MfgOrder._Plant AS _Plant,
  MfgOrder._Material AS _Material,
  MfgOrder._MfgOrderCategory AS _MfgOrderCategory,
  MfgOrder._MfgOrderType AS _MfgOrderType
FROM I_OrderOperation AS OrderOperation
INNER JOIN I_MfgOrder AS MfgOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderSequence AS OrderSequence ON /* join condition not captured in parsed metadata */
;

Learn More