R_SrvcConfItemLongTextTP

DDL: R_SRVCCONFITEMLONGTEXTTP Type: view_entity TRANSACTIONAL

Long Text for Service Conf Item

R_SrvcConfItemLongTextTP is a Transactional CDS View that provides data about "Long Text for Service Conf Item" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItem, I_ServiceDocumentLongText) and exposes 26 fields with key fields ServiceConfirmation, ServiceConfirmationItem, TextObjectType, Language, SrvcDocLogTextIdentifier. It has 1 association to related views.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItem ServiceConfItem inner
I_ServiceDocumentLongText ServiceItemText from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_ServiceConfirmationTP _ServiceConfirmationTP $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation

Annotations (8)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Long Text for Service Conf Item view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation I_ServiceDocumentItem ServiceDocument
KEY ServiceConfirmationItem I_ServiceDocumentItem ServiceDocumentItem
KEY TextObjectType I_ServiceDocumentLongText TextObjectType
KEY Language I_ServiceDocumentLongText Language
KEY SrvcDocLogTextIdentifier I_ServiceDocumentLongText SrvcDocLogTextIdentifier
ServiceDocumentLongTextUUID I_ServiceDocumentLongText ServiceDocumentLongTextUUID
TextObjectCategory I_ServiceDocumentLongText TextObjectCategory
SrvcDocLongTextMimeType I_ServiceDocumentLongText SrvcDocLongTextMimeType
SrvcConfItemLongText I_ServiceDocumentLongText ServiceDocumentLongText
ReferenceTextObjectCategory I_ServiceDocumentLongText ReferenceTextObjectCategory
ReferenceTextObjectType I_ServiceDocumentLongText ReferenceTextObjectType
ReferenceLongTextKey I_ServiceDocumentLongText ReferenceLongTextKey
ReferenceServiceObjectType I_ServiceDocumentLongText ReferenceServiceObjectType
ReferenceServiceDocument I_ServiceDocumentLongText ReferenceServiceDocument
ReferenceServiceDocumentItem I_ServiceDocumentLongText ReferenceServiceDocumentItem
SrvcDocLongTxtCreationDateTime I_ServiceDocumentLongText SrvcDocLongTxtCreationDateTime
SrvcDocLongTextCreatedByUser I_ServiceDocumentLongText SrvcDocLongTextCreatedByUser
SrvcDocLongTextChangedDateTime I_ServiceDocumentLongText SrvcDocLongTextChangedDateTime
SrvcDocLongTextChangedByUser I_ServiceDocumentLongText SrvcDocLongTextChangedByUser
_Language I_ServiceDocumentLongText _Language
_ReferenceTextObjectCategory I_ServiceDocumentLongText _ReferenceTextObjectCategory
_ReferenceTextObjectType I_ServiceDocumentLongText _ReferenceTextObjectType
_TextObjectCategory I_ServiceDocumentLongText _TextObjectCategory
_TextObjectType I_ServiceDocumentLongText _TextObjectType
_ServiceConfirmationItemTP _ServiceConfirmationItemTP
_ServiceConfirmationTP _ServiceConfirmationTP 
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@Metadata: {
  ignorePropagatedAnnotations: true
}

@ObjectModel: {
   usageType: {dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L}
  //dataCategory: #TEXT

}
@EndUserText.label: 'Long Text for Service Conf Item'
define view entity R_SrvcConfItemLongTextTP as select from
I_ServiceDocumentLongText as ServiceItemText
    inner join   I_ServiceDocumentItem     as ServiceConfItem on  ServiceItemText.ServiceDocument                 = ServiceConfItem.ServiceDocument
                                                               and ServiceItemText.ServiceDocumentItem             = ServiceConfItem.ServiceDocumentItem
                                                               and ServiceItemText.TextObjectCategory              = 'CRM_ORDERI'
                                                               and ServiceConfItem.ServiceObjectType              = 'BUS2000117'

  association  to parent R_ServiceConfirmationItemTP as _ServiceConfirmationItemTP on  $projection.ServiceConfirmation     = _ServiceConfirmationItemTP.ServiceConfirmation
                                                                           and $projection.ServiceConfirmationItem = _ServiceConfirmationItemTP.ServiceConfirmationItem
  association [1..1] to R_ServiceConfirmationTP    as _ServiceConfirmationTP     on  $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation

{
  key ServiceConfItem.ServiceDocument as ServiceConfirmation,
  key ServiceConfItem.ServiceDocumentItem as ServiceConfirmationItem,
  key ServiceItemText.TextObjectType,
        @Semantics.language:true
  key ServiceItemText.Language,
  key ServiceItemText.SrvcDocLogTextIdentifier,
      ServiceItemText.ServiceDocumentLongTextUUID,

     // ServiceOrderItem.ServiceObjectType,


      ServiceItemText.TextObjectCategory,
      
      
      ServiceItemText.SrvcDocLongTextMimeType,
      @Semantics.text:true
      ServiceItemText.ServiceDocumentLongText  as SrvcConfItemLongText,

      ServiceItemText.ReferenceTextObjectCategory,
      ServiceItemText.ReferenceTextObjectType,
      ServiceItemText.ReferenceLongTextKey,
      ServiceItemText.ReferenceServiceObjectType,
      ServiceItemText.ReferenceServiceDocument,
      ServiceItemText.ReferenceServiceDocumentItem,

      ServiceItemText.SrvcDocLongTxtCreationDateTime,
      ServiceItemText.SrvcDocLongTextCreatedByUser,
      ServiceItemText.SrvcDocLongTextChangedDateTime,
      ServiceItemText.SrvcDocLongTextChangedByUser,

      /* Associations */
      ServiceItemText._Language,
      ServiceItemText._ReferenceTextObjectCategory,
      ServiceItemText._ReferenceTextObjectType,
      ServiceItemText._TextObjectCategory,
      ServiceItemText._TextObjectType,
      _ServiceConfirmationItemTP,
      _ServiceConfirmationTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEDOCUMENTITEM",
"I_SERVICEDOCUMENTLONGTEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_TEXTOBJECTCATEGORY",
"I_TEXTOBJECTTYPE",
"R_SERVICECONFIRMATIONITEMTP",
"R_SERVICECONFIRMATIONTP"
],
"BASE":
[
"I_SERVICEDOCUMENTLONGTEXT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More