Which tables does C_MfgOrderCompAssemblyAggrgn read from?

C_MfgOrderCompAssemblyAggrgn reads data from: P_MfgOrderCompAssemblyAggrgn3.

What VDM layer is C_MfgOrderCompAssemblyAggrgn?

C_MfgOrderCompAssemblyAggrgn is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MfgOrderCompAssemblyAggrgn

Q: What is C_MfgOrderCompAssemblyAggrgn in SAP S/4HANA?

C_MfgOrderCompAssemblyAggrgn is a consumption CDS view in SAP S/4HANA. It contains 49 fields.

DDL: C_MFGORDERCOMPASSEMBLYAGGRGN SQL: CMPECOMPASSEMBLA Type: view CONSUMPTION

49 Fields 1 Data Sources 2 Associations

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	Description
KEY	Reservation	P_MfgOrderCompAssemblyAggrgn3	Reservation	Reservation
KEY	ReservationItem	P_MfgOrderCompAssemblyAggrgn3	ReservationItem	Reservation Item
KEY	RecordType	P_MfgOrderCompAssemblyAggrgn3	RecordType	Reservation Record Type
KEY	OpActyNtwkInstance	P_MfgOrderCompAssemblyAggrgn3	OpActyNtwkInstance	Instance ID
KEY	OpActyNtwkElement	P_MfgOrderCompAssemblyAggrgn3	OpActyNtwkElement	Element Number
KEY	AssemblyShopFloorItem	P_MfgOrderCompAssemblyAggrgn3	AssemblyShopFloorItem
KEY	ShopFloorItem	P_MfgOrderCompAssemblyAggrgn3	ShopFloorItem	Serial.Mat. ID
KEY	Batch	P_MfgOrderCompAssemblyAggrgn3	Batch	Lot No.
KEY	Material	P_MfgOrderCompAssemblyAggrgn3	Material	Vehicle Model
KEY	Plant	P_MfgOrderCompAssemblyAggrgn3	Plant	Valuation Area
KEY	OriglDgtlMockUpCharcsUUID	P_MfgOrderCompAssemblyAggrgn3	OriglDgtlMockUpCharcsUUID	DMU GUID
	MfgRefStrucBOMLeafAssgmtUUID	P_MfgOrderCompAssemblyAggrgn3	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	P_MfgOrderCompAssemblyAggrgn3	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	P_MfgOrderCompAssemblyAggrgn3	MfgRefStrucItmDetIsContextual
	StorageLocation	_ReservationItem	StorageLocation	StorageLocation
	DgtlMockUpCharcsUUID	P_MfgOrderCompAssemblyAggrgn3	DgtlMockUpCharcsUUID	DMU GUID
	ReferenceDesignatorValue	P_MfgOrderCompAssemblyAggrgn3	ReferenceDesignatorValue	Ref. Designator
	ReferenceDesignatorName	P_MfgOrderCompAssemblyAggrgn3	ReferenceDesignatorName
	MaterialComponentQuantity	P_MfgOrderCompAssemblyAggrgn3	MaterialComponentQuantity
	RequiredQuantity	P_MfgOrderCompAssemblyAggrgn3	RequiredQuantity	Requirement qty
	MaterialBaseUnit	P_MfgOrderCompAssemblyAggrgn3	MaterialBaseUnit	Valuation Unit
	QuantityInEntryUnit	P_MfgOrderCompAssemblyAggrgn3	QuantityInEntryUnit	Quantity in Unit of Entry
	EntryUnit	P_MfgOrderCompAssemblyAggrgn3	EntryUnit	Unit of Entry
	DebitCreditCode	P_MfgOrderCompAssemblyAggrgn3	DebitCreditCode	Single-Character Flag
	SerialNumberasAssembledSerialNumber
	ManufacturerSerialNumber	P_MfgOrderCompAssemblyAggrgn3	ManufacturerSerialNumber	Mnf.serial no.
	BatchBySupplier	P_MfgOrderCompAssemblyAggrgn3	BatchBySupplier	Supplier Batch
	MfgRefStrucItmRefDesignator	P_MfgOrderCompAssemblyAggrgn3	MfgRefStrucItmRefDesignator
	MfgRefStrucItmRefDsgntrDesc	P_MfgOrderCompAssemblyAggrgn3	MfgRefStrucItmRefDsgntrDesc
	MfgRefStrucItmRefDsgntrName	P_MfgOrderCompAssemblyAggrgn3	MfgRefStrucItmRefDsgntrName	MRS Designator
	MaterialCompIsVariableSized
	FormulaKey	P_MfgOrderCompAssemblyAggrgn3	FormulaKey	VSI Formula
	VariableSizeDimension1	P_MfgOrderCompAssemblyAggrgn3	VariableSizeDimension1	Size 1
	VariableSizeDimension2	P_MfgOrderCompAssemblyAggrgn3	VariableSizeDimension2	Size 2
	VariableSizeDimension3	P_MfgOrderCompAssemblyAggrgn3	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	P_MfgOrderCompAssemblyAggrgn3	VariableSizeDimensionUnit	Size unit
	VariableSizeComponentQuantity	P_MfgOrderCompAssemblyAggrgn3	VariableSizeComponentQuantity	VSI Quantity
	VariableSizeComponentUnit	P_MfgOrderCompAssemblyAggrgn3	VariableSizeComponentUnit	VSI UoM
	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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MfgOrderCompAssemblyAggrgn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMPECOMPASSEMBLA

CREATE VIEW C_MfgOrderCompAssemblyAggrgn AS
SELECT
  MfgOrderCompAssemblyAggrgn.Reservation AS Reservation,
  MfgOrderCompAssemblyAggrgn.ReservationItem AS ReservationItem,
  MfgOrderCompAssemblyAggrgn.RecordType AS RecordType,
  MfgOrderCompAssemblyAggrgn.OpActyNtwkInstance AS OpActyNtwkInstance,
  MfgOrderCompAssemblyAggrgn.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderCompAssemblyAggrgn.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  MfgOrderCompAssemblyAggrgn.ShopFloorItem AS ShopFloorItem,
  MfgOrderCompAssemblyAggrgn.Batch AS Batch,
  MfgOrderCompAssemblyAggrgn.Material AS Material,
  MfgOrderCompAssemblyAggrgn.Plant AS Plant,
  MfgOrderCompAssemblyAggrgn.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  MfgOrderCompAssemblyAggrgn.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  MfgOrderCompAssemblyAggrgn.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  MfgOrderCompAssemblyAggrgn.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  _ReservationItem.StorageLocation AS StorageLocation,
  MfgOrderCompAssemblyAggrgn.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  MfgOrderCompAssemblyAggrgn.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  MfgOrderCompAssemblyAggrgn.ReferenceDesignatorName AS ReferenceDesignatorName,
  MfgOrderCompAssemblyAggrgn.MaterialComponentQuantity AS MaterialComponentQuantity,
  MfgOrderCompAssemblyAggrgn.RequiredQuantity AS RequiredQuantity,
  MfgOrderCompAssemblyAggrgn.MaterialBaseUnit AS MaterialBaseUnit,
  MfgOrderCompAssemblyAggrgn.QuantityInEntryUnit AS QuantityInEntryUnit,
  MfgOrderCompAssemblyAggrgn.EntryUnit AS EntryUnit,
  MfgOrderCompAssemblyAggrgn.DebitCreditCode AS DebitCreditCode,
  MfgOrderCompAssemblyAggrgn.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  MfgOrderCompAssemblyAggrgn.BatchBySupplier AS BatchBySupplier,
  MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDesignator AS MfgRefStrucItmRefDesignator,
  MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrDesc AS MfgRefStrucItmRefDsgntrDesc,
  MfgOrderCompAssemblyAggrgn.MfgRefStrucItmRefDsgntrName AS MfgRefStrucItmRefDsgntrName,
  MfgOrderCompAssemblyAggrgn.FormulaKey AS FormulaKey,
  MfgOrderCompAssemblyAggrgn.VariableSizeDimension1 AS VariableSizeDimension1,
  MfgOrderCompAssemblyAggrgn.VariableSizeDimension2 AS VariableSizeDimension2,
  MfgOrderCompAssemblyAggrgn.VariableSizeDimension3 AS VariableSizeDimension3,
  MfgOrderCompAssemblyAggrgn.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  MfgOrderCompAssemblyAggrgn.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  MfgOrderCompAssemblyAggrgn.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  MfgOrderCompAssemblyAggrgn._OpActyNtwkInstance AS _OpActyNtwkInstance,
  MfgOrderCompAssemblyAggrgn._OperationActivityInstance AS _OperationActivityInstance,
  MfgOrderCompAssemblyAggrgn._ShopFloorItem AS _ShopFloorItem,
  MfgOrderCompAssemblyAggrgn._ParentShopFloorItem AS _ParentShopFloorItem,
  MfgOrderCompAssemblyAggrgn._Material AS _Material,
  MfgOrderCompAssemblyAggrgn._Plant AS _Plant,
  MfgOrderCompAssemblyAggrgn._Reservation AS _Reservation,
  MfgOrderCompAssemblyAggrgn._MaterialBaseUnit AS _MaterialBaseUnit
FROM P_MfgOrderCompAssemblyAggrgn3 AS MfgOrderCompAssemblyAggrgn
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND storagelocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [0..1]
;

Depth:

C_MfgOrderCompAssemblyAggrgn view

P_MfgOrderCompAssemblyAggrgn3 view