P_ServiceDocItemNote

DDL: P_SERVICEDOCITEMNOTE Type: view_entity COMPOSITE Package: CRMS4_SERV_COMMON

Service Transaction Notes

P_ServiceDocItemNote is a Composite CDS View that provides data about "Service Transaction Notes" in SAP S/4HANA. It reads from 4 data sources (I_ServiceDocumentItemEnhcd, I_ServiceDocumentLongText, I_ServiceDocumentItemEnhcd, I_TextObject) and exposes 10 fields with key fields ServiceDocumentItemUUID, TextObjectType, Language, TextObjectType, Language. Part of development package CRMS4_SERV_COMMON.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd _ServiceDocumentItemEnhcd inner
I_ServiceDocumentLongText new union
I_ServiceDocumentItemEnhcd ServiceDocumentEnhcd inner
I_TextObject TextObject from

Annotations (8)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Service Transaction Notes view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentItemUUID I_ServiceDocumentItemEnhcd ServiceDocumentItemUUID
KEY TextObjectType I_TextObject TextObjectType
KEY Language I_TextObject Language
TextObjectCategory I_TextObject TextObjectCategory
CreatedByUser I_TextObject CreatedByUser
KEY TextObjectType I_ServiceDocumentLongText TextObjectType
KEY Language I_ServiceDocumentLongText Language
TextObjectCategory I_ServiceDocumentLongText TextObjectCategory
CreatedByUser
LastChangedByUser 
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Service Transaction Notes'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
define view entity P_ServiceDocItemNote  as select from I_TextObject as TextObject
inner join I_ServiceDocumentItemEnhcd as _ServiceDocumentItemEnhcd on _ServiceDocumentItemEnhcd.ServiceDocumentItemCharUUID = TextObject.TextObjectKey
 {  
    key _ServiceDocumentItemEnhcd.ServiceDocumentItemUUID,
    key TextObject.TextObjectType,
    key TextObject.Language,
    TextObject.TextObjectCategory,
    TextObject.CreatedByUser,
    TextObject.LastChangedByUser
//    CreationDate,

//    CreationTime,

//    LastChangeDate,

//    LastChangeTime


}
where TextObject.TextObjectCategory = 'CRM_ORDERI' 

union select from I_ServiceDocumentLongText as new
  inner join     I_ServiceDocumentItemEnhcd  as ServiceDocumentEnhcd on ServiceDocumentEnhcd.ServiceDocument = new.ServiceDocument
                                                           and ServiceDocumentEnhcd.ServiceDocumentItem = new.ServiceDocumentItem
{
  key ServiceDocumentEnhcd.ServiceDocumentItemUUID as ServiceDocumentItemUUID,
  key new.TextObjectType,
  key new.Language,
  new.TextObjectCategory,
  cast( new.SrvcDocLongTextCreatedByUser as tdfuser ) as CreatedByUser,
  cast( new.SrvcDocLongTextChangedByUser as tdfuser ) as LastChangedByUser
//  tstmp_to_dats( new.SrvcDocLongTxtCreationDateTime,

//                      abap_user_timezone($session.user, $session.client,'NULL' ),

//                      $session.client,

//                      'NULL' )  as CreationDate,

//    tstmp_to_tims( new.SrvcDocLongTxtCreationDateTime,

//                      abap_user_timezone($session.user, $session.client,'NULL' ),

//                      $session.client,

//                      'NULL' )  as CreationTime,

//  tstmp_to_dats( new.SrvcDocLongTextChangedDateTime,

//                      abap_user_timezone($session.user, $session.client,'NULL' ),

//                      $session.client,

//                      'NULL' )  as LastChangeDate,

//    tstmp_to_tims( new.SrvcDocLongTextChangedDateTime,

//                      abap_user_timezone($session.user, $session.client,'NULL' ),

//                      $session.client,

//                      'NULL' )  as LastChangeTime

                      
} where new.TextObjectCategory = 'CRM_ORDERI'

Learn More