Which tables does C_SFIOpActyPRTAssignment read from?

C_SFIOpActyPRTAssignment reads data from: P_SFIOperationActivityPRT.

What VDM layer is C_SFIOpActyPRTAssignment?

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

C_SFIOpActyPRTAssignment

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

C_SFIOpActyPRTAssignment is a consumption CDS view in SAP S/4HANA. It contains 46 fields.

DDL: C_SFIOPACTYPRTASSIGNMENT SQL: CMPESFIOAPRTA Type: view CONSUMPTION

46 Fields 1 Data Sources 1 Associations

C_SFIOpActyPRTAssignment is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SFIOperationActivityPRT) and exposes 46 fields with key fields ShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
P_SFIOperationActivityPRT	OperationActyPRTAssignment	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_OpActyInstceEquipActvRegn	_OpActyInstceEquipActvRegn	$projection.ShopFloorItem = _OpActyInstceEquipActvRegn.ShopFloorItem and $projection.OpActyNtwkInstance = _OpActyInstceEquipActvRegn.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyInstceEquipActvRegn.OpActyNtwkElement and $projection.OrderInternalID = _OpActyInstceEquipActvRegn.OrderInternalID and $projection.MfgOrderOpProdnRsceToolIntID = _OpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID and ( $projection.ProdnRsceToolCategory <> 'E' or $projection.Equipment = _OpActyInstceEquipActvRegn.Equipment )

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	CMPESFIOAPRTA	view
AccessControl.authorizationCheck	#CHECK	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

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	ShopFloorItem	P_SFIOperationActivityPRT	ShopFloorItem	Serial.Mat. ID
KEY	OpActyNtwkInstance	P_SFIOperationActivityPRT	OpActyNtwkInstance	Instance ID
KEY	OpActyNtwkElement	P_SFIOperationActivityPRT	OpActyNtwkElement	Element Number
KEY	OrderInternalID	P_SFIOperationActivityPRT	OrderInternalID	Plan No.f.Oper.
KEY	MfgOrderOpProdnRsceToolIntID	P_SFIOperationActivityPRT	MfgOrderOpProdnRsceToolIntID
KEY	Equipment
KEY	ProductionResourceType	P_SFIOperationActivityPRT	ProductionResourceType	Object Type
KEY	ProductionResourceInternalID	P_SFIOperationActivityPRT	ProductionResourceInternalID	Object ID
	PRTIsUsedAsTestEquipment	P_SFIOperationActivityPRT	PRTIsUsedAsTestEquipment	Test Equipment
	ProdnRsceToolCategory
	ProdnRsceToolCategoryName
	MiscProductionResourceTool	P_SFIOperationActivityPRT	MiscProductionResourceTool
	ProdnRsceToolRegnIsAllowed	P_SFIOperationActivityPRT	ProdnRsceToolRegnIsAllowed	Registrable
	Material	P_SFIOperationActivityPRT	Material	Vehicle Model
	MaterialName
	SerialNumber
	UniqueItemIdentifier
	DocumentType	P_SFIOperationActivityPRT	DocumentType	Order Type
	DocumentInfoRecord	P_SFIOperationActivityPRT	DocumentInfoRecord	Document
	DocumentVersion	P_SFIOperationActivityPRT	DocumentVersion	Docu. Version
	DocumentPart	P_SFIOperationActivityPRT	DocumentPart	Document Part
	PlannedProdnRsceToolQtyUnit	P_SFIOperationActivityPRT	ProdnRsceToolStdWorkQtyUnit	Unit
	PlannedTotalProdnRsceToolQty	P_SFIOperationActivityPRT	ProdnRsceToolStandardWorkQty	Quantity
	ProdnRsceToolStandardWorkQtythen1red
	NumberOfActvEquipRegistrations	P_SFIOperationActivityPRT	NumberOfActvEquipRegistrations
	BaseUnit	P_SFIOperationActivityPRT	BaseUnit	Unit of Measure
	RegisteredPRTQtyInBaseUnit
	ManufacturingOrderCategory	P_SFIOperationActivityPRT	ManufacturingOrderCategory
	ManufacturingOrderType	P_SFIOperationActivityPRT	ManufacturingOrderType
	ProductionPlant	P_SFIOperationActivityPRT	ProductionPlant	Prod plnt
	ProdnRsceToolItemNumber	P_SFIOperationActivityPRT	ProdnRsceToolItemNumber	Item Number
	MfgOrderOpPRTItemNumber
	BOOOperationPRTInternalID	P_SFIOperationActivityPRT	BOOOperationPRTInternalID
	PRTRegistrationControl	P_SFIOperationActivityPRT	PRTRegistrationControl	Registration Type
	PRTRegistrationControlName
	_ShopFloorItem
	_OpActyNtwkInstance	P_SFIOperationActivityPRT	_OpActyNtwkInstance
	_OperationActivityInstance	P_SFIOperationActivityPRT	_OperationActivityInstance
	_OrdInternalBillOfOperations	P_SFIOperationActivityPRT	_OrdInternalBillOfOperations
	_ProductionResourceType	P_SFIOperationActivityPRT	_ProductionResourceType
	_ProdnRsceToolCategory	P_SFIOperationActivityPRT	_ProdnRsceToolCategory
	_Material	P_SFIOperationActivityPRT	_Material
	_MfgOrderCategory	P_SFIOperationActivityPRT	_MfgOrderCategory
	_MfgOrderType	P_SFIOperationActivityPRT	_MfgOrderType
	_OpActyInstceEquipActvRegn		_OpActyInstceEquipActvRegn
	_ProductionPlant	P_SFIOperationActivityPRT	_ProductionPlant

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_SFIOpActyPRTAssignment.
-- 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: CMPESFIOAPRTA

