I_InsurClmBndlContractOverview

DDL: I_INSURCLMBNDLCONTRACTOVERVIEW SQL: IICLCCEVENTCO Type: view BASIC
35 Fields 1 Data Sources

Mehrerer Verträge–Vertragsübersicht

I_InsurClmBndlContractOverview is a Basic CDS View that provides data about "Mehrerer Verträge–Vertragsübersicht" in SAP S/4HANA. It reads from 1 data source (iclcceventco) and exposes 35 fields with key fields InsurClmActive, InsurClaimBundle, InsuranceClaimBundleContract, InsurClmAssignUUID, InsurClmIncdntType.

Data Sources (1)

SourceAliasJoin Type
iclcceventco iclcceventco from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICLCCEVENTCO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Mehrerer Verträge–Vertragsübersicht view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive active Usage Active
KEY InsurClaimBundle ccevent Claim Bundle
KEY InsuranceClaimBundleContract contract Trading Contract
KEY InsurClmAssignUUID assign_guid Link UUID
KEY InsurClmIncdntType losstype Scope of Loss
KEY InsurClmBndlParentContract parent_contract Contract
ChangedOnDateTime Created
LastChangedByUser changedby User Name
InsurClmDatabaseLineStatus deleted Truth Value
InsurClmBndlIsSelect xselect Selectable
InsurLineOfBus lob Insurance Line
InsurClmBndlPlcyNmbr policy Policy
InsurClmBndlNameOfContrTxt contractn Contract Name
InsuranceClaimBundleClaimData claim_data Reserve
InsurClmUnqCvrgNmbr coverage Coverage No.
InsurClmCvrgDesc coveragen Name
InsurClmCoverageType covtype Coverage Type
InsurClmIncdntTypeName losstypen IncidentType Nm
InsuranceClaim claim Policy Snapshot
InsurClmPolicyProduct polprod Stand. Product
InsurClmPolicyProdGeneration generat Generation
InsurClmPolicyProductVersion version XML Vers.
InsurClmBnftProcgPrfl profile_pr_level BenProcProfile
InsurClmDateOfLoss lossdate Date of Loss
InsurClmTimeOfLoss losstime Time
InsurClmBeginDte begin_date Validity Start
InsurClmEndDte end_date Valn End date
InsurClmContrCancDte cont_cancel_dt Valid To
InsurClmBndlIncdntSqnc incident_sequence Item Number
InsurClmBndlWthdrwlSqnc withdrawseq Withdrawal Seq.
InsurClmBndlWithdrawAmt withdrawamount Withdrawal Amt
InsurClmBndlWithdrawCrcy withdrawamountcurr Currency
InsurClmBndlBnftValAmt benvalue Benefit Value
InsurClmBndlEvalCrcy evcurr 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 I_InsurClmBndlContractOverview.
-- 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.
-- SQL view name: IICLCCEVENTCO

CREATE VIEW I_InsurClmBndlContractOverview AS
SELECT
  active AS InsurClmActive,
  ccevent AS InsurClaimBundle,
  contract AS InsuranceClaimBundleContract,
  assign_guid AS InsurClmAssignUUID,
  losstype AS InsurClmIncdntType,
  parent_contract AS InsurClmBndlParentContract,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  xselect AS InsurClmBndlIsSelect,
  lob AS InsurLineOfBus,
  policy AS InsurClmBndlPlcyNmbr,
  contractn AS InsurClmBndlNameOfContrTxt,
  claim_data AS InsuranceClaimBundleClaimData,
  coverage AS InsurClmUnqCvrgNmbr,
  coveragen AS InsurClmCvrgDesc,
  covtype AS InsurClmCoverageType,
  losstypen AS InsurClmIncdntTypeName,
  claim AS InsuranceClaim,
  polprod AS InsurClmPolicyProduct,
  generat AS InsurClmPolicyProdGeneration,
  version AS InsurClmPolicyProductVersion,
  profile_pr_level AS InsurClmBnftProcgPrfl,
  lossdate AS InsurClmDateOfLoss,
  losstime AS InsurClmTimeOfLoss,
  begin_date AS InsurClmBeginDte,
  end_date AS InsurClmEndDte,
  cont_cancel_dt AS InsurClmContrCancDte,
  incident_sequence AS InsurClmBndlIncdntSqnc,
  withdrawseq AS InsurClmBndlWthdrwlSqnc,
  withdrawamount AS InsurClmBndlWithdrawAmt,
  withdrawamountcurr AS InsurClmBndlWithdrawCrcy,
  benvalue AS InsurClmBndlBnftValAmt,
  evcurr AS InsurClmBndlEvalCrcy
FROM iclcceventco
;

Learn More