What is I_OpActySFIGroupCompDetail in SAP S/4HANA?

I_OpActySFIGroupCompDetail is a composite CDS view in SAP S/4HANA. Detail of a component of a group of SFI at OA It contains 65 fields.

Which tables does I_OpActySFIGroupCompDetail read from?

I_OpActySFIGroupCompDetail reads data from: I_EAMMaterialItemCategory, I_OpActySFIGroupComp, I_OpActySFIGroupDetail, I_MfgOrderOperationComponent, I_OpActyComponentAssignment and more.

What VDM layer is I_OpActySFIGroupCompDetail?

I_OpActySFIGroupCompDetail is classified as a Composite view that combines data from multiple basic views.

I_OpActySFIGroupCompDetail

DDL: I_OPACTYSFIGROUPCOMPDETAIL SQL: IMPEOASFIGRPCDET Type: view COMPOSITE

65 Fields 6 Data Sources

Detail of a component of a group of SFI at OA

I_OpActySFIGroupCompDetail is a Composite CDS View that provides data about "Detail of a component of a group of SFI at OA" in SAP S/4HANA. It reads from 6 data sources and exposes 65 fields with key fields OperationActivitySFIGroup, OpActySFIGrpCompInternalID.

Data Sources (6)

Source	Alias	Join Type
I_EAMMaterialItemCategory	MaterialItemCategory	inner
I_OpActySFIGroupComp	OpActySFIGroupComp	from
I_OpActySFIGroupDetail	OpActySFIGroupDetail	inner
I_MfgOrderOperationComponent	RprstvMfgOrderOperComponent	inner
I_OpActyComponentAssignment	RprstvOpActyCompAssignment	inner
I_OrderOperation	RprstvOrderOperation	inner

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	IMPEOASFIGRPCDET	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	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.representativeKey	OperationActivitySFIGroup	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Detail of a component of a group of SFI at OA	view

Fields (65)

