I_InsuranceObjectMasterData

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_InsuranceObjectMasterData.
-- 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_InsuranceObjectMasterData AS
SELECT
  ins_guid AS InsuranceObjectUUID,
  ins_category AS InsuranceObjectCategory,
  ins_typ AS InsuranceObjectType,
  ins_id AS CollateralInsuranceObjectID,
  ins_desc AS InsuranceObjectDescription,
  insur_tax_db AS InsuranceObjectBankTaxDebit,
  setlmnt_type AS InsuranceObjectSettlementType,
  insur_sum AS InsuranceObjectSumAmount,
  insur_curr AS InsuranceObjectSumCurrency,
  prm_rt AS InsuranceObjectPremiumRate,
  insur_premium AS InsuranceObjectPremiumAmount,
  insur_prm_curr AS InsuranceObjectPremiumCurrency,
  insur_tax_rt AS InsuranceObjectTaxRate,
  insur_tax_amt AS InsuranceObjectTaxAmount,
  insur_tax_curr AS InsuranceObjectTaxCurrency,
  ins_strt_dat AS InsuranceObjectStartDate,
  insur_expy_dat AS InsuranceObjectExpiryDate,
  reqd_insur_cvr AS InsuranceObjRequiredCoverAmt,
  reqd_insur_curr AS InsuranceObjRequiredCoverCrcy,
  insurer_nam AS InsuranceObjectInsurerName,
  insurer_inf AS InsuranceObjectInsurerDesc,
  cover_mkt AS InsuranceObjectMarketCover,
  share_cvr_mkt AS InsuranceObjMarketCoverShrAmt,
  sh_cvr_mkt_cur AS InsuranceObjMarketCoverShrCrcy,
  contact_firm AS InsuranceObjectContactFirmName,
  contact_partner AS InsuranceObjContactPartnerName,
  tarrif AS InsuranceObjectTariffDesc,
  contract_strt_dt AS InsuranceObjContractBeginDate,
  contract_end_dt AS InsuranceObjectContractEndDate,
  contract_con_dt AS InsuranceObjContrConclusionDte,
  insur_status AS InsuranceObjectStatus,
  insur_status_dt AS InsuranceObjectStatusDate,
  sum_one_tm_con AS InsuranceObjOneTimeContrbnAmt,
  one_tm_con_cky AS InsuranceObjOneTmeContrbnCrcy,
  dynamics AS InsurObjHasDynamicAdaption,
  per_dynamics AS InsuranceObjectDynamicsPct,
  termin_prd AS InsuranceObjectTermnPeriod,
  term_prd_unit AS InsuranceObjectTermnPeriodUnit,
  recall_prd AS InsuranceObjectRecallPeriod,
  recall_prd_unit AS InsuranceObjRecallPeriodUnit,
  ins_sum_srvl AS InsuranceObjectSurvivalBnftAmt,
  ins_sum_srvl_cky AS InsuranceObjSurvivalBnftCrcy,
  ins_sum_dth AS InsuranceObjectDeathBnftAmt,
  ins_sum_dth_cky AS InsuranceObjDeathBnftCrcy,
  ins_benf_exp AS InsuranceObjectExpiryBnftAmt,
  ins_benf_exp_cky AS InsuranceObjExpiryBnftCrcy,
  dt_prob_ben_exp AS InsuranceObjExpiryBnftDate,
  admin_org_unit AS CollateralAdminOrgUnit,
  bankarea AS CollateralBankArea
FROM cms_ins
LEFT OUTER JOIN I_InsuranceObjectData AS _InsuranceObjectData ON InsuranceObjectUUID = _InsuranceObjectData.InsuranceObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON InsuranceObjectUUID = _ObjectInsuranceLinkData.ObjectInsuranceReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_InsurancePersonSpecification AS _InsurancePersonSpecification ON InsuranceObjectUUID = _InsurancePersonSpecification.InsuranceObjectUUID  -- 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_LiquidationData AS _LiquidationData ON InsuranceObjectUUID = _LiquidationData.ObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_InsuranceObjectType AS _InsuranceObjectType ON InsuranceObjectCategory = _InsuranceObjectType.InsuranceObjectCategory AND InsuranceObjectType = _InsuranceObjectType.InsuranceObjectType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_CollateralObjectCategory AS _InsuranceObjectCategory ON InsuranceObjectCategory = _InsuranceObjectCategory.CollateralObjectCategory  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _InsuranceObjectSettlementType ON InsuranceObjectSettlementType = _InsuranceObjectSettlementType.CollateralAttributeIndType AND _InsuranceObjectSettlementType.CollateralAttributeIndCat = 'INS001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _InsuranceObjectStatus ON InsuranceObjectStatus = _InsuranceObjectStatus.CollateralAttributeIndType AND _InsuranceObjectStatus.CollateralAttributeIndCat = 'INS003'  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectFrequencyUnit AS _InsuranceObjTermnPeriodUnit ON InsuranceObjectTermnPeriodUnit = _InsuranceObjTermnPeriodUnit.InsuranceObjectFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_InsuranceObjectFrequencyUnit AS _InsuranceObjRecallPeriodUnit ON InsuranceObjRecallPeriodUnit = _InsuranceObjRecallPeriodUnit.InsuranceObjectFrequencyUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjectSumCurrency ON InsuranceObjectSumCurrency = _InsuranceObjectSumCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjectPremiumCrcy ON InsuranceObjectPremiumCurrency = _InsuranceObjectPremiumCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjectTaxCurrency ON InsuranceObjectTaxCurrency = _InsuranceObjectTaxCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjRequiredCoverCrcy ON InsuranceObjRequiredCoverCrcy = _InsuranceObjRequiredCoverCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjMktCoverShrCrcy ON InsuranceObjMarketCoverShrCrcy = _InsuranceObjMktCoverShrCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjOneTmeContrbnCrcy ON InsuranceObjOneTmeContrbnCrcy = _InsuranceObjOneTmeContrbnCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjSurvivalBnftCrcy ON InsuranceObjSurvivalBnftCrcy = _InsuranceObjSurvivalBnftCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjDeathBnftCrcy ON InsuranceObjDeathBnftCrcy = _InsuranceObjDeathBnftCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _InsuranceObjExpiryBnftCrcy ON InsuranceObjExpiryBnftCrcy = _InsuranceObjExpiryBnftCrcy.Currency  -- association [0..1]
;