P_MFGORDERHEADERHOLD

CDS View

Material and order holds of a Manufacturing Order

P_MFGORDERHEADERHOLD is a CDS View in S/4HANA. Material and order holds of a Manufacturing Order. It contains 8 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 8 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MfgOrderHeaderHoldUnionBasic view from CONSUMPTION All holds of a Manufacturing Order (that apply to any node)
P_MfgOrderOperHoldUnionBasic view from CONSUMPTION Holds of a Mfg Order that apply on header or operation

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 2
KEY ProductionHold ProductionHold 2
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 2
ProductionHoldObjectType ProductionHoldObjectType 1
ProductionPlant ProductionPlant 2
WorkCenterInternalID WorkCenterInternalID 1 
@AbapCatalog.sqlViewName: 'PMPEMFGORDHDRHLD'
@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_MfgOrderHeaderHold
  as select from I_MfgOrder            as MfgOrder
    inner join   I_ProductionHoldBasic as ProductionHold on(
      -- Material Hold
      ProductionHold.Material                                                                          = MfgOrder.Material
      and ProductionHold.ProductionPlant                                                               = MfgOrder.ProductionPlant
      and ProductionHold.ProductionHoldObjectType                                                      = '1'
    )
    -- Order Hold
                                                         or(
                                                           ProductionHold.ManufacturingOrder           = MfgOrder.ManufacturingOrder
                                                           and ProductionHold.ProductionHoldObjectType = '3'
                                                         )
{
  key ProductionHold.ProductionHold,
      ProductionHold.ProductionHoldStatus,
      MfgOrder.ManufacturingOrder,
      ProductionHold.ProductionHoldObjectType,
      MfgOrder.OrderInternalBillOfOperations,
      MfgOrder.ManufacturingOrderType,
      MfgOrder.ManufacturingOrderCategory,
      ProductionHold.ProductionPlant,
      ProductionHold.Material,
      ProductionHold.WorkCenterInternalID,
      ProductionHold.WorkCenterTypeCode
}
where
      MfgOrder.ManufacturingOrderCategory      = '10'
  and ProductionHold.ProductionHoldEndDateTime = 0

Learn More