I_ServiceDocItemNote

DDL: I_SERVICEDOCITEMNOTE Type: view_entity COMPOSITE Package: CRMS4_REPORT

Service Document Item for Note

I_ServiceDocItemNote is a Composite CDS View that provides data about "Service Document Item for Note" in SAP S/4HANA. It reads from 1 data source (P_ServiceItemTextObject) and exposes 15 fields with key fields TextObjectKey, TextObjectType, TextObjectCategory, Language. It has 1 association to related views. Part of development package CRMS4_REPORT.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
P_ServiceItemTextObject P_ServiceItemTextObject from

Associations (1)

CardinalityTargetAliasCondition
[0..1] crms4t_note_temp _inotetemp _inotetemp.id = '????'

Annotations (7)

NameValueLevelField
EndUserText.label Service Document Item for Note view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TextObjectKey TextObjectKey
KEY TextObjectType TextObjectType
KEY TextObjectCategory TextObjectCategory
KEY Language Language
ServiceDocumentItemUUID ServiceDocumentItemUUID
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
ServiceOrderNoteText _inotetemp text
_Language _Language
_TextObjectCategory _TextObjectCategory
_TextObjectType _TextObjectType 
@EndUserText.label: 'Service Document Item for Note'
@VDM: {
  viewType:  #COMPOSITE
//  lifecycle.contract.type: #PUBLIC_LOCAL_API

}
@AccessControl.authorizationCheck: #CHECK


@ObjectModel:{
  supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE],
  usageType.serviceQuality: #C,
  usageType.sizeCategory : #XL ,
  usageType.dataClass: #TRANSACTIONAL
}

//@Analytics.dataCategory: #DIMENSION


@Metadata.ignorePropagatedAnnotations: true

define view entity I_ServiceDocItemNote
  as select from    P_ServiceItemTextObject //I_TextObject - Note Changes

  //  left outer join crms4t_note_temp as _inotetemp on _inotetemp.id = '????' //this join should never satisfy the join condition. intention is to fetch an empty row with left outer join

 association [0..1] to crms4t_note_temp as _inotetemp on _inotetemp.id = '????'
{

      //I_TextObject

  key TextObjectKey,
  key TextObjectType,
  key TextObjectCategory,
  key Language,
      //hextobin( TextObjectKeyUUID ) as ServiceDocumentItemUUID,

      ServiceDocumentItemUUID,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      _inotetemp.text               as ServiceOrderNoteText,
      /* Associations */
      //I_TextObject

      _Language,
      _TextObjectCategory,
      _TextObjectType

}
where
  Language = $session.system_language
 // and TextObjectType = '0002'

Learn More