I_RoutingPRTMasterDataSrchMod

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_RoutingPRTMasterDataSrchMod.
-- 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_RoutingPRTMasterDataSrchMod AS
SELECT
  cast(crfh.objty as productionresourcetype preserving type) AS ProductionResourceType,
  cast(crfh.objid as pph_fhmid preserving type) AS ProductionResourceInternalID,
  crfh.fgru1 AS ProductionResourceToolGroup1,
  crfh.fgru2 AS ProductionResourceToolGroup2,
  crfh.planv AS ProductionResourceUsage,
  crfh.brgru AS MiscPRTAuthorizationGroup,
  crfh.steuf AS ProdnRsceToolControlProfile,
  cast(crfh.aennr as changenumber preserving type) AS ChangeNumber,
  crfh.ktsch AS ProdnRsceToolStandardTextCode,
  crfh.mgform AS ProdnRsceToolTotQtyCalcFormula,
  crfh.ewform AS ProdnRsceToolUsageQtyCalcFmla,
  crfh.andat AS CreationDate,
  cast(crfh.annam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  crfh.aedat AS LastChangeDate,
  crfh.aenam AS LastChangedByUser,
  cast(crfh.bzoffb as startdateoffsetreferencecode preserving type) AS StartDateOffsetReferenceCode,
  cast(crfh.offstb as startdateoffsetduration preserving type) AS StartDateOffsetDuration,
  crfh.ehoffb AS StartDateOffsetDurationUnit,
  cast(crfh.bzoffe as enddateoffsetreferencecode preserving type) AS EndDateOffsetReferenceCode,
  cast(crfh.offste as enddateoffsetduration preserving type) AS EndDateOffsetDuration,
  crfh.ehoffe AS EndDateOffsetDurationUnit
FROM crfh
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- 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_ProductionResourceUsage AS _ProductionResourceUsage ON ProductionResourceUsage = _ProductionResourceUsage.ProductionResourceUsage  -- 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_ChangeMaster AS _ChangeMaster ON ChangeNumber = _ChangeMaster.ChangeNumber  -- association [0..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_OperationDateOffsetRefCode AS _StartDateOffsetReferenceCode ON StartDateOffsetReferenceCode = _StartDateOffsetReferenceCode.OperationDateOffsetRefCode  -- association [1..1]
LEFT OUTER JOIN I_OperationDateOffsetRefCode AS _EndDateOffsetReferenceCode ON EndDateOffsetReferenceCode = _EndDateOffsetReferenceCode.OperationDateOffsetRefCode  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StartDateOffsetDurationUnit ON StartDateOffsetDurationUnit = _StartDateOffsetDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EndDateOffsetDurationUnit ON EndDateOffsetDurationUnit = _EndDateOffsetDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_MaterialPRTByInternalKey AS _MaterialPRTByInternalKey ON ProductionResourceType = _MaterialPRTByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _MaterialPRTByInternalKey.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_EquipmentPRTByInternalKey AS _EquipmentPRTByInternalKey ON ProductionResourceType = _EquipmentPRTByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _EquipmentPRTByInternalKey.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_DocumentPRTByInternalKey AS _DocumentPRTByInternalKey ON ProductionResourceType = _DocumentPRTByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _DocumentPRTByInternalKey.ProductionResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_MiscPRTByInternalKey AS _MiscPRTByInternalKey ON ProductionResourceType = _MiscPRTByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _MiscPRTByInternalKey.ProductionResourceInternalID  -- association [0..1]
;