SAP Real Estate Tables
Are you looking for the right table related to SAP Real Estate Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Real Estate (FS-CMS-MD-RE) module.
Top 10 tables in Real Estate
| Table | Description |
|---|---|
| TCMS_RE_U_CAT_T | Object usage category(Text table) |
| TCMS_OMS_ID_CT_T | Attribute Indicator category - Text table |
| TCMS_RE_BPRL_T | Business partner roles(Text table) |
| TCMS_RE_HER_RG_T | Heritable Building rights(Text table) |
| TCMS_RE_ENV_ST_T | Environmental Status(Text table) |
| TCMS_RE_FX_FIT | Customizing table for fixtures and fitting types |
| CMS_RE_OBJ | Real estate header details |
| TCMS_RE_LOC_MA | Customizing table for Macro location types |
| CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here |
| TCMS_RE_CST_TY | Customizing table for Object Cost Type |
List of tables in Real Estate
| Table | Description |
|---|---|
| TCMS_RE_U_CAT_T | Object usage category(Text table) |
| TCMS_OMS_ID_CT_T | Attribute Indicator category - Text table |
| TCMS_RE_BPRL_T | Business partner roles(Text table) |
| TCMS_RE_HER_RG_T | Heritable Building rights(Text table) |
| TCMS_RE_ENV_ST_T | Environmental Status(Text table) |
| TCMS_RE_FX_FIT | Customizing table for fixtures and fitting types |
| CMS_RE_OBJ | Real estate header details |
| TCMS_RE_LOC_MA | Customizing table for Macro location types |
| CMS_RE_OBJ_BP | Link between Real estate objects and BuPa is stored here |
| TCMS_RE_CST_TY | Customizing table for Object Cost Type |
| TCMS_RE_ACS_TY | Customizing table for Object Accessories Type |
| TCMS_RE_APPL | Customizing table for Applications |
| TCMS_RE_BPRL | Customizing table for Business Partner roles |
| CMS_RE_PRT_VAL | Real Estate Part value details |
| TCMS_RE_EX_BPRL | Customizing table for External BuPa roles |
| TCMS_RE_C_CAT_T | System table for Cost Category (text table) |
| CMS_RE_OBJ_DOC | Link between Real estate objects and Doc is stored here |
| CMS_RE_OBJ_SPC | Space Details to describe a real estate object |
| TCMS_OMS_ID_TY_T | Attribute Indicator type - Text Table |
| TCMS_RE_APPL_T | Application name(Text table) |
| TCMS_RE_C_CAT | System table for Cost Category |
| TCMS_RE_LGL_MS | Customizing table for Legal Measure types |
| TCMS_RE_ACS_TY_T | Customizing table for Object Accessories Type (text table) |
| TCMS_RE_ACS_SAS | Acs type - Sub Asset relation |
| TCMS_RE_FX_FIT_T | Fixtures and Fittings type(Text table) |
| TCMS_RE_LGL_MS_T | Legal measure types(Text table) |
| CMS_RE_OBJ_RL | Real Estate Object role details |
| CMS_RE_OBJ_PRT | Real Estate Object part details |
| CMS_RE_PRT_BP | Real Estate Part BP details |
| TCMS_OMS_ID_TY | Attribute Indicator type |
| CMS_RE_PRT_LR | Real Estate Part LR details |
| TCMS_RE_EX_DOC | Customizing table for External Doc types |
| CMS_RE_PRT_DOC | Real Estate Document details |
| TCMS_RE_EX_TYP | Customizing table for External object types |
| TCMS_OMS_ID_CT | Attribute Indicator category |
| TCMS_VAL_PARAM_T | Text table for valuation parameters |
| TCMS_RE_STR_T | Building Structures Types(Text table) |
| TCMS_RE_U_TYP_T | Object usage(Text table) |
| TCMS_RE_LR_ID | Land Registers Identifiers |
| CMS_RE_PRT_ACS | Real Estate Part accessory details |
| TCMS_RE_U_CAT | System table for Object Usage Category |
| TCMS_RE_T_CAT_T | Object category(Text table) |
| CMS_RE_PRT_CST | Real Estate Part Cost details |
| TCMS_RE_TR_CON | Customizing table for Transport connection types |
| TCMS_RE_COND | Customizing table for real estate conditions |
| TCMS_RE_ENV_ST | Customizing table for envirnonmental status |
| TCMS_VAL_COMP | Valuation components |
| TCMS_RE_T_CAT | System table for Object category |
| TCMS_RE_CST_TY_T | Customizing table for Object Cost Type (text table) |
| TCMS_RE_OBJ_PRT | Real Estate object type - Building Parts relationship |
| TCMS_RE_SP_TYP | Customizing table for space types |
| TCMS_RE_ST_CAT | System table for Object Status Category |
| TCMS_RE_PRT_TY_T | Customizing table for Object Part Type (text table) |
| TCMS_VAL_COMP_T | Text table for valuation components |
| TCMS_RE_ST_CAT_T | Object Status category(Text table) |
| TCMS_RE_P_CAT | Building Part Category |
| TCMS_RE_SP_TYP_T | Space Types(Text table) |
| TCMS_VAL_PARAM | Valuation parameters |
| TCMS_RE_TRNSCTN | Customizing table for Transaction codes |
| TCMS_RE_PRIOR | Priority for Real estate |
| TCMS_RE_OBJ_ACS | Real Estate object type - Accessories relationship |
| TCMS_RE_PRT_TY | Customizing table for Object Part Type |
| TCMS_VAL_RES_T | Text table of real estate valuation results |
| TCMS_RE_TR_CON_T | Transport connection types(Text table) |
| TCMS_VAL_RES | Real estate valuation results |
| TCMS_RE_LOC_MI_T | Micro location types(Text table) |
| TCMS_RE_PRT_SAS | Building Part type - Sub Asset relation |
| TCMS_VAL_PARGP_T | Text table for parameter groups of valuation |
| TCMS_VAL_PARGP | Grouping factor for valuation fields in formula builder |
| TCMS_RE_STATUS | Customizing table for Object status |
| TCMS_RE_STATUS_T | Object status(Text table) |
| TCMS_RE_LR_ID_T | Land Registers Identifiers Text |
| TCMS_RE_STR | Customizing table for Building Structure types |
| TCMS_RE_TYP_T | Object types(Text table) |
| TCMS_RE_TYP | Customizing table for real estate types |
| TCMS_RE_LOC_MI | Customizing table for Micro location types |
| TCMS_RE_LOC_MA_T | Macro location types(Text table) |
| TCMS_RE_U_TYP | Customizing table for Object usage |
| TCMS_RE_COND_T | Object condition(Text table) |
| TCMS_RE_HER_RG | Customizing table for Heritable building rights |
| TCMS_RE_P_CAT_T | System table for Building Part Category (text table) |