R_InsurClaimItemTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_InsurClmItem | ClaimItem | from |
| I_InsurClmItemEvaluation | ClaimItemEval | inner |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_InsuranceClaimItem | _Extension | $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmSubclm = _Extension.InsurClmSubclm and $projection.InsurClmItem = _Extension.InsurClmItem |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA