A_ClfnProductSalesDelivery

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_ClfnProductSalesDelivery.
-- 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: ACLFNPRODSLSDELI

CREATE VIEW A_ClfnProductSalesDelivery 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
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]
;