I_MiscProdnRsceToolWorkList

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_MiscProdnRsceToolWorkList.
-- 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 I_MiscProdnRsceToolWorkList AS
SELECT
  cast(PRT.objty as productionresourcetype preserving type) AS ProductionResourceType,
  cast(PRT.objid as pph_fhmid preserving type) AS ProductionResourceInternalID,
  cast(PRT.fhmar as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  cast(crvs_a.sfhnr as pph_sfhnr preserving type) AS MiscProductionResourceTool,
  PRT.stowk AS ProdnRsceToolPlntLoc,
  PRT.status AS ProductionResourceToolStatus,
  PRT.planv AS ProductionResourceUsage,
  PRT.baseh AS ProdnRsceToolBaseUnit,
  PRT.loekz AS ProdnRsceToolIsDeleted,
  PRT.fgru1 AS ProductionResourceToolGroup1,
  PRT.fgru2 AS ProductionResourceToolGroup2,
  PRT.stort AS ProductionResourceToolLocation,
  PRT.steuf AS ProdnRsceToolControlProfile,
  PRT.ktsch AS ProdnRsceToolStandardTextCode,
  PRT.mgform AS ProdnRsceToolTotQtyCalcFormula,
  PRT.ewform AS ProdnRsceToolUsageQtyCalcFmla,
  PRT.brgru AS MiscPRTAuthorizationGroup
FROM crfh 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..*]
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory_3 ON ProdnRsceToolCategory = _ProdnRsceToolCategory_3.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductionResourceUsage AS _ProductionResourceUsage ON ProductionResourceUsage = _ProductionResourceUsage.ProductionResourceUsage  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolGroup AS _ProdnRsceToolGroup1 ON ProductionResourceToolGroup1 = _ProdnRsceToolGroup1.ProductionResourceToolGroup  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolGroup AS _ProdnRsceToolGroup2 ON ProductionResourceToolGroup2 = _ProdnRsceToolGroup2.ProductionResourceToolGroup  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile ON ProdnRsceToolControlProfile = _ProdnRsceToolControlProfile.ProdnRsceToolControlProfile  -- association [0..1]
LEFT OUTER JOIN I_ProdnRsceToolStandardText AS _ProdnRsceToolStandardText ON ProdnRsceToolStandardTextCode = _ProdnRsceToolStandardText.ProdnRsceToolStandardTextCode  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolQtyCalcFormula AS _ProdnRsceToolTotQtyCalcFmla ON ProdnRsceToolTotQtyCalcFormula = _ProdnRsceToolTotQtyCalcFmla.ProdnRsceToolQtyCalcFormula  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolQtyCalcFormula AS _ProdnRsceToolUsageQtyCalcFmla ON ProdnRsceToolUsageQtyCalcFmla = _ProdnRsceToolUsageQtyCalcFmla.ProdnRsceToolQtyCalcFormula  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolGroupText AS _GroupKey1Text ON ProductionResourceToolGroup1 = _GroupKey1Text.ProductionResourceToolGroup AND _GroupKey1Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdnRsceToolGroupText AS _GroupKey2Text ON ProductionResourceToolGroup2 = _GroupKey2Text.ProductionResourceToolGroup AND _GroupKey2Text.Language = $session.system_language  -- association [0..1]
;