I_InvgCsMNote

DDL: I_INVGCSMNOTE SQL: IINVGCSMNOTE Type: view BASIC

Basic View For ICM Object Note

I_InvgCsMNote is a Basic CDS View that provides data about "Basic View For ICM Object Note" in SAP S/4HANA. It reads from 2 data sources (crms4t_text_temp, stxh) and exposes 13 fields with key fields InvgCsMTextObjectType, InvgCsMTextObjectID, InvgCsMTextTypeCode, InvgCsMTextLanguageCode.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
crms4t_text_temp _icmtext left_outer
stxh _stxh from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINVGCSMNOTE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic View For ICM Object Note view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMTextObjectType tdobject
KEY InvgCsMTextObjectID
KEY InvgCsMTextTypeCode tdid
KEY InvgCsMTextLanguageCode tdspras
InvgCsMTextTitle tdtitle
InvgCsMTextCreatedByUserID tdfuser
InvgCsMTextCreatedDate tdfdate
InvgCsMTextCreatedTime tdftime
InvgCsMTextChangedByUserID tdluser
InvgCsMTextChangedDate tdldate
InvgCsMTextChangedTime tdltime
InvgCsMTextDateTime
InvgCsMTextContent crms4t_text_temp text 
@AbapCatalog.sqlViewName: 'IINVGCSMNOTE'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic View For ICM Object Note'
@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_InvgCsMNote
  as select from    stxh             as _stxh
    left outer join crms4t_text_temp as _icmtext on _icmtext.id = '????' //this join should never satisfy the join condition. intention is to fetch an empty row with left outer join


{

  key    tdobject                  as InvgCsMTextObjectType,
         //key cast( tdname as char20)                                                                   as  InvgCsMTextObjectID,

  key    cast( tdname as char32 )  as InvgCsMTextObjectID,
  key    tdid                      as InvgCsMTextTypeCode,
  key    tdspras                   as InvgCsMTextLanguageCode,
         tdtitle                   as InvgCsMTextTitle,
         tdfuser                   as InvgCsMTextCreatedByUserID,
         tdfdate                   as InvgCsMTextCreatedDate,
         tdftime                   as InvgCsMTextCreatedTime,
         tdluser                   as InvgCsMTextChangedByUserID,
         tdldate                   as InvgCsMTextChangedDate,
         tdltime                   as InvgCsMTextChangedTime,
         LEFT(RIGHT(tdname,17),14) as InvgCsMTextDateTime,
         _icmtext.text             as InvgCsMTextContent

}
where
     tdobject = 'ICM_OBJ'
  or tdobject = 'ICM_LOC'
  or tdobject = 'ICM_REL'

Learn More