I_PRODUCTIONORDOPBASIC

CDS View

Production Order Operation afvg

I_PRODUCTIONORDOPBASIC is a CDS View in S/4HANA. Production Order Operation afvg. It contains 8 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 8 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_MfgOrderWrkCtrHoldCount view_entity from CONSUMPTION
P_OrdFirstOper view_entity left_outer CONSUMPTION
P_OrdFirstOperAggr view_entity from CONSUMPTION
P_Ordlatestoper view_entity left_outer CONSUMPTION
P_OrdLatestOperAggr view_entity from CONSUMPTION
P_Ordoperaggr view_entity from CONSUMPTION

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ManufacturingOrder ManufacturingOrder 3
KEY OrderInternalID OrderInternalBillOfOperations 3
ManufacturingOrderCategory ManufacturingOrderCategory 2
OperationText FirstOperationText,LatestOperationText 2
OperationUnit OperationUnit 2
OpPlannedTotalQuantity OpFirstPlannedTotalQty,OpLtstPlannedTotalQty 2
OpTotalConfirmedScrapQty OpLtstConfirmedScrapQty 1
OpTotalConfirmedYieldQty OpFirstConfirmedYieldQty,OpLtstConfirmedYieldQty 2 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Production Order Operation afvg'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.semanticKey: ['OrderInternalID', 'OrderOperationInternalID']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #BASIC
//@VDM.private: true

define view entity I_ProductionOrdOpBasic
  as select from P_ProdOrdMgmtOpBasic as afvg
  left outer to one join I_StatusObjectStatusBasic as _isDeleted   on _isDeleted.StatusObject   = afvg.objnr and _isDeleted.StatusCode   = 'I0013' and _isDeleted.StatusIsInactive   = '' // OperationIsDeleted

  association [1..1] to I_OrderInternalID as _OrderInternalID on  $projection.OrderInternalID = _OrderInternalID.OrderInternalID
  
{
  @ObjectModel.foreignKey.association: '_OrderInternalID'
  key afvg.aufpl                                        as OrderInternalID,
  key afvg.aplzl                                        as OrderOperationInternalID,

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

      // Semantic key

      afvg.aplfl                                        as Sequence,
      afvg.vornr                                        as Operation,

      // BOO data

      afvg.plnfl                                        as BillOfOperationsSequence,
      afvg.plnty                                        as BillOfOperationsType,
      afvg.plnnr                                        as BillOfOperationsGroup,
      afvg.plnal                                        as BillOfOperationsVariant,
      afvg.plnkn                                        as BOOOperationInternalID,
      afvg.tl_versn                                     as BillOfOperationsVersion,

      // BOM data

      afvg.istty                                        as BillOfMaterialCategory,
      afvg.istnr                                        as BillOfMaterialInternalID,
      afvg.istkn                                        as BillOfMaterialItemNodeNumber,
      afvg.istpo                                        as BOMItemNodeCount,

      // Assignments

      afvg.sumnr                                        as SuperiorOperationInternalID,
      afvg.arbid                                        as WorkCenterInternalID,
      afvg.werks                                        as Plant,

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

      afvg.pvzkn                                        as OrderIntBillOfOpItemOfPhase,
      afvg.phflg                                        as MfgOrderOperationIsPhase,

      // Operation Unit

      //@Semantics.unitOfMeasure: true

      afvg.meinh                                        as OperationUnit,

      // Quantities

      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.mgvrg                                        as OpPlannedTotalQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.asvrg                                        as OpPlannedScrapQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.lmnga                                        as OpTotalConfirmedYieldQty,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      afvg.xmnga                                        as OpTotalConfirmedScrapQty,

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

      cast((afvg.mgvrg - afvg.asvrg) as vdm_gmeng) as OpPlannedYieldQuantity,

      afvg.fsedd                                        as OpErlstSchedldExecEndDte,
      afvg.fsedz                                        as OpErlstSchedldExecEndTme,
      afvg.ssavd                                        as OpLtstSchedldExecStrtDte,
      afvg.ssavz                                        as OpLtstSchedldExecStrtTme,
      afvg.ssedd                                        as OpLtstSchedldExecEndDte,
      afvg.ssedz                                        as OpLtstSchedldExecEndTme,
      afvg.isdd                                         as OpActualExecutionStartDate,
      afvg.isdz                                         as OpActualExecutionStartTime,
      afvg.iedd                                         as OpActualExecutionEndDate,
      afvg.iedz                                         as OpActualExecutionEndTime,
      _OrderInternalID
}
where
      afvg.ManufacturingOrderCategory = '10'
  and afvg.sumnr                 is initial //SuperiorOperationInternalID

  and afvg.aplfl                 = '000000' //Sequence

  and _isDeleted.StatusCode is null

Learn More