I_MaterialShortageDefinition

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_MaterialShortageDefinition.
-- 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: IMATSHORTDEF

CREATE VIEW I_MaterialShortageDefinition AS
SELECT
  sdm_msh_prof01.materialshortageprofile AS MaterialShortageProfile,
  cast (sdm_msh_prof01.materialshortageprof_cnt as materialshortageprofilecount preserving type) AS MaterialShortageProfileCount,
  sdm_msh_prof01.demandcategorygroup AS DemandCategoryGroup,
  sdm_msh_prof01.receiptcategorygroup AS ReceiptCategoryGroup,
  sdm_msh_prof01.sdivevaluationhorizonindays AS EvaluationHorizonInDays,
  _MaterialShortageDefText[ 1: spras = $session.system_language ].materialshortagedefinitionname AS MaterialShortageDefinitionName,
  sdm_msh_prof01.mfgordercomponentcheckrule AS HasMfgOrderComponentCheckRule,
  sdm_msh_prof01.uncovereddemandiscalculated AS UncoveredDemandIsCalculated
FROM sdm_msh_prof01
LEFT OUTER JOIN sdm_aor_profile AS _ProfileUser ON _ProfileUser.uname = $session.user AND _ProfileUser.sdm_profile = MaterialShortageProfile  -- association [0..1]
LEFT OUTER JOIN sdm_aor_profile AS _ProfileStar ON _ProfileStar.uname = '*' AND _ProfileStar.sdm_profile = MaterialShortageProfile  -- association [0..1]
LEFT OUTER JOIN sdm_msh_prof01_t AS _MaterialShortageDefText ON MaterialShortageProfile = _MaterialShortageDefText.materialshortageprofile AND MaterialShortageProfileCount = _MaterialShortageDefText.materialshortageprof_cnt  -- association [0..*]
;