P_MFGORDEROPERATIONHOLD

CDS View

P_MFGORDEROPERATIONHOLD is a CDS View in S/4HANA. 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 inner CONSUMPTION
P_MfgOrderOperHoldUnionBasic view union_all CONSUMPTION

Fields (8)

KeyField CDS FieldsUsed in Views
ManufacturingOrder ManufacturingOrder 1
Material Material 2
OrderInternalID OrderInternalID 1
OrderOperationInternalID OrderOperationInternalID 1
ProductionHoldObjectType ProductionHoldObjectType 1
ProductionPlant ProductionPlant 2
WorkCenterInternalID WorkCenterInternalID 1
WorkCenterTypeCode WorkCenterTypeCode 1 
@AbapCatalog.sqlViewName: 'PMPEOPHOLD'
@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_MfgOrderOperationHold
  as select from I_OrderOperationBasic as OrderOperationBasic
    inner join   I_OrderInternalID     as OrderInternalID on OrderInternalID.OrderInternalID = OrderOperationBasic.OrderInternalID
    inner join   I_ProductionHoldBasic as ProductionHold  on(
       -- Operation Hold
       ProductionHold.OrderInternalID                                                                   = OrderOperationBasic.OrderInternalID
       and ProductionHold.OrderOperationInternalID                                                      = OrderOperationBasic.OrderOperationInternalID
       and ProductionHold.ProductionHoldObjectType                                                      = '4'
     )
    -- Work center Hold
                                                          or(
                                                            OrderOperationBasic.WorkCenterInternalID    = ProductionHold.WorkCenterInternalID
                                                            and ProductionHold.ProductionHoldObjectType = '2'
                                                          )
{
  key ProductionHold.ProductionHold,
      OrderInternalID.OrderID as ManufacturingOrder,
      OrderOperationBasic.OrderInternalID,
      OrderOperationBasic.OrderOperationInternalID,
      ProductionHold.ProductionHoldObjectType,
      ProductionHold.ProductionPlant,
      ProductionHold.Material,
      ProductionHold.WorkCenterInternalID,
      ProductionHold.WorkCenterTypeCode
}
where
  ProductionHold.ProductionHoldEndDateTime = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERINTERNALID",
"I_ORDEROPERATIONBASIC",
"I_PRODUCTIONHOLDBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More