I_MFGORDERCOMPASSEMBLYAGGRGN

CDS View

Assembled Qts at OA for Material, Serial Number and Batch

I_MFGORDERCOMPASSEMBLYAGGRGN is a CDS View in S/4HANA. Assembled Qts at OA for Material, Serial Number and Batch. It contains 26 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 26 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_MfgOrderAssembledSerialVH view from CONSUMPTION Serial Number
C_ShopFloorItemWhereUsedList view from CONSUMPTION Shop Floor Item Assembly Parent
P_AggrgdSFIOpActyComponents view from CONSUMPTION
P_MfgOrderCompAssemblyAggrgn2 view from CONSUMPTION
P_ShopFloorItemComponent view from CONSUMPTION

Fields (26)

KeyField CDS FieldsUsed in Views
KEY AssemblyShopFloorItem AssemblyShopFloorItem 3
KEY Batch Batch 3
KEY Material Material,MaterialComponent 3
KEY OpActyNtwkElement OpActyNtwkElement 3
KEY OpActyNtwkInstance OpActyNtwkInstance 3
KEY OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID 3
KEY Plant Plant 3
KEY RecordType RecordType 3
KEY Reservation Reservation 3
KEY ReservationItem ReservationItem 3
KEY ShopFloorItem ShopFloorItem 3
_Material _Material 2
_MaterialBaseUnit _MaterialBaseUnit 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityInstance _OperationActivityInstance 1
_ParentShopFloorItem _ParentShopFloorItem 1
_Plant _Plant 1
_Reservation _Reservation 1
_ShopFloorItem _ShopFloorItem 1
BatchBySupplier BatchBySupplier 1
DebitCreditCode DebitCreditCode 2
DgtlMockUpCharcsUUID DgtlMockUpCharcsUUID 2
ManufacturerSerialNumber ManufacturerSerialNumber 1
MaterialBaseUnit MaterialBaseUnit 2
MaterialComponentQuantity MaterialComponentQuantity 2
ReferenceDesignatorValue ReferenceDesignatorValue 3 
@AbapCatalog.sqlViewName: 'IMPECOMPASSEMBLA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY 
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Assembled Qts at OA for Material, Serial Number and Batch'
define view I_MfgOrderCompAssemblyAggrgn
  as select from P_MfgOrderCompAssemblyAggrgn

  association [0..1] to I_StorageLocation as _StorageLocation on  $projection.Plant           = _StorageLocation.Plant
                                                              and $projection.storagelocation = _StorageLocation.StorageLocation
  association [0..1] to I_ReservationItem as _ReservationItem on  $projection.Reservation     = _ReservationItem.Reservation
                                                              and $projection.ReservationItem = _ReservationItem.ReservationItem
                                                              and $projection.RecordType      = _ReservationItem.RecordType
{
      @ObjectModel.foreignKey.association: '_Reservation'
  key Reservation,
  key ReservationItem,
  key RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyNtwkInstanceStdVH', element: 'OpActyNtwkInstance' } } ]
  key OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyInstceStdVH', element: 'OpActyNtwkElement' } } ]
  key OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_ParentShopFloorItem'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ShopFloorItemStdVH', element: 'ShopFloorItem' } } ]
  key AssemblyShopFloorItem,
      @ObjectModel.foreignKey.association: '_ShopFloorItem'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ShopFloorItemStdVH', element: 'ShopFloorItem' } } ]
  key ShopFloorItem,

  key Batch,
      @ObjectModel.foreignKey.association: '_Material'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
  key Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key Plant,
  key OriglDgtlMockUpCharcsUUID,

      @ObjectModel.foreignKey.association: '_StorageLocation'
      _ReservationItem.StorageLocation,
      DgtlMockUpCharcsUUID,
      ReferenceDesignatorValue,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MaterialComponentQuantity,
      @Semantics.unitOfMeasure: true
      MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      EntryUnit,
      DebitCreditCode,
      -- Fields consumend from the UI
      _ShopFloorItem.SerialNumber                        as AssembledSerialNumber,
      _ShopFloorItem._Equipment.ManufacturerSerialNumber as ManufacturerSerialNumber,
      _BatchDistinct.BatchBySupplier                     as BatchBySupplier,

      _OpActyNtwkInstance,
      _OperationActivityInstance,
      _ShopFloorItem,
      _ParentShopFloorItem,
      _Material,
      _Plant,
      _StorageLocation,
      _Reservation,
      _ReservationItem,
      _MaterialBaseUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BATCHDISTINCT",
"I_EQUIPMENT",
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"P_MFGORDERCOMPASSEMBLYAGGRGN"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_PLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_MFGORDERCOMPASSEMBLYAGGRGN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More