What is C_OpActyInstcePlndComponent in SAP S/4HANA?

C_OpActyInstcePlndComponent is a consumption CDS view in SAP S/4HANA. Planned Components at OA Instance It contains 92 fields.

Which tables does C_OpActyInstcePlndComponent read from?

C_OpActyInstcePlndComponent reads data from: P_OpActyInstcePlndComponent.

What VDM layer is C_OpActyInstcePlndComponent?

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

C_OpActyInstcePlndComponent

DDL: C_OPACTYINSTCEPLNDCOMPONENT Type: view_entity CONSUMPTION

92 Fields 1 Data Sources 3 Associations 1 OData Services

Planned Components at OA Instance

C_OpActyInstcePlndComponent is a Consumption CDS View that provides data about "Planned Components at OA Instance" in SAP S/4HANA. It reads from 1 data source (P_OpActyInstcePlndComponent) and exposes 92 fields with key fields OpActyNtwkInstance, Plant. It has 3 associations to related views. It is exposed through 1 OData service (UI_OPACTYINSTANCEASSIGNMENT).

Data Sources (1)

Source	Alias	Join Type
P_OpActyInstcePlndComponent	OpActyComponentAssignment	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_MatlCompAssembleControl	_MatlCompAssembleControl	`$projection.MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl`
[0..1]	I_BillOfMaterialItemCategory	_BOMItemCategory	`$projection.BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory ----Extension`
[1..1]	E_ReservationDocumentItem	_ReservationDocumentItem	`$projection.Reservation = _ReservationDocumentItem.Reservation and $projection.ReservationItem = _ReservationDocumentItem.ReservationItem and $projection.RecordType = _ReservationDocumentItem.RecordType`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Planned Components at OA Instance	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_OPACTYINSTANCEASSIGNMENT	UI_OPACTYINSTANCEASSIGNMENT	V4	C1	NOT_RELEASED

Fields (92)

Key	Field	Source Table	Source Field	Description
KEY	OpActyNtwkInstance	P_OpActyInstcePlndComponent	OpActyNtwkInstance	Instance ID
	OpActyNtwkElement
	Reservation
	ReservationItem
	RecordType
	MaterialasMaterial
