I_CollateralRealEstateMaster

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_CollateralRealEstateMaster.
-- 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_CollateralRealEstateMaster AS
SELECT
  obj_guid AS CollateralRealEstateUUID,
  object_id AS CollateralRealEstateIdentifier,
  object_type AS CollateralRealEstateType,
  addr_id AS CollateralRealEstateAddressID,
  object_desc AS ColltrlRealEstateDescription,
  obj_parent_id AS CollateralRealEstateParentUUID,
  obj_old_ref_no AS ColltrlREExtReferenceNumber,
  fix_fitting_typ AS ColltrlREFixtureFittingType,
  object_area_uom AS CollateralRealEstateAreaUnit,
  object_vol_uom AS CollateralRealEstateVolumeUnit,
  object_curr AS ColltrlREObjectCurrency,
  macro_loc_type AS ColltrlRealEstateMacroLocation,
  micro_loc_type AS ColltrlRealEstateMicroLocation,
  tran_conn_type AS ColltrlRETransptConncn,
  environ_status AS ColltrlREEnvironmentalStatus,
  flood_zone_flg AS ColltrlRealEstateIsFloodZone,
  earthquake_flg AS ColltrlREIsEarthquakeZone,
  arct_conv_flg AS ColltrlREIsArchlConsvnArea,
  hist_site_flg AS ColltrlREIsHistoricalSite,
  is_val_imp_facs AS ColltrlREHasFctrsImprngVal,
  value_imp_desc AS ColltrlREFctrsImprngValDesc,
  admin_org_unit AS CollateralAdminOrgUnit,
  bankarea AS CollateralBankArea,
  created_by AS CollateralRealEstateEnteredBy,
  created_date AS ColltrlRealEstateEnteredDate,
  created_time AS ColltrlRealEstateEnteredTime,
  entry_src AS ColltrlRealEstateEnteredSource,
  last_chg_by AS ColltrlRealEstateLastChangedBy,
  last_chg_date AS ColltrlRELastChangedDate,
  last_chg_time AS ColltrlRELastChangedTime,
  processing_src AS ColltrlRELastChangedSource
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_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]
;