P_MFGORDERAORLIST

CDS View

Orders matching the assigned _AORs

P_MFGORDERAORLIST is a CDS View in S/4HANA. Orders matching the assigned _AORs. 13 CDS views read from this table.

Used by 13 CDS view(s)

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_ManageOrdersTP view inner TRANSACTIONAL Production Orders Transactional BOPF
P_Mfgordcompmissaggr view_entity inner CONSUMPTION Group the ComponentsIsMissing flags for all comps for Order
P_MfgOrderHoldCount view_entity inner COMPOSITE
P_MfgOrderLongText view_entity inner COMPOSITE
P_MfgOrderOperActyHoldCount view_entity inner COMPOSITE
P_MfgOrderOperHoldCount view_entity inner COMPOSITE
P_MfgOrderSFIHoldCount view_entity inner COMPOSITE
P_MfgOrderWrkCtrHoldCount view_entity inner CONSUMPTION
P_MfgOrdNrOfDefectSitns view inner COMPOSITE
P_MPEInspIssuesByProdnOrder view_entity inner CONSUMPTION Inspection Issues by Production Order
P_Orderqtyissue view_entity inner CONSUMPTION Order Quantity Issue Calculation
P_OrdFirstOper view_entity inner CONSUMPTION
P_Ordlatestoper view_entity inner CONSUMPTION 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Orders 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_MfgOrderAORList as
   select from I_PPAreaOfResponsibility as _AOR  // I_MfgOrderOperationCompCube

   inner join I_LogisticsOrder as _OrderBasic on _OrderBasic.Plant = _AOR.Plant
                                             and _OrderBasic.ProductionSupervisor = ''
                                             and _OrderBasic.OrderCategory = '10'
   {
        key _OrderBasic.OrderID    // _OrderBasic.ObjectInternalID

   }
   where _AOR.ProductionSupervisor is initial and _AOR.WorkCenterInternalID is initial

union

   select from I_PPAreaOfResponsibility as _AOR
   inner join I_LogisticsOrder as _Orders on _Orders.Plant = _AOR.Plant
                                         and _Orders.ProductionSupervisor = _AOR.ProductionSupervisor
                                         and _Orders.OrderCategory = '10'

   {
       key _Orders.OrderID    //  _Orders.ObjectInternalID

   }
   where _AOR.ProductionSupervisor is not initial and _AOR.WorkCenterInternalID is initial

union

   select from I_PPAreaOfResponsibility as _AOR
   inner join I_OrderOperationBasic as _OrderOperBasic on _OrderOperBasic.WorkCenterInternalID = _AOR.WorkCenterInternalID
                                                      and _OrderOperBasic.BillOfOperationsType <> 'R' and _OrderOperBasic.BillOfOperationsType <> '3'
   inner join I_LogisticsOrder      as _OrdersBasic    on _OrdersBasic.OrderInternalBillOfOperations = _OrderOperBasic.OrderInternalID
                                                      and _OrdersBasic.Plant = _AOR.Plant
                                                      and _OrdersBasic.OrderCategory = '10'
  {
   key _OrdersBasic.OrderID  //  _OrdersBasic.ObjectInternalID

  }
  where _AOR.ProductionSupervisor is initial and _AOR.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