I_OPACTYASSEMBLYBYCOMPONENT

CDS View

OA Assembly by Component, Material and Plant

I_OPACTYASSEMBLYBYCOMPONENT is a CDS View in S/4HANA. OA Assembly by Component, Material and Plant. It contains 9 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 9 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_OperationActivityCompUnion view union_all CONSUMPTION

Fields (9)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY Plant Plant 1
KEY RecordType RecordType 1
KEY Reservation Reservation 1
KEY ReservationItem ReservationItem 1
EntryUnit EntryUnit 1
MaterialBaseUnit BaseUnit 1
MaterialComponentQuantity MaterialComponentQuantity 1 
@AbapCatalog.sqlViewName: 'IMPEOAASSYBYCOMP'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'OA Assembly by Component, Material and Plant'
define view I_OpActyAssemblyByComponent
  as select from I_MfgOrderComponentAssembly as MfgOrderComponentAssembly
  association [0..1] to I_UnitOfMeasure as _MaterialBaseUnit on $projection.MaterialBaseUnit = _MaterialBaseUnit.UnitOfMeasure
{
  key MfgOrderComponentAssembly.Reservation,
  key MfgOrderComponentAssembly.ReservationItem,
  key MfgOrderComponentAssembly.RecordType,
  key MfgOrderComponentAssembly.OpActyNtwkInstance,
  key MfgOrderComponentAssembly.OpActyNtwkElement,
  key MfgOrderComponentAssembly.Material,
  key MfgOrderComponentAssembly.Plant,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(sum(MfgOrderComponentAssembly.MaterialComponentQuantity) as mpe_consumed_qty preserving type) as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(max(MfgOrderComponentAssembly.RequiredQuantity) as bdmng preserving type)                     as RequiredQuantity,
      @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,
      cast(max(MfgOrderComponentAssembly.EntryUnit) as erfme preserving type)                            as EntryUnit,

      MfgOrderComponentAssembly._Reservation,
      MfgOrderComponentAssembly._ReservationItem,
      MfgOrderComponentAssembly._OpActyNtwkInstance,
      MfgOrderComponentAssembly._OperationActivityInstance,
      MfgOrderComponentAssembly._Material,
      MfgOrderComponentAssembly._Plant,
      _MaterialBaseUnit
}
group by
  MfgOrderComponentAssembly.Reservation,
  MfgOrderComponentAssembly.ReservationItem,
  MfgOrderComponentAssembly.RecordType,
  MfgOrderComponentAssembly.OpActyNtwkInstance,
  MfgOrderComponentAssembly.OpActyNtwkElement,
  MfgOrderComponentAssembly.Material,
  MfgOrderComponentAssembly.Plant
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDERCOMPONENTASSEMBLY"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_PLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MFGORDERCOMPONENTASSEMBLY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More