I_TEXT_TEMPLATES

CDS View

Text Templates

I_TEXT_TEMPLATES is a CDS View in S/4HANA. Text Templates. It contains 8 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 8 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_DataMigrationLogItemText view inner BASIC Data Migration Log Item Approval Text
I_PurchaseReqnHeaderNotes view from BASIC Purchase Requisition Header Note Basic
I_PurchaseReqnItemText view from BASIC Pur Reqn Item Text Basic View
I_Purctritnotes view from COMPOSITE Purchase Contract Item Notes
I_Purctrnotes view from BASIC Purchase Contract Header Notes
I_PurgInfoRecdOrgPOText view from BASIC Purchase Info Record PO - Text
I_SchedgAgrmtHeaderNotes view from BASIC Scheduling Agreement Header Notes
I_SchedgAgrmtItemNotes view from BASIC Scheduling Agreement Item Notes
R_PurchaseOrderItemNote view from BASIC Purchase Order Item Notes
R_PurchaseOrderNote view from BASIC Purchase Order Notes

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ArchitecturalObjectNumber ArchitecturalObjectNumber 4
KEY DocumentText DocumentText 5
KEY Language Language 5
KEY TechnicalObjectType TechnicalObjectType 4
DisplayModeOfTextTypeInPurg DisplayModeOfTextTypeInPurg 2
FixedIndicator FixedIndicator 4
NoteDescription NoteDescription 4
TextIsAdoptedFromReference TextIsAdoptedFromReference 2 
@AbapCatalog.sqlViewName: 'ITEXTTEMPLATES'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Text Templates'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #B
define view I_Text_Templates
  as select from stxh
  association [1..1] to I_TextObjectPlainLongText as _LongText on  $projection.TechnicalObjectType       = _LongText.TextObjectCategory
                                                               and $projection.ArchitecturalObjectNumber = _LongText.TextObjectKey
                                                               and $projection.DocumentText              = _LongText.TextObjectType
                                                               and $projection.Language                  = _LongText.Language
{

       @EndUserText.label: 'Texts: Application Object'
  key  tdobject                           as TechnicalObjectType,

       @EndUserText.label: 'Name'
  key  tdname                             as ArchitecturalObjectNumber,

       @EndUserText.label: 'Text ID'
  key  tdid                               as DocumentText,

  key  tdspras                            as Language,

//       cast('' as text_description)       as NoteDescription,

       
       _LongText.PlainLongText            as NoteDescription,

       cast('' as fixie)                  as FixedIndicator,

       cast('' as mmpur_text_displaymode) as DisplayModeOfTextTypeInPurg,

       cast('' as mmpur_t_text_isadopted) as TextIsAdoptedFromReference
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECTPLAINLONGTEXT",
"STXH"
],
"ASSOCIATED":
[
"I_TEXTOBJECTPLAINLONGTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More