I_CMMDTYTEXT
Commodity - Text
I_CMMDTYTEXT is a CDS View in S/4HANA. Commodity - Text. It contains 1 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CmmdtyDrvtvContrMicPhys | view | left_outer | BASIC | View for DCS, MIC and Commodity |
| I_CmmdtyIntCounterpartySubAcct | view | left_outer | BASIC | Subaccounts assgn. to int. Counterparty |
Fields (1)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| CommodityName | CommodityName | 1 |
@EndUserText.label: 'Commodity - Text'
//@Analytics.dataCategory: #DIMENSION
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #CHECK
@AbapCatalog.sqlViewName: 'ICMMDTYT'
@ObjectModel.representativeKey: 'Commodity'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.preserveKey: true
define view I_CmmdtyText
as select from tbac_physcommt
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [1..1] to I_Cmmdty as _Commodity
on $projection.Commodity = _Commodity.Commodity
{
key commodity as Commodity,
@Semantics.language: true
key langu as Language,
@Semantics.text: true
text as CommodityName,
_Language,
_Commodity
}