SEPMRA_C_CurrencyValueHelp

DDL: SEPMRA_C_CURRENCYVALUEHELP Type: view

Currency

SEPMRA_C_CurrencyValueHelp is a CDS View that provides data about "Currency" in SAP S/4HANA. It reads from 1 data source (I_Currency) and exposes 2 fields with key field Currency.

Data Sources (1)

SourceAliasJoin Type
I_Currency Currency from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName SEPMRACCURRVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Currency view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Currency view
Search.searchable true view
AccessControl.authorizationCheck #NOT_REQUIRED view
UI.headerInfo.typeName Currency view
UI.headerInfo.typeNamePlural Currencies view
UI.headerInfo.typeImageUrl sap-icon: title: { type: #STANDARD, value: view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Currency I_Currency Currency
CurrencyT
@AbapCatalog: {
  sqlViewName:  'SEPMRACCURRVH',
  compiler.compareFilter: true
}

@ClientHandling: {
  type:      #CLIENT_DEPENDENT,
  algorithm: #SESSION_VARIABLE
}

@ObjectModel: {
  representativeKey: 'Currency',
  usageType: {
    serviceQuality: #B,
    sizeCategory:   #S,
    dataClass:      #CUSTOMIZING
  }
}

@EndUserText.label: 'Currency'


@Search.searchable: true

@AccessControl.authorizationCheck: #NOT_REQUIRED  -- no data access restriction needed: this is a simple code list

@UI.headerInfo: {
  typeName:       'Currency',
  typeNamePlural: 'Currencies',
  typeImageUrl:   'sap-icon://lead',

  title:          { type: #STANDARD, value: 'Currency' }
}

define view SEPMRA_C_CurrencyValueHelp
  as select from I_Currency as Currency

{
      @Search:      {
        defaultSearchElement: true,
        ranking:              #HIGH,
        fuzzinessThreshold:   0.75
      }
      @UI.lineItem: [
        { position: 1, importance: #HIGH, type: #STANDARD }
      ]
      @UI.identification: [
        { position: 1, importance: #HIGH, type: #STANDARD }
      ]
      @ObjectModel: {
        text.element: ['CurrencyT']
      }
  key Currency.Currency,

      @Search: {
        defaultSearchElement: true,
        ranking: #HIGH,
        fuzzinessThreshold: 0.8
      }
      @Consumption: {
        groupWithElement: 'Currency'
      }
      @Semantics: {
        text: true
      }
      @EndUserText: {
         label:     'Name',
         quickInfo: 'Currency Name'
      }
      _Text[1: Language = $session.system_language].CurrencyName as CurrencyT
}
where
  Currency.CurrencyISOCode = Currency.Currency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CURRENCY",
"I_CURRENCYTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/