What is C_OpActyInstanceAssembledComp in SAP S/4HANA?

C_OpActyInstanceAssembledComp is a consumption CDS view in SAP S/4HANA. Component assembled at an OA instance It contains 69 fields.

Which tables does C_OpActyInstanceAssembledComp read from?

C_OpActyInstanceAssembledComp reads data from: I_OpActyInstanceAssembledComp.

What VDM layer is C_OpActyInstanceAssembledComp?

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

C_OpActyInstanceAssembledComp

DDL: C_OPACTYINSTANCEASSEMBLEDCOMP SQL: CMPEOAIAAMAT Type: view CONSUMPTION

69 Fields 1 Data Sources 2 Associations

Component assembled at an OA instance

C_OpActyInstanceAssembledComp is a Consumption CDS View that provides data about "Component assembled at an OA instance" in SAP S/4HANA. It reads from 1 data source (I_OpActyInstanceAssembledComp) and exposes 69 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_OpActyInstanceAssembledComp	OpActyInstanceAssembledComp	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_MfgBOMItemWithPhantomHier	_MfgBOMItemWithPhantomHier	`$projection.BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial and $projection.BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant and $projection.BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion and $projection.InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr --Extension`
[0..1]	E_BillOfMaterialItemTP	_BillOfMaterialItemExtension	`$projection.BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory and $projection.BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial and $projection.BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CMPEOAIAAMAT	view
AccessControl.authorizationCheck	#MANDATORY	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
AbapCatalog.compiler.compareFilter	true	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Component assembled at an OA instance	view

Fields (69)

Key	Field	Source Table	Source Field	Description
KEY	OpActyNtwkInstance	I_OpActyInstanceAssembledComp	OpActyNtwkInstance	Instance ID
KEY	OpActyNtwkElement	I_OpActyInstanceAssembledComp	OpActyNtwkElement	Element Number
KEY	Reservation	I_OpActyInstanceAssembledComp	Reservation	Reservation
KEY	ReservationItem	I_OpActyInstanceAssembledComp	ReservationItem	Reservation Item
KEY	RecordType	I_OpActyInstanceAssembledComp	RecordType	Reservation Record Type
KEY	Material	I_OpActyInstanceAssembledComp	Material	Vehicle Model
	Plant
	StorageLocation	I_OpActyInstanceAssembledComp	StorageLocation	StorageLocation
	MaterialName
	MaterialBaseUnit	I_OpActyInstanceAssembledComp	MaterialBaseUnit	Valuation Unit
	RequiredQuantity	I_OpActyInstanceAssembledComp	RequiredQuantity	Requirement qty
	MaterialComponentQuantity	I_OpActyInstanceAssembledComp	MaterialComponentQuantity
	ResvnItmWithdrawnQtyInBaseUnit	I_OpActyInstanceAssembledComp	ResvnItmWithdrawnQtyInBaseUnit	Withdrawal Qty
	EntryUnit	I_OpActyInstanceAssembledComp	EntryUnit	Unit of Entry
	MatlCompIsMarkedForBackflush	I_OpActyInstanceAssembledComp	MatlCompIsMarkedForBackflush	Backflush
	GoodsMovementIsAllowed	I_OpActyInstanceAssembledComp	GoodsMovementIsAllowed	Mvt Allowed
	MatlCompInstceAssyIsRequired	I_OpActyInstanceAssembledComp	MatlCompInstceAssyIsRequired	Instances Exist
	BOOOpBOMItemInternalID	I_OpActyInstanceAssembledComp	BOOOpBOMItemInternalID	Allocation no.
	ManufacturingOrder	I_OpActyInstanceAssembledComp	ManufacturingOrder	Order
	ManufacturingOrderOperation	I_OpActyInstanceAssembledComp	ManufacturingOrderOperation	Activity
	MfgOrderOperationText	I_OpActyInstanceAssembledComp	MfgOrderOperationText
	OperationActivity	I_OpActyInstanceAssembledComp	OperationActivity	Operation Activity
	OperationActyVersionCounter	I_OpActyInstanceAssembledComp	OperationActyVersionCounter	OA Version
	OperationActivityName
	BillOfOperationsType	I_OpActyInstanceAssembledComp	BillOfOperationsType	Task List Type
	BillOfOperationsGroup	I_OpActyInstanceAssembledComp	BillOfOperationsGroup	Group
	RequiredQuantitythen1red
	RequiredQuantitythen3greenelse2yellow
	MatlCompAssembleControl	I_OpActyInstanceAssembledComp	MatlCompAssembleControl
	MatlCompAssembleControlName
	SerialNumberProfile	I_OpActyInstanceAssembledComp	SerialNumberProfile	SerialNoProfile
	SerialNumberIsRqdForAssembly	I_OpActyInstanceAssembledComp	SerialNumberIsRqdForAssembly
	IsBatchManagementRequired	I_OpActyInstanceAssembledComp	IsBatchManagementRequired	Batch Mgmt Rqt(Plnt)
	StockCheckMessageType	I_OpActyInstanceAssembledComp	StockCheckMessageType
	BillOfMaterialCategory	I_OpActyInstanceAssembledComp	BillOfMaterialCategory	BOM category
	BillOfMaterialVariant	I_OpActyInstanceAssembledComp	BillOfMaterialVariant	AlternativeBOM
	BillOfMaterialVersion	I_OpActyInstanceAssembledComp	BillOfMaterialVersion	BOM Version
	InheritedBOMItemNode	I_OpActyInstanceAssembledComp	InheritedBOMItemNode
	BillOfMaterialInternalID	I_OpActyInstanceAssembledComp	BillOfMaterialInternalID
	BOMItem	I_OpActyInstanceAssembledComp	BOMItem
	BOMItemInternalChangeCount	I_OpActyInstanceAssembledComp	BOMItemInternalChangeCount	Counter
	BOMItemCategory	I_OpActyInstanceAssembledComp	BOMItemCategory	Item Category
	MaterialCompIsVariableSized
	FormulaKey	I_OpActyInstanceAssembledComp	FormulaKey	VSI Formula
	VariableSizeDimension1	I_OpActyInstanceAssembledComp	VariableSizeDimension1	Size 1
	VariableSizeDimension2	I_OpActyInstanceAssembledComp	VariableSizeDimension2	Size 2
	VariableSizeDimension3	I_OpActyInstanceAssembledComp	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	I_OpActyInstanceAssembledComp	VariableSizeDimensionUnit	Size unit
	VarblSizeCompFrmtdFormulaVal
	VariableSizeComponentQuantity	I_OpActyInstanceAssembledComp	VariableSizeComponentQuantity	VSI Quantity
	VariableSizeComponentUnit	I_OpActyInstanceAssembledComp	VariableSizeComponentUnit	VSI UoM
	MfgRefStrucBOMLeafAssgmtUUID	I_OpActyInstanceAssembledComp	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	I_OpActyInstanceAssembledComp	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	I_OpActyInstanceAssembledComp	MfgRefStrucItmDetIsContextual
	_OrderComponent	I_OpActyInstanceAssembledComp	_OrderComponent
	_BOMItemCategory	I_OpActyInstanceAssembledComp	_BOMItemCategory
	_OpActyNtwkInstance	I_OpActyInstanceAssembledComp	_OpActyNtwkInstance
	_OperationActivityInstance	I_OpActyInstanceAssembledComp	_OperationActivityInstance
	_Reservation	I_OpActyInstanceAssembledComp	_Reservation
	_MfgOrder	I_OpActyInstanceAssembledComp	_MfgOrder
	_Material	I_OpActyInstanceAssembledComp	_Material
	_Plant	I_OpActyInstanceAssembledComp	_Plant
	_StorageLocation	I_OpActyInstanceAssembledComp	_StorageLocation
	_OpActyCompInstceAssignment	I_OpActyInstanceAssembledComp	_OpActyCompInstceAssignment
	_OpActyBOOOpBOMIndivItmAssgmt	I_OpActyInstanceAssembledComp	_OpActyBOOOpBOMIndivItmAssgmt
	_MfgOrderCompAssemblyAggrgn	I_OpActyInstanceAssembledComp	_MfgOrderCompAssemblyAggrgn
	_BOMItmMfgRefStrucItmAssgmt	I_OpActyInstanceAssembledComp	_BOMItmMfgRefStrucItmAssgmt
	_MfgRefStrucItemWithDetails	I_OpActyInstanceAssembledComp	_MfgRefStrucItemWithDetails
	_MfgRefHierItemWithDetails	I_OpActyInstanceAssembledComp	_MfgRefHierItemWithDetails

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_OpActyInstanceAssembledComp.
-- 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: CMPEOAIAAMAT

CREATE VIEW C_OpActyInstanceAssembledComp AS
SELECT
  OpActyInstanceAssembledComp.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstanceAssembledComp.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyInstanceAssembledComp.Reservation AS Reservation,
  OpActyInstanceAssembledComp.ReservationItem AS ReservationItem,
  OpActyInstanceAssembledComp.RecordType AS RecordType,
  OpActyInstanceAssembledComp.Material AS Material,
  OpActyInstanceAssembledComp.StorageLocation AS StorageLocation,
  OpActyInstanceAssembledComp._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OpActyInstanceAssembledComp.MaterialBaseUnit AS MaterialBaseUnit,
  OpActyInstanceAssembledComp.RequiredQuantity AS RequiredQuantity,
  OpActyInstanceAssembledComp.MaterialComponentQuantity AS MaterialComponentQuantity,
  OpActyInstanceAssembledComp.ResvnItmWithdrawnQtyInBaseUnit AS ResvnItmWithdrawnQtyInBaseUnit,
  OpActyInstanceAssembledComp.EntryUnit AS EntryUnit,
  OpActyInstanceAssembledComp.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyInstanceAssembledComp.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyInstanceAssembledComp.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyInstanceAssembledComp.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyInstanceAssembledComp.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstanceAssembledComp.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OpActyInstanceAssembledComp.MfgOrderOperationText AS MfgOrderOperationText,
  OpActyInstanceAssembledComp.OperationActivity AS OperationActivity,
  OpActyInstanceAssembledComp.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstanceAssembledComp._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  OpActyInstanceAssembledComp.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstanceAssembledComp.BillOfOperationsGroup AS BillOfOperationsGroup,
  case when OpActyInstanceAssembledComp.MaterialComponentQuantity = 0 or OpActyInstanceAssembledComp.MaterialComponentQuantity is null then 0 AS RequiredQuantitythen1red,
  because overfilled when OpActyInstanceAssembledComp.MaterialComponentQuantity = OpActyInstanceAssembledComp.RequiredQuantity then 3 AS RequiredQuantitythen3greenelse2yellow,
  OpActyInstanceAssembledComp.MatlCompAssembleControl AS MatlCompAssembleControl,
  OpActyInstanceAssembledComp._MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  OpActyInstanceAssembledComp.SerialNumberProfile AS SerialNumberProfile,
  OpActyInstanceAssembledComp.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  OpActyInstanceAssembledComp.IsBatchManagementRequired AS IsBatchManagementRequired,
  OpActyInstanceAssembledComp.StockCheckMessageType AS StockCheckMessageType,
  OpActyInstanceAssembledComp.BillOfMaterialCategory AS BillOfMaterialCategory,
  OpActyInstanceAssembledComp.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyInstanceAssembledComp.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyInstanceAssembledComp.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyInstanceAssembledComp.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OpActyInstanceAssembledComp.BOMItem AS BOMItem,
  OpActyInstanceAssembledComp.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyInstanceAssembledComp.BOMItemCategory AS BOMItemCategory,
  OpActyInstanceAssembledComp.FormulaKey AS FormulaKey,
  OpActyInstanceAssembledComp.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyInstanceAssembledComp.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyInstanceAssembledComp.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyInstanceAssembledComp.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  OpActyInstanceAssembledComp.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyInstanceAssembledComp.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyInstanceAssembledComp.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyInstanceAssembledComp.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyInstanceAssembledComp.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyInstanceAssembledComp._OrderComponent AS _OrderComponent,
  OpActyInstanceAssembledComp._BOMItemCategory AS _BOMItemCategory,
  OpActyInstanceAssembledComp._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstanceAssembledComp._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstanceAssembledComp._Reservation AS _Reservation,
  OpActyInstanceAssembledComp._MfgOrder AS _MfgOrder,
  OpActyInstanceAssembledComp._Material AS _Material,
  OpActyInstanceAssembledComp._Plant AS _Plant,
  OpActyInstanceAssembledComp._StorageLocation AS _StorageLocation,
  OpActyInstanceAssembledComp._OpActyCompInstceAssignment AS _OpActyCompInstceAssignment,
  OpActyInstanceAssembledComp._OpActyBOOOpBOMIndivItmAssgmt AS _OpActyBOOOpBOMIndivItmAssgmt,
  OpActyInstanceAssembledComp._MfgOrderCompAssemblyAggrgn AS _MfgOrderCompAssemblyAggrgn,
  OpActyInstanceAssembledComp._BOMItmMfgRefStrucItmAssgmt AS _BOMItmMfgRefStrucItmAssgmt,
  OpActyInstanceAssembledComp._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyInstanceAssembledComp._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails
FROM I_OpActyInstanceAssembledComp AS OpActyInstanceAssembledComp
LEFT OUTER JOIN I_MfgBOMItemWithPhantomHier AS _MfgBOMItemWithPhantomHier ON BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory AND BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial AND BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant AND BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion AND InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr  -- association [0..1]
LEFT OUTER JOIN E_BillOfMaterialItemTP AS _BillOfMaterialItemExtension ON BillOfMaterialCategory = _BillOfMaterialItemExtension.BillOfMaterialCategory AND BillOfMaterialInternalID = _BillOfMaterialItemExtension.BillOfMaterial AND BOMItem = _BillOfMaterialItemExtension.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItemExtension.BOMItemInternalChangeCount  -- association [0..1]
;

Depth:

C_OpActyInstanceAssembledComp view

I_OpActyInstanceAssembledComp view