I_TextObject

DDL: I_TEXTOBJECT SQL: ITEXTOBJECT Type: view BASIC

Text Object

I_TextObject is a Basic CDS View that provides data about "Text Object" in SAP S/4HANA. It reads from 1 data source (stxh) and exposes 13 fields with key fields TextObjectKey, TextObjectType, TextObjectCategory, Language. It has 3 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
stxh stxh from

Associations (3)

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

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey TextObjectKey view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName ITEXTOBJECT view
EndUserText.label Text Object view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TextObjectKey stxh tdname
KEY TextObjectType stxh tdid
KEY TextObjectCategory stxh tdobject
KEY Language stxh tdspras
CreatedByUser tdfuser
CreationDate tdfdate
CreationTime tdftime
LastChangedByUser tdluser
LastChangeDate tdldate
LastChangeTime tdltime
_TextObjectType _TextObjectType
_TextObjectCategory _TextObjectCategory
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.representativeKey: 'TextObjectKey'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'ITEXTOBJECT'
@EndUserText.label: 'Text Object'
@Analytics.dataExtraction.enabled : true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC

define view I_TextObject as select from stxh 

association [0..1] to I_TextObjectType as _TextObjectType on
    $projection.TextObjectType = _TextObjectType.TextObjectType and
    $projection.TextObjectCategory = _TextObjectType.TextObjectCategory
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      
{
  key stxh.tdname as TextObjectKey , 
  @ObjectModel.foreignKey.association: '_TextobjectType'
  key stxh.tdid as TextObjectType, 
  @ObjectModel.foreignKey.association: '_Textobjectcategory'
  key stxh.tdobject as TextObjectCategory,
  @Semantics.language: true
@ObjectModel.foreignKey.association: '_Language' 
  key stxh.tdspras  as Language,
  tdfuser as CreatedByUser,
  tdfdate as CreationDate,
  tdftime as CreationTime,
  tdluser as LastChangedByUser,
  tdldate as LastChangeDate,
  tdltime as LastChangeTime,
  
  _TextObjectType,
  _TextObjectCategory,
  _Language
 
}   
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"STXH"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTCATEGORY",
"I_TEXTOBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More