P_SFIOperationActivityPRT

DDL: P_SFIOPERATIONACTIVITYPRT Type: view_entity CONSUMPTION
45 Fields 1 Data Sources 5 Associations

P_SFIOperationActivityPRT is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_SFIOperationActivityPRTUnion) and exposes 45 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_SFIOperationActivityPRTUnion SFIOperationActivityPRT from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_ProdnRsceToolCategory_2 _ProdnRsceToolCategory $projection.ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory
[1..1] I_ProductionResourceType _ProductionResourceType $projection.ProductionResourceType = _ProductionResourceType.ProductionResourceType
[0..1] I_Plant _Plant $projection.ProductionPlant = _Plant.Plant
[0..*] I_MiscProdnRsceToolText _MiscProdnRsceToolText $projection.ProductionResourceType = _MiscProdnRsceToolText.ProductionResourceType and $projection.ProductionResourceInternalID = _MiscProdnRsceToolText.ProductionResourceInternalID
[1..1] I_ShopFloorItem _ShopFloorItem $projection.ShopFloorItem = _ShopFloorItem.ShopFloorItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_SFIOperationActivityPRTUnion OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_SFIOperationActivityPRTUnion OpActyNtwkElement Element Number
KEY OrderInternalID P_SFIOperationActivityPRTUnion OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_SFIOperationActivityPRTUnion MfgOrderOpProdnRsceToolIntID
KEY Equipment P_SFIOperationActivityPRTUnion Equipment Equipment check
KEY ProductionResourceType P_SFIOperationActivityPRTUnion ProductionResourceType Object Type
KEY ProductionResourceInternalID P_SFIOperationActivityPRTUnion ProductionResourceInternalID Object ID
KEY ShopFloorItem P_SFIOperationActivityPRTUnion ShopFloorItem Serial.Mat. ID
PRTIsUsedAsTestEquipment P_SFIOperationActivityPRTUnion PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory P_SFIOperationActivityPRTUnion ProdnRsceToolCategory
Material P_SFIOperationActivityPRTUnion Material Vehicle Model
DocumentType P_SFIOperationActivityPRTUnion DocumentType Order Type
DocumentInfoRecord P_SFIOperationActivityPRTUnion DocumentInfoRecord Document
DocumentVersion P_SFIOperationActivityPRTUnion DocumentVersion Docu. Version
DocumentPart P_SFIOperationActivityPRTUnion DocumentPart Document Part
MiscProductionResourceTool P_SFIOperationActivityPRTUnion MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit P_SFIOperationActivityPRTUnion ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty P_SFIOperationActivityPRTUnion ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit P_SFIOperationActivityPRTUnion PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty P_SFIOperationActivityPRTUnion PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations P_SFIOperationActivityPRTUnion NumberOfActvEquipRegistrations
BaseUnit P_SFIOperationActivityPRTUnion BaseUnit Unit of Measure
RegisteredPRTQtyInBaseUnit P_SFIOperationActivityPRTUnion RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText P_SFIOperationActivityPRTUnion OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed P_SFIOperationActivityPRTUnion ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory P_SFIOperationActivityPRTUnion ManufacturingOrderCategory
ManufacturingOrderType P_SFIOperationActivityPRTUnion ManufacturingOrderType
ProductionPlant P_SFIOperationActivityPRTUnion ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_SFIOperationActivityPRTUnion ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID P_SFIOperationActivityPRTUnion BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable P_SFIOperationActivityPRTUnion ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl P_SFIOperationActivityPRTUnion PRTRegistrationControl Registration Type
_OpActyNtwkInstance
_OperationActivityInstance P_SFIOperationActivityPRTUnion _OperationActivityInstance
_OrdInternalBillOfOperations P_SFIOperationActivityPRTUnion _OrdInternalBillOfOperations
_ProductionResourceType _ProductionResourceType
_ProdnRsceToolCategory _ProdnRsceToolCategory
_MfgOrderCategory P_SFIOperationActivityPRTUnion _MfgOrderCategory
_MfgOrderType P_SFIOperationActivityPRTUnion _MfgOrderType
_ProductionPlant _Plant
_Material P_SFIOperationActivityPRTUnion _Material
_Equipment P_SFIOperationActivityPRTUnion _Equipment
_PRTRegistrationControl P_SFIOperationActivityPRTUnion _PRTRegistrationControl
_MiscProdnRsceToolText _MiscProdnRsceToolText
_ShopFloorItem _ShopFloorItem

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 P_SFIOperationActivityPRT.
-- 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 P_SFIOperationActivityPRT AS
SELECT
  SFIOperationActivityPRT.OpActyNtwkInstance AS OpActyNtwkInstance,
  SFIOperationActivityPRT.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOperationActivityPRT.OrderInternalID AS OrderInternalID,
  SFIOperationActivityPRT.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  SFIOperationActivityPRT.Equipment AS Equipment,
  SFIOperationActivityPRT.ProductionResourceType AS ProductionResourceType,
  SFIOperationActivityPRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  SFIOperationActivityPRT.ShopFloorItem AS ShopFloorItem,
  SFIOperationActivityPRT.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  SFIOperationActivityPRT.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  SFIOperationActivityPRT.Material AS Material,
  SFIOperationActivityPRT.DocumentType AS DocumentType,
  SFIOperationActivityPRT.DocumentInfoRecord AS DocumentInfoRecord,
  SFIOperationActivityPRT.DocumentVersion AS DocumentVersion,
  SFIOperationActivityPRT.DocumentPart AS DocumentPart,
  SFIOperationActivityPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  SFIOperationActivityPRT.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  SFIOperationActivityPRT.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  SFIOperationActivityPRT.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  SFIOperationActivityPRT.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  SFIOperationActivityPRT.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  SFIOperationActivityPRT.BaseUnit AS BaseUnit,
  SFIOperationActivityPRT.RegisteredPRTQtyInBaseUnit AS RegisteredPRTQtyInBaseUnit,
  SFIOperationActivityPRT.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  SFIOperationActivityPRT.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  SFIOperationActivityPRT.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  SFIOperationActivityPRT.ManufacturingOrderType AS ManufacturingOrderType,
  SFIOperationActivityPRT.ProductionPlant AS ProductionPlant,
  SFIOperationActivityPRT.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  SFIOperationActivityPRT.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  SFIOperationActivityPRT.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  SFIOperationActivityPRT.PRTRegistrationControl AS PRTRegistrationControl,
  SFIOperationActivityPRT._OperationActivityInstance AS _OperationActivityInstance,
  SFIOperationActivityPRT._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  SFIOperationActivityPRT._MfgOrderCategory AS _MfgOrderCategory,
  SFIOperationActivityPRT._MfgOrderType AS _MfgOrderType,
  SFIOperationActivityPRT._Material AS _Material,
  SFIOperationActivityPRT._Equipment AS _Equipment,
  SFIOperationActivityPRT._PRTRegistrationControl AS _PRTRegistrationControl
FROM P_SFIOperationActivityPRTUnion AS SFIOperationActivityPRT
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory ON ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ProductionPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MiscProdnRsceToolText AS _MiscProdnRsceToolText ON ProductionResourceType = _MiscProdnRsceToolText.ProductionResourceType AND ProductionResourceInternalID = _MiscProdnRsceToolText.ProductionResourceInternalID  -- association [0..*]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [1..1]
;

Learn More