I_InsuranceClaimShadowBasic

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_InsuranceClaimShadowBasic.
-- 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: INSURCLMSHADOWB

CREATE VIEW I_InsuranceClaimShadowBasic AS
SELECT
  claim AS InsuranceClaim,
  tstmp_to_dats( changetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as InsurClmChangeDate AS clientNULLasInsurClmChangeDate,
  tstmp_to_tims( changetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as InsurClmChangedTime AS clientNULLasInsurClmChangedTime,
  cast( changetime as timestamp preserving type ) AS ChangedOnDateTime,
  policy AS InsuranceContract,
  polprod AS InsurClmPolicyProduct,
  changedby AS LastChangedByUser,
  cast( createtime as icl_createutc_fiori preserving type ) AS CreationDateTime,
  createdby AS CreatedByUser,
  status AS InsurClmLifeCycSts,
  statreason AS InsurClmStatReason,
  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,
  timeloss AS InsurClmTimeOfLoss,
  ltimezone AS InsurClmTimeZoneOfLoss,
  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,
  covered AS InsurClmCovered,
  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,
  achangedby AS InsurClmWholeClmChgdBy,
  cast(achangetime as timestamp) AS InsurClmWholeClmChgDteTme,
  exclaimnocat AS InsurClmExternalNumberCategory,
  cast( statuschg as timestamp) AS InsurClmSubclmStsChgdOnDteTime,
  sthandler AS InsuranceClaimIsStatusHandler,
  stnoclaim AS InsuranceClaimIsNoClaimMade,
  stclosed AS InsuranceClaimIsStatusClosed,
  lossevent AS InsuranceClaimBundleLossEvent,
  peril AS InsuranceClaimReinsurancePeril,
  xdateestim AS InsuranceClaimIsDateEstimate,
  datechanger AS InsuranceClaimDateChangeReason,
  xauthrep AS InsurClmIsRptdToAuth,
  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,
  xclaimb AS InsurClmIsEntrInPaytAmtAuthzns,
  xnonotif AS InsuranceClaimIsNoNotif,
  xreserve AS InsuranceClaimIsReserve,
  cast(wf_exec_time as timestamp) AS InsurClmWrkflwExecDteTme,
  wf_status AS InsurClmWorkflowStatus,
  max_itemnr AS InsuranceClaimMaxItemNumber,
  sif_status AS InsurClmSecondInjuryFundStatus,
  invstg_status AS InsurClmIncdntInvstgnSts,
  effective_dt AS InsuranceClaimEffectiveDate,
  lossrep_dt AS InsuranceClaimLossRepDate,
  lumpsumoption AS InsuranceClaimLumpSum,
  statpension AS InsurClmStatutoryPensionType,
  withdrawam AS InsurClmBndlWithdrawAmt,
  withdrawcurr AS InsurClmBndlWithdrawCrcy,
  withdrawseq AS InsurClmBndlWthdrwlSqnc,
  alternateben AS InsuranceClaimAlternateBenefit,
  generatenotif AS InsuranceClaimSpecialRiskNotif,
  notifreason AS InsuranceClaimNotifReason,
  autfollowup AS InsuranceClaimAutoResubmission,
  followup_dt AS InsClmAutoResubmsnDte,
  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 timestamp) AS InsurClmSpecialRiskMsgDateTime,
  cast(ben_calc_fail as timestamp) AS InsurClmIncrrtBnftCalcDateTime,
  polsystem AS InsuranceClaimPolicySystem,
  archive_status AS InsurClmArchivingStatus,
  archive_flud AS InsurClmArchResubmsnDte,
  rejection AS InsurClmArchRjcnRsn,
  deleted AS InsurClmDatabaseLineStatus
FROM icsclaim
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..*]
;