KEY	Plant	P_OpActyInstcePlndComponent	Plant	Valuation Area
	PlantName	_Plant	PlantName	Plant Name
	ManufacturingOrder	P_OpActyInstcePlndComponent	ManufacturingOrder	Order
	ProductionPlant	P_OpActyInstcePlndComponent	ProductionPlant	Prod plnt
	StorageLocation	P_OpActyInstcePlndComponent	StorageLocation	StorageLocation
	StorageLocationName	_StorageLocation	StorageLocationName	Storage Loc. Name
	MaterialName
	OpActyNtwkSegmentType	P_OpActyInstcePlndComponent	OpActyNtwkSegmentType
	AssemblySequenceNumber	P_OpActyInstcePlndComponent	AssemblySequenceNumber	Assembly Sequence
	BaseUnit	P_OpActyInstcePlndComponent	BaseUnit	Unit of Measure
	EntryUnit
	MfgOrderComponentUsageQuantity	P_OpActyInstcePlndComponent	MfgOrderComponentUsageQuantity
	RequiredQuantity	P_OpActyInstcePlndComponent	RequiredQuantity	Requirement qty
	SerialNumberProfile	P_OpActyInstcePlndComponent	SerialNumberProfile	SerialNoProfile
	SerialNumberIsRqdForAssembly	P_OpActyInstcePlndComponent	SerialNumberIsRqdForAssembly
	StockCheckMessageType	P_OpActyInstcePlndComponent	StockCheckMessageType
	IsBatchManagementRequired	P_OpActyInstcePlndComponent	IsBatchManagementRequired	Batch Mgmt Rqt(Plnt)
	MatlCompIsMarkedForBackflush	P_OpActyInstcePlndComponent	MatlCompIsMarkedForBackflush	Backflush
	IsBulkMaterialComponent	P_OpActyInstcePlndComponent	IsBulkMaterialComponent	Bulk material
	MatlCompDiscontinuationType	P_OpActyInstcePlndComponent	MatlCompDiscontinuationType
	MaterialCompIsVariableSized
	FormulaKey	P_OpActyInstcePlndComponent	FormulaKey	VSI Formula
	VariableSizeDimension1	P_OpActyInstcePlndComponent	VariableSizeDimension1	Size 1
	VariableSizeDimension2	P_OpActyInstcePlndComponent	VariableSizeDimension2	Size 2
	VariableSizeDimension3	P_OpActyInstcePlndComponent	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	P_OpActyInstcePlndComponent	VariableSizeDimensionUnit	Size unit
	VarblSizeCompFrmtdFormulaVal
	VariableSizeComponentQuantity	P_OpActyInstcePlndComponent	VariableSizeComponentQuantity	VSI Quantity
	VariableSizeComponentUnit	P_OpActyInstcePlndComponent	VariableSizeComponentUnit	VSI UoM
	MatlCompAssembleControl	P_OpActyInstcePlndComponent	MatlCompAssembleControl
	MatlCompAssembleControlName
	MaterialCompIsAlternativeItem	P_OpActyInstcePlndComponent	MaterialCompIsAlternativeItem
	AlternativeItemGroup	P_OpActyInstcePlndComponent	AlternativeItemGroup	AltItemGroup
	GoodsMovementIsAllowed	P_OpActyInstcePlndComponent	GoodsMovementIsAllowed	Mvt Allowed
	MaterialComponentIsMissing	P_OpActyInstcePlndComponent	MaterialComponentIsMissing
	ReservationIsFinallyIssued	P_OpActyInstcePlndComponent	ReservationIsFinallyIssued	Res Final Issue
	MatlCompInstceAssyIsRequired	P_OpActyInstcePlndComponent	MatlCompInstceAssyIsRequired	Instances Exist
	BOMItemCategory	P_OpActyInstcePlndComponent	BOMItemCategory	Item Category
	BillOfMaterialItemCategoryDesc
	MfgRefStrucItmRefDesignator	P_OpActyInstcePlndComponent	MfgRefStrucItmRefDesignator
	MfgRefStrucItmRefDsgntrName	P_OpActyInstcePlndComponent	MfgRefStrucItmRefDsgntrName	MRS Designator
	MfgBOMItemIsPhantomChild	P_OpActyInstcePlndComponent	MfgBOMItemIsPhantomChild
	EffectivityParameterVariant	P_OpActyInstcePlndComponent	EffectivityParameterVariant
	Assembly	P_OpActyInstcePlndComponent	Assembly	Pegged Reqmt
	RelatedReservation
	RelatedReservationItem	P_OpActyInstcePlndComponent	RelatedReservationItem
	RelatedRecordType	P_OpActyInstcePlndComponent	RelatedRecordType
	RelatedOpActyNtwkInstance	P_OpActyInstcePlndComponent	RelatedOpActyNtwkInstance
	RelatedOpActyNtwkElement	P_OpActyInstcePlndComponent	RelatedOpActyNtwkElement
	LeadingReservation	P_OpActyInstcePlndComponent	LeadingReservation
	LeadingReservationItem	P_OpActyInstcePlndComponent	LeadingReservationItem
	LeadingReservationRecordType	P_OpActyInstcePlndComponent	LeadingReservationRecordType
	LeadingOpActyNtwkInstance	P_OpActyInstcePlndComponent	LeadingOpActyNtwkInstance
	LeadingOpActyNtwkElement	P_OpActyInstcePlndComponent	LeadingOpActyNtwkElement
	BillOfMaterialCategory
	BillOfMaterialInternalID	P_OpActyInstcePlndComponent	BillOfMaterialInternalID
	BillOfMaterialVersion	P_OpActyInstcePlndComponent	BillOfMaterialVersion	BOM Version
	BillOfMaterialVariant	P_OpActyInstcePlndComponent	BillOfMaterialVariant	AlternativeBOM
	InheritedBOMItemNode	P_OpActyInstcePlndComponent	InheritedBOMItemNode
	BOMItem	P_OpActyInstcePlndComponent	BOMItem
	BOMItemInternalChangeCount	P_OpActyInstcePlndComponent	BOMItemInternalChangeCount	Counter
	BillOfOperationsType	P_OpActyInstcePlndComponent	BillOfOperationsType	Task List Type
	BillOfOperationsGroup	P_OpActyInstcePlndComponent	BillOfOperationsGroup	Group
	BOOOpBOMItemInternalID	P_OpActyInstcePlndComponent	BOOOpBOMItemInternalID	Allocation no.
	LogicalComponent	P_OpActyInstcePlndComponent	LogicalComponent	Logical Component
	MfgRefStrucBOMLeafAssgmtUUID	P_OpActyInstcePlndComponent	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	P_OpActyInstcePlndComponent	MfgRefStructureItemDetailUUID
	MfgRefStrucItmDetIsContextual	P_OpActyInstcePlndComponent	MfgRefStrucItmDetIsContextual
	OrderInternalID	P_OpActyInstcePlndComponent	OrderInternalID	Plan No.f.Oper.
	OrderOperationInternalID	P_OpActyInstcePlndComponent	OrderOperationInternalID
	_MatlCompAssembleControl		_MatlCompAssembleControl
	_MfgRefHierItemWithDetails	P_OpActyInstcePlndComponent	_MfgRefHierItemWithDetails
	_MfgRefStrucItemWithDetails	P_OpActyInstcePlndComponent	_MfgRefStrucItemWithDetails
	_OpActyNtwkInstance	P_OpActyInstcePlndComponent	_OpActyNtwkInstance
	_OperationActivityInstance	P_OpActyInstcePlndComponent	_OperationActivityInstance
	_Material	P_OpActyInstcePlndComponent	_Material
	_Reservation	P_OpActyInstcePlndComponent	_Reservation
	_ProductPlant	P_OpActyInstcePlndComponent	_ProductPlant
	_MfgOrder	P_OpActyInstcePlndComponent	_MfgOrder
	_MfgOrderOperation	P_OpActyInstcePlndComponent	_MfgOrderOperation
	_ProductionPlant	P_OpActyInstcePlndComponent	_ProductionPlant
	_Plant	P_OpActyInstcePlndComponent	_Plant
	_StorageLocation	P_OpActyInstcePlndComponent	_StorageLocation
	_BillOfMaterialItem	P_OpActyInstcePlndComponent	_BillOfMaterialItem
	_OpActyCompInstceAssignment	P_OpActyInstcePlndComponent	_OpActyCompInstceAssignment
	_OpActyNtwkInstanceBasic	P_OpActyInstcePlndComponent	_OpActyNtwkInstanceBasic

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_OpActyInstcePlndComponent.
-- 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.

CREATE VIEW C_OpActyInstcePlndComponent AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  OpActyComponentAssignment.ManufacturingOrder AS ManufacturingOrder,
  OpActyComponentAssignment.ProductionPlant AS ProductionPlant,
  OpActyComponentAssignment.StorageLocation AS StorageLocation,
  _StorageLocation.StorageLocationName AS StorageLocationName,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OpActyComponentAssignment.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyComponentAssignment.AssemblySequenceNumber AS AssemblySequenceNumber,
  OpActyComponentAssignment.BaseUnit AS BaseUnit,
  OpActyComponentAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  OpActyComponentAssignment.RequiredQuantity AS RequiredQuantity,
  OpActyComponentAssignment.SerialNumberProfile AS SerialNumberProfile,
  OpActyComponentAssignment.SerialNumberIsRqdForAssembly AS SerialNumberIsRqdForAssembly,
  OpActyComponentAssignment.StockCheckMessageType AS StockCheckMessageType,
  OpActyComponentAssignment.IsBatchManagementRequired AS IsBatchManagementRequired,
  OpActyComponentAssignment.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  OpActyComponentAssignment.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  OpActyComponentAssignment.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  OpActyComponentAssignment.FormulaKey AS FormulaKey,
  OpActyComponentAssignment.VariableSizeDimension1 AS VariableSizeDimension1,
  OpActyComponentAssignment.VariableSizeDimension2 AS VariableSizeDimension2,
  OpActyComponentAssignment.VariableSizeDimension3 AS VariableSizeDimension3,
  OpActyComponentAssignment.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  OpActyComponentAssignment.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  OpActyComponentAssignment.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyComponentAssignment.MatlCompAssembleControl AS MatlCompAssembleControl,
  _MatlCompAssembleControl._Text[1: Language=$session.system_language].MatlCompAssembleControlName AS MatlCompAssembleControlName,
  OpActyComponentAssignment.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  OpActyComponentAssignment.AlternativeItemGroup AS AlternativeItemGroup,
  OpActyComponentAssignment.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  OpActyComponentAssignment.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  OpActyComponentAssignment.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  OpActyComponentAssignment.BOMItemCategory AS BOMItemCategory,
  _BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  OpActyComponentAssignment.MfgRefStrucItmRefDesignator AS MfgRefStrucItmRefDesignator,
  OpActyComponentAssignment.MfgRefStrucItmRefDsgntrName AS MfgRefStrucItmRefDsgntrName,
  OpActyComponentAssignment.MfgBOMItemIsPhantomChild AS MfgBOMItemIsPhantomChild,
  OpActyComponentAssignment.EffectivityParameterVariant AS EffectivityParameterVariant,
  OpActyComponentAssignment.Assembly AS Assembly,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  OpActyComponentAssignment.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  OpActyComponentAssignment.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyComponentAssignment.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyComponentAssignment.InheritedBOMItemNode AS InheritedBOMItemNode,
  OpActyComponentAssignment.BOMItem AS BOMItem,
  OpActyComponentAssignment.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  OpActyComponentAssignment.BillOfOperationsType AS BillOfOperationsType,
  OpActyComponentAssignment.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyComponentAssignment.LogicalComponent AS LogicalComponent,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyComponentAssignment.OrderInternalID AS OrderInternalID,
  OpActyComponentAssignment.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyComponentAssignment._MfgRefHierItemWithDetails AS _MfgRefHierItemWithDetails,
  OpActyComponentAssignment._MfgRefStrucItemWithDetails AS _MfgRefStrucItemWithDetails,
  OpActyComponentAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyComponentAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OpActyComponentAssignment._Material AS _Material,
  OpActyComponentAssignment._Reservation AS _Reservation,
  OpActyComponentAssignment._ProductPlant AS _ProductPlant,
  OpActyComponentAssignment._MfgOrder AS _MfgOrder,
  OpActyComponentAssignment._MfgOrderOperation AS _MfgOrderOperation,
  OpActyComponentAssignment._ProductionPlant AS _ProductionPlant,
  OpActyComponentAssignment._Plant AS _Plant,
  OpActyComponentAssignment._StorageLocation AS _StorageLocation,
  OpActyComponentAssignment._BillOfMaterialItem AS _BillOfMaterialItem,
  OpActyComponentAssignment._OpActyCompInstceAssignment AS _OpActyCompInstceAssignment,
  OpActyComponentAssignment._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic
FROM P_OpActyInstcePlndComponent AS OpActyComponentAssignment
LEFT OUTER JOIN I_MatlCompAssembleControl AS _MatlCompAssembleControl ON MatlCompAssembleControl = _MatlCompAssembleControl.MatlCompAssembleControl  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [1..1]
;

Depth:

C_OpActyInstcePlndComponent view_entity

P_OpActyInstcePlndComponent view_entity