C_Productsalesdelivery

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_Productsalesdelivery.
-- 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: CPRDSALESDELIVWD

CREATE VIEW C_Productsalesdelivery AS
SELECT
  SalesDelivery.Product AS Product,
  SalesDelivery.ProductSalesOrg AS ProductSalesOrg,
  SalesDelivery.ProductDistributionChnl AS ProductDistributionChnl,
  SalesDelivery.ProductForEdit AS ProductForEdit,
  SalesDelivery.ProductSalesOrgForEdit AS ProductSalesOrgForEdit,
  SalesDelivery.ProductDistributionChnlForEdit AS ProductDistributionChnlForEdit,
  SalesDelivery.IsMarkedForDeletion AS IsMarkedForDeletion,
  SalesDelivery.MinimumOrderQuantity AS MinimumOrderQuantity,
  SalesDelivery.SupplyingPlant AS SupplyingPlant,
  SalesDelivery.PriceSpecificationProductGroup AS PriceSpecificationProductGroup,
  SalesDelivery.AccountDetnProductGroup AS AccountDetnProductGroup,
  SalesDelivery.DeliveryNoteProcMinDelivQty AS DeliveryNoteProcMinDelivQty,
  SalesDelivery.ItemCategoryGroup AS ItemCategoryGroup,
  SalesDelivery.DeliveryQuantityUnit AS DeliveryQuantityUnit,
  SalesDelivery.DeliveryQuantity AS DeliveryQuantity,
  SalesDelivery.ProductSalesStatus AS ProductSalesStatus,
  SalesDelivery.ProductSalesStatusValidityDate AS ProductSalesStatusValidityDate,
  SalesDelivery.SalesMeasureUnit AS SalesMeasureUnit,
  SalesDelivery.ProductHierarchy AS ProductHierarchy,
  SalesDelivery.FirstSalesSpecProductGroup AS FirstSalesSpecProductGroup,
  SalesDelivery.SecondSalesSpecProductGroup AS SecondSalesSpecProductGroup,
  SalesDelivery.ThirdSalesSpecProductGroup AS ThirdSalesSpecProductGroup,
  SalesDelivery.FourthSalesSpecProductGroup AS FourthSalesSpecProductGroup,
  SalesDelivery.FifthSalesSpecProductGroup AS FifthSalesSpecProductGroup,
  SalesDelivery.MinimumMakeToOrderOrderQty AS MinimumMakeToOrderOrderQty,
  SalesDelivery.LogisticsStatisticsGroup AS LogisticsStatisticsGroup,
  SalesDelivery.VolumeRebateGroup AS VolumeRebateGroup,
  SalesDelivery.ProductCommissionGroup AS ProductCommissionGroup,
  SalesDelivery.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  SalesDelivery.PricingReferenceProduct AS PricingReferenceProduct,
  SalesDelivery.AssortmentGrade AS AssortmentGrade,
  SalesDelivery.ProdExtAssortmentPriority AS ProdExtAssortmentPriority,
  SalesDelivery.StoreListingProcedure AS StoreListingProcedure,
  SalesDelivery.DistrCntrListingProcedure AS DistrCntrListingProcedure,
  SalesDelivery.StoreListingStartDate AS StoreListingStartDate,
  SalesDelivery.StoreListingEndDate AS StoreListingEndDate,
  SalesDelivery.DistrCntrListingStartDate AS DistrCntrListingStartDate,
  SalesDelivery.DistrCntrListingEndDate AS DistrCntrListingEndDate,
  SalesDelivery.StoreSaleStartDate AS StoreSaleStartDate,
  SalesDelivery.StoreSaleEndDate AS StoreSaleEndDate,
  SalesDelivery.DistrCntrSaleStartDate AS DistrCntrSaleStartDate,
  SalesDelivery.DistrCntrSaleEndDate AS DistrCntrSaleEndDate,
  SalesDelivery.RoundingProfile AS RoundingProfile,
  SalesDelivery.ProductUnitGroup AS ProductUnitGroup,
  SalesDelivery.MaxDeliveryQtyStoreOrder AS MaxDeliveryQtyStoreOrder,
  SalesDelivery.PriceFixingCategory AS PriceFixingCategory,
  SalesDelivery.VariableSalesUnitIsNotAllowed AS VariableSalesUnitIsNotAllowed,
  SalesDelivery.CompetitionPressureCategory AS CompetitionPressureCategory,
  cast('' as boole_d) AS HasActiveHierarchy,
  BaseUnit,
  SalesDelivery.ProdIsEntlmntRlvt AS ProdIsEntlmntRlvt,
  SalesDelivery._ItemCategoryGroup AS _ItemCategoryGroup,
  SalesDelivery._ItemCategoryGroupText AS _ItemCategoryGroupText
