R_InsurClaimItemTP

DDL: R_INSURCLAIMITEMTP Type: view_entity TRANSACTIONAL

Insurance Claim Item - TP

R_InsurClaimItemTP is a Transactional CDS View that provides data about "Insurance Claim Item - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmItem, I_InsurClmItemEvaluation) and exposes 30 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmItem, InsurClmItemEvaluation. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurClmItem ClaimItem from
I_InsurClmItemEvaluation ClaimItemEval inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsuranceClaimItem _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmSubclm = _Extension.InsurClmSubclm and $projection.InsurClmItem = _Extension.InsurClmItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Insurance Claim Item - TP 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

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmItem InsuranceClaim
KEY InsurClmSubclm I_InsurClmItem InsurClmSubclm
KEY InsurClmItem I_InsurClmItem InsurClmItem
KEY InsurClmItemEvaluation I_InsurClmItemEvaluation InsurClmItemEvaluation
LastChangeDateTime I_InsurClmItem LastChangeDateTime
InsurClmItemCat I_InsurClmItem InsurClmItemCat
InsurClmItemType I_InsurClmItem InsurClmItemType
InsurClmCoverageType I_InsurClmItem InsurClmCoverageType
InsurBnftType I_InsurClmItem InsurBnftType
InsurClmItemStatus I_InsurClmItem InsurClmItemStatus
InsurClmItemRjcnRsn I_InsurClmItem InsurClmItemRjcnRsn
InsurClmItemDescription I_InsurClmItem InsurClmItemDescription
InsurClmItemEvalBase I_InsurClmItem InsurClmItemEvalBase
InsurClmItemEvalQuantity I_InsurClmItem InsurClmItemEvalQuantity
InsurClmItemEvalQuantityUnit I_InsurClmItem InsurClmItemEvalQuantityUnit
InsurClmItemEvalPerUnitAmt I_InsurClmItem InsurClmItemEvalPerUnitAmt
InsurClmItemEvalAmount I_InsurClmItem InsurClmItemEvalAmount
InsurClmItemEvalCurrency I_InsurClmItem InsurClmItemEvalCurrency
InsurClmItemEvalFactor I_InsurClmItem InsurClmItemEvalFactor
InsurClmItmEvalActlCshValAmt I_InsurClmItem InsurClmItmEvalActlCshValAmt
InsurClmItmEvalActlCshValPct I_InsurClmItem InsurClmItmEvalActlCshValPct
InsurClmBRFCalcExpression I_InsurClmItem InsurClmBRFCalcExpression
InsurClmItemTaxCode I_InsurClmItem InsurClmItemTaxCode
InsurClmItemSubclmRef I_InsurClmItem InsurClmItemSubclmRef
InsurClmItemRef I_InsurClmItem InsurClmItemRef
InsurClmDamagedObject I_InsurClmItem InsurClmDamagedObject
InsurClmItemEvalDate I_InsurClmItemEvaluation InsurClmItemEvalDate
InsurClmItemLiabilityRate I_InsurClmItemEvaluation InsurClmItemLiabilityRate
InsurClmItemClmdAmount I_InsurClmItemEvaluation InsurClmItemClmdAmount
_InsuranceClaim _InsuranceClaim
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Insurance Claim Item - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@ObjectModel: {
   semanticKey: [ 'InsuranceClaim' ],
usageType:{
  dataClass:      #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory:   #XL
}
}
define view entity R_InsurClaimItemTP as select from I_InsurClmItem as ClaimItem          
    inner join I_InsurClmItemEvaluation as ClaimItemEval
          on ClaimItem.InsuranceClaim         = ClaimItemEval.InsuranceClaim
          and ClaimItem.InsurClmSubclm         = ClaimItemEval.InsurClmSubclm
          and ClaimItem.InsurClmItem           = ClaimItemEval.InsurClmItem
          and ClaimItem.InsurClmItemEvaluation = ClaimItemEval.InsurClmItemEvaluation
    association to parent R_InsuranceClaimTP as _InsuranceClaim
          on $projection.InsuranceClaim = _InsuranceClaim.InsuranceClaim
    association [1..1] to E_InsuranceClaimItem   as _Extension  on  $projection.InsuranceClaim = _Extension.InsuranceClaim
                                                                and $projection.InsurClmSubclm = _Extension.InsurClmSubclm
                                                                and $projection.InsurClmItem   = _Extension.InsurClmItem
                                                            