Key	Field	Source Table	Source Field	Description
KEY	OperationActivitySFIGroup	I_OpActySFIGroupComp	OperationActivitySFIGroup	Serial Number Group
KEY	OpActySFIGrpCompInternalID	I_OpActySFIGroupComp	OpActySFIGrpCompInternalID	Item no.
	RepresentativeReservation	I_OpActySFIGroupComp	RepresentativeReservation	Reservation
	RepresentativeReservationItem	I_OpActySFIGroupComp	RepresentativeReservationItem	Item no.
	RprstvReservationRecordType	I_OpActySFIGroupComp	RprstvReservationRecordType	Record type
	RprstvOpActyNtwkInstance	I_OpActySFIGroupDetail	RprstvOpActyNtwkInstance
	RprstvOpActyNtwkElement	I_OpActySFIGroupDetail	RprstvOpActyNtwkElement
	NumberOfGroupedShopFloorItems	I_OpActySFIGroupDetail	NumberOfGroupedShopFloorItems
	WorkCenterInternalID	I_OpActySFIGroupDetail	WorkCenterInternalID	Work Center
	Material	I_MfgOrderOperationComponent	Material	Vehicle Model
	Plant	I_MfgOrderOperationComponent	Plant	Valuation Area
	StorageLocation	I_MfgOrderOperationComponent	StorageLocation	StorageLocation
	ProductionPlant	I_MfgOrderOperationComponent	ProductionPlant	Prod plnt
	AssemblySequenceNumber	I_OpActyComponentAssignment	AssemblySequenceNumber	Assembly Sequence
	BaseUnit	I_MfgOrderOperationComponent	BaseUnit	Unit of Measure
	MfgOrderComponentUsageQuantity	I_OpActyComponentAssignment	MfgOrderComponentUsageQuantity	Usage qty - UoM
	MaterialComponentQuantity
	QuantityInEntryUnit
	DebitCreditCode	I_MfgOrderOperationComponent	DebitCreditCode	Single-Character Flag
	IsBulkMaterialComponent	I_MfgOrderOperationComponent	IsBulkMaterialComponent	Bulk material
	MatlCompIsMarkedForBackflush	I_MfgOrderOperationComponent	MatlCompIsMarkedForBackflush	Backflush
	GoodsMovementIsAllowed	I_MfgOrderOperationComponent	GoodsMovementIsAllowed	Mvt Allowed
	MaterialComponentIsMissing	I_MfgOrderOperationComponent	MaterialComponentIsMissing	Missing Part
	ReservationIsFinallyIssued	I_MfgOrderOperationComponent	ReservationIsFinallyIssued	Res Final Issue
	MatlCompDiscontinuationType	I_MfgOrderOperationComponent	MatlCompDiscontinuationType	Share of scrap
	Batch	I_MfgOrderOperationComponent	Batch	Lot No.
	VariableSizeItemUnit	I_MfgOrderOperationComponent	VariableSizeItemUnit	VSI unit
	FormulaKey	I_MfgOrderOperationComponent	FormulaKey	VSI Formula
	VariableSizeDimension1	I_MfgOrderOperationComponent	VariableSizeDimension1	Size 1
	VariableSizeDimension2	I_MfgOrderOperationComponent	VariableSizeDimension2	Size 2
	VariableSizeDimension3	I_MfgOrderOperationComponent	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	I_MfgOrderOperationComponent	VariableSizeDimensionUnit	Size unit
	VariableSizeComponentQuantity	I_MfgOrderOperationComponent	VariableSizeComponentQuantity	VSI Quantity
	VariableSizeComponentUnit	I_MfgOrderOperationComponent	VariableSizeComponentUnit	VSI UoM
	RelatedReservationasRelatedReservation
	RelatedReservationItem	I_OpActyComponentAssignment	RelatedReservationItem	Item no.
	RelatedRecordType	I_OpActyComponentAssignment	RelatedRecordType	Record type
	RelatedOpActyNtwkInstance	I_OpActyComponentAssignment	RelatedOpActyNtwkInstance	Instance ID
	RelatedOpActyNtwkElement	I_OpActyComponentAssignment	RelatedOpActyNtwkElement	Element Number
	LeadingReservation	I_OpActyComponentAssignment	LeadingReservation	Reservation
	LeadingReservationItem	I_OpActyComponentAssignment	LeadingReservationItem	Item no.
	LeadingReservationRecordType	I_OpActyComponentAssignment	LeadingReservationRecordType	Record type
	LeadingOpActyNtwkInstance	I_OpActyComponentAssignment	LeadingOpActyNtwkInstance	Instance ID
	LeadingOpActyNtwkElement	I_OpActyComponentAssignment	LeadingOpActyNtwkElement	Element Number
	BillOfMaterial
	BOMItem	I_MfgOrderOperationComponent	BOMItem
	BOMItemInternalChangeCount	I_MfgOrderOperationComponent	BOMItemInternalChangeCount	Counter
	BillOfMaterialInternalID
	BOMItemCategory	I_MfgOrderOperationComponent	BOMItemCategory	Item Category
	BOOOpBOMItemInternalID	I_OpActyComponentAssignment	BOOOpBOMItemInternalID	Allocation no.
	LogicalComponent	I_OpActyComponentAssignment	LogicalComponent	Logical Component
	MfgRefStrucBOMLeafAssgmtUUID	I_OpActyComponentAssignment	MfgRefStrucBOMLeafAssgmtUUID	Leaf Assignment UUID
	MfgRefStructureItemDetailUUID	I_OpActyComponentAssignment	MfgRefStructureItemDetailUUID	MRS Item UUID
	MfgRefStrucItmDetIsContextual	I_OpActyComponentAssignment	MfgRefStrucItmDetIsContextual	Contextual
	MatlCompInstceAssyIsRequired	I_OpActyComponentAssignment	MatlCompInstceAssyIsRequired	Instances Exist
	ItemCatRequiresMaterialEntry	I_EAMMaterialItemCategory	ItemCatRequiresMaterialEntry	Material entry
	_OperationActivitySFIGroup	I_OpActySFIGroupComp	_OperationActivitySFIGroup
	_RprstvOpActyNtwkInstance	I_OpActySFIGroupDetail	_RprstvOpActyNtwkInstance
	_RprstvOpActyInstance	I_OpActySFIGroupDetail	_RprstvOpActyInstance
	_Material	I_MfgOrderOperationComponent	_Material
	_Plant	I_MfgOrderOperationComponent	_Plant
	_StorageLocation	I_MfgOrderOperationComponent	_StorageLocation
	_ProductionPlant	I_MfgOrderOperationComponent	_ProductionPlant
	_WorkCenterByInternalID	I_OpActySFIGroupDetail	_WorkCenterByInternalID
	_MatlCompDiscontinuationType	I_MfgOrderOperationComponent	_MatlCompDiscontinuationType

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 I_OpActySFIGroupCompDetail.
-- 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: IMPEOASFIGRPCDET

