I_MiscPRTByInternalKey

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_MiscPRTByInternalKey.
-- 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: IPPMISCPRTIK

CREATE VIEW I_MiscPRTByInternalKey AS
SELECT
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  cast(crvs_a.sfhnr as pph_sfhnr preserving type) AS MiscProductionResourceTool,
  PRT.ProductionResourceToolGroup1 AS ProductionResourceToolGroup1,
  PRT.ProductionResourceToolGroup2 AS ProductionResourceToolGroup2,
  PRT.ProductionResourceUsage AS ProductionResourceUsage,
  ProdnRsceToolControlProfile,
  PRT.ChangeNumber AS ChangeNumber,
  ProdnRsceToolStandardTextCode,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQtyCalcFmla,
  StartDateOffsetReferenceCode,
  EndDateOffsetReferenceCode,
  EndDateOffsetDurnIsReferenced,
  StartDateOffstDurnIsReferenced,
  EndDteOffstRefCodeIsReferenced,
  StartDateOffsetRefCodeIsRefcd,
  PRTTotQtyCalcFmlaIsReferenced,
  PRTUsgeQtyCalcFmlaIsReferenced,
  PRTControlProfileIsReferenced,
  PRTStdTextCodeIsReferenced,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  PRT.MiscPRTAuthorizationGroup AS MiscPRTAuthorizationGroup
FROM I_ProdnRsceToolMasterData AS PRT
INNER JOIN crvs_a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MiscProdnRsceToolText AS _Text ON ProductionResourceType = _Text.ProductionResourceType AND ProductionResourceInternalID = _Text.ProductionResourceInternalID  -- association [0..*]
;