I_CollateralInsurance

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_CollateralInsurance.
-- 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_CollateralInsurance AS
SELECT
  ins_guid AS CollateralInsuranceUUID,
  cast( bintohex( ins_guid ) as cms_dte_obj_refid ) AS CollateralInsuranceConvertedID,
  ins_category AS CollateralObjectCategory,
  ins_typ AS CollateralInsuranceType,
  ins_id AS CollateralInsuranceIdentifier,
  ins_desc AS CollateralInsuranceDescription,
  insur_tax_db AS ColltrlInsuranceBankTaxDebit,
  setlmnt_type AS ColltrlInsuranceSettlementType,
  insur_sum AS CollateralInsuranceSumAmount,
  insur_curr AS CollateralInsuranceSumCurrency,
  prm_rt AS CollateralInsurancePremiumRate,
  insur_premium AS ColltrlInsurancePremiumAmount,
  insur_prm_curr AS ColltrlInsurPremiumCurrency,
  insur_tax_rt AS CollateralInsuranceTaxRate,
  insur_tax_amt AS CollateralInsuranceTaxAmount,
  insur_tax_curr AS CollateralInsuranceTaxCurrency,
  ins_strt_dat AS CollateralInsuranceStartDate,
  insur_expy_dat AS CollateralInsuranceExpiryDate,
  reqd_insur_cvr AS ColltrlInsurRqdCoverAmount,
  reqd_insur_curr AS ColltrlInsurRqdCoverCurrency,
  insurer_nam AS CollateralInsuranceInsurerName,
  insurer_inf AS ColltrlInsurInsurerDescription,
  cover_mkt AS CollateralInsuranceCoverMarket,
  share_cvr_mkt AS ColltrlInsurCovrMktShareAmount,
  sh_cvr_mkt_cur AS ColltrlInsurCovrMktShrCurrency,
  contact_firm AS ColltrlInsurContactFirmName,
  contact_partner AS ColltrlInsurContactPartnerName,
  tarrif AS ColltrlInsurTariffDescription,
  contract_strt_dt AS ColltrlInsurContractBeginDate,
  contract_end_dt AS ColltrlInsurContractEndDate,
  contract_con_dt AS ColltrlInsurContrCnclsnDate,
  insur_status AS CollateralInsuranceStatus,
  insur_status_dt AS CollateralInsuranceStatusDate,
  sum_one_tm_con AS ColltrlInsurOneTmeContrbnAmt,
  one_tm_con_cky AS ColltrlInsurOneTmeContrbnCrcy,
  dynamics AS ColltrlInsurHasDynamicAdaption,
  per_dynamics AS ColltrlInsurDynamicsPercent,
  termin_prd AS ColltrlInsurTerminationPeriod,
  term_prd_unit AS ColltrlInsurTermnPeriodUnit,
  recall_prd AS ColltrlInsuranceRecallPeriod,
  recall_prd_unit AS ColltrlInsurRecallPeriodUnit,
  ins_sum_srvl AS ColltrlInsurSurvlBenefitAmount,
  ins_sum_srvl_cky AS ColltrlInsurSurvlBnftCurrency,
  ins_sum_dth AS ColltrlInsurDeathBenefitAmount,
  ins_sum_dth_cky AS ColltrlInsurDthBenefitCurrency,
  ins_benf_exp AS ColltrlInsurExpryBenefitAmount,
  ins_benf_exp_cky AS ColltrlInsurExpryBnftCurrency,
  dt_prob_ben_exp AS ColltrlInsurExpiryBenefitDate,
  admin_org_unit AS CollateralAdminOrgUnit,
  bankarea AS CollateralBankArea,
  created_by AS CollateralInsuranceEnteredBy,
  created_at AS ColltrlInsurEnteredDateTime,
  changed_by AS ColltrlInsuranceLastChangedBy,
  changed_at AS ColltrlInsurLastChgdDateTime,
  sourceofentry AS ColltrlInsuranceEnteredSource,
  bupr_id AS CollateralBusinessProcessUUID,
  bupr_type_code AS ColltrlBusinessProcessTypeCode,
  ext_itm_no AS CollateralExternalItemNumber,
  ext_reference AS ColltrlExternalReferenceNumber,
  ins_comp AS CollateralInsuranceCompanyName,
  fop AS ColltrlInsurPaymentFrequency,
  freq_unit AS ColltrlInsuranceFrequencyUnit
