C_SupAssgmtDmndMntr

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 C_SupAssgmtDmndMntr.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_SupAssgmtDmndMntr AS
SELECT
  entity: { name : 'I_Currency', element : 'Currency' AS RequirementType,
  ranking: #HIGH AS rankingHIGH
FROM I_SupAssgmtDmndDetsCube
LEFT OUTER JOIN C_SupAssgmtDmndMntrAssgmt AS _DmndMntrAssgmt ON RequirementDocumentNumber = _DmndMntrAssgmt.RequirementDocumentNumber AND RequirementDocumentItem = _DmndMntrAssgmt.RequirementDocumentItem AND RequirementType = _DmndMntrAssgmt.RequirementType  -- association [0..*]
LEFT OUTER JOIN I_SupDmndRqmtTypeText AS _RqmtText ON RequirementType = _RqmtText.RequirementType AND _RqmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupAssgmtSupAvailyStsTxt AS _SupAvailyStsTxt ON SupAssgmtSupAvailySts = _SupAvailyStsTxt.SupAssgmtSupAvailySts AND _SupAvailyStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ARunFashionCancDteOrdStsT AS _CancDteOrdStsT ON FashionCancelDateHorizon = _CancDteOrdStsT.FashionCancelDateHorizon AND _CancDteOrdStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText_2 AS _ProductGroupText ON MaterialGroup = _ProductGroupText.ProductGroup AND _ProductGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON SalesOrganization = _SalesOrgText.SalesOrganization AND _SalesOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChnlText ON DistributionChannel = _DistrChnlText.DistributionChannel AND _DistrChnlText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivnText ON Division = _DivnText.Division AND _DivnText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDistText ON SalesDistrict = _SalesDistText.SalesDistrict AND _SalesDistText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustGroupTxt ON CustomerGroup = _CustGroupTxt.CustomerGroup AND _CustGroupTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ARunDmndMntrToBeAssgd AS _DmndMntrToBeAssgd ON RequirementDocumentNumber = _DmndMntrToBeAssgd.RequirementDocumentNumber AND RequirementDocumentItem = _DmndMntrToBeAssgd.RequirementDocumentItem AND RequirementType = _DmndMntrToBeAssgd.RequirementType  -- association [1..1]
;