I_ACMCommodityDetails

DDL: I_ACMCOMMODITYDETAILS SQL: IACMCOMDET Type: view COMPOSITE
4 Fields 1 Data Sources

Interface for Commodity Details

I_ACMCommodityDetails is a Composite CDS View that provides data about "Interface for Commodity Details" in SAP S/4HANA. It reads from 1 data source (I_ACMMaterialMstrData) and exposes 4 fields with key field Material.

Data Sources (1)

SourceAliasJoin Type
I_ACMMaterialMstrData Material from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IACMCOMDET view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #CDS_MODELING_DATA_SOURCE view
EndUserText.label Interface for Commodity Details view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
MaterialBaseUnit MaterialBaseUnit Valuation Unit
Commodity I_ACMMaterialMstrData Commodity Commodity Code
CommodityName CommodityName

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_ACMCommodityDetails.
-- 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: IACMCOMDET

CREATE VIEW I_ACMCommodityDetails AS
SELECT
  Material,
  MaterialBaseUnit,
  Material.Commodity AS Commodity,
  CommodityName
FROM I_ACMMaterialMstrData AS Material
;

Learn More