P_MFGORDERAORLIST

CDS View

Orders matching the assigned _AORs

P_MFGORDERAORLIST is a CDS View in S/4HANA. Orders matching the assigned _AORs. It contains 1 fields. 15 CDS views read from this table.

Used by 15 CDS view(s) 1 fields

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_ManageOrdersTP view inner TRANSACTIONAL Production Orders Transactional BOPF
P_InspLotByAOR view_entity inner COMPOSITE Inspection Issues By Order
P_Mfgordcompmissaggr view_entity inner CONSUMPTION Group the ComponentsIsMissing flags for all comps for Order
P_MfgOrderHoldCount view_entity inner COMPOSITE Number of active Order Holds of a Production Order
P_MfgOrderLongText view_entity inner COMPOSITE Order Long Text
P_MfgOrderOperActyHoldCount view_entity inner COMPOSITE Number of active Prodution Holds of an Operation Activity
P_MfgOrderOperHoldCount view_entity inner COMPOSITE Number of active Operation Holds of a Production Order
P_MfgOrderSFIHoldCount view_entity inner COMPOSITE Number of active SFI Holds of a Production Order
P_MfgOrderWrkCtrHoldCount view_entity inner CONSUMPTION Number of active Work Center Holds of a Production Order
P_MfgOrdNrOfDefectSitns view inner COMPOSITE Defect situation count per order
P_Orderqtyissue view_entity inner CONSUMPTION Order Quantity Issue Calculation
P_OrdFirstOper view_entity inner CONSUMPTION Order First Operation Details
P_OrdFirstOperAggr view_entity inner COMPOSITE Grouping the Order By First Operation
P_Ordlatestoper view_entity inner CONSUMPTION Order Latest Operation Details
P_Ordoperaggr view_entity inner COMPOSITE Grouping the Order By Latest Operation

Fields (1)

KeyField CDS FieldsUsed in Views
KEY OrderID ManufacturingOrder 4 
@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_OrderBasic          as ordAufk 
   inner join I_LogisticsOrderBasic as ordAfko on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'
                                                and ordAfko.ProductionSupervisor is initial
   inner join I_PPAreaOfResponsibility as _AOR  on ordAufk.Plant = _AOR.Plant  
                                             and ordAfko.ProductionSupervisor = ''
                                             and ordAufk.OrderCategory = '10'
                                             and _AOR.ProductionSupervisor is initial 
                                             and _AOR.WorkCenterInternalID is initial 
   {
        key ordAfko.OrderID,    // _OrderBasic.ObjectInternalID

        ordAfko.OrderInternalID as OrderInternalBillOfOperations
   }

union

   select from I_OrderBasic          as ordAufk 
   inner join I_LogisticsOrderBasic as ordAfko on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'
                                                and ordAfko.ProductionSupervisor is not initial
   inner join I_PPAreaOfResponsibility as _AOR  on ordAufk.Plant = _AOR.Plant 
                                         and ordAfko.ProductionSupervisor = _AOR.ProductionSupervisor 
                                         and ordAufk.OrderCategory = '10'
                                         and _AOR.ProductionSupervisor is not initial 
                                         and _AOR.WorkCenterInternalID is initial            
   {
       key ordAfko.OrderID,    //  _Orders.ObjectInternalID

       ordAfko.OrderInternalID as OrderInternalBillOfOperations
   }

union

   select from I_LogisticsOrderBasic as ordAfko
   inner join I_OrderBasic          as ordAufk on ordAufk.OrderID = ordAfko.OrderID and ordAufk.OrderCategory = '10'  
                                                and ordAfko.ProductionSupervisor is initial   
   inner join I_OrderOperationBasic as _OrderOperBasic on ordAfko.OrderInternalID = _OrderOperBasic.OrderInternalID
                                                        and _OrderOperBasic.WorkCenterInternalID is not initial
   inner join I_PPAreaOfResponsibility as _AOR on _OrderOperBasic.WorkCenterInternalID = _AOR.WorkCenterInternalID                                                                 
                                                      and _OrderOperBasic.BillOfOperationsType <> 'R' and _OrderOperBasic.BillOfOperationsType <> '3'
                                                      and ordAufk.Plant = _AOR.Plant
                                                      and _AOR.ProductionSupervisor is initial and _AOR.WorkCenterInternalID is not initial 
     
  {
   key ordAfko.OrderID,  //  _OrdersBasic.ObjectInternalID

   ordAfko.OrderInternalID as OrderInternalBillOfOperations
  }

Learn More