R_InsurClmBndlContrOvwTP

DDL: R_INSURCLMBNDLCONTROVWTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_CLAIMBUNDLE_API

Insurance Claim Bundle Contract Overview

R_InsurClmBndlContrOvwTP is a Transactional CDS View that provides data about "Insurance Claim Bundle Contract Overview" in SAP S/4HANA. It reads from 1 data source (I_InsurClmBndlContractOverview) and exposes 34 fields with key fields InsurClmActive, InsurClaimBundle, InsuranceClaimBundleContract, InsurClmAssignUUID, InsurClmIncdntType. Part of development package ICL_VDM_CLAIMBUNDLE_API.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmBndlContractOverview I_InsurClmBndlContractOverview from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Insurance Claim Bundle Contract Overview 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 (34)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsurClaimBundle InsurClaimBundle Claim Bundle
KEY InsuranceClaimBundleContract InsuranceClaimBundleContract Trading Contract
KEY InsurClmAssignUUID InsurClmAssignUUID Link UUID
KEY InsurClmIncdntType InsurClmIncdntType Incident Type
KEY InsurClmBndlParentContract InsurClmBndlParentContract Contract
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmBndlIsSelect InsurClmBndlIsSelect Selectable
InsurLineOfBus InsurLineOfBus Insurance Line
InsurClmBndlPlcyNmbr InsurClmBndlPlcyNmbr Policy
InsurClmBndlNameOfContrTxt InsurClmBndlNameOfContrTxt Contract Name
InsuranceClaimBundleClaimData InsuranceClaimBundleClaimData Reserve
InsurClmUnqCvrgNmbr InsurClmUnqCvrgNmbr Coverage No.
InsurClmCvrgDesc InsurClmCvrgDesc Name
InsurClmCoverageType InsurClmCoverageType Coverage Type
InsurClmIncdntTypeName InsurClmIncdntTypeName IncidentType Nm
InsuranceClaim InsuranceClaim Claim Number
InsurClmPolicyProduct InsurClmPolicyProduct Policy Product
InsurClmPolicyProdGeneration InsurClmPolicyProdGeneration Generation
InsurClmPolicyProductVersion InsurClmPolicyProductVersion Version
InsurClmBnftProcgPrfl InsurClmBnftProcgPrfl BenProcProfile
InsurClmDateOfLoss InsurClmDateOfLoss Date of Loss
InsurClmTimeOfLoss InsurClmTimeOfLoss Time
InsurClmBeginDte InsurClmBeginDte Validity Start
InsurClmEndDte InsurClmEndDte Valn End date
InsurClmContrCancDte InsurClmContrCancDte Valid To
InsurClmBndlIncdntSqnc InsurClmBndlIncdntSqnc Item Number
InsurClmBndlWthdrwlSqnc InsurClmBndlWthdrwlSqnc Withdrawal Seq.
InsurClmBndlWithdrawAmt InsurClmBndlWithdrawAmt Withdrawal Amt
InsurClmBndlWithdrawCrcy InsurClmBndlWithdrawCrcy Currency
InsurClmBndlBnftValAmt InsurClmBndlBnftValAmt Benefit Value
InsurClmBndlEvalCrcy InsurClmBndlEvalCrcy Currency
_InsurClmBundle _InsurClmBundle

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_InsurClmBndlContrOvwTP.
-- 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_InsurClmBndlContrOvwTP AS
SELECT
  InsurClmActive,
  InsurClaimBundle,
  InsuranceClaimBundleContract,
  InsurClmAssignUUID,
  InsurClmIncdntType,
  InsurClmBndlParentContract,
  ChangedOnDateTime,
  LastChangedByUser,
  InsurClmBndlIsSelect,
  InsurLineOfBus,
  InsurClmBndlPlcyNmbr,
  InsurClmBndlNameOfContrTxt,
  InsuranceClaimBundleClaimData,
  InsurClmUnqCvrgNmbr,
  InsurClmCvrgDesc,
  InsurClmCoverageType,
  InsurClmIncdntTypeName,
  InsuranceClaim,
  InsurClmPolicyProduct,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmBnftProcgPrfl,
  InsurClmDateOfLoss,
  InsurClmTimeOfLoss,
  InsurClmBeginDte,
  InsurClmEndDte,
  InsurClmContrCancDte,
  InsurClmBndlIncdntSqnc,
  InsurClmBndlWthdrwlSqnc,
  InsurClmBndlWithdrawAmt,
  InsurClmBndlWithdrawCrcy,
  InsurClmBndlBnftValAmt,
  InsurClmBndlEvalCrcy
FROM I_InsurClmBndlContractOverview
;