SAP CMS_RE_STR_BASIC_DETAILS Structure for basic details for Objects in RE Add-On Table data and field list

CMS_RE_STR_BASIC_DETAILS 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 "Structure for basic details for Objects in RE Add-On" 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_BASIC_DETAILS TYPE CMS_RE_STR_BASIC_DETAILS.

The CMS_RE_STR_BASIC_DETAILS table consists of various fields, each holding specific information or linking keys about Structure for basic details for Objects in RE Add-On data available in SAP. These include OBJECT_TYPE (Real Estate Object Type ID), ADDR_ID (Address ID), OBJECT_COND (Condition ID), OBJECT_DESC (Description of the Real Estate Object)... 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. .

CMS_RE_STR_BASIC_DETAILS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_RE_STR_BASIC_DETAILS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
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_GUIDRAW16Assigned to domainSYSUUIDCMS_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

Key field Non-key field



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

As CMS_RE_STR_BASIC_DETAILS 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_BASIC_DETAILS as there is no data to select.

How to access SAP table CMS_RE_STR_BASIC_DETAILS

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

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