SAP ABAP Table VCMS_RE_OBJ (Change Document Structure; Generated by RSSCD000)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RE (Application Component) Real Estate
     ⤷ CMS_RE (Package) Collateral Management System: Real Esate

Basic Data

Table Category	INTTAB	Structure
Structure	VCMS_RE_OBJ	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	.INCLUDE	☐				0	0	Real estate header details
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Structure for Object GUID
4	OBJ_GUID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
5	.INCLUDE	☐				0	0	Structure for Semantic key for Objects in RE Add-On
6	OBJECT_ID	☐	CMS_RE_DTE_OBJECT_ID	CMS_RE_OBJECT_ID	CHAR	20	0	Object ID
7	.INCLUDE	☐				0	0	Structure for Object Header
8	OBJECT_TYPE	☐	CMS_RE_DTE_OBJ_TYP	CMS_RE_TYP	CHAR	6	0	Real Estate Object Type ID	TCMS_RE_TYP
9	ADDR_ID	☐	CMS_RE_DTE_ADDR_ID	AD_ADDRNUM	CHAR	10	0	Address ID	*
10	OBJECT_DESC	☐	CMS_RE_DTE_OBJ_DESC	CMS_RE_DESC	CHAR	30	0	Description of the Real Estate Object
11	OBJ_PARENT_ID	☐	CMS_RE_DTE_OBJ_GUID	SYSUUID	RAW	16	0	GUID for Real Estate Object
12	OBJ_OLD_REF_NO	☐	CMS_RE_DTE_OBJ_REF_NO	CMS_RE_REFID	CHAR	32	0	External reference Number of an External System
13	FIX_FITTING_TYP	☐	CMS_RE_DTE_FIX_FIT_TYP	CMS_RE_FIX_FIT_TYP	CHAR	6	0	Fixtures and Fittings Type ID
14	.INCLUDE	☐				0	0	Structure for Object Unit Of Measure
15	OBJECT_AREA_UOM	☐	CMS_RE_DTE_AREA_UOM	MEINS	UNIT	3	0	Unit of Measure for Area	*
16	OBJECT_VOL_UOM	☐	CMS_RE_DTE_VOL_UOM	MEINS	UNIT	3	0	Unit of Measure for Volume of Real Estate	*
17	.INCLUDE	☐				0	0	Structure for Object Currency
18	OBJECT_CURR	☐	CMS_RE_DTE_OBJ_CURR	WAERS	CUKY	5	0	Object Currency	TCURC
19	.INCLUDE	☐				0	0	Structure for Location description details
20	MACRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO002	CMS_ATT_ID_TYP	CHAR	6	0	Macro Location	TCMS_ATT_ID_TY
21	MICRO_LOC_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO003	CMS_ATT_ID_TYP	CHAR	6	0	Micro Location	TCMS_ATT_ID_TY
22	TRAN_CONN_TYPE	☐	CMS_RE_DTE_ATT_ID_TY_REO004	CMS_ATT_ID_TYP	CHAR	6	0	Transport Connection	TCMS_ATT_ID_TY
23	ENVIRON_STATUS	☐	CMS_RE_DTE_ATT_ID_TY_REO005	CMS_ATT_ID_TYP	CHAR	6	0	Enviromental Status	TCMS_ATT_ID_TY
24	FLOOD_ZONE_FLG	☐	CMS_RE_DTE_FLOOD_ZONE	CMS_RE_FLG	CHAR	1	0	Indicator for Flood Zone
25	EARTHQUAKE_FLG	☐	CMS_RE_DTE_EARTHQUAKE	CMS_RE_FLG	CHAR	1	0	Indicator : Eathquake Zone
26	ARCT_CONV_FLG	☐	CMS_RE_DTE_ARCT_CONV	CMS_RE_FLG	CHAR	1	0	Indicator for Architectural Conservation Area
27	HIST_SITE_FLG	☐	CMS_RE_DTE_HIST_SITE	CMS_RE_FLG	CHAR	1	0	Indicator for Historical Site
28	IS_VAL_IMP_FACS	☐	CMS_RE_DTE_VAL_IMP_FLG	CMS_RE_FLG	CHAR	1	0	Indicates existence of Factors Impairing Real Estate Value
29	VALUE_IMP_DESC	☐	CMS_RE_DTE_VAL_IMP_DESC	CMS_RE_DESC	CHAR	30	0	Description of the value imparing factor
30	.INCLUDE	☐				0	0
31	.INCLUDE	☐				0	0	Administrative organization unit
32	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
33	.INCLUDE	☐				0	0	Bank area
34	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
35	.INCLUDE	☐				0	0	Structure for history
36	CREATED_BY	☐	CMS_RE_DTE_CR_BY	CMS_RE_USER	CHAR	12	0	Real Estate Add-On User
37	CREATED_DATE	☐	CMS_RE_DTE_CR_ON	CMS_RE_DATE	DATS	8	0	Created On
38	CREATED_TIME	☐	CMS_RE_DTE_CR_AT	CMS_RE_TIME	TIMS	6	0	Created At
39	ENTRY_SRC	☐	CMS_RE_DTE_SRC_INIT	CMS_RE_SOURCE	CHAR	32	0	Sorce of Initial entry
40	LAST_CHG_BY	☐	CMS_RE_DTE_CHG_BY	CMS_RE_USER	CHAR	12	0	Last Changed By
41	LAST_CHG_DATE	☐	CMS_RE_DTE_CHG_ON	CMS_RE_DATE	DATS	8	0	Last Changed On
42	LAST_CHG_TIME	☐	CMS_RE_DTE_CHG_AT	CMS_RE_TIME	TIMS	6	0	Last Changed At
43	PROCESSING_SRC	☐	CMS_RE_DTE_PRC_SRC	CMS_RE_SOURCE	CHAR	32	0	Processing Source
44	.INCLUDE	☐				0	0	RE DB Asset Details - not used
45	.INCLUDE	☐				0	0	Basic Asset data
46	RISK_CODE	☐	CMS_RE_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
47	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
48	SFTY_DSCNT	☐	CMS_RE_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
49	SFTY_AMOUNT	☐	CMS_RE_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Safety discount as an amount
50	SFTY_AMT_CURR	☐	CMS_RE_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount	TCURC
51	.INCLUDE	☐				0	0	Valuation data
52	VALUATION_TYP	☐	CMS_RE_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Check conducted on the object
53	UNIT_VALN_FREQ	☐	CMS_RE_DTE_IND_FREQUENCY	CMS_RE_IND_FREQUENCY	CHAR	2	0	Indicator : Valuation Period
54	PERIOD_VALN_FREQ	☐	CMS_RE_DTE_VALN_FREQ_PERIOD	CMS_RE_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for a real estate
55	PAST_VALUED_DATE	☐	CMS_RE_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Most Recent Date on which the Real Estate was last Valued
56	START_DATE	☐	CMS_RE_DTE_START_DATE	CMS_DATE	DATS	8	0	Revaluation Start date
57	END_DATE	☐	CMS_RE_DTE_END_DATE	CMS_DATE	DATS	8	0	End date for Revaluation of the Real Estate
58	.INCLUDE	☐				0	0	Lending rate data
59	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
60	.INCLUDE	☐				0	0	Lending rates
61	LENDING_RATE1	☐	CMS_RE_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
62	LENDING_RATE2	☐	CMS_RE_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending rate 2
63	LENDING_RATE3	☐	CMS_RE_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending rate 3
64	LENDING_RATE4	☐	CMS_RE_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending rate 4
65	LENDING_RATE5	☐	CMS_RE_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending rate 5
66	.INCLUDE	☐				0	0	Liquidation rights data
67	LIQD_TYP	☐	CMS_RE_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
68	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
69	LIQD_DATE	☐	CMS_RE_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
70	LIQD_AMT	☐	CMS_RE_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
71	LIQD_CURR	☐	CMS_RE_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value	TCURC
72	.INCLUDE	☐				0	0	Verfication Data
73	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
74	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
75	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
76	.INCLUDE	☐				0	0	Organization unit structure: RE
77	ORG_UNIT1	☐	CMS_RE_DTE_ORG_UNIT1	CMS_RE_ORG_UNIT	CHAR	10	0	organization unit 1: Assets	*
78	ORG_UNIT2	☐	CMS_RE_DTE_ORG_UNIT2	CMS_RE_ORG_UNIT	CHAR	10	0	organization unit 2: Assets	*
79	ORG_UNIT3	☐	CMS_RE_DTE_ORG_UNIT3	CMS_RE_ORG_UNIT	CHAR	10	0	organization unit 3: Assets	*
80	ORG_UNIT4	☐	CMS_RE_DTE_ORG_UNIT4	CMS_RE_ORG_UNIT	CHAR	10	0	organization unit 4: Assets	*
81	ORG_UNIT5	☐	CMS_RE_DTE_ORG_UNIT5	CMS_RE_ORG_UNIT	CHAR	10	0	organization unit 5: Assets	*
82	.INCLUDE	☐				0	0
83	.INCLUDE	☐				0	0	Structures for generating change document update programs
84	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VCMS_RE_OBJ	ENVIRON_STATUS	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	VCMS_RE_OBJ	LIQD_CURR	TCURC	WAERS	REF	1	CN
3	VCMS_RE_OBJ	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
4	VCMS_RE_OBJ	MACRO_LOC_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
5	VCMS_RE_OBJ	MANDT	T000	MANDT	KEY	1	CN
6	VCMS_RE_OBJ	MICRO_LOC_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
7	VCMS_RE_OBJ	OBJECT_CURR	TCURC	WAERS	REF	1	CN
8	VCMS_RE_OBJ	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN
9	VCMS_RE_OBJ	TRAN_CONN_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600