C_SalesOrderItemProductEANVH

DDL: C_SALESORDERITEMPRODUCTEANVH Type: view_entity CONSUMPTION Package: ODATA_SD_S4H_COMMON
11 Fields 2 Data Sources

Product By EAN/UPC

C_SalesOrderItemProductEANVH is a Consumption CDS View that provides data about "Product By EAN/UPC" in SAP S/4HANA. It reads from 2 data sources (C_SlsOrdProdBySlsOrgDistrChnl, I_ProductUnitOfMeasureEAN) and exposes 11 fields with key fields SalesOrganization, DistributionChannel, Product, RequestedQuantityUnit, ConsecutiveNumber. Part of development package ODATA_SD_S4H_COMMON.

Data Sources (2)

SourceAliasJoin Type
C_SlsOrdProdBySlsOrgDistrChnl Product from
I_ProductUnitOfMeasureEAN ProductUnitOfMeasureEAN inner

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey Product view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view
Consumption.ranked true view
EndUserText.label Product By EAN/UPC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SalesOrganization C_SlsOrdProdBySlsOrgDistrChnl SalesOrganization Sales Organization
KEY DistributionChannel C_SlsOrdProdBySlsOrgDistrChnl DistributionChannel RefDistCh-Cust/Mat.
KEY Product
KEY RequestedQuantityUnit I_ProductUnitOfMeasureEAN AlternativeUnit Base UoM
KEY ConsecutiveNumber I_ProductUnitOfMeasureEAN ConsecutiveNumber Sequence no.
ProductName C_SlsOrdProdBySlsOrgDistrChnl ProductName Description
ProductStandardID I_ProductUnitOfMeasureEAN ProductStandardID GTIN
IsMainGlobalTradeItemNumber I_ProductUnitOfMeasureEAN IsMainGlobalTradeItemNumber Main EAN
_SalesOrganization C_SlsOrdProdBySlsOrgDistrChnl _SalesOrganization
_DistributionChannel C_SlsOrdProdBySlsOrgDistrChnl _DistributionChannel
_Product I_ProductUnitOfMeasureEAN _Product

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_SalesOrderItemProductEANVH.
-- 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.

CREATE VIEW C_SalesOrderItemProductEANVH AS
SELECT
  Product.SalesOrganization AS SalesOrganization,
  Product.DistributionChannel AS DistributionChannel,
  cast (ProductUnitOfMeasureEAN.Product as productnumber preserving type ) AS Product,
  ProductUnitOfMeasureEAN.AlternativeUnit AS RequestedQuantityUnit,
  ProductUnitOfMeasureEAN.ConsecutiveNumber AS ConsecutiveNumber,
  Product.ProductName AS ProductName,
  ProductUnitOfMeasureEAN.ProductStandardID AS ProductStandardID,
  ProductUnitOfMeasureEAN.IsMainGlobalTradeItemNumber AS IsMainGlobalTradeItemNumber,
  Product._SalesOrganization AS _SalesOrganization,
  Product._DistributionChannel AS _DistributionChannel,
  ProductUnitOfMeasureEAN._Product AS _Product
FROM C_SlsOrdProdBySlsOrgDistrChnl AS Product
INNER JOIN I_ProductUnitOfMeasureEAN AS ProductUnitOfMeasureEAN ON /* join condition not captured in parsed metadata */
;

Learn More