I_CollateralRealEstate

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_CollateralRealEstate.
-- 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_CollateralRealEstate AS
SELECT
  cms_re_obj.obj_guid AS CollateralRealEstateUUID,
  cast( bintohex( cms_re_obj.obj_guid ) as cms_dte_obj_refid ) AS ColltrlRealEstateConvertedID,
  cms_re_obj.object_id AS CollateralRealEstateIdentifier,
  cms_re_obj.object_type AS CollateralRealEstateType,
  cms_re_obj.addr_id AS CollateralRealEstateAddressID,
  cms_re_obj.object_desc AS ColltrlRealEstateDescription,
  cms_re_obj.obj_parent_id AS CollateralRealEstateParentUUID,
  cms_re_obj.obj_old_ref_no AS ColltrlREExtReferenceNumber,
  cms_re_obj.fix_fitting_typ AS ColltrlREFixtureFittingType,
  cms_re_obj.object_area_uom AS CollateralRealEstateAreaUnit,
  cms_re_obj.object_vol_uom AS CollateralRealEstateVolumeUnit,
  cms_re_obj.object_curr AS ColltrlREObjectCurrency,
  cms_re_obj.macro_loc_type AS ColltrlRealEstateMacroLocation,
  cms_re_obj.micro_loc_type AS ColltrlRealEstateMicroLocation,
  cms_re_obj.tran_conn_type AS ColltrlRETransptConncn,
  cms_re_obj.environ_status AS ColltrlREEnvironmentalStatus,
  cms_re_obj.flood_zone_flg AS ColltrlRealEstateIsFloodZone,
  cms_re_obj.earthquake_flg AS ColltrlREIsEarthquakeZone,
  cms_re_obj.arct_conv_flg AS ColltrlREIsArchlConsvnArea,
  cms_re_obj.hist_site_flg AS ColltrlREIsHistoricalSite,
  cms_re_obj.is_val_imp_facs AS ColltrlREHasFctrsImprngVal,
  cms_re_obj.value_imp_desc AS ColltrlREFctrsImprngValDesc,
  cms_re_obj.admin_org_unit AS CollateralAdminOrgUnit,
  cms_re_obj.bankarea AS CollateralBankArea,
  cms_re_obj.created_by AS CollateralRealEstateEnteredBy,
  cms_re_obj.created_date AS ColltrlRealEstateEnteredDate,
  cms_re_obj.created_time AS ColltrlRealEstateEnteredTime,
  cms_re_obj.entry_src AS ColltrlRealEstateEnteredSource,
  cms_re_obj.last_chg_by AS ColltrlRealEstateLastChangedBy,
  cms_re_obj.last_chg_date AS ColltrlRELastChangedDate,
  cms_re_obj.last_chg_time AS ColltrlRELastChangedTime,
  cms_re_obj.processing_src AS ColltrlRELastChangedSource,
  cms_re_obj.bupr_id AS CollateralBusinessProcessUUID,
  cms_re_obj.bupr_type_code AS ColltrlBusinessProcessTypeCode,
  cms_arc_re_obj.block_ind AS CollateralIsBlocked
FROM cms_re_obj
LEFT OUTER JOIN I_CollateralRealEstateMaster AS _CollateralRealEstateMaster ON CollateralRealEstateUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstatePart AS _CollateralRealEstatePart ON CollateralRealEstateUUID = _CollateralRealEstatePart.CollateralRealEstateUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartMaster AS _ColltrlREPartMaster ON CollateralRealEstateUUID = _ColltrlREPartMaster.CollateralRealEstateUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON ColltrlRealEstateConvertedID = _ObjectAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_ObjectInsuranceLinkData AS _ObjectInsuranceLinkData ON CollateralRealEstateUUID = _ObjectInsuranceLinkData.ObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_LiquidationData AS _LiquidationData ON CollateralRealEstateUUID = _LiquidationData.ObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstateType AS _CollateralRealEstateType ON CollateralRealEstateType = _CollateralRealEstateType.CollateralRealEstateType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAdminOrgUnitAttrib AS _CollateralAdminOrgUnitAttrib ON CollateralAdminOrgUnit = _CollateralAdminOrgUnitAttrib.CollateralAdminOrgUnit  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREFixtureFittingType AS _ColltrlREFixtureFittingType ON ColltrlREFixtureFittingType = _ColltrlREFixtureFittingType.ColltrlREFixtureFittingType  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREMacroLocation ON ColltrlRealEstateMacroLocation = _ColltrlREMacroLocation.CollateralAttributeIndType AND _ColltrlREMacroLocation.CollateralAttributeIndCat = 'REO002'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREMicroLocation ON ColltrlRealEstateMicroLocation = _ColltrlREMicroLocation.CollateralAttributeIndType AND _ColltrlREMicroLocation.CollateralAttributeIndCat = 'REO003'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRETransptConncn ON ColltrlRETransptConncn = _ColltrlRETransptConncn.CollateralAttributeIndType AND _ColltrlRETransptConncn.CollateralAttributeIndCat = 'REO004'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREEnvironmentalStatus ON ColltrlREEnvironmentalStatus = _ColltrlREEnvironmentalStatus.CollateralAttributeIndType AND _ColltrlREEnvironmentalStatus.CollateralAttributeIndCat = 'REO005'  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREObjectCurrency ON ColltrlREObjectCurrency = _ColltrlREObjectCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CollateralRealEstateAreaUnit ON CollateralRealEstateAreaUnit = _CollateralRealEstateAreaUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CollateralRealEstateVolUnit ON CollateralRealEstateVolumeUnit = _CollateralRealEstateVolUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CollateralAssetData AS _CollateralAssetData ON ColltrlRealEstateConvertedID = _CollateralAssetData.CollateralAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_CollateralInsuranceLinkData AS _CollateralInsuranceLinkData ON CollateralRealEstateUUID = _CollateralInsuranceLinkData.CollateralObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralObjectInsurance AS _CollateralObjectInsurance ON CollateralRealEstateUUID = _CollateralObjectInsurance.CollateralObjectReferenceUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREEngyPerfCert AS _ColltrlREEngyPerfCert ON CollateralRealEstateUUID = _ColltrlREEngyPerfCert.CollateralRealEstateUUID  -- association [0..*]
;