C_SubscrpnProdSlsDelivery

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_SubscrpnProdSlsDelivery.
-- 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: CSPRDSALESDELIV

CREATE VIEW C_SubscrpnProdSlsDelivery AS
SELECT
  SubscrpnProdSlsDelivery.Product AS Product,
  SubscrpnProdSlsDelivery.ProductSalesOrg AS ProductSalesOrg,
  SubscrpnProdSlsDelivery.ProductDistributionChnl AS ProductDistributionChnl,
  SubscrpnProdSlsDelivery.ItemCategoryGroup AS ItemCategoryGroup,
  SubscrpnProdSlsDelivery.IsMarkedForDeletion AS IsMarkedForDeletion,
  SubscrpnProdSlsDelivery.SubscrpnContrDfltDuration AS SubscrpnContrDfltDuration,
  SubscrpnProdSlsDelivery.SubscrpnContrAltvDuration1 AS SubscrpnContrAltvDuration1,
  SubscrpnProdSlsDelivery.SubscrpnContrAltvDuration2 AS SubscrpnContrAltvDuration2,
  SubscrpnProdSlsDelivery.SubscrpnContrDurationUnit AS SubscrpnContrDurationUnit,
  SubscrpnProdSlsDelivery.SubscrpnContrDfltExtnDurn AS SubscrpnContrDfltExtnDurn,
  SubscrpnProdSlsDelivery.SubscrpnContrAltvExtnDurn1 AS SubscrpnContrAltvExtnDurn1,
  SubscrpnProdSlsDelivery.SubscrpnContrAltvExtnDurn2 AS SubscrpnContrAltvExtnDurn2,
  SubscrpnProdSlsDelivery.SubscrpnContrExtnDurnUnit AS SubscrpnContrExtnDurnUnit,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName
FROM I_SubscrpnProdSlsDelivery AS SubscrpnProdSlsDelivery
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON ProductSalesOrg = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON ProductSalesOrg = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON ProductDistributionChnl = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelName ON ProductDistributionChnl = _DistributionChannelName.DistributionChannel AND _DistributionChannelName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ItemCategoryGroup AS _ItemCategoryGroup ON ItemCategoryGroup = _ItemCategoryGroup.ItemCategoryGroup  -- association [0..1]
LEFT OUTER JOIN I_ItemCategoryGroupText AS _ItemCategoryGroupText ON ItemCategoryGroup = _ItemCategoryGroupText.ItemCategoryGroup AND _ItemCategoryGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnContrDurnUnitVH AS _SubscrpnContrDurnUnitVH ON SubscrpnContrDurationUnit = _SubscrpnContrDurnUnitVH.SubscrpnContrDurationUnit  -- association [0..1]
LEFT OUTER JOIN I_SubscrpnContrDurnUnitVH AS _SubscrpnContrExtnDurnUnitVH ON SubscrpnContrExtnDurnUnit = _SubscrpnContrExtnDurnUnitVH.SubscrpnContrDurationUnit  -- association [0..1]
LEFT OUTER JOIN C_SubscrpnProdSalesCountry AS _SubscrpnProdSalesCountry ON Product = _SubscrpnProdSalesCountry.Product AND ProductSalesOrg = _SubscrpnProdSalesCountry.ProductSalesOrg AND ProductDistributionChnl = _SubscrpnProdSalesCountry.ProductDistributionChnl  -- association [1..*]
;