CREATE VIEW C_SFIOpActyPRTAssignment AS
SELECT
  OperationActyPRTAssignment.ShopFloorItem AS ShopFloorItem,
  OperationActyPRTAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPRTAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPRTAssignment.OrderInternalID AS OrderInternalID,
  OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  cast(coalesce(OperationActyPRTAssignment.Equipment, '') as equnr) AS Equipment,
  OperationActyPRTAssignment.ProductionResourceType AS ProductionResourceType,
  OperationActyPRTAssignment.ProductionResourceInternalID AS ProductionResourceInternalID,
  OperationActyPRTAssignment.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  cast(OperationActyPRTAssignment.ProdnRsceToolCategory as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  OperationActyPRTAssignment._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  OperationActyPRTAssignment.MiscProductionResourceTool AS MiscProductionResourceTool,
  OperationActyPRTAssignment.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  OperationActyPRTAssignment.Material AS Material,
  OperationActyPRTAssignment._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OperationActyPRTAssignment._Equipment.SerialNumber AS SerialNumber,
  OperationActyPRTAssignment._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  OperationActyPRTAssignment.DocumentType AS DocumentType,
  OperationActyPRTAssignment.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPRTAssignment.DocumentVersion AS DocumentVersion,
  OperationActyPRTAssignment.DocumentPart AS DocumentPart,
  OperationActyPRTAssignment.ProdnRsceToolStdWorkQtyUnit AS PlannedProdnRsceToolQtyUnit,
  OperationActyPRTAssignment.ProdnRsceToolStandardWorkQty AS PlannedTotalProdnRsceToolQty,
  OperationActyPRTAssignment.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  OperationActyPRTAssignment.BaseUnit AS BaseUnit,
  cast(OperationActyPRTAssignment.RegisteredPRTQtyInBaseUnit as mpe_prt_registered_qty preserving type ) AS RegisteredPRTQtyInBaseUnit,
  OperationActyPRTAssignment.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OperationActyPRTAssignment.ManufacturingOrderType AS ManufacturingOrderType,
  OperationActyPRTAssignment.ProductionPlant AS ProductionPlant,
  OperationActyPRTAssignment.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  cast(OperationActyPRTAssignment.ProdnRsceToolItemNumber as mpe_psnfh_char) AS MfgOrderOpPRTItemNumber,
  OperationActyPRTAssignment.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  OperationActyPRTAssignment.PRTRegistrationControl AS PRTRegistrationControl,
  OperationActyPRTAssignment._PRTRegistrationControl._PRTRegistrationControlText[1: Language=$session.system_language].PRTRegistrationControlName AS PRTRegistrationControlName,
  OperationActyPRTAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OperationActyPRTAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPRTAssignment._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OperationActyPRTAssignment._ProductionResourceType AS _ProductionResourceType,
  OperationActyPRTAssignment._ProdnRsceToolCategory AS _ProdnRsceToolCategory,
  OperationActyPRTAssignment._Material AS _Material,
  OperationActyPRTAssignment._MfgOrderCategory AS _MfgOrderCategory,
  OperationActyPRTAssignment._MfgOrderType AS _MfgOrderType,
  OperationActyPRTAssignment._ProductionPlant AS _ProductionPlant
FROM P_SFIOperationActivityPRT AS OperationActyPRTAssignment
LEFT OUTER JOIN I_OpActyInstceEquipActvRegn AS _OpActyInstceEquipActvRegn ON ShopFloorItem = _OpActyInstceEquipActvRegn.ShopFloorItem AND OpActyNtwkInstance = _OpActyInstceEquipActvRegn.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstceEquipActvRegn.OpActyNtwkElement AND OrderInternalID = _OpActyInstceEquipActvRegn.OrderInternalID AND MfgOrderOpProdnRsceToolIntID = _OpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID AND ( ProdnRsceToolCategory <> 'E' OR Equipment = _OpActyInstceEquipActvRegn.Equipment )  -- association [0..*]
;

Depth:

C_SFIOpActyPRTAssignment view

P_SFIOperationActivityPRT view_entity