What is I_CollateralRealEstatePart in SAP S/4HANA?

I_CollateralRealEstatePart is a basic CDS view in SAP S/4HANA. Part Details for Collateral Real Estate It contains 0 fields.

Which tables does I_CollateralRealEstatePart read from?

I_CollateralRealEstatePart reads data from: cms_re_obj_prt.

What VDM layer is I_CollateralRealEstatePart?

I_CollateralRealEstatePart is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CollateralRealEstatePart

DDL: I_COLLATERALREALESTATEPART Type: view BASIC

1 Data Sources 63 Associations

Part Details for Collateral Real Estate

I_CollateralRealEstatePart (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

CollateralRealEstatePart · Cross Applications

I_CollateralRealEstatePart is a Basic CDS View (Dimension) that provides data about "Part Details for Collateral Real Estate" in SAP S/4HANA. It reads from 1 data source (cms_re_obj_prt). It has 63 associations to related views.

SAP Help Documentation

Category	Real Estate
Data Category	Dimension
Status	Released
Data Extraction Type	Delta enabled
Corresponding DataSource	ICREPART

Purpose
This CDS view provides the prerequisites to answer the following business question: What are the details of the collateral real estate part?

Prerequisites
This CDS view inherits the authorization object from CDS view I_CollateralRealEstate (see below under Related Information ).

Structure
Measures and Attributes Some important measures and attributes are: CollateralRealEstatePartUUID ColltrlREPartConvertedID CollateralRealEstateUUID CollateralRealEstatePartID ColltrlREBuildingPartType ColltrlRealEstateUtilization ColltrlREPartDescription ColltrlREReferencePartUUID ColltrlREResidentialRentType

SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. For details about the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content .

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	FS-CMS
Capabilities	Analytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Data Extraction, Data Source for Defining CDS Entities
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
cms_re_obj_prt	cms_re_obj_prt	from

Associations (63)

Cardinality	Target	Alias	Condition
[0..1]	I_ColltrlREPartMaster	_ColltrlREPartMaster	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartMaster.CollateralRealEstatePartUUID`
[0..1]	I_CollateralRealEstate	_CollateralRealEstate	`$projection.CollateralRealEstateUUID = _CollateralRealEstate.CollateralRealEstateUUID`
[0..1]	I_CollateralRealEstateMaster	_CollateralRealEstateMaster	`$projection.CollateralRealEstateUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID`
[0..*]	I_ColltrlREPartAccessory	_ColltrlREPartAccessory	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartAccessory.CollateralRealEstatePartUUID`
[0..*]	I_ColltrlREPartAccessoryMaster	_ColltrlREPartAccessoryMaster	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartAccessoryMaster.CollateralRealEstatePartUUID`
[0..*]	I_ColltrlREPartPartner	_ColltrlREPartPartner	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartPartner.CollateralRealEstatePartUUID`
[0..*]	I_CollateralRealEstatePartCost	_CollateralRealEstatePartCost	`$projection.CollateralRealEstatePartUUID = _CollateralRealEstatePartCost.CollateralRealEstatePartUUID`
[0..*]	I_ColltrlREPartValue	_ColltrlREPartValue	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartValue.CollateralRealEstatePartUUID`
[0..*]	I_ColltrlRELandRegister	_ColltrlRELandRegister	`$projection.CollateralRealEstatePartUUID = _ColltrlRELandRegister.CollateralRealEstatePartUUID`
[0..*]	I_ObjectAssetData	_ObjectAssetData	`$projection.ColltrlREPartConvertedID = _ObjectAssetData.ObjectAssetReferenceNumber`
[0..1]	I_ColltrlREUsageType	_ColltrlREMainUsageType	`$projection.ColltrlREMainUsageType = _ColltrlREMainUsageType.CollateralRealEstateUsageType`
[0..1]	I_ColltrlREUsageType	_ColltrlREAdditionalUsageType1	`$projection.ColltrlREAdditionalUsageType1 = _ColltrlREAdditionalUsageType1.CollateralRealEstateUsageType`
[0..1]	I_ColltrlREUsageType	_ColltrlREAdditionalUsageType2	`$projection.ColltrlREAdditionalUsageType2 = _ColltrlREAdditionalUsageType2.CollateralRealEstateUsageType`
[0..1]	I_ColltrlREUtilization	_ColltrlREUtilization	`$projection.ColltrlRealEstateUtilization = _ColltrlREUtilization.ColltrlRealEstateUtilization`
[0..1]	I_UnitOfMeasure	_ColltrlREUsblAreaUoM	`$projection.ColltrlREUsblAreaUoM = _ColltrlREUsblAreaUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRERntdUsblAreaUoM	`$projection.ColltrlRERntdUsblAreaUoM = _ColltrlRERntdUsblAreaUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlREUsblVolumeUoM	`$projection.ColltrlREUsblVolumeUoM = _ColltrlREUsblVolumeUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRERntdUsblVolumeUoM	`$projection.ColltrlRERntdUsblVolumeUoM = _ColltrlRERntdUsblVolumeUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRERsdntlAreaUoM	`$projection.ColltrlRERsdntlAreaUoM = _ColltrlRERsdntlAreaUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRESecdryAreaUoM	`$projection.ColltrlRESecdryAreaUoM = _ColltrlRESecdryAreaUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlREOthAreaUnitOfMeasure	`$projection.ColltrlREOthAreaUnitOfMeasure = _ColltrlREOthAreaUnitOfMeasure.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRELandAreaUoM	`$projection.ColltrlRELandAreaUnitOfMeasure = _ColltrlRELandAreaUoM.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ColltrlRERntdLandAreaUoM	`$projection.ColltrlRERntdLandAreaUoM = _ColltrlRERntdLandAreaUoM.UnitOfMeasure`
[0..1]	I_Currency	_ColltrlRERsdntlPlndRentCrcy	`$projection.ColltrlRERsdntlPlndRentCrcy = _ColltrlRERsdntlPlndRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRERsdntlActlRentCrcy	`$projection.ColltrlRERsdntlActlRentCrcy = _ColltrlRERsdntlActlRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRERsdntlComparRentCrcy	`$projection.ColltrlRERsdntlComparRentCrcy = _ColltrlRERsdntlComparRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlREDailyAvgPriceCrcy	`$projection.ColltrlREDailyAvgPriceCurrency = _ColltrlREDailyAvgPriceCrcy.Currency`
[0..1]	I_Currency	_ColltrlRETurnoverCurrency	`$projection.ColltrlRETurnoverCurrency = _ColltrlRETurnoverCurrency.Currency`
[0..1]	I_Currency	_ColltrlREBldngPrgrsCurrency	`$projection.ColltrlREBldngProgressCurrency = _ColltrlREBldngPrgrsCurrency.Currency`
[0..1]	I_Currency	_ColltrlREInsuranceCurrency	`$projection.ColltrlREInsuranceCurrency = _ColltrlREInsuranceCurrency.Currency`
[0..1]	I_Currency	_ColltrlRERsdntlRatnCostCrcy	`$projection.ColltrlRERsdntlRatnCostCrcy = _ColltrlRERsdntlRatnCostCrcy.Currency`
[0..1]	I_Currency	_ColltrlREExtLaytCostCrcy	`$projection.ColltrlREExtLayoutCostCurrency = _ColltrlREExtLaytCostCrcy.Currency`
[0..1]	I_Currency	_ColltrlRECommlRatnCostCrcy	`$projection.ColltrlRECommlRatnCostCurrency = _ColltrlRECommlRatnCostCrcy.Currency`
[0..1]	I_Currency	_ColltrlREGrssColdRentCrcy	`$projection.ColltrlREGrossColdRentCurrency = _ColltrlREGrssColdRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRENetColdRentCurrency	`$projection.ColltrlRENetColdRentCurrency = _ColltrlRENetColdRentCurrency.Currency`
[0..1]	I_Currency	_ColltrlRECommlPlndRentCrcy	`$projection.ColltrlRECommlPlndRentCurrency = _ColltrlRECommlPlndRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRECommlActlRentCrcy	`$projection.ColltrlRECommlActlRentCurrency = _ColltrlRECommlActlRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRECommlComparRentCrcy	`$projection.ColltrlRECommlComparRentCrcy = _ColltrlRECommlComparRentCrcy.Currency`
[0..1]	I_Currency	_ColltrlRELandPlndRentCurrency	`$projection.ColltrlRELandPlndRentCurrency = _ColltrlRELandPlndRentCurrency.Currency`
[0..1]	I_Currency	_ColltrlRELandActlRentCurrency	`$projection.ColltrlRELandActlRentCurrency = _ColltrlRELandActlRentCurrency.Currency`
[0..1]	I_Currency	_ColltrlRELandCostCurrency	`$projection.ColltrlRELandCostCurrency = _ColltrlRELandCostCurrency.Currency`
[0..1]	I_Currency	_ColltrlREDevCostCurrency	`$projection.ColltrlREDevCostCurrency = _ColltrlREDevCostCurrency.Currency`
[0..1]	I_Currency	_ColltrlREAddlLandCostCurrency	`$projection.ColltrlREAddlLandCostCurrency = _ColltrlREAddlLandCostCurrency.Currency`
[0..1]	I_Currency	_ColltrlRECnstrctnCostCurrency	`$projection.ColltrlRECnstrctnCostCurrency = _ColltrlRECnstrctnCostCurrency.Currency`
[0..1]	I_Currency	_ColltrlREYrlyGrssProfitCrcy	`$projection.ColltrlREYrlyGrssProfitCrcy = _ColltrlREYrlyGrssProfitCrcy.Currency`
[0..1]	I_ColltrlREBasePeriod	_ColltrlRERsdntlBasePeriod	`$projection.ColltrlREResidentialBasePeriod = _ColltrlRERsdntlBasePeriod.CollateralRealEstateBasePeriod`
[0..1]	I_ColltrlREBasePeriod	_ColltrlRECommercialBasePeriod	`$projection.ColltrlRECommercialBasePeriod = _ColltrlRECommercialBasePeriod.CollateralRealEstateBasePeriod`
[0..1]	I_ColltrlREBasePeriod	_ColltrlRELandRentBasePeriod	`$projection.ColltrlRELandRentBasePeriod = _ColltrlRELandRentBasePeriod.CollateralRealEstateBasePeriod`
[0..1]	I_ColltrlREBaseMeasure	_ColltrlRERsdntlBaseMeasure	`$projection.ColltrlRERsdntlBaseMeasure = _ColltrlRERsdntlBaseMeasure.ColltrlRealEstateBaseMeasure`
[0..1]	I_ColltrlREBaseMeasure	_ColltrlRECommlBaseMeasure	`$projection.ColltrlRECommercialBaseMeasure = _ColltrlRECommlBaseMeasure.ColltrlRealEstateBaseMeasure`
[0..1]	I_ColltrlREBaseMeasure	_ColltrlRELandRentBaseMeasure	`$projection.ColltrlRELandRentBaseMeasure = _ColltrlRELandRentBaseMeasure.ColltrlRealEstateBaseMeasure`
[0..1]	I_ColltrlREBaseMeasure	_ColltrlRECnstrctnCostBaseMsr	`$projection.ColltrlRECnstrctnCostBaseMsr = _ColltrlRECnstrctnCostBaseMsr.ColltrlRealEstateBaseMeasure`
[0..1]	I_CollateralAttributeIndType	_ColltrlREBuildingPartType	`$projection.ColltrlREBuildingPartType = _ColltrlREBuildingPartType.CollateralAttributeIndType and _ColltrlREBuildingPartType.CollateralAttributeIndCat = 'REO006'`
[0..1]	I_CollateralAttributeIndType	_ColltrlRealEstatePrtCondition	`$projection.ColltrlRealEstatePartCondition = _ColltrlRealEstatePrtCondition.CollateralAttributeIndType and _ColltrlRealEstatePrtCondition.CollateralAttributeIndCat = 'REO001'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREBuildingMethodRoof	`$projection.ColltrlREBuildingMethodRoof = _ColltrlREBuildingMethodRoof.CollateralAttributeIndType and _ColltrlREBuildingMethodRoof.CollateralAttributeIndCat = 'REO007'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREBuildingMethodBody	`$projection.ColltrlREBuildingMethodBody = _ColltrlREBuildingMethodBody.CollateralAttributeIndType and _ColltrlREBuildingMethodBody.CollateralAttributeIndCat = 'REO008'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREBuildingMethodCellar	`$projection.ColltrlREBuildingMethodCellar = _ColltrlREBuildingMethodCellar.CollateralAttributeIndType and _ColltrlREBuildingMethodCellar.CollateralAttributeIndCat = 'REO009'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREBldngSctnDescription	`$projection.ColltrlREBldngSctnDescription = _ColltrlREBldngSctnDescription.CollateralAttributeIndType and _ColltrlREBldngSctnDescription.CollateralAttributeIndCat = 'REO015'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREPriceCategory	`$projection.ColltrlRealEstatePriceCategory = _ColltrlREPriceCategory.CollateralAttributeIndType and _ColltrlREPriceCategory.CollateralAttributeIndCat = 'REO013'`
[0..1]	I_CollateralAttributeIndType	_ColltrlRERentalAgreementType	`$projection.ColltrlRERentalAgreementType = _ColltrlRERentalAgreementType.CollateralAttributeIndType and _ColltrlRERentalAgreementType.CollateralAttributeIndCat = 'REO014'`
[0..1]	I_CollateralAttributeIndType	_ColltrlREInsuranceType	`$projection.ColltrlRealEstateInsuranceType = _ColltrlREInsuranceType.CollateralAttributeIndType and _ColltrlREInsuranceType.CollateralAttributeIndCat = 'REO011'`
[0..*]	I_ColltrlREPartDocument	_ColltrlREPartDocument	`$projection.CollateralRealEstatePartUUID = _ColltrlREPartDocument.CollateralRealEstatePartUUID`
[0..*]	I_CollateralAssetData	_CollateralAssetData	`$projection.ColltrlREPartConvertedID = _CollateralAssetData.CollateralAssetReferenceNumber`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	ICREPART	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ObjectModel.usageType.serviceQuality	A	view
ObjectModel.usageType.sizeCategory	L	view
ObjectModel.usageType.dataClass	MASTER	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	CollateralRealEstatePartUUID	view
ObjectModel.sapObjectNodeType.name	CollateralRealEstatePart	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.internalName	#LOCAL	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Part Details for Collateral Real Estate	view

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_CollateralRealEstatePart.
-- 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_CollateralRealEstatePart AS
SELECT *  -- field list not available in parsed metadata
FROM cms_re_obj_prt
LEFT OUTER JOIN I_ColltrlREPartMaster AS _ColltrlREPartMaster ON CollateralRealEstatePartUUID = _ColltrlREPartMaster.CollateralRealEstatePartUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstate AS _CollateralRealEstate ON CollateralRealEstateUUID = _CollateralRealEstate.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_CollateralRealEstateMaster AS _CollateralRealEstateMaster ON CollateralRealEstateUUID = _CollateralRealEstateMaster.CollateralRealEstateUUID  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartAccessory AS _ColltrlREPartAccessory ON CollateralRealEstatePartUUID = _ColltrlREPartAccessory.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartAccessoryMaster AS _ColltrlREPartAccessoryMaster ON CollateralRealEstatePartUUID = _ColltrlREPartAccessoryMaster.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartPartner AS _ColltrlREPartPartner ON CollateralRealEstatePartUUID = _ColltrlREPartPartner.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralRealEstatePartCost AS _CollateralRealEstatePartCost ON CollateralRealEstatePartUUID = _CollateralRealEstatePartCost.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREPartValue AS _ColltrlREPartValue ON CollateralRealEstatePartUUID = _ColltrlREPartValue.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ColltrlRELandRegister AS _ColltrlRELandRegister ON CollateralRealEstatePartUUID = _ColltrlRELandRegister.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_ObjectAssetData AS _ObjectAssetData ON ColltrlREPartConvertedID = _ObjectAssetData.ObjectAssetReferenceNumber  -- association [0..*]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREMainUsageType ON ColltrlREMainUsageType = _ColltrlREMainUsageType.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREAdditionalUsageType1 ON ColltrlREAdditionalUsageType1 = _ColltrlREAdditionalUsageType1.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUsageType AS _ColltrlREAdditionalUsageType2 ON ColltrlREAdditionalUsageType2 = _ColltrlREAdditionalUsageType2.CollateralRealEstateUsageType  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREUtilization AS _ColltrlREUtilization ON ColltrlRealEstateUtilization = _ColltrlREUtilization.ColltrlRealEstateUtilization  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREUsblAreaUoM ON ColltrlREUsblAreaUoM = _ColltrlREUsblAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdUsblAreaUoM ON ColltrlRERntdUsblAreaUoM = _ColltrlRERntdUsblAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREUsblVolumeUoM ON ColltrlREUsblVolumeUoM = _ColltrlREUsblVolumeUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdUsblVolumeUoM ON ColltrlRERntdUsblVolumeUoM = _ColltrlRERntdUsblVolumeUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERsdntlAreaUoM ON ColltrlRERsdntlAreaUoM = _ColltrlRERsdntlAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRESecdryAreaUoM ON ColltrlRESecdryAreaUoM = _ColltrlRESecdryAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlREOthAreaUnitOfMeasure ON ColltrlREOthAreaUnitOfMeasure = _ColltrlREOthAreaUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRELandAreaUoM ON ColltrlRELandAreaUnitOfMeasure = _ColltrlRELandAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ColltrlRERntdLandAreaUoM ON ColltrlRERntdLandAreaUoM = _ColltrlRERntdLandAreaUoM.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlPlndRentCrcy ON ColltrlRERsdntlPlndRentCrcy = _ColltrlRERsdntlPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlActlRentCrcy ON ColltrlRERsdntlActlRentCrcy = _ColltrlRERsdntlActlRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlComparRentCrcy ON ColltrlRERsdntlComparRentCrcy = _ColltrlRERsdntlComparRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREDailyAvgPriceCrcy ON ColltrlREDailyAvgPriceCurrency = _ColltrlREDailyAvgPriceCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRETurnoverCurrency ON ColltrlRETurnoverCurrency = _ColltrlRETurnoverCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREBldngPrgrsCurrency ON ColltrlREBldngProgressCurrency = _ColltrlREBldngPrgrsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREInsuranceCurrency ON ColltrlREInsuranceCurrency = _ColltrlREInsuranceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRERsdntlRatnCostCrcy ON ColltrlRERsdntlRatnCostCrcy = _ColltrlRERsdntlRatnCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREExtLaytCostCrcy ON ColltrlREExtLayoutCostCurrency = _ColltrlREExtLaytCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlRatnCostCrcy ON ColltrlRECommlRatnCostCurrency = _ColltrlRECommlRatnCostCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREGrssColdRentCrcy ON ColltrlREGrossColdRentCurrency = _ColltrlREGrssColdRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRENetColdRentCurrency ON ColltrlRENetColdRentCurrency = _ColltrlRENetColdRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlPlndRentCrcy ON ColltrlRECommlPlndRentCurrency = _ColltrlRECommlPlndRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlActlRentCrcy ON ColltrlRECommlActlRentCurrency = _ColltrlRECommlActlRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECommlComparRentCrcy ON ColltrlRECommlComparRentCrcy = _ColltrlRECommlComparRentCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandPlndRentCurrency ON ColltrlRELandPlndRentCurrency = _ColltrlRELandPlndRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandActlRentCurrency ON ColltrlRELandActlRentCurrency = _ColltrlRELandActlRentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRELandCostCurrency ON ColltrlRELandCostCurrency = _ColltrlRELandCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREDevCostCurrency ON ColltrlREDevCostCurrency = _ColltrlREDevCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREAddlLandCostCurrency ON ColltrlREAddlLandCostCurrency = _ColltrlREAddlLandCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlRECnstrctnCostCurrency ON ColltrlRECnstrctnCostCurrency = _ColltrlRECnstrctnCostCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ColltrlREYrlyGrssProfitCrcy ON ColltrlREYrlyGrssProfitCrcy = _ColltrlREYrlyGrssProfitCrcy.Currency  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRERsdntlBasePeriod ON ColltrlREResidentialBasePeriod = _ColltrlRERsdntlBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRECommercialBasePeriod ON ColltrlRECommercialBasePeriod = _ColltrlRECommercialBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBasePeriod AS _ColltrlRELandRentBasePeriod ON ColltrlRELandRentBasePeriod = _ColltrlRELandRentBasePeriod.CollateralRealEstateBasePeriod  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRERsdntlBaseMeasure ON ColltrlRERsdntlBaseMeasure = _ColltrlRERsdntlBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRECommlBaseMeasure ON ColltrlRECommercialBaseMeasure = _ColltrlRECommlBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRELandRentBaseMeasure ON ColltrlRELandRentBaseMeasure = _ColltrlRELandRentBaseMeasure.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREBaseMeasure AS _ColltrlRECnstrctnCostBaseMsr ON ColltrlRECnstrctnCostBaseMsr = _ColltrlRECnstrctnCostBaseMsr.ColltrlRealEstateBaseMeasure  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingPartType ON ColltrlREBuildingPartType = _ColltrlREBuildingPartType.CollateralAttributeIndType AND _ColltrlREBuildingPartType.CollateralAttributeIndCat = 'REO006'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRealEstatePrtCondition ON ColltrlRealEstatePartCondition = _ColltrlRealEstatePrtCondition.CollateralAttributeIndType AND _ColltrlRealEstatePrtCondition.CollateralAttributeIndCat = 'REO001'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodRoof ON ColltrlREBuildingMethodRoof = _ColltrlREBuildingMethodRoof.CollateralAttributeIndType AND _ColltrlREBuildingMethodRoof.CollateralAttributeIndCat = 'REO007'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodBody ON ColltrlREBuildingMethodBody = _ColltrlREBuildingMethodBody.CollateralAttributeIndType AND _ColltrlREBuildingMethodBody.CollateralAttributeIndCat = 'REO008'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBuildingMethodCellar ON ColltrlREBuildingMethodCellar = _ColltrlREBuildingMethodCellar.CollateralAttributeIndType AND _ColltrlREBuildingMethodCellar.CollateralAttributeIndCat = 'REO009'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREBldngSctnDescription ON ColltrlREBldngSctnDescription = _ColltrlREBldngSctnDescription.CollateralAttributeIndType AND _ColltrlREBldngSctnDescription.CollateralAttributeIndCat = 'REO015'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREPriceCategory ON ColltrlRealEstatePriceCategory = _ColltrlREPriceCategory.CollateralAttributeIndType AND _ColltrlREPriceCategory.CollateralAttributeIndCat = 'REO013'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlRERentalAgreementType ON ColltrlRERentalAgreementType = _ColltrlRERentalAgreementType.CollateralAttributeIndType AND _ColltrlRERentalAgreementType.CollateralAttributeIndCat = 'REO014'  -- association [0..1]
LEFT OUTER JOIN I_CollateralAttributeIndType AS _ColltrlREInsuranceType ON ColltrlRealEstateInsuranceType = _ColltrlREInsuranceType.CollateralAttributeIndType AND _ColltrlREInsuranceType.CollateralAttributeIndCat = 'REO011'  -- association [0..1]
LEFT OUTER JOIN I_ColltrlREPartDocument AS _ColltrlREPartDocument ON CollateralRealEstatePartUUID = _ColltrlREPartDocument.CollateralRealEstatePartUUID  -- association [0..*]
LEFT OUTER JOIN I_CollateralAssetData AS _CollateralAssetData ON ColltrlREPartConvertedID = _CollateralAssetData.CollateralAssetReferenceNumber  -- association [0..*]
;

Depth:

I_CollateralRealEstatePart view

cms_re_obj_prt

R_CollateralRealEstatePartTP view_entity