R_InsurClmFNOLDriverSFCTP

DDL: R_INSURCLMFNOLDRIVERSFCTP Type: view_entity TRANSACTIONAL

FNOL Driver SFC

R_InsurClmFNOLDriverSFCTP is a Transactional CDS View that provides data about "FNOL Driver SFC" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmFactCapture, I_InsurClmFNOLVehDriver) and exposes 27 fields with key fields InsuranceClaim, InsuranceContract, InsurClmSubobject, InsurClmFactCaptureCategory, InsurFactsSubobject. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurClmFactCapture _Facts inner
I_InsurClmFNOLVehDriver _part from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_InsurClmFNOLTP _InsurClaim $projection.InsuranceClaim = _InsurClaim.InsuranceClaim

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Driver SFC view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsuranceClaim view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim
KEY InsuranceContract
KEY InsurClmSubobject I_InsurClmFNOLVehDriver InsurClmSubobject
KEY InsurClmFactCaptureCategory I_InsurClmFactCapture InsurClmFactCaptureCategory
KEY InsurFactsSubobject I_InsurClmFactCapture InsurFactsSubobject
KEY InsurClmFactCaptureQstn I_InsurClmFactCapture InsurClmFactCaptureQstn
KEY InsurClmFactCaptureAnswer I_InsurClmFactCapture InsurClmFactCaptureAnswer
InsurClmFactFreeTextAnswerCat
InsurClmFactCaptureQstnPos I_InsurClmFactCapture InsurClmFactCaptureQstnPos
InsurClmFactCaptureQstnSqnc I_InsurClmFactCapture InsurClmFactCaptureQstnSqnc
InsurClmFactCaptureSqncVersion I_InsurClmFactCapture InsurClmFactCaptureSqncVersion
InsurClmFactCaptureSqncVariant I_InsurClmFactCapture InsurClmFactCaptureSqncVariant
InsurClmFactCaptureQstnCat
InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt
InsurClmFactAnswerShortText
InsurClmFactAnswerLongText
InsurClmFactCaptureTextAnswer
InsurClmFactUsrSeldAnswerKeys
InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureNextQstn
InsurClmIsHiddenFlag
_FactCaptureAnswer I_InsurClmFactCapture _FactCaptureAnswer
_FactCaptureQstn I_InsurClmFactCapture _FactCaptureQstn
_Damaged _Damaged
_InsurClaim _InsurClaim
_Driver _Driver
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'FNOL Driver SFC'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@ObjectModel: {
   semanticKey: [ 'InsuranceClaim' ],
usageType:{
  dataClass:      #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory:   #XL
}
}
@ObjectModel.sapObjectNodeType.name: 'InsuranceClaim'
define view entity R_InsurClmFNOLDriverSFCTP
  as select from I_InsurClmFNOLVehDriver as _part
    inner join   I_InsurClmFactCapture   as _Facts on  _Facts.InsuranceClaim      = _part.InsuranceClaim
                                                   and _Facts.InsurFactsSubobject = _part.InsurFactsSubobject
  association to I_InsurClmFNOLDamagedObjectTP    as _Damaged on  $projection.InsuranceClaim    = _Damaged.InsuranceClaim
                                                              and $projection.InsurClmSubobject = _Damaged.InsurClmDamagedObject
  association [1..1] to R_InsurClmFNOLTP                     as _InsurClaim       on  $projection.InsuranceClaim = _InsurClaim.InsuranceClaim
  association to parent R_InsurClmFNOLVehDriverTP as _Driver  on  $projection.InsuranceClaim      = _Driver.InsuranceClaim
                                                              and $projection.InsurClmSubobject   = _Driver.InsurClmDamagedObject
                                                              and $projection.InsurFactsSubobject = _Driver.InsurFactsSubobject
{
  key       _Facts. InsuranceClaim,
  key       _Facts. InsuranceContract,
  key       _part.InsurClmSubobject,
  key       _Facts.InsurClmFactCaptureCategory,
  key       _Facts.InsurFactsSubobject,
  key       _Facts.InsurClmFactCaptureQstn,
  key       _Facts.InsurClmFactCaptureAnswer,
            _Facts._FactCaptureAnswer.InsurClmFactFreeTextAnswerCat    as InsurClmFactFreeTextAnswerCat,
//            @ObjectModel.editableFieldFor: 'InsurClmFactCaptureQstn'

//            _Facts.InsurClmFactCaptureQstn                             as InsurClmFactCaptureQstnForEdit,

//            @ObjectModel.editableFieldFor: 'InsurClmFactCaptureAnswer'

//            _Facts.InsurClmFactCaptureAnswer                           as InsurClmFactCaptureAnswForEdit,

            _Facts.InsurClmFactCaptureQstnPos,
            _Facts.InsurClmFactCaptureQstnSqnc,
            _Facts.InsurClmFactCaptureSqncVersion,
            _Facts.InsurClmFactCaptureSqncVariant,
            _Facts._FactCaptureQstn.InsurClmFactCaptureQstnCat         as InsurClmFactCaptureQstnCat,
            _Facts._FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnShrtTxt,
            _Facts._FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnLongTxt,
            _Facts._FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerShortText,
            _Facts._FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerLongText,
            _Facts._FactCaptureTxtAnswer. InsurClmFactCaptureTextAnswer,
            _Facts._FactCaptureTxtAnswer.InsurClmFactCaptureTextAnswer as InsurClmFactUsrSeldAnswerKeys,
            _Facts._FactCaptureQstn. InsurClmFactQstnIsMltplChoice,
            _Facts._FactCaptureAnswer. InsurClmFactCaptureNextQstn,
            cast('' as xfeld preserving type )                         as InsurClmIsHiddenFlag,
            _Facts._FactCaptureAnswer,
            _Facts._FactCaptureQstn,

            _Damaged,
            _InsurClaim,
//            _Facts._Claim,

            _Driver
}
where
  _Facts. InsurClmFactCaptureCategory = 'PA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMFACTCAPTURE",
"I_INSURCLMFACTCAPTUREANSWER",
"I_INSURCLMFACTCAPTUREANSWERT",
"I_INSURCLMFACTCAPTUREQSTN",
"I_INSURCLMFACTCAPTUREQSTNTEXT",
"I_INSURCLMFACTCAPTURETXTANSWER",
"I_INSURCLMFNOLVEHDRIVER"
],
"ASSOCIATED":
[
"I_INSURCLMFACTCAPTUREANSWER",
"I_INSURCLMFACTCAPTUREQSTN",
"I_INSURCLMFNOLDAMAGEDOBJECTTP",
"R_INSURCLMFNOLTP",
"R_INSURCLMFNOLVEHDRIVERTP"
],
"BASE":
[
"I_INSURCLMFACTCAPTURE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/