What is C_SFOAssldTraceableComponent in SAP S/4HANA?

C_SFOAssldTraceableComponent is a consumption CDS view in SAP S/4HANA. Shop floor order assld traceable comp It contains 60 fields.

Which tables does C_SFOAssldTraceableComponent read from?

C_SFOAssldTraceableComponent reads data from: P_SFOTraceableAssldComp.

What VDM layer is C_SFOAssldTraceableComponent?

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

C_SFOAssldTraceableComponent

DDL: C_SFOASSLDTRACEABLECOMPONENT Type: view_entity CONSUMPTION

60 Fields 1 Data Sources 6 Associations

Shop floor order assld traceable comp

C_SFOAssldTraceableComponent is a Consumption CDS View that provides data about "Shop floor order assld traceable comp" in SAP S/4HANA. It reads from 1 data source (P_SFOTraceableAssldComp) and exposes 60 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_SFOTraceableAssldComp	ass	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	I_Plant	_Plant	`$projection.Plant = _Plant.Plant`
[1..1]	I_OpActyNtwkInstance	_OpActyNtwkInstance	`$projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance`
[1..1]	I_OperationActivityInstance	_OperationActivityInstance	`$projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement`
[1..1]	I_AltvItmGrpMbrSubstnType	_AltvItmGrpMbrSubstnType	`$projection.AltvItmGrpMbrSubstnType = _AltvItmGrpMbrSubstnType.AltvItmGrpMbrSubstnType ----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`
[1..1]	E_ReservationDocumentItem	_ReservationDocumentItem	`$projection.Reservation = _ReservationDocumentItem.Reservation and $projection.ReservationItem = _ReservationDocumentItem.ReservationItem and $projection.RecordType = _ReservationDocumentItem.RecordType`

Annotations (12)

Name	Value	Level
Metadata.allowExtensions	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
UI.headerInfo.typeName	Traceable Component	view
UI.headerInfo.typeNamePlural	Traceable Components	view
UI.headerInfo.title.label	Traceable Component	view
UI.textArrangement	#TEXT_LAST	view
EndUserText.label	Shop floor order assld traceable comp	view

Fields (60)

Key	Field	Source Table	Source Field	Description
KEY	Reservation	P_SFOTraceableAssldComp	Reservation	Reservation
KEY	ReservationItem	P_SFOTraceableAssldComp	ReservationItem	Reservation Item
KEY	RecordType	P_SFOTraceableAssldComp	RecordType	Reservation Record Type
KEY	OpActyNtwkInstance	P_SFOTraceableAssldComp	OpActyNtwkInstance	Instance ID
KEY	OpActyNtwkElement	P_SFOTraceableAssldComp	OpActyNtwkElement	Element Number
KEY	ShopFloorItem	P_SFOTraceableAssldComp	ShopFloorItem	Serial.Mat. ID
	Batch
	Material
