I_InsurClmFactCaptureInquiry

DDL: I_INSURCLMFACTCAPTUREINQUIRY SQL: IICLFACTCAPIN Type: view COMPOSITE Package: ICL_VDM_CLAIMINQUIRY

Sachverhalt

I_InsurClmFactCaptureInquiry is a Composite CDS View that provides data about "Sachverhalt" in SAP S/4HANA. It reads from 1 data source (I_InsurClmFactCapture) and exposes 12 fields with key fields InsuranceClaim, InsurClmFactCaptureCategory, InsurClmSubobject, InsurClmFactCaptureQstn, InsurClmFactCaptureAnswer. Part of development package ICL_VDM_CLAIMINQUIRY.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurClmFactCapture I_InsurClmFactCapture from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICLFACTCAPIN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Sachverhalt view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
KEY InsurClmFactCaptureCategory InsurClmFactCaptureCategory
KEY InsurClmSubobject InsurClmSubobject
KEY InsurClmFactCaptureQstn InsurClmFactCaptureQstn
KEY InsurClmFactCaptureAnswer InsurClmFactCaptureAnswer
InsurClmFactCaptureQstnSqnc InsurClmFactCaptureQstnSqnc
InsurClmFactCaptureSqncVersion InsurClmFactCaptureSqncVersion
InsurClmFactCaptureSqncVariant InsurClmFactCaptureSqncVariant
InsurClmFactCaptureQstnLongTxt
_FactCaptureAnswer _FactCaptureAnswer
_FactCaptureQstn _FactCaptureQstn
_Claim _Claim 
@AbapCatalog.sqlViewName: 'IICLFACTCAPIN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@EndUserText.label: 'Sachverhalt'
define view I_InsurClmFactCaptureInquiry
  as select from I_InsurClmFactCapture
{
  key InsuranceClaim,
  key InsurClmFactCaptureCategory,
  key InsurClmSubobject,
  key InsurClmFactCaptureQstn,
  key InsurClmFactCaptureAnswer,

      InsurClmFactCaptureQstnSqnc,
      InsurClmFactCaptureSqncVersion,
      InsurClmFactCaptureSqncVariant,

      //_FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnShrtTxt,

      _FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnLongTxt as InsurClmFactCaptureQstnLongTxt,

      //_FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerShortText,

      // _FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerLongText    as InsurClmFactAnswerLongText,


      case
      when _FactCaptureTxtAnswer.InsurClmFactCaptureAnswer is null
       then _FactCaptureAnswer._FactCaptureAnswerT[Language = $session.system_language].InsurClmFactAnswerLongText
       else
       _FactCaptureTxtAnswer.InsurClmFactCaptureTextAnswer
       end                                                                                                        as InsurClmFactAnswerLongText,


      _FactCaptureAnswer,
      _FactCaptureQstn,
      _Claim

}

Learn More