I_ProdnRsceToolMasterData

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_ProdnRsceToolMasterData.
-- 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: IPPPRTMD

CREATE VIEW I_ProdnRsceToolMasterData AS
SELECT
  cast(crfh.objty as productionresourcetype preserving type) AS ProductionResourceType,
  cast(crfh.objid as pph_fhmid preserving type) AS ProductionResourceInternalID,
  crfh.fhmar AS ProdnRsceToolCategory,
  cast(crfh.fhmar as mpe_fhmar preserving type) AS ProdnRsceToolCategory_2,
  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.baseh AS ProdnRsceToolBaseUnit,
  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,
  cast(crfh.offste_ref as vdm_oekzr preserving type) AS EndDateOffsetDurnIsReferenced,
  cast(crfh.offstb_ref as vdm_obkzr preserving type) AS StartDateOffstDurnIsReferenced,
  cast(crfh.bzoffe_ref as vdm_bekzr preserving type) AS EndDteOffstRefCodeIsReferenced,
  cast(crfh.bzoffb_ref as vdm_bbkzr preserving type) AS StartDateOffsetRefCodeIsRefcd,
  cast(crfh.mgform_ref as vdm_mfkzr preserving type) AS PRTTotQtyCalcFmlaIsReferenced,
  cast(crfh.ewform_ref as vdm_efkzr preserving type) AS PRTUsgeQtyCalcFmlaIsReferenced,
  cast(crfh.steuf_ref as vdm_stkzr preserving type) AS PRTControlProfileIsReferenced,
  cast(crfh.ktsch_ref as vdm_ktkzr preserving type) AS PRTStdTextCodeIsReferenced,
  crfh.registrable AS ShopFloorRtgPRTIsRegistrable,
  crfh.kzkbl AS ProdPRTLoadRecordsAreCreated
FROM crfh
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory AS _ProdnRsceToolCategory ON ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory AS _ProdnRsceToolCategory_2 ON ProdnRsceToolCategory_2 = _ProdnRsceToolCategory_2.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory_3 ON ProdnRsceToolCategory_2 = _ProdnRsceToolCategory_3.ProdnRsceToolCategory  -- 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_UnitOfMeasure AS _ProdnRsceToolBaseUnit ON ProdnRsceToolBaseUnit = _ProdnRsceToolBaseUnit.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]
;