I_ServiceDocumentLongText

DDL: I_SERVICEDOCUMENTLONGTEXT Type: view_entity BASIC Package: CRMS4_TEXT

Service Transaction Long Texts

I_ServiceDocumentLongText is a Basic CDS View that provides data about "Service Transaction Long Texts" in SAP S/4HANA. It reads from 2 data sources (crms4d_text, crms4d_text) and exposes 51 fields with key field ServiceDocumentLongTextUUID. It has 6 associations to related views. Part of development package CRMS4_TEXT.

2 data source(s) 51 fields

Data Sources (2)

SourceAliasJoin Type
crms4d_text ServiceDocumentText from
crms4d_text ServiceDocumentText union_all

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_TextObjectCategory _TextObjectCategory $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
[1..1] I_TextObjectType _TextObjectType $projection.TextObjectCategory = _TextObjectType.TextObjectCategory and $projection.TextObjectType = _TextObjectType.TextObjectType
[1..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_CustMgmtBusObjType _ServiceObjType $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType
[1..1] I_TextObjectCategory _ReferenceTextObjectCategory $projection.ReferenceTextObjectCategory = _ReferenceTextObjectCategory.TextObjectCategory
[1..1] I_TextObjectType _ReferenceTextObjectType $projection.ReferenceTextObjectCategory = _ReferenceTextObjectType.TextObjectCategory and $projection.ReferenceTextObjectType = _ReferenceTextObjectType.TextObjectType

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Service Transaction Long Texts view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentLongTextUUID crms4d_text text_uuid
TextObjectCategory crms4d_text text_object
TextObjectType crms4d_text text_id
Language crms4d_text language
ServiceObjectType crms4d_text objtype_h
ServiceDocument crms4d_text object_id
ServiceDocumentItem crms4d_text number_int
SrvcDocLongTextMimeType crms4d_text mimetype
ServiceDocumentLongText ReferenceServiceDocumentText text_content
ReferenceTextObjectCategory crms4d_text ref_text_object
ReferenceTextObjectType crms4d_text ref_text_id
ReferenceLongTextKey crms4d_text ref_text_name
ReferenceServiceObjectType crms4d_text ref_objtype_h
ReferenceServiceDocument crms4d_text ref_object_id
ReferenceServiceDocumentItem crms4d_text ref_number_int
SrvcDocLogTextIdentifier crms4d_text log_timestamp
SrvcDocLongTxtCreationDateTime crms4d_text created_at
SrvcDocLongTextCreatedByUser crms4d_text created_by
SrvcDocLongTextChangedDateTime crms4d_text changed_at
SrvcDocLongTextChangedByUser crms4d_text changed_by
_TextObjectCategory _TextObjectCategory
_TextObjectType _TextObjectType
_Language _Language
_ServiceObjType _ServiceObjType
_ReferenceTextObjectCategory _ReferenceTextObjectCategory
text_uuidasServiceDocumentLongTextUUID
TextObjectCategory crms4d_text text_object
TextObjectType crms4d_text text_id
Language crms4d_text language
ServiceObjectType crms4d_text objtype_h
ServiceDocument crms4d_text object_id
ServiceDocumentItem crms4d_text number_int
SrvcDocLongTextMimeType crms4d_text mimetype
ServiceDocumentLongText crms4d_text text_content
ReferenceTextObjectCategory crms4d_text ref_text_object
ReferenceTextObjectType crms4d_text ref_text_id
ReferenceLongTextKey crms4d_text ref_text_name
ReferenceServiceObjectType crms4d_text ref_objtype_h
ReferenceServiceDocument crms4d_text ref_object_id
ReferenceServiceDocumentItem crms4d_text ref_number_int
SrvcDocLogTextIdentifier crms4d_text log_timestamp
SrvcDocLongTxtCreationDateTime crms4d_text created_at
SrvcDocLongTextCreatedByUser crms4d_text created_by
SrvcDocLongTextChangedDateTime crms4d_text changed_at
SrvcDocLongTextChangedByUser crms4d_text changed_by
_TextObjectCategory _TextObjectCategory
_TextObjectType _TextObjectType
_Language _Language
_ServiceObjType _ServiceObjType
_ReferenceTextObjectCategory _ReferenceTextObjectCategory
_ReferenceTextObjectType _ReferenceTextObjectType 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Service Transaction Long Texts'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
define view entity I_ServiceDocumentLongText 
// Texts which are reference texts to a One Order text

  as select from crms4d_text as ServiceDocumentText
                 left outer to one join crms4d_text as ReferenceServiceDocumentText
                 on  ReferenceServiceDocumentText.text_object = ServiceDocumentText.ref_text_object
                 and ReferenceServiceDocumentText.text_id     = ServiceDocumentText.ref_text_id
                 and ReferenceServiceDocumentText.language    = ServiceDocumentText.language
                 and ReferenceServiceDocumentText.objtype_h   = ServiceDocumentText.ref_objtype_h
                 and ReferenceServiceDocumentText.object_id   = ServiceDocumentText.ref_object_id
                 and ReferenceServiceDocumentText.number_int  = ServiceDocumentText.ref_number_int
  
  association [1..1] to I_TextObjectCategory      as _TextObjectCategory          on  $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
  association [1..1] to I_TextObjectType          as _TextObjectType              on  $projection.TextObjectCategory = _TextObjectType.TextObjectCategory
                                                                                  and $projection.TextObjectType     = _TextObjectType.TextObjectType
  association [1..1] to I_Language                as _Language                    on  $projection.Language = _Language.Language
  association [1..1] to I_CustMgmtBusObjType      as _ServiceObjType              on  $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType
  association [1..1] to I_TextObjectCategory      as _ReferenceTextObjectCategory on  $projection.ReferenceTextObjectCategory = _ReferenceTextObjectCategory.TextObjectCategory                                                                         
  association [1..1] to I_TextObjectType          as _ReferenceTextObjectType     on  $projection.ReferenceTextObjectCategory = _ReferenceTextObjectType.TextObjectCategory
                                                                                  and $projection.ReferenceTextObjectType     = _ReferenceTextObjectType.TextObjectType  
{
  key ServiceDocumentText.text_uuid               as ServiceDocumentLongTextUUID,
      @ObjectModel.foreignKey.association: '_TextObjectCategory'
      ServiceDocumentText.text_object             as TextObjectCategory,
      @ObjectModel.foreignKey.association: '_TextObjectType'
      ServiceDocumentText.text_id                 as TextObjectType,
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language:true
      ServiceDocumentText.language                as Language,
      @ObjectModel.foreignKey.association: '_ServiceObjType'
      ServiceDocumentText.objtype_h               as ServiceObjectType,
      ServiceDocumentText.object_id               as ServiceDocument,
      ServiceDocumentText.number_int              as ServiceDocumentItem,
      ServiceDocumentText.mimetype                as SrvcDocLongTextMimeType,
      ReferenceServiceDocumentText.text_content   as ServiceDocumentLongText,
      @ObjectModel.foreignKey.association: '_ReferenceTextObjectCategory'
      ServiceDocumentText.ref_text_object         as ReferenceTextObjectCategory,
      @ObjectModel.foreignKey.association: '_ReferenceTextObjectType'
      ServiceDocumentText.ref_text_id             as ReferenceTextObjectType,
      ServiceDocumentText.ref_text_name           as ReferenceLongTextKey,
      ServiceDocumentText.ref_objtype_h           as ReferenceServiceObjectType,
      ServiceDocumentText.ref_object_id           as ReferenceServiceDocument,
      ServiceDocumentText.ref_number_int          as ReferenceServiceDocumentItem,
      ServiceDocumentText.log_timestamp           as SrvcDocLogTextIdentifier,
      ServiceDocumentText.created_at              as SrvcDocLongTxtCreationDateTime,
      ServiceDocumentText.created_by              as SrvcDocLongTextCreatedByUser,
      ServiceDocumentText.changed_at              as SrvcDocLongTextChangedDateTime,
      ServiceDocumentText.changed_by              as SrvcDocLongTextChangedByUser,
      
      _TextObjectCategory,
      _TextObjectType,
      _Language,
      _ServiceObjType,
      _ReferenceTextObjectCategory,
      _ReferenceTextObjectType
}
  where ServiceDocumentText.ref_text_object = 'CRM_ORDERH' or
        ServiceDocumentText.ref_text_object = 'CRM_ORDERI'
        
// All other texts (texts which are not reference texts, or which have a reference to a foreign text object)

  union all select from crms4d_text as ServiceDocumentText
  
  association [1..1] to I_TextObjectCategory      as _TextObjectCategory          on  $projection.TextObjectCategory = _TextObjectCategory.TextObjectCategory
  association [1..1] to I_TextObjectType          as _TextObjectType              on  $projection.TextObjectCategory = _TextObjectType.TextObjectCategory
                                                                                  and $projection.TextObjectType     = _TextObjectType.TextObjectType
  association [1..1] to I_Language                as _Language                    on  $projection.Language = _Language.Language
  association [1..1] to I_CustMgmtBusObjType      as _ServiceObjType              on  $projection.ServiceObjectType = _ServiceObjType.BusinessObjectType
  association [1..1] to I_TextObjectCategory      as _ReferenceTextObjectCategory on  $projection.ReferenceTextObjectCategory = _ReferenceTextObjectCategory.TextObjectCategory                                                                         
  association [1..1] to I_TextObjectType          as _ReferenceTextObjectType     on  $projection.ReferenceTextObjectCategory = _ReferenceTextObjectType.TextObjectCategory
                                                                                  and $projection.ReferenceTextObjectType     = _ReferenceTextObjectType.TextObjectType  
{
  key ServiceDocumentText.text_uuid          as ServiceDocumentLongTextUUID,
//      @ObjectModel.foreignKey.association: '_TextObjectCategory'

      ServiceDocumentText.text_object        as TextObjectCategory,
//      @ObjectModel.foreignKey.association: '_TextObjectType'

      ServiceDocumentText.text_id            as TextObjectType,
//      @ObjectModel.foreignKey.association: '_Language'

      ServiceDocumentText.language           as Language,
//      @ObjectModel.foreignKey.association: '_ServiceObjType'

      ServiceDocumentText.objtype_h          as ServiceObjectType,
      ServiceDocumentText.object_id          as ServiceDocument,
      ServiceDocumentText.number_int         as ServiceDocumentItem,
      ServiceDocumentText.mimetype           as SrvcDocLongTextMimeType,
      ServiceDocumentText.text_content       as ServiceDocumentLongText,
//      @ObjectModel.foreignKey.association: '_ReferenceTextObjectCategory'

      ServiceDocumentText.ref_text_object    as ReferenceTextObjectCategory,
//      @ObjectModel.foreignKey.association: '_ReferenceTextObjectType'

      ServiceDocumentText.ref_text_id        as ReferenceTextObjectType,
      ServiceDocumentText.ref_text_name      as ReferenceLongTextKey,
      ServiceDocumentText.ref_objtype_h      as ReferenceServiceObjectType,
      ServiceDocumentText.ref_object_id      as ReferenceServiceDocument,
      ServiceDocumentText.ref_number_int     as ReferenceServiceDocumentItem,
      ServiceDocumentText.log_timestamp      as SrvcDocLogTextIdentifier,
      ServiceDocumentText.created_at         as SrvcDocLongTxtCreationDateTime,
      ServiceDocumentText.created_by         as SrvcDocLongTextCreatedByUser,
      ServiceDocumentText.changed_at         as SrvcDocLongTextChangedDateTime,
      ServiceDocumentText.changed_by         as SrvcDocLongTextChangedByUser,
      
      _TextObjectCategory,
      _TextObjectType,
      _Language,
      _ServiceObjType,
      _ReferenceTextObjectCategory,
      _ReferenceTextObjectType
}
  where ServiceDocumentText.ref_text_object <> 'CRM_ORDERH' and
        ServiceDocumentText.ref_text_object <> 'CRM_ORDERI'

Learn More