I_TextObjectTypeText

DDL: I_TEXTOBJECTTYPETEXT SQL: ITXTOBJECTTYPTXT Type: view BASIC Package: VDM_FND

Text Object Type - Text

I_TextObjectTypeText is a Basic CDS View that provides data about "Text Object Type - Text" in SAP S/4HANA. It reads from 1 data source (ttxit) and exposes 7 fields with key fields TextObjectCategory, TextObjectType, Language. It has 3 associations to related views. Part of development package VDM_FND.

Data Sources (1)

SourceAliasJoin Type
ttxit ttxit from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_TextObjectCategory _TextObjectCategory $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_TextObjectType _TextObjectType $projection.TextObjectType = _TextObjectType.TextObjectType and $projection.TextObjectCategory = _TextObjectType.TextObjectCategory

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey TextObjectType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.sqlViewName ITXTOBJECTTYPTXT view
EndUserText.label Text Object Type - Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TextObjectCategory ttxit tdobject
KEY TextObjectType ttxit tdid
KEY Language ttxit tdspras
TextObjectTypeName ttxit tdtext
_TextObjectType _TextObjectType
_TextObjectCategory _TextObjectCategory
_Language _Language
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'TextObjectType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.sqlViewName: 'ITXTOBJECTTYPTXT'
@EndUserText.label: 'Text Object Type - Text'
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #LANGUAGE_DEPENDENT_TEXT ]

define view I_TextObjectTypeText as select from ttxit  
association [0..1] to I_TextObjectCategory as _TextObjectCategory on
    $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
association [0..1] to I_Language as _Language on
    $projection.Language = _Language.Language  
association [0..1] to I_TextObjectType as _TextObjectType on 
    $projection.TextObjectType = _TextObjectType.TextObjectType and
    $projection.TextObjectCategory = _TextObjectType.TextObjectCategory

{
  @ObjectModel.foreignKey.association: '_TextObjectCategory'
  key ttxit.tdobject as TextObjectCategory, 
 
@ObjectModel.foreignKey.association: '_TextObjectType' 
  key ttxit.tdid as TextObjectType, 
  
  @Semantics.language: true
@ObjectModel.foreignKey.association: '_Language'
  key ttxit.tdspras as Language, 
  @Semantics.text: true
  ttxit.tdtext as TextObjectTypeName,
  
  _TextObjectType,
  _TextObjectCategory,
  _Language 
}