SAP ABAP Table CMS_STR_COR_RE_REQ (Real estate)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_COR (Package) Correspondence serivce for CMS

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_COR_RE_REQ	Table Relationship Diagram
Short Description	Real estate

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	WA_RE_GEN	☐	DFKKCOH		STRU	0	0
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
3	COTYP	☐	COTYP_KK	COTYP_KK	CHAR	4	0	Correspondence Type
4	COKEY	☐	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
5	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
6	CDATE	☐	COCDT_KK	SYDATS	DATS	8	0	Created On
7	CTIME	☐	COCTM_KK	SYTIME	TIMS	6	0	Time of Creation (to the Second)
8	GPART	☐	CREC_GP_KK	BU_PARTNER	CHAR	10	0	Correspondence Recipient
9	GPART_GUID	☐	CREC_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Correspondence Recipient (GUID)
10	GPART_ADR_KIND	☐	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
11	ORG_GPART	☐	CREC_ORG_GP_KK	BU_PARTNER	CHAR	10	0	Original Correspondence Recipient
12	ORG_GPART_GUID	☐	CREC_ORG_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Original Correspondence Recipient (GUID)
13	ADD_GPART	☐	CREC_GP_ADD_KK	BU_PARTNER	CHAR	10	0	Additional Business Partner for Correspondence Recipient
14	ADD_GPART_GUID	☐	CREC_GP_ADD_GUID_KK	SYSUUID_C	CHAR	32	0	Addit. Business Partner for Correspondence Recipient GUID
15	ADD_GPART_CAT	☐	CREC_GP_ADD_CAT_KK	CORR_CREC_ADD_CAT_KK	CHAR	1	0	Type of Additional Correspondence Recipient
16	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
17	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
18	ADR_VALID_ON	☐	CREC_AD_VALID_ON_KK	TZNTSTMPS	DEC	15	0	Address of Correspondence Recipient Valid On
19	ADRNR	☐	CREC_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Recipient
20	ADR_GUID	☐	CREC_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Recipient
21	ADRNR_INDEP_COMM	☐	CREC_AD_INDEP_COMM_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Address-Independent Communication
22	AGPART	☐	CSEN_GP_KK	BU_PARTNER	CHAR	10	0	Sending Business Partner
23	AGPART_GUID	☐	CSEN_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Sender (GUID)
24	AGPART_ADR_KIND	☐	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
25	AADRNR	☐	CSEN_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Sender
26	AADR_GUID	☐	CSEN_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Sender
27	FORMKEY	☐	FORMKEY	FORMKEY	CHAR	30	0	Application form
28	FORMKEY_RDI	☐	FORMKEY	FORMKEY	CHAR	30	0	Application form
29	ENTID1	☐	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
30	DATA1	☐	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
31	ENTID2	☐	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
32	DATA2	☐	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
33	ENTID3	☐	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
34	DATA3	☐	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
35	ENTID4	☐	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
36	DATA4	☐	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
37	CSORT	☐	CSORT_KK	CORR_TXT50	CHAR	50	0	Correspondence Sort Field
38	XCODT	☐	XCODT_KK	XFELD	CHAR	1	0	Data Part Is Used
39	XCODT_CLUST	☐	XCODT_CLUST_KK	XFELD	CHAR	1	0	Cluster Data Part is Used
40	LAUFD	☐	CORR_LAUFD_KK	DATUM	DATS	8	0	Date ID for Creation Run
41	LAUFI	☐	CORR_LAUFI_KK	CORR_LAUFI_KK	CHAR	6	0	Additional ID Characteristic for Creation Run
42	XTEST	☐	XTEST_KK	XFELD	CHAR	1	0	Correspondence is Result of Test
43	COPRI	☐	COPRI_KK	SYDATS	DATS	8	0	Print Date
44	COIDT	☐	COIDT_KK	SYDATS	DATS	8	0	Date of Issue
45	COITM	☐	COITM_KK	SYTIME	TIMS	6	0	Issue Time to the Second
46	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key
47	SALWA	☐	CORR_BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency
48	SALBE	☐	CORR_BETRH_KK	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
49	SENDCONTROL	☐	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
50	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
51	APERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
52	BUKRS	☐	CORR_BUKRS	CORR_BUKRS	CHAR	4	0	Company Code in Correspondence
53	CORR_ROLE	☐	CORR_ROLE_KK	CORR_ROLE_KK	CHAR	4	0	Correspondence Roles
54	COPRI_LAUFD	☐	COPRI_LAUFD_KK	DATUM	DATS	8	0	Date ID for Print Run
55	COPRI_LAUFI	☐	COPRI_LAUFID_KK	COPRI_LAUFID_KK	CHAR	6	0	ID Characteristic for Run
56	PROCESS_ID_	☐	CORR_PROCESS_ID_KK		CHAR	36	0	Business Process ID
57	NO_DOCPARTS	☐	CORR_NO_DOCPARTS_KK		NUMC	4	0	Number of Document Parts
58	DOCPART_ROLE	☐	CORR_DOCPART_ROLE_KK	CORR_DOCPART_ROLE_KK	CHAR	1	0	Document Part Role
59	XTRIAL	☐	XTRIAL_KK	XFELD	CHAR	1	0	Correspondence Request is Test
60	XREPRINT	☐	XREPRINT_KK	XFELD	CHAR	1	0	Recreate Correspondence
61	.INCLUDE	☐				0	0
62	SUBAP	☐	CORR_SUBAP_KK	CORR_SUBAP_KK	CHAR	1	0	Subapplication Indicator in Correspondence
63	XDELETE	☐	X_CORR_DELETE_KK	XFELD	CHAR	1	0	Correspondence Is Logically Deleted
64	PRINT_MODE	☐	PRINT_MODE_KK	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
65	X_NO_ARC	☐	X_NO_ARC_KK	XFELD	CHAR	1	0	SAP ArchiveLink Object ID Part Is Not Used
66	X_DOCPART_LIST	☐	X_DOCPART_LIST_KK	XFELD	CHAR	1	0	Document Part List Is Used
67	.INCLU--AP	☐				0	0	CMS appends for DFKKCOH
68	.INCLU-CMS	☐				0	0	CMS include for DFKKCOH
69	OBJECT_IDCMS	☐	CMS_DTE_OBJECT_ID	SYSUUID	RAW	16	0	Object Identification Number
70	FLG_ORIGINALCMS	☐	CMS_DTE_FLG_ORIG	CMS_FLG	CHAR	1	0	Flag to indicate if the document is original or duplicate
71	SENDCONTROLCMS	☐	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
72	.INCLU--AP	☐				0	0	Loans Append for DFKKCOH
73	.INCLU-FVD	☐				0	0	Loans Include for DFKKCOH
74	PRODUCTTYPEFVD	☐	VVSART	VVSART	CHAR	3	0	Product Type
75	BP_ROLEFVD	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role
76	BP_ROLETYPEFVD	☐	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type
77	SOBJECTFVD	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
78	CORR_ACTIVITYFVD	☐	KORRVORF	KORRVORF	NUMC	4	0	Correspondence activity
79	REFERENCEDATEFVD	☐	TB_CORR_REFERENCE_DATE	DATUM	DATS	8	0	Reference Date for Creating Correspondence
80	WA_RECEIVER	☐	CMS_STR_BPID		STRU	0	0
81	BU_PARTNERID	☐	CMS_DTE_BPID	CMS_BPID	CHAR	32	0	Business Partner Identification Number
82	BP_DESCRIPTION	☐	CMS_DTE_BP_ADDR_DESC	CMS_BP_ADDR_DESC	CHAR	60	0	Address description of Business Partner
83	WA_SENDER	☐	P1028		STRU	0	0
84	.INCLUDE	☐				0	0	Key Structure for Infotype Structures PNNNN
85	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
86	PLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version
87	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
88	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
89	INFTY	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype
90	SUBTY	☐	SUBTYP	SUBTYP	CHAR	4	0	Subtype
91	ISTAT	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
92	PRIOX	☐	PRIOX	CHAR2	CHAR	2	0	Priority
93	BEGDA	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
94	ENDDA	☐	ENDDATUM	DATUM	DATS	8	0	End Date
95	VARYF	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
96	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
97	.INCLUDE	☐				0	0	Infotype Administration Data
98	AEDTM	☐	AEDTM	DATUM	DATS	8	0	Changed on
99	UNAME	☐	USRNAME	CHAR12	CHAR	12	0	User Name
100	REASN	☐	REASN	CHAR2	CHAR	2	0	Reason
101	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
102	ITXNR	☐	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
103	.INCLUDE	☐				0	0	Infotype 1028 Fields
104	CNAME	☐	CNAME	TEXT25	CHAR	25	0	Address Supplement (c/o)
105	STRAS	☐	PD_STRAS	TEXT30	CHAR	30	0	House Number and Street
106	ORT01	☐	KORT	TEXT40	CHAR	40	0	City
107	PSTLZ	☐	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
108	LAND1	☐	KLAND	LAND1	CHAR	3	0	Country
109	TELNR	☐	TELENR	CHAR25	CHAR	25	0	Telephone Number
110	FAXNR	☐	FAXNR	CHAR25	CHAR	25	0	Fax Number
111	ENTKM	☐	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
112	BUILD	☐	BUILD	BUILD	CHAR	8	0	Building
113	ROOM1	☐	ROOM1	CHAR8	CHAR	8	0	Physical Room Number
114	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
115	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
116	STRS2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
117	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
118	.INCLUDE	☐				0	0
119	WA_RE_OBJ_DET	☐	CMS_RE_STR_OBJ_MAIN_MAP_GET		STRU	0	0
120	.INCLUDE	☐				0	0	Structure for Object GUID
121	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
122	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
123	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
124	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID
125	.INCLUDE	☐				0	0	Primary key for Object part
126	OBJ_PRT_GUID	☐	CMS_RE_DTE_OBJ_PRT_GUID	SYSUUID	RAW	16	0	GUID for Object part
127	.INCLUDE	☐				0	0	Structure for Basic Part Details
128	BLD_PART_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO006	CMS_ATT_ID_TYP	CHAR	6	0	Building Part Type
129	PART_COND	☐	CMS_RE_DTE_ATT_ID_TY_REO001	CMS_ATT_ID_TYP	CHAR	6	0	Object condition
130	MAIN_USAGE	☐	CMS_RE_DTE_USG_TYP	CMS_RE_TYP	CHAR	6	0	Usage Type
131	ADD_USAGE_1	☐	CMS_RE_DTE_ADD1_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 1
132	ADD_USAGE_2	☐	CMS_RE_DTE_ADD2_USG_TYP	CMS_RE_TYP	CHAR	6	0	Additional Usage 2
133	BLD_METHOD_ROOF	☐	CMS_RE_DTE_ATT_ID_TY_REO007	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Roof
134	BLD_METHOD_BODY	☐	CMS_RE_DTE_ATT_ID_TY_REO008	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Body
135	BLD_METD_CELLAR	☐	CMS_RE_DTE_ATT_ID_TY_REO009	CMS_ATT_ID_TYP	CHAR	6	0	Building method - Cellar
136	UTILIZATION	☐	CMS_RE_DTE_PRT_UTILIZATION	CMS_RE_UTIL	CHAR	6	0	Utilization of the Object
137	PART_DESC	☐	CMS_RE_DTE_SPC_DESC	CMS_RE_DESC	CHAR	30	0	Description of Building Part
138	COMM_USAGE_PCT	☐	CMS_RE_DTE_COM_USE_PCT	CMS_RE_PCT	DEC	10	6	Commercial Usage as a Percentage of Total Usage
139	OTHER_USG_FLG	☐	CMS_RE_DTE_OTH_USE_FLG	CMS_RE_OTH_USG_FLG	CHAR	1	0	Indicates if Usages in addition to Main Usage are Possible
140	REF_OBJ_PRT_GUID	☐	CMS_RE_DTE_REF_OBJ_PRT_GUID	SYSUUID	RAW	16	0	Reference Object Part GUID
141	IS_SUB_AST_CREA	☐	CMS_RE_DTE_CREATE_SUB_AST_FLG	CMS_RE_FLG	CHAR	1	0	Indicates whether a Sub-asset is created for Building Part
142	.INCLUDE	☐				0	0	Structure for Part Size Details
143	USEFUL_AREA	☐	CMS_RE_DTE_AREA_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Area
144	USBL_AREA_UOM	☐	CMS_RE_DTE_USBL_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Area
145	USEFUL_AREA_REN	☐	CMS_RE_DTE_AREA_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Rented Usable Area
146	USBL_AR_REN_UOM	☐	CMS_RE_DTE_USBL_AREA_REN_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Rented Area
147	USEFUL_VOL	☐	CMS_RE_DTE_VOL_USEFUL	CMS_RE_SIZE	QUAN	13	3	Usable Volume of Real Estate Building Parts
148	USBL_VOL_UOM	☐	CMS_RE_DTE_USBL_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Usable Volume of Real Estate
149	USEFUL_VOL_REN	☐	CMS_RE_DTE_VOL_USEFUL_REN	CMS_RE_SIZE	QUAN	13	3	Usable Volume of the Rented Portions of Real Estate
150	USBL_VL_REN_UOM	☐	CMS_RE_DTE_USBL_VOL_REN_UOM	MEINS	UNIT	3	0	Unit of measure for usable volume of Rented Parts
151	RESIDENTIAL_AREA	☐	CMS_RE_DTE_AREA_RESIDENTIAL	CMS_RE_SIZE	QUAN	13	3	Residential Area
152	RES_AR_UOM	☐	CMS_RE_DTE_RES_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Residential Area
153	SECONDARY_AREA	☐	CMS_RE_DTE_AREA_SECONDARY	CMS_RE_SIZE	QUAN	13	3	Secondary Area
154	SEC_AREA_UOM	☐	CMS_RE_DTE_SEC_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Secondary Area
155	OTHER_AREA	☐	CMS_RE_DTE_AREA_OTHER	CMS_RE_SIZE	QUAN	13	3	Other Area
156	OTH_AREA_UOM	☐	CMS_RE_DTE_OTH_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Other Area
157	.INCLUDE	☐				0	0	Structure for Part Unit Details
158	NO_PRT_UNIT	☐	CMS_RE_DTE_NO_PRT_UNIT	CMS_RE_UNITS	INT4	10	0	Number of building part units
159	NO_PRT_UNIT_REN	☐	CMS_RE_DTE_NO_PRT_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of building part units rented
160	.INCLUDE	☐				0	0	Structure for dates
161	CONS_START_DATE	☐	CMS_RE_DTE_OBJ_CONS_ST_DATE	CMS_RE_DATE	DATS	8	0	Start Date of Construction
162	PERMSN_APPL_DATE	☐	CMS_RE_DTE_OBJ_PMSN_APPL_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion applied date
163	PERMSN_OBTD_DATE	☐	CMS_RE_DTE_OBJ_PMSN_OBTD_DATE	CMS_RE_DATE	DATS	8	0	Building Permssion obtained date
164	OCCY_DATE	☐	CMS_RE_DTE_OBJ_OCCY_DATE	CMS_RE_DATE	DATS	8	0	Occupancy Date
165	COMP_DATE	☐	CMS_RE_DTE_OBJ_COMP_DATE	CMS_RE_DATE	DATS	8	0	Completion Date
166	FINAL_INSP_DATE	☐	CMS_RE_DTE_OBJ_FINAL_INSP_DATE	CMS_RE_DATE	DATS	8	0	Date of Final Inspection
167	.INCLUDE	☐				0	0
168	.INCLUDE	☐				0	0	Structure for Part Rent Details
169	RENT_AMT_PLANNED	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
170	RENT_AMT_ACTUAL	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
171	RENT_PLAN_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
172	RENT_ACT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
173	BASE_PERIOD	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
174	BASE_MEASURE	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
175	VACANT_POSN_PCT	☐	CMS_RE_DTE_VACANT_POS_PCT	CMS_RE_PCT	DEC	10	6	Ratio of Real Estate not rented to Total Real Estate Value
176	RES_RENT_IND	☐	CMS_RE_DTE_RES_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Net or Gross Rent
177	COMP_RENT_RES	☐	CMS_RE_DTE_RENT_LEVEL	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Residential)
178	COM_REN_RES_CURR	☐	CMS_RE_DTE_COMP_RENT_RES_CURR	WAERS	CUKY	5	0	Comparative Rent Currency - Residential
179	.INCLUDE	☐				0	0	Structure for Land Area & UOM
180	LAND_AREA	☐	CMS_RE_DTE_LAND_AREA	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate
181	LAND_AREA_UOM	☐	CMS_RE_DTE_LAND_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure of Land Area
182	LAND_AREA_REN	☐	CMS_RE_DTE_LAND_AREA_REN	CMS_RE_SIZE	QUAN	13	3	Land Area of the Real Estate which is Rented
183	LAND_AR_REN_UOM	☐	CMS_RE_DTE_LAND_AREA_REN_UOM	MEINS	UNIT	3	0	Land area unit of measure(rented)
184	.INCLUDE	☐				0	0	Structure for General Details
185	NO_OF_UNITS	☐	CMS_RE_DTE_NO_UNIT	CMS_RE_UNITS	INT4	10	0	No of units in real estate object
186	NO_OF_FLOORS	☐	CMS_RE_DTE_NO_FLOOR	CMS_RE_UNITS	INT4	10	0	Number of Floors
187	NO_GARAGES	☐	CMS_RE_DTE_NO_GAR	CMS_RE_UNITS	INT4	10	0	No of Garages in Real Estate Object
188	NO_GARAGES_REN	☐	CMS_RE_DTE_NO_GAR_REN	CMS_RE_UNITS	INT4	10	0	No of Garages Rented in Real Estate Object
189	NO_PARK_UNIT	☐	CMS_RE_DTE_NO_PARK_UNIT	CMS_RE_UNITS	INT4	10	0	Number of Parking Units
190	NO_PARK_UNIT_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_REN	CMS_RE_UNITS	INT4	10	0	Number of Parking Units Rented
191	NO_PARK_UG	☐	CMS_RE_DTE_NO_PARK_UNIT_UG	CMS_RE_UNITS	INT4	10	0	Number of Underground Parking Units
192	NO_PARK_UG_REN	☐	CMS_RE_DTE_NO_PARK_UNIT_UG_REN	CMS_RE_UNITS	INT4	10	0	Number of Rented Underground Parking Units
193	.INCLUDE	☐				0	0	Structure for Residential Details
194	NO_CUR_UNITS	☐	CMS_RE_DTE_NO_CUR_UNIT	CMS_RE_UNITS	INT4	10	0	No of current units in real estate object
195	NO_CUR_UNITS_REN	☐	CMS_RE_DTE_NO_CUR_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Current Units Rented in Real Estate Object
196	NO_OLD_UNITS	☐	CMS_RE_DTE_NO_OLD_UNIT	CMS_RE_UNITS	INT4	10	0	No of old units in real estate object
197	NO_OLD_UNITS_REN	☐	CMS_RE_DTE_NO_OLD_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of Old Units Rented in Real Estate Object
198	NO_NEW_UNITS	☐	CMS_RE_DTE_NO_NEW_UNIT	CMS_RE_UNITS	INT4	10	0	No of new units in real estate object
199	NO_NEW_UNITS_REN	☐	CMS_RE_DTE_NO_NEW_UNIT_REN	CMS_RE_UNITS	INT4	10	0	No of New units Rented in Real Estate Object
200	.INCLUDE	☐				0	0	Structure for Number of Units in Office
201	NO_ACCESS_STR	☐	CMS_RE_DTE_NO_ACCESS_STR	CMS_RE_UNITS	INT4	10	0	No of Access Structures
202	.INCLUDE	☐				0	0	Structure for Number of Sales level in Commericial Building
203	NO_SALE_LEVEL	☐	CMS_RE_DTE_NO_SALE_LEVEL	CMS_RE_UNITS	INT4	10	0	No of Sale levels in commercial building
204	.INCLUDE	☐				0	0	Structure for Number of Rooms in the hotel/clinic
205	NO_OF_ROOMS	☐	CMS_RE_DTE_NO_ROOMS	CMS_RE_UNITS	INT4	10	0	No of rooms in the hotel/clinic
206	.INCLUDE	☐				0	0	Structure for Number of rooms in the clinic/nursing home
207	NO_OF_BEDS	☐	CMS_RE_DTE_NO_BEDS	CMS_RE_UNITS	INT4	10	0	No of beds in the clinic/nursing home
208	.INCLUDE	☐				0	0	Structure for Other Details in RE Object
209	OCCUPANCY_PCT	☐	CMS_RE_DTE_OCCY_PCT	CMS_RE_PCT	DEC	10	6	Occupancy specified in Percentage Terms
210	TURNOVER_AMT	☐	CMS_RE_DTE_TURNOVER_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Total Amount of Turnover
211	TURNOVER_CURR	☐	CMS_RE_DTE_TURNOVER_CURR	WAERS	CUKY	5	0	Currency
212	RENTAL_AGMT_TYP	☐	CMS_RE_DTE_ATT_ID_TY_REO014	CMS_ATT_ID_TYP	CHAR	6	0	Rental Agreement Type
213	.INCLUDE	☐				0	0	Structure for Commericial Details
214	COMM_ENV_DESC	☐	CMS_RE_DTE_COMM_ENV_DESC	CMS_RE_DESC	CHAR	30	0	Description of the commercial environment
215	ACCESS_STR_DESC	☐	CMS_RE_DTE_ACCESS_STR_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Access Structures
216	BLD_SECTION_DESC	☐	CMS_RE_DTE_ATT_ID_TY_REO015	CMS_ATT_ID_TYP	CHAR	6	0	Building Section
217	.INCLUDE	☐				0	0	Structure for Hotel Details
218	PRICE_CATEGORY	☐	CMS_RE_DTE_ATT_ID_TY_REO013	CMS_ATT_ID_TYP	CHAR	6	0	Price Category
219	AVG_PRICE	☐	CMS_RE_DTE_AVG_PRICE	CMS_RE_AMOUNT	CURR	17	2	Average Price per Day
220	AVG_PRICE_CURR	☐	CMS_RE_DTE_AVG_PRICE_CURR	WAERS	CUKY	5	0	Average Price Currency
221	.INCLUDE	☐				0	0	Building Construction Progress
222	LAST_REPORT_DATE	☐	CMS_RE_DTE_LAST_CONST_REP_DATE	CMS_RE_DATE	DATS	8	0	Date of Last Constuction Report
223	BLD_PROGRESS_AMT	☐	CMS_RE_DTE_AMT_BLD_PROGRESS	CMS_RE_AMOUNT	CURR	17	2	Amount Disbursed for Construction based on Building Progress
224	BLD_AMT_CURR	☐	CMS_RE_DTE_BLD_PROGRESS_CURR	WAERS	CUKY	5	0	Building Progress Amount Curreny
225	PCT_COMPLETED	☐	CMS_RE_DTE_DEGREE_COMPLETE	CMS_RE_PCT	DEC	10	6	Degree of Completion of Construction
226	.INCLUDE	☐				0	0	Insurance details
227	INSURANCE_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO011	CMS_ATT_ID_TYP	CHAR	6	0	Insurance Type
228	INSURANCE_AMT	☐	CMS_RE_DTE_INSURANCE_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Insurance Amount
229	INSURANCE_CURR	☐	CMS_RE_DTE_INSURANCE_CURR	WAERS	CUKY	5	0	Insurance Currency
230	INS_VALIDITY	☐	CMS_RE_DTE_INS_VALID_TILL	CMS_RE_DATE	DATS	8	0	Date until which the Insurance Stands Valid
231	.INCLUDE	☐				0	0	Other Costs
232	RATIONING_COST	☐	CMS_RE_DTE_RAT_COST_AMT	CMS_RE_AMOUNT	CURR	17	2	Residential Rationing Cost
233	RTN_CST_PCT	☐	CMS_RE_DTE_RAN_COST_PCT	CMS_RE_PCT	DEC	10	6	Percentage of Residential Rationing Cost
234	EXT_LAYOUT_COST	☐	CMS_RE_DTE_EXT_LAYOUT_COST	CMS_RE_AMOUNT	CURR	17	2	External Layout Cost
235	EXT_LAY_CST_PCT	☐	CMS_RE_DTE_EXT_LAYOUT_COST_PCT	CMS_RE_PCT	DEC	10	6	External Layout Cost as Percentage of Total Cost
236	RTN_CST_CURR	☐	CMS_RE_DTE_RTN_CST_CURR	WAERS	CUKY	5	0	Rationing cost currency
237	EXT_RTN_CST_CURR	☐	CMS_RE_DTE_EXT_LAYOUT_CST_CURR	WAERS	CUKY	5	0	External Layout cost currency
238	RTN_CST_COM	☐	CMS_RE_DTE_RAT_COST_AMT_COM	CMS_RE_AMOUNT	CURR	17	2	Commercial Rationing Cost
239	RTN_CST_COM_CURR	☐	CMS_RE_DTE_RTN_CST_CURR_COM	WAERS	CUKY	5	0	Rationing cost currency
240	RTN_CST_COM_PCT	☐	CMS_RE_DTE_RAN_COST_PCT_COM	CMS_RE_PCT	DEC	10	6	Percentage of Commercial Rationing Cost
241	.INCLUDE	☐				0	0	Other rents
242	GROSS_COLD_RENT	☐	CMS_RE_DTE_YRLY_GROSS_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Gross Cold Rent
243	GROSS_RENT_CURR	☐	CMS_RE_DTE_GROSS_RENT_CURR	WAERS	CUKY	5	0	Gross Cold Rent Currency
244	NET_COLD_RENT	☐	CMS_RE_DTE_YRLY_NET_COLD_REN	CMS_RE_AMOUNT	CURR	17	2	Net Cold Rent
245	NET_RENT_CURR	☐	CMS_RE_DTE_NET_RENT_CURR	WAERS	CUKY	5	0	Net Cold Rent Currency
246	.INCLUDE	☐				0	0	Valuation Bases(Com)
247	NO_OF_YEARS_COM	☐	CMS_RE_DTE_VAL_NO_YEARS_COM	CMS_RE_INT1	INT1	3	0	No of years since Last Valuation of Commercial Real Estate
248	INT_RATE_COM	☐	CMS_RE_DTE_VAL_INT_RATE_COM	CMS_RE_PCT	DEC	10	6	Interest rate (Com)
249	.INCLUDE	☐				0	0	Valuation Bases
250	NO_OF_YEARS	☐	CMS_RE_DTE_VALUATION_NO_YEARS	CMS_RE_INT1	INT1	3	0	No. of Years since Real Estate was last Valued
251	INT_RATE	☐	CMS_RE_DTE_VALUATION_INT_RATE	CMS_RE_PCT	DEC	10	6	Interest rate used in Valuation of Residential Real Estate
252	.INCLUDE	☐				0	0	Structure for Part Rent Details
253	RENT_PLANNED_COM	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
254	RENT_ACTUAL_COM	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
255	PLAN_CURR_COM	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
256	ACT_CURR_COM	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
257	BASE_PERIOD_COM	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
258	BASE_MEAS_COM	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
259	COM_RENT_IND	☐	CMS_RE_DTE_COM_IND	CMS_RE_RENT_FLG	CHAR	1	0	Indicator for Rent Type
260	COMP_RENT_COM	☐	CMS_RE_DTE_RENT_LEVEL_COM	CMS_RE_AMOUNT	CURR	17	2	Comparative Rent (Commercial)
261	COMP_REN_COM_CUR	☐	CMS_RE_DTE_COMP_RENT_COM_CURR	WAERS	CUKY	5	0	Comparative Rent Currency (Commercial)
262	.INCLUDE	☐				0	0	Structure for Land Rent details
263	PLAN_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT	CMS_RE_AMOUNT	CURR	17	2	Planned Rent Amount
264	ACTUAL_RENT_LAND	☐	CMS_RE_DTE_RENT_AMOUNT_ACT	CMS_RE_AMOUNT	CURR	17	2	Actual Rent Amount
265	PLAN_RENT_CURR	☐	CMS_RE_DTE_RENT_PLANNED_CURR	WAERS	CUKY	5	0	Planned Rent Currency
266	ACTUAL_RENT_CURR	☐	CMS_RE_DTE_RENT_ACTUAL_CURR	WAERS	CUKY	5	0	Actual Rent Currency
267	BASE_PERIOD_LAND	☐	CMS_RE_DTE_BASE_PERIOD	CMS_RE_BASE_PERIOD	CHAR	1	0	Base period for the rent
268	BASE_MEAS_LAND	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
269	.INCLUDE	☐				0	0	Depriciation
270	DEPR	☐	CMS_RE_DTE_DEPR	CMS_RE_PCT	DEC	10	6	Depriciation
271	.INCLUDE	☐				0	0	Land Costs
272	LAND_COST	☐	CMS_RE_DTE_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Land Cost Amount
273	LAND_COST_CURR	☐	CMS_RE_DTE_LAND_COST_CURR	WAERS	CUKY	5	0	Land Cost Currency
274	DEV_COST	☐	CMS_RE_DTE_DEV_COST	CMS_RE_AMOUNT	CURR	17	2	Development Cost Amount
275	DEV_COST_CURR	☐	CMS_RE_DTE_DEV_COST_CURR	WAERS	CUKY	5	0	Dev Cost Currency
276	LAND_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
277	DEV_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
278	ADD_LAND_CST	☐	CMS_RE_DTE_ADD_LAND_COST	CMS_RE_AMOUNT	CURR	17	2	Additional Land Cost Amount
279	ADD_CST_CURR	☐	CMS_RE_DTE_ADD_LAND_COST_CURR	WAERS	CUKY	5	0	Additional Land Cost Currency
280	ADD_CST_BASE	☐	CMS_RE_DTE_BASE_MEAS_LAND	CMS_RE_BASE_MEAS_LAND	CHAR	1	0	Base measure of Land
281	.INCLUDE	☐				0	0	Construction Costs for Buildings
282	CONST_COST	☐	CMS_RE_DTE_CONS_COST	CMS_RE_AMOUNT	CURR	17	2	Construction Cost
283	CONST_COST_CURR	☐	CMS_RE_DTE_CONS_COST_CURR	WAERS	CUKY	5	0	Construction cost currency
284	BASE_MEAS	☐	CMS_RE_DTE_BASE_MEAS	CMS_RE_BASE_MEAS	CHAR	1	0	Base Measure
285	.INCLUDE	☐				0	0	Yearly Gross Profit for Commercial Real Estate
286	GRS_PROFIT	☐	CMS_RE_DTE_GRS_PROFIT	CMS_RE_AMOUNT	CURR	17	2	Yearly Gross Profit
287	GRS_PROFIT_CURR	☐	CMS_RE_DTE_GRS_PROFIT_CURR	WAERS	CUKY	5	0	Yearly Gross Profit Currency
288	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
289	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
290	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
291	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
292	.INCLUDE	☐				0	0	Structure with Asset Details
293	.INCLUDE	☐				0	0	Basic Asset data
294	RISK_CODE	☐	CMS_RE_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
295	SFTY_IND	☐	CMS_RE_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
296	SFTY_DSCNT	☐	CMS_RE_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
297	SFTY_AMOUNT	☐	CMS_RE_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Safety discount as an amount
298	SFTY_AMT_CURR	☐	CMS_RE_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount
299	.INCLUDE	☐				0	0	Valuation data
300	VALUATION_TYP	☐	CMS_RE_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Check conducted on the object
301	UNIT_VALN_FREQ	☐	CMS_RE_DTE_IND_FREQUENCY	CMS_RE_IND_FREQUENCY	CHAR	2	0	Indicator : Valuation Period
302	PERIOD_VALN_FREQ	☐	CMS_RE_DTE_VALN_FREQ_PERIOD	CMS_RE_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for a real estate
303	PAST_VALUED_DATE	☐	CMS_RE_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Most Recent Date on which the Real Estate was last Valued
304	START_DATE	☐	CMS_RE_DTE_START_DATE	CMS_DATE	DATS	8	0	Revaluation Start date
305	END_DATE	☐	CMS_RE_DTE_END_DATE	CMS_DATE	DATS	8	0	End date for Revaluation of the Real Estate
306	.INCLUDE	☐				0	0	Lending rate data
307	LENDING_RATE_IND	☐	CMS_RE_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
308	.INCLUDE	☐				0	0	Lending rates
309	LENDING_RATE1	☐	CMS_RE_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
310	LENDING_RATE2	☐	CMS_RE_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending rate 2
311	LENDING_RATE3	☐	CMS_RE_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending rate 3
312	LENDING_RATE4	☐	CMS_RE_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending rate 4
313	LENDING_RATE5	☐	CMS_RE_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending rate 5
314	.INCLUDE	☐				0	0	Account for liquidation proceeds
315	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
316	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
317	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
318	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
319	.INCLUDE	☐				0	0	Verfication Data
320	UNIT_VERF_FREQ	☐	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
321	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
322	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
323	.INCLUDE	☐				0	0	Liquidation Data
324	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
325	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
326	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
327	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
328	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
329	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
330	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
331	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
332	.INCLUDE	☐				0	0	Structure for Asset values
333	.INCLUDE	☐				0	0	Structure for Asset values
334	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
335	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
336	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
337	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
338	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
339	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
340	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
341	.INCLUDE	☐				0	0	Purchase price data
342	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
343	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
344	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
345	.INCLUDE	☐				0	0	Organization unit structure
346	ORG_UNIT1	☐	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
347	ORG_UNIT2	☐	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
348	ORG_UNIT3	☐	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
349	ORG_UNIT4	☐	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
350	ORG_UNIT5	☐	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5
351	WA_RE_ADDR	☐	CMS_RE_STR_ADDR_GET_MLT		STRU	0	0
352	.INCLUDE	☐				0	0	Structure for Object GUID
353	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
354	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
355	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
356	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID
357	.INCLUDE	☐				0	0	Address details
358	.INCLUDE	☐				0	0	Address return structure
359	.INCLUDE	☐				0	0	Address selection parameter
360	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number
361	ADDRHANDLE	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
362	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
363	DATE	☐	AD_DATE	DATUM	DATS	8	0	Date referred to
364	.INCLUDE	☐				0	0	Address transfer structure
365	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
366	DATE_TO	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
367	.INCLUDE	☐				0	0	Include structure with name attributes of the ADRC address
368	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key
369	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
370	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
371	NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
372	NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
373	NAME_TXT	☐	AD_NAMETXT	TEXT50	CHAR	50	0	Converted name field (with form of address)
374	.INCLUDE	☐				0	0	Include structure with ADRC attributes without name fields
375	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
376	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
377	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
378	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file
379	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file
380	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
381	CITYH_CODE	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file
382	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
383	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping
384	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
385	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
386	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
387	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
388	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
389	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
390	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
391	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag
392	PO_BOX_NUM	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
393	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
394	CITY_CODE2	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)
395	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)
396	PO_BOX_CTY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country
397	POSTALAREA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
398	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
399	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
400	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag
401	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File
402	STREETABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name
403	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
404	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
405	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
406	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
407	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
408	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
409	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
410	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
411	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
412	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
413	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
414	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key
415	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
416	SORT1	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
417	SORT2	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
418	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
419	ADDRORIGIN	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)
420	EXTENSION1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
421	EXTENSION2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
422	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone
423	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
424	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
425	REMARK	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
426	LANGU_CREA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language
427	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
428	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service
429	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
430	COUNTY_CODE	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county
431	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
432	TOWNSHIP_CODE	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township
433	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
434	DEFLT_COMM	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)
435	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
436	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
437	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
438	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
439	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)
440	WA_RE_HDR	☐	CMS_RE_STR_OBJ_HDR_MAP_GET		STRU	0	0
441	.INCLUDE	☐				0	0	Structure for Object GUID
442	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
443	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
444	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
445	.INCLUDE	☐				0	0	Structure for Object Header
446	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID
447	ADDR_ID	☐	CMS_RE_DTE_ADDR_ID	AD_ADDRNUM	CHAR	10	0	Address ID
448	OBJECT_DESC	☐	CMS_RE_DTE_OBJ_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Real Estate Object
449	OBJ_PARENT_ID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
450	OBJ_OLD_REF_NO	☐	CMS_RE_DTE_OBJ_REF_NO	CMS_RE_REFID	CHAR	32	0	External reference Number of an External System
451	FIX_FITTING_TYP	☐	CMS_RE_DTE_FIX_FIT_TYP	CMS_RE_FIX_FIT_TYP	CHAR	6	0	Fixtures and Fittings Type ID
452	OBJ_TYP_NAME	☐	CMS_RE_DTE_NAME	CMS_RE_NAME	CHAR	40	0	Name in a specified language
453	.INCLUDE	☐				0	0	Structure for Object Unit Of Measure
454	OBJECT_AREA_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area
455	OBJECT_VOL_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate
456	.INCLUDE	☐				0	0	Structure for Object Currency
457	OBJECT_CURR	☐	CMS_RE_DTE_OBJ_CURR	WAERS	CUKY	5	0	Object Currency
458	.INCLUDE	☐				0	0	Structure for Location description details
459	MACRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO002	CMS_ATT_ID_TYP	CHAR	6	0	Macro Location
460	MICRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO003	CMS_ATT_ID_TYP	CHAR	6	0	Micro Location
461	TRAN_CONN_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO004	CMS_ATT_ID_TYP	CHAR	6	0	Transport Connection
462	ENVIRON_STATUS	☐	CMS_RE_DTE_ATT_ID_TY_REO005	CMS_ATT_ID_TYP	CHAR	6	0	Enviromental Status
463	FLOOD_ZONE_FLG	☐	CMS_RE_DTE_FLOOD_ZONE	CMS_RE_FLG	CHAR	1	0	Indicator for Flood Zone
464	EARTHQUAKE_FLG	☐	CMS_RE_DTE_EARTHQUAKE	CMS_RE_FLG	CHAR	1	0	Indicator : Eathquake Zone
465	ARCT_CONV_FLG	☐	CMS_RE_DTE_ARCT_CONV	CMS_RE_FLG	CHAR	1	0	Indicator for Architectural Conservation Area
466	HIST_SITE_FLG	☐	CMS_RE_DTE_HIST_SITE	CMS_RE_FLG	CHAR	1	0	Indicator for Historical Site
467	IS_VAL_IMP_FACS	☐	CMS_RE_DTE_VAL_IMP_FLG	CMS_RE_FLG	CHAR	1	0	Indicates existence of Factors Impairing Real Estate Value
468	VALUE_IMP_DESC	☐	CMS_RE_DTE_VAL_IMP_DESC	CMS_RE_DESC	CHAR	30	0	Description of the value imparing factor
469	.INCLUDE	☐				0	0
470	.INCLUDE	☐				0	0	Administrative organization unit
471	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
472	.INCLUDE	☐				0	0	Bank area
473	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
474	.INCLUDE	☐				0	0	Structure for history
475	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
476	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
477	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
478	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
479	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
480	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
481	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
482	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
483	T_USR_STAT	☐	CMS_TAB_COR_RE_OBJ_USR_STAT		TTYP	0	0
484	T_RE_NOTES	☐	CMS_TAB_COR_RE_NOTES		TTYP	0	0
485	T_SYS_STAT	☐	CMS_TAB_COR_RE_OBJ_SYS_STAT		TTYP	0	0
486	T_RE_INSDOC	☐	CMS_TAB_COR_OBJ_INS_DOC		TTYP	0	0
487	T_RE_INSBP	☐	CMS_TAB_COR_OBJ_INS_BP		TTYP	0	0
488	T_RE_INS	☐	CMS_TAB_COR_OBJ_INS_DATA		TTYP	0	0
489	T_PRT_CST	☐	CMS_TAB_COR_OBJ_PRT_CST		TTYP	0	0
490	T_PRT_SEC2	☐	CMS_TAB_COR_OBJ_PRT_SEC2		TTYP	0	0
491	T_PRT_SECB	☐	CMS_TAB_COR_OBJ_PRT_SECB		TTYP	0	0
492	T_PRT_LR	☐	CMS_TAB_COR_OBJ_PRT_LR		TTYP	0	0
493	T_PRT_VAL	☐	CMS_TAB_COR_OBJ_PRT_VAL		TTYP	0	0
494	T_PRT_DOC	☐	CMS_TAB_COR_OBJ_PRT_DOC		TTYP	0	0
495	T_PRT_BP	☐	CMS_TAB_COR_OBJ_PRT_BP		TTYP	0	0
496	T_PRT_ACS	☐	CMS_TAB_COR_OBJ_PRT_ACS		TTYP	0	0
497	T_OBJ_PRT	☐	CMS_TAB_COR_OBJ_PRT		TTYP	0	0
498	T_MAIN_CST	☐	CMS_TAB_COR_MAIN_OBJ_CST		TTYP	0	0
499	T_MAIN_SEC2	☐	CMS_TAB_COR_MAIN_OBJ_SEC2		TTYP	0	0
500	T_MAIN_SECB	☐	CMS_TAB_COR_MAIN_OBJ_SECB		TTYP	0	0
501	T_MAIN_LR	☐	CMS_TAB_COR_MAIN_OBJ_LR		TTYP	0	0
502	T_MAIN_VAL	☐	CMS_TAB_COR_MAIN_OBJ_VAL		TTYP	0	0
503	T_MAINOBJDOC	☐	CMS_TAB_COR_MAIN_OBJ_DOC		TTYP	0	0
504	T_MAINOBJ_BP	☐	CMS_TAB_COR_MAIN_OBJ_BP		TTYP	0	0
505	T_RE_ACS	☐	CMS_TAB_COR_MAIN_OBJ_ACS		TTYP	0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in	500