I_ACMCommodityItem

DDL: I_ACMCOMMODITYITEM Type: view_entity BASIC
4 Fields 1 Data Sources

Interface for wb2dcomsub data

I_ACMCommodityItem is a Basic CDS View that provides data about "Interface for wb2dcomsub data" in SAP S/4HANA. It reads from 1 data source (wb2_d_comsub) and exposes 4 fields with key fields ACMContractNumber, ACMContractItemNumber, ACMTrdgContrCmmdtySubitem.

Data Sources (1)

SourceAliasJoin Type
wb2_d_comsub wb2_d_comsub from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Interface for wb2dcomsub data view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ACMContractNumber tkonn Trading Contract
KEY ACMContractItemNumber tposn Item Number
KEY ACMTrdgContrCmmdtySubitem tposn_com Com. item num.
Material matnr Vehicle Model

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_ACMCommodityItem.
-- 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_ACMCommodityItem AS
SELECT
  tkonn AS ACMContractNumber,
  tposn AS ACMContractItemNumber,
  tposn_com AS ACMTrdgContrCmmdtySubitem,
  matnr AS Material
FROM wb2_d_comsub
;

Learn More