P_MfgOrderHeaderHoldUnionBasic

DDL: P_MFGORDERHEADERHOLDUNIONBASIC SQL: PMPEMFGORDHLDUNB Type: view CONSUMPTION

P_MfgOrderHeaderHoldUnionBasic is a Consumption CDS View in SAP S/4HANA. It reads from 8 data sources and exposes 25 fields with key fields ProductionHold, ManufacturingOrder, ManufacturingOrder, ManufacturingOrder, ManufacturingOrder.

8 data source(s) 25 fields

Data Sources (8)

SourceAliasJoin Type
I_MfgOrderBasic MfgOrderBasic union_all
I_MfgOrderBasic MfgOrderBasic union_all
I_MfgOrderBasic MfgOrderBasic union_all
P_MfgOrderHeaderHold MfgOrderHeaderHold from
P_MfgOrderOperationHold MfgOrderOperationHold inner
P_MfgOrderSFIHold MfgOrderSFIHold inner
I_ProductionHoldBasic OAHold inner
I_OpActyNtwkInstanceBasic OpActyNtwkInstanceBasic inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEMFGORDHLDUNB 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 (25)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold P_MfgOrderHeaderHold ProductionHold
KEY ManufacturingOrder P_MfgOrderHeaderHold ManufacturingOrder
ManufacturingOrderType P_MfgOrderHeaderHold ManufacturingOrderType
ManufacturingOrderCategory P_MfgOrderHeaderHold ManufacturingOrderCategory
Material P_MfgOrderHeaderHold Material
ProductionPlant P_MfgOrderHeaderHold ProductionPlant
ProductionHold
KEY ManufacturingOrder I_MfgOrderBasic ManufacturingOrder
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
Material P_MfgOrderOperationHold Material
ProductionPlant P_MfgOrderOperationHold ProductionPlant
ProductionHold
KEY ManufacturingOrder P_MfgOrderSFIHold ManufacturingOrder
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
Material P_MfgOrderSFIHold Material
ProductionPlant P_MfgOrderSFIHold ProductionPlant
ProductionHold
KEY ManufacturingOrder I_MfgOrderBasic ManufacturingOrder
ManufacturingOrderType I_MfgOrderBasic ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrderBasic ManufacturingOrderCategory
Material I_ProductionHoldBasic Material
ProductionPlant I_ProductionHoldBasic ProductionPlant
ProductionHoldObjectType I_ProductionHoldBasic ProductionHoldObjectType 
@AbapCatalog.sqlViewName: 'PMPEMFGORDHLDUNB'
@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_MfgOrderHeaderHoldUnionBasic
  -- Material and Order Holds
  as select from P_MfgOrderHeaderHold as MfgOrderHeaderHold
{
  key MfgOrderHeaderHold.ProductionHold,
  key MfgOrderHeaderHold.ManufacturingOrder,
      MfgOrderHeaderHold.ManufacturingOrderType,
      MfgOrderHeaderHold.ManufacturingOrderCategory,
      MfgOrderHeaderHold.Material,
      MfgOrderHeaderHold.ProductionPlant,
      MfgOrderHeaderHold.ProductionHoldObjectType
}
-- Opration and Work Center Holds
union all select from I_MfgOrderBasic         as MfgOrderBasic
  inner join          P_MfgOrderOperationHold as MfgOrderOperationHold on MfgOrderOperationHold.OrderInternalID = MfgOrderBasic.OrderInternalID
{
  key MfgOrderOperationHold.ProductionHold,
  key MfgOrderBasic.ManufacturingOrder,
      MfgOrderBasic.ManufacturingOrderType,
      MfgOrderBasic.ManufacturingOrderCategory,
      MfgOrderOperationHold.Material,
      MfgOrderOperationHold.ProductionPlant,
      MfgOrderOperationHold.ProductionHoldObjectType
}
where
  MfgOrderBasic.ManufacturingOrderCategory = '10'
-- SFI Holds
union all select from I_MfgOrderBasic   as MfgOrderBasic
  inner join          P_MfgOrderSFIHold as MfgOrderSFIHold on MfgOrderSFIHold.ManufacturingOrder = MfgOrderBasic.ManufacturingOrder
{
  key MfgOrderSFIHold.ProductionHold,
  key MfgOrderSFIHold.ManufacturingOrder,
      MfgOrderBasic.ManufacturingOrderType,
      MfgOrderBasic.ManufacturingOrderCategory,
      MfgOrderSFIHold.Material,
      MfgOrderSFIHold.ProductionPlant,
      MfgOrderSFIHold.ProductionHoldObjectType
}
union all select from I_MfgOrderBasic           as MfgOrderBasic
  inner join          I_OpActyNtwkInstanceBasic as OpActyNtwkInstanceBasic on OpActyNtwkInstanceBasic.OrderInternalID = MfgOrderBasic.OrderInternalID
  inner join          I_ProductionHoldBasic     as OAHold                  on  OAHold.ProductionHoldObjectType  = '6'
                                                                           and OAHold.OpActyNtwkInstance        = OpActyNtwkInstanceBasic.OpActyNtwkInstance
                                                                           and OAHold.ProductionHoldEndDateTime = 0
{
  key OAHold.ProductionHold,
  key MfgOrderBasic.ManufacturingOrder,
      MfgOrderBasic.ManufacturingOrderType,
      MfgOrderBasic.ManufacturingOrderCategory,
      OAHold.Material,
      OAHold.ProductionPlant,
      OAHold.ProductionHoldObjectType
}
where
  MfgOrderBasic.ManufacturingOrderCategory = '10'

Learn More