I_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 I_InsuranceClaim.
-- 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: INSURANCECLAIM

CREATE VIEW I_InsuranceClaim AS
SELECT
  claim AS InsuranceClaim,
  policy AS InsuranceContract,
  _PolicySnapshot.InsurancePolicy AS InsurancePolicy,
  polprod AS InsurClmPolicyProduct,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  cast( createtime as icl_createutc_fiori preserving type ) AS CreationDateTime,
  createdby AS CreatedByUser,
  achangedby AS InsurClmWholeClmChgdBy,
  cast ( achangetime as icl_achangetime_fiori preserving type ) AS InsurClmWholeClmChgDteTme,
  exclaimnocat AS InsurClmExternalNumberCategory,
  cast( statuschg as timestamp) AS InsurClmSubclmStsChgdOnDteTime,
  status AS InsurClmLifeCycSts,
  cast ( statuschg as icl_achangetime_fiori preserving type ) AS InsurClmStsChgdOnDteTime,
  lumpsumoption AS InsuranceClaimLumpSum,
  lumpsumoption AS InsuranceClaimIsLumpSum,
  withdrawam AS InsurClmBndlWithdrawAmt,
  withdrawcurr AS InsurClmBndlWithdrawCrcy,
  withdrawseq AS InsurClmBndlWthdrwlSqnc,
  sthandler AS InsuranceClaimIsStatusHandler,
  stnoclaim AS InsuranceClaimIsNoClaimMade,
  stclosed AS InsuranceClaimIsStatusClosed,
  statreason AS InsurClmStatReason,
  followup_dt AS InsClmAutoResubmsnDte,
  claimtype AS InsurClmType,
  authclm AS InsurClmAuthznGrp,
  generat AS InsurClmPolicyProdGeneration,
  version AS InsurClmPolicyProductVersion,
  losstype AS InsurClmIncdntType,
  dateloss AS InsurClmDateOfLoss,
  losscause AS InsurClmCauseOfLoss,
  lossaddress AS InsurClmLossLocAddressID,
  cltypeg AS InsurClmTypeGeneration,
  cltypev AS InsurClmTypeVers,
  lossevent AS InsuranceClaimBundleLossEvent,
  peril AS InsuranceClaimReinsurancePeril,
  timeloss AS InsurClmTimeOfLoss,
  ltimezone AS InsurClmTimeZoneOfLoss,
  xdateestim AS InsuranceClaimIsDateEstimate,
  datechanger AS InsuranceClaimDateChangeReason,
  xauthrep AS InsurClmIsRptdToAuth,
  cast( lrenewal as icl_lrenewal_fiori preserving type ) AS InsurClmContractLastRenewal,
  cast( verchngutc as icl_verchngutc_fiori preserving type ) AS InsurClmVersionChangeTime,
  assign_guid AS InsurClmAssignUUID,
  complex AS InsurClmComplexity,
  juriscountry AS InsurClmJurisdictionCountry,
  jurisregion AS InsurClmJurisdictionRegion,
  assign_state AS InsurClmActyAssgmtSts,
  ownertype AS InsuranceClaimOwnerType,
  owner AS InsuranceClaimOwner,
  ownertype_grp AS InsuranceClaimOwnerTypeGroup,
  owner_grp AS InsuranceClaimOwnerGroup,
  xcumul AS InsuranceClaimIsCumulative,
  viewfault AS InsuranceClaimViewFault,
  viewfaultph AS InsurClmVwFaultPlcyHldr,
  xtpknown AS InsurClmIsThirdPartyKnown,
  covered AS InsurClmCovered,
  xclaimb AS InsurClmIsEntrInPaytAmtAuthzns,
  xnonotif AS InsuranceClaimIsNoNotif,
  xreserve AS InsuranceClaimIsReserve,
  cast ( wf_exec_time as icl_lrenewal_fiori preserving type ) AS InsurClmWrkflwExecDteTme,
  wf_status AS InsurClmWorkflowStatus,
  opendate AS InsurClmOpenDate,
  max_itemnr AS InsuranceClaimMaxItemNumber,
  sif_status AS InsurClmSecondInjuryFundStatus,
  invstg_status AS InsurClmIncdntInvstgnSts,
  effective_dt AS InsuranceClaimEffectiveDate,
  lossrep_dt AS InsuranceClaimLossRepDate,
  statpension AS InsurClmStatutoryPensionType,
  lumpsumoption AS InsuranceClaimIsLumpSumOption,
  withdrawam AS InsurClmWithdrawAmt,
  withdrawcurr AS InsurClmWithdrawCrcy,
  withdrawseq AS InsurClmWthdrwlSqnc,
  alternateben AS InsuranceClaimAlternateBenefit,
  generatenotif AS InsuranceClaimSpecialRiskNotif,
  notifreason AS InsuranceClaimNotifReason,
  autfollowup AS InsuranceClaimAutoResubmission,
  followup_dt AS InsuranceClaimFollowUpDate,
  processing_dt AS InsuranceClaimProcessingDate,
  statusobjid AS InsuranceClaimStatusObjectNmbr,
  dunnlevel AS InsuranceClaimDunningStatus,
  cleardate AS InsuranceClaimClearDate,
  prembalanam AS InsurClmPremiumBalanceAmount,
  prembalanamcurr AS InsurClmPremiumBalanceCurrency,
  withdrawtype AS InsuranceClaimWithdrawalType,
  react_dt AS InsuranceClaimReactDate,
  cast ( gennotiftime as icl_lrenewal_fiori preserving type ) AS InsurClmSpecialRiskMsgDateTime,
  cast ( ben_calc_fail as icl_lrenewal_fiori preserving type ) AS InsurClmIncrrtBnftCalcDateTime,
  polsystem AS InsuranceClaimPolicySystem,
  bentree AS InsurClmBenefitTypeTree,
  bentreeg AS InsurClmBnftTypeTreeGeneration,
  bentreev AS InsurClmBnftTypeTreeVersion,
  xwithout_product AS InsurClmIsWithoutProduct,
  xdummyclaim AS InsurClmIsDummyClaim,
  lossrepcompa AS InsurClmReportedDate,
  lossrepagent AS InsurClmAgentReportedDate,
  xsensitive AS InsurClmSensitiveClaim,
  exclaimno AS InsuranceClaimExternalNumber,
  fnol_claimnr AS InsuranceClaimDraftIdentifier,
  archive_status AS InsurClmArchivingStatus,
  archive_flud AS InsurClmArchResubmsnDte,
  rejection AS InsurClmArchRjcnRsn
FROM iclclaim
LEFT OUTER JOIN I_InsurClaimPolicyProduct AS _PolicyProduct ON InsurClmPolicyProduct = _PolicyProduct.InsurClmPolicyProduct AND InsurClmPolicyProdGeneration = _PolicyProduct.InsurClmPolicyProdGeneration AND InsurClmPolicyProductVersion = _PolicyProduct.InsurClmPolicyProductVersion  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPolicySnapshot AS _PolicySnapshot ON InsuranceClaim = _PolicySnapshot.InsuranceClaim AND _PolicySnapshot.InsurClmContractVersion = '00'  -- association [0..1]
LEFT OUTER JOIN I_InsurIntClmTypeAllwdSubclm AS _AllwdSubclmType ON InsurClmType = _AllwdSubclmType.InsurClmType AND InsurClmTypeGeneration = _AllwdSubclmType.InsurClmTypeGeneration AND InsurClmTypeVers = _AllwdSubclmType.InsurClmTypeVers  -- association [0..*]
;