C_Productsalesdeliverypos

DDL: C_PRODUCTSALESDELIVERYPOS SQL: CPRDSALESDELPOS Type: view CONSUMPTION Package: VDM_MD_PRODUCT
24 Fields 1 Data Sources 3 Associations

Consumption - Product Sales delivery POS

C_Productsalesdeliverypos is a Consumption CDS View that provides data about "Consumption - Product Sales delivery POS" in SAP S/4HANA. It reads from 1 data source (I_Productsalesdeliveryposwd) and exposes 24 fields with key fields Product, ProductSalesOrg, ProductDistributionChnl, Plant. It has 3 associations to related views. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_Productsalesdeliveryposwd SalesDeliveryPOS from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_Product _Product $projection.Product = _Product.Product
[1..1] C_Productsalesdelivery _SalesDelivery $projection.Product = _SalesDelivery.Product and $projection.ProductSalesOrg = _SalesDelivery.ProductSalesOrg and $projection.ProductDistributionChnl = _SalesDelivery.ProductDistributionChnl
[0..1] I_Plant _PlantVH $projection.PlantForEdit = _PlantVH.Plant

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRDSALESDELPOS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption - Product Sales delivery POS view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
Metadata.allowExtensions true view
Feature SW:ISR_RETAILSWITCH view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY Product I_Productsalesdeliveryposwd Product Product Sold
KEY ProductSalesOrg I_Productsalesdeliveryposwd ProductSalesOrg Sales Org.
KEY ProductDistributionChnl I_Productsalesdeliveryposwd ProductDistributionChnl Distr. Channel
KEY Plant I_Productsalesdeliveryposwd Plant Valuation Area
ProductSalesOrgForEdit I_Productsalesdeliveryposwd ProductSalesOrgForEdit Sales Org.
ProductDistributionChnlForEdit I_Productsalesdeliveryposwd ProductDistributionChnlForEdit Distr. Channel
PlantForEdit I_Productsalesdeliveryposwd PlantForEdit Plant ID
StoreSaleStartDate I_Productsalesdeliveryposwd StoreSaleStartDate sale from (str)
StoreSaleEndDate I_Productsalesdeliveryposwd StoreSaleEndDate sale till (str)
ProductSalesStatus I_Productsalesdeliveryposwd ProductSalesStatus Status
ProductSalesStatusValidityDate I_Productsalesdeliveryposwd ProductSalesStatusValidityDate Valid From
IsPointOfSalesDiscountAllowed I_Productsalesdeliveryposwd IsPointOfSalesDiscountAllowed Disc. allowed
ProdSlsDelivPOSIsPriceRequired I_Productsalesdeliveryposwd ProdSlsDelivPOSIsPriceRequired
ProdSlsDelivRepeatKey I_Productsalesdeliveryposwd ProdSlsDelivRepeatKey
ScalesGroup I_Productsalesdeliveryposwd ScalesGroup Scales Group
_Product _Product
_SalesDelivery _SalesDelivery
_ProdSlsDelivRepeatKey _ProdSlsDelivRepeatKey
_ProdSlsDelivRepeatKeyText _ProdSlsDelivRepeatKeyText
_PlantVH _PlantVH
_ProductSalesStatus _ProductSalesStatus
_ProductSalesStatusText _ProductSalesStatusText
_ScalesGroup _ScalesGroup
_ScalesGroupText _ScalesGroupText

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_Productsalesdeliverypos.
-- 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: CPRDSALESDELPOS

CREATE VIEW C_Productsalesdeliverypos AS
SELECT
  SalesDeliveryPOS.Product AS Product,
  SalesDeliveryPOS.ProductSalesOrg AS ProductSalesOrg,
  SalesDeliveryPOS.ProductDistributionChnl AS ProductDistributionChnl,
  SalesDeliveryPOS.Plant AS Plant,
  SalesDeliveryPOS.ProductSalesOrgForEdit AS ProductSalesOrgForEdit,
  SalesDeliveryPOS.ProductDistributionChnlForEdit AS ProductDistributionChnlForEdit,
  SalesDeliveryPOS.PlantForEdit AS PlantForEdit,
  SalesDeliveryPOS.StoreSaleStartDate AS StoreSaleStartDate,
  SalesDeliveryPOS.StoreSaleEndDate AS StoreSaleEndDate,
  SalesDeliveryPOS.ProductSalesStatus AS ProductSalesStatus,
  SalesDeliveryPOS.ProductSalesStatusValidityDate AS ProductSalesStatusValidityDate,
  SalesDeliveryPOS.IsPointOfSalesDiscountAllowed AS IsPointOfSalesDiscountAllowed,
  SalesDeliveryPOS.ProdSlsDelivPOSIsPriceRequired AS ProdSlsDelivPOSIsPriceRequired,
  SalesDeliveryPOS.ProdSlsDelivRepeatKey AS ProdSlsDelivRepeatKey,
  SalesDeliveryPOS.ScalesGroup AS ScalesGroup
FROM I_Productsalesdeliveryposwd AS SalesDeliveryPOS
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_Productsalesdelivery AS _SalesDelivery ON Product = _SalesDelivery.Product AND ProductSalesOrg = _SalesDelivery.ProductSalesOrg AND ProductDistributionChnl = _SalesDelivery.ProductDistributionChnl  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantVH ON PlantForEdit = _PlantVH.Plant  -- association [0..1]
;

Learn More