- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_RealEstateObjPrtMstrData
Real Estate Object Part Details
| view: IREOBJPRTMD | ATTR
| Extraction:
Full or Incremental
| Component: Collateral Management System
Tables used:
CMS_RE_OBJ_PRT
- 🔑 Keys (1)
- 💰 Amounts (22)
- ∑ Quantities (9)
- 📅 Dates (12)
- ☰ Categorical (15)
- Other (41)
- 🔗 Relations (26)
| Column Name | Description | |
|---|---|---|
| RealEstatePrtUUID | GUID for Object part |
| Column Name | Description | |
|---|---|---|
| 💲 Planned Rent Currency (REPrtResidentialPlndRentCrcy): | ||
| REPrtResidentialPlndRentAmt | Planned Rent Amount | |
| 💲 Actual Rent Currency (REPrtResidentialActlRentCrcy): | ||
| REPrtResidentialActlRentAmt | Actual Rent Amount | |
| 💲 Comparative Rent Currency - Residential (REPrtComparativeRentCurrency): | ||
| REPrtComparativeRentAmount | Comparative Rent (Residential) | |
| 💲 Average Price Currency (REPrtAveragePricePerDayCrcy): | ||
| REPrtAveragePricePerDayAmt | Average Price per Day | |
| 💲 Currency (RealEstatePrtTurnoverCrcy): | ||
| RealEstatePrtTurnoverAmt | Total Amount of Turnover | |
| 💲 Building Progress Amount Curreny (REPrtBuildingProgressCrcy): | ||
| REPrtBuildingProgressAmt | Amount Disbursed for Construction based on Building Progress | |
| 💲 Insurance Currency (RealEstatePrtInsuranceCrcy): | ||
| RealEstatePrtInsuranceAmt | Insurance Amount | |
| 💲 Rationing cost currency (RealEstatePrtRationCostCrcy): | ||
| RealEstatePrtRationCostAmt | Residential Rationing Cost | |
| 💲 External Layout cost currency (REPrtExternalLayoutCostCrcy): | ||
| REPrtExternalLayoutCostAmt | External Layout Cost | |
| 💲 Rationing cost currency (REPrtCommercialRationCostCrcy): | ||
| REPrtCommercialRationCostAmt | Commercial Rationing Cost | |
| 💲 Gross Cold Rent Currency (RealEstatePrtGrossColdRentCrcy): | ||
| RealEstatePrtGrossColdRentAmt | Gross Cold Rent | |
| 💲 Net Cold Rent Currency (RealEstatePrtNetColdRentCrcy): | ||
| RealEstatePrtNetColdRentAmt | Net Cold Rent | |
| 💲 Planned Rent Currency (REPrtCommercialPlannedRentCrcy): | ||
| REPrtCommercialPlannedRentAmt | Planned Rent Amount | |
| 💲 Actual Rent Currency (REPrtCommercialActualRentCrcy): | ||
| REPrtCommercialActualRentAmt | Actual Rent Amount | |
| 💲 Comparative Rent Currency (Commercial) (REPrtCommercialComparRentCrcy): | ||
| REPrtCommercialComparRentAmt | Comparative Rent (Commercial) | |
| 💲 Planned Rent Currency (RealEstatePrtPlannedRentCrcy): | ||
| RealEstatePrtPlannedRentAmt | Planned Rent Amount | |
| 💲 Actual Rent Currency (RealEstatePrtActualRentCrcy): | ||
| RealEstatePrtActualRentAmt | Actual Rent Amount | |
| 💲 Land Cost Currency (RealEstatePrtLandCostCrcy): | ||
| RealEstatePrtLandCostAmt | Land Cost Amount | |
| 💲 Dev Cost Currency (REPrtDevelopmentCostCrcy): | ||
| REPrtDevelopmentCostAmt | Development Cost Amount | |
| 💲 Additional Land Cost Currency (REPrtAdditionalLandCostCrcy): | ||
| REPrtAdditionalLandCostAmt | Additional Land Cost Amount | |
| 💲 Construction cost currency (REPrtConstructionCostCrcy): | ||
| REPrtConstructionCostAmt | Construction Cost | |
| 💲 Yearly Gross Profit Currency (REPrtYearlyGrossProfitCrcy): | ||
| REPrtYearlyGrossProfitAmt | Yearly Gross Profit | |
| Column Name | Description | |
|---|---|---|
| 📏 Unit of Measure for Usable Area (RealEstatePrtUsableAreaUnitMsr): | ||
| RealEstatePrtUsableAreaSize | Usable Area | |
| 📏 Unit of Measure for Usable Rented Area (REPrtRentedUsableAreaUnitMsr): | ||
| REPrtRentedUsableAreaSize | Rented Usable Area | |
| 📏 Unit of Measure for Usable Volume of Real Estate (REPrtUsableVolumeUnitMsr): | ||
| RealEstatePrtUsableVolume | Usable Volume of Real Estate Building Parts | |
| 📏 Unit of measure for usable volume of Rented Parts (REPrtRentedUsableVolumeUnitMsr): | ||
| REPrtRentedUsableVolume | Usable Volume of the Rented Portions of Real Estate | |
| 📏 Unit of Measure for Residential Area (REPrtResidentialAreaUnitMsr): | ||
| REPrtResidentialAreaSize | Residential Area | |
| 📏 Unit of Measure for Secondary Area (REPrtSecondaryAreaUnitMsr): | ||
| REPrtSecondaryAreaSize | Secondary Area | |
| 📏 Unit of Measure for Other Area (RealEstatePrtOtherAreaUnitMsr): | ||
| RealEstatePrtOtherAreaSize | Other Area | |
| 📏 Unit of Measure of Land Area (RealEstatePrtLandAreaUnitMsr): | ||
| RealEstatePrtLandAreaSize | Land Area of the Real Estate | |
| 📏 Land area unit of measure(rented) (REPrtRentedLandAreaUnitMsr): | ||
| REPrtRentedLandAreaSize | Land Area of the Real Estate which is Rented | |
| Column Name | Description | |
|---|---|---|
| REPrtConstructionStartDate | Start Date of Construction | |
| REPrtPermissionAppliedDate | Building Permssion applied date | |
| REPrtPermissionObtainedDate | Building Permssion obtained date | |
| RealEstatePrtOccupancyDate | Occupancy Date | |
| RealEstatePrtCompletionDate | Completion Date | |
| REPrtFinalInspectionDate | Date of Final Inspection | |
| REPrtLastConstructionRptDate | Date of Last Constuction Report | |
| RealEstatePrtInsurValidToDate | Date until which the Insurance Stands Valid | |
| RealEstatePrtEnteredDate | Created On | |
| RealEstatePrtEnteredTime | Created At | |
| RealEstatePrtLastChangedDate | Last Changed On | |
| RealEstatePrtLastChangedTime | Last Changed At |
| Column Name | Description | |
|---|---|---|
| RealEstatePrtUtilization | Utilization of the Object | Show values |
| RealEstatePrtThirdPartyUsage | Indicates if Usages in addition to Main Usage are Possible | Show values |
| RealEstatePrtIsSubAssetCreated | Indicates whether a Sub-asset is created for Building Part | Show values |
| REPrtResidentialBasePeriod | Base period for the rent | Show values |
| REPrtResidentialBaseMeasure | Base Measure | Show values |
| RealEstatePrtRentType | Indicator for Net or Gross Rent | Show values |
| REPrtCommercialBasePeriod | Base period for the rent | Show values |
| REPrtCommercialBaseMsr | Base Measure | Show values |
| REPrtCommercialRentType | Indicator for Rent Type | Show values |
| RealEstatePrtRentBasePeriod | Base period for the rent | Show values |
| RealEstatePrtRentBaseMeasure | Base Measure | Show values |
| RealEstatePrtLandCostBaseMsr | Base measure of Land | Show values |
| REPrtDevelopmentCostBaseMsr | Base measure of Land | Show values |
| REPrtAdditionalLandCostBaseMsr | Base measure of Land | Show values |
| REPrtConstructionCostBaseMsr | Base Measure | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| RealEstatePrtID | Part ID for the Object | CMS_RE_PRT_ID | |
| RealEstatePrtDescription | Description of Building Part | CMS_RE_DESC | |
| REPrtCommercialUsagePercent | Commercial Usage as a Percentage of Total Usage | CMS_RE_PCT | |
| RealEstatePrtRefObjectUUID | Reference Object Part GUID | SYSUUID | |
| REPrtNumberOfBuildingPrt | Number of building part units | CMS_RE_UNITS | |
| REPrtNumberOfBuildingPrtRented | Number of building part units rented | CMS_RE_UNITS | |
| REPrtVacantPositionPercent | Ratio of Real Estate not rented to Total Real Estate Value | CMS_RE_PCT | |
| RealEstatePrtNumberOfUnits | No of units in real estate object | CMS_RE_UNITS | |
| RealEstatePrtNumberOfFloors | Number of Floors | CMS_RE_UNITS | |
| REPrtNumberOfGarages | No of Garages in Real Estate Object | CMS_RE_UNITS | |
| REPrtNumberOfGaragesRented | No of Garages Rented in Real Estate Object | CMS_RE_UNITS | |
| REPrtNumberOfParking | Number of Parking Units | CMS_RE_UNITS | |
| REPrtNumberOfParkingRented | Number of Parking Units Rented | CMS_RE_UNITS | |
| REPrtNrOfUndrGrndParking | Number of Underground Parking Units | CMS_RE_UNITS | |
| REPrtNrOfUndrGrndParkingRntd | Number of Rented Underground Parking Units | CMS_RE_UNITS | |
| REPrtNumberOfCurrentUnits | No of current units in real estate object | CMS_RE_UNITS | |
| REPrtNmbrOfCurrentUnitsRented | No of Current Units Rented in Real Estate Object | CMS_RE_UNITS | |
| REPrtNumberOfOldUnits | No of old units in real estate object | CMS_RE_UNITS | |
| REPrtNumberOfOldUnitsRented | No of Old Units Rented in Real Estate Object | CMS_RE_UNITS | |
| REPrtNumberOfNewUnits | No of new units in real estate object | CMS_RE_UNITS | |
| REPrtNumberOfNewUnitsRented | No of New units Rented in Real Estate Object | CMS_RE_UNITS | |
| REPrtNumberOfAccessStructures | No of Access Structures | CMS_RE_UNITS | |
| RealEstatePrtNumberOfSaleLevel | No of Sale levels in commercial building | CMS_RE_UNITS | |
| RealEstatePrtNumberOfRooms | No of rooms in the hotel/clinic | CMS_RE_UNITS | |
| RealEstatePrtNumberOfBeds | No of beds in the clinic/nursing home | CMS_RE_UNITS | |
| REPrtCommercialEnvironmentDesc | Description of the commercial environment | CMS_RE_DESC | |
| REPrtAccessStructureDesc | Description of the Access Structures | CMS_RE_DESC | |
| RealEstatePrtOccupancyPct | Occupancy specified in Percentage Terms | CMS_RE_PCT | |
| REPrtBuildingCompletionPct | Degree of Completion of Construction | CMS_RE_PCT | |
| RealEstatePrtRationCostPct | Percentage of Residential Rationing Cost | CMS_RE_PCT | |
| REPrtExternalLayoutCostPct | External Layout Cost as Percentage of Total Cost | CMS_RE_PCT | |
| REPrtCommercialRationCostPct | Percentage of Commercial Rationing Cost | CMS_RE_PCT | |
| RealEstatePrtEnteredBy | Real Estate Add-On User | CMS_RE_USER | |
| RealEstatePrtEnteredSource | Sorce of Initial entry | CMS_RE_SOURCE | |
| RealEstatePrtLastChangedBy | Last Changed By | CMS_RE_USER | |
| RealEstatePrtLastChangedSource | Processing Source | CMS_RE_SOURCE | |
| REPrtCommlNmbrOfYrsLastValn | No of years since Last Valuation of Commercial Real Estate | CMS_RE_INT1 | |
| REPrtCommercialInterestRate | Interest rate (Com) | CMS_RE_PCT | |
| REPrtRsdntlLastValnNrOfYrs | No. of Years since Real Estate was last Valued | CMS_RE_INT1 | |
| REPrtRsdntlInterestRate | Interest rate used in Valuation of Residential Real Estate | CMS_RE_PCT | |
| RealEstatePrtDepreciationPct | Depriciation | CMS_RE_PCT |
| Master Data Relations | Join Conditions |
|---|---|
Usage type Foreign key
|
|
Usage type Foreign key
|
|
Building method - Body
|
|
Building method - Cellar
|
|
Building method - Roof
|
|
Building Part Type
|
|
Object condition
|
|
Gross Cold Rent Currency
| |
Insurance Currency
| |
Insurance Type
|
|
Foreign key for Unit of measure
| |
Usage type Foreign key
|
|
Net Cold Rent Currency
| |
Foreign key for Currency
| |
Price Category
|
|
Rental Agreement Type
|
|
Foreign key for Currency
| |
| Foreign key for Object GUID | I_REALESTATEOBJPRTMSTRDATA.MANDT == CMS_RE_OBJ.MANDT |
Average Price Currency
| |
Building Section
|
|
Actual Rent Currency
| |
Comparative Rent Currency (Commercial)
| |
Foreign key for Currency
| |
Comparative Rent Currency - Residential
| |
Actual Rent Currency
| |
Foreign key for Currency
|