P_MfgOrderComponentAssemblyAgg

DDL: P_MFGORDERCOMPONENTASSEMBLYAGG SQL: PMPECOMPASSAGG Type: view CONSUMPTION Package: MPE_EXEC_SFO

Assembly Qty at SFI@OA per Reservation and Material

P_MfgOrderComponentAssemblyAgg is a Consumption CDS View that provides data about "Assembly Qty at SFI@OA per Reservation and Material" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderComponentAssembly) and exposes 9 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_SFO.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderComponentAssembly I_MfgOrderComponentAssembly from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPASSAGG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Reservation Reservation
KEY ReservationItem ReservationItem
KEY RecordType RecordType
KEY OpActyNtwkInstance OpActyNtwkInstance
KEY OpActyNtwkElement OpActyNtwkElement
KEY Material Material
KEY AssemblyShopFloorItem AssemblyShopFloorItem
MaterialComponentQuantity
MaterialBaseUnit 
@AbapCatalog.sqlViewName: 'PMPECOMPASSAGG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
// Used in several classes

define view P_MfgOrderComponentAssemblyAgg
  as select from I_MfgOrderComponentAssembly
{
  key Reservation,
  key ReservationItem,
  key RecordType,
  key OpActyNtwkInstance,
  key OpActyNtwkElement,
  key Material,
  key AssemblyShopFloorItem,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(sum(MaterialComponentQuantity) as kmpmg preserving type) as MaterialComponentQuantity,
      cast(max(MaterialBaseUnit) as meins preserving type)          as MaterialBaseUnit
}
where
  MaterialComponentQuantity <> 0
group by
  Reservation,
  ReservationItem,
  RecordType,
  OpActyNtwkInstance,
  OpActyNtwkElement,
  Material,
  AssemblyShopFloorItem

Learn More