I_DepreciationKeyText

DDL: I_DEPRECIATIONKEYTEXT SQL: IFIDEPRKEYT Type: view BASIC

Depreciation Key - Text

I_DepreciationKeyText is a Basic CDS View that provides data about "Depreciation Key - Text" in SAP S/4HANA. It reads from 1 data source (t090nat) and exposes 6 fields with key fields ChartOfDepreciation, DepreciationKey, Language. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
t090nat t090nat from

Associations (2)

CardinalityTargetAliasCondition
[1] I_ChartOfDepreciation _ChartOfDepreciation $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IFIDEPRKEYT view
EndUserText.label Depreciation Key - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey DepreciationKey view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChartOfDepreciation t090nat afapl
KEY DepreciationKey t090nat afasl
KEY Language t090nat spras
DepreciationKeyName
_ChartOfDepreciation _ChartOfDepreciation
_Language _Language 
@AbapCatalog.sqlViewName: 'IFIDEPRKEYT'
@EndUserText.label: 'Depreciation Key - Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { representativeKey: 'DepreciationKey',
                dataCategory: #TEXT,
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING,
                modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
                supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT]
              }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true

define view I_DepreciationKeyText
  as select from t090nat

  association [1]    to I_ChartOfDepreciation as _ChartOfDepreciation on $projection.ChartOfDepreciation = _ChartOfDepreciation.ChartOfDepreciation
  association [0..1] to I_Language            as _Language            on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_ChartOfDepreciation'
  key t090nat.afapl                      as ChartOfDepreciation,
  key t090nat.afasl                      as DepreciationKey,
      @Semantics.language
  key t090nat.spras                      as Language,

      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      cast(t090nat.afatxt as fis_afatxt) as DepreciationKeyName,

      _ChartOfDepreciation,
      _Language
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T090NAT"
],
"ASSOCIATED":
[
"I_CHARTOFDEPRECIATION",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More