E_CommodityStructuralQuantity

DDL: E_COMMODITYSTRUCTURALQUANTITY SQL: ECMMDTYSTRUQTY Type: view EXTENSION
4 Fields 1 Data Sources

Commodity Structural Quantity - Extension

E_CommodityStructuralQuantity is a Extension CDS View that provides data about "Commodity Structural Quantity - Extension" in SAP S/4HANA. It reads from 1 data source (cmm_struc_qty) and exposes 4 fields with key fields Product, Plant, Commodity.

Data Sources (1)

SourceAliasJoin Type
cmm_struc_qty Persistence from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ECMMDTYSTRUQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #EXTENSION view
EndUserText.label Commodity Structural Quantity - Extension view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product cmm_struc_qty product Product Sold
KEY Plant cmm_struc_qty plant Valuation Area
KEY Commodity cmm_struc_qty commodity Commodity Code
IsActiveEntity

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 E_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.
-- SQL view name: ECMMDTYSTRUQTY

CREATE VIEW E_CommodityStructuralQuantity AS
SELECT
  Persistence.product AS Product,
  Persistence.plant AS Plant,
  Persistence.commodity AS Commodity,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity
FROM cmm_struc_qty AS Persistence
;

Learn More