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

CMS_STR_COR_RE_REQ SAP (Real estate) Structure details

Dictionary Type: Structure
Description: Real estate

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

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_COR_RE_REQ 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" 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_COR_RE_REQ TYPE CMS_STR_COR_RE_REQ.

The CMS_STR_COR_RE_REQ table consists of various fields, each holding specific information or linking keys about Real estate data available in SAP. These include MANDT (Client), COTYP (Correspondence Type), COKEY (Correspondence key), UNAME (User Name).. 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_COR_RE_REQ 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
WA_RE_GEN				0
MANDT	Client	MANDT	CLNT	3			MANDT
COTYP	Correspondence Type	COTYP_KK	CHAR	4			COTYP_KK	COTYP	COTYP_KK
COKEY	Correspondence key	COKEY_KK	CHAR	36			COKEY_KK
UNAME	User Name	SYUNAME	CHAR	12			SYCHAR12
CDATE	Created On	COCDT_KK	DATS	8			SYDATS
CTIME	Time of Creation (to the Second)	COCTM_KK	TIMS	6			SYTIME
GPART	Correspondence Recipient	CREC_GP_KK	CHAR	10		ALPHA	BU_PARTNER
GPART_GUID	Correspondence Recipient (GUID)	CREC_GP_GUID_KK	CHAR	32			SYSUUID_C
GPART_ADR_KIND	Address Type Of Correspondence Recipient	CORR_ADR_KIND_KK	CHAR	10			BU_ADRKIND
ORG_GPART	Original Correspondence Recipient	CREC_ORG_GP_KK	CHAR	10		ALPHA	BU_PARTNER
ORG_GPART_GUID	Original Correspondence Recipient (GUID)	CREC_ORG_GP_GUID_KK	CHAR	32			SYSUUID_C
ADD_GPART	Additional Business Partner for Correspondence Recipient	CREC_GP_ADD_KK	CHAR	10		ALPHA	BU_PARTNER
ADD_GPART_GUID	Addit. Business Partner for Correspondence Recipient GUID	CREC_GP_ADD_GUID_KK	CHAR	32			SYSUUID_C
ADD_GPART_CAT	Type of Additional Correspondence Recipient	CREC_GP_ADD_CAT_KK	CHAR	1			CORR_CREC_ADD_CAT_KK
VKONT	Contract Account Number	CORR_VKONT_KK	CHAR	12		ALPHA	CORR_VKONT_KK
VTREF	Reference Specifications from Contract	CORR_VTREF_KK	CHAR	20		ALPHA	CORR_VTREF_KK
ADR_VALID_ON	Address of Correspondence Recipient Valid On	CREC_AD_VALID_ON_KK	DEC	15			TZNTSTMPS
ADRNR	Address Number of Correspondence Recipient	CREC_AD_KK	CHAR	10		ALPHA	AD_ADDRNUM
ADR_GUID	Address GUID of Correspondence Recipient	CREC_AD_GUID_KK	CHAR	32			SYSUUID_C
ADRNR_INDEP_COMM	Address Number for Address-Independent Communication	CREC_AD_INDEP_COMM_KK	CHAR	10		ALPHA	AD_ADDRNUM
AGPART	Sending Business Partner	CSEN_GP_KK	CHAR	10		ALPHA	BU_PARTNER
AGPART_GUID	Sender (GUID)	CSEN_GP_GUID_KK	CHAR	32			SYSUUID_C
AGPART_ADR_KIND	Address Type Of Correspondence Recipient	CORR_ADR_KIND_KK	CHAR	10			BU_ADRKIND
AADRNR	Address Number of Correspondence Sender	CSEN_AD_KK	CHAR	10		ALPHA	AD_ADDRNUM
AADR_GUID	Address GUID of Correspondence Sender	CSEN_AD_GUID_KK	CHAR	32			SYSUUID_C
FORMKEY	Application form	FORMKEY	CHAR	30			FORMKEY	FOM
FORMKEY_RDI	Application form	FORMKEY	CHAR	30			FORMKEY	FOM
ENTID1	Correspondence data	ENTID_KK	CHAR	4			ENTID_KK
DATA1	Correspondence Data Field	CDATA_KK	CHAR	32			CDATA_KK
ENTID2	Correspondence data	ENTID_KK	CHAR	4			ENTID_KK
DATA2	Correspondence Data Field	CDATA_KK	CHAR	32			CDATA_KK
ENTID3	Correspondence data	ENTID_KK	CHAR	4			ENTID_KK
DATA3	Correspondence Data Field	CDATA_KK	CHAR	32			CDATA_KK
ENTID4	Correspondence data	ENTID_KK	CHAR	4			ENTID_KK
DATA4	Correspondence Data Field	CDATA_KK	CHAR	32			CDATA_KK
CSORT	Correspondence Sort Field	CSORT_KK	CHAR	50			CORR_TXT50
XCODT	Data Part Is Used	XCODT_KK	CHAR	1			XFELD
XCODT_CLUST	Cluster Data Part is Used	XCODT_CLUST_KK	CHAR	1			XFELD
LAUFD	Date ID for Creation Run	CORR_LAUFD_KK	DATS	8			DATUM
LAUFI	Additional ID Characteristic for Creation Run	CORR_LAUFI_KK	CHAR	6			CORR_LAUFI_KK
XTEST	Correspondence is Result of Test	XTEST_KK	CHAR	1			XFELD
COPRI	Print Date	COPRI_KK	DATS	8			SYDATS
COIDT	Date of Issue	COIDT_KK	DATS	8			SYDATS
COITM	Issue Time to the Second	COITM_KK	TIMS	6			SYTIME
SPRAS	Language Key	SPRAS	LANG	1		ISOLA	SPRAS	SPR	H_T002
SALWA	Transaction Currency	CORR_BLWAE_KK	CUKY	5			WAERS	FWS
SALBE	Amount in Local Currency with +/- Signs	CORR_BETRH_KK	CURR	13(2)			WRTV7
SENDCONTROL	Dispatch Control	SENDCONTROL	CHAR	4			ESENDCONTROL
PERSNUMBER	Person number	AD_PERSNUM	CHAR	10		ALPHA	AD_PERSNUM	CDT	ADDRESS
APERSNUMBER	Person number	AD_PERSNUM	CHAR	10		ALPHA	AD_PERSNUM	CDT	ADDRESS
BUKRS	Company Code in Correspondence	CORR_BUKRS	CHAR	4			CORR_BUKRS
CORR_ROLE	Correspondence Roles	CORR_ROLE_KK	CHAR	4			CORR_ROLE_KK
COPRI_LAUFD	Date ID for Print Run	COPRI_LAUFD_KK	DATS	8			DATUM
COPRI_LAUFI	ID Characteristic for Run	COPRI_LAUFID_KK	CHAR	6			COPRI_LAUFID_KK
PROCESS_ID_	Business Process ID	CORR_PROCESS_ID_KK	CHAR	36
NO_DOCPARTS	Number of Document Parts	CORR_NO_DOCPARTS_KK	NUMC	4
DOCPART_ROLE	Document Part Role	CORR_DOCPART_ROLE_KK	CHAR	1			CORR_DOCPART_ROLE_KK
XTRIAL	Correspondence Request is Test	XTRIAL_KK	CHAR	1			XFELD
XREPRINT	Recreate Correspondence	XREPRINT_KK	CHAR	1			XFELD
SUBAP	Subapplication Indicator in Correspondence	CORR_SUBAP_KK	CHAR	1			CORR_SUBAP_KK
XDELETE	Correspondence Is Logically Deleted	X_CORR_DELETE_KK	CHAR	1			XFELD
PRINT_MODE	Business Partner Print Format	PRINT_MODE_KK	CHAR	1			BU_PRINT_MODE
X_NO_ARC	SAP ArchiveLink Object ID Part Is Not Used	X_NO_ARC_KK	CHAR	1			XFELD
X_DOCPART_LIST	Document Part List Is Used	X_DOCPART_LIST_KK	CHAR	1			XFELD
.INCLU--AP				0
BKKRS	Bank Area	BKK_BKKRS	CHAR	4			BKK_BKKRS	BNS
ACNUM_INT	Internal Account Number for Current Account	BKK_ACCNT	CHAR	10		ALPHA	BKK_ACCNT	ACI
.INCLU--AP				0
.INCLU-CMS				0
OBJECT_IDCMS	Object Identification Number	CMS_DTE_OBJECT_ID	RAW	16			SYSUUID
FLG_ORIGINALCMS	Flag to indicate if the document is original or duplicate	CMS_DTE_FLG_ORIG	CHAR	1			CMS_FLG
SENDCONTROLCMS	Dispatch Control	SENDCONTROL	CHAR	4			ESENDCONTROL
.INCLU--AP				0
.INCLU-FVD				0
PRODUCTTYPEFVD	Product Type	VVSART	CHAR	3			VVSART	SAN	VVSART_APPL_BAS
BP_ROLEFVD	BP Role	BU_PARTNERROLE	CHAR	6			BU_ROLE		BUPA_ROLE
BP_ROLETYPEFVD	Business Partner Role Type	BP_ROLE	CHAR	4			BP_ROLE
SOBJECTFVD	Internal key for object	VVKEYOBJ	CHAR	10			VVKEY
CORR_ACTIVITYFVD	Correspondence activity	KORRVORF	NUMC	4			KORRVORF
REFERENCEDATEFVD	Reference Date for Creating Correspondence	TB_CORR_REFERENCE_DATE	DATS	8			DATUM
WA_RECEIVER				0
BU_PARTNERID	Business Partner Identification Number	CMS_DTE_BPID	CHAR	32			CMS_BPID
BP_DESCRIPTION	Address description of Business Partner	CMS_DTE_BP_ADDR_DESC	CHAR	60			CMS_BP_ADDR_DESC
WA_SENDER				0
MANDT	Client	MANDT	CLNT	3			MANDT
PLVAR	Plan Version	PLVAR	CHAR	2			PLVAR	POP
OTYPE	Object Type	OTYPE	CHAR	2			OTYPE	POT
OBJID	Object ID	OBJEKTID	NUMC	8			NUM08	PON
INFTY	Infotype	INFOTYP	CHAR	4			INFOTYP		HRBAS00INFTY
SUBTY	Subtype	SUBTYP	CHAR	4			SUBTYP
ISTAT	Planning Status	ISTAT_D	CHAR	1			ISTAT	PST
PRIOX	Priority	PRIOX	CHAR	2			CHAR2
BEGDA	Start Date	BEGDATUM	DATS	8			DATUM	BEG
ENDDA	End Date	ENDDATUM	DATS	8			DATUM	END
VARYF	Variation Field for File PLOG	VARYF	CHAR	10			CHAR10
SEQNR	Number of Infotype Record with Same Key	SEQNR	NUMC	3			NUM03
AEDTM	Changed on	AEDTM	DATS	8			DATUM
UNAME	User Name	USRNAME	CHAR	12			CHAR12
REASN	Reason	REASN	CHAR	2			CHAR2
HISTO	Historical Record Flag	HISTO	CHAR	1			CHAR1
ITXNR	Text Module for Infotype	ITXNR	NUMC	8			NUM08
CNAME	Address Supplement (c/o)	CNAME	CHAR	25			TEXT25
STRAS	House Number and Street	PD_STRAS	CHAR	30			TEXT30
ORT01	City	KORT	CHAR	40			TEXT40
PSTLZ	Postal Code	PD_PSTLZ	CHAR	10			PSTLZ
LAND1	Country	KLAND	CHAR	3			LAND1
TELNR	Telephone Number	TELENR	CHAR	25			CHAR25
FAXNR	Fax Number	FAXNR	CHAR	25			CHAR25
ENTKM	Distance in Kilometers	ENTKM	DEC	3			DEC3
BUILD	Building	BUILD	CHAR	8			BUILD
ROOM1	Physical Room Number	ROOM1	CHAR	8			CHAR8
ADRNR	Address	ADRNR	CHAR	10		ALPHA	ADRNR
REGIO	STATE (State, Province, County)	REGIO	CHAR	3			REGIO
STRS2	House number and street	STRAS_GP	CHAR	35			TEXT35
HAUSN	House number	HAUSN_BAS	CHAR	6			CHAR6
WA_RE_OBJ_DET				0
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			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
OBJ_PRT_GUID	GUID for Object part	CMS_RE_DTE_OBJ_PRT_GUID	RAW	16			SYSUUID
BLD_PART_TYPE	Building Part Type	CMS_RE_DTE_ATT_ID_TY_REO006	CHAR	6			CMS_ATT_ID_TYP
PART_COND	Object condition	CMS_RE_DTE_ATT_ID_TY_REO001	CHAR	6			CMS_ATT_ID_TYP
MAIN_USAGE	Usage Type	CMS_RE_DTE_USG_TYP	CHAR	6			CMS_RE_TYP
ADD_USAGE_1	Additional Usage 1	CMS_RE_DTE_ADD1_USG_TYP	CHAR	6			CMS_RE_TYP
ADD_USAGE_2	Additional Usage 2	CMS_RE_DTE_ADD2_USG_TYP	CHAR	6			CMS_RE_TYP
BLD_METHOD_ROOF	Building method - Roof	CMS_RE_DTE_ATT_ID_TY_REO007	CHAR	6			CMS_ATT_ID_TYP
BLD_METHOD_BODY	Building method - Body	CMS_RE_DTE_ATT_ID_TY_REO008	CHAR	6			CMS_ATT_ID_TYP
BLD_METD_CELLAR	Building method - Cellar	CMS_RE_DTE_ATT_ID_TY_REO009	CHAR	6			CMS_ATT_ID_TYP
UTILIZATION	Utilization of the Object	CMS_RE_DTE_PRT_UTILIZATION	CHAR	6			CMS_RE_UTIL
PART_DESC	Description of Building Part	CMS_RE_DTE_SPC_DESC	CHAR	30			CMS_RE_DESC
COMM_USAGE_PCT	Commercial Usage as a Percentage of Total Usage	CMS_RE_DTE_COM_USE_PCT	DEC	10(6)			CMS_RE_PCT
OTHER_USG_FLG	Indicates if Usages in addition to Main Usage are Possible	CMS_RE_DTE_OTH_USE_FLG	CHAR	1		ALPHA	CMS_RE_OTH_USG_FLG
REF_OBJ_PRT_GUID	Reference Object Part GUID	CMS_RE_DTE_REF_OBJ_PRT_GUID	RAW	16			SYSUUID
IS_SUB_AST_CREA	Indicates whether a Sub-asset is created for Building Part	CMS_RE_DTE_CREATE_SUB_AST_FLG	CHAR	1		ALPHA	CMS_RE_FLG
USEFUL_AREA	Usable Area	CMS_RE_DTE_AREA_USEFUL	QUAN	13(3)			CMS_RE_SIZE
USBL_AREA_UOM	Unit of Measure for Usable Area	CMS_RE_DTE_USBL_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
USEFUL_AREA_REN	Rented Usable Area	CMS_RE_DTE_AREA_USEFUL_REN	QUAN	13(3)			CMS_RE_SIZE
USBL_AR_REN_UOM	Unit of Measure for Usable Rented Area	CMS_RE_DTE_USBL_AREA_REN_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
USEFUL_VOL	Usable Volume of Real Estate Building Parts	CMS_RE_DTE_VOL_USEFUL	QUAN	13(3)			CMS_RE_SIZE
USBL_VOL_UOM	Unit of Measure for Usable Volume of Real Estate	CMS_RE_DTE_USBL_VOL_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_VOLUME_UOM
USEFUL_VOL_REN	Usable Volume of the Rented Portions of Real Estate	CMS_RE_DTE_VOL_USEFUL_REN	QUAN	13(3)			CMS_RE_SIZE
USBL_VL_REN_UOM	Unit of measure for usable volume of Rented Parts	CMS_RE_DTE_USBL_VOL_REN_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_VOLUME_UOM
RESIDENTIAL_AREA	Residential Area	CMS_RE_DTE_AREA_RESIDENTIAL	QUAN	13(3)			CMS_RE_SIZE
RES_AR_UOM	Unit of Measure for Residential Area	CMS_RE_DTE_RES_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
SECONDARY_AREA	Secondary Area	CMS_RE_DTE_AREA_SECONDARY	QUAN	13(3)			CMS_RE_SIZE
SEC_AREA_UOM	Unit of Measure for Secondary Area	CMS_RE_DTE_SEC_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
OTHER_AREA	Other Area	CMS_RE_DTE_AREA_OTHER	QUAN	13(3)			CMS_RE_SIZE
OTH_AREA_UOM	Unit of Measure for Other Area	CMS_RE_DTE_OTH_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
NO_PRT_UNIT	Number of building part units	CMS_RE_DTE_NO_PRT_UNIT	INT4	10			CMS_RE_UNITS
NO_PRT_UNIT_REN	Number of building part units rented	CMS_RE_DTE_NO_PRT_UNIT_REN	INT4	10			CMS_RE_UNITS
CONS_START_DATE	Start Date of Construction	CMS_RE_DTE_OBJ_CONS_ST_DATE	DATS	8			CMS_RE_DATE
PERMSN_APPL_DATE	Building Permssion applied date	CMS_RE_DTE_OBJ_PMSN_APPL_DATE	DATS	8			CMS_RE_DATE
PERMSN_OBTD_DATE	Building Permssion obtained date	CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	DATS	8			CMS_RE_DATE
OCCY_DATE	Occupancy Date	CMS_RE_DTE_OBJ_OCCY_DATE	DATS	8			CMS_RE_DATE
COMP_DATE	Completion Date	CMS_RE_DTE_OBJ_COMP_DATE	DATS	8			CMS_RE_DATE
FINAL_INSP_DATE	Date of Final Inspection	CMS_RE_DTE_OBJ_FINAL_INSP_DATE	DATS	8			CMS_RE_DATE
RENT_AMT_PLANNED	Planned Rent Amount	CMS_RE_DTE_RENT_AMOUNT	CURR	17(2)			CMS_RE_AMOUNT
RENT_AMT_ACTUAL	Actual Rent Amount	CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	17(2)			CMS_RE_AMOUNT
RENT_PLAN_CURR	Planned Rent Currency	CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	5			WAERS
RENT_ACT_CURR	Actual Rent Currency	CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	5			WAERS
BASE_PERIOD	Base period for the rent	CMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEASURE	Base Measure	CMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
VACANT_POSN_PCT	Ratio of Real Estate not rented to Total Real Estate Value	CMS_RE_DTE_VACANT_POS_PCT	DEC	10(6)			CMS_RE_PCT
RES_RENT_IND	Indicator for Net or Gross Rent	CMS_RE_DTE_RES_IND	CHAR	1			CMS_RE_RENT_FLG
COMP_RENT_RES	Comparative Rent (Residential)	CMS_RE_DTE_RENT_LEVEL	CURR	17(2)			CMS_RE_AMOUNT
COM_REN_RES_CURR	Comparative Rent Currency - Residential	CMS_RE_DTE_COMP_RENT_RES_CURR	CUKY	5			WAERS
LAND_AREA	Land Area of the Real Estate	CMS_RE_DTE_LAND_AREA	QUAN	13(3)			CMS_RE_SIZE
LAND_AREA_UOM	Unit of Measure of Land Area	CMS_RE_DTE_LAND_AREA_UOM	UNIT	3		CUNIT	MEINS		CMS_ELM_SURFACE_UOM
LAND_AREA_REN	Land Area of the Real Estate which is Rented	CMS_RE_DTE_LAND_AREA_REN	QUAN	13(3)			CMS_RE_SIZE
LAND_AR_REN_UOM	Land area unit of measure(rented)	CMS_RE_DTE_LAND_AREA_REN_UOM	UNIT	3		CUNIT	MEINS
NO_OF_UNITS	No of units in real estate object	CMS_RE_DTE_NO_UNIT	INT4	10			CMS_RE_UNITS
NO_OF_FLOORS	Number of Floors	CMS_RE_DTE_NO_FLOOR	INT4	10			CMS_RE_UNITS
NO_GARAGES	No of Garages in Real Estate Object	CMS_RE_DTE_NO_GAR	INT4	10			CMS_RE_UNITS
NO_GARAGES_REN	No of Garages Rented in Real Estate Object	CMS_RE_DTE_NO_GAR_REN	INT4	10			CMS_RE_UNITS
NO_PARK_UNIT	Number of Parking Units	CMS_RE_DTE_NO_PARK_UNIT	INT4	10			CMS_RE_UNITS
NO_PARK_UNIT_REN	Number of Parking Units Rented	CMS_RE_DTE_NO_PARK_UNIT_REN	INT4	10			CMS_RE_UNITS
NO_PARK_UG	Number of Underground Parking Units	CMS_RE_DTE_NO_PARK_UNIT_UG	INT4	10			CMS_RE_UNITS
NO_PARK_UG_REN	Number of Rented Underground Parking Units	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	INT4	10			CMS_RE_UNITS
NO_CUR_UNITS	No of current units in real estate object	CMS_RE_DTE_NO_CUR_UNIT	INT4	10			CMS_RE_UNITS
NO_CUR_UNITS_REN	No of Current Units Rented in Real Estate Object	CMS_RE_DTE_NO_CUR_UNIT_REN	INT4	10			CMS_RE_UNITS
NO_OLD_UNITS	No of old units in real estate object	CMS_RE_DTE_NO_OLD_UNIT	INT4	10			CMS_RE_UNITS
NO_OLD_UNITS_REN	No of Old Units Rented in Real Estate Object	CMS_RE_DTE_NO_OLD_UNIT_REN	INT4	10			CMS_RE_UNITS
NO_NEW_UNITS	No of new units in real estate object	CMS_RE_DTE_NO_NEW_UNIT	INT4	10			CMS_RE_UNITS
NO_NEW_UNITS_REN	No of New units Rented in Real Estate Object	CMS_RE_DTE_NO_NEW_UNIT_REN	INT4	10			CMS_RE_UNITS
NO_ACCESS_STR	No of Access Structures	CMS_RE_DTE_NO_ACCESS_STR	INT4	10			CMS_RE_UNITS
NO_SALE_LEVEL	No of Sale levels in commercial building	CMS_RE_DTE_NO_SALE_LEVEL	INT4	10			CMS_RE_UNITS
NO_OF_ROOMS	No of rooms in the hotel/clinic	CMS_RE_DTE_NO_ROOMS	INT4	10			CMS_RE_UNITS
NO_OF_BEDS	No of beds in the clinic/nursing home	CMS_RE_DTE_NO_BEDS	INT4	10			CMS_RE_UNITS
OCCUPANCY_PCT	Occupancy specified in Percentage Terms	CMS_RE_DTE_OCCY_PCT	DEC	10(6)			CMS_RE_PCT
TURNOVER_AMT	Total Amount of Turnover	CMS_RE_DTE_TURNOVER_AMOUNT	CURR	17(2)			CMS_RE_AMOUNT
TURNOVER_CURR	Currency	CMS_RE_DTE_TURNOVER_CURR	CUKY	5			WAERS
RENTAL_AGMT_TYP	Rental Agreement Type	CMS_RE_DTE_ATT_ID_TY_REO014	CHAR	6			CMS_ATT_ID_TYP
COMM_ENV_DESC	Description of the commercial environment	CMS_RE_DTE_COMM_ENV_DESC	CHAR	30			CMS_RE_DESC
ACCESS_STR_DESC	Description of the Access Structures	CMS_RE_DTE_ACCESS_STR_DESC	CHAR	30			CMS_RE_DESC
BLD_SECTION_DESC	Building Section	CMS_RE_DTE_ATT_ID_TY_REO015	CHAR	6			CMS_ATT_ID_TYP
PRICE_CATEGORY	Price Category	CMS_RE_DTE_ATT_ID_TY_REO013	CHAR	6			CMS_ATT_ID_TYP
AVG_PRICE	Average Price per Day	CMS_RE_DTE_AVG_PRICE	CURR	17(2)			CMS_RE_AMOUNT
AVG_PRICE_CURR	Average Price Currency	CMS_RE_DTE_AVG_PRICE_CURR	CUKY	5			WAERS
LAST_REPORT_DATE	Date of Last Constuction Report	CMS_RE_DTE_LAST_CONST_REP_DATE	DATS	8			CMS_RE_DATE
BLD_PROGRESS_AMT	Amount Disbursed for Construction based on Building Progress	CMS_RE_DTE_AMT_BLD_PROGRESS	CURR	17(2)			CMS_RE_AMOUNT
BLD_AMT_CURR	Building Progress Amount Curreny	CMS_RE_DTE_BLD_PROGRESS_CURR	CUKY	5			WAERS
PCT_COMPLETED	Degree of Completion of Construction	CMS_RE_DTE_DEGREE_COMPLETE	DEC	10(6)			CMS_RE_PCT
INSURANCE_TYPE	Insurance Type	CMS_RE_DTE_ATT_ID_TY_REO011	CHAR	6			CMS_ATT_ID_TYP
INSURANCE_AMT	Insurance Amount	CMS_RE_DTE_INSURANCE_AMOUNT	CURR	17(2)			CMS_RE_AMOUNT
INSURANCE_CURR	Insurance Currency	CMS_RE_DTE_INSURANCE_CURR	CUKY	5			WAERS
INS_VALIDITY	Date until which the Insurance Stands Valid	CMS_RE_DTE_INS_VALID_TILL	DATS	8			CMS_RE_DATE
RATIONING_COST	Residential Rationing Cost	CMS_RE_DTE_RAT_COST_AMT	CURR	17(2)			CMS_RE_AMOUNT
RTN_CST_PCT	Percentage of Residential Rationing Cost	CMS_RE_DTE_RAN_COST_PCT	DEC	10(6)			CMS_RE_PCT
EXT_LAYOUT_COST	External Layout Cost	CMS_RE_DTE_EXT_LAYOUT_COST	CURR	17(2)			CMS_RE_AMOUNT
EXT_LAY_CST_PCT	External Layout Cost as Percentage of Total Cost	CMS_RE_DTE_EXT_LAYOUT_COST_PCT	DEC	10(6)			CMS_RE_PCT
RTN_CST_CURR	Rationing cost currency	CMS_RE_DTE_RTN_CST_CURR	CUKY	5			WAERS
EXT_RTN_CST_CURR	External Layout cost currency	CMS_RE_DTE_EXT_LAYOUT_CST_CURR	CUKY	5			WAERS
RTN_CST_COM	Commercial Rationing Cost	CMS_RE_DTE_RAT_COST_AMT_COM	CURR	17(2)			CMS_RE_AMOUNT
RTN_CST_COM_CURR	Rationing cost currency	CMS_RE_DTE_RTN_CST_CURR_COM	CUKY	5			WAERS
RTN_CST_COM_PCT	Percentage of Commercial Rationing Cost	CMS_RE_DTE_RAN_COST_PCT_COM	DEC	10(6)			CMS_RE_PCT
GROSS_COLD_RENT	Gross Cold Rent	CMS_RE_DTE_YRLY_GROSS_COLD_REN	CURR	17(2)			CMS_RE_AMOUNT
GROSS_RENT_CURR	Gross Cold Rent Currency	CMS_RE_DTE_GROSS_RENT_CURR	CUKY	5			WAERS
NET_COLD_RENT	Net Cold Rent	CMS_RE_DTE_YRLY_NET_COLD_REN	CURR	17(2)			CMS_RE_AMOUNT
NET_RENT_CURR	Net Cold Rent Currency	CMS_RE_DTE_NET_RENT_CURR	CUKY	5			WAERS
NO_OF_YEARS_COM	No of years since Last Valuation of Commercial Real Estate	CMS_RE_DTE_VAL_NO_YEARS_COM	INT1	3			CMS_RE_INT1
INT_RATE_COM	Interest rate (Com)	CMS_RE_DTE_VAL_INT_RATE_COM	DEC	10(6)			CMS_RE_PCT
NO_OF_YEARS	No. of Years since Real Estate was last Valued	CMS_RE_DTE_VALUATION_NO_YEARS	INT1	3			CMS_RE_INT1
INT_RATE	Interest rate used in Valuation of Residential Real Estate	CMS_RE_DTE_VALUATION_INT_RATE	DEC	10(6)			CMS_RE_PCT
RENT_PLANNED_COM	Planned Rent Amount	CMS_RE_DTE_RENT_AMOUNT	CURR	17(2)			CMS_RE_AMOUNT
RENT_ACTUAL_COM	Actual Rent Amount	CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	17(2)			CMS_RE_AMOUNT
PLAN_CURR_COM	Planned Rent Currency	CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	5			WAERS
ACT_CURR_COM	Actual Rent Currency	CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	5			WAERS
BASE_PERIOD_COM	Base period for the rent	CMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEAS_COM	Base Measure	CMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
COM_RENT_IND	Indicator for Rent Type	CMS_RE_DTE_COM_IND	CHAR	1			CMS_RE_RENT_FLG
COMP_RENT_COM	Comparative Rent (Commercial)	CMS_RE_DTE_RENT_LEVEL_COM	CURR	17(2)			CMS_RE_AMOUNT
COMP_REN_COM_CUR	Comparative Rent Currency (Commercial)	CMS_RE_DTE_COMP_RENT_COM_CURR	CUKY	5			WAERS
PLAN_RENT_LAND	Planned Rent Amount	CMS_RE_DTE_RENT_AMOUNT	CURR	17(2)			CMS_RE_AMOUNT
ACTUAL_RENT_LAND	Actual Rent Amount	CMS_RE_DTE_RENT_AMOUNT_ACT	CURR	17(2)			CMS_RE_AMOUNT
PLAN_RENT_CURR	Planned Rent Currency	CMS_RE_DTE_RENT_PLANNED_CURR	CUKY	5			WAERS
ACTUAL_RENT_CURR	Actual Rent Currency	CMS_RE_DTE_RENT_ACTUAL_CURR	CUKY	5			WAERS
BASE_PERIOD_LAND	Base period for the rent	CMS_RE_DTE_BASE_PERIOD	CHAR	1			CMS_RE_BASE_PERIOD
BASE_MEAS_LAND	Base Measure	CMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
DEPR	Depriciation	CMS_RE_DTE_DEPR	DEC	10(6)			CMS_RE_PCT
LAND_COST	Land Cost Amount	CMS_RE_DTE_LAND_COST	CURR	17(2)			CMS_RE_AMOUNT
LAND_COST_CURR	Land Cost Currency	CMS_RE_DTE_LAND_COST_CURR	CUKY	5			WAERS
DEV_COST	Development Cost Amount	CMS_RE_DTE_DEV_COST	CURR	17(2)			CMS_RE_AMOUNT
DEV_COST_CURR	Dev Cost Currency	CMS_RE_DTE_DEV_COST_CURR	CUKY	5			WAERS
LAND_CST_BASE	Base measure of Land	CMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
DEV_CST_BASE	Base measure of Land	CMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
ADD_LAND_CST	Additional Land Cost Amount	CMS_RE_DTE_ADD_LAND_COST	CURR	17(2)			CMS_RE_AMOUNT
ADD_CST_CURR	Additional Land Cost Currency	CMS_RE_DTE_ADD_LAND_COST_CURR	CUKY	5			WAERS
ADD_CST_BASE	Base measure of Land	CMS_RE_DTE_BASE_MEAS_LAND	CHAR	1			CMS_RE_BASE_MEAS_LAND
CONST_COST	Construction Cost	CMS_RE_DTE_CONS_COST	CURR	17(2)			CMS_RE_AMOUNT
CONST_COST_CURR	Construction cost currency	CMS_RE_DTE_CONS_COST_CURR	CUKY	5			WAERS
BASE_MEAS	Base Measure	CMS_RE_DTE_BASE_MEAS	CHAR	1			CMS_RE_BASE_MEAS
GRS_PROFIT	Yearly Gross Profit	CMS_RE_DTE_GRS_PROFIT	CURR	17(2)			CMS_RE_AMOUNT
GRS_PROFIT_CURR	Yearly Gross Profit Currency	CMS_RE_DTE_GRS_PROFIT_CURR	CUKY	5			WAERS
AST_GUID	GUID for Table CMS_AST	CMS_DTE_AST_GUID	RAW	16			SYSUUID
AST_TYP	Asset Type	CMS_DTE_AST_TYP	CHAR	6			CMS_AST_TYP	CMS_AST_TYP	CMS_AST_TYP
PARENT_GUID	Asset Guid as a parent GUID for a sub-asset	CMS_DTE_SAS_PAR_GUID	RAW	16			SYSUUID
RISK_CODE	Risk Code	CMS_RE_DTE_RISK_CODE	CHAR	6			CMS_RISK_CODE
SFTY_IND	Indicates that the asset has a default sfty discount or not	CMS_RE_DTE_IND_SFTY_DISC	CHAR	2			CMS_IND_SFTY
SFTY_DSCNT	Safety discount	CMS_RE_DTE_SAFETY_DSCNT	DEC	10(6)			CMS_SFTY_PCT
SFTY_AMOUNT	Safety discount as an amount	CMS_RE_DTE_SAFETY_AMT	CURR	17(2)			CMS_AMOUNT
SFTY_AMT_CURR	Currency of the Safety discount amount	CMS_RE_DTE_SAFETY_AMT_CURR	CUKY	5			WAERS
VALUATION_TYP	Type of Check conducted on the object	CMS_RE_DTE_IND_VALN_TYP	CHAR	2			CMS_VALN_TYP
UNIT_VALN_FREQ	Indicator : Valuation Period	CMS_RE_DTE_IND_FREQUENCY	CHAR	2			CMS_RE_IND_FREQUENCY
PERIOD_VALN_FREQ	Period of revaluation for a real estate	CMS_RE_DTE_VALN_FREQ_PERIOD	NUMC	4			CMS_RE_VALN_FREQ_PERIOD
PAST_VALUED_DATE	Most Recent Date on which the Real Estate was last Valued	CMS_RE_DTE_VALN_DATE	DATS	8			CMS_DATE
START_DATE	Revaluation Start date	CMS_RE_DTE_START_DATE	DATS	8			CMS_DATE
END_DATE	End date for Revaluation of the Real Estate	CMS_RE_DTE_END_DATE	DATS	8			CMS_DATE
LENDING_RATE_IND	Indicates that the asset has a default lending rate or not	CMS_RE_DTE_IND_LND_RTE	CHAR	2			CMS_IND_LRTE
LENDING_RATE1	Lending rate 1	CMS_RE_DTE_LRTE_PCT1	DEC	10(6)			CMS_PCT
LENDING_RATE2	Lending rate 2	CMS_RE_DTE_LRTE_PCT2	DEC	10(6)			CMS_PCT
LENDING_RATE3	Lending rate 3	CMS_RE_DTE_LRTE_PCT3	DEC	10(6)			CMS_PCT
LENDING_RATE4	Lending rate 4	CMS_RE_DTE_LRTE_PCT4	DEC	10(6)			CMS_PCT
LENDING_RATE5	Lending rate 5	CMS_RE_DTE_LRTE_PCT5	DEC	10(6)			CMS_PCT
ACC_NUMBER_LIQ	Account number for liquidation proceeds	CMS_DTE_LIQ_ACC_NUMBER	CHAR	35			BANKN35
BANK_CNTRY_LIQ	Bank country key	CMS_DTE_LIQ_BNK_CTRY_KY	CHAR	3			LAND1
BANK_KEY_LIQ	Bank Key	CMS_DTE_LIQ_BNK_KEY	CHAR	15			BANKK	BNK
BANK_CTRLKEY_LIQ	Bank Control Key	BKONT	CHAR	2			BKONT
UNIT_VERF_FREQ	Indicator: Units of time for verification of an asset	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CHAR	2			CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQ	Statement Period for an Asset	CMS_DTE_AST_VERF_FREQ_PERIOD	NUMC	4			CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATE	Last Verification Date	CMS_DTE_AST_VERF_DATE	DATS	8			CMS_DATE
LIQD_TYP	Liquidation Type	CMS_DTE_LIQD_TYP	CHAR	6			CMS_TYP		CMS_AST_LIQTYP
LIQD_REASON	Liquidation Reason	CMS_DTE_ATT_ID_TY_AST004	CHAR	6			CMS_ATT_ID_TYP
LIQD_DATE	Date on which the Collateral was Liquidated	CMS_DTE_LIQD_DATE	DATS	8			CMS_DATE
LIQD_AMT	Returns from the Liquidation of Collateral	CMS_DTE_LIQD_VALUE	CURR	17(2)			CMS_AMOUNT
LIQD_CURR	Currency of Liquidation Value	CMS_DTE_LIQD_CURR	CUKY	5			WAERS
EXP_PRCD_AMNT	Expected Proceed Amount	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CURR	17(2)			CMS_AMOUNT
EXP_PRCD_CURR	Currency: Expected Proceed	CMS_DTE_LIQ_EXP_PRCD_CURR	CUKY	5			WAERS
EXP_ACC_DATE	Expected accrual date	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	DATS	8			CMS_DATE
NOM_VALUE	Nominal Value of the Asset	CMS_DTE_AST_NOMINAL_VALUE	CURR	17(2)			CMS_AMOUNT
NOM_VALUE_CURR	Currency of Nominal value	CMS_DTE_AST_NOMINAL_VALUE_CURR	CUKY	5			WAERS
AST_VALUE	Final Asset Value	CMS_DTE_AST_VALUE	CURR	17(2)			CMS_AMOUNT
AST_VALUE_CURR	Currency of the Final Asset Value	CMS_DTE_AST_VALUE_CURR	CUKY	5			WAERS
QUANTITY	Quantity	CMS_DTE_QTY	QUAN	13(3)			CMS_QTY
UNIT_OF_MEASURE	Unit of Measure of Quantity	CMS_DTE_UNIT	UNIT	3		CUNIT	MEINS
REC_AT	Asset Value Recording Timestamp	CMS_DTE_REC_AT	DEC	15			TZNTSTMPS
PUR_PRICE	Purchase Price of the Asset	CMS_DTE_AST_PURCHASE_PRICE	CURR	17(2)			CMS_AMOUNT
PUR_PRICE_CURR	Currency of Purchase Price	CMS_DTE_AST_PUR_PRICE_CURR	CUKY	5			WAERS
PUR_DATE	Date of Purchase	CMS_DTE_AST_PUR_PRICE_DATE	DATS	8			CMS_DATE
ORG_UNIT1	Organizational Unit 1	CMS_DTE_ORG_UNIT1	CHAR	10			CMS_ORG_UNIT
ORG_UNIT2	Organizational Unit 2	CMS_DTE_ORG_UNIT2	CHAR	10			CMS_ORG_UNIT
ORG_UNIT3	Organizational Unit 3	CMS_DTE_ORG_UNIT3	CHAR	10			CMS_ORG_UNIT
ORG_UNIT4	Organizational Unit 4	CMS_DTE_ORG_UNIT4	CHAR	10			CMS_ORG_UNIT
ORG_UNIT5	Organizational Unit 5	CMS_DTE_ORG_UNIT5	CHAR	10			CMS_ORG_UNIT
WA_RE_ADDR				0
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			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ADDRNUMBER	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
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		ALPHA	CITY_CODE
CITYP_CODE	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
CITYH_CODE	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_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		ALPHA	CITY_CODE
PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	AD_POBXREG	CHAR	3			REGIO
PO_BOX_CTY	PO box country	AD_POBXCTY	CHAR	3			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			ZONE
STREET	Street	AD_STREET	CHAR	60			TEXT60		CLSTRTNAME
DONT_USE_S	Street Address Undeliverable Flag	AD_NO_USES	CHAR	4			AD_NO_USE
STREETCODE	Street Number for City/Street File	AD_STRNUM	CHAR	12		ALPHA	STRT_CODE
STREETABBR	(Not Supported) Abbreviation of Street Name	AD_STRABBR	CHAR	2			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			LAND1	LND
LANGU	Language Key	SPRAS	LANG	1		ISOLA	SPRAS	SPR	H_T002
REGION	STATE (State, Province, County)	REGIO	CHAR	3			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			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
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		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			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		ALPHA	CNTY_CODE
COUNTY	County	AD_COUNTY	CHAR	40			TEXT40		CLTCNTYNAME
TOWNSHIP_CODE	Township code for Township	AD_TWSHPNUM	CHAR	8		ALPHA	TWSHP_CODE
TOWNSHIP	Township	AD_TOWNSHIP	CHAR	40			TEXT40		CLTWSHPNAME
DEFLT_COMM	Communication Method (Key) (Business Address Services)	AD_COMM	CHAR	3			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			AD_GROUP
WA_RE_HDR				0
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			CMS_RE_TYP	CMS_RE_OBJECT_TYPE
ADDR_ID	Address ID	CMS_RE_DTE_ADDR_ID	CHAR	10		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
OBJ_TYP_NAME	Name in a specified language	CMS_RE_DTE_NAME	CHAR	40			CMS_RE_NAME
OBJECT_AREA_UOM	Unit of Measure for Area	CMS_RE_DTE_AREA_UOM	UNIT	3		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		CUNIT	MEINS	CMS_VOL_UOM	CMS_ELM_VOLUME_UOM
OBJECT_CURR	Object Currency	CMS_RE_DTE_OBJ_CURR	CUKY	5			WAERS	CMS_OBJ_CURR
MACRO_LOC_TYPE	Macro Location	CMS_RE_DTE_ATT_ID_TY_REO002	CHAR	6			CMS_ATT_ID_TYP
MICRO_LOC_TYPE	Micro Location	CMS_RE_DTE_ATT_ID_TY_REO003	CHAR	6			CMS_ATT_ID_TYP
TRAN_CONN_TYPE	Transport Connection	CMS_RE_DTE_ATT_ID_TY_REO004	CHAR	6			CMS_ATT_ID_TYP
ENVIRON_STATUS	Enviromental Status	CMS_RE_DTE_ATT_ID_TY_REO005	CHAR	6			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			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
T_USR_STAT				0
T_RE_NOTES				0
T_SYS_STAT				0
T_RE_INSDOC				0
T_RE_INSBP				0
T_RE_INS				0
T_PRT_CST				0
T_PRT_SEC2				0
T_PRT_SECB				0
T_PRT_LR				0
T_PRT_VAL				0
T_PRT_DOC				0
T_PRT_BP				0
T_PRT_ACS				0
T_OBJ_PRT				0
T_MAIN_CST				0
T_MAIN_SEC2				0
T_MAIN_SECB				0
T_MAIN_LR				0
T_MAIN_VAL				0
T_MAINOBJDOC				0
T_MAINOBJ_BP				0
T_RE_ACS				0

Key field

Non-key field

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

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

How to access SAP table CMS_STR_COR_RE_REQ

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