P_OperationAffectedByProdnHold

DDL: P_OPERATIONAFFECTEDBYPRODNHOLD Type: view_entity COMPOSITE

P_OperationAffectedByProdnHold is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_OrderInternalID, I_OrderItem, I_OrderOperationBasic, I_ProductionHoldBasic) and exposes 11 fields with key fields ProductionHold, OrderInternalID, OrderOperationInternalID.

4 data source(s) 11 fields

Data Sources (4)

SourceAliasJoin Type
I_OrderInternalID OrderInternalID inner
I_OrderItem OrderItem inner
I_OrderOperationBasic OrderOperationBasic from
I_ProductionHoldBasic ProductionHold inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProductionHold I_ProductionHoldBasic ProductionHold
KEY OrderInternalID I_OrderOperationBasic OrderInternalID
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID
ProductionHoldObjectType I_ProductionHoldBasic ProductionHoldObjectType
ManufacturingOrder I_OrderInternalID OrderID
Material I_ProductionHoldBasic Material
WorkCenterInternalID I_ProductionHoldBasic WorkCenterInternalID
ProductionPlant I_ProductionHoldBasic ProductionPlant
WorkCenter
OpActyNtwkInstance I_ProductionHoldBasic OpActyNtwkInstance
OpActyNtwkElement I_ProductionHoldBasic OpActyNtwkElement 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_OperationAffectedByProdnHold
  as select from I_OrderOperationBasic as OrderOperationBasic
    inner join   I_OrderInternalID     as OrderInternalID on OrderInternalID.OrderInternalID = OrderOperationBasic.OrderInternalID
    inner join   I_OrderItem           as OrderItem       on  OrderItem.OrderID   = OrderInternalID.OrderID
                                                          and OrderItem.OrderItem = '0001'
    inner join   I_ProductionHoldBasic as ProductionHold  on ProductionHold.ProductionHoldEndDateTime     = 0
                                                          and(
                                                            -- WorkCenter hold
                                                            (
                                                              ProductionHold.ProductionHoldObjectType     = '2'
                                                              and ProductionHold.WorkCenterInternalID     = OrderOperationBasic.WorkCenterInternalID
                                                            )
                                                            or(
                                                              -- MaterialHold
                                                              ProductionHold.ProductionHoldObjectType     = '1'
                                                              and ProductionHold.Material                 = OrderItem.Material
                                                              and ProductionHold.ProductionPlant          = OrderItem.MRPPlant
                                                            )
                                                            or(
                                                              -- OrderHold
                                                              ProductionHold.ProductionHoldObjectType     = '3'
                                                              and ProductionHold.ManufacturingOrder       = OrderInternalID.OrderID
                                                            )
                                                            or(
                                                              -- OperationHold
                                                              ProductionHold.ProductionHoldObjectType     = '4'
                                                              and ProductionHold.OrderInternalID          = OrderOperationBasic.OrderInternalID
                                                              and ProductionHold.OrderOperationInternalID = OrderOperationBasic.OrderOperationInternalID
                                                            )
                                                            or(
                                                              -- Operation Activity Hold
                                                              ProductionHold.ProductionHoldObjectType     = '6'
                                                              and ProductionHold.OrderInternalID          = OrderOperationBasic.OrderInternalID
                                                              and ProductionHold.OrderOperationInternalID = OrderOperationBasic.OrderOperationInternalID
                                                            )
                                                          )
{
  key ProductionHold.ProductionHold                as ProductionHold,
  key OrderOperationBasic.OrderInternalID          as OrderInternalID,
  key OrderOperationBasic.OrderOperationInternalID as OrderOperationInternalID,
      ProductionHold.ProductionHoldObjectType      as ProductionHoldObjectType,
      OrderInternalID.OrderID                      as ManufacturingOrder,
      ProductionHold.Material                      as Material,
      ProductionHold.WorkCenterInternalID          as WorkCenterInternalID,
      ProductionHold.ProductionPlant               as ProductionPlant,
      ProductionHold._WorkCenter.WorkCenter        as WorkCenter,
      ProductionHold.OpActyNtwkInstance            as OpActyNtwkInstance,
      ProductionHold.OpActyNtwkElement             as OpActyNtwkElement

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERINTERNALID",
"I_ORDERITEM",
"I_ORDEROPERATIONBASIC",
"I_PRODUCTIONHOLDBASIC",
"I_WORKCENTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More