I_CommodityQuantitySalesTP

DDL: I_COMMODITYQUANTITYSALESTP SQL: ICMMDTYQTYSALES Type: view TRANSACTIONAL
21 Fields 1 Data Sources 7 Associations

Commodity Quantity for Sales - TP

I_CommodityQuantitySalesTP is a Transactional CDS View that provides data about "Commodity Quantity for Sales - TP" in SAP S/4HANA. It reads from 1 data source (I_CommodityQuantitySales) and exposes 21 fields with key fields Product, SalesOrganization, DistributionChannel, Commodity. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CommodityQuantitySales CommodityQuantitySales from

Associations (7)

CardinalityTargetAliasCondition
[1..1] E_CommodityQuantitySales _ActiveExtension $projection.Product = _ActiveExtension.Product and $projection.SalesOrganization = _ActiveExtension.SalesOrganization and $projection.DistributionChannel = _ActiveExtension.DistributionChannel and $projection.Commodity = _ActiveExtension.Commodity
[1..1] E_CommodityQuantitySales _DraftExtension $projection.Product = _DraftExtension.Product and $projection.SalesOrganization = _DraftExtension.SalesOrganization and $projection.DistributionChannel = _DraftExtension.DistributionChannel and $projection.Commodity = _DraftExtension.Commodity
[1..1] I_ProductWD _Product $projection.Product = _Product.Product
[1..1] I_ProductSalesDeliveryWD _SalesDelivery $projection.Product = _SalesDelivery.Product and $projection.SalesOrganization = _SalesDelivery.ProductSalesOrg and $projection.DistributionChannel = _SalesDelivery.ProductDistributionChnl
[0..*] I_SourcingCommodityText _SourcingCommodityText $projection.Commodity = _SourcingCommodityText.Commodity
[0..1] I_User _UserCreate $projection.CreatedByUser = _UserCreate.UserID
[0..1] I_User _UserChange $projection.LastChangedByUser = _UserChange.UserID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYQTYSALES view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence CMM_SLS_QTY_D view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Commodity Quantity for Sales - TP view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Product Product Product Sold
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Commodity Commodity Commodity Code
CommodityForEdit Commodity Commodity Code
CommodityName
CommodityQuantity CommodityQuantity Commodity Quantity
CommodityQuantityUoM CommodityQuantityUoM Commodity Qty Uom
ReferenceQuantity ReferenceQuantity Comm Refer Quantity
ReferenceQuantityUoM ReferenceQuantityUoM Comm RefQty Uom
CreatedByUser CreatedByUser User Name
CreatedByUserName _UserCreate UserDescription Full Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedByUserName _UserChange UserDescription Full Name
LastChangeDateTime LastChangeDateTime Timestamp
_Product _Product
_SalesDelivery _SalesDelivery
_SourcingCommodityText _SourcingCommodityText
_UserCreate _UserCreate
_UserChange _UserChange

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_CommodityQuantitySalesTP.
-- 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: ICMMDTYQTYSALES

CREATE VIEW I_CommodityQuantitySalesTP AS
SELECT
  Product,
  SalesOrganization,
  DistributionChannel,
  Commodity,
  Commodity AS CommodityForEdit,
  _SourcingCommodityText[1: Language=$session.system_language].CommodityName AS CommodityName,
  CommodityQuantity,
  CommodityQuantityUoM,
  ReferenceQuantity,
  ReferenceQuantityUoM,
  CreatedByUser,
  _UserCreate.UserDescription AS CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  _UserChange.UserDescription AS ChangedByUserName,
  LastChangeDateTime
FROM I_CommodityQuantitySales AS CommodityQuantitySales
LEFT OUTER JOIN E_CommodityQuantitySales AS _ActiveExtension ON Product = _ActiveExtension.Product AND SalesOrganization = _ActiveExtension.SalesOrganization AND DistributionChannel = _ActiveExtension.DistributionChannel AND Commodity = _ActiveExtension.Commodity  -- association [1..1]
LEFT OUTER JOIN E_CommodityQuantitySales AS _DraftExtension ON Product = _DraftExtension.Product AND SalesOrganization = _DraftExtension.SalesOrganization AND DistributionChannel = _DraftExtension.DistributionChannel AND Commodity = _DraftExtension.Commodity  -- association [1..1]
LEFT OUTER JOIN I_ProductWD AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ProductSalesDeliveryWD AS _SalesDelivery ON Product = _SalesDelivery.Product AND SalesOrganization = _SalesDelivery.ProductSalesOrg AND DistributionChannel = _SalesDelivery.ProductDistributionChnl  -- association [1..1]
LEFT OUTER JOIN I_SourcingCommodityText AS _SourcingCommodityText ON Commodity = _SourcingCommodityText.Commodity  -- association [0..*]
LEFT OUTER JOIN I_User AS _UserCreate ON CreatedByUser = _UserCreate.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserChange ON LastChangedByUser = _UserChange.UserID  -- association [0..1]
;

Learn More