P_MfgOrderOperHoldUnionBasic

DDL: P_MFGORDEROPERHOLDUNIONBASIC SQL: PMPEMFGOPRHLDUNB Type: view CONSUMPTION Package: MPE_EXEC_COMMON

Holds of a Mfg Order that apply on header or operation

P_MfgOrderOperHoldUnionBasic is a Consumption CDS View that provides data about "Holds of a Mfg Order that apply on header or operation" in SAP S/4HANA. It reads from 3 data sources (P_MfgOrderHeaderHold, P_MfgOrderOperationHold, I_OrderOperationBasic) and exposes 17 fields with key field ProductionHold. Part of development package MPE_EXEC_COMMON.

3 data source(s) 17 fields

Data Sources (3)

SourceAliasJoin Type
P_MfgOrderHeaderHold MfgOrderHeaderHold from
P_MfgOrderOperationHold MfgOrderOperationHold union_all
I_OrderOperationBasic OrderOperationBasic inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEMFGOPRHLDUNB view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold P_MfgOrderHeaderHold ProductionHold
ManufacturingOrder P_MfgOrderHeaderHold ManufacturingOrder
OrderInternalID I_OrderOperationBasic OrderInternalID
OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID
ProductionHoldObjectType P_MfgOrderHeaderHold ProductionHoldObjectType
ProductionPlant P_MfgOrderHeaderHold ProductionPlant
Material P_MfgOrderHeaderHold Material
WorkCenterInternalID P_MfgOrderHeaderHold WorkCenterInternalID
ProductionHold
ManufacturingOrder P_MfgOrderOperationHold ManufacturingOrder
OrderInternalID P_MfgOrderOperationHold OrderInternalID
OrderOperationInternalID P_MfgOrderOperationHold OrderOperationInternalID
ProductionHoldObjectType P_MfgOrderOperationHold ProductionHoldObjectType
ProductionPlant P_MfgOrderOperationHold ProductionPlant
Material P_MfgOrderOperationHold Material
WorkCenterInternalID P_MfgOrderOperationHold WorkCenterInternalID
WorkCenterTypeCode P_MfgOrderOperationHold WorkCenterTypeCode 
@AbapCatalog.sqlViewName: 'PMPEMFGOPRHLDUNB'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
define view P_MfgOrderOperHoldUnionBasic
  -- Material and Order Holds
  as select from P_MfgOrderHeaderHold  as MfgOrderHeaderHold
    inner join   I_OrderOperationBasic as OrderOperationBasic on OrderOperationBasic.OrderInternalID = MfgOrderHeaderHold.OrderInternalBillOfOperations
{
  key MfgOrderHeaderHold.ProductionHold,
      MfgOrderHeaderHold.ManufacturingOrder,
      OrderOperationBasic.OrderInternalID,
      OrderOperationBasic.OrderOperationInternalID,
      MfgOrderHeaderHold.ProductionHoldObjectType,
      MfgOrderHeaderHold.ProductionPlant,
      MfgOrderHeaderHold.Material,
      MfgOrderHeaderHold.WorkCenterInternalID,
      MfgOrderHeaderHold.WorkCenterTypeCode
}
-- Operation and Work Center Holds
union all select from P_MfgOrderOperationHold as MfgOrderOperationHold
{
  key MfgOrderOperationHold.ProductionHold,
      MfgOrderOperationHold.ManufacturingOrder,
      MfgOrderOperationHold.OrderInternalID,
      MfgOrderOperationHold.OrderOperationInternalID,
      MfgOrderOperationHold.ProductionHoldObjectType,
      MfgOrderOperationHold.ProductionPlant,
      MfgOrderOperationHold.Material,
      MfgOrderOperationHold.WorkCenterInternalID,
      MfgOrderOperationHold.WorkCenterTypeCode
}

Learn More