P_MfgOrderCompAssyWthoutInstce

DDL: P_MFGORDERCOMPASSYWTHOUTINSTCE SQL: PMPECOMPASMAGGNI Type: view COMPOSITE Package: MPE_EXEC_SFO

Assembly Qty at SFI@OA per RESB, Matl, SerialNr and Batch

P_MfgOrderCompAssyWthoutInstce is a Composite CDS View that provides data about "Assembly Qty at SFI@OA per RESB, Matl, SerialNr and Batch" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderComponentAssembly) and exposes 24 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 1 association to related views. Part of development package MPE_EXEC_SFO.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderComponentAssembly MfgOrderComponentAssembly from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _MaterialBaseUnit $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPASMAGGNI view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter 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 #COMPOSITE view
VDM.private true view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_MfgOrderComponentAssembly Reservation
KEY ReservationItem I_MfgOrderComponentAssembly ReservationItem
KEY RecordType I_MfgOrderComponentAssembly RecordType
KEY OpActyNtwkInstance I_MfgOrderComponentAssembly OpActyNtwkInstance
KEY OpActyNtwkElement I_MfgOrderComponentAssembly OpActyNtwkElement
KEY AssemblyShopFloorItem I_MfgOrderComponentAssembly AssemblyShopFloorItem
KEY ShopFloorItem I_MfgOrderComponentAssembly ShopFloorItem
KEY Batch I_MfgOrderComponentAssembly Batch
KEY Material I_MfgOrderComponentAssembly Material
KEY Plant I_MfgOrderComponentAssembly Plant
DebitCreditCode I_MfgOrderComponentAssembly DebitCreditCode
MaterialComponentQuantity
MaterialBaseUnit
QuantityInEntryUnit
EntryUnit
_OpActyNtwkInstance I_MfgOrderComponentAssembly _OpActyNtwkInstance
_OperationActivityInstance I_MfgOrderComponentAssembly _OperationActivityInstance
_ShopFloorItem I_MfgOrderComponentAssembly _ShopFloorItem
_ParentShopFloorItem I_MfgOrderComponentAssembly _ParentShopFloorItem
_BatchDistinct I_MfgOrderComponentAssembly _BatchDistinct
_Material I_MfgOrderComponentAssembly _Material
_Plant I_MfgOrderComponentAssembly _Plant
_Reservation I_MfgOrderComponentAssembly _Reservation
_MaterialBaseUnit _MaterialBaseUnit 
@AbapCatalog.sqlViewName: 'PMPECOMPASMAGGNI'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
// Used in C_SHOPFLOORITEMATOPACTYCOMP to get number of assembled materials per component

define view P_MfgOrderCompAssyWthoutInstce
  as select from I_MfgOrderComponentAssembly as MfgOrderComponentAssembly
  association [0..1] to I_UnitOfMeasure as _MaterialBaseUnit on $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
{
      @ObjectModel.foreignKey.association: '_Reservation'
  key MfgOrderComponentAssembly.Reservation,
  key MfgOrderComponentAssembly.ReservationItem,
  key MfgOrderComponentAssembly.RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key MfgOrderComponentAssembly.OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key MfgOrderComponentAssembly.OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_ParentShopFloorItem'
  key MfgOrderComponentAssembly.AssemblyShopFloorItem,
      @ObjectModel.foreignKey.association: '_ShopFloorItem'
  key MfgOrderComponentAssembly.ShopFloorItem,

  key MfgOrderComponentAssembly.Batch,
      @ObjectModel.foreignKey.association: '_Material'
  key MfgOrderComponentAssembly.Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key MfgOrderComponentAssembly.Plant,

      MfgOrderComponentAssembly.DebitCreditCode,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(sum(MfgOrderComponentAssembly.MaterialComponentQuantity) as kmpmg preserving type) as MaterialComponentQuantity,
      @Semantics.unitOfMeasure: true
      cast(max(MfgOrderComponentAssembly.MaterialBaseUnit) as meins preserving type)          as MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(sum(MfgOrderComponentAssembly.QuantityInEntryUnit) as erfmgv preserving type)      as QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      cast(max(MfgOrderComponentAssembly.EntryUnit) as erfme preserving type)                 as EntryUnit,

      MfgOrderComponentAssembly._OpActyNtwkInstance,
      MfgOrderComponentAssembly._OperationActivityInstance,
      MfgOrderComponentAssembly._ShopFloorItem,
      MfgOrderComponentAssembly._ParentShopFloorItem,
      MfgOrderComponentAssembly._BatchDistinct,
      MfgOrderComponentAssembly._Material,
      MfgOrderComponentAssembly._Plant,
      MfgOrderComponentAssembly._Reservation,
      _MaterialBaseUnit
}
group by
  MfgOrderComponentAssembly.Reservation,
  MfgOrderComponentAssembly.ReservationItem,
  MfgOrderComponentAssembly.RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement,
  MfgOrderComponentAssembly.AssemblyShopFloorItem,
  MfgOrderComponentAssembly.ShopFloorItem,
  MfgOrderComponentAssembly.Batch,
  MfgOrderComponentAssembly.Material,
  MfgOrderComponentAssembly.Plant,
  MfgOrderComponentAssembly.DebitCreditCode

Learn More