P_MfgOrdOperConfObjPgQtSum

DDL: P_MFGORDOPERCONFOBJPGQTSUM Type: view_entity COMPOSITE Package: ODATA_MPE_MFGORDER

Manufacturing order confirmation Quantity Sum

P_MfgOrdOperConfObjPgQtSum is a Composite CDS View that provides data about "Manufacturing order confirmation Quantity Sum" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationConf) and exposes 12 fields with key field MfgOrderConfirmation. Part of development package ODATA_MPE_MFGORDER.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationConf _orderOperation from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Manufacturing order confirmation Quantity Sum view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MfgOrderConfirmation I_MfgOrderOperationConf MfgOrderConfirmation
ManufacturingOrder I_MfgOrderOperationConf ManufacturingOrder
ManufacturingOrderType I_MfgOrderOperationConf ManufacturingOrderType
ProductionPlant I_MfgOrderOperationConf ProductionPlant
ConfirmationUnit I_MfgOrderOperationConf ConfirmationUnit
OpTotalConfirmedYieldQty
OpTotalConfirmedScrapQty
MfgOrderConfirmedReworkQty
_MfgOrder I_MfgOrderOperationConf _MfgOrder
_ConfirmationGroup I_MfgOrderOperationConf _ConfirmationGroup
_MfgOrderType I_MfgOrderOperationConf _MfgOrderType
_ProductionPlant I_MfgOrderOperationConf _ProductionPlant 
@VDM.viewType : #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@EndUserText.label: 'Manufacturing order confirmation Quantity Sum'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private:true 

define view entity P_MfgOrdOperConfObjPgQtSum
  as select from I_MfgOrderOperationConf as _orderOperation

{
// Key

           @ObjectModel.foreignKey.association: '_ConfirmationGroup'
  key      _orderOperation.MfgOrderConfirmation,
             // Order data

           @ObjectModel.foreignKey.association: '_MfgOrder'
           _orderOperation.ManufacturingOrder,
           @ObjectModel.foreignKey.association: '_MfgOrderType'
           _orderOperation.ManufacturingOrderType,
           @ObjectModel.foreignKey.association: '_ProductionPlant'
           _orderOperation.ProductionPlant,
           //@Semantics.unitOfMeasure: true

           _orderOperation.ConfirmationUnit,           
           @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
           sum( _orderOperation.ConfirmationYieldQuantity )               as OpTotalConfirmedYieldQty,
           @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
           sum( _orderOperation.ConfirmationScrapQuantity )               as OpTotalConfirmedScrapQty,
           @Semantics.quantity.unitOfMeasure: 'ConfirmationUnit'
           sum( _orderOperation.ConfirmationReworkQuantity )              as MfgOrderConfirmedReworkQty,
  
           _orderOperation._MfgOrder,
           _orderOperation._ConfirmationGroup,
           _orderOperation._MfgOrderType,
           _orderOperation._ProductionPlant  

}
group by
  _orderOperation.MfgOrderConfirmation,
  _orderOperation.ManufacturingOrder,
  _orderOperation.ManufacturingOrderType,
  _orderOperation.ProductionPlant,
  _orderOperation.ConfirmationUnit

Learn More