I_SrvcDocHeaderLongText

DDL: I_SRVCDOCHEADERLONGTEXT Type: view_entity BASIC

ESH Long text search

I_SrvcDocHeaderLongText is a Basic CDS View that provides data about "ESH Long text search" in SAP S/4HANA. It reads from 1 data source (crms4d_text) and exposes 11 fields with key field ServiceDocumentLongTextUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
crms4d_text ServiceDocumentText from

Associations (4)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ESH Long text search 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 (11)

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
ServiceDocumentLongText crms4d_text text_content
_TextObjectCategory _TextObjectCategory
_TextObjectType _TextObjectType
_Language _Language
_ServiceObjType _ServiceObjType
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ESH Long text search'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
define view entity I_SrvcDocHeaderLongText as 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
{
  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.text_content as ServiceDocumentLongText,
      _TextObjectCategory,
      _TextObjectType,
      _Language,
      _ServiceObjType
}
where
  ServiceDocumentText.text_object = 'CRM_ORDERH'