{    
  key ClaimItem.InsuranceClaim,
  key ClaimItem.InsurClmSubclm,
  key ClaimItem.InsurClmItem,
  key ClaimItemEval.InsurClmItemEvaluation,
      ClaimItem.LastChangeDateTime            as LastChangeDateTime,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimItemCategory'
      ClaimItem.InsurClmItemCat               as InsurClmItemCat,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimItemType'
      ClaimItem.InsurClmItemType              as InsurClmItemType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimCoverageType'
      ClaimItem.InsurClmCoverageType          as InsurClmCoverageType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimBenefitType'
      ClaimItem.InsurBnftType                 as InsurBnftType,
       @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimItemStatus'
      ClaimItem.InsurClmItemStatus            as InsurClmItemStatus,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClaimItemRejectionRsn'
      ClaimItem.InsurClmItemRjcnRsn           as InsurClmItemRjcnRsn,
      ClaimItem.InsurClmItemDescription       as InsurClmItemDescription,
      @ObjectModel.sapObjectNodeTypeReference: 'InsuranceClmItemEvaluationBase'
      ClaimItem.InsurClmItemEvalBase          as InsurClmItemEvalBase,
      @Semantics.quantity.unitOfMeasure: 'InsurClmItemEvalQuantityUnit'
      ClaimItem.InsurClmItemEvalQuantity      as InsurClmItemEvalQuantity,
      ClaimItem.InsurClmItemEvalQuantityUnit  as InsurClmItemEvalQuantityUnit,
      @Semantics.amount.currencyCode: 'InsurClmItemEvalCurrency'
      ClaimItem.InsurClmItemEvalPerUnitAmt    as InsurClmItemEvalPerUnitAmt,
      @Semantics.amount.currencyCode: 'InsurClmItemEvalCurrency'
      ClaimItem.InsurClmItemEvalAmount        as InsurClmItemEvalAmount,
      ClaimItem.InsurClmItemEvalCurrency      as InsurClmItemEvalCurrency,
      ClaimItem.InsurClmItemEvalFactor        as InsurClmItemEvalFactor,
      @Semantics.amount.currencyCode: 'InsurClmItemEvalCurrency'
      ClaimItem.InsurClmItmEvalActlCshValAmt  as InsurClmItmEvalActlCshValAmt,
      ClaimItem.InsurClmItmEvalActlCshValPct  as InsurClmItmEvalActlCshValPct,
      ClaimItem.InsurClmBRFCalcExpression     as InsurClmBRFCalcExpression,
      ClaimItem.InsurClmItemTaxCode           as InsurClmItemTaxCode,
      ClaimItem.InsurClmItemSubclmRef         as InsurClmItemSubclmRef,
      ClaimItem.InsurClmItemRef               as InsurClmItemRef,
      ClaimItem.InsurClmDamagedObject         as InsurClmDamagedObject,
      //      ClaimItemEval.InsurClmItemEvalCat        as InsurClmItemEvalCat,

      ClaimItemEval.InsurClmItemEvalDate       as InsurClmItemEvalDate,
      ClaimItemEval.InsurClmItemLiabilityRate  as InsurClmItemLiabilityRate,
      @Semantics.amount.currencyCode: 'InsurClmItemEvalCurrency'
      ClaimItemEval.InsurClmItemClmdAmount     as InsurClmItemClmdAmount,
     
      //Associations

      _InsuranceClaim
     
}
where ClaimItem.InsurClmDatabaseLineStatus     <> 'X'
  and ClaimItemEval.InsurClmDatabaseLineStatus <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMITEM",
"I_INSURCLMITEMEVALUATION"
],
"ASSOCIATED":
[
"R_INSURANCECLAIMTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/