P_ServiceItemTextObject

DDL: P_SERVICEITEMTEXTOBJECT SQL: PTEXTOBJECT Type: view BASIC

P_ServiceItemTextObject is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (stxh) and exposes 14 fields with key fields TextObjectKey, TextObjectType, TextObjectCategory, Language. It has 3 associations to related views.

1 data source(s) 14 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 (9)

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 PTEXTOBJECT view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
VDM.private true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TextObjectKey stxh tdname
KEY TextObjectType stxh tdid
KEY TextObjectCategory stxh tdobject
KEY Language stxh tdspras
ServiceDocumentItemUUID ServiceDocumentItem ServiceDocumentItemUUID
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: '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