I_ColltrlInsurPersnSpec

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_ColltrlInsurPersnSpec.
-- 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_ColltrlInsurPersnSpec AS
SELECT
  ins_psn_guid AS CollateralInsurancePersonUUID,
  ins_guid AS CollateralInsuranceUUID,
  insrd_prsn_nm AS CollateralInsuredPersonName,
  prsn_status AS CollateralInsuranceStatus,
  prsn_status_dt AS CollateralInsuranceStatusDate,
  spec_ins_rnk_pr AS ColltrlInsurRankDescription,
  insured_rsk AS CollateralInsuredRiskType,
  sgle_prm AS ColltrlInsurSglPremiumAmount,
  sgle_prm_cky AS ColltrlInsurSglPremiumCurrency,
  one_tme_con AS ColltrlInsurOneTmeContrbnAmt,
  one_tme_con_cky AS ColltrlInsurOneTmeContrbnCrcy,
  renew_dat AS ColltrlInsurPremiumRenewalDate,
  created_by AS CollateralInsuranceEnteredBy,
  created_at AS ColltrlInsurEnteredDateTime,
  changed_by AS ColltrlInsuranceLastChangedBy,
  changed_at AS ColltrlInsurLastChgdDateTime,
  sourceofentry AS ColltrlInsuranceEnteredSource
FROM cms_ins_psn
LEFT OUTER JOIN I_CollateralInsurance AS _CollateralInsurance ON CollateralInsuranceUUID = _CollateralInsurance.CollateralInsuranceUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON CollateralInsuranceUUID = _ObjectInsuranceLinkData.ObjectInsuranceReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetPartner AS _ObjectAssetPartner ON CollateralInsuranceUUID = _ObjectAssetPartner.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetDocument AS _ObjectAssetDocument ON CollateralInsuranceUUID = _ObjectAssetDocument.ObjectAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectValuationLinkData AS _ObjectValuationLinkData ON CollateralInsuranceUUID = _ObjectValuationLinkData.ObjectValuationLinkUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _CollateralInsuranceStatus ON _CollateralInsuranceStatus.CollateralAttributeIndCat = 'INS003' AND CollateralInsuranceStatus = _CollateralInsuranceStatus.CollateralAttributeIndType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _CollateralInsuredRiskType ON _CollateralInsuredRiskType.CollateralAttributeIndCat = 'INS002' AND CollateralInsuredRiskType = _CollateralInsuredRiskType.CollateralAttributeIndType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurSglPremCurrency ON ColltrlInsurSglPremiumCurrency = _ColltrlInsurSglPremCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurOneTmeContrbnCrcy ON ColltrlInsurOneTmeContrbnCrcy = _ColltrlInsurOneTmeContrbnCrcy.Currency  -- association [0..1]
;