P_MfgOrderHeaderHold

DDL: P_MFGORDERHEADERHOLD SQL: PMPEMFGORDHDRHLD Type: view CONSUMPTION

P_MfgOrderHeaderHold is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MfgOrder, I_ProductionHoldBasic) and exposes 11 fields with key field ProductionHold.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_MfgOrder MfgOrder from
I_ProductionHoldBasic ProductionHold inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEMFGORDHDRHLD 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 (11)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold I_ProductionHoldBasic ProductionHold
ProductionHoldStatus I_ProductionHoldBasic ProductionHoldStatus
ManufacturingOrder I_MfgOrder ManufacturingOrder
ProductionHoldObjectType I_ProductionHoldBasic ProductionHoldObjectType
OrderInternalBillOfOperations I_MfgOrder OrderInternalBillOfOperations
ManufacturingOrderType I_MfgOrder ManufacturingOrderType
ManufacturingOrderCategory I_MfgOrder ManufacturingOrderCategory
ProductionPlant I_ProductionHoldBasic ProductionPlant
Material I_ProductionHoldBasic Material
WorkCenterInternalID I_ProductionHoldBasic WorkCenterInternalID
WorkCenterTypeCode I_ProductionHoldBasic WorkCenterTypeCode 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDER",
"I_PRODUCTIONHOLDBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More