I_InvgCsMNote

@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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMS4T_TEXT_TEMP",
"STXH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/