I_SrvcDocHeaderLongText

DDL: I_SRVCDOCHEADERLONGTEXT Type: view_entity BASIC Package: CRMS4_REPORT

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 12 fields with key field ServiceDocumentLongTextUUID. It has 4 associations to related views. Part of development package CRMS4_REPORT.

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 (9)

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
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (12)

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
SrvcDocLongTextMimeType crms4d_text mimetype
_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
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET, 
                                      #SQL_DATA_SOURCE, 
                                      #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
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,
      @EndUserText: { label: 'Long Text', quickInfo: 'Long Text' }
      ServiceDocumentText.text_content as ServiceDocumentLongText,
      ServiceDocumentText.mimetype     as SrvcDocLongTextMimeType,

      _TextObjectCategory,
      _TextObjectType,
      _Language,
      _ServiceObjType
}
where
  ServiceDocumentText.text_object = 'CRM_ORDERH'