I_INSURCLMFACTCAPTURE

CDS View

Sachverhalt des Schaden-/Leistungsfalls

I_INSURCLMFACTCAPTURE is a CDS View in S/4HANA. Sachverhalt des Schaden-/Leistungsfalls. It contains 15 fields. 16 CDS views read from this table.

Used by 16 CDS view(s) 15 fields

CDS Views using this table (16)

ViewTypeJoinVDMDescription
I_InsurClm1stNotifFactCapture view from COMPOSITE Schadenmeldung - Sachverhalt
I_InsurClmFactCaptureInquiry view from COMPOSITE Sachverhalt
I_InsurClmFactsItems view from COMPOSITE SFC Items
I_InsurClmFNOLDriverSFCTP view_entity inner TRANSACTIONAL Facts Captured Driver FNOL - TP
I_InsurClmFNOLFactsDmgdVehTP view_entity from TRANSACTIONAL Facts Capture for Damaged Object
I_InsurClmFNOLFactsLossLocTP view_entity from TRANSACTIONAL Loss Location Facts Captured
I_InsurClmFNOLFactsOriginTP view_entity from COMPOSITE Origin of Loss Facts Captured
I_InsurClmFNOLInjuredSFCTP view_entity inner TRANSACTIONAL Injured Person SFC FNOL - TP
I_InsurClmPrtcpntSFCTP view_entity inner TRANSACTIONAL SFC in Claim Participant - TP
I_InsurClmSrvcsPrtcpntSFC view_entity inner COMPOSITE Claim Srvcs SFC For Participant - Cube
R_InsurClmFactCaptureTP view_entity from TRANSACTIONAL Insurance Claim Fact Capture - TP
R_InsurClmFNOLDriverSFCTP view_entity inner TRANSACTIONAL FNOL Driver SFC
R_InsurClmFNOLFactsDmgdVehTP view_entity from TRANSACTIONAL FNOL Damaged Vehicle SFC
R_InsurClmFNOLFactsLossLocTP view_entity from TRANSACTIONAL FNOL SFC for Loss Location
R_InsurClmFNOLFactsOriginTP view_entity from TRANSACTIONAL FNOL SFC for Origin of Loss
R_InsurClmFNOLInjuredSFCTP view_entity inner TRANSACTIONAL FNOL Injured Person SFC

Fields (15)

KeyField CDS FieldsUsed in Views
KEY InsuranceClaim InsuranceClaim 5
KEY InsuranceContract InsuranceContract 3
KEY InsurClmFactCaptureAnswer InsurClmFactCaptureAnswer,InsurClmFactCaptureAnswForEdit 6
KEY InsurClmFactCaptureCategory InsurClmFactCaptureCategory 7
KEY InsurClmFactCaptureQstn InsurClmFactCaptureQstn,InsurClmFactCaptureQstnForEdit 6
KEY InsurClmSubobject InsurClmSFCSubobj 1
KEY InsurFactsSubobject InsurFactsSubobject 6
_Claim _Claim 1
_FactCaptureAnswer _FactCaptureAnswer 5
_FactCaptureQstn _FactCaptureQstn 5
_FactCaptureTxtAnswer _FactCaptureTxtAnswer 1
InsurClmFactCaptureQstnPos InsurClmFactCaptureQstnPos 6
InsurClmFactCaptureQstnSqnc InsurClmFactCaptureQstnSqnc 6
InsurClmFactCaptureSqncVariant InsurClmFactCaptureSqncVariant 6
InsurClmFactCaptureSqncVersion InsurClmFactCaptureSqncVersion 6 
@AbapCatalog.sqlViewName: 'ICLMFACTSCAPT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sachverhalt des Schaden-/Leistungsfalls'

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
}

define view I_InsurClmFactCapture
  as select from icllossdes

  association [1]    to I_InsuranceClaim               as _Claim                on  $projection.InsuranceClaim = _Claim.InsuranceClaim

  association [1..1] to I_InsurClmFactCaptureQstn      as _FactCaptureQstn      on  $projection.InsurClmFactCaptureQstnSqnc    = _FactCaptureQstn.InsurClmFactCaptureQstnSqnc
                                                                                and $projection.InsurClmFactCaptureSqncVersion = _FactCaptureQstn.InsurClmFactCaptureSqncVersion
                                                                                and $projection.InsurClmFactCaptureQstn        = _FactCaptureQstn.InsurClmFactCaptureQstn

  association [1..1] to I_InsurClmFactCaptureAnswer    as _FactCaptureAnswer    on  $projection.InsurClmFactCaptureQstnSqnc    = _FactCaptureAnswer.InsurClmFactCaptureQstnSqnc
                                                                                and $projection.InsurClmFactCaptureSqncVersion = _FactCaptureAnswer.InsurClmFactCaptureSqncVersion
                                                                                and $projection.InsurClmFactCaptureQstn        = _FactCaptureAnswer.InsurClmFactCaptureQstn
                                                                                and $projection.InsurClmFactCaptureAnswer      = _FactCaptureAnswer.InsurClmFactCaptureAnswer
                                                                                and $projection.InsurClmFactCaptureSqncVariant = _FactCaptureAnswer.InsurClmFactCaptureSqncVariant

  association [0..1] to I_InsurClmFactCaptureTxtAnswer as _FactCaptureTxtAnswer on  $projection.InsuranceClaim              = _FactCaptureTxtAnswer.InsuranceClaim
                                                                                and $projection.InsurClmFactCaptureCategory = _FactCaptureTxtAnswer.InsurClmFactCaptureCategory
                                                                                and $projection.InsurClmSubobject           = _FactCaptureTxtAnswer.InsurClmSubobject
                                                                                and $projection.InsurClmFactCaptureQstn     = _FactCaptureTxtAnswer.InsurClmFactCaptureQstn
                                                                                and $projection.InsurClmFactCaptureAnswer   = _FactCaptureTxtAnswer.InsurClmFactCaptureAnswer

{

  key claim       as InsuranceClaim,
  key _Claim.InsuranceContract,
  key factscat    as InsurClmFactCaptureCategory,
  key subobject   as InsurClmSubobject,
  key subobject   as InsurFactsSubobject,
  key question    as InsurClmFactCaptureQstn,
  key answer      as InsurClmFactCaptureAnswer,
      avariant    as InsurClmFactCaptureSqncVariant,
      qposition   as InsurClmFactCaptureQstnPos,
      queseq      as InsurClmFactCaptureQstnSqnc,
      version     as InsurClmFactCaptureSqncVersion,
      @Semantics.dateTime: true
      cast( changetime as icl_achangetime_fiori preserving type )   as InsurClmChangeDateTime,
      changedby   as InsuranceClaimChangedByUser,
      deleted     as InsurClmDatabaseLineStatus,

      _Claim,
      _FactCaptureQstn,
      _FactCaptureAnswer,
      _FactCaptureTxtAnswer

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

Learn More