I_InsurancePersonSpecification

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_InsurancePersonSpecification.
-- 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_InsurancePersonSpecification AS
SELECT
  ins_psn_guid AS InsurancePersonUUID,
  ins_guid AS InsuranceObjectUUID,
  insrd_prsn_nm AS InsurancePersonName,
  prsn_status AS InsurancePersonStatus,
  prsn_status_dt AS InsurancePersonStatusDate,
  spec_ins_rnk_pr AS InsurancePersonRankDesc,
  insured_rsk AS InsurancePersonRisk,
  sgle_prm AS InsurancePersonSinglePremAmt,
  sgle_prm_cky AS InsurancePersonSinglePremCrcy,
  one_tme_con AS InsurPersnOneTmeContrbnAmt,
  one_tme_con_cky AS InsurPersonOneTimeContrbnCrcy,
  renew_dat AS InsurancePersonPremRenewalDate,
  created_by AS InsurancePersonEnteredBy,
  created_at AS InsurancePersonEnteredDateTime,
  changed_by AS InsurancePersonLastChangedBy,
  changed_at AS InsurancePersonLastChgdDteTme,
  sourceofentry AS InsurancePersonEnteredSource,
  _InsuranceObjectData.InsuranceObjectCategory AS InsuranceObjectCategory
FROM cms_ins_psn
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON InsuranceObjectUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectMasterData AS _InsuranceObjectMasterData ON InsuranceObjectUUID = _InsuranceObjectMasterData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON InsuranceObjectUUID = _ObjectInsuranceLinkData.ObjectInsuranceReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetPartner AS _InsuranceObjectPartner ON InsuranceObjectUUID = _InsuranceObjectPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _InsuranceObjectDocument ON InsuranceObjectUUID = _InsuranceObjectDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectValuationLinkData AS _ObjectValuationLinkData ON InsuranceObjectUUID = _ObjectValuationLinkData.ObjectValuationLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _InsurancePersonStatus ON InsurancePersonStatus = _InsurancePersonStatus.CollateralAttributeIndType AND _InsurancePersonStatus.CollateralAttributeIndCat = 'INS003'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _InsurancePersonRisk ON InsurancePersonRisk = _InsurancePersonRisk.CollateralAttributeIndType AND _InsurancePersonRisk.CollateralAttributeIndCat = 'INS002'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsurancePersonSinglePremCrcy ON InsurancePersonSinglePremCrcy = _InsurancePersonSinglePremCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsurPersonOneTimeContrbnCrcy ON InsurPersonOneTimeContrbnCrcy = _InsurPersonOneTimeContrbnCrcy.Currency  -- association [0..1]
;