i_MarketIdentifierCodeText

DDL: I_MARKETIDENTIFIERCODETEXT SQL: IMICT Type: view BASIC Package: FTR_BASIS_VDM

Market Identifier Code - Text

i_MarketIdentifierCodeText is a Basic CDS View that provides data about "Market Identifier Code - Text" in SAP S/4HANA. It reads from 1 data source (tbac_mict) and exposes 5 fields with key fields MarketIdentifierCode, Language. It has 2 associations to related views. Part of development package FTR_BASIS_VDM.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
tbac_mict tbac_mict from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_MarketIdentCode _MarketIdentifierCode $projection.MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode

Annotations (11)

NameValueLevelField
EndUserText.label Market Identifier Code - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMICT view
ObjectModel.representativeKey MarketIdentifierCode view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MarketIdentifierCode mic
KEY Language langu
MarketIdentifierCodeName text
_MarketIdentifierCode _MarketIdentifierCode
_Language _Language 
@EndUserText.label: 'Market Identifier Code - Text'
//@Analytics.dataCategory: #TEXT

@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #CHECK

@AbapCatalog.sqlViewName: 'IMICT'
@ObjectModel.representativeKey: 'MarketIdentifierCode'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,#LANGUAGE_DEPENDENT_TEXT]

define view i_MarketIdentifierCodeText
   as select from tbac_mict
 
   association [0..1] to I_Language as _Language  on $projection.Language = _Language.Language
   association [1..1] to I_MarketIdentCode as _MarketIdentifierCode
        on $projection.MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode
{
 
    key mic as MarketIdentifierCode,
    @Semantics.language: true
    key langu as Language,
    @Semantics.text: true
        text as MarketIdentifierCodeName,
        _MarketIdentifierCode,
        _Language
  
}

Learn More