Which tables does C_MfgOrderCompAssemblyAggrgn use?

C_MfgOrderCompAssemblyAggrgn reads from 1 data source(s): P_MfgOrderCompAssemblyAggrgn3.

C_MfgOrderCompAssemblyAggrgn

Q: How many fields does C_MfgOrderCompAssemblyAggrgn have?

C_MfgOrderCompAssemblyAggrgn has 49 fields. Key fields: Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

DDL: C_MFGORDERCOMPASSEMBLYAGGRGN SQL: CMPECOMPASSEMBLA Type: view CONSUMPTION

C_MfgOrderCompAssemblyAggrgn is a Consumption CDS View 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.

Data Sources (1)

Source	Alias	Join Type
P_MfgOrderCompAssemblyAggrgn3	MfgOrderCompAssemblyAggrgn	from

Associations (2)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"P_MFGORDERCOMPASSEMBLYAGGRGN3"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_PLANT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONITEM",
"I_SHOPFLOORITEM",
"I_STORAGELOCATION",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_MFGORDERCOMPASSEMBLYAGGRGN3"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_MfgOrderCompAssemblyAggrgn view

P_MfgOrderCompAssemblyAggrgn3 view