KEY	Plant	P_SFOTraceableAssldComp	Plant	Valuation Area
KEY	DgtlMockUpCharcsUUID	P_SFOTraceableAssldComp	DgtlMockUpCharcsUUID	DMU GUID
	BillOfMaterialItemNumber	P_SFOTraceableAssldComp	BillOfMaterialItemNumber	Item
	BillOfMaterialCategory	P_SFOTraceableAssldComp	BillOfMaterialCategory	BOM category
	BillOfMaterialInternalID	P_SFOTraceableAssldComp	BillOfMaterialInternalID
	BOMItem	P_SFOTraceableAssldComp	BOMItem
	BOMItemInternalChangeCount	P_SFOTraceableAssldComp	BOMItemInternalChangeCount	Counter
	BillOfMaterialVariant	P_SFOTraceableAssldComp	BillOfMaterialVariant	AlternativeBOM
	BillOfMaterialVersion	P_SFOTraceableAssldComp	BillOfMaterialVersion	BOM Version
	InheritedNodeNumberForBOMItem	P_SFOTraceableAssldComp	InheritedNodeNumberForBOMItem	Nodes
	InheritedNodeNumberVersionBOM	P_SFOTraceableAssldComp	InheritedNodeNumberVersionBOM	Item node
	AlternativeItemGroup	P_SFOTraceableAssldComp	AlternativeItemGroup	AltItemGroup
	AltvItmGrpMbrSubstnType	P_SFOTraceableAssldComp	AltvItmGrpMbrSubstnType
	AltvItmGrpMbrSubstnTypeName
	Assembly	P_SFOTraceableAssldComp	Assembly	Pegged Reqmt
	MaterialName
	RequiredQuantity
	RequiredQuantityInBaseUnit	P_SFOTraceableAssldComp	RequiredQuantityInBaseUnit
	MaterialComponentQuantity
	ResvnItmWithdrawnQtyInBaseUnit	P_SFOTraceableAssldComp	ResvnItmWithdrawnQtyInBaseUnit	Withdrawal Qty
	ResvnItmTotalWithdrawnQty	P_SFOTraceableAssldComp	ResvnItmTotalWithdrawnQty
	MaterialBaseUnit	P_SFOTraceableAssldComp	MaterialBaseUnit	Valuation Unit
	EntryUnit	P_SFOTraceableAssldComp	EntryUnit	Unit of Entry
	OrderInternalID	P_SFOTraceableAssldComp	OrderInternalID	Plan No.f.Oper.
	OrderOperationInternalID	P_SFOTraceableAssldComp	OrderOperationInternalID
	SerialNumber
	ManufacturerSerialNumber	P_SFOTraceableAssldComp	ManufacturerSerialNumber	Mnf.serial no.
	BatchBySupplier
	ReferenceDesignatorValue	P_SFOTraceableAssldComp	ReferenceDesignatorValue	Ref. Designator
	MaterialCompIsVariableSized
	FormulaKey	P_SFOTraceableAssldComp	FormulaKey	VSI Formula
	VariableSizeDimension1	P_SFOTraceableAssldComp	VariableSizeDimension1	Size 1
	VariableSizeDimension2	P_SFOTraceableAssldComp	VariableSizeDimension2	Size 2
	VariableSizeDimension3	P_SFOTraceableAssldComp	VariableSizeDimension3	Size 3
	VariableSizeDimensionUnit	P_SFOTraceableAssldComp	VariableSizeDimensionUnit	Size unit
	VarblSizeCompFrmtdFormulaVal
	VariableSizeComponentQuantity	P_SFOTraceableAssldComp	VariableSizeComponentQuantity	VSI Quantity
	VariableSizeComponentUnit	P_SFOTraceableAssldComp	VariableSizeComponentUnit	VSI UoM
	MfgRefStrucItmDetIsContextual	P_SFOTraceableAssldComp	MfgRefStrucItmDetIsContextual
	ManufacturingOrder	P_SFOTraceableAssldComp	ManufacturingOrder	Order
	MfgOrderOperationText	P_SFOTraceableAssldComp	OperationText	Description
	OperationActivityName
	MatlCompAssembleControl	P_SFOTraceableAssldComp	MatlCompAssembleControl
	BOMItemCategory	P_SFOTraceableAssldComp	BOMItemCategory	Item Category
	BillOfMaterialItemCategoryDesc
	EffectivityParameterVariant	P_SFOTraceableAssldComp	EffectivityParameterVariant
	MfgRefStrucBOMLeafAssgmtUUID
	MfgRefStructureItemDetailUUID	P_SFOTraceableAssldComp	MfgRefStructureItemDetailUUID
	_Material
	_Plant		_Plant
	_OpActyNtwkInstance		_OpActyNtwkInstance
	_OperationActivityInstance		_OperationActivityInstance

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_SFOAssldTraceableComponent.
-- 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_SFOAssldTraceableComponent AS
SELECT
  ass.Reservation AS Reservation,
  ass.ReservationItem AS ReservationItem,
  ass.RecordType AS RecordType,
  ass.OpActyNtwkInstance AS OpActyNtwkInstance,
  ass.OpActyNtwkElement AS OpActyNtwkElement,
  ass.ShopFloorItem AS ShopFloorItem,
  ass.Plant AS Plant,
  ass.DgtlMockUpCharcsUUID AS DgtlMockUpCharcsUUID,
  ass.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  ass.BillOfMaterialCategory AS BillOfMaterialCategory,
  ass.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  ass.BOMItem AS BOMItem,
  ass.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  ass.BillOfMaterialVariant AS BillOfMaterialVariant,
  ass.BillOfMaterialVersion AS BillOfMaterialVersion,
  ass.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  ass.InheritedNodeNumberVersionBOM AS InheritedNodeNumberVersionBOM,
  ass.AlternativeItemGroup AS AlternativeItemGroup,
  ass.AltvItmGrpMbrSubstnType AS AltvItmGrpMbrSubstnType,
  _AltvItmGrpMbrSubstnType._Text[1: Language=$session.system_language].AltvItmGrpMbrSubstnTypeName AS AltvItmGrpMbrSubstnTypeName,
  ass.Assembly AS Assembly,
  ass._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ass.RequiredQuantityInBaseUnit AS RequiredQuantityInBaseUnit,
  ass.ResvnItmWithdrawnQtyInBaseUnit AS ResvnItmWithdrawnQtyInBaseUnit,
  ass.ResvnItmTotalWithdrawnQty AS ResvnItmTotalWithdrawnQty,
  ass.MaterialBaseUnit AS MaterialBaseUnit,
  ass.EntryUnit AS EntryUnit,
  ass.OrderInternalID AS OrderInternalID,
  ass.OrderOperationInternalID AS OrderOperationInternalID,
  ass.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  cast(' ' as lichn preserving type ) AS BatchBySupplier,
  ass.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  ass.FormulaKey AS FormulaKey,
  ass.VariableSizeDimension1 AS VariableSizeDimension1,
  ass.VariableSizeDimension2 AS VariableSizeDimension2,
  ass.VariableSizeDimension3 AS VariableSizeDimension3,
  ass.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  cast('' as mpe_vsi_formatted_formula) AS VarblSizeCompFrmtdFormulaVal,
  ass.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  ass.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  ass.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  ass.ManufacturingOrder AS ManufacturingOrder,
  ass.OperationText AS MfgOrderOperationText,
  OpActyNtwkElement._OperationActivityText[1: Language=$session.system_language].OperationActivityName AS OperationActivityName,
  ass.MatlCompAssembleControl AS MatlCompAssembleControl,
  ass.BOMItemCategory AS BOMItemCategory,
  ass._BOMItemCategory._ItemCategoryT[1: Language=$session.system_language].BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  ass.EffectivityParameterVariant AS EffectivityParameterVariant,
  ass.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID
FROM P_SFOTraceableAssldComp AS ass
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [1..1]
LEFT OUTER JOIN I_AltvItmGrpMbrSubstnType AS _AltvItmGrpMbrSubstnType ON AltvItmGrpMbrSubstnType = _AltvItmGrpMbrSubstnType.AltvItmGrpMbrSubstnType  -- association [1..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]
LEFT OUTER JOIN E_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [1..1]
;

Depth:

C_SFOAssldTraceableComponent view_entity

P_SFOTraceableAssldComp view_entity