P_MFGOPERBASICAORLIST

CDS View

Orders and Operations List For AORs

P_MFGOPERBASICAORLIST is a CDS View in S/4HANA. Orders and Operations List For AORs. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_OrdLatestOperAggr view_entity from COMPOSITE Grouping the Order By Latest Operation

Fields (2)

KeyField CDS FieldsUsed in Views
KEY OrderInternalID OrderInternalBillOfOperations 1
Plant Plant 1 
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Orders and Operations List For AORs'

@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType:  #COMPOSITE
@VDM.private: true
@Metadata.ignorePropagatedAnnotations: true
define view entity P_MfgOperBasicAorList as  
  select from  I_ProductionOrdOpBasic as afvg
  inner join P_MfgOperationsList as _List on  _List.OrderInternalID = afvg.OrderInternalID
                                      and _List.OrderOperationInternalID  = afvg.OrderOperationInternalID
                                      and _List.Plant = afvg.Plant                                                                      
{
  @ObjectModel.foreignKey.association: '_OrderInternalID'
  key afvg.OrderInternalID,
  key afvg.OrderOperationInternalID,

      afvg.ManufacturingOrder,
      afvg.ManufacturingOrderCategory,
      afvg.ProductionPlant,
      afvg.ProductionSupervisor,

      // Semantic key

      afvg.Sequence,
      afvg.Operation,

      // BOO data

      afvg.BillOfOperationsSequence,
      afvg.BillOfOperationsType,
      afvg.BillOfOperationsGroup,
      afvg.BillOfOperationsVariant,
      afvg.BOOOperationInternalID,
      afvg.BillOfOperationsVersion,

      // BOM data

      afvg.BillOfMaterialCategory,
      afvg.BillOfMaterialInternalID,
      afvg.BillOfMaterialItemNodeNumber,
      afvg.BOMItemNodeCount,

      // Assignments

      afvg.SuperiorOperationInternalID,
      afvg.WorkCenterInternalID,
      afvg.Plant,

      afvg.ObjectInternalID,
      @Semantics.text: true
      afvg.OperationText,
      afvg.Language,
      // PP-PI data

      afvg.OrderIntBillOfOpItemOfPhase,
      afvg.MfgOrderOperationIsPhase,

      // Operation Unit

      //@Semantics.unitOfMeasure: true

      afvg.OperationUnit,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.OpPlannedTotalQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.OpPlannedScrapQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.OpTotalConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.OpTotalConfirmedScrapQty,

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      //OpPlannedYieldQuantity,

      afvg.OpPlannedYieldQuantity,

      afvg.OpErlstSchedldExecEndDte,
      afvg.OpErlstSchedldExecEndTme,
      afvg.OpLtstSchedldExecStrtDte,
      afvg.OpLtstSchedldExecStrtTme,
      afvg.OpLtstSchedldExecEndDte,
      afvg.OpLtstSchedldExecEndTme,
      afvg.OpActualExecutionStartDate,
      afvg.OpActualExecutionStartTime,
      afvg.OpActualExecutionEndDate,
      afvg.OpActualExecutionEndTime,
      afvg._OrderInternalID
}

Learn More