I_InsurClmLossLocDesc

DDL: I_INSURCLMLOSSLOCDESC SQL: ICLCLMLOSSLOCDSC Type: view BASIC

Schadenortbeschreibung

I_InsurClmLossLocDesc is a Basic CDS View that provides data about "Schadenortbeschreibung" in SAP S/4HANA. It reads from 2 data sources (icltext_repl, sgbt_nte_cont) and exposes 10 fields with key field InsuranceClaim. It has 1 association to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
icltext_repl ClaimLossLocDesc from
sgbt_nte_cont ExternalNote inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InsuranceClaim _Claim ClaimLossLocDesc.claim = _Claim.InsuranceClaim

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICLCLMLOSSLOCDSC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schadenortbeschreibung view
VDM.viewType #BASIC view
ObjectModel.representativeKey InsuranceClaim view
ObjectModel.semanticKey InsuranceClaim view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim icltext_repl claim
InsurClmApplObjectCategory icltext_repl tdobject
InsurClmApplObjectTypeID icltext_repl tdid
NoteID sgbt_nte_cont noteid
CreatedByUser sgbt_nte_cont creator
CreationDateTime sgbt_nte_cont created
LastChangedByUser sgbt_nte_cont changer
ChangedOnDateTime sgbt_nte_cont changed
InsurClmDescriptionOfLossLoc sgbt_nte_cont content
_Claim _Claim 
@AbapCatalog.sqlViewName: 'ICLCLMLOSSLOCDSC'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Schadenortbeschreibung'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'InsuranceClaim'
@ObjectModel.semanticKey:       'InsuranceClaim'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT

define view I_InsurClmLossLocDesc
  as select from icltext_repl  as ClaimLossLocDesc
  //  join  I_TextObjectPlainLongText as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = ClaimLossLocDesc.claim

  //                                                              and _TextObjectPlainLongText.TextObjectCategory = 'CLAIM'

  //                                                              and _TextObjectPlainLongText.Language           =  $session.system_language

  //                                                              and _TextObjectPlainLongText.TextObjectType     = ClaimLossLocDesc.tdid

  //

  //  association [1..1] to I_InsuranceClaim as _Claim on ClaimLossLocDesc.claim = _Claim.InsuranceClaim

  //{

  //  key    ClaimLossLocDesc.claim                                                     as InsuranceClaim,

  ////  key    ClaimLossLocDesc.noteid                                                    as InsuranceClaimNoteID,

  //  ClaimLossLocDesc.tdobject                                                  as InsurClmApplObjectCategory,

  //  ClaimLossLocDesc.tdid                                                      as InsurClmApplObjectTypeID,

  //  _TextObjectPlainLongText.Language                                          as InsurClmLossDescLanguage,

  //  _TextObjectPlainLongText.PlainLongText                                     as InsurClmDescriptionOfLossLoc,

  //  _Claim

  //}

  //where

  //  tdid = '0002'

    inner join   sgbt_nte_cont as ExternalNote on ClaimLossLocDesc.noteid = ExternalNote.noteid
  association [1..1] to I_InsuranceClaim as _Claim on ClaimLossLocDesc.claim = _Claim.InsuranceClaim
{
  key    ClaimLossLocDesc.claim    as InsuranceClaim,
         ClaimLossLocDesc.tdobject as InsurClmApplObjectCategory,
         ClaimLossLocDesc.tdid     as InsurClmApplObjectTypeID,
         ExternalNote.noteid       as NoteID,
         ExternalNote.creator      as CreatedByUser,
         ExternalNote.created      as CreationDateTime,
         ExternalNote.changer      as LastChangedByUser,
         ExternalNote.changed      as ChangedOnDateTime,
         ExternalNote.content      as InsurClmDescriptionOfLossLoc,

         _Claim
}

where
      ClaimLossLocDesc.tdobject = 'CLAIM'
  and ClaimLossLocDesc.tdid     = '0002'

Learn More