I_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 I_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: ISPRDSALESDELIV

CREATE VIEW I_SubscrpnProdSlsDelivery AS
SELECT
  mvke.matnr AS Product,
  mvke.vkorg AS ProductSalesOrg,
  mvke.vtweg AS ProductDistributionChnl,
  mvke.mtpos AS ItemCategoryGroup,
  mvke.lvorm AS IsMarkedForDeletion,
  mvke.ctr_term_def AS SubscrpnContrDfltDuration,
  mvke.ctr_term_alt1 AS SubscrpnContrAltvDuration1,
  mvke.ctr_term_alt2 AS SubscrpnContrAltvDuration2,
  mvke.ctr_term_unit AS SubscrpnContrDurationUnit,
  mvke.ext_period_def AS SubscrpnContrDfltExtnDurn,
  mvke.ext_period_alt1 AS SubscrpnContrAltvExtnDurn1,
  mvke.ext_period_alt2 AS SubscrpnContrAltvExtnDurn2,
  mvke.ext_period_unit AS SubscrpnContrExtnDurnUnit
FROM mvke
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]
;