C_SupDmndOvwPgCustRetsQ

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_SupDmndOvwPgCustRetsQ.
-- 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_SupDmndOvwPgCustRetsQ AS
SELECT
  Material,
  Plant,
  Batch,
  StorageLocation,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  ProductAvailabilityDate,
  AssignedSupplyType,
  SupAssgmtSource,
  RequestedDeliveryDate,
  OpenSupplyQuantity,
  AssignedQuantityInBaseUnit,
  BaseUnit,
  SupAssgmtAggrgQtyUnit,
  SDDocumentReason,
  SalesDocumentRjcnReason,
  MaterialGroup,
  MaterialType,
  CrossPlantConfigurableProduct,
  StockSegment,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  Customer,
  CompanyCode,
  DisplayCurrency,
  TotActualAmtInDisplayCurrency
FROM I_SupDmndOvwPgCustRetsC
LEFT OUTER JOIN I_SupDmndAllDocSupTypeT AS _SupText ON AssignedSupplyType = _SupText.AssignedSupplyType AND _SupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocSupSourceT AS _SupSrceText ON SupAssgmtSource = _SupSrceText.SupAssgmtSource AND _SupSrceText.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_ProductTypeText AS _ProductTypeText ON MaterialType = _ProductTypeText.ProductType AND _ProductTypeText.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_SalesDocumentRjcnReasonText AS _SalesDocumentRjcnReasonT ON SalesDocumentRjcnReason = _SalesDocumentRjcnReasonT.SalesDocumentRjcnReason AND _SalesDocumentRjcnReasonT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReasonText AS _SDDocumentReasonT ON SDDocumentReason = _SDDocumentReasonT.SDDocumentReason AND _SDDocumentReasonT.Language = $session.system_language  -- association [0..1]
;