A_InsurClmBndlContrOvw

DDL: A_INSURCLMBNDLCONTROVW Type: view_entity CONSUMPTION Package: ICL_VDM_CLAIMBUNDLE_API

Claim Bundle Contract Overview

A_InsurClmBndlContrOvw is a Consumption CDS View that provides data about "Claim Bundle Contract Overview" in SAP S/4HANA. It reads from 1 data source (R_InsurClmBndlContrOvwTP) and exposes 33 fields with key fields InsurClmActive, InsurClaimBundle, InsuranceClaimBundleContract, InsurClmAssignUUID, InsurClmIncdntType. It is exposed through 1 OData service (API_INSURANCECLAIMBUNDLE). Part of development package ICL_VDM_CLAIMBUNDLE_API.

Data Sources (1)

SourceAliasJoin Type
R_InsurClmBndlContrOvwTP R_InsurClmBndlContrOvwTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Claim Bundle Contract Overview view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name InsurClmBndlContrOvw_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_INSURANCECLAIMBUNDLE API_INSURANCECLAIMBUNDLE V4 C2 NOT_RELEASED

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive InsurClmActive Active/Suspense
KEY InsurClaimBundle InsurClaimBundle Claim Bundle
KEY InsuranceClaimBundleContract InsuranceClaimBundleContract
KEY InsurClmAssignUUID InsurClmAssignUUID Link UUID
KEY InsurClmIncdntType InsurClmIncdntType Incident Type
KEY InsurClmBndlParentContract InsurClmBndlParentContract
ChangedOnDateTime ChangedOnDateTime Last Changed At
LastChangedByUser LastChangedByUser User Name
InsurClmBndlIsSelect InsurClmBndlIsSelect
InsurLineOfBus InsurLineOfBus
InsurClmBndlPlcyNmbr InsurClmBndlPlcyNmbr
InsurClmBndlNameOfContrTxt InsurClmBndlNameOfContrTxt
InsuranceClaimBundleClaimData InsuranceClaimBundleClaimData
InsurClmUnqCvrgNmbr InsurClmUnqCvrgNmbr
InsurClmCvrgDesc InsurClmCvrgDesc
InsurClmCoverageType InsurClmCoverageType Coverage Type
InsurClmIncdntTypeName InsurClmIncdntTypeName
InsuranceClaim InsuranceClaim Claim Number
InsurClmPolicyProduct InsurClmPolicyProduct Policy Product
InsurClmPolicyProdGeneration InsurClmPolicyProdGeneration Generation
InsurClmPolicyProductVersion InsurClmPolicyProductVersion Version
InsurClmBnftProcgPrfl InsurClmBnftProcgPrfl
InsurClmDateOfLoss InsurClmDateOfLoss Date of Loss
InsurClmTimeOfLoss InsurClmTimeOfLoss Time
InsurClmBeginDte InsurClmBeginDte
InsurClmEndDte InsurClmEndDte
InsurClmContrCancDte InsurClmContrCancDte
InsurClmBndlIncdntSqnc InsurClmBndlIncdntSqnc
InsurClmBndlWthdrwlSqnc InsurClmBndlWthdrwlSqnc
InsurClmBndlWithdrawAmt InsurClmBndlWithdrawAmt
InsurClmBndlWithdrawCrcy InsurClmBndlWithdrawCrcy
InsurClmBndlBnftValAmt InsurClmBndlBnftValAmt
InsurClmBndlEvalCrcy InsurClmBndlEvalCrcy

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 A_InsurClmBndlContrOvw.
-- 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 A_InsurClmBndlContrOvw 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 R_InsurClmBndlContrOvwTP
;