R_InsuranceClaimShadowItemTP

DDL: R_INSURANCECLAIMSHADOWITEMTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_CLAIM_API
30 Fields 2 Data Sources

TP View for Insurance Claim Item Shadow

R_InsuranceClaimShadowItemTP is a Transactional CDS View that provides data about "TP View for Insurance Claim Item Shadow" in SAP S/4HANA. It reads from 2 data sources (I_InsuranceClaimShadowItem, I_InsurClmItemEvaluation) and exposes 30 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmItem, InsurClmItemEvaluation. Part of development package ICL_VDM_CLAIM_API.

Data Sources (2)

SourceAliasJoin Type
I_InsuranceClaimShadowItem ClaimItem from
I_InsurClmItemEvaluation ClaimItemEval inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label TP View for Insurance Claim Item Shadow 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_InsuranceClaimShadowItem InsuranceClaim Claim Number
KEY InsurClmSubclm I_InsuranceClaimShadowItem InsurClmSubclm Subclaim
KEY InsurClmItem I_InsuranceClaimShadowItem InsurClmItem Claim Item
KEY InsurClmItemEvaluation I_InsurClmItemEvaluation InsurClmItemEvaluation Valid evaluatn
LastChangeDateTime I_InsuranceClaimShadowItem LastChangeDateTime Timestamp
InsurClmItemCat I_InsuranceClaimShadowItem InsurClmItemCat Claim Item Cat.
InsurClmItemType I_InsuranceClaimShadowItem InsurClmItemType Object Type
InsurClmCoverageType I_InsuranceClaimShadowItem InsurClmCoverageType Coverage Type
InsurBnftType I_InsuranceClaimShadowItem InsurBnftType Benefit Type
InsurClmItemStatus I_InsuranceClaimShadowItem InsurClmItemStatus Status
InsurClmItemRjcnRsn I_InsuranceClaimShadowItem InsurClmItemRjcnRsn Rejection Reasn
InsurClmItemDescription I_InsuranceClaimShadowItem InsurClmItemDescription Description
InsurClmItemEvalBase I_InsuranceClaimShadowItem InsurClmItemEvalBase Evaluation By
InsurClmItemEvalQuantity I_InsuranceClaimShadowItem InsurClmItemEvalQuantity Number
InsurClmItemEvalQuantityUnit I_InsuranceClaimShadowItem InsurClmItemEvalQuantityUnit Unit
InsurClmItemEvalPerUnitAmt I_InsuranceClaimShadowItem InsurClmItemEvalPerUnitAmt Amount per Unit
InsurClmItemEvalAmount I_InsuranceClaimShadowItem InsurClmItemEvalAmount EvaluatedAmount
InsurClmItemEvalCurrency I_InsuranceClaimShadowItem InsurClmItemEvalCurrency Currency
InsurClmItemEvalFactor I_InsuranceClaimShadowItem InsurClmItemEvalFactor Factor
InsurClmItmEvalActlCshValAmt I_InsuranceClaimShadowItem InsurClmItmEvalActlCshValAmt Act.Cash Value
InsurClmItmEvalActlCshValPct I_InsuranceClaimShadowItem InsurClmItmEvalActlCshValPct ACV Part
InsurClmBRFCalcExpression I_InsuranceClaimShadowItem InsurClmBRFCalcExpression Payout Calc.
InsurClmItemTaxCode I_InsuranceClaimShadowItem InsurClmItemTaxCode Tax Code
InsurClmItemSubclmRef I_InsuranceClaimShadowItem InsurClmItemSubclmRef Belongs To
InsurClmItemRef I_InsuranceClaimShadowItem InsurClmItemRef Claim Item
InsurClmDamagedObject I_InsuranceClaimShadowItem InsurClmDamagedObject Damaged Object
InsurClmItemEvalDate I_InsurClmItemEvaluation InsurClmItemEvalDate Valuation Date
InsurClmItemLiabilityRate I_InsurClmItemEvaluation InsurClmItemLiabilityRate Rate negotiated
InsurClmItemClmdAmount I_InsurClmItemEvaluation InsurClmItemClmdAmount Amount Requestd
_InsuranceClaim _InsuranceClaim

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InsuranceClaimShadowItemTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InsuranceClaimShadowItemTP AS
SELECT
  ClaimItem.InsuranceClaim AS InsuranceClaim,
  ClaimItem.InsurClmSubclm AS InsurClmSubclm,
  ClaimItem.InsurClmItem AS InsurClmItem,
  ClaimItemEval.InsurClmItemEvaluation AS InsurClmItemEvaluation,
  ClaimItem.LastChangeDateTime AS LastChangeDateTime,
  ClaimItem.InsurClmItemCat AS InsurClmItemCat,
  ClaimItem.InsurClmItemType AS InsurClmItemType,
  ClaimItem.InsurClmCoverageType AS InsurClmCoverageType,
  ClaimItem.InsurBnftType AS InsurBnftType,
  ClaimItem.InsurClmItemStatus AS InsurClmItemStatus,
  ClaimItem.InsurClmItemRjcnRsn AS InsurClmItemRjcnRsn,
  ClaimItem.InsurClmItemDescription AS InsurClmItemDescription,
  ClaimItem.InsurClmItemEvalBase AS InsurClmItemEvalBase,
  ClaimItem.InsurClmItemEvalQuantity AS InsurClmItemEvalQuantity,
  ClaimItem.InsurClmItemEvalQuantityUnit AS InsurClmItemEvalQuantityUnit,
  ClaimItem.InsurClmItemEvalPerUnitAmt AS InsurClmItemEvalPerUnitAmt,
  ClaimItem.InsurClmItemEvalAmount AS InsurClmItemEvalAmount,
  ClaimItem.InsurClmItemEvalCurrency AS InsurClmItemEvalCurrency,
  ClaimItem.InsurClmItemEvalFactor AS InsurClmItemEvalFactor,
  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.InsurClmItemEvalDate AS InsurClmItemEvalDate,
  ClaimItemEval.InsurClmItemLiabilityRate AS InsurClmItemLiabilityRate,
  ClaimItemEval.InsurClmItemClmdAmount AS InsurClmItemClmdAmount
FROM I_InsuranceClaimShadowItem AS ClaimItem
INNER JOIN I_InsurClmItemEvaluation AS ClaimItemEval ON /* join condition not captured in parsed metadata */
;

Learn More