CREATE VIEW I_OpActySFIGroupCompDetail AS
SELECT
  OpActySFIGroupComp.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  OpActySFIGroupComp.OpActySFIGrpCompInternalID AS OpActySFIGrpCompInternalID,
  OpActySFIGroupComp.RepresentativeReservation AS RepresentativeReservation,
  OpActySFIGroupComp.RepresentativeReservationItem AS RepresentativeReservationItem,
  OpActySFIGroupComp.RprstvReservationRecordType AS RprstvReservationRecordType,
  OpActySFIGroupDetail.RprstvOpActyNtwkInstance AS RprstvOpActyNtwkInstance,
  OpActySFIGroupDetail.RprstvOpActyNtwkElement AS RprstvOpActyNtwkElement,
  OpActySFIGroupDetail.NumberOfGroupedShopFloorItems AS NumberOfGroupedShopFloorItems,
  OpActySFIGroupDetail.WorkCenterInternalID AS WorkCenterInternalID,
  RprstvMfgOrderOperComponent.Material AS Material,
  RprstvMfgOrderOperComponent.Plant AS Plant,
  RprstvMfgOrderOperComponent.StorageLocation AS StorageLocation,
  RprstvMfgOrderOperComponent.ProductionPlant AS ProductionPlant,
  RprstvOpActyCompAssignment.AssemblySequenceNumber AS AssemblySequenceNumber,
  RprstvMfgOrderOperComponent.BaseUnit AS BaseUnit,
  RprstvOpActyCompAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  RprstvMfgOrderOperComponent.DebitCreditCode AS DebitCreditCode,
  RprstvMfgOrderOperComponent.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  RprstvMfgOrderOperComponent.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  RprstvMfgOrderOperComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  RprstvMfgOrderOperComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  RprstvMfgOrderOperComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  RprstvMfgOrderOperComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  RprstvMfgOrderOperComponent.Batch AS Batch,
  RprstvMfgOrderOperComponent.VariableSizeItemUnit AS VariableSizeItemUnit,
  RprstvMfgOrderOperComponent.FormulaKey AS FormulaKey,
  RprstvMfgOrderOperComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  RprstvMfgOrderOperComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  RprstvMfgOrderOperComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  RprstvMfgOrderOperComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  RprstvMfgOrderOperComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  RprstvMfgOrderOperComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  RprstvOpActyCompAssignment.RelatedReservationItem AS RelatedReservationItem,
  RprstvOpActyCompAssignment.RelatedRecordType AS RelatedRecordType,
  RprstvOpActyCompAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  RprstvOpActyCompAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  RprstvOpActyCompAssignment.LeadingReservation AS LeadingReservation,
  RprstvOpActyCompAssignment.LeadingReservationItem AS LeadingReservationItem,
  RprstvOpActyCompAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  RprstvOpActyCompAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  RprstvOpActyCompAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  cast(RprstvMfgOrderOperComponent.BillOfMaterial as mpe_exec_stnum preserving type) AS BillOfMaterial,
  RprstvMfgOrderOperComponent.BOMItem AS BOMItem,
  RprstvMfgOrderOperComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  cast(RprstvMfgOrderOperComponent.BillOfMaterialInternalID as mpe_exec_stnum preserving type) AS BillOfMaterialInternalID,
  RprstvMfgOrderOperComponent.BOMItemCategory AS BOMItemCategory,
  RprstvOpActyCompAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  RprstvOpActyCompAssignment.LogicalComponent AS LogicalComponent,
  RprstvOpActyCompAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  RprstvOpActyCompAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  RprstvOpActyCompAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  RprstvOpActyCompAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  MaterialItemCategory.ItemCatRequiresMaterialEntry AS ItemCatRequiresMaterialEntry,
  OpActySFIGroupComp._OperationActivitySFIGroup AS _OperationActivitySFIGroup,
  OpActySFIGroupDetail._RprstvOpActyNtwkInstance AS _RprstvOpActyNtwkInstance,
  OpActySFIGroupDetail._RprstvOpActyInstance AS _RprstvOpActyInstance,
  RprstvMfgOrderOperComponent._Material AS _Material,
  RprstvMfgOrderOperComponent._Plant AS _Plant,
  RprstvMfgOrderOperComponent._StorageLocation AS _StorageLocation,
  RprstvMfgOrderOperComponent._ProductionPlant AS _ProductionPlant,
  OpActySFIGroupDetail._WorkCenterByInternalID AS _WorkCenterByInternalID,
  RprstvMfgOrderOperComponent._MatlCompDiscontinuationType AS _MatlCompDiscontinuationType
FROM I_OpActySFIGroupComp AS OpActySFIGroupComp
INNER JOIN I_OpActySFIGroupDetail AS OpActySFIGroupDetail ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyComponentAssignment AS RprstvOpActyCompAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderOperationComponent AS RprstvMfgOrderOperComponent ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS RprstvOrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_EAMMaterialItemCategory AS MaterialItemCategory ON /* join condition not captured in parsed metadata */
;

Depth:

I_OpActySFIGroupCompDetail view

P_ProcgExecOpActySFIGrpCompCns view