A_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 A_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: APRODSALESDELIV

CREATE VIEW A_ProductSalesDelivery AS
SELECT
  Product,
  ProductSalesOrg,
  ProductDistributionChnl,
  MinimumOrderQuantity,
  SupplyingPlant,
  PriceSpecificationProductGroup,
  AccountDetnProductGroup,
  DeliveryNoteProcMinDelivQty,
  ItemCategoryGroup,
  DeliveryQuantityUnit,
  DeliveryQuantity,
  ProductSalesStatus,
  ProductSalesStatusValidityDate,
  SalesMeasureUnit,
  IsMarkedForDeletion,
  ProductHierarchy,
  FirstSalesSpecProductGroup,
  SecondSalesSpecProductGroup,
  ThirdSalesSpecProductGroup,
  FourthSalesSpecProductGroup,
  FifthSalesSpecProductGroup,
  MinimumMakeToOrderOrderQty,
  BaseUnit,
  LogisticsStatisticsGroup,
  VolumeRebateGroup,
  ProductCommissionGroup,
  CashDiscountIsDeductible,
  PricingReferenceProduct,
  RoundingProfile,
  ProductUnitGroup,
  VariableSalesUnitIsNotAllowed,
  ProductHasAttributeID01,
  ProductHasAttributeID02,
  ProductHasAttributeID03,
  ProductHasAttributeID04,
  ProductHasAttributeID05,
  ProductHasAttributeID06,
  ProductHasAttributeID07,
  ProductHasAttributeID08,
  ProductHasAttributeID09,
  ProductHasAttributeID10
FROM I_ProductSalesDelivery AS SalesDelivery
LEFT OUTER JOIN E_Productsalesdelivery AS _ProdSalesDeliveryExt ON Product = _ProdSalesDeliveryExt.Product AND ProductSalesOrg = _ProdSalesDeliveryExt.ProductSalesOrganization AND ProductDistributionChnl = _ProdSalesDeliveryExt.ProductDistributionChannel  -- association [0..1]
LEFT OUTER JOIN A_ProductSalesText AS _SalesText ON Product = _SalesText.Product AND ProductSalesOrg = _SalesText.ProductSalesOrg AND ProductDistributionChnl = _SalesText.ProductDistributionChnl  -- association [0..*]
LEFT OUTER JOIN A_ProductSalesTax AS _SalesTax ON Product = _SalesTax.Product  -- association [0..*]
LEFT OUTER JOIN A_Product AS _Product ON Product = _Product.Product  -- association [1..1]
;