P_SERVICEITEMTEXTOBJECT

CDS View

P_SERVICEITEMTEXTOBJECT is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ServiceDocItemNote view from COMPOSITE Service Document Item for Note 
@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: 'PTEXTOBJECT'
//@EndUserText.label: 'Text Object'

//@Analytics.dataExtraction.enabled : true

@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@VDM.private: true

define view P_ServiceItemTextObject
  as select from stxh
  left outer to one join I_ServiceDocumentItem as ServiceDocumentItem on ServiceDocumentItem.ServiceDocumentItemCharUUID = stxh.tdname
  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,
      
      //substring( stxh.tdname, 1, 32 ) as TextObjectKeyUUID,

      ServiceDocumentItem.ServiceDocumentItemUUID as ServiceDocumentItemUUID,
      tdfuser                         as CreatedByUser,
      tdfdate                         as CreationDate,
      tdftime                         as CreationTime,
      tdluser                         as LastChangedByUser,
      tdldate                         as LastChangeDate,
      tdltime                         as LastChangeTime,

      _TextObjectType,
      _TextObjectCategory,
      _Language

}
where
  stxh.tdobject = 'CRM_ORDERI'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEM",
"STXH"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTCATEGORY",
"I_TEXTOBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More