C_MfgOrderCompAssemblyAggrgn

DDL: C_MFGORDERCOMPASSEMBLYAGGRGN SQL: CMPECOMPASSEMBLA Type: view CONSUMPTION Package: MPE_EXEC_SFO

Assembled Qts for OA

C_MfgOrderCompAssemblyAggrgn is a Consumption CDS View that provides data about "Assembled Qts for OA" in SAP S/4HANA. It reads from 1 data source (P_MfgOrderCompAssemblyAggrgn3) and exposes 49 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 2 associations to related views. Part of development package MPE_EXEC_SFO.

1 data source(s) 49 fields

Data Sources (1)

SourceAliasJoin Type
P_MfgOrderCompAssemblyAggrgn3 MfgOrderCompAssemblyAggrgn from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.storagelocation = _StorageLocation.StorageLocation
[0..1] I_ReservationItem _ReservationItem $projection.Reservation = _ReservationItem.Reservation and $projection.ReservationItem = _ReservationItem.ReservationItem and $projection.RecordType = _ReservationItem.RecordType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPECOMPASSEMBLA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_MfgOrderCompAssemblyAggrgn3 Reservation
KEY ReservationItem P_MfgOrderCompAssemblyAggrgn3 ReservationItem
KEY RecordType P_MfgOrderCompAssemblyAggrgn3 RecordType
KEY OpActyNtwkInstance P_MfgOrderCompAssemblyAggrgn3 OpActyNtwkInstance
KEY OpActyNtwkElement P_MfgOrderCompAssemblyAggrgn3 OpActyNtwkElement
KEY AssemblyShopFloorItem P_MfgOrderCompAssemblyAggrgn3 AssemblyShopFloorItem
KEY ShopFloorItem P_MfgOrderCompAssemblyAggrgn3 ShopFloorItem
KEY Batch P_MfgOrderCompAssemblyAggrgn3 Batch
KEY Material P_MfgOrderCompAssemblyAggrgn3 Material
KEY Plant P_MfgOrderCompAssemblyAggrgn3 Plant
KEY OriglDgtlMockUpCharcsUUID P_MfgOrderCompAssemblyAggrgn3 OriglDgtlMockUpCharcsUUID
MfgRefStrucBOMLeafAssgmtUUID P_MfgOrderCompAssemblyAggrgn3 MfgRefStrucBOMLeafAssgmtUUID
MfgRefStructureItemDetailUUID P_MfgOrderCompAssemblyAggrgn3 MfgRefStructureItemDetailUUID
MfgRefStrucItmDetIsContextual P_MfgOrderCompAssemblyAggrgn3 MfgRefStrucItmDetIsContextual
StorageLocation _ReservationItem StorageLocation
DgtlMockUpCharcsUUID P_MfgOrderCompAssemblyAggrgn3 DgtlMockUpCharcsUUID
ReferenceDesignatorValue P_MfgOrderCompAssemblyAggrgn3 ReferenceDesignatorValue
ReferenceDesignatorName P_MfgOrderCompAssemblyAggrgn3 ReferenceDesignatorName
MaterialComponentQuantity P_MfgOrderCompAssemblyAggrgn3 MaterialComponentQuantity
RequiredQuantity P_MfgOrderCompAssemblyAggrgn3 RequiredQuantity
MaterialBaseUnit P_MfgOrderCompAssemblyAggrgn3 MaterialBaseUnit
QuantityInEntryUnit P_MfgOrderCompAssemblyAggrgn3 QuantityInEntryUnit
EntryUnit P_MfgOrderCompAssemblyAggrgn3 EntryUnit
DebitCreditCode P_MfgOrderCompAssemblyAggrgn3 DebitCreditCode
SerialNumberasAssembledSerialNumber
ManufacturerSerialNumber P_MfgOrderCompAssemblyAggrgn3 ManufacturerSerialNumber
BatchBySupplier P_MfgOrderCompAssemblyAggrgn3 BatchBySupplier
MfgRefStrucItmRefDesignator P_MfgOrderCompAssemblyAggrgn3 MfgRefStrucItmRefDesignator
MfgRefStrucItmRefDsgntrDesc P_MfgOrderCompAssemblyAggrgn3 MfgRefStrucItmRefDsgntrDesc
MfgRefStrucItmRefDsgntrName P_MfgOrderCompAssemblyAggrgn3 MfgRefStrucItmRefDsgntrName
MaterialCompIsVariableSized
FormulaKey P_MfgOrderCompAssemblyAggrgn3 FormulaKey
VariableSizeDimension1 P_MfgOrderCompAssemblyAggrgn3 VariableSizeDimension1
VariableSizeDimension2 P_MfgOrderCompAssemblyAggrgn3 VariableSizeDimension2
VariableSizeDimension3 P_MfgOrderCompAssemblyAggrgn3 VariableSizeDimension3
VariableSizeDimensionUnit P_MfgOrderCompAssemblyAggrgn3 VariableSizeDimensionUnit
VariableSizeComponentQuantity P_MfgOrderCompAssemblyAggrgn3 VariableSizeComponentQuantity
VariableSizeComponentUnit P_MfgOrderCompAssemblyAggrgn3 VariableSizeComponentUnit
VarblSizeCompFrmtdFormulaVal
_OpActyNtwkInstance P_MfgOrderCompAssemblyAggrgn3 _OpActyNtwkInstance
_OperationActivityInstance P_MfgOrderCompAssemblyAggrgn3 _OperationActivityInstance
_ShopFloorItem P_MfgOrderCompAssemblyAggrgn3 _ShopFloorItem
_ParentShopFloorItem P_MfgOrderCompAssemblyAggrgn3 _ParentShopFloorItem
_Material P_MfgOrderCompAssemblyAggrgn3 _Material
_Plant P_MfgOrderCompAssemblyAggrgn3 _Plant
_Reservation P_MfgOrderCompAssemblyAggrgn3 _Reservation
_ReservationItem _ReservationItem
_StorageLocation _StorageLocation
_MaterialBaseUnit P_MfgOrderCompAssemblyAggrgn3 _MaterialBaseUnit 
@AbapCatalog.sqlViewName: 'CMPECOMPASSEMBLA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY 
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
//@EndUserText.label: 'Assembled Qts at OA'

