C_ProductionHold

DDL: C_PRODUCTIONHOLD SQL: CMPEPRODHOLD Type: view CONSUMPTION
43 Fields 2 Data Sources 4 Associations

C_ProductionHold is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProductionHold, I_ProductionHoldAction) and exposes 43 fields with key field ProductionHold. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ProductionHold ProductionHold from
I_ProductionHoldAction ProductionHoldAction inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_MfgOrder _MfgOrder $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
[1..1] I_OrdInternalBillOfOperations _OrderInternalID $projection.OrderInternalID = _OrderInternalID.OrderInternalBillOfOperations
[0..1] I_MfgOrderOperation _MfgOrderOperation $projection.OrderInternalID = _MfgOrderOperation.OrderInternalBillOfOperations and $projection.OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem
[0..1] I_OpActyInstceNtwkElmntBasic _OpActyInstceNtwkElmntBasic ProductionHold.OpActyNtwkInstance = _OpActyInstceNtwkElmntBasic.OpActyNtwkInstance and ProductionHold.OpActyNtwkElement = _OpActyInstceNtwkElmntBasic.OpActyNtwkElement

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMPEPRODHOLD view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
AbapCatalog.preserveKey true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold I_ProductionHold ProductionHold Hold ID
ProductionHoldObjectType I_ProductionHold ProductionHoldObjectType
ProductionPlant I_ProductionHold ProductionPlant Prod plnt
Material I_ProductionHold Material Vehicle Model
WorkCenterInternalID I_ProductionHold WorkCenterInternalID Work Center
WorkCenterTypeCode I_ProductionHold WorkCenterTypeCode Object Type
ManufacturingOrder I_ProductionHold ManufacturingOrder Order
OrderInternalID I_ProductionHold OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_ProductionHold OrderOperationInternalID
ShopFloorItem I_ProductionHold ShopFloorItem Serial.Mat. ID
OpActyNtwkInstance I_ProductionHold OpActyNtwkInstance Instance ID
OpActyNtwkElement I_ProductionHold OpActyNtwkElement Element Number
OperationActivitySFIGroup I_ProductionHold OperationActivitySFIGroup
OperationActivityName I_ProductionHold OperationActivityName
OpActyNtwkElementExternalID I_ProductionHold OpActyNtwkElementExternalID Op. Activity
ProductionHoldStartDateTime
ProductionHoldEndDateTime
MfgActionReasonCodeGroupCtlg I_ProductionHoldAction MfgActionReasonCodeGroupCtlg Catalog
MfgActionReasonCodeGroup I_ProductionHoldAction MfgActionReasonCodeGroup Code Group
ManufacturingActionReasonCode I_ProductionHoldAction ManufacturingActionReasonCode Water Hazard Cl.
MfgActionReasonCodeName
ProductionHoldApplyNote ProductionHoldNote MfgExecutionDocumentNote
DefectInternalID
Defect
DefectText
Notification I_ProductionHold Notification Notification
NotificationItem I_ProductionHold NotificationItem
ProdnHoldIsAppldForOrderChg I_ProductionHold ProdnHoldIsAppldForOrderChg
_ProductionHoldObjectType I_ProductionHold _ProductionHoldObjectType
_ProductionPlant I_ProductionHold _ProductionPlant
_Material I_ProductionHold _Material
_WorkCenter I_ProductionHold _WorkCenter
_MfgOrder _MfgOrder
_OrderInternalID _OrderInternalID
_MfgOrderOperation _MfgOrderOperation
_ShopFloorItem I_ProductionHold _ShopFloorItem
_OpActyNtwkInstance I_ProductionHold _OpActyNtwkInstance
_OperationActivityInstance I_ProductionHold _OperationActivityInstance
_OperationActivitySFIGroup I_ProductionHold _OperationActivitySFIGroup
_Defect I_ProductionHold _Defect
_Notification I_ProductionHold _Notification
_NotificationItem I_ProductionHold _NotificationItem
_OpActyInstceNtwkElmntBasic _OpActyInstceNtwkElmntBasic

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_ProductionHold.
-- 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: CMPEPRODHOLD

CREATE VIEW C_ProductionHold AS
SELECT
  ProductionHold.ProductionHold AS ProductionHold,
  ProductionHold.ProductionHoldObjectType AS ProductionHoldObjectType,
  ProductionHold.ProductionPlant AS ProductionPlant,
  ProductionHold.Material AS Material,
  ProductionHold.WorkCenterInternalID AS WorkCenterInternalID,
  ProductionHold.WorkCenterTypeCode AS WorkCenterTypeCode,
  ProductionHold.ManufacturingOrder AS ManufacturingOrder,
  ProductionHold.OrderInternalID AS OrderInternalID,
  ProductionHold.OrderOperationInternalID AS OrderOperationInternalID,
  ProductionHold.ShopFloorItem AS ShopFloorItem,
  ProductionHold.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProductionHold.OpActyNtwkElement AS OpActyNtwkElement,
  ProductionHold.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  ProductionHold.OperationActivityName AS OperationActivityName,
  ProductionHold.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  ProductionHoldAction.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  ProductionHoldAction.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  ProductionHoldAction.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  ProductionHoldAction._MfgActionReasonCode._Text[1: Language=$session.system_language].MfgActionReasonCodeName AS MfgActionReasonCodeName,
  ProductionHoldNote.MfgExecutionDocumentNote AS ProductionHoldApplyNote,
  ProductionHold._Defect.Defect AS Defect,
  ProductionHold._Defect.DefectText AS DefectText,
  ProductionHold.Notification AS Notification,
  ProductionHold.NotificationItem AS NotificationItem,
  ProductionHold.ProdnHoldIsAppldForOrderChg AS ProdnHoldIsAppldForOrderChg,
  ProductionHold._ProductionHoldObjectType AS _ProductionHoldObjectType,
  ProductionHold._ProductionPlant AS _ProductionPlant,
  ProductionHold._Material AS _Material,
  ProductionHold._WorkCenter AS _WorkCenter,
  ProductionHold._ShopFloorItem AS _ShopFloorItem,
  ProductionHold._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ProductionHold._OperationActivityInstance AS _OperationActivityInstance,
  ProductionHold._OperationActivitySFIGroup AS _OperationActivitySFIGroup,
  ProductionHold._Defect AS _Defect,
  ProductionHold._Notification AS _Notification,
  ProductionHold._NotificationItem AS _NotificationItem
FROM I_ProductionHold AS ProductionHold
INNER JOIN I_ProductionHoldAction AS ProductionHoldAction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN I_OpActyInstceNtwkElmntBasic AS _OpActyInstceNtwkElmntBasic ON ProductionHold.OpActyNtwkInstance = _OpActyInstceNtwkElmntBasic.OpActyNtwkInstance AND ProductionHold.OpActyNtwkElement = _OpActyInstceNtwkElmntBasic.OpActyNtwkElement  -- association [0..1]
;

Learn More