I_CommodityQuantitySales

DDL: I_COMMODITYQUANTITYSALES Type: view_entity BASIC Package: LOG_CMM_PRC_CMMDTY_QTY_PROD
12 Fields 1 Data Sources 1 Associations

Commodity Quantity Sales Info

I_CommodityQuantitySales is a Basic CDS View that provides data about "Commodity Quantity Sales Info" in SAP S/4HANA. It reads from 1 data source (cmm_sls_qty) and exposes 12 fields with key fields Product, SalesOrganization, DistributionChannel, Commodity. It has 1 association to related views. Part of development package LOG_CMM_PRC_CMMDTY_QTY_PROD.

Data Sources (1)

SourceAliasJoin Type
cmm_sls_qty cmm_sls_qty from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CommodityQuantitySales _CommodityQtySalesExt $projection.Product = _CommodityQtySalesExt.Product and $projection.SalesOrganization = _CommodityQtySalesExt.SalesOrganization and $projection.DistributionChannel = _CommodityQtySalesExt.DistributionChannel and $projection.Commodity = _CommodityQtySalesExt.Commodity

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Commodity Quantity Sales Info view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Product product Product Sold
KEY SalesOrganization salesorganization Sales Organization
KEY DistributionChannel distributionchannel RefDistCh-Cust/Mat.
KEY Commodity commodity Commodity Code
CommodityQuantity commodityquantity Commodity Quantity
CommodityQuantityUoM commodityquantityuom Commodity Qty Uom
ReferenceQuantity referencequantity Comm Refer Quantity
ReferenceQuantityUoM referencequantityuom Comm RefQty Uom
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp

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 I_CommodityQuantitySales.
-- 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 I_CommodityQuantitySales AS
SELECT
  Product,
  SalesOrganization,
  DistributionChannel,
  Commodity,
  CommodityQuantity,
  CommodityQuantityUoM,
  ReferenceQuantity,
  ReferenceQuantityUoM,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM cmm_sls_qty
LEFT OUTER JOIN E_CommodityQuantitySales AS _CommodityQtySalesExt ON Product = _CommodityQtySalesExt.Product AND SalesOrganization = _CommodityQtySalesExt.SalesOrganization AND DistributionChannel = _CommodityQtySalesExt.DistributionChannel AND Commodity = _CommodityQtySalesExt.Commodity  -- association [1..1]
;

Learn More