CMS_STR_REAL_ESTATE_CRM SAP (Real Estate - ATtributes) Structure details

Dictionary Type: Structure
Description: Real Estate - ATtributes




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




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

CMS_STR_REAL_ESTATE_CRM 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 "Real Estate - ATtributes" 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_STR_REAL_ESTATE_CRM TYPE CMS_STR_REAL_ESTATE_CRM.

The CMS_STR_REAL_ESTATE_CRM table consists of various fields, each holding specific information or linking keys about Real Estate - ATtributes data available in SAP. These include ID (Text field, length 35), SCHEME_ID (60 Characters Lower Case), SCHEME_AGENCY_ID (Character String 60), ID (Object 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: Cannot Be Enhanced


SAP CMS_STR_REAL_ESTATE_CRM 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
BTD_ID 0
IDText field, length 35 CHAR_35CHAR35CHAR_35
SCHEME_ID60 Characters Lower Case CMS_DTE_CHAR60LOW_CRMCHAR60CHAR60LOW
SCHEME_AGENCY_IDCharacter String 60 CHAR_60CHAR60CHAR_60
IDObject ID BAPICMS_RE_DTE_OBJECT_IDCHAR20ALPHACMS_RE_OBJECT_IDCMS_RE_OBJECT_IDCMS_RE_SRCH_ALL
TYPEReal Estate Object Type ID BAPICMS_RE_DTE_OBJ_TYPCHAR6TCMS_RE_TYPCMS_RE_TYPCMS_RE_OBJECT_TYPE
CATEGORYObject Category BAPICMS_DTE_OMS_OBJ_CATCHAR6TCMS_OMS_CATCMS_OBJ_CAT
UTILIZATIONUtilization of the part BAPICMS_RE_DTE_PRT_UTILIZATIONCHAR6CMS_RE_UTIL
DESCRIPTIONDescription of Building Part BAPICMS_RE_DTE_SPC_DESCCHAR30CMS_RE_DESC
MONETARY_VALUE 0
MARKET_VALUEFinal Asset Value BAPICMS_DTE_AST_VALUEDEC23(4) BAPICURR
MARKET_VALUE_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
NOMINAL_VALUENominal Value of the Asset BAPICMS_DTE_AST_NOMINAL_VALUEDEC23(4) BAPICURR
NOMINAL_VALUE_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
UNUSED_VALUE CMS_DTE_RE_UNUSED_AMOUNTDEC23(4) BAPICURR
UNUSED_VALUE_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RATES 0
LENDING_RATELending Rate 1 BAPICMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_AMOUNTS 0
LENDING_AMOUNTLending value Calculation for Asset BAPICMS_DTE_AST_LENDING_VALUEDEC23(4) BAPICURR
LENDING_AMOUNT_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_LIMIT_AMOUNTLending Limit 5 Calculation for Asset BAPICMS_DTE_AST_LENDING_LIMIT5DEC23(4) BAPICURR
LENDING_LIMIT_AMOUNT_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
LENDING_RANGE_AMOUNTLending Range 5 calculation for Asset BAPICMS_DTE_AST_LENDING_RANGE5DEC23(4) BAPICURR
LENDING_RANGE_AMOUNT_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
SAFETY_DISCOUNT 0
CODEIndicates that the asset has a default sfty discount or not BAPICMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
PERCENTAGESafety discount BAPICMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
AMOUNTSafety discount as an amount BAPICMS_DTE_SAFETY_AMTDEC23(4) BAPICURR
AMOUNT_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
ADDRESS 0
CITY_NAMECity AD_CITY1CHAR40TEXT40CLCITYNAME
STREET_POSTAL_CODECity postal code AD_PSTCD1CHAR10CHAR10
STREET_NAMEStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_IDHouse Number AD_HSNM1CHAR10TEXT10
COUNTRY_CODECountry ISO code INTCACHAR2INTCAF4_INTCA
REGION_CODESTATE (State, Province, County) REGIOCHAR3REGIO
LOCATION 0
MACRO_LOCATION_CODEMacro Location BAPICMS_DTE_RE_MACRO_LOCCHAR6CMS_ATT_ID_TYP
MICRO_LOCATION_CODEMicro Location BAPICMS_DTE_RE_MICRO_LOCCHAR6CMS_ATT_ID_TYP
TRANSPORT_CONNECTION_CODETransport Connection BAPICMS_DTE_RE_CONNECTIONCHAR6CMS_ATT_ID_TYP
ENVIRONMENTAL_CONDITIONS_CODEEnviromental Status BAPICMS_DTE_RE_ENV_STATUSCHAR6CMS_ATT_ID_TYP
FLOOD_ZONE_INDICATORIndicator for Flood Zone BAPICMS_RE_DTE_FLOOD_ZONECHAR1ALPHACMS_RE_FLG
EARTHQUAKE_ZONE_INDICATORIndicator for Eathquake Zone BAPICMS_RE_DTE_EARTHQUAKECHAR1ALPHACMS_RE_FLG
ARCHITECTL_CONS_AREA_INDICATORIndicator for Architectural Conservation area BAPICMS_RE_DTE_ARCT_CONVCHAR1ALPHACMS_RE_FLG
HISTORIC_SITE_INDICATORIndicator for Historical Site BAPICMS_RE_DTE_HIST_SITECHAR1ALPHACMS_RE_FLG
VALUE_IMPAIRING_FT_INDICATORIndicates existence of Factors Impairing Real Estate Value BAPICMS_RE_DTE_VAL_IMP_FLGCHAR1ALPHACMS_RE_FLG
VALUE_IMPAIRING_FT_DESCRIPTIONDescription of the value imparing factor BAPICMS_RE_DTE_VAL_IMP_DESCCHAR30CMS_RE_DESC
LAND 0
AREA 0
LAND_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
LAND_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
RENTED_LAND_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
RENTED_LAND_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
COSTS 0
LAND_COSTLand Cost amount BAPICMS_RE_DTE_LAND_COSTDEC23(4) BAPICURR
LAND_COST_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
LAND_COST_BASEBase measure - Land BAPICMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
DEVELOPMENT_COSTDev Cost amount BAPICMS_RE_DTE_DEV_COSTDEC23(4) BAPICURR
DEVELOPMENT_COST_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
DEVELOPMENT_COST_BASEBase measure - Land BAPICMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
ADDITIONAL_LAND_COSTAdditional Land Cost amount BAPICMS_RE_DTE_ADD_LAND_COSTDEC23(4) BAPICURR
ADDITIONAL_LAND_COST_CURRENCYISO Currency Code BAPIISOCDCHAR3ISOCD
ADDITIONAL_LAND_COST_BASEBase measure - Land BAPICMS_RE_DTE_BASE_MEAS_LANDCHAR1CMS_RE_BASE_MEAS_LAND
BUILDING 0
AREA 0
USABLE_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
USABLE_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
USABLE_VOLUMEDecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
USABLE_VOLUME_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
RESIDENTIAL_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
RESIDENTIAL_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
SECONDARY_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
SECONDARY_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
OTHER_AREADecimal CMS_DTE_DEC_13_3_CRMDEC13(3) DEC10_3
OTHER_AREA_UNITISO code for unit of measurement ISOCD_UNITCHAR3ISOCD_UNIT
UNITS 0
NUMBER_OF_BUILDING_PARTSNumber of building part units BAPICMS_RE_DTE_NO_PRT_UNITINT410CMS_RE_UNITS
OWNER 0

Key field Non-key field



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

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

How to access SAP table CMS_STR_REAL_ESTATE_CRM

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_REAL_ESTATE_CRM 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!