I_INSURCLMNOTEEXTN

CDS View

Notizen - erweiterte Daten

I_INSURCLMNOTEEXTN is a CDS View in S/4HANA. Notizen - erweiterte Daten. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_InsurClm1stNotifNote view from BASIC Schadenmeldung - Notiz
I_InsurClmFNOLNoteTP view_entity from TRANSACTIONAL Notes Fnol - TP
I_InsurClmNote view from COMPOSITE Fallnotiz
R_InsuranceClaimNoteTP view_entity from TRANSACTIONAL Insurance Claim Note - TP
R_InsurClmFNOLNoteTP view_entity from TRANSACTIONAL FNOL Notes 
@AbapCatalog.sqlViewName: 'ICLCLMNOTEXT'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Notizen - erweiterte Daten'
@VDM.viewType: #BASIC
@ObjectModel.semanticKey:  [ 'InsuranceClaim', 'InsurClmNote', 'InsurClmNoteYear' ]
@ClientHandling.algorithm: #SESSION_VARIABLE

// just testing for enterprise search

@ObjectModel.dataCategory: #TEXT

define view I_InsurClmNoteExtn
  as select from           iclnote       as ClaimNote
    left outer to one join sgbt_nte_cont as ExternalNote on ClaimNote.noteid = ExternalNote.noteid

  association [1..1] to I_InsuranceClaim as _Claim on ClaimNote.claim = _Claim.InsuranceClaim
{

  key ClaimNote.claim       as InsuranceClaim,
  key ClaimNote.objyr       as InsurClmNoteYear,
  key ClaimNote.objno       as InsurClmNote,
      ClaimNote.authgrp     as InsurClmNoteAuthznGrp,
      ClaimNote.notetype    as InsurClmNoteType,
      ClaimNote.subclaim    as InsurClmSubclm,
      ClaimNote.validstatus as InsurClmNoteStatus,
      ExternalNote.noteid   as NoteID,
      // just testing for enterprise search

      @Semantics.text: true
      ExternalNote.title    as InsurClmNoteTitle,
      ExternalNote.creator  as CreatedByUser,
      ExternalNote.created  as CreationDateTime,
      ExternalNote.changer  as LastChangedByUser,
      ExternalNote.changed  as ChangedOnDateTime,
      ExternalNote.content  as InsurClmNoteText,

      _Claim
}

where
      ClaimNote.active  =  #icl_active.'A'
  and ClaimNote.deleted <> #boole.'X'

Learn More