FROM I_ProductSalesDeliveryWD AS SalesDelivery
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productsalescountry AS _ProductSalesTax ON Product = _ProductSalesTax.Product AND ProductSalesOrg = _ProductSalesTax.ProductSalesOrg AND ProductDistributionChnl = _ProductSalesTax.ProductDistributionChnl  -- association [1..*]
LEFT OUTER JOIN C_Productsalesdeliverypos AS _SalesDeliveryPointofSale ON Product = _SalesDeliveryPointofSale.Product AND ProductSalesOrg = _SalesDeliveryPointofSale.ProductSalesOrg AND ProductDistributionChnl = _SalesDeliveryPointofSale.ProductDistributionChnl  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationName ON ProductSalesOrgForEdit = _SalesOrganizationName.SalesOrganization AND _SalesOrganizationName.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelName ON ProductDistributionChnlForEdit = _DistributionChannelName.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON SupplyingPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyText AS _ProductHierarchyText ON ProductHierarchy = _ProductHierarchyText.ProductHierarchy  -- association [0..*]
LEFT OUTER JOIN C_AdditionalProductGroup1Text AS _AdditionalProductGroup1Text ON FirstSalesSpecProductGroup = _AdditionalProductGroup1Text.FirstSalesSpecProductGroup  -- association [0..*]
LEFT OUTER JOIN C_AdditionalProductGroup2Text AS _AdditionalProductGroup2Text ON SecondSalesSpecProductGroup = _AdditionalProductGroup2Text.SecondSalesSpecProductGroup  -- association [0..*]
LEFT OUTER JOIN C_AdditionalProductGroup3Text AS _AdditionalProductGroup3Text ON ThirdSalesSpecProductGroup = _AdditionalProductGroup3Text.ThirdSalesSpecProductGroup  -- association [0..*]
LEFT OUTER JOIN C_AdditionalProductGroup4Text AS _AdditionalProductGroup4Text ON FourthSalesSpecProductGroup = _AdditionalProductGroup4Text.FourthSalesSpecProductGroup  -- association [0..*]
LEFT OUTER JOIN C_AdditionalProductGroup5Text AS _AdditionalProductGroup5Text ON FifthSalesSpecProductGroup = _AdditionalProductGroup5Text.FifthSalesSpecProductGroup  -- association [0..*]
LEFT OUTER JOIN I_UOMGroup AS _ProductUnitGroupVH ON ProductUnitGroup = _ProductUnitGroupVH.ProductUnitGroup  -- association [0..*]
LEFT OUTER JOIN C_Volrbtegrptexttemp AS _VolumeRebateGroupText ON VolumeRebateGroup = _VolumeRebateGroupText.VolumeRebateGroup  -- association [0..*]
LEFT OUTER JOIN C_ProductBasicInfo AS _PricingReferenceProduct ON PricingReferenceProduct = _PricingReferenceProduct.Product  -- association [0..1]
LEFT OUTER JOIN C_SalesOrganizationVH AS _ProductSalesOrg ON ProductSalesOrg = _ProductSalesOrg.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _ProdSalesOrgText ON ProductSalesOrg = _ProdSalesOrgText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN C_SalesOrganizationVH AS _ProductSalesOrganization ON ProductSalesOrgForEdit = _ProductSalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN C_ProdHierByDistributionChain AS _ProdHierByDistributionChain ON Product = _ProdHierByDistributionChain.Product AND ProductSalesOrg = _ProdHierByDistributionChain.SalesOrganization AND ProductDistributionChnl = _ProdHierByDistributionChain.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN C_CommodityQuantitySales AS _CommodityQuantitySales ON Product = _CommodityQuantitySales.Product AND ProductSalesOrg = _CommodityQuantitySales.SalesOrganization AND ProductDistributionChnl = _CommodityQuantitySales.DistributionChannel  -- association [0..*]
;