R_SrvcConfLongTextTP

DDL: R_SRVCCONFLONGTEXTTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_CONFIRMATION_RAP

Long Text for Service Confirmation

R_SrvcConfLongTextTP is a Transactional CDS View that provides data about "Long Text for Service Confirmation" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocument, I_ServiceDocumentLongText) and exposes 16 fields with key fields ServiceConfirmation, TextObjectType, Language, SrvcDocLogTextIdentifier. Part of development package CRMS4_SERVICE_CONFIRMATION_RAP.

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocument ServiceConfirmation inner
I_ServiceDocumentLongText ServiceText from

Annotations (8)

NameValueLevelField
EndUserText.label Long Text for Service Confirmation view
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

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ServiceConfirmation I_ServiceDocumentLongText ServiceDocument
KEY TextObjectType I_ServiceDocumentLongText TextObjectType
KEY Language I_ServiceDocumentLongText Language
KEY SrvcDocLogTextIdentifier I_ServiceDocumentLongText SrvcDocLogTextIdentifier
TextObjectCategory I_ServiceDocumentLongText TextObjectCategory
ServiceObjectType I_ServiceDocumentLongText ServiceObjectType
SrvcDocLongTextMimeType I_ServiceDocumentLongText SrvcDocLongTextMimeType
SrvcConfLongText I_ServiceDocumentLongText ServiceDocumentLongText
ReferenceTextObjectCategory I_ServiceDocumentLongText ReferenceTextObjectCategory
ReferenceTextObjectType I_ServiceDocumentLongText ReferenceTextObjectType
ReferenceLongTextKey I_ServiceDocumentLongText ReferenceLongTextKey
SrvcDocLongTxtCreationDateTime I_ServiceDocumentLongText SrvcDocLongTxtCreationDateTime
SrvcDocLongTextCreatedByUser I_ServiceDocumentLongText SrvcDocLongTextCreatedByUser
SrvcDocLongTextChangedDateTime I_ServiceDocumentLongText SrvcDocLongTextChangedDateTime
SrvcDocLongTextChangedByUser I_ServiceDocumentLongText SrvcDocLongTextChangedByUser
_ServiceConfirmationTP _ServiceConfirmationTP
@EndUserText.label: 'Long Text for Service Confirmation'
@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

}
define view entity R_SrvcConfLongTextTP as select from I_ServiceDocumentLongText as ServiceText
    inner join   I_ServiceDocument         as ServiceConfirmation on  ServiceText.ServiceDocument       = ServiceConfirmation.ServiceDocument
                                                            and ServiceText.ServiceDocumentItem         = '000000'
                                                           and ServiceText.TextObjectCategory           = 'CRM_ORDERH'
                                                           and ServiceConfirmation.ServiceObjectType    = 'BUS2000117'

  association to parent R_ServiceConfirmationTP as _ServiceConfirmationTP on $projection.ServiceConfirmation = _ServiceConfirmationTP.ServiceConfirmation

{
  key ServiceText.ServiceDocument as ServiceConfirmation,
  key ServiceText.TextObjectType,
      @Semantics.language:true 
  key ServiceText.Language,
  key ServiceText.SrvcDocLogTextIdentifier,
      ServiceText.TextObjectCategory,
      //ServiceText.ServiceDocumentLongTextUUID, //! Not mapped in map_from_text() 

      

      ServiceText.ServiceObjectType,

      ServiceText.SrvcDocLongTextMimeType,
      @Semantics.text:true
      ServiceText.ServiceDocumentLongText as SrvcConfLongText,
      ServiceText.ReferenceTextObjectCategory,
      ServiceText.ReferenceTextObjectType,
      ServiceText.ReferenceLongTextKey,

      ServiceText.SrvcDocLongTxtCreationDateTime,
      ServiceText.SrvcDocLongTextCreatedByUser,
      ServiceText.SrvcDocLongTextChangedDateTime,
      ServiceText.SrvcDocLongTextChangedByUser,

      /* Associations */
      _ServiceConfirmationTP
}
where ServiceText.ServiceObjectType = 'BUS2000117'