I_InsurClmPolicySnapshot

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_InsurClmPolicySnapshot.
-- 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_InsurClmPolicySnapshot AS
SELECT
  claim AS InsuranceClaim,
  polvnr AS InsurClmContractVersion,
  cast(inception as timestamp) AS InsurClmContractStartDateTime,
  cast(expiry as timestamp) AS InsurClmContractEndDateTime,
  policy_pm AS InsurancePolicy,
  multi_currency_category AS InsurClmPolicyProdMultiCrcyCat,
  curr AS InsurClmLimitAndDcblCurrency,
  plineofbus AS InsurLineOfBus,
  cast (changetime as tzntstmps preserving type) AS InsurClmChangeTime,
  changedby AS InsurClmChangedBy,
  deleted AS InsurClmDatabaseLineStatus,
  importstatus AS InsurClmPlcySnpshtImported,
  validdata AS InsurClmPlcySnpshtOverview,
  manchange AS InsurClmPlcySnpshtHasChanged,
  cast (validfrom as tzntstmps preserving type) AS InsurClmPlcySnpshtFromDateTime,
  cast (validto as tzntstmps preserving type) AS InsurClmPlcySnpshtToDateTime,
  cast (srcchange as tzntstmps preserving type) AS InsurClmPlcySnpshtVersDateTime,
  cast (issued as tzntstmps preserving type) AS InsurClmIssuePrescriptDateTime,
  juriscountry AS InsurClmJurisdictionCountry,
  jurisregion AS InsurClmJurisdictionRegion,
  ncbonus AS InsurClmPlcySnpshtDiscountRate,
  distchan AS InsurClmPlcySnpshtDistChannel,
  policy AS InsurClmBndlParentContract,
  polprod AS InsurClmPolicyProduct,
  cast (lrenewal as tzntstmps preserving type) AS InsurClmContractLastRenewal,
  polobj_cd AS InsurClmLoanHdrInsurObjId,
  benexclper AS InsurClmIsBenefitExclusion,
  polex_pm AS InsurClmPlcySnpshtNoOfPolicy,
  policy_pm_txt AS InsurClmPlcySnpshtPlcyShrtName,
  contr_pm_txt AS InsurClmBndlNameOfContrTxt,
  profile_pr_level AS InsurClmBnftProcgPrfl,
  clause AS InsurClmPlcySnpshtHasClause,
  polprodn AS InsurClmPlcySnpshtPlcyProdName,
  inscond_gen AS InsurClmGenInsurConditionsText,
  inscond_genn AS InsurClmGenConditionsDescText,
  inscond_spec AS InsurClmSpecialConditionsText,
  inscond_specn AS InsurClmSpclConditionsDescText,
  bukrs AS InsurClmReinsurPlcyCompanyCode,
  gesnr AS InsurClmReinsurBPBroker,
  mainmatur_dt AS InsurClmPlcySnpshtMainDue,
  cast (duedate as dats preserving type) AS InsurClmPlcySnpshtDueDate,
  requeststatus AS InsurClmPlcySnpshtReqStatus,
  text_langu AS InsurClmPlcySnpshtLangKey
FROM iclpol
LEFT OUTER JOIN I_InsuranceClaim AS _InsuranceClaim ON InsuranceClaim = _InsuranceClaim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmBnftTypesPlcySnpsht AS _BnftTypesPlcySnpsht ON InsuranceClaim = _BnftTypesPlcySnpsht.InsuranceClaim AND InsurClmContractVersion = _BnftTypesPlcySnpsht.InsurClmContractVersion  -- association [0..*]
;