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

CMS_STR_ANL_CS_RE_DETAILS SAP (Real estate details for collateral sheet) Structure details

Dictionary Type: Structure
Description: Real estate details for collateral sheet

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

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_ANL_CS_RE_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 "Real estate details for collateral sheet" 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_ANL_CS_RE_DETAILS TYPE CMS_STR_ANL_CS_RE_DETAILS.

The CMS_STR_ANL_CS_RE_DETAILS table consists of various fields, each holding specific information or linking keys about Real estate details for collateral sheet data available in SAP. These include AST_GUID (GUID for Table CMS_AST), AST_ID (Asset ID), AST_TYP (Asset Type), OBJ_GUID (GUID for 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. .

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_STR_ANL_CS_RE_DETAILS 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
AST_GUID	GUID for Table CMS_AST	CMS_DTE_AST_GUID	RAW	16			SYSUUID
AST_ID	Asset ID	CMS_DTE_AST_ID	CHAR	40		ALPHA	CMS_AST_ID	CMS_ASTID	CMS_SRCH_AST
AST_TYP	Asset Type	CMS_DTE_AST_TYP	CHAR	6	Assigned to domain		CMS_AST_TYP	CMS_AST_TYP	CMS_AST_TYP
OBJ_GUID	GUID for Real Estate Object	CMS_RE_DTE_OBJ_GUID	RAW	16			SYSUUID	CMS_RE_OBJ_GUID
OBJECT_ID	Object ID	CMS_RE_DTE_OBJECT_ID	CHAR	20		ALPHA	CMS_RE_OBJECT_ID	CMS_RE_OBJECT_ID	CMS_RE_SRCH_ALL
OBJECT_TYPE	Real Estate Object Type ID	CMS_RE_DTE_OBJ_TYP	CHAR	6	TCMS_RE_TYP		CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ADDR_ID	Address ID	CMS_RE_DTE_ADDR_ID	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM		ADMC
OBJECT_DESC	Description of the Real Estate Object	CMS_RE_DTE_OBJ_DESC	CHAR	30			CMS_RE_DESC
OBJ_PARENT_ID	GUID for Real Estate Object	CMS_RE_DTE_OBJ_GUID	RAW	16			SYSUUID	CMS_RE_OBJ_GUID
OBJ_OLD_REF_NO	External reference Number of an External System	CMS_RE_DTE_OBJ_REF_NO	CHAR	32			CMS_RE_REFID
FIX_FITTING_TYP	Fixtures and Fittings Type ID	CMS_RE_DTE_FIX_FIT_TYP	CHAR	6		ALPHA	CMS_RE_FIX_FIT_TYP
OBJECT_AREA_UOM	Unit of Measure for Area	CMS_RE_DTE_AREA_UOM	UNIT	3	Assigned to domain	CUNIT	MEINS	CMS_AREA_UOM	CMS_ELM_SURFACE_UOM
OBJECT_VOL_UOM	Unit of Measure for Volume of Real Estate	CMS_RE_DTE_VOL_UOM	UNIT	3	Assigned to domain	CUNIT	MEINS	CMS_VOL_UOM	CMS_ELM_VOLUME_UOM
OBJECT_CURR	Object Currency	CMS_RE_DTE_OBJ_CURR	CUKY	5	TCURC		WAERS	CMS_OBJ_CURR
MACRO_LOC_TYPE	Macro Location	CMS_RE_DTE_ATT_ID_TY_REO002	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
MICRO_LOC_TYPE	Micro Location	CMS_RE_DTE_ATT_ID_TY_REO003	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
TRAN_CONN_TYPE	Transport Connection	CMS_RE_DTE_ATT_ID_TY_REO004	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
ENVIRON_STATUS	Enviromental Status	CMS_RE_DTE_ATT_ID_TY_REO005	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
FLOOD_ZONE_FLG	Indicator for Flood Zone	CMS_RE_DTE_FLOOD_ZONE	CHAR	1		ALPHA	CMS_RE_FLG
EARTHQUAKE_FLG	Indicator : Eathquake Zone	CMS_RE_DTE_EARTHQUAKE	CHAR	1		ALPHA	CMS_RE_FLG
ARCT_CONV_FLG	Indicator for Architectural Conservation Area	CMS_RE_DTE_ARCT_CONV	CHAR	1		ALPHA	CMS_RE_FLG
HIST_SITE_FLG	Indicator for Historical Site	CMS_RE_DTE_HIST_SITE	CHAR	1		ALPHA	CMS_RE_FLG
IS_VAL_IMP_FACS	Indicates existence of Factors Impairing Real Estate Value	CMS_RE_DTE_VAL_IMP_FLG	CHAR	1		ALPHA	CMS_RE_FLG
VALUE_IMP_DESC	Description of the value imparing factor	CMS_RE_DTE_VAL_IMP_DESC	CHAR	30			CMS_RE_DESC
ADMIN_ORG_UNIT	Administration Organizational Unit	CMS_DTE_ADMINORG	CHAR	12			TEXT12	CMS_ADMINORG
BANKAREA	Bank Area in Collateral Management	CMS_DTE_BANKAREA	CHAR	4	Assigned to domain		CMS_BANKAREA	CMS_BANKAREA
CREATED_BY	Real Estate Add-On User	CMS_RE_DTE_CR_BY	CHAR	12			CMS_RE_USER
CREATED_DATE	Created On	CMS_RE_DTE_CR_ON	DATS	8			CMS_RE_DATE
CREATED_TIME	Created At	CMS_RE_DTE_CR_AT	TIMS	6			CMS_RE_TIME
ENTRY_SRC	Sorce of Initial entry	CMS_RE_DTE_SRC_INIT	CHAR	32			CMS_RE_SOURCE
LAST_CHG_BY	Last Changed By	CMS_RE_DTE_CHG_BY	CHAR	12			CMS_RE_USER
LAST_CHG_DATE	Last Changed On	CMS_RE_DTE_CHG_ON	DATS	8			CMS_RE_DATE
LAST_CHG_TIME	Last Changed At	CMS_RE_DTE_CHG_AT	TIMS	6			CMS_RE_TIME
PROCESSING_SRC	Processing Source	CMS_RE_DTE_PRC_SRC	CHAR	32			CMS_RE_SOURCE
OBJ_TYP_DESC	Name in a specified language	CMS_RE_DTE_NAME	CHAR	40			CMS_RE_NAME
ADDRNUMBER	Address number	AD_ADDRNUM	CHAR	10	Assigned to domain	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	Assigned to domain		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	TSAD3		AD_TITLE
NAME1	Name 1	AD_NAME1	CHAR	40			TEXT40
NAME2	Name 2	AD_NAME2	CHAR	40			TEXT40
NAME3	Name 3	AD_NAME3	CHAR	40			TEXT40
NAME4	Name 4	AD_NAME4	CHAR	40			TEXT40
NAME_TXT	Converted name field (with form of address)	AD_NAMETXT	CHAR	50			TEXT50
NAME_CO	c/o name	AD_NAME_CO	CHAR	40			TEXT40
CITY1	City	AD_CITY1	CHAR	40			TEXT40		CLCITYNAME
CITY2	District	AD_CITY2	CHAR	40			TEXT40		CITY_PART
CITY_CODE	City code for city/street file	AD_CITYNUM	CHAR	12	ADRCITY	ALPHA	CITY_CODE
CITYP_CODE	District code for City and Street file	AD_CITYPNM	CHAR	8	ADRCITYPRT	ALPHA	CITYP_CODE
HOME_CITY	City (different from postal city)	AD_CITY3	CHAR	40			TEXT40
CITYH_CODE	Different city for city/street file	AD_CITYHNM	CHAR	12	ADRCITY	ALPHA	CITY_CODE
CHCKSTATUS	City file test status	AD_CHECKST	CHAR	1			AD_CHECKST
REGIOGROUP	Regional structure grouping	REGIOGROUP	CHAR	8	ADRREGGRP		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	TSAD12		AD_NO_USE
PO_BOX_NUM	Flag: PO Box Without Number	AD_POBXNUM	CHAR	1			XFELD
PO_BOX_LOC	PO Box city	AD_POBXLOC	CHAR	40			TEXT40		CITY_NAME
CITY_CODE2	City PO box code (City file)	AD_CIT2NUM	CHAR	12	ADRCITY	ALPHA	CITY_CODE
PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	AD_POBXREG	CHAR	3	T005S		REGIO
PO_BOX_CTY	PO box country	AD_POBXCTY	CHAR	3	T005		LAND1
POSTALAREA	(Not Supported) Post Delivery District	AD_PSTLAR	CHAR	15			TEXT15
TRANSPZONE	Transportation zone to or from which the goods are delivered	LZONE	CHAR	10	TZONE		ZONE
STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
DONT_USE_S	Street Address Undeliverable Flag	AD_NO_USES	CHAR	4	TSAD12		AD_NO_USE
STREETCODE	Street Number for City/Street File	AD_STRNUM	CHAR	12	ADRSTREET	ALPHA	STRT_CODE
STREETABBR	(Not Supported) Abbreviation of Street Name	AD_STRABBR	CHAR	2	ADRSTRTYPE		STRTYPEAB
HOUSE_NUM1	House Number	AD_HSNM1	CHAR	10			TEXT10
HOUSE_NUM2	House number supplement	AD_HSNM2	CHAR	10			TEXT10
HOUSE_NUM3	(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
BUILDING	Building (Number or Code)	AD_BLDNG	CHAR	20			TEXT20
FLOOR	Floor in building	AD_FLOOR	CHAR	10			TEXT10
ROOMNUMBER	Room or Appartment Number	AD_ROOMNUM	CHAR	10			TEXT10
COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
LANGU	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
REGION	STATE (State, Province, County)	REGIO	CHAR	3	Assigned to domain		REGIO
SORT1	Search Term 1	AD_SORT1UL	CHAR	20			TEXT20
SORT2	Search Term 2	AD_SORT2UL	CHAR	20			TEXT20
SORT_PHN	(Not Supported) Phonetic Search Sort Field	AD_SRTPHN	CHAR	20			CHAR20
ADDRORIGIN	(Not Supported) Address Data Source (Key)	AD_ORIGINA	CHAR	4	TSAD6		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	TTZZ		TZNZONE
TAXJURCODE	Tax Jurisdiction	AD_TXJCD	CHAR	15			AD_TXJCD	TXJ
ADDRESS_ID	(Not supported) Physical address ID	AD_ADDR_ID	CHAR	10		ALPHA	AD_ADDR_ID
REMARK	Address notes	AD_REMARK1	CHAR	50			TEXT50
LANGU_CREA	Address record creation original language	AD_LANGUCR	LANG	1	T002	ISOLA	SPRAS
PO_BOX_LOBBY	PO Box Lobby	AD_PO_BOX_LBY	CHAR	40			TEXT40
DELI_SERV_TYPE	Type of Delivery Service	AD_DELIVERY_SERVICE_TYPE	CHAR	4	ADDRC_DELI_SERV		AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER	Number of Delivery Service	AD_DELIVERY_SERVICE_NUMBER	CHAR	10			CHAR10
COUNTY_CODE	County code for county	AD_CNTYNUM	CHAR	8	ADRCOUNTY	ALPHA	CNTY_CODE
COUNTY	County	AD_COUNTY	CHAR	40			TEXT40		CLTCNTYNAME
TOWNSHIP_CODE	Township code for Township	AD_TWSHPNUM	CHAR	8	ADRTOWNSHIP	ALPHA	TWSHP_CODE
TOWNSHIP	Township	AD_TOWNSHIP	CHAR	40			TEXT40		CLTWSHPNAME
DEFLT_COMM	Communication Method (Key) (Business Address Services)	AD_COMM	CHAR	3	TSAC		AD_COMM
TEL_NUMBER	First telephone no.: dialling code+number	AD_TLNMBR1	CHAR	30			CHAR30
TEL_EXTENS	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	Assigned to domain		AD_GROUP
DISTRICT	District Court	CMS_DTE_LR_DE_DISTRICT	CHAR	25			CMS_LR_DE_TEXT25
SUB_DISTRICT	Land Register District	CMS_DTE_LR_DE_SUB_DISTRICT	CHAR	25			CMS_LR_DE_TEXT25
VOLUME_NO	Volume Number	CMS_DTE_LR_DE_VOLUME_NO	CHAR	15			CMS_LR_DE_TEXT15
PAGE_NO	Page Number	CMS_DTE_LR_DE_PAGE_NO	CHAR	15			CMS_LR_DE_TEXT15
REG_TYPE	Register Type	CMS_DTE_LR_DE_REG_TYP	CHAR	6	Assigned to domain		CMS_RE_TYP
OLD_REF_ID	Reference of Old Land Register, in case data was migrated	CMS_DTE_LR_DE_OLD_REF_ID	CHAR	32			CMS_LR_DE_OLD_REF_ID
SECB_GUID	GUID for Table CMS_LR_DE_B	CMS_DTE_LR_DE_SECB_GUID	RAW	16			SYSUUID
SECA_GUID	GUID for Table CMS_LR_DE_A	CMS_DTE_LR_DE_SECA_GUID	RAW	16			SYSUUID
ACCESSORY_CURR	Currency of the Final Asset Value	CMS_DTE_AST_VALUE_CURR	CUKY	5	Assigned to domain		WAERS
TOT_ACCESSORIES	Calculations Result Amount	CMS_DTE_CALC_RES_AMT	CURR	17(2)			CMS_AMOUNT
SERIAL_NO	Serial number of the Property List Number	CMS_DTE_LR_DE_SECB_SR_NO	CHAR	4		ALPHA	CMS_LR_DE_SERIAL_NO
AREA	Area	CMS_DTE_LR_DE_AREA	QUAN	13(3)			CMS_LR_DE_AREA
AREA_UOM	Unit of Measure	CMS_DTE_LR_DE_AREA_UOM	UNIT	3	Assigned to domain	CUNIT	MEINS		CMS_ELM_SURFACE_UOM
FLUR	Flur	CMS_DTE_LR_DE_FLUR	CHAR	10			CMS_LR_DE_FLUR
FLURSTUECK	Parcel of the land. Flurstueck in German	CMS_DTE_LR_DE_FLURSTUECK	CHAR	60			CMS_LR_DE_TEXT60
AST_DISP_DATA	Asset IF : Screen Data for Object ID	CMS_DTE_AST_IF_OBJ_ID_SCR	CHAR	90			CMS_SCR_TEXT

Key field

Non-key field

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

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

How to access SAP table CMS_STR_ANL_CS_RE_DETAILS

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

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!