C_MfgOrderOperationHold

DDL: C_MFGORDEROPERATIONHOLD SQL: CMPEOPHOLD Type: view CONSUMPTION
17 Fields 2 Data Sources 3 Associations

C_MfgOrderOperationHold is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrder, P_MfgOrderOperHoldUnionBasic) and exposes 17 fields with key fields ProductionHold, OrderInternalID, OrderOperationInternalID. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_MfgOrder MfgOrder inner
P_MfgOrderOperHoldUnionBasic MfgOrderOperHoldUnionBasic from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
[1..1] I_ProductionHoldBasic _ProductionHoldBasic $projection.ProductionHold = _ProductionHoldBasic.ProductionHold
[1..1] I_ProductionHoldObjectType _ProductionHoldObjectType $projection.ProductionHoldObjectType = _ProductionHoldObjectType.ProductionHoldObjectType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOPHOLD view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold P_MfgOrderOperHoldUnionBasic ProductionHold
KEY OrderInternalID P_MfgOrderOperHoldUnionBasic OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID P_MfgOrderOperHoldUnionBasic OrderOperationInternalID
ManufacturingOrder I_MfgOrder ManufacturingOrder Order
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
OrderInternalBillOfOperations I_MfgOrder OrderInternalBillOfOperations Order Internal Bill of Operations
Material P_MfgOrderOperHoldUnionBasic Material Vehicle Model
ProductionPlant P_MfgOrderOperHoldUnionBasic ProductionPlant Prod plnt
ProductionHoldObjectType P_MfgOrderOperHoldUnionBasic ProductionHoldObjectType
WorkCenter WorkCenter WorkCenter Work Center
_OrdInternalBillOfOperations I_MfgOrder _OrdInternalBillOfOperations
_MfgOrder _MfgOrder
_MfgOrderCategory I_MfgOrder _MfgOrderCategory
_MfgOrderType I_MfgOrder _MfgOrderType
_ProductionHoldBasic _ProductionHoldBasic
_ProductionHoldObjectType _ProductionHoldObjectType

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_MfgOrderOperationHold.
-- 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: CMPEOPHOLD

CREATE VIEW C_MfgOrderOperationHold AS
SELECT
  MfgOrderOperHoldUnionBasic.ProductionHold AS ProductionHold,
  MfgOrderOperHoldUnionBasic.OrderInternalID AS OrderInternalID,
  MfgOrderOperHoldUnionBasic.OrderOperationInternalID AS OrderOperationInternalID,
  MfgOrder.ManufacturingOrder AS ManufacturingOrder,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  MfgOrder.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  MfgOrderOperHoldUnionBasic.Material AS Material,
  MfgOrderOperHoldUnionBasic.ProductionPlant AS ProductionPlant,
  MfgOrderOperHoldUnionBasic.ProductionHoldObjectType AS ProductionHoldObjectType,
  WorkCenter.WorkCenter AS WorkCenter,
  MfgOrder._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  MfgOrder._MfgOrderCategory AS _MfgOrderCategory,
  MfgOrder._MfgOrderType AS _MfgOrderType
FROM P_MfgOrderOperHoldUnionBasic AS MfgOrderOperHoldUnionBasic
INNER JOIN I_MfgOrder AS MfgOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldBasic AS _ProductionHoldBasic ON ProductionHold = _ProductionHoldBasic.ProductionHold  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldObjectType AS _ProductionHoldObjectType ON ProductionHoldObjectType = _ProductionHoldObjectType.ProductionHoldObjectType  -- association [1..1]
;

Learn More