P_ProcgExecOpActySFIGrpPRTCns

DDL: P_PROCGEXECOPACTYSFIGRPPRTCNS SQL: PMPEOASFIGRPP Type: view CONSUMPTION Package: MPE_EXEC_SFI
46 Fields 1 Data Sources

PRT of SFI at OA Group

P_ProcgExecOpActySFIGrpPRTCns is a Consumption CDS View that provides data about "PRT of SFI at OA Group" in SAP S/4HANA. It reads from 1 data source (I_OpActySFIGroupPRTDetail) and exposes 46 fields with key fields OperationActivitySFIGroup, OpActySFIGroupPRTInternalID. Part of development package MPE_EXEC_SFI.

Data Sources (1)

SourceAliasJoin Type
I_OpActySFIGroupPRTDetail OpActySFIGroupPRTDetail from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOASFIGRPP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED 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
VDM.private true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY OperationActivitySFIGroup I_OpActySFIGroupPRTDetail OperationActivitySFIGroup
KEY OpActySFIGroupPRTInternalID I_OpActySFIGroupPRTDetail OpActySFIGroupPRTInternalID
RprstvMfgOrderInternalID I_OpActySFIGroupPRTDetail RprstvMfgOrderInternalID
RprstvProdnRsceToolInternalID I_OpActySFIGroupPRTDetail RprstvProdnRsceToolInternalID
RepresentativeShopFloorItem I_OpActySFIGroupPRTDetail RepresentativeShopFloorItem
RprstvOpActyNtwkInstance I_OpActySFIGroupPRTDetail RprstvOpActyNtwkInstance
RprstvOpActyNtwkElement I_OpActySFIGroupPRTDetail RprstvOpActyNtwkElement
NumberOfGroupedShopFloorItems I_OpActySFIGroupPRTDetail NumberOfGroupedShopFloorItems
WorkCenterInternalID I_OpActySFIGroupPRTDetail WorkCenterInternalID Work Center
PRTIsUsedAsTestEquipment I_OpActySFIGroupPRTDetail PRTIsUsedAsTestEquipment Test Equipment
ProductionResourceType I_OpActySFIGroupPRTDetail ProductionResourceType Object Type
ProductionResourceInternalID I_OpActySFIGroupPRTDetail ProductionResourceInternalID Object ID
ProdnRsceToolCategory I_OpActySFIGroupPRTDetail ProdnRsceToolCategory
Material I_OpActySFIGroupPRTDetail Material Vehicle Model
Equipment I_OpActySFIGroupPRTDetail Equipment Equipment check
DocumentType I_OpActySFIGroupPRTDetail DocumentType Order Type
DocumentInfoRecord I_OpActySFIGroupPRTDetail DocumentInfoRecord Document
DocumentVersion I_OpActySFIGroupPRTDetail DocumentVersion Docu. Version
DocumentPart I_OpActySFIGroupPRTDetail DocumentPart Document Part
MiscProductionResourceTool I_OpActySFIGroupPRTDetail MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit I_OpActySFIGroupPRTDetail ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty I_OpActySFIGroupPRTDetail ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit I_OpActySFIGroupPRTDetail PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty I_OpActySFIGroupPRTDetail PlannedTotalProdnRsceToolQty
OrderProdnRsceToolText I_OpActySFIGroupPRTDetail OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed I_OpActySFIGroupPRTDetail ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory I_OpActySFIGroupPRTDetail ManufacturingOrderCategory Order Category
ManufacturingOrderType I_OpActySFIGroupPRTDetail ManufacturingOrderType Order Type
ProductionPlant I_OpActySFIGroupPRTDetail ProductionPlant Prod plnt
ProdnRsceToolItemNumber I_OpActySFIGroupPRTDetail ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID I_OpActySFIGroupPRTDetail BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable I_OpActySFIGroupPRTDetail ShopFloorRtgPRTIsRegistrable
NumberOfActvEquipRegistrations SFIOpActyNrOfActvEquipRegn NumberOfActvEquipRegistrations
SerialNumber
UniqueItemIdentifier
_RprstvOpActyNtwkInstance I_OpActySFIGroupPRTDetail _RprstvOpActyNtwkInstance
_RprstvOpActyInstance I_OpActySFIGroupPRTDetail _RprstvOpActyInstance
_Equipment I_OpActySFIGroupPRTDetail _Equipment
_Material I_OpActySFIGroupPRTDetail _Material
_MfgOrderCategory I_OpActySFIGroupPRTDetail _MfgOrderCategory
_MfgOrderType I_OpActySFIGroupPRTDetail _MfgOrderType
_MiscProdnRsceToolText I_OpActySFIGroupPRTDetail _MiscProdnRsceToolText
_ProdnRsceToolCategory I_OpActySFIGroupPRTDetail _ProdnRsceToolCategory
_ProductionPlant I_OpActySFIGroupPRTDetail _ProductionPlant
_ProductionResourceType I_OpActySFIGroupPRTDetail _ProductionResourceType
_WorkCenterByInternalID I_OpActySFIGroupPRTDetail _WorkCenterByInternalID

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_ProcgExecOpActySFIGrpPRTCns.
-- 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: PMPEOASFIGRPP

CREATE VIEW P_ProcgExecOpActySFIGrpPRTCns AS
SELECT
  OpActySFIGroupPRTDetail.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  OpActySFIGroupPRTDetail.OpActySFIGroupPRTInternalID AS OpActySFIGroupPRTInternalID,
  OpActySFIGroupPRTDetail.RprstvMfgOrderInternalID AS RprstvMfgOrderInternalID,
  OpActySFIGroupPRTDetail.RprstvProdnRsceToolInternalID AS RprstvProdnRsceToolInternalID,
  OpActySFIGroupPRTDetail.RepresentativeShopFloorItem AS RepresentativeShopFloorItem,
  OpActySFIGroupPRTDetail.RprstvOpActyNtwkInstance AS RprstvOpActyNtwkInstance,
  OpActySFIGroupPRTDetail.RprstvOpActyNtwkElement AS RprstvOpActyNtwkElement,
  OpActySFIGroupPRTDetail.NumberOfGroupedShopFloorItems AS NumberOfGroupedShopFloorItems,
  OpActySFIGroupPRTDetail.WorkCenterInternalID AS WorkCenterInternalID,
  OpActySFIGroupPRTDetail.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  OpActySFIGroupPRTDetail.ProductionResourceType AS ProductionResourceType,
  OpActySFIGroupPRTDetail.ProductionResourceInternalID AS ProductionResourceInternalID,
  OpActySFIGroupPRTDetail.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  OpActySFIGroupPRTDetail.Material AS Material,
  OpActySFIGroupPRTDetail.Equipment AS Equipment,
  OpActySFIGroupPRTDetail.DocumentType AS DocumentType,
  OpActySFIGroupPRTDetail.DocumentInfoRecord AS DocumentInfoRecord,
  OpActySFIGroupPRTDetail.DocumentVersion AS DocumentVersion,
  OpActySFIGroupPRTDetail.DocumentPart AS DocumentPart,
  OpActySFIGroupPRTDetail.MiscProductionResourceTool AS MiscProductionResourceTool,
  OpActySFIGroupPRTDetail.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  OpActySFIGroupPRTDetail.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  OpActySFIGroupPRTDetail.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  OpActySFIGroupPRTDetail.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  OpActySFIGroupPRTDetail.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  OpActySFIGroupPRTDetail.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  OpActySFIGroupPRTDetail.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OpActySFIGroupPRTDetail.ManufacturingOrderType AS ManufacturingOrderType,
  OpActySFIGroupPRTDetail.ProductionPlant AS ProductionPlant,
  OpActySFIGroupPRTDetail.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  OpActySFIGroupPRTDetail.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  OpActySFIGroupPRTDetail.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  SFIOpActyNrOfActvEquipRegn.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  OpActySFIGroupPRTDetail._Equipment.SerialNumber AS SerialNumber,
  OpActySFIGroupPRTDetail._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  OpActySFIGroupPRTDetail._RprstvOpActyNtwkInstance AS _RprstvOpActyNtwkInstance,
  OpActySFIGroupPRTDetail._RprstvOpActyInstance AS _RprstvOpActyInstance,
  OpActySFIGroupPRTDetail._Equipment AS _Equipment,
  OpActySFIGroupPRTDetail._Material AS _Material,
  OpActySFIGroupPRTDetail._MfgOrderCategory AS _MfgOrderCategory,
  OpActySFIGroupPRTDetail._MfgOrderType AS _MfgOrderType,
  OpActySFIGroupPRTDetail._MiscProdnRsceToolText AS _MiscProdnRsceToolText,
  OpActySFIGroupPRTDetail._ProdnRsceToolCategory AS _ProdnRsceToolCategory,
  OpActySFIGroupPRTDetail._ProductionPlant AS _ProductionPlant,
  OpActySFIGroupPRTDetail._ProductionResourceType AS _ProductionResourceType,
  OpActySFIGroupPRTDetail._WorkCenterByInternalID AS _WorkCenterByInternalID
FROM I_OpActySFIGroupPRTDetail AS OpActySFIGroupPRTDetail
;

Learn More