Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

CMS_STR_BII_RE_DETAIL_SNG SAP (CMS-Basel: Complete Details for a Singe Real Estate Object) Structure details

Dictionary Type: Structure
Description: CMS-Basel: Complete Details for a Singe Real Estate Object

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

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

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

CMS_STR_BII_RE_DETAIL_SNG 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 "CMS-Basel: Complete Details for a Singe Real Estate 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_STR_BII_RE_DETAIL_SNG TYPE CMS_STR_BII_RE_DETAIL_SNG.

The CMS_STR_BII_RE_DETAIL_SNG table consists of various fields, each holding specific information or linking keys about CMS-Basel: Complete Details for a Singe Real Estate Object data available in SAP. These include RE_IDENTIFIER (GUID for Real estate - Primary key), REALESTATE_KEYS (), RE_IDENTIFIER (GUID for Real estate - Primary key), IDENTIFICATION (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: Can Be Enhanced (Deep)

SAP CMS_STR_BII_RE_DETAIL_SNG 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
REALESTATE_IDENTIFIER				0
RE_IDENTIFIER	GUID for Real estate - Primary key	BAPICMS_DTE_RE_GUID	CHAR	32			SYSUUID_C
REALESTATE_KEYS				0
RE_IDENTIFIER	GUID for Real estate - Primary key	BAPICMS_DTE_RE_GUID	CHAR	32			SYSUUID_C
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
TYPE_NAME	Name in a specified language	BAPICMS_RE_DTE_TYP_NAME	CHAR	40			CMS_RE_NAME
CATEGORY	Object Category	BAPICMS_DTE_OMS_OBJ_CAT	CHAR	6			CMS_OBJ_CAT
HEADER_DATA				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ADDRESS_ID	Address ID	BAPICMS_RE_DTE_ADDR_ID	CHAR	10		ALPHA	AD_ADDRNUM		ADMC
DESCRIPTION	Description of the Real Estate Object	BAPICMS_RE_DTE_OBJ_DESC	CHAR	30			CMS_RE_DESC
OBJECT_PARENT_ID	GUID for Real Estate Object	BAPICMS_RE_DTE_OBJ_GUID	RAW	16			SYSUUID
OLD_REFERENCE_ID	Reference number for an external system	BAPICMS_RE_DTE_OBJ_REF_NO	CHAR	32			CMS_RE_REFID
TYPE_OF_FIXTURE_AND_FITTINGS	Fixtures and Fittings type ID	BAPICMS_RE_DTE_FIX_FIT_TYP	CHAR	6		ALPHA	CMS_RE_FIX_FIT_TYP
TYPE_NAME	Name in a specified language	BAPICMS_RE_DTE_TYP_NAME	CHAR	40			CMS_RE_NAME
AREA_UNIT	Unit of measure for area	BAPICMS_RE_DTE_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
AREA_UNIT_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
VOLUME_UNIT	Unit of Measure for Volume of Real Estate	BAPICMS_RE_DTE_VOL_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_VOLUME_UOM
VOLUME_UNIT_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
OBJECT_CURRENCY	Object currency	BAPICMS_RE_DTE_OBJ_CURR	CUKY	5			WAERS
OBJECT_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
MACRO_LOCATION	Macro Location	BAPICMS_DTE_RE_MACRO_LOC	CHAR	6			CMS_ATT_ID_TYP
MICRO_LOCATION	Micro Location	BAPICMS_DTE_RE_MICRO_LOC	CHAR	6			CMS_ATT_ID_TYP
TRANSPORT_CONNECTION	Transport Connection	BAPICMS_DTE_RE_CONNECTION	CHAR	6			CMS_ATT_ID_TYP
ENVIRONMENTAL_STATUS	Enviromental Status	BAPICMS_DTE_RE_ENV_STATUS	CHAR	6			CMS_ATT_ID_TYP
IS_IN_FLOOD_ZONE	Indicator for Flood Zone	BAPICMS_RE_DTE_FLOOD_ZONE	CHAR	1		ALPHA	CMS_RE_FLG
IS_IN_EARTHQUAKE_ZONE	Indicator for Eathquake Zone	BAPICMS_RE_DTE_EARTHQUAKE	CHAR	1		ALPHA	CMS_RE_FLG
IS_IN_ARCHITECT_CONSERVTN_AREA	Indicator for Architectural Conservation area	BAPICMS_RE_DTE_ARCT_CONV	CHAR	1		ALPHA	CMS_RE_FLG
IS_A_HISTORIC_SITE	Indicator for Historical Site	BAPICMS_RE_DTE_HIST_SITE	CHAR	1		ALPHA	CMS_RE_FLG
IMPAIRING_FACTORS_EXIST	Indicates existence of Factors Impairing Real Estate Value	BAPICMS_RE_DTE_VAL_IMP_FLG	CHAR	1		ALPHA	CMS_RE_FLG
DESCRIPTN_OF_IMPAIRNG_FACTOR	Description of the value imparing factor	BAPICMS_RE_DTE_VAL_IMP_DESC	CHAR	30			CMS_RE_DESC
ADMINISTRATION_ORG_UNIT	Administration Organizational Unit	BAPICMS_DTE_ADMINORG	CHAR	12			TEXT12	CMS_ADMINORG
BANKAREA	Bank Area in Collateral Management	BAPICMS_DTE_BANKAREA	CHAR	4			CMS_BANKAREA	CMS_BANKAREA
CREATED_BY	Real Estate Add-On User	BAPICMS_RE_DTE_CR_BY	CHAR	12			CMS_RE_USER
CREATED_ON	Created On	BAPICMS_RE_DTE_CR_ON	DATS	8			CMS_RE_DATE
CREATED_AT	Created At	BAPICMS_RE_DTE_CR_AT	TIMS	6			CMS_RE_TIME
SOURCE_OF_ENTRY	Source of Initial entry	BAPICMS_RE_DTE_SRC_INIT	CHAR	32			CMS_RE_SOURCE
CHANGED_BY	Last Changed By	BAPICMS_RE_DTE_CHG_BY	CHAR	12			CMS_RE_USER
CHANGED_ON	Last Changed On	BAPICMS_RE_DTE_CHG_ON	DATS	8			CMS_RE_DATE
CHANGED_AT	Last Changed At	BAPICMS_RE_DTE_CHG_AT	TIMS	6			CMS_RE_TIME
PROCESSING_SOURCE	Processing Source	BAPICMS_RE_DTE_PRC_SRC	CHAR	32			CMS_RE_SOURCE
ADDRESS				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ADDRESSID	Location / Address	BAPICMS_DTE_MOV_LOCATION	CHAR	10		ALPHA	AD_ADDRNUM		ADMC
ADDR_NO	Address number	AD_ADDRNUM	CHAR	10		ALPHA	AD_ADDRNUM	ADR
ADDRHANDLE	Handle for Creating Addresses/Persons (Bus. Addr. Services)	AD_HANDLE	CHAR	140			TEXT140
NATION	Version ID for International Addresses	AD_NATION	CHAR	1			AD_NATION	ADDRESS_NATION
DATE	Date referred to	AD_DATE	DATS	8			DATUM
DATE_FROM	Valid-from date - in current Release only 00010101 possible	AD_DATE_FR	DATS	8			DATUM
DATE_TO	Valid-to date in current Release only 99991231 possible	AD_DATE_TO	DATS	8			DATUM
TITLE	Form-of-Address Key	AD_TITLE	CHAR	4			AD_TITLE
NAME_1	Name 1	AD_NAME1	CHAR	40			TEXT40
NAME_2	Name 2	AD_NAME2	CHAR	40			TEXT40
NAME_3	Name 3	AD_NAME3	CHAR	40			TEXT40
NAME_4	Name 4	AD_NAME4	CHAR	40			TEXT40
NAME_TXT	Converted name field (with form of address)	AD_NAMETXT	CHAR	50			TEXT50
C_O_NAME	c/o name	AD_NAME_CO	CHAR	40			TEXT40
CITY	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
DISTRICT	District	AD_CITY2	CHAR	40			TEXT40		CITY_PART
CITY_NO	City code for city/street file	AD_CITYNUM	CHAR	12		ALPHA	CITY_CODE
DISTRCT_NO	District code for City and Street file	AD_CITYPNM	CHAR	8		ALPHA	CITYP_CODE
HOME_CITY	City (different from postal city)	AD_CITY3	CHAR	40			TEXT40
HOMECITYNO	Different city for city/street file	AD_CITYHNM	CHAR	12		ALPHA	CITY_CODE
CHCKSTATUS	City file test status	AD_CHECKST	CHAR	1			AD_CHECKST
REGIOGROUP	Regional structure grouping	REGIOGROUP	CHAR	8			REGIOGROUP
POST_CODE1	City postal code	AD_PSTCD1	CHAR	10			CHAR10
POST_CODE2	PO Box Postal Code	AD_PSTCD2	CHAR	10			CHAR10
POST_CODE3	Company Postal Code (for Large Customers)	AD_PSTCD3	CHAR	10			CHAR10
PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	AD_PST1XT	CHAR	10			CHAR10
PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	AD_PST2XT	CHAR	10			CHAR10
PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	AD_PST3XT	CHAR	10			CHAR10
PO_BOX	PO Box	AD_POBX	CHAR	10			CHAR10
DONT_USE_P	PO Box Address Undeliverable Flag	AD_NO_USEP	CHAR	4			AD_NO_USE
PO_W_O_NO	Flag: PO Box Without Number	AD_POBXNUM	CHAR	1			XFELD
PO_BOX_CIT	PO Box city	AD_POBXLOC	CHAR	40			TEXT40		CITY_NAME
PBOXCIT_NO	City PO box code (City file)	AD_CIT2NUM	CHAR	12		ALPHA	CITY_CODE
PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	AD_POBXREG	CHAR	3			REGIO
POBOX_CTRY	PO box country	AD_POBXCTY	CHAR	3			LAND1
PO_CTRYISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
DELIV_DIS	(Not Supported) Post Delivery District	AD_PSTLAR	CHAR	15			TEXT15
TRANSPZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10			ZONE
STREET_LNG	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
DONT_USE_S	Street Address Undeliverable Flag	AD_NO_USES	CHAR	4			AD_NO_USE
STREET_NO	Street Number for City/Street File	AD_STRNUM	CHAR	12		ALPHA	STRT_CODE
STR_ABBR	(Not Supported) Abbreviation of Street Name	AD_STRABBR	CHAR	2			STRTYPEAB
HOUSE_NO	House Number	AD_HSNM1	CHAR	10			TEXT10
HOUSE_NO2	House number supplement	AD_HSNM2	CHAR	10			TEXT10
HOUSE_NO3	(Not supported) House Number Range	AD_HSNM3	CHAR	10			TEXT10
STR_SUPPL1	Street 2	AD_STRSPP1	CHAR	40			TEXT40
STR_SUPPL2	Street 3	AD_STRSPP2	CHAR	40			TEXT40
STR_SUPPL3	Street 4	AD_STRSPP3	CHAR	40			TEXT40
LOCATION	Street 5	AD_LCTN	CHAR	40			TEXT40
BUILD_LONG	Building (Number or Code)	AD_BLDNG	CHAR	20			TEXT20
FLOOR	Floor in building	AD_FLOOR	CHAR	10			TEXT10
ROOM_NO	Room or Appartment Number	AD_ROOMNUM	CHAR	10			TEXT10
COUNTRY	Country Key	LAND1	CHAR	3			LAND1	LND
COUNTRYISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
LANGU	Language Key	SPRAS	LANG	1		ISOLA	SPRAS	SPR	H_T002
LANGU_ISO	2-Character SAP Language Code	LAISO	CHAR	2			LAISO
REGION	STATE (State, Province, County)	REGIO	CHAR	3			REGIO
SORT1	Search Term 1	AD_SORT1	CHAR	20			CHAR20
SORT2	Search Term 2	AD_SORT2	CHAR	20			CHAR20
SORT_PHN	(Not Supported) Phonetic Search Sort Field	AD_SRTPHN	CHAR	20			CHAR20
ADDRORIGIN	(Not Supported) Address Data Source (Key)	AD_ORIGINA	CHAR	4			AD_ORIGIN
EXTENSION1	Extension (only for data conversion) (e.g. data line)	AD_EXTENS1	CHAR	40			TEXT40
EXTENSION2	Extension (only for data conversion) (e.g. telebox)	AD_EXTENS2	CHAR	40			TEXT40
TIME_ZONE	Address time zone	AD_TZONE	CHAR	6			TZNZONE
TAXJURCODE	Tax Jurisdiction	AD_TXJCD	CHAR	15			AD_TXJCD	TXJ
ADR_NOTES	Address notes	AD_REMARK1	CHAR	50			TEXT50
LANGU_CR	Address record creation original language	AD_LANGUCR	LANG	1		ISOLA	SPRAS
LANGUCRISO	2-Character SAP Language Code	LAISO	CHAR	2			LAISO
COMM_TYPE	Communication Method (Key) (Business Address Services)	AD_COMM	CHAR	3			AD_COMM
TEL1_NUMBR	First telephone no.: dialling code+number	AD_TLNMBR1	CHAR	30			CHAR30
TEL1_EXT	First Telephone No.: Extension	AD_TLXTNS1	CHAR	10			CHAR10
FAX_NUMBER	First fax no.: dialling code+number	AD_FXNMBR1	CHAR	30			CHAR30
FAX_EXTENS	First fax no.: extension	AD_FXXTNS1	CHAR	10			CHAR10
ADDR_GROUP	Address Group (Key) (Business Address Services)	AD_GROUP	CHAR	4			AD_GROUP
MAINOBJECT_DATA				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
CONDITION	Object condition	BAPICMS_DTE_RE_PART_COND	CHAR	6			CMS_ATT_ID_TYP
MAIN_USAGE	Usage Type	BAPICMS_RE_DTE_USG_TYP	CHAR	6			CMS_RE_TYP
ADDITIONAL_USAGE_1	Additional usage 1	BAPICMS_RE_DTE_ADD1_USG_TYP	CHAR	6			CMS_RE_TYP
ADDITIONAL_USAGE_2	Additional usage 2	BAPICMS_RE_DTE_ADD2_USG_TYP	CHAR	6			CMS_RE_TYP
BUILDING_METHOD_ROOF	Building method - Roof	BAPICMS_DTE_RE_BUILDMETH_BODY	CHAR	6			CMS_ATT_ID_TYP
BUILDING_METHOD_BODY	Building method - Body	BAPICMS_DTE_RE_BUILDMETH_ROOF	CHAR	6			CMS_ATT_ID_TYP
BUILDING_METHOD_CELLAR	Building method - Cellar	BAPICMS_DTE_RE_BUILDMTH_CELLAR	CHAR	6			CMS_ATT_ID_TYP
UTILIZATION	Utilization of the part	BAPICMS_RE_DTE_PRT_UTILIZATION	CHAR	6			CMS_RE_UTIL
DESCRIPTION	Description of Building Part	BAPICMS_RE_DTE_SPC_DESC	CHAR	30			CMS_RE_DESC
PERCENTAGE_COMMON_USAGE	Commercial usage (percentage)	BAPICMS_RE_DTE_COM_USE_PCT	DEC	10(6)			CMS_RE_PCT
IS_USED_OTHERWISE	Suitable For Other Usage	BAPICMS_RE_DTE_OTH_USE_FLG	CHAR	1		ALPHA	CMS_RE_OTH_USG_FLG
REF_OBJ_PART	Reference Object Part GUID	BAPICMS_RE_DTE_REF_OBJ_PRTGUID	CHAR	32			SYSUUID_C
IS_SUB_ASSET_CREATE	Indicates whether an subasset created for this building part	BAPICMS_RE_DTE_SUB_AST_FLG	CHAR	1		ALPHA	CMS_RE_FLG
USABLE_AREA	Usable area	BAPICMS_RE_DTE_AREA_USEFUL	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_USABLE_AREA	Unit of Measure for Usable Area	BAPICMS_RE_DTE_USBL_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_MEASURE_USABLE_AREA_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
USABLE_AREA_RENTED	Usable area - rented	BAPICMS_RE_DTE_AREA_USEFUL_REN	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASUR_USBL_AREA_RENTD	Unit of Measure for Usable Rented Area	BAPICMS_RE_DTE_USBL_ARA_RN_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_MEASUR_USBL_AREA_RNTD_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
USABLE_VOLUME	Usable Volume of Real Estate Building Parts	BAPICMS_RE_DTE_VOL_USEFUL	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_USABLE_VOLUME	Unit of Measure for Usable Volume of Real Estate	BAPICMS_RE_DTE_USBL_VOL_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_VOLUME_UOM
UNIT_MEASURE_USABLE_VOLUME_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
USABLE_VOLUME_RENTED	Usable Volume of the Rented Portions of Real Estate	BAPICMS_RE_DTE_VOL_USEFUL_REN	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_USBL_VOL_RENTD	Unit of measure for usable volume of Rented Parts	BAPICMS_RE_DTE_USBL_VOL_RN_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_VOLUME_UOM
UNIT_MEASURE_USB_VOL_RENTD_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
RESIDENTIAL_AREA	Residential Area	BAPICMS_DTE_RE_AREA_RESIDENTAL	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_RESIDNTL_AREA	Unit of measure for residential area	BAPICMS_RE_DTE_RES_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_MEASURE_RESIDNTL_AREA_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
SECONDARY_AREA	Secondary Area	BAPICMS_RE_DTE_AREA_SECONDARY	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_SECONDARY_AREA	Unit of Measure for Secondary Area	BAPICMS_RE_DTE_SEC_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_MEASURE_SECNDARY_AREA_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
OTHER_AREA	Other Area	BAPICMS_RE_DTE_AREA_OTHER	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_OTHER_AREA	Unit of measure for Other area	BAPICMS_RE_DTE_OTH_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_OF_MEASURE_OTHER_AREA_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
NUMBER_OF_PART_UNITS	Number of building part units	BAPICMS_RE_DTE_NO_PRT_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_UNITS_RENTED	Number of building part units rented	BAPICMS_RE_DTE_NO_PRT_UNIT_REN	INT4	10			CMS_RE_UNITS
COSNTRUCTION_BEGIN	Construction start date	BAPICMS_RE_DTE_OBJ_CONS_ST_DAT	DATS	8			CMS_RE_DATE
DATE_PERMISSION_APPLIED	Building Permssion applied date	BAPICMS_RE_DTE_OBJ_PMSN_APL_DT	DATS	8			CMS_RE_DATE
DATE_PERMISSION_OBTAINED	Building Permssion obtained date	BAPICMS_RE_DTE_OBJ_PMSN_OBT_DT	DATS	8			CMS_RE_DATE
OCCUPANCY_DATE	Occupancy Date	BAPICMS_RE_DTE_OBJ_OCCY_DATE	DATS	8			CMS_RE_DATE
COMPLETION_DATE	Completion Date	BAPICMS_RE_DTE_OBJ_COMP_DATE	DATS	8			CMS_RE_DATE
DATE_OF_FINAL_INSPECTION	Final Inspection Date	BAPICMS_RE_DTE_OBJ_FINL_INS_DT	DATS	8			CMS_RE_DATE
PLANNED_RENT_AMOUNT	Planned rent amount	BAPICMS_RE_DTE_RENT_AMOUNT	DEC	23(4)			BAPICURR
ACTUAL_RENT_AMOUNT	Actual rent amount	BAPICMS_RE_DTE_RENT_AMOUNT_ACT	DEC	23(4)			BAPICURR
CURRENCY_PLANNED_RENT_AMT	Planned Rent Currency	BAPICMS_RE_DTE_RENT_PLAND_CURR	CUKY	5			WAERS
CURRENCY_PLANNED_RENT_AMT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CURRENCY_ACTUAL_RENT_AMT	Actual Rent Currency	BAPICMS_RE_DTE_RENT_ACTUAL_CUR	CUKY	5			WAERS
CURRENCY_ACTUAL_RENT_AMT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_PERIOD_FOR_RENT	Base period for the rent	BAPICMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEASURE	Base measure	BAPICMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
RATIO_NOT_RENTED_TO_TOTAL_AMT	Ratio of Real Estate not rented to Total Real Estate Value	BAPICMS_RE_DTE_VACANT_POS_PCT	DEC	10(6)			CMS_RE_PCT
NET_OR_GROSS_RENT	Indicator for Net/Gross Rent	BAPICMS_RE_DTE_RES_IND	CHAR	1			CMS_RE_RENT_FLG
COMPARATIVE_RENT_AMT	Comparative Rent (Residential)	BAPICMS_RE_DTE_RENT_LEVEL	DEC	23(4)			BAPICURR
CURRENCY_COMPARATIVE_RENT	Comparative Rent Currency - Residential	BAPICMS_RE_DTE_COM_RNT_RES_CUR	CUKY	5			WAERS
CURRENCY_COMPARATIVE_RENT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LAND_AREA	Land area of the real estate	BAPICMS_RE_DTE_LAND_AREA	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_LAND_AREA	Land area unit of measure	BAPICMS_RE_DTE_LAND_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
UNIT_MEASURE_LAND_AREA_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
RENTED_AREA_LAND	Land area(rented) of the real estate	BAPICMS_RE_DTE_LAND_AREA_REN	QUAN	13(3)			CMS_RE_SIZE
UNIT_OF_MEASURE_RENTED_LAND	Land area unit of measure(rented)	BAPICMS_RE_DTE_LAND_ARA_RN_UOM	UNIT	3		CUNIT	MEINS
UNIT_MEASURE_RENTED_LAND_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
NUMBER_OF_UNITS	No of units in real estate object	BAPICMS_RE_DTE_NO_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_FLOORS	Number of Floors	BAPICMS_RE_DTE_NO_FLOOR	INT4	10			CMS_RE_UNITS
NUMBER_OF_GARAGES	No of garages in real estate object	BAPICMS_RE_DTE_NO_GAR	INT4	10			CMS_RE_UNITS
NUMBER_OF_RENTED_GARAGES	No of garages rented in real estate object	BAPICMS_RE_DTE_NO_GAR_REN	INT4	10			CMS_RE_UNITS
NUMBER_OF_PARKING_UNITS	Number of parking units	BAPICMS_RE_DTE_NO_PARK_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_RENTED_PARK_UNITS	Number of parking units rented	BAPICMS_RE_DTE_NO_PARK_UNT_REN	INT4	10			CMS_RE_UNITS
NUMBER_OF_UNDERGR_PARKNG_UNITS	Number of underground parking units	BAPICMS_RE_DTE_NO_PARK_UNIT_UG	INT4	10			CMS_RE_UNITS
NUMBER_OF_RENTED_UNDERGR_UNITS	Number of underground parking units	BAPICMS_RE_DTE_NO_PARK_UNIT_UG	INT4	10			CMS_RE_UNITS
NUMBER_OF_CURRENT_UNITS	No of current units in real estate object	BAPICMS_RE_DTE_NO_CUR_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_CURRENT_UNITS_RENTED	No of current units rented in real estate object	BAPICMS_RE_DTE_NO_CUR_UNIT_REN	INT4	10			CMS_RE_UNITS
NUMBER_OF_OLD_UNITS	No of old units in real estate object	BAPICMS_RE_DTE_NO_OLD_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_OLD_UNITS_RENTED	No of old units rented in real estate object	BAPICMS_RE_DTE_NO_OLD_UNIT_REN	INT4	10			CMS_RE_UNITS
NUMBER_OF_NEW_UNITS	No of new units in real estate object	BAPICMS_RE_DTE_NO_NEW_UNIT	INT4	10			CMS_RE_UNITS
NUMBER_OF_NEW_UNITS_RENTED	No of new units rented in real estate object	BAPICMS_RE_DTE_NO_NEW_UNIT_REN	INT4	10			CMS_RE_UNITS
NUMBER_OF_ACCESS_STRUCTURES	No of access structures	BAPICMS_RE_DTE_NO_ACCESS_STR	INT4	10			CMS_RE_UNITS
NUMBER_OF_SALE_LEVELS	No of Sale levels in commercial building	BAPICMS_RE_DTE_NO_SALE_LEVEL	INT4	10			CMS_RE_UNITS
NUMBER_OF_ROOMS	No of rooms in the hotel/clinic	BAPICMS_RE_DTE_NO_ROOMS	INT4	10			CMS_RE_UNITS
NUMBER_OF_BEDS	No of rooms in the clinic/nursing home	BAPICMS_RE_DTE_NO_BEDS	INT4	10			CMS_RE_UNITS
PERCENTAGE_OCCUPIED	Occupancy in percentage	BAPICMS_RE_DTE_OCCY_PCT	DEC	10(6)			CMS_RE_PCT
TOTAL_TURN_OVER_AMOUNT	Total Amount of Turnover	BAPICMS_RE_DTE_TURNOVER_AMOUNT	DEC	23(4)			BAPICURR
CURRENCY_TOTAL_TURN_OVER	Currency	BAPICMS_RE_DTE_TURNOVER_CURR	CUKY	5			WAERS
CURRENCY_TOTAL_TURN_OVER_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
RENTAL_AGREEMENT_TYPE	Rental Agreement Type	BAPICMS_RE_DTE_RENTAL_AGRMNT	CHAR	6			CMS_ATT_ID_TYP
COMMERCIAL_ENVIRONMENT	Description of the commercial environment	BAPICMS_RE_DTE_COMM_ENV_DESC	CHAR	30			CMS_RE_DESC
DESCRIPTION_ACCESS_STRUCTURES	Description of the access structures	BAPICMS_RE_DTE_ACCESS_STR_DESC	CHAR	30			CMS_RE_DESC
BUILDING_SECTION	Building Section	BAPICMS_RE_DTE_SECTION	CHAR	6			CMS_ATT_ID_TYP
PRICE_CATEGORY	Price Category	BAPICMS_RE_DTE_ATT_ID_TY_REO13	CHAR	6			CMS_ATT_ID_TYP
AVERAGE_PRICE	Average price/day	BAPICMS_RE_DTE_AVG_PRICE	DEC	23(4)			BAPICURR
CURRENCY_AVERAGE_PRICE	Average Price Currency	BAPICMS_RE_DTE_AVG_PRICE_CURR	CUKY	5			WAERS
CURRENCY_AVERAGE_PRICE_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LAST_REPORT_DATE	Last Constuction Report Date	BAPICMS_RE_DTE_LAST_CON_REP_DT	DATS	8			CMS_RE_DATE
BUILDLING_PROGRESS_AMOUNT	Amount Building Progress	BAPICMS_RE_DTE_AMT_BLD_PROGRES	DEC	23(4)			BAPICURR
CURRENCY_BUILDING_PROGRESS	Building Progress Amount Curreny	BAPICMS_RE_DTE_BLD_PROGRES_CUR	CUKY	5			WAERS
CURRENCY_BUILDING_PROGRESS_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
PERCENTAGE_COMPLETE	Degree of Completion	BAPICMS_RE_DTE_DEGREE_COMPLETE	DEC	10(6)			CMS_RE_PCT
INSURANCE_TYPE	Insurance Type	BAPICMS_RE_DTE_INSURANCE_TYPE	CHAR	6			CMS_ATT_ID_TYP
INSURANCE_SUM	Insurance amount	BAPICMS_RE_DTE_INSURANCE_AMNT	DEC	23(4)			BAPICURR
INSURANCE_SUM_CURRENCY	Insurance Currency	BAPICMS_RE_DTE_INSURANCE_CURR	CUKY	5			WAERS
INSURANCE_SUM_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
INSURANCE_EXPIRY	Date until which the Insurance stands valid	BAPICMS_RE_DTE_INS_VALID_TILL	DATS	8			CMS_RE_DATE
RATIONING_COST_AMOUNT	Rationing Cost - Residential	BAPICMS_RE_DTE_RAT_COST_AMT	DEC	23(4)			BAPICURR
RATIONING_COST_PERCENTAGE	Rationing Cost (percentage) - Residential	BAPICMS_RE_DTE_RAN_COST_PCT	DEC	10(6)			CMS_RE_PCT
EXTERNAL_LAYOUT_COST	External Layout Cost	BAPICMS_RE_DTE_EXT_LAYOUT_COST	DEC	23(4)			BAPICURR
EXTERNAL_LAYOUT_COST_PCT_AMT	External Layout Cost (percentage)	BAPICMS_RE_DTE_EXT_LOUT_CS_PCT	DEC	10(6)			CMS_RE_PCT
CURRENCY_RATION_COST	Rationing cost currency	BAPICMS_RE_DTE_RTN_CST_CURR	CUKY	5			WAERS
CURRENCY_RATION_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CURRENCY_EXT_LAYOUT_COST	External Layout cost currency	BAPICMS_RE_DTE_EXT_LOUT_CS_CUR	CUKY	5			WAERS
CURRENCY_EXT_LAYOUT_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
RATION_COST_COMMERCIAL	Rationing Cost - Commercial	BAPICMS_RE_DTE_RAT_CST_AMT_COM	DEC	23(4)			BAPICURR
CURRENCY_RATION_COST_COM	Rationing cost currency	BAPICMS_RE_DTE_RTN_CST_CUR_COM	CUKY	5			WAERS
CURRENCY_RATION_COST_COM_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
RATION_COST_PERCNTG_COMMERCIAL	Rationing Cost (percentage) - Commercial	BAPICMS_RE_DTE_RAN_CST_PCT_COM	DEC	10(6)			CMS_RE_PCT
GROSS_COLD_RENT	Gross Cold Rent	BAPICMS_RE_DTE_YRLY_GRS_CLD_RN	DEC	23(4)			BAPICURR
CURRENCY_GROSS_RENT	Gross Cold Rent Currency	BAPICMS_RE_DTE_GROSS_RENT_CURR	CUKY	5			WAERS
CURRENCY_GROSS_RENT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
NET_COLD_RENT	Net Cold Rent	BAPICMS_RE_DTE_YRLY_NET_CLD_RN	DEC	23(4)			BAPICURR
CURRENCY_NET_RENT	Net Cold Rent Currency	BAPICMS_RE_DTE_NET_RENT_CURR	CUKY	5			WAERS
CURRENCY_NET_RENT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
YEARS_SINCE_RECENT_VALTN_COM	No of years since Last Valuation of Commercial Real Estate	BAPICMS_RE_DTE_VAL_NO_YEAR_COM	INT1	3			CMS_RE_INT1
INTEREST_RATE_COMMERCIAL	Interest rate (Com)	BAPICMS_RE_DTE_VAL_INT_RAT_COM	DEC	10(6)			CMS_RE_PCT
YEARS_SINCE_RECENT_VALUATION	No. of Years since Real Estate was last Valued	BAPICMS_RE_DTE_VALUATON_NO_YRS	INT1	3			CMS_RE_INT1
INTEREST_RATE	Interest rate used in Valuation of Residential Real Estate	BAPICMS_RE_DTE_VALUATN_INT_RAT	DEC	10(6)			CMS_RE_PCT
PLANNED_RENT_AMOUNT_COMMERCIAL	Planned rent amount	BAPICMS_RE_DTE_RENT_AMOUNT	DEC	23(4)			BAPICURR
ACTUAL_RENT_COMMERCIAL	Actual rent amount	BAPICMS_RE_DTE_RENT_AMOUNT_ACT	DEC	23(4)			BAPICURR
CURRENCY_PLANNED_COMMERCIAL	Planned Rent Currency	BAPICMS_RE_DTE_RENT_PLAND_CURR	CUKY	5			WAERS
CURRENCY_PLANED_COMMERCIAL_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CURRENCY_ACTUAL_COMMERCIAL	Actual Rent Currency	BAPICMS_RE_DTE_RENT_ACTUAL_CUR	CUKY	5			WAERS
CURRENCY_ACTUAL_COMMERCIAL_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_PERIOD_RENT_COMMERCIAL	Base period for the rent	BAPICMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEASURE_COMMERCIAL	Base measure	BAPICMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
NET_OR_GROSS_COMMERCIAL_RENT	Indicator for Net/Gross Rent	BAPICMS_RE_DTE_COM_IND	CHAR	1			CMS_RE_RENT_FLG
COMPARATIVE_COMMERCIAL_RENT	Comparative Rent (Commercial)	BAPICMS_RE_DTE_RENT_LEVEL_COM	DEC	23(4)			BAPICURR
CURRENCY_COMPARATIVE_RENT_COM	Comparative Rent Currency (Commercial)	BAPICMS_RE_DTE_COMP_RNT_CM_CUR	CUKY	5			WAERS
CURRENCY_COMPRTVE_RENT_COM_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
PLANNED_RENT_LAND	Planned rent amount	BAPICMS_RE_DTE_RENT_AMOUNT	DEC	23(4)			BAPICURR
ACTUAL_RENT_LAND	Actual rent amount	BAPICMS_RE_DTE_RENT_AMOUNT_ACT	DEC	23(4)			BAPICURR
CURRENCY_PLAN_RENT_LAND	Planned Rent Currency	BAPICMS_RE_DTE_RENT_PLAND_CURR	CUKY	5			WAERS
CURRENCY_PLAN_RENT_LAND_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CURRENCY_ACTUAL_RENT_LND	Actual Rent Currency	BAPICMS_RE_DTE_RENT_ACTUAL_CUR	CUKY	5			WAERS
CURRENCY_ACTUAL_RENT_LND_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_PERIOD_RENT_LAND	Base period for the rent	BAPICMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEASURE_LAND	Base measure	BAPICMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
DEPRECIATION_PERCENTAGE	Depriciation	BAPICMS_RE_DTE_DEPR	DEC	10(6)			CMS_RE_PCT
LAND_COST	Land Cost amount	BAPICMS_RE_DTE_LAND_COST	DEC	23(4)			BAPICURR
CURRENCY_LAND_COST	Land Cost Currency	BAPICMS_RE_DTE_LAND_COST_CURR	CUKY	5			WAERS
CURRENCY_LAND_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
DEVELOPMENT_COST	Dev Cost amount	BAPICMS_RE_DTE_DEV_COST	DEC	23(4)			BAPICURR
CURRENCY_DEVELOPMENT_COST	Dev Cost Currency	BAPICMS_RE_DTE_DEV_COST_CURR	CUKY	5			WAERS
CURRENCY_DEVLOPMENT_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_FOR_LAND_COST	Base measure - Land	BAPICMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
BASE_FOR_DEVELOPMENT_COST	Base measure - Land	BAPICMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
ADDITIONAL_LAND_COST	Additional Land Cost amount	BAPICMS_RE_DTE_ADD_LAND_COST	DEC	23(4)			BAPICURR
CURRENCY_ADD_LAND_COST	Additional Land Cost Currency	BAPICMS_RE_DTE_ADD_LND_CST_CUR	CUKY	5			WAERS
CURRENCY_ADD_LAND_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_FOR_ADDITIONAL_COST	Base measure - Land	BAPICMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
CONSTRUCTION_COST	Construction cost	BAPICMS_RE_DTE_CONS_COST	DEC	23(4)			BAPICURR
CURRENCY_CONSTRUCTION_COST	Construction cost currency	BAPICMS_RE_DTE_CONS_COST_CURR	CUKY	5			WAERS
CURRENCY_CONSTRUCTION_COST_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BASE_MEASURE_CONSTUCTION_COST	Base measure	BAPICMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
YEARLY_GROSS_PROFIT	Yearly Gross Profit	BAPICMS_RE_DTE_GRS_PROFIT	DEC	23(4)			BAPICURR
CURRENCY_GROSS_PROFIT	Yearly Gross Profit Currency	BAPICMS_RE_DTE_GRS_PROFIT_CURR	CUKY	5			WAERS
CURRENCY_GROSS_PROFIT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
ASSET_GUID	GUID for Table CMS_AST	BAPICMS_DTE_AST_GUID	CHAR	32			SYSUUID_C
ASSET_TYPE	Object Type in the External (Add-On) System	BAPICMS_DTE_OBJ_TYP	CHAR	32			CMS_OBJ_TYP
RISK_CODE	Risk Code	BAPICMS_DTE_RISK_CODE	CHAR	6			CMS_RISK_CODE
SAFETY_INDICATOR	Indicates that the asset has a default sfty discount or not	BAPICMS_DTE_IND_SFTY_DISC	CHAR	2			CMS_IND_SFTY
SAFETY_DISCOUNT	Safety discount	BAPICMS_DTE_SAFETY_DSCNT	DEC	10(6)			CMS_SFTY_PCT
SAFETY_AMOUNT	Safety discount as an amount	BAPICMS_DTE_SAFETY_AMT	DEC	23(4)			BAPICURR
SAFETY_AMOUNT_CURRENCY	Currency of the Safety discount amount	BAPICMS_DTE_SAFETY_AMT_CURR	CUKY	5			WAERS
SAFETY_AMOUNT_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
VALUATION_TYPE	Type of Check conducted on the object	BAPICMS_DTE_IND_VALN_TYP	CHAR	2			CMS_VALN_TYP
UNIT_VALUATION_FREQUENCY	Indicator: Units of time for revaluation of an asset	BAPICMS_DTE_IND_AST_VLN_FQ_UNT	CHAR	2			CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALUATION_FREQUENCY	Period of revaluation for an asset	BAPICMS_DTE_AST_VLN_FQ_PRD	NUMC	4			CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATE	Date on which the asset was last valued	BAPICMS_DTE_VALN_DATE	DATS	8			CMS_DATE
START_DATE	Valuation Start date	BAPICMS_DTE_START_DATE	DATS	8			CMS_DATE
END_DATE	Valuation End date	BAPICMS_DTE_END_DATE	DATS	8			CMS_DATE
DEFAULT_LENDING_RATE_INDICATOR	Indicates that the asset has a default lending rate or not	BAPICMS_DTE_IND_LND_RTE	CHAR	2			CMS_IND_LRTE
LENDING_RATE1	Lending Rate 1	BAPICMS_DTE_LRTE_PCT1	DEC	10(6)			CMS_PCT
LENDING_RATE2	Lending Rate 2	BAPICMS_DTE_LRTE_PCT2	DEC	10(6)			CMS_PCT
LENDING_RATE3	Lending Rate 3	BAPICMS_DTE_LRTE_PCT3	DEC	10(6)			CMS_PCT
LENDING_RATE4	Lending Rate 4	BAPICMS_DTE_LRTE_PCT4	DEC	10(6)			CMS_PCT
LENDING_RATE5	Lending Rate 5	BAPICMS_DTE_LRTE_PCT5	DEC	10(6)			CMS_PCT
LIQUIDATION_TYPE	Liquidation Type	BAPICMS_DTE_LIQD_TYP	CHAR	6			CMS_TYP		CMS_AST_LIQTYP
LIQUIDATION_REASON	Liquidation Reason	BAPICMS_DTE_ATT_ID_TY_AST004	CHAR	6			CMS_ATT_ID_TYP
LIQUIDATION_DATE	Collateral Liquidation Date	BAPICMS_DTE_LIQD_DATE	DATS	8			CMS_DATE
LIQUIDATION_AMOUNT	Returns from the Liquidation of Collateral	BAPICMS_DTE_LIQD_VALUE	DEC	23(4)			BAPICURR
LIQUIDATION_CURRENCY	Currency of Liquidation Value	BAPICMS_DTE_LIQD_CURR	CUKY	5			WAERS
LIQUIDATION_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
BANK_ACCT	Bank account number	BAPICMS_DTE_BANK_ACCT	CHAR	18			BANKN
BANK_CTRY	Bank country key	BAPICMS_DTE_BANK_CTRY	CHAR	3			LAND1	BKL
BANK_CTRY_ISO	Country ISO code	INTCA	CHAR	2			INTCA		F4_INTCA
BANK_KEY	Bank Keys	BAPICMS_DTE_BANK_KEY	CHAR	15			BANKK	BNK
BANK_CONTROL_KEY	Bank Control Key	BAPICMS_DTE_BANK_CNTRL_KEY	CHAR	2			BKONT
VERIFICATION_UNIT_FREQUENCY	Indicator: Units of time for verification of an asset	BAPICMS_DTE_IND_AST_VER_FQ_UNT	CHAR	2			CMS_IND_AST_VERF_FREQ_UNIT
VERIFICATION_PERIOD_FREQUENCY	Period of verification for an asset	BAPICMS_DTE_AST_VER_FQ_PRD	NUMC	4			CMS_AST_VERF_FREQ_PERIOD
VERIFICATION_DATE	Last Verification Date	BAPICMS_DTE_AST_VERF_DATE	DATS	8			CMS_DATE
NOMINAL_VALUE	Nominal Value of the Asset	BAPICMS_DTE_AST_NOMINAL_VALUE	DEC	23(4)			BAPICURR
NOMINAL_VALUE_CURRENCY	Currency of Nominal value	BAPICMS_DTE_AST_NOMINL_VAL_CUR	CUKY	5			WAERS
NOMINAL_VALUE_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
ASSET_VALUE	Final Asset Value	BAPICMS_DTE_AST_VALUE	DEC	23(4)			BAPICURR
ASSET_VALUE_CURRENCY	Currency of the final Asset Value	BAPICMS_DTE_AST_VALUE_CURR	CUKY	5			WAERS
ASSET_VALUE_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
QUANTITY	Quantity	BAPICMS_DTE_QTY	QUAN	13(3)			CMS_QTY
UNIT_OF_MEASURE_FOR_QUANTITY	Unit of Measure of Quantity	BAPICMS_DTE_UNIT	UNIT	3		CUNIT	MEINS
UNIT_OF_MEASURE_QUANTITY_ISO	ISO code for unit of measurement	ISOCD_UNIT	CHAR	3			ISOCD_UNIT
PURCHASE_PRICE	Purchase price of the Asset	BAPICMS_DTE_AST_PURCHASE_PRICE	DEC	23(4)			BAPICURR
PURCHASE_PRICE_CURRENCY	Purchase price currency	BAPICMS_DTE_AST_PUR_PRICE_CURR	CUKY	5			WAERS
PURCHASE_PRICE_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
PURCHASE_DATE	Date of Purchase	BAPICMS_DTE_AST_PUR_PRICE_DATE	DATS	8			CMS_DATE
MAINOBJECT_ACCESSORIES_DATA				0
MAINOBJECT_BUSINESS_PARTNER				0
MAINOBJECT_DOCUMENT_DATA				0
MAINOBJECT_VALUE_DATA				0
MAINOBJECT_LANDREGISTER_DATA				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
LANDREGISTER_LINK_KEY	Link Key between RE and LR systems	BAPICMS_RE_DTE_LR_ID_LKY	CHAR	32			SYSUUID_C
MAINOBJECT_COST_DATA				0
OBJECT_PARTS_DATA				0
PARTS_ACCESSORIES_DATA				0
PARTS_BUSINESS_PARTNER_DATA				0
PARTS_DOCUMENT_DATA				0
PARTS_VALUE_DATA				0
PARTS_LANDREGISTER_DATA				0
PARTS_COST_DATA				0
INSURANCE_DATA				0
INSURANCE_BUPA_DATA				0
INSURANCE_DOCUMENTS_DATA				0
MAINOBJECT_PROPERTYLIST_DATA				0
MAINOBJECT_NONMONETARY_DATA				0
PARTS_PROPERTYLIST_DATA				0
PARTS_NONMONETARY_DATA				0
NOTES				0
USER_STATUS				0
SYSTEM_STATUS				0
CALCULATION_RESULTS				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ASSET_GUID	GUID for Table CMS_AST	BAPICMS_DTE_AST_GUID	CHAR	32			SYSUUID_C
RESULT_CURRENCY	Calculations Result Currency	BAPICMS_DTE_CALC_RES_CURR	CUKY	5			WAERS
RESULT_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_VALUE_AMOUNT	Lending value Calculation for Asset	BAPICMS_DTE_AST_LENDING_VALUE	DEC	23(4)			BAPICURR
LENDING_VALUE_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT1_AMOUNT	Lending Limit 1 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT1	DEC	23(4)			BAPICURR
LENDING_LIMIT1_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT2_AMOUNT	Lending Limit 2 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT2	DEC	23(4)			BAPICURR
LENDING_LIMIT2_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT3_AMOUNT	Lending Limit 3 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT3	DEC	23(4)			BAPICURR
LENDING_LIMIT3_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT4_AMOUNT	Lending Limit 4 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT4	DEC	23(4)			BAPICURR
LENDING_LIMIT4_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT5_AMOUNT	Lending Limit 5 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT5	DEC	23(4)			BAPICURR
LENDING_LIMIT5_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE1_AMOUNT	Lending Range 1 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE1	DEC	23(4)			BAPICURR
LENDING_RANGE1_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE2_AMOUNT	Lending Range 2 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE2	DEC	23(4)			BAPICURR
LENDING_RANGE2_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE3_AMOUNT	Lending Range 3 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE3	DEC	23(4)			BAPICURR
LENDING_RANGE3_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE4_AMOUNT	Lending Range 4 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE4	DEC	23(4)			BAPICURR
LENDING_RANGE4_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE5_AMOUNT	Lending Range 5 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE5	DEC	23(4)			BAPICURR
LENDING_RANGE5_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CALCULATION_RESULTS_MAIN				0
IDENTIFICATION	Object ID	BAPICMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
TYPE	Real Estate Object Type ID	BAPICMS_RE_DTE_OBJ_TYP	CHAR	6			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ASSET_GUID	GUID for Table CMS_AST	BAPICMS_DTE_AST_GUID	CHAR	32			SYSUUID_C
RESULT_CURRENCY	Calculations Result Currency	BAPICMS_DTE_CALC_RES_CURR	CUKY	5			WAERS
RESULT_CURRENCY_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_VALUE_AMOUNT	Lending value Calculation for Asset	BAPICMS_DTE_AST_LENDING_VALUE	DEC	23(4)			BAPICURR
LENDING_VALUE_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT1_AMOUNT	Lending Limit 1 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT1	DEC	23(4)			BAPICURR
LENDING_LIMIT1_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT2_AMOUNT	Lending Limit 2 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT2	DEC	23(4)			BAPICURR
LENDING_LIMIT2_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT3_AMOUNT	Lending Limit 3 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT3	DEC	23(4)			BAPICURR
LENDING_LIMIT3_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT4_AMOUNT	Lending Limit 4 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT4	DEC	23(4)			BAPICURR
LENDING_LIMIT4_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_LIMIT5_AMOUNT	Lending Limit 5 Calculation for Asset	BAPICMS_DTE_AST_LENDING_LIMIT5	DEC	23(4)			BAPICURR
LENDING_LIMIT5_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE1_AMOUNT	Lending Range 1 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE1	DEC	23(4)			BAPICURR
LENDING_RANGE1_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE2_AMOUNT	Lending Range 2 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE2	DEC	23(4)			BAPICURR
LENDING_RANGE2_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE3_AMOUNT	Lending Range 3 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE3	DEC	23(4)			BAPICURR
LENDING_RANGE3_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE4_AMOUNT	Lending Range 4 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE4	DEC	23(4)			BAPICURR
LENDING_RANGE4_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
LENDING_RANGE5_AMOUNT	Lending Range 5 calculation for Asset	BAPICMS_DTE_AST_LENDING_RANGE5	DEC	23(4)			BAPICURR
LENDING_RANGE5_AMOUNT_ISO	ISO Currency Code	BAPIISOCD	CHAR	3			ISOCD
CALCULATION_RESULTS_PARTS				0
EXTENSIONOUT				0

Key field

Non-key field

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

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

How to access SAP table CMS_STR_BII_RE_DETAIL_SNG

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