CMS_RE_STR_OBJ SAP (Strcuture for details of Object) Structure details

Dictionary Type: Structure
Description: Strcuture for details of Object




ABAP Code to SELECT data from CMS_RE_STR_OBJ
Related tables to CMS_RE_STR_OBJ
Access table CMS_RE_STR_OBJ




Structure field list including key, data, relationships and ABAP select examples

CMS_RE_STR_OBJ is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Strcuture for details of Object" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_RE_STR_OBJ TYPE CMS_RE_STR_OBJ.

The CMS_RE_STR_OBJ table consists of various fields, each holding specific information or linking keys about Strcuture for details of Object data available in SAP. These include OBJ_GUID (GUID for Real Estate Object), OBJECT_ID (Object ID), OBJECT_TYPE (Real Estate Object Type ID), ADDR_ID (Address ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_RE_STR_OBJ structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
OBJ_GUIDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16SYSUUIDCMS_RE_OBJ_GUID
OBJECT_IDObject ID CMS_RE_DTE_OBJECT_IDCHAR20ALPHACMS_RE_OBJECT_IDCMS_RE_OBJECT_IDCMS_RE_SRCH_ALL
OBJECT_TYPEReal Estate Object Type ID CMS_RE_DTE_OBJ_TYPCHAR6TCMS_RE_TYPCMS_RE_TYPCMS_RE_OBJECT_TYPE
ADDR_IDAddress ID CMS_RE_DTE_ADDR_IDCHAR10Assigned to domainALPHAAD_ADDRNUMADMC
OBJECT_CONDCondition ID CMS_RE_DTE_OBJ_CONDCHAR6TCMS_RE_CONDCMS_RE_COND
OBJECT_DESCDescription of the Real Estate Object CMS_RE_DTE_OBJ_DESCCHAR30CMS_RE_DESC
OBJECT_PARENT_IDGUID for Real Estate Object CMS_RE_DTE_OBJ_GUIDRAW16SYSUUIDCMS_RE_OBJ_GUID
OBJECT_EXT_REFNOExternal reference Number of an External System CMS_RE_DTE_OBJ_REF_NOCHAR32CMS_RE_REFID
USAGE_TYPEUsage Type CMS_RE_DTE_USG_TYPCHAR6TCMS_RE_U_TYPCMS_RE_TYP
BLD_STR_TYPEReal Estate Building Structure ID CMS_RE_DTE_BLD_STR_TYPCHAR6TCMS_RE_STRCMS_RE_TYP
FIX_FITTING_TYPEFixtures and Fittings Type ID CMS_RE_DTE_FIX_FIT_TYPCHAR6TCMS_RE_FX_FITALPHACMS_RE_FIX_FIT_TYP
OBJECT_VALReal Estate Value CMS_RE_DTE_OBJ_VALCURR17(2) CMS_RE_AMOUNT
OBJECT_VAL_CURRCurrency for the Object Value CMS_RE_DTE_OBJ_VAL_CURRCUKY5TCURCWAERS
OBJECT_VAL_DATEObject Value Calculation Date CMS_RE_DTE_OBJ_VAL_DATEDATS8CMS_RE_DATE
AREATotal Area of the Real Estate Object CMS_RE_DTE_AREAQUAN13(3) CMS_RE_SIZE
AREA_UOMUnit of Measure for Area CMS_RE_DTE_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_AREA_UOMCMS_ELM_SURFACE_UOM
VOLUMEVolume of Real Estate Object CMS_RE_DTE_VOLQUAN13(3) CMS_RE_SIZE
VOLUME_UOMUnit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_VOL_UOMCMS_ELM_VOLUME_UOM
AREA_VALUEArea in the Real Estate which has Collateral Value CMS_RE_DTE_AREA_VALQUAN13(3) CMS_RE_SIZE
AREA_VALUE_UOMUnit of Measure for Area CMS_RE_DTE_AREA_UOMUNIT3Assigned to domainCUNITMEINSCMS_AREA_UOMCMS_ELM_SURFACE_UOM
VOLUME_VALVolume of Real Estate which has Collateral Value CMS_RE_DTE_VOLUME_VALQUAN13(3) CMS_RE_SIZE
VOLUME_VALUE_UOMUnit of Measure for Volume of Real Estate CMS_RE_DTE_VOL_UOMUNIT3Assigned to domainCUNITMEINSCMS_VOL_UOMCMS_ELM_VOLUME_UOM
MACRO_LOC_TYPEMacro Location CMS_RE_DTE_ATT_ID_TY_REO002CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MICRO_LOC_TYPEMicro Location CMS_RE_DTE_ATT_ID_TY_REO003CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
TRAN_CONN_TYPETransport Connection CMS_RE_DTE_ATT_ID_TY_REO004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
ENVIRON_STATUSEnviromental Status CMS_RE_DTE_ATT_ID_TY_REO005CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
FLOOD_ZONE_FLGIndicator for Flood Zone CMS_RE_DTE_FLOOD_ZONECHAR1ALPHACMS_RE_FLG
EARTHQUAKE_FLGIndicator : Eathquake Zone CMS_RE_DTE_EARTHQUAKECHAR1ALPHACMS_RE_FLG
ARCT_CONV_FLGIndicator for Architectural Conservation Area CMS_RE_DTE_ARCT_CONVCHAR1ALPHACMS_RE_FLG
HIST_SITE_FLGIndicator for Historical Site CMS_RE_DTE_HIST_SITECHAR1ALPHACMS_RE_FLG
IS_VAL_IMP_FACSIndicates existence of Factors Impairing Real Estate Value CMS_RE_DTE_VAL_IMP_FLGCHAR1ALPHACMS_RE_FLG
VALUE_IMP_DESCDescription of the value imparing factor CMS_RE_DTE_VAL_IMP_DESCCHAR30CMS_RE_DESC
NO_UNITSNo of units in real estate object CMS_RE_DTE_NO_UNITINT410CMS_RE_UNITS
NO_FLOORSNumber of Floors CMS_RE_DTE_NO_FLOORINT410CMS_RE_UNITS
NO_CUR_UNITSNo of current units in real estate object CMS_RE_DTE_NO_CUR_UNITINT410CMS_RE_UNITS
NO_CUR_UNITS_RENNo of Current Units Rented in Real Estate Object CMS_RE_DTE_NO_CUR_UNIT_RENINT410CMS_RE_UNITS
NO_OLD_UNITSNo of old units in real estate object CMS_RE_DTE_NO_OLD_UNITINT410CMS_RE_UNITS
NO_OLD_UNITS_RENNo of Old Units Rented in Real Estate Object CMS_RE_DTE_NO_OLD_UNIT_RENINT410CMS_RE_UNITS
NO_NEW_UNITSNo of new units in real estate object CMS_RE_DTE_NO_NEW_UNITINT410CMS_RE_UNITS
NO_NEW_UNITS_RENNo of New units Rented in Real Estate Object CMS_RE_DTE_NO_NEW_UNIT_RENINT410CMS_RE_UNITS
NO_GARAGESNo of Garages in Real Estate Object CMS_RE_DTE_NO_GARINT410CMS_RE_UNITS
NO_GARAGES_RENNo of Garages Rented in Real Estate Object CMS_RE_DTE_NO_GAR_RENINT410CMS_RE_UNITS
NO_PARK_UNITNumber of Parking Units CMS_RE_DTE_NO_PARK_UNITINT410CMS_RE_UNITS
NO_PARK_UNIT_RENNumber of Parking Units Rented CMS_RE_DTE_NO_PARK_UNIT_RENINT410CMS_RE_UNITS
NO_PARK_UGNumber of Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UGINT410CMS_RE_UNITS
NO_PARK_UG_RENNumber of Rented Underground Parking Units CMS_RE_DTE_NO_PARK_UNIT_UG_RENINT410CMS_RE_UNITS
OBJECT_PUR_PRICEBuying Price for the Real estate object CMS_RE_DTE_OBJ_PRCCURR17(2) CMS_RE_AMOUNT
OBJECT_PUR_CURRBuying Price Currency for the Real estate object CMS_RE_DTE_OBJ_PRC_CURRCUKY5TCURCWAERS
OBJECT_PUR_DATEPurchasing Date for the Real estate object CMS_RE_DTE_OBJ_PRC_DATEDATS8CMS_RE_DATE
CONS_START_DATEStart Date of Construction CMS_RE_DTE_OBJ_CONS_ST_DATEDATS8CMS_RE_DATE
PERMSN_APPL_DATEBuilding Permssion applied date CMS_RE_DTE_OBJ_PMSN_APPL_DATEDATS8CMS_RE_DATE
PERMSN_OBTD_DATEBuilding Permssion obtained date CMS_RE_DTE_OBJ_PMSN_OBTD_DATEDATS8CMS_RE_DATE
OCCY_DATEOccupancy Date CMS_RE_DTE_OBJ_OCCY_DATEDATS8CMS_RE_DATE
COMP_DATECompletion Date CMS_RE_DTE_OBJ_COMP_DATEDATS8CMS_RE_DATE
FINAL_INSP_DATEDate of Final Inspection CMS_RE_DTE_OBJ_FINAL_INSP_DATEDATS8CMS_RE_DATE
CREATED_BYReal Estate Add-On User CMS_RE_DTE_CR_BYCHAR12CMS_RE_USER
CREATED_DATECreated On CMS_RE_DTE_CR_ONDATS8CMS_RE_DATE
CREATED_TIMECreated At CMS_RE_DTE_CR_ATTIMS6CMS_RE_TIME
ENTRY_SRCSorce of Initial entry CMS_RE_DTE_SRC_INITCHAR32CMS_RE_SOURCE
LAST_CHG_BYLast Changed By CMS_RE_DTE_CHG_BYCHAR12CMS_RE_USER
LAST_CHG_DATELast Changed On CMS_RE_DTE_CHG_ONDATS8CMS_RE_DATE
LAST_CHG_TIMELast Changed At CMS_RE_DTE_CHG_ATTIMS6CMS_RE_TIME
PROCESSING_SRCProcessing Source CMS_RE_DTE_PRC_SRCCHAR32CMS_RE_SOURCE

Key field Non-key field



How do I retrieve data from SAP structure CMS_RE_STR_OBJ using ABAP code?

As CMS_RE_STR_OBJ is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_RE_STR_OBJ as there is no data to select.

How to access SAP table CMS_RE_STR_OBJ

Within an ECC or HANA version of SAP you can also view further information about CMS_RE_STR_OBJ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!