I_MsrgPointPRTByInternalKey

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 I_MsrgPointPRTByInternalKey.
-- 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: IPPMSRGPRTIK

CREATE VIEW I_MsrgPointPRTByInternalKey AS
SELECT
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  cast(crvp_a.meas_point as pph_imrc_point preserving type) AS MeasuringPoint,
  PRT.ProductionResourceToolGroup1 AS ProductionResourceToolGroup1,
  PRT.ProductionResourceToolGroup2 AS ProductionResourceToolGroup2,
  PRT.ProductionResourceUsage AS ProductionResourceUsage,
  ProdnRsceToolControlProfile,
  PRT.ChangeNumber AS ChangeNumber,
  ProdnRsceToolStandardTextCode,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQtyCalcFmla,
  StartDateOffsetReferenceCode,
  EndDateOffsetReferenceCode,
  imptt.begru AS AuthorizationGroup,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser
FROM I_ProdnRsceToolMasterData AS PRT
INNER JOIN crvp_a ON /* join condition not captured in parsed metadata */
INNER JOIN imptt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MeasuringPoint AS _MeasuringPoint ON MeasuringPoint = _MeasuringPoint.MeasuringPoint  -- association [1..1]
LEFT OUTER JOIN I_MsrgPointProdnRsceTool AS _MsrgPointProdnRsceTool ON MeasuringPoint = _MsrgPointProdnRsceTool.MeasuringPoint  -- association [1..1]
;