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,
  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,
  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,
  fnol_claimnr AS InsuranceClaimDraftIdentifier
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..*]
;