I_ProductionHold

DDL: I_PRODUCTIONHOLD SQL: IMPEPRODNHLD Type: view COMPOSITE
34 Fields 1 Data Sources 9 Associations

Production Hold

I_ProductionHold is a Composite CDS View that provides data about "Production Hold" in SAP S/4HANA. It reads from 1 data source (P_ProductionHold) and exposes 34 fields with key field ProductionHold. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_ProductionHold ProductionHold from

Associations (9)

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
[1..1] I_ProductionHoldStatus _ProductionHoldStatus $projection.ProductionHoldStatus = _ProductionHoldStatus.ProductionHoldStatus
[0..1] I_Defect _Defect $projection.DefectInternalID = _Defect.DefectInternalID
[0..1] I_Notification _Notification $projection.Notification = _Notification.Notification
[0..1] I_NotificationItem _NotificationItem $projection.Notification = _NotificationItem.Notification and $projection.NotificationItem = _NotificationItem.NotificationItem
[0..1] I_NotificationItem _ReferenceNotificationItem ProductionHold.DefectInternalID = _ReferenceNotificationItem.ReferencedDefect and ProductionHold.DefectInternalID <> '' and _ReferenceNotificationItem.IsDeleted = ''
[0..1] I_NotificationItem _NotificationItemRefDefect ProductionHold.Notification = _NotificationItemRefDefect.Notification and ProductionHold.NotificationItem = _NotificationItemRefDefect.NotificationItem

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IMPEPRODNHLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey ProductionHold view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.writeActivePersistence IMPEPRODNHLD view
Search.searchable true view
VDM.viewType #COMPOSITE view
EndUserText.label Production Hold view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold P_ProductionHold ProductionHold
ProductionHoldObjectType P_ProductionHold ProductionHoldObjectType
ProductionPlant P_ProductionHold ProductionPlant Prod plnt
Material P_ProductionHold Material Vehicle Model
WorkCenterInternalID P_ProductionHold WorkCenterInternalID Work Center
WorkCenterTypeCode P_ProductionHold WorkCenterTypeCode Object Type
ManufacturingOrder P_ProductionHold ManufacturingOrder Order
OrderInternalID P_ProductionHold OrderInternalID Plan No.f.Oper.
OrderOperationInternalID P_ProductionHold OrderOperationInternalID
ShopFloorItem P_ProductionHold ShopFloorItem Serial.Mat. ID
OpActyNtwkInstance P_ProductionHold OpActyNtwkInstance Instance ID
OpActyNtwkElement P_ProductionHold OpActyNtwkElement Element Number
OperationActivitySFIGroup P_ProductionHold OperationActivitySFIGroup
OperationActivityName P_ProductionHold OperationActivityName
OpActyNtwkElementExternalID P_ProductionHold OpActyNtwkElementExternalID Op. Activity
ProductionHoldStartDateTime P_ProductionHold ProductionHoldStartDateTime
ProductionHoldEndDateTime P_ProductionHold ProductionHoldEndDateTime
ProdnHoldIsAppldForOrderChg P_ProductionHold ProdnHoldIsAppldForOrderChg
ProductionHoldStatus P_ProductionHold ProductionHoldStatus
_ProductionHoldObjectType P_ProductionHold _ProductionHoldObjectType
_ProductionPlant P_ProductionHold _ProductionPlant
_Material P_ProductionHold _Material
_WorkCenter P_ProductionHold _WorkCenter
_MfgOrder _MfgOrder
_OrderInternalID _OrderInternalID
_MfgOrderOperation _MfgOrderOperation
_ShopFloorItem P_ProductionHold _ShopFloorItem
_ProductionHoldStatus _ProductionHoldStatus
_OpActyNtwkInstance P_ProductionHold _OpActyNtwkInstance
_OperationActivityInstance P_ProductionHold _OperationActivityInstance
_OperationActivitySFIGroup P_ProductionHold _OperationActivitySFIGroup
_Defect _Defect
_Notification _Notification
_NotificationItem _NotificationItem

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_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: IMPEPRODNHLD

CREATE VIEW I_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,
  ProductionHold.ProductionHoldStartDateTime AS ProductionHoldStartDateTime,
  ProductionHold.ProductionHoldEndDateTime AS ProductionHoldEndDateTime,
  ProductionHold.ProdnHoldIsAppldForOrderChg AS ProdnHoldIsAppldForOrderChg,
  ProductionHold.ProductionHoldStatus AS ProductionHoldStatus,
  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
FROM P_ProductionHold AS ProductionHold
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_ProductionHoldStatus AS _ProductionHoldStatus ON ProductionHoldStatus = _ProductionHoldStatus.ProductionHoldStatus  -- association [1..1]
LEFT OUTER JOIN I_Defect AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [0..1]
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON Notification = _NotificationItem.Notification AND NotificationItem = _NotificationItem.NotificationItem  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _ReferenceNotificationItem ON ProductionHold.DefectInternalID = _ReferenceNotificationItem.ReferencedDefect AND ProductionHold.DefectInternalID <> '' AND _ReferenceNotificationItem.IsDeleted = ''  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItemRefDefect ON ProductionHold.Notification = _NotificationItemRefDefect.Notification AND ProductionHold.NotificationItem = _NotificationItemRefDefect.NotificationItem  -- association [0..1]
;

Learn More