I_CommodityStructuralQuantity

DDL: I_COMMODITYSTRUCTURALQUANTITY Type: view_entity BASIC
11 Fields 1 Data Sources 1 Associations

Commodity Quantity Structural Info

I_CommodityStructuralQuantity is a Basic CDS View that provides data about "Commodity Quantity Structural Info" in SAP S/4HANA. It reads from 1 data source (cmm_struc_qty) and exposes 11 fields with key fields Product, Plant, Commodity. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cmm_struc_qty cmm_struc_qty from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_CommodityStructuralQuantity _CommodityQtyStructuralExt $projection.Product = _CommodityQtyStructuralExt.Product and $projection.Plant = _CommodityQtyStructuralExt.Plant and $projection.Commodity = _CommodityQtyStructuralExt.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 #TRANSACTIONAL view
EndUserText.label Commodity Quantity Structural Info view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Product product Product Sold
KEY Plant plant Valuation Area
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_CommodityStructuralQuantity.
-- 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_CommodityStructuralQuantity AS
SELECT
  Product,
  Plant,
  Commodity,
  CommodityQuantity,
  CommodityQuantityUoM,
  ReferenceQuantity,
  ReferenceQuantityUoM,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM cmm_struc_qty
LEFT OUTER JOIN E_CommodityStructuralQuantity AS _CommodityQtyStructuralExt ON Product = _CommodityQtyStructuralExt.Product AND Plant = _CommodityQtyStructuralExt.Plant AND Commodity = _CommodityQtyStructuralExt.Commodity  -- association [1..1]
;

Learn More