I_TEXT_TEMPLATES

CDS View

Text Templates

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

Used by 12 CDS view(s) 8 fields

CDS Views using this table (12)

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_PurchasingInfoRecordNote view_entity from BASIC Purchasing Info Record General Notes
I_Purctritnotes view from COMPOSITE Purchase Contract Item Notes
I_Purctrnotes view from COMPOSITE Purchase Contract Header Notes
I_PurgInfoRecdOrganizationNote view_entity from BASIC Purchasing Info Recd Organisation 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,ArchObjectNumber,TextObjectKey 7
KEY DocumentText DocumentText,TextObjectType 8
KEY Language Language 8
KEY TechnicalObjectType TechnicalObjectType 6
DisplayModeOfTextTypeInPurg DisplayModeOfTextTypeInPurg 3
FixedIndicator FixedIndicator 6
NoteDescription NoteDescription 7
TextIsAdoptedFromReference TextIsAdoptedFromReference 3 
@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
}

Learn More