I_InsurClmClaimValueHelp

DDL: I_INSURCLMCLAIMVALUEHELP SQL: IICLCLAIMVH Type: view COMPOSITE Package: ICL_VDM_SUBCLAIMMAINTAIN

Claim Value Help

I_InsurClmClaimValueHelp is a Composite CDS View that provides data about "Claim Value Help" in SAP S/4HANA. It reads from 1 data source (I_InsuranceClaim) and exposes 21 fields with key field InsuranceClaim. It has 5 associations to related views. It is exposed through 1 OData service (ICL_CLAIMITEM). Part of development package ICL_VDM_SUBCLAIMMAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_InsuranceClaim I_InsuranceClaim from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_InsurClmPolicyHolderInquiry _PolicyHolder $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim
[0..1] I_InsurClmStatus _ClaimStatus $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts
[0..*] I_InsurClmIncdntTypeText _IncidentTypeText $projection.InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType
[1..1] I_InsurClmInsuredVehInquiry _InsuredVehicle $projection.InsuranceClaim = _InsuredVehicle.InsuranceContract
[1..1] I_InsurClmProdNameVH _ProductName $projection.InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IICLCLAIMVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Claim Value Help view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_CLAIMITEM ICL_UI_CLAIMITEM V2 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
InsuranceClaimForEdit InsuranceClaim Claim
InsurancePolicy _PolicySnapshot InsurancePolicy Policy
InsuranceContract InsuranceContract Contract
InsurClmPolicyProduct InsurClmPolicyProduct
InsurClmPolicyProdGeneration InsurClmPolicyProdGeneration
InsurClmPlcyProdName Policy Product
InsurClmType InsurClmType Claim Type
CreatedByUser CreatedByUser
InsurClmContractStartDateTime
InsurClmContractEndDateTime
InsurClmLifeCycSts InsurClmLifeCycSts
InsurClmLifeCycStsName Claim Status
InsurClmIncdntType InsurClmIncdntType
InsurClmIncdntTypeName Incident Type
InsurClmDateOfLoss InsurClmDateOfLoss Date of Loss
InsurClmAuthznGrp InsurClmAuthznGrp
InsurClmCauseOfLoss InsurClmCauseOfLoss
InsurClmPolicyHolderName _PolicyHolder InsurClmPolicyHolderName Policy Holder Name
InsurClmVehiclePlateNumber _InsuredVehicle InsurClmVehiclePlateNumber Plate Number
InsurClmInsrdVehMakeModelText
@AbapCatalog.sqlViewName: 'IICLCLAIMVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Claim Value Help'

@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.dataCategory:#VALUE_HELP
@Search.searchable: true

define view I_InsurClmClaimValueHelp
  as select from I_InsuranceClaim
  association [0..1] to I_InsurClmPolicyHolderInquiry as _PolicyHolder     on  $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim

  association [0..1] to I_InsurClmStatus              as _ClaimStatus      on  $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts

  association [0..*] to I_InsurClmIncdntTypeText      as _IncidentTypeText on  $projection.InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType

  association [1..1] to I_InsurClmInsuredVehInquiry   as _InsuredVehicle   on  $projection.InsuranceClaim = _InsuredVehicle.InsuranceContract

  association [1..1] to I_InsurClmProdNameVH          as _ProductName      on  $projection.InsurClmPolicyProduct        = _ProductName.InsurClmPolicyProduct
                                                                           and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration

{
      //I_InsuranceClaim

      
  key InsuranceClaim,
 @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 1
      @EndUserText.label: 'Claim'
      @UI.selectionField: [{position: 10 }]
      @UI.identification: [{position: 10 }]
  InsuranceClaim                                                                                                         as InsuranceClaimForEdit,
  
  
  
      @EndUserText.label: 'Policy'
      @UI.selectionField: [{position: 20 }]
      @UI.identification: [{position: 20 }]
      _PolicySnapshot.InsurancePolicy                                                                    as InsurancePolicy,
      @EndUserText.label: 'Contract'
      @UI.selectionField: [{position: 30 }]
      @UI.identification: [{position: 30 }]
      InsuranceContract,
      @UI.hidden: true
      InsurClmPolicyProduct,
      @UI.hidden: true
      InsurClmPolicyProdGeneration,
      @EndUserText.label: 'Policy Product'
      @UI.selectionField: [{position: 40 }]
      @UI.identification: [{position: 40 }]
      _ProductName[Language = $session.system_language].InsurClmPlcyProdName                             as InsurClmPlcyProdName,
      @EndUserText.label: 'Claim Type'
      @UI.selectionField: [{position: 50 }]
      @UI.identification: [{position: 50 }]
      InsurClmType,
      @UI.hidden: true
      CreatedByUser,
      @UI.hidden: true
      cast( _PolicySnapshot.InsurClmContractStartDateTime as icl_achangetime_fiori preserving type )     as InsurClmContractStartDateTime,
      @UI.hidden: true
      cast( _PolicySnapshot.InsurClmContractEndDateTime as icl_achangetime_fiori preserving type )       as InsurClmContractEndDateTime,
      @UI.hidden: true
      InsurClmLifeCycSts,
      @EndUserText.label: 'Claim Status'
      @UI.selectionField: [{position: 60 }]
      @UI.identification: [{position: 60 }]
      _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName        as InsurClmLifeCycStsName,
      @UI.hidden: true
      InsurClmIncdntType,
      @EndUserText.label: 'Incident Type'
      @UI.selectionField: [{position: 70 }]
      @UI.identification: [{position: 70 }]
      _IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName                    as InsurClmIncdntTypeName,
      @EndUserText.label: 'Date of Loss'
      @UI.selectionField: [{position: 80 }]
      @UI.identification: [{position: 80 }]
      InsurClmDateOfLoss,
      @UI.hidden: true
      InsurClmAuthznGrp,
      @UI.hidden: true
      InsurClmCauseOfLoss,
      @EndUserText.label: 'Policy Holder Name'
      @UI.selectionField: [{position: 90 }]
      @UI.identification: [{position: 90 }]
      _PolicyHolder.InsurClmPolicyHolderName                                                             as InsurClmPolicyHolderName,
      @EndUserText.label: 'Plate Number'
      @UI.selectionField: [{position: 95 }]
      @UI.identification: [{position: 95 }]
      _InsuredVehicle.InsurClmVehiclePlateNumber                                                         as InsurClmVehiclePlateNumber,
      @UI.hidden: true
      concat_with_space(_InsuredVehicle.InsurClmVehicleMfrTxt,_InsuredVehicle.InsurClmVehicleModelTxt,1) as InsurClmInsrdVehMakeModelText
      /* Associations */
      //I_InsuranceClaim


}