define view C_MfgOrderCompAssemblyAggrgn
  as select from P_MfgOrderCompAssemblyAggrgn3 as 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 MfgOrderCompAssemblyAggrgn.Reservation,
  key MfgOrderCompAssemblyAggrgn.ReservationItem,
  key MfgOrderCompAssemblyAggrgn.RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyNtwkInstanceStdVH', element: 'OpActyNtwkInstance' } } ]
  key MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OpActyInstceStdVH', element: 'OpActyNtwkElement' } } ]
  key MfgOrderCompAssemblyAggrgn.OpActyNtwkElement,
      @ObjectModel.foreignKey.association: '_ParentShopFloorItem'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ShopFloorItemStdVH', element: 'ShopFloorItem' } } ]
  key MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem,
      @ObjectModel.foreignKey.association: '_ShopFloorItem'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ShopFloorItemStdVH', element: 'ShopFloorItem' } } ]
  key MfgOrderCompAssemblyAggrgn.ShopFloorItem,

  key MfgOrderCompAssemblyAggrgn.Batch,
      @ObjectModel.foreignKey.association: '_Material'
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
  key MfgOrderCompAssemblyAggrgn.Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key MfgOrderCompAssemblyAggrgn.Plant,
  key MfgOrderCompAssemblyAggrgn.OriglDgtlMockUpCharcsUUID,
      MfgOrderCompAssemblyAggrgn.MfgRefStrucBOMLeafAssgmtUUID,
      MfgOrderCompAssemblyAggrgn.MfgRefStructureItemDetailUUID,
      MfgOrderCompAssemblyAggrgn.MfgRefStrucItmDetIsContextual,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      _ReservationItem.StorageLocation,
      MfgOrderCompAssemblyAggrgn.DgtlMockUpCharcsUUID,
      MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue,
      MfgOrderCompAssemblyAggrgn.ReferenceDesignatorName,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MfgOrderCompAssemblyAggrgn.MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MfgOrderCompAssemblyAggrgn.RequiredQuantity,
      @Semantics.unitOfMeasure: true
      MfgOrderCompAssemblyAggrgn.MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      MfgOrderCompAssemblyAggrgn.QuantityInEntryUnit,
      @Semantics.unitOfMeasure: true
      MfgOrderCompAssemblyAggrgn.EntryUnit,
      MfgOrderCompAssemblyAggrgn.DebitCreditCode,
      -- Fields consumend from the UI
      MfgOrderCompAssemblyAggrgn._ShopFloorItem.SerialNumber as AssembledSerialNumber,
      MfgOrderCompAssemblyAggrgn.ManufacturerSerialNumber    as ManufacturerSerialNumber,
      MfgOrderCompAssemblyAggrgn.BatchBySupplier             as BatchBySupplier,

      @ObjectModel.text.element: 'MfgRefStrucItmRefDsgntrDesc'
      MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDesignator,
      MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrDesc,
      MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName,
      -- Variable-Size Item Fields
      MfgOrderCompAssemblyAggrgn.MaterialCompIsVariableSized,
      MfgOrderCompAssemblyAggrgn.FormulaKey,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      MfgOrderCompAssemblyAggrgn.VariableSizeDimension1,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      MfgOrderCompAssemblyAggrgn.VariableSizeDimension2,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      MfgOrderCompAssemblyAggrgn.VariableSizeDimension3,
      @Semantics.unitOfMeasure: true
      MfgOrderCompAssemblyAggrgn.VariableSizeDimensionUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      MfgOrderCompAssemblyAggrgn.VariableSizeComponentQuantity,
      MfgOrderCompAssemblyAggrgn.VariableSizeComponentUnit,
      @ObjectModel: {
        virtualElement: true,
        virtualElementCalculatedBy: 'ABAP:CL_MPE_VSI_FRMTD_FORMULA_VE'
      }
      cast('' as mpe_vsi_formatted_formula)                  as VarblSizeCompFrmtdFormulaVal,

      MfgOrderCompAssemblyAggrgn._OpActyNtwkInstance,
      MfgOrderCompAssemblyAggrgn._OperationActivityInstance,
      MfgOrderCompAssemblyAggrgn._ShopFloorItem,
      MfgOrderCompAssemblyAggrgn._ParentShopFloorItem,
      MfgOrderCompAssemblyAggrgn._Material,
      MfgOrderCompAssemblyAggrgn._Plant,
      MfgOrderCompAssemblyAggrgn._Reservation,
      _ReservationItem,
      _StorageLocation,
      MfgOrderCompAssemblyAggrgn._MaterialBaseUnit

}

Learn More