R_InsurClmBenefitSplitItemTP

DDL: R_INSURCLMBENEFITSPLITITEMTP Type: view_entity TRANSACTIONAL

Benefit split (Onetime) item - TP

R_InsurClmBenefitSplitItemTP is a Transactional CDS View that provides data about "Benefit split (Onetime) item - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBenefitSplitItem) and exposes 28 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBnftSpltItmUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBenefitSplitItem ClmBenefitSplitItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurClmBenefitSplitItem _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmBnftSpltItmUUID = _Extension.InsurClmBnftSpltItmUUID

Annotations (8)

NameValueLevelField
EndUserText.label Benefit split (Onetime) item - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey InsurClmBnftSpltItmUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive
KEY InsuranceClaim InsuranceClaim
KEY InsurClmBnftSpltItmUUID InsurClmBnftSpltItmUUID
ChangedOnDateTime ChangedOnDateTime
LastChangedByUser LastChangedByUser
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus
InsurClmBnftSplitItemNumber InsurClmBnftSplitItemNumber
InsurClmBnftSpltItmHdrUUID InsurClmBnftSpltItmHdrUUID
InsurClmPrioOfBnftSpltValue InsurClmPrioOfBnftSpltValue
InsurClmCalcBaseShrPct InsurClmCalcBaseShrPct
InsurClmBnftSpltItmGrossAmt InsurClmBnftSpltItmGrossAmt
InsurClmBnftSpltItmNetAmt InsurClmBnftSpltItmNetAmt
InsurClmBnftSpltAmtFxdValue InsurClmBnftSpltAmtFxdValue
InsurClmBnftSpltItmPaidAmt InsurClmBnftSpltItmPaidAmt
InsurClmBnftSpltItmCalcBaseAmt InsurClmBnftSpltItmCalcBaseAmt
InsurClmBnftSpltOffsetKey InsurClmBnftSpltOffsetKey
InsurClmBnftSpltNetPaytDueDate InsurClmBnftSpltNetPaytDueDate
InsurClmBankDetailsId InsurClmBankDetailsId
InsurClmPaytMethod InsurClmPaytMethod
InsurClmPaytAddrNmbrForChecks InsurClmPaytAddrNmbrForChecks
InsurClmAltvPostgTgtVal InsurClmAltvPostgTgtVal
InsurClmPaytNote InsurClmPaytNote
InsurClmBnftSplitCurrency InsurClmBnftSplitCurrency
InsurClmBnftSpltItmValidToID
InsurClmNetAmtValidValue InsurClmNetAmtValidValue
InsurClmBnftSpltItmSubclaim InsurClmBnftSpltItmSubclaim
InsurClmIsOffstAmtAssgdSubclm InsurClmIsOffstAmtAssgdSubclm
_InsurClmBenefitSplitHeader _InsurClmBenefitSplitHeader
@EndUserText.label: 'Benefit split (Onetime) item - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurClmBnftSpltItmUUID',
   semanticKey: [ 'InsurClmBnftSpltItmUUID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity R_InsurClmBenefitSplitItemTP
as select from I_InsurClmBenefitSplitItem as ClmBenefitSplitItem
association to parent  R_InsurClmBenefitSplitHeaderTP  as _InsurClmBenefitSplitHeader
on  $projection.InsurClmActive = _InsurClmBenefitSplitHeader.InsurClmActive
                   and  $projection.InsuranceClaim = _InsurClmBenefitSplitHeader.InsuranceClaim
                  and  $projection.InsurClmBnftSpltItmHdrUUID = _InsurClmBenefitSplitHeader.InsurClmBnftSpltHdrUUID
association [1..1] to E_InsurClmBenefitSplitItem   as _Extension  on  $projection.InsuranceClaim = _Extension.InsuranceClaim
                                                                and $projection.InsurClmBnftSpltItmUUID = _Extension.InsurClmBnftSpltItmUUID
{
key InsurClmActive,
key InsuranceClaim,
key InsurClmBnftSpltItmUUID, 
ChangedOnDateTime,
LastChangedByUser,
InsurClmDatabaseLineStatus,
InsurClmBnftSplitItemNumber,
InsurClmBnftSpltItmHdrUUID,
InsurClmPrioOfBnftSpltValue,
InsurClmCalcBaseShrPct,
@Semantics.amount.currencyCode: 'InsurClmBnftSplitCurrency'
InsurClmBnftSpltItmGrossAmt,
@Semantics.amount.currencyCode: 'InsurClmBnftSplitCurrency'
InsurClmBnftSpltItmNetAmt,
InsurClmBnftSpltAmtFxdValue,
@Semantics.amount.currencyCode: 'InsurClmBnftSplitCurrency'
InsurClmBnftSpltItmPaidAmt,
@Semantics.amount.currencyCode: 'InsurClmBnftSplitCurrency'
InsurClmBnftSpltItmCalcBaseAmt,
InsurClmBnftSpltOffsetKey,
InsurClmBnftSpltNetPaytDueDate,
InsurClmBankDetailsId,
InsurClmPaytMethod,
InsurClmPaytAddrNmbrForChecks,
InsurClmAltvPostgTgtVal,
InsurClmPaytNote,
InsurClmBnftSplitCurrency,  
case when (InsurClmBnftSpltItmValidToID = '0000-00-00') then  '0' else (InsurClmBnftSpltItmValidToID)  end as InsurClmBnftSpltItmValidToID, //Fix CX_PARAMETER_INVALID_RANGE Error

InsurClmNetAmtValidValue,
InsurClmBnftSpltItmSubclaim,
InsurClmIsOffstAmtAssgdSubclm ,

_InsurClmBenefitSplitHeader 
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMBENEFITSPLITITEM"
],
"ASSOCIATED":
[
"R_INSURCLMBENEFITSPLITHEADERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/