R_InsurClmFNOLClaimItemTP

DDL: R_INSURCLMFNOLCLAIMITEMTP Type: view_entity TRANSACTIONAL
35 Fields 1 Data Sources 1 Associations

FNOL Claim Items

R_InsurClmFNOLClaimItemTP is a Transactional CDS View that provides data about "FNOL Claim Items" in SAP S/4HANA. It reads from 1 data source (I_InsurClmItem) and exposes 35 fields with key fields InsuranceClaim, InsurClmSubclm, InsurClmItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmItem I_InsurClmItem from

Associations (1)

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

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Claim Items view
AbapCatalog.extensibility.elementSuffix ICL view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 1000 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
ObjectModel.sapObjectNodeType.name InsuranceClaim view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmSubclm InsurClmSubclm Subclaim
KEY InsurClmItem InsurClmItem Claim Item
LastChangeDateTime LastChangeDateTime Timestamp
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus Status
InsurClmItemCat InsurClmItemCat Claim Item Cat.
InsurClmItemType InsurClmItemType Object Type
InsurClmCoverageType InsurClmCoverageType Coverage Type
InsurBnftType InsurBnftType Benefit Type
InsurClmItemStatus InsurClmItemStatus Status
InsurClmItemRjcnRsn InsurClmItemRjcnRsn Rejection Reasn
InsurClmItemDescription InsurClmItemDescription Description
InsurClmItemEvalBase InsurClmItemEvalBase Evaluation By
InsurClmItemEvaluation InsurClmItemEvaluation Valid evaluatn
InsurClmItemEvalQuantity InsurClmItemEvalQuantity Number
InsurClmItemEvalQuantityUnit InsurClmItemEvalQuantityUnit Unit
InsurClmItemEvalPerUnitAmt InsurClmItemEvalPerUnitAmt Amount per Unit
InsurClmItemEvalAmount InsurClmItemEvalAmount EvaluatedAmount
InsurClmItemEvalCurrency InsurClmItemEvalCurrency Currency
InsurClmItemEvalFactor InsurClmItemEvalFactor Factor
InsurClmItmEvalActlCshValAmt InsurClmItmEvalActlCshValAmt Act.Cash Value
InsurClmItmEvalActlCshValPct InsurClmItmEvalActlCshValPct ACV Part
InsurClmBRFCalcExpression InsurClmBRFCalcExpression Payout Calc.
InsurClmItemTaxCode InsurClmItemTaxCode Tax Code
InsurClmItemSubclmRef InsurClmItemSubclmRef Belongs To
InsurClmItemRef InsurClmItemRef Claim Item
InsurClmDamagedObject InsurClmDamagedObject Damaged Object
InsurClmAssignUUID InsurClmAssignUUID Link UUID
InsurClmBnftValAmt InsurClmBnftValAmt Benefit Value
InsurClmManuallyCreatedItem InsurClmManuallyCreatedItem Creatd Manually
InsuranceClaimCreationReason InsuranceClaimCreationReason Creation Reason
InsurClmIsInternalClearing InsurClmIsInternalClearing Int. Clearing
InsuranceClaimPeriodicity InsuranceClaimPeriodicity Time Periods
InsurClmAddlPaytDueDateVal InsurClmAddlPaytDueDateVal Addl Due Date
_Claim _Claim

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_InsurClmFNOLClaimItemTP.
-- 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_InsurClmFNOLClaimItemTP AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmItem,
  LastChangeDateTime,
  InsurClmDatabaseLineStatus,
  InsurClmItemCat,
  InsurClmItemType,
  InsurClmCoverageType,
  InsurBnftType,
  InsurClmItemStatus,
  InsurClmItemRjcnRsn,
  InsurClmItemDescription,
  InsurClmItemEvalBase,
  InsurClmItemEvaluation,
  InsurClmItemEvalQuantity,
  InsurClmItemEvalQuantityUnit,
  InsurClmItemEvalPerUnitAmt,
  InsurClmItemEvalAmount,
  InsurClmItemEvalCurrency,
  InsurClmItemEvalFactor,
  InsurClmItmEvalActlCshValAmt,
  InsurClmItmEvalActlCshValPct,
  InsurClmBRFCalcExpression,
  InsurClmItemTaxCode,
  InsurClmItemSubclmRef,
  InsurClmItemRef,
  InsurClmDamagedObject,
  InsurClmAssignUUID,
  InsurClmBnftValAmt,
  InsurClmManuallyCreatedItem,
  InsuranceClaimCreationReason,
  InsurClmIsInternalClearing,
  InsuranceClaimPeriodicity,
  InsurClmAddlPaytDueDateVal
FROM I_InsurClmItem
LEFT OUTER JOIN E_InsuranceClaimItem AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmSubclm = _Extension.InsurClmSubclm AND InsurClmItem = _Extension.InsurClmItem  -- association [1..1]
;

Learn More