C_SFIOpActyPRTAssignment

DDL: C_SFIOPACTYPRTASSIGNMENT SQL: CMPESFIOAPRTA Type: view CONSUMPTION Package: MPE_EXEC_SFI
40 Fields 2 Data Sources 1 Associations

Shop Floor Item At Operation Activity

C_SFIOpActyPRTAssignment is a Consumption CDS View that provides data about "Shop Floor Item At Operation Activity" in SAP S/4HANA. It reads from 2 data sources (P_OperationActyPRTAssignment, I_ShopFloorItemStatus) and exposes 40 fields with key fields ShopFloorItem, OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID. It has 1 association to related views. Part of development package MPE_EXEC_SFI.

Data Sources (2)

SourceAliasJoin Type
P_OperationActyPRTAssignment OperationActyPRTAssignment from
I_ShopFloorItemStatus ShopFloorItemStatus inner

Associations (1)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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 (40)

KeyFieldSource TableSource FieldDescription
KEY ShopFloorItem I_ShopFloorItemStatus ShopFloorItem Serial.Mat. ID
KEY OpActyNtwkInstance P_OperationActyPRTAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OperationActyPRTAssignment OpActyNtwkElement Element Number
KEY OrderInternalID P_OperationActyPRTAssignment OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_OperationActyPRTAssignment MfgOrderOpProdnRsceToolIntID
KEY Equipment
ProductionResourceType P_OperationActyPRTAssignment ProductionResourceType Object Type
PRTIsUsedAsTestEquipment P_OperationActyPRTAssignment PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategoryExtCode
ProdnRsceToolCategory
ProdnRsceToolCategoryName
MiscProductionResourceTool P_OperationActyPRTAssignment MiscProductionResourceTool
ProdnRsceToolRegnIsAllowed P_OperationActyPRTAssignment ProdnRsceToolRegnIsAllowed Registrable
Material P_OperationActyPRTAssignment Material Vehicle Model
MaterialName
SerialNumber
UniqueItemIdentifier
DocumentType P_OperationActyPRTAssignment DocumentType Order Type
DocumentInfoRecord P_OperationActyPRTAssignment DocumentInfoRecord Document
DocumentVersion P_OperationActyPRTAssignment DocumentVersion Docu. Version
DocumentPart P_OperationActyPRTAssignment DocumentPart Document Part
PlannedProdnRsceToolQtyUnit P_OperationActyPRTAssignment ProdnRsceToolStdWorkQtyUnit Unit
PlannedTotalProdnRsceToolQty P_OperationActyPRTAssignment ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolStandardWorkQtythen1red
ManufacturingOrderCategory P_OperationActyPRTAssignment ManufacturingOrderCategory
ManufacturingOrderType P_OperationActyPRTAssignment ManufacturingOrderType
ProductionPlant P_OperationActyPRTAssignment ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_OperationActyPRTAssignment ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID P_OperationActyPRTAssignment BOOOperationPRTInternalID
_ShopFloorItem I_ShopFloorItemStatus _ShopFloorItem
_OpActyNtwkInstance P_OperationActyPRTAssignment _OpActyNtwkInstance
_OperationActivityInstance P_OperationActyPRTAssignment _OperationActivityInstance
_OrdInternalBillOfOperations P_OperationActyPRTAssignment _OrdInternalBillOfOperations
_ProductionResourceType P_OperationActyPRTAssignment _ProductionResourceType
_ProdnRsceToolCategory P_OperationActyPRTAssignment _ProdnRsceToolCategory
_Material P_OperationActyPRTAssignment _Material
_MfgOrderCategory P_OperationActyPRTAssignment _MfgOrderCategory
_MfgOrderType P_OperationActyPRTAssignment _MfgOrderType
_OpActyInstceEquipActvRegn _OpActyInstceEquipActvRegn
_ProductionPlant P_OperationActyPRTAssignment _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
  ShopFloorItemStatus.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.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  cast(OperationActyPRTAssignment._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryExtCode as mpe_fhmar preserving type) AS ProdnRsceToolCategoryExtCode,
  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.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OperationActyPRTAssignment.ManufacturingOrderType AS ManufacturingOrderType,
  OperationActyPRTAssignment.ProductionPlant AS ProductionPlant,
  OperationActyPRTAssignment.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  OperationActyPRTAssignment.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  ShopFloorItemStatus._ShopFloorItem AS _ShopFloorItem,
  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_OperationActyPRTAssignment AS OperationActyPRTAssignment
INNER JOIN I_ShopFloorItemStatus AS ShopFloorItemStatus ON /* join condition not captured in parsed metadata */
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..*]
;

Learn More