P_MFGOPERATIONSLIST

CDS View

Operations matching the assigned AORs

P_MFGOPERATIONSLIST is a CDS View in S/4HANA. Operations matching the assigned AORs. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_ManageOperationsTP view inner TRANSACTIONAL Production Operations Transactional BOPF
P_LatestOperation view_entity inner CONSUMPTION
P_Mfgcompsmissaggr view_entity inner CONSUMPTION Group the ComponentIsMissing flags for all components 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Operations matching the assigned AORs'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType:  #COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true
define view entity P_MfgOperationsList as
  select from I_PPAreaOfResponsibility as AOR
  inner join I_OrderOperationBasic as _OrderOperBasic1  on _OrderOperBasic1.Plant = AOR.Plant
                                                        and _OrderOperBasic1.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic1.BillOfOperationsType <> '3'
  inner join I_LogisticsOrder      as _OrderBasic       on _OrderBasic.OrderInternalBillOfOperations = _OrderOperBasic1.OrderInternalID
                                                        and _OrderBasic.ProductionSupervisor = ''
                                                        and _OrderBasic.OrderCategory = '10'
{
     key _OrderOperBasic1.OrderInternalID,
     key _OrderOperBasic1.OrderOperationInternalID
}
where AOR.ProductionSupervisor is initial and AOR.WorkCenterInternalID is initial

union

select from I_PPAreaOfResponsibility as AOR1
inner join I_OrderOperationBasic as _OrderOperBasic2    on _OrderOperBasic2.Plant = AOR1.Plant
                                                        and _OrderOperBasic2.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic2.BillOfOperationsType <> '3'
inner join I_LogisticsOrder      as _Orders             on ( _Orders.ProductionSupervisor        = AOR1.ProductionSupervisor ) // or AOR1.ProductionSupervisor = '*' )

                                                        and _Orders.OrderInternalBillOfOperations = _OrderOperBasic2.OrderInternalID
                                                        and _Orders.OrderCategory = '10'
{
    key _OrderOperBasic2.OrderInternalID,
    key _OrderOperBasic2.OrderOperationInternalID
}
where  AOR1.ProductionSupervisor is not initial and AOR1.WorkCenterInternalID is initial

union

select from I_PPAreaOfResponsibility as AOR2
inner join I_OrderOperationBasic    as _OrderOperBasic  on _OrderOperBasic.Plant                = AOR2.Plant
                                                        and _OrderOperBasic.WorkCenterInternalID = AOR2.WorkCenterInternalID
                                                        and _OrderOperBasic.BillOfOperationsType <> 'R'
                                                        and _OrderOperBasic.BillOfOperationsType <> '3'
inner join I_LogisticsOrder         as _OrdersBasic     on _OrdersBasic.OrderInternalBillOfOperations = _OrderOperBasic.OrderInternalID
                                                        and _OrdersBasic.OrderCategory = '10'
{
    key _OrderOperBasic.OrderInternalID,
    key _OrderOperBasic.OrderOperationInternalID
}
where AOR2.ProductionSupervisor is initial and AOR2.WorkCenterInternalID is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_ORDEROPERATIONBASIC",
"I_PPAREAOFRESPONSIBILITY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More