FROM cms_ins
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON CollateralInsuranceUUID = _ObjectInsuranceLinkData.ObjectInsuranceReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlInsurPersnSpec AS _ColltrlInsurPersnSpec ON CollateralInsuranceUUID = _ColltrlInsurPersnSpec.CollateralInsuranceUUID  -- 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_ObjectAssetData AS _ObjectAssetData ON CollateralInsuranceConvertedID = _ObjectAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_LiquidationData AS _LiquidationData ON CollateralInsuranceUUID = _LiquidationData.ObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralInsuranceType AS _CollateralInsuranceType ON CollateralObjectCategory = _CollateralInsuranceType.CollateralObjectCategory AND CollateralInsuranceType = _CollateralInsuranceType.CollateralInsuranceType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_CollateralObjectCategory AS _CollateralObjectCategory ON CollateralObjectCategory = _CollateralObjectCategory.CollateralObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlInsurSettlementType ON _ColltrlInsurSettlementType.CollateralAttributeIndCat = 'INS001' AND ColltrlInsuranceSettlementType = _ColltrlInsurSettlementType.CollateralAttributeIndType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _CollateralInsuranceStatus ON _CollateralInsuranceStatus.CollateralAttributeIndCat = 'INS003' AND CollateralInsuranceStatus = _CollateralInsuranceStatus.CollateralAttributeIndType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlInsurFrequencyUnit AS _ColltrlInsurTermnPeriodUnit ON ColltrlInsurTermnPeriodUnit = _ColltrlInsurTermnPeriodUnit.ColltrlInsuranceFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_ColltrlInsurFrequencyUnit AS _ColltrlInsurRecallPeriodUnit ON ColltrlInsurRecallPeriodUnit = _ColltrlInsurRecallPeriodUnit.ColltrlInsuranceFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsuranceSumCurrency ON CollateralInsuranceSumCurrency = _ColltrlInsuranceSumCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurPremiumCurrency ON ColltrlInsurPremiumCurrency = _ColltrlInsurPremiumCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsuranceTaxCurrency ON CollateralInsuranceTaxCurrency = _ColltrlInsuranceTaxCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurRqdCoverCurrency ON ColltrlInsurRqdCoverCurrency = _ColltrlInsurRqdCoverCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurCovrMktShrCrcy ON ColltrlInsurCovrMktShrCurrency = _ColltrlInsurCovrMktShrCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurOneTmeContrbnCrcy ON ColltrlInsurOneTmeContrbnCrcy = _ColltrlInsurOneTmeContrbnCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurSurvlBnftCurrency ON ColltrlInsurSurvlBnftCurrency = _ColltrlInsurSurvlBnftCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurDthBnftCurrency ON ColltrlInsurDthBenefitCurrency = _ColltrlInsurDthBnftCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlInsurExpryBnftCurrency ON ColltrlInsurExpryBnftCurrency = _ColltrlInsurExpryBnftCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CollateralInsuranceLinkData AS _CollateralInsuranceLinkData ON CollateralInsuranceUUID = _CollateralInsuranceLinkData.ColltrlInsuranceReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetPartner AS _CollateralAssetPartner ON CollateralInsuranceUUID = _CollateralAssetPartner.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetDocument AS _CollateralAssetDocument ON CollateralInsuranceUUID = _CollateralAssetDocument.CollateralAssetUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetData AS _CollateralAssetData ON CollateralInsuranceConvertedID = _CollateralAssetData.CollateralAssetReferenceNumber  -- association [0..*]
;