I_MatlProcurementProfile

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_MatlProcurementProfile.
-- 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: IMATLPROCMPRFL

CREATE VIEW I_MatlProcurementProfile AS
SELECT
  cast(prfl.sobsl as pph_sobsl preserving type) AS MaterialProcurementProfile,
  prfl.werks AS Plant,
  cast(prfl.beskz as pph_beskz preserving type) AS MaterialProcurementCategory,
  cast(prfl.sobes as pph_esobs preserving type) AS MaterialProcurementExtType,
  cast(prfl.wrk02 as vdm_wrk02 preserving type) AS SupplyingOrProductionPlant,
  prfl.rewrk AS IssuingPlant,
  $session.system_language AS Language,
  prfl.clcor AS MaterialIsDirectlyProduced,
  prfl.dirpr AS MaterialIsDirectlyProcured,
  prfl.dumps AS IsPhantomItem,
  prfl.rewfg AS IsWithdrawnFrmAlternativePlant,
  prfl.umldb AS MRPStockTransfSelectionControl,
  prfl.mlscr AS MatlIsRlvtForMultiLvlSubcontrg
FROM t460a AS prfl
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _SupplyingOrProductionPlant ON SupplyingOrProductionPlant = _SupplyingOrProductionPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _IssuingPlant ON IssuingPlant = _IssuingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementProfileText AS _Text ON MaterialProcurementProfile = _Text.MaterialProcurementProfile AND Plant = _Text.Plant  -- association [0..*]
LEFT OUTER JOIN I_MatlProcurementCategory AS _MaterialProcurementCategory ON MaterialProcurementCategory = _MaterialProcurementCategory.MaterialProcurementCategory  -- association [1..1]
LEFT OUTER JOIN I_MatlProcurementExternalType AS _MaterialProcurementExtType ON MaterialProcurementExtType = _MaterialProcurementExtType.MaterialProcurementExtType  -- association [0..*]
LEFT OUTER JOIN I_MatlProcurementExternalType AS _MaterialProcurementExtType_2 ON MaterialProcurementExtType = _MaterialProcurementExtType_2.MaterialProcurementExtType AND Language = _MaterialProcurementExtType_2.Language  -- association [0..1]
LEFT OUTER JOIN I_MatlProcmtExternalType AS _MaterialProcurementExtType_3 ON MaterialProcurementExtType = _MaterialProcurementExtType_3.MaterialProcurementExtType  -- association [0..1]
;