CMS_RE_OBJ_PRT is a SAP table coming under FS module and EA-FINSERV component.View details, Fields & related tables of CMS_RE_OBJ_PRT in SAP.
- Table description : Real Estate Object part details
- Module : FS-CMS-MD-RE
- Parent Module : FS
- Package : CMS_RE
- Software Component : EA-FINSERV
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP CMS_RE_OBJ_PRT Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
.INCLUDE | Primary key for Object part | ||
OBJ_PRT_GUID | GUID for Object part | CMS_RE_DTE_OBJ_PRT_GUID | SYSUUID |
.INCLUDE | Link structure for the real estate object | ||
OBJ_GUID | GUID for Real Estate Object | CMS_RE_DTE_OBJ_GUID | SYSUUID |
.INCLUDE | Structure for Part ID | ||
PART_ID | Part ID for the Object | CMS_RE_DTE_PART_ID | CMS_RE_PRT_ID |
.INCLUDE | Structure for Basic Part Details | ||
BLD_PART_TYPE | Building Part Type | CMS_RE_DTE_ATT_ID_TY_REO006 | CMS_ATT_ID_TYP |
PART_COND | Object condition | CMS_RE_DTE_ATT_ID_TY_REO001 | CMS_ATT_ID_TYP |
MAIN_USAGE | Usage Type | CMS_RE_DTE_USG_TYP | CMS_RE_TYP |
ADD_USAGE_1 | Additional Usage 1 | CMS_RE_DTE_ADD1_USG_TYP | CMS_RE_TYP |
ADD_USAGE_2 | Additional Usage 2 | CMS_RE_DTE_ADD2_USG_TYP | CMS_RE_TYP |
BLD_METHOD_ROOF | Building method - Roof | CMS_RE_DTE_ATT_ID_TY_REO007 | CMS_ATT_ID_TYP |
BLD_METHOD_BODY | Building method - Body | CMS_RE_DTE_ATT_ID_TY_REO008 | CMS_ATT_ID_TYP |
BLD_METD_CELLAR | Building method - Cellar | CMS_RE_DTE_ATT_ID_TY_REO009 | CMS_ATT_ID_TYP |
UTILIZATION | Utilization of the Object | CMS_RE_DTE_PRT_UTILIZATION | CMS_RE_UTIL |
PART_DESC | Description of Building Part | CMS_RE_DTE_SPC_DESC | CMS_RE_DESC |
COMM_USAGE_PCT | Commercial Usage as a Percentage of Total Usage | CMS_RE_DTE_COM_USE_PCT | CMS_RE_PCT |
OTHER_USG_FLG | Indicates if Usages in addition to Main Usage are Possible | CMS_RE_DTE_OTH_USE_FLG | CMS_RE_OTH_USG_FLG |
REF_OBJ_PRT_GUID | Reference Object Part GUID | CMS_RE_DTE_REF_OBJ_PRT_GUID | SYSUUID |
IS_SUB_AST_CREA | Indicates whether a Sub-asset is created for Building Part | CMS_RE_DTE_CREATE_SUB_AST_FLG | CMS_RE_FLG |
.INCLUDE | Structure for Part Size Details | ||
USEFUL_AREA | Usable Area | CMS_RE_DTE_AREA_USEFUL | CMS_RE_SIZE |
USBL_AREA_UOM | Unit of Measure for Usable Area | CMS_RE_DTE_USBL_AREA_UOM | MEINS |
USEFUL_AREA_REN | Rented Usable Area | CMS_RE_DTE_AREA_USEFUL_REN | CMS_RE_SIZE |
USBL_AR_REN_UOM | Unit of Measure for Usable Rented Area | CMS_RE_DTE_USBL_AREA_REN_UOM | MEINS |
USEFUL_VOL | Usable Volume of Real Estate Building Parts | CMS_RE_DTE_VOL_USEFUL | CMS_RE_SIZE |
USBL_VOL_UOM | Unit of Measure for Usable Volume of Real Estate | CMS_RE_DTE_USBL_VOL_UOM | MEINS |
USEFUL_VOL_REN | Usable Volume of the Rented Portions of Real Estate | CMS_RE_DTE_VOL_USEFUL_REN | CMS_RE_SIZE |
USBL_VL_REN_UOM | Unit of measure for usable volume of Rented Parts | CMS_RE_DTE_USBL_VOL_REN_UOM | MEINS |
RESIDENTIAL_AREA | Residential Area | CMS_RE_DTE_AREA_RESIDENTIAL | CMS_RE_SIZE |
RES_AR_UOM | Unit of Measure for Residential Area | CMS_RE_DTE_RES_AREA_UOM | MEINS |
SECONDARY_AREA | Secondary Area | CMS_RE_DTE_AREA_SECONDARY | CMS_RE_SIZE |
SEC_AREA_UOM | Unit of Measure for Secondary Area | CMS_RE_DTE_SEC_AREA_UOM | MEINS |
OTHER_AREA | Other Area | CMS_RE_DTE_AREA_OTHER | CMS_RE_SIZE |
OTH_AREA_UOM | Unit of Measure for Other Area | CMS_RE_DTE_OTH_AREA_UOM | MEINS |
.INCLUDE | Structure for Part Unit Details | ||
NO_PRT_UNIT | Number of building part units | CMS_RE_DTE_NO_PRT_UNIT | CMS_RE_UNITS |
NO_PRT_UNIT_REN | Number of building part units rented | CMS_RE_DTE_NO_PRT_UNIT_REN | CMS_RE_UNITS |
.INCLUDE | Structure for dates | ||
CONS_START_DATE | Start Date of Construction | CMS_RE_DTE_OBJ_CONS_ST_DATE | CMS_RE_DATE |
PERMSN_APPL_DATE | Building Permssion applied date | CMS_RE_DTE_OBJ_PMSN_APPL_DATE | CMS_RE_DATE |
PERMSN_OBTD_DATE | Building Permssion obtained date | CMS_RE_DTE_OBJ_PMSN_OBTD_DATE | CMS_RE_DATE |
OCCY_DATE | Occupancy Date | CMS_RE_DTE_OBJ_OCCY_DATE | CMS_RE_DATE |
COMP_DATE | Completion Date | CMS_RE_DTE_OBJ_COMP_DATE | CMS_RE_DATE |
FINAL_INSP_DATE | Date of Final Inspection | CMS_RE_DTE_OBJ_FINAL_INSP_DATE | CMS_RE_DATE |
.INCLUDE | |||
.INCLUDE | Structure for Part Rent Details | ||
RENT_AMT_PLANNED | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CMS_RE_AMOUNT |
RENT_AMT_ACTUAL | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CMS_RE_AMOUNT |
RENT_PLAN_CURR | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | WAERS |
RENT_ACT_CURR | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | WAERS |
BASE_PERIOD | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CMS_RE_BASE_PERIOD |
BASE_MEASURE | Base Measure | CMS_RE_DTE_BASE_MEAS | CMS_RE_BASE_MEAS |
VACANT_POSN_PCT | Ratio of Real Estate not rented to Total Real Estate Value | CMS_RE_DTE_VACANT_POS_PCT | CMS_RE_PCT |
RES_RENT_IND | Indicator for Net or Gross Rent | CMS_RE_DTE_RES_IND | CMS_RE_RENT_FLG |
COMP_RENT_RES | Comparative Rent (Residential) | CMS_RE_DTE_RENT_LEVEL | CMS_RE_AMOUNT |
COM_REN_RES_CURR | Comparative Rent Currency - Residential | CMS_RE_DTE_COMP_RENT_RES_CURR | WAERS |
.INCLUDE | Structure for Land Area & UOM | ||
LAND_AREA | Land Area of the Real Estate | CMS_RE_DTE_LAND_AREA | CMS_RE_SIZE |
LAND_AREA_UOM | Unit of Measure of Land Area | CMS_RE_DTE_LAND_AREA_UOM | MEINS |
LAND_AREA_REN | Land Area of the Real Estate which is Rented | CMS_RE_DTE_LAND_AREA_REN | CMS_RE_SIZE |
LAND_AR_REN_UOM | Land area unit of measure(rented) | CMS_RE_DTE_LAND_AREA_REN_UOM | MEINS |
.INCLUDE | Structure for General Details | ||
NO_OF_UNITS | No of units in real estate object | CMS_RE_DTE_NO_UNIT | CMS_RE_UNITS |
NO_OF_FLOORS | Number of Floors | CMS_RE_DTE_NO_FLOOR | CMS_RE_UNITS |
NO_GARAGES | No of Garages in Real Estate Object | CMS_RE_DTE_NO_GAR | CMS_RE_UNITS |
NO_GARAGES_REN | No of Garages Rented in Real Estate Object | CMS_RE_DTE_NO_GAR_REN | CMS_RE_UNITS |
NO_PARK_UNIT | Number of Parking Units | CMS_RE_DTE_NO_PARK_UNIT | CMS_RE_UNITS |
NO_PARK_UNIT_REN | Number of Parking Units Rented | CMS_RE_DTE_NO_PARK_UNIT_REN | CMS_RE_UNITS |
NO_PARK_UG | Number of Underground Parking Units | CMS_RE_DTE_NO_PARK_UNIT_UG | CMS_RE_UNITS |
NO_PARK_UG_REN | Number of Rented Underground Parking Units | CMS_RE_DTE_NO_PARK_UNIT_UG_REN | CMS_RE_UNITS |
.INCLUDE | Structure for Residential Details | ||
NO_CUR_UNITS | No of current units in real estate object | CMS_RE_DTE_NO_CUR_UNIT | CMS_RE_UNITS |
NO_CUR_UNITS_REN | No of Current Units Rented in Real Estate Object | CMS_RE_DTE_NO_CUR_UNIT_REN | CMS_RE_UNITS |
NO_OLD_UNITS | No of old units in real estate object | CMS_RE_DTE_NO_OLD_UNIT | CMS_RE_UNITS |
NO_OLD_UNITS_REN | No of Old Units Rented in Real Estate Object | CMS_RE_DTE_NO_OLD_UNIT_REN | CMS_RE_UNITS |
NO_NEW_UNITS | No of new units in real estate object | CMS_RE_DTE_NO_NEW_UNIT | CMS_RE_UNITS |
NO_NEW_UNITS_REN | No of New units Rented in Real Estate Object | CMS_RE_DTE_NO_NEW_UNIT_REN | CMS_RE_UNITS |
.INCLUDE | Structure for Number of Units in Office | ||
NO_ACCESS_STR | No of Access Structures | CMS_RE_DTE_NO_ACCESS_STR | CMS_RE_UNITS |
.INCLUDE | Structure for Number of Sales level in Commericial Building | ||
NO_SALE_LEVEL | No of Sale levels in commercial building | CMS_RE_DTE_NO_SALE_LEVEL | CMS_RE_UNITS |
.INCLUDE | Structure for Number of Rooms in the hotel/clinic | ||
NO_OF_ROOMS | No of rooms in the hotel/clinic | CMS_RE_DTE_NO_ROOMS | CMS_RE_UNITS |
.INCLUDE | Structure for Number of rooms in the clinic/nursing home | ||
NO_OF_BEDS | No of beds in the clinic/nursing home | CMS_RE_DTE_NO_BEDS | CMS_RE_UNITS |
.INCLUDE | |||
.INCLUDE | Structure for Commericial Details | ||
COMM_ENV_DESC | Description of the commercial environment | CMS_RE_DTE_COMM_ENV_DESC | CMS_RE_DESC |
ACCESS_STR_DESC | Description of the Access Structures | CMS_RE_DTE_ACCESS_STR_DESC | CMS_RE_DESC |
BLD_SECTION_DESC | Building Section | CMS_RE_DTE_ATT_ID_TY_REO015 | CMS_ATT_ID_TYP |
.INCLUDE | |||
.INCLUDE | Structure for Hotel Details | ||
PRICE_CATEGORY | Price Category | CMS_RE_DTE_ATT_ID_TY_REO013 | CMS_ATT_ID_TYP |
AVG_PRICE | Average Price per Day | CMS_RE_DTE_AVG_PRICE | CMS_RE_AMOUNT |
AVG_PRICE_CURR | Average Price Currency | CMS_RE_DTE_AVG_PRICE_CURR | WAERS |
.INCLUDE | |||
.INCLUDE | Structure for Other Details in RE Object | ||
OCCUPANCY_PCT | Occupancy specified in Percentage Terms | CMS_RE_DTE_OCCY_PCT | CMS_RE_PCT |
TURNOVER_AMT | Total Amount of Turnover | CMS_RE_DTE_TURNOVER_AMOUNT | CMS_RE_AMOUNT |
TURNOVER_CURR | Currency | CMS_RE_DTE_TURNOVER_CURR | WAERS |
RENTAL_AGMT_TYP | Rental Agreement Type | CMS_RE_DTE_ATT_ID_TY_REO014 | CMS_ATT_ID_TYP |
.INCLUDE | Building Construction Progress | ||
LAST_REPORT_DATE | Date of Last Constuction Report | CMS_RE_DTE_LAST_CONST_REP_DATE | CMS_RE_DATE |
BLD_PROGRESS_AMT | Amount Disbursed for Construction based on Building Progress | CMS_RE_DTE_AMT_BLD_PROGRESS | CMS_RE_AMOUNT |
BLD_AMT_CURR | Building Progress Amount Curreny | CMS_RE_DTE_BLD_PROGRESS_CURR | WAERS |
PCT_COMPLETED | Degree of Completion of Construction | CMS_RE_DTE_DEGREE_COMPLETE | CMS_RE_PCT |
.INCLUDE | Insurance details | ||
INSURANCE_TYPE | Insurance Type | CMS_RE_DTE_ATT_ID_TY_REO011 | CMS_ATT_ID_TYP |
INSURANCE_AMT | Insurance Amount | CMS_RE_DTE_INSURANCE_AMOUNT | CMS_RE_AMOUNT |
INSURANCE_CURR | Insurance Currency | CMS_RE_DTE_INSURANCE_CURR | WAERS |
INS_VALIDITY | Date until which the Insurance Stands Valid | CMS_RE_DTE_INS_VALID_TILL | CMS_RE_DATE |
.INCLUDE | Other Costs | ||
RATIONING_COST | Residential Rationing Cost | CMS_RE_DTE_RAT_COST_AMT | CMS_RE_AMOUNT |
RTN_CST_PCT | Percentage of Residential Rationing Cost | CMS_RE_DTE_RAN_COST_PCT | CMS_RE_PCT |
EXT_LAYOUT_COST | External Layout Cost | CMS_RE_DTE_EXT_LAYOUT_COST | CMS_RE_AMOUNT |
EXT_LAY_CST_PCT | External Layout Cost as Percentage of Total Cost | CMS_RE_DTE_EXT_LAYOUT_COST_PCT | CMS_RE_PCT |
RTN_CST_CURR | Rationing cost currency | CMS_RE_DTE_RTN_CST_CURR | WAERS |
EXT_RTN_CST_CURR | External Layout cost currency | CMS_RE_DTE_EXT_LAYOUT_CST_CURR | WAERS |
RTN_CST_COM | Commercial Rationing Cost | CMS_RE_DTE_RAT_COST_AMT_COM | CMS_RE_AMOUNT |
RTN_CST_COM_CURR | Rationing cost currency | CMS_RE_DTE_RTN_CST_CURR_COM | WAERS |
RTN_CST_COM_PCT | Percentage of Commercial Rationing Cost | CMS_RE_DTE_RAN_COST_PCT_COM | CMS_RE_PCT |
.INCLUDE | Other rents | ||
GROSS_COLD_RENT | Gross Cold Rent | CMS_RE_DTE_YRLY_GROSS_COLD_REN | CMS_RE_AMOUNT |
GROSS_RENT_CURR | Gross Cold Rent Currency | CMS_RE_DTE_GROSS_RENT_CURR | WAERS |
NET_COLD_RENT | Net Cold Rent | CMS_RE_DTE_YRLY_NET_COLD_REN | CMS_RE_AMOUNT |
NET_RENT_CURR | Net Cold Rent Currency | CMS_RE_DTE_NET_RENT_CURR | WAERS |
.INCLUDE | Structure for history | ||
CREATED_BY | Real Estate Add-On User | CMS_RE_DTE_CR_BY | CMS_RE_USER |
CREATED_DATE | Created On | CMS_RE_DTE_CR_ON | CMS_RE_DATE |
CREATED_TIME | Created At | CMS_RE_DTE_CR_AT | CMS_RE_TIME |
ENTRY_SRC | Sorce of Initial entry | CMS_RE_DTE_SRC_INIT | CMS_RE_SOURCE |
LAST_CHG_BY | Last Changed By | CMS_RE_DTE_CHG_BY | CMS_RE_USER |
LAST_CHG_DATE | Last Changed On | CMS_RE_DTE_CHG_ON | CMS_RE_DATE |
LAST_CHG_TIME | Last Changed At | CMS_RE_DTE_CHG_AT | CMS_RE_TIME |
PROCESSING_SRC | Processing Source | CMS_RE_DTE_PRC_SRC | CMS_RE_SOURCE |
.INCLUDE | |||
.INCLUDE | Valuation Bases(Com) | ||
NO_OF_YEARS_COM | No of years since Last Valuation of Commercial Real Estate | CMS_RE_DTE_VAL_NO_YEARS_COM | CMS_RE_INT1 |
INT_RATE_COM | Interest rate (Com) | CMS_RE_DTE_VAL_INT_RATE_COM | CMS_RE_PCT |
.INCLUDE | Valuation Bases | ||
NO_OF_YEARS | No. of Years since Real Estate was last Valued | CMS_RE_DTE_VALUATION_NO_YEARS | CMS_RE_INT1 |
INT_RATE | Interest rate used in Valuation of Residential Real Estate | CMS_RE_DTE_VALUATION_INT_RATE | CMS_RE_PCT |
.INCLUDE | Structure for Part Rent Details | ||
RENT_PLANNED_COM | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CMS_RE_AMOUNT |
RENT_ACTUAL_COM | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CMS_RE_AMOUNT |
PLAN_CURR_COM | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | WAERS |
ACT_CURR_COM | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | WAERS |
BASE_PERIOD_COM | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CMS_RE_BASE_PERIOD |
BASE_MEAS_COM | Base Measure | CMS_RE_DTE_BASE_MEAS | CMS_RE_BASE_MEAS |
COM_RENT_IND | Indicator for Rent Type | CMS_RE_DTE_COM_IND | CMS_RE_RENT_FLG |
COMP_RENT_COM | Comparative Rent (Commercial) | CMS_RE_DTE_RENT_LEVEL_COM | CMS_RE_AMOUNT |
COMP_REN_COM_CUR | Comparative Rent Currency (Commercial) | CMS_RE_DTE_COMP_RENT_COM_CURR | WAERS |
.INCLUDE | Structure for Land Rent details | ||
PLAN_RENT_LAND | Planned Rent Amount | CMS_RE_DTE_RENT_AMOUNT | CMS_RE_AMOUNT |
ACTUAL_RENT_LAND | Actual Rent Amount | CMS_RE_DTE_RENT_AMOUNT_ACT | CMS_RE_AMOUNT |
PLAN_RENT_CURR | Planned Rent Currency | CMS_RE_DTE_RENT_PLANNED_CURR | WAERS |
ACTUAL_RENT_CURR | Actual Rent Currency | CMS_RE_DTE_RENT_ACTUAL_CURR | WAERS |
BASE_PERIOD_LAND | Base period for the rent | CMS_RE_DTE_BASE_PERIOD | CMS_RE_BASE_PERIOD |
BASE_MEAS_LAND | Base Measure | CMS_RE_DTE_BASE_MEAS | CMS_RE_BASE_MEAS |
.INCLUDE | Depriciation | ||
DEPR | Depriciation | CMS_RE_DTE_DEPR | CMS_RE_PCT |
.INCLUDE | Land Costs | ||
LAND_COST | Land Cost Amount | CMS_RE_DTE_LAND_COST | CMS_RE_AMOUNT |
LAND_COST_CURR | Land Cost Currency | CMS_RE_DTE_LAND_COST_CURR | WAERS |
DEV_COST | Development Cost Amount | CMS_RE_DTE_DEV_COST | CMS_RE_AMOUNT |
DEV_COST_CURR | Dev Cost Currency | CMS_RE_DTE_DEV_COST_CURR | WAERS |
LAND_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CMS_RE_BASE_MEAS_LAND |
DEV_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CMS_RE_BASE_MEAS_LAND |
ADD_LAND_CST | Additional Land Cost Amount | CMS_RE_DTE_ADD_LAND_COST | CMS_RE_AMOUNT |
ADD_CST_CURR | Additional Land Cost Currency | CMS_RE_DTE_ADD_LAND_COST_CURR | WAERS |
ADD_CST_BASE | Base measure of Land | CMS_RE_DTE_BASE_MEAS_LAND | CMS_RE_BASE_MEAS_LAND |
.INCLUDE | Construction Costs for Buildings | ||
CONST_COST | Construction Cost | CMS_RE_DTE_CONS_COST | CMS_RE_AMOUNT |
CONST_COST_CURR | Construction cost currency | CMS_RE_DTE_CONS_COST_CURR | WAERS |
BASE_MEAS | Base Measure | CMS_RE_DTE_BASE_MEAS | CMS_RE_BASE_MEAS |
.INCLUDE | Yearly Gross Profit for Commercial Real Estate | ||
GRS_PROFIT | Yearly Gross Profit | CMS_RE_DTE_GRS_PROFIT | CMS_RE_AMOUNT |
GRS_PROFIT_CURR | Yearly Gross Profit Currency | CMS_RE_DTE_GRS_PROFIT_CURR | WAERS |
CMS_RE_OBJ_PRT related tables
Table | Note |
---|---|
CMS_RE_OBJ_PRT | Real Estate Object part details |
CMS_RE_PRT_ACS | Real Estate Part accessory details |
CMS_RE_PRT_BP | Real Estate Part BP details |
CMS_RE_PRT_CST | Real Estate Part Cost details |
CMS_RE_PRT_LR | Real Estate Part LR details |
CMS_RE_PRT_VAL | Real Estate Part value details |
CMS_RE_OBJ_RL | Real Estate Object role details |
CMS_RE_OBJ_SPC | Space Details to describe a real estate object |
CMS_RE_OBJ | Real estate header details |
CMS_RE_PRT_DOC | Real Estate Document details |
BPOBIMMO | Business Partner - Object Relationship: Real Estate |
CHBTIV00 | Field status definitions for Real Estate object mgmt |
TCMS_RE_OBJ_ACS | Real Estate object type - Accessories relationship |
TCMS_RE_OBJ_PRT | Real Estate object type - Building Parts relationship |
TIV00 | Field status definitions for Real Estate object mgmt |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP