P_TrackToolUsageOATTUCLAIMED

DDL: P_TRACKTOOLUSAGEOATTUCLAIMED SQL: PTTUOAPRTCLAIM Type: view COMPOSITE Package: MPE_EXEC_TRACKABLE_TOOLS
6 Fields 3 Data Sources

CLAIMED PRTs in OA

P_TrackToolUsageOATTUCLAIMED is a Composite CDS View that provides data about "CLAIMED PRTs in OA" in SAP S/4HANA. It reads from 3 data sources (P_TrackToolUsageTTUCLAIMED, P_TrackToolUsageOAPRT, P_TrackToolUsageOAPRTASSGNED) and exposes 6 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Equipment. Part of development package MPE_EXEC_TRACKABLE_TOOLS.

Data Sources (3)

SourceAliasJoin Type
P_TrackToolUsageTTUCLAIMED clprt inner
P_TrackToolUsageOAPRT oaprt from
P_TrackToolUsageOAPRTASSGNED OAPRTASSGNED inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PTTUOAPRTCLAIM view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_TrackToolUsageOAPRTASSGNED OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_TrackToolUsageOAPRTASSGNED OpActyNtwkElement Element Number
KEY Equipment P_TrackToolUsageTTUCLAIMED Equipment Equipment check
Material P_TrackToolUsageOAPRT Material Vehicle Model
Equipmenthistorydocument P_TrackToolUsageTTUCLAIMED Equipmenthistorydocument
EquipmentClaimType P_TrackToolUsageTTUCLAIMED EquipmentClaimType

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_TrackToolUsageOATTUCLAIMED.
-- 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: PTTUOAPRTCLAIM

CREATE VIEW P_TrackToolUsageOATTUCLAIMED AS
SELECT
  OAPRTASSGNED.OpActyNtwkInstance AS OpActyNtwkInstance,
  OAPRTASSGNED.OpActyNtwkElement AS OpActyNtwkElement,
  clprt.Equipment AS Equipment,
  oaprt.Material AS Material,
  clprt.Equipmenthistorydocument AS Equipmenthistorydocument,
  clprt.EquipmentClaimType AS EquipmentClaimType
FROM P_TrackToolUsageOAPRT AS oaprt
INNER JOIN P_TrackToolUsageOAPRTASSGNED AS OAPRTASSGNED ON /* join condition not captured in parsed metadata */
INNER JOIN P_TrackToolUsageTTUCLAIMED AS clprt ON /* join condition not captured in parsed metadata */
;

Learn More