I_InsuranceClaim_2

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_2.
-- 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 I_InsuranceClaim_2 AS
SELECT
  active AS InsurClmActive,
  claim AS InsuranceClaim,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  createdby AS CreatedByUser,
  cast( createtime as icl_createutc_fiori preserving type ) AS CreationDateTime,
  achangedby AS InsurClmWholeClmChgdBy,
  cast ( achangetime as icl_achangetime_fiori preserving type ) AS InsurClmWholeClmChgDteTme,
  exclaimnocat AS InsurClmExternalNumberCategory,
  exclaimno AS InsuranceClaimExternalNumber,
  status AS InsurClmLifeCycSts,
  cast ( statuschg as icl_achangetime_fiori preserving type ) AS InsurClmStsChgdOnDteTime,
  sthandler AS InsuranceClaimIsStatusHandler,
  stnoclaim AS InsuranceClaimIsNoClaimMade,
  stclosed AS InsuranceClaimIsStatusClosed,
  statreason AS InsurClmStatReason,
  losstype AS InsurClmIncdntType,
  claimtype AS InsurClmType,
  cltypeg AS InsurClmTypeGeneration,
  cltypev AS InsurClmTypeVers,
  lossevent AS InsuranceClaimBundleLossEvent,
  polprod AS InsurClmPolicyProduct,
  generat AS InsurClmPolicyProdGeneration,
  version AS InsurClmPolicyProductVersion,
  cast( lrenewal as icl_lrenewal_fiori preserving type ) AS InsurClmContractLastRenewal,
  policy AS InsuranceContract,
  losscause AS InsurClmCauseOfLoss,
  peril AS InsuranceClaimReinsurancePeril,
  dateloss AS InsurClmDateOfLoss,
  timeloss AS InsurClmTimeOfLoss,
  ltimezone AS InsurClmTimeZoneOfLoss,
  xdateestim AS InsuranceClaimIsDateEstimate,
  datechanger AS InsuranceClaimDateChangeReason,
  lossrepcompa AS InsurClmReportedDate,
  lossrepagent AS InsurClmAgentReportedDate,
  lossaddress AS InsurClmLossLocAddressID,
  xauthrep AS InsurClmIsRptdToAuth,
  xsensitive AS InsurClmSensitiveClaim,
  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,
  authclm AS InsurClmAuthznGrp,
  xclaimb AS InsurClmIsEntrInPaytAmtAuthzns,
  xnonotif AS InsuranceClaimIsNoNotif,
  xreserve AS InsuranceClaimIsReserve,
  bentree AS InsurClmBenefitTypeTree,
  bentreeg AS InsurClmBnftTypeTreeGeneration,
  bentreev AS InsurClmBnftTypeTreeVersion,
  cast ( wf_exec_time as icl_lrenewal_fiori preserving type ) AS InsurClmWrkflwExecDteTme,
  wf_status AS InsurClmWorkflowStatus,
  xdummyclaim AS InsurClmIsDummyClaim,
  cast( verchngutc as icl_verchngutc_fiori preserving type ) AS InsurClmVersionChangeTime,
  opendate AS InsurClmOpenDate,
  xwithout_product AS InsurClmIsWithoutProduct,
  max_itemnr AS InsuranceClaimMaxItemNumber,
  assign_guid AS InsurClmAssignUUID,
  sif_status AS InsurClmSecondInjuryFundStatus,
  invstg_status AS InsurClmIncdntInvstgnSts,
  effective_dt AS InsuranceClaimEffectiveDate,
  lossrep_dt AS InsuranceClaimLossRepDate,
  lumpsumoption AS InsuranceClaimIsLumpSumOption,
  statpension AS InsurClmStatutoryPensionType,
  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,
  fnol_claimnr AS InsuranceClaimDraftIdentifier,
  archive_status AS InsurClmArchivingStatus,
  archive_flud AS InsurClmArchResubmsnDte,
  rejection AS InsurClmArchRjcnRsn
FROM iclclaim
;