SAP ABAP Table CRMT_FS_CAG_RE (Collateral Agreement and Real Estate)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IFS-BTX-CL (Application Component) Security System Connection
     ⤷ CRM_FS_COLLATERAL_IMPL (Package) Financial Services: Collateral Management Implementations

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_FS_CAG_RE	Table Relationship Diagram
Short Description	Collateral Agreement and 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	CAG_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
2	RE_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
3	CHARGE_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
4	TRANSFERRED_FLAG	☐	CRMT_FS_CAG_TRANSF_FLAG	CRM_FS_CAG_FLAG	CHAR	1	0	Indicates Whether Data Was Transferred
5	ITEM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	COLLATERAL_TXT	☐	CRMT_FS_COLLATERAL_TXT		CHAR	40	0	Collaterals: Text
7	SYSTEM_ID	☐	CRMT_FS_SYSTEM_ID		CHAR	60	0	ID of Logical Back End System
8	.INCLUDE	☐				0	0	Collateral Agreement: Main Fields
9	CAG_ID	☐	CRMT_FS_CAG_ID		CHAR	40	0	Collateral Agreement: ID
10	CAG_TYPE_ID	☐	CRMT_FS_CAG_TYPE_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Collateral Agreement: Type ID
11	CAG_TYPE	☐	CRMT_FS_CAG_TYPE	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Collateral Agreement: Type
12	CAG_PORTION_ID	☐	CRMT_FS_CAG_PORTION_ID		NUMC	4	0	Collateral Agreement: Portion ID
13	CAG_FREE_COLL	☐	CRMT_FS_CAG_FREE_COLL_AMT	CRM_FS_CAG_AMOUNT	CURR	23	2	Collateral Agreement: Free Collaterals
14	CAG_FREE_COLL_CURR	☐	CRMT_FS_CAG_FREE_COLL_CURR	WAERS	CUKY	5	0	Collateral Agreement: Free Collaterals - Currency	*
15	.INCLUDE	☐				0	0	Collateral Agreement: Additional Fields
16	CAG_DESCR	☐	CRMT_FS_CAG_DESCR		CHAR	30	0	Collateral Agreement: Description
17	CAG_ASMT_AMT	☐	CRMT_FS_CAG_ASMT_AMT	CRM_FS_CAG_AMOUNT	CURR	23	2	Collateral Agreement: Value to be Applied
18	CAG_ASMT_CURR	☐	CRMT_FS_CAG_ASMT_CURR	WAERS	CUKY	5	0	Collateral Agreement: Value to be Applied - Currency	*
19	CAG_COLL_LAND_CHARGE	☐	CRMT_FS_CAG_COLL_LAND_CHARGE	CRM_FS_CAG_FLAG	CHAR	1	0	Collateral Agreement: Collective Land Charge
20	CAG_SUBSCR_DATE	☐	CRMT_FS_CAG_SUBSCR_DATE		DATS	8	0	Collateral Agreement: Closing Date
21	CAG_VALID_FROM	☐	CRMT_FS_CAG_VALID_FROM		DATS	8	0	Collateral Agreement: Valid From
22	CAG_VALID_TO	☐	CRMT_FS_CAG_VALID_TO		DATS	8	0	Collateral Agreement: Valid To
23	.INCLUDE	☐				0	0	Real Estate: Main Fields
24	RE_ID	☐	CRMT_FS_RE_ID		CHAR	40	0	Real Estate: ID
25	RE_DESCR	☐	CRMT_FS_RE_DESCR		CHAR	30	0	Real Estate: Description
26	RE_TYPE_ID	☐	CRMT_FS_RE_TYPE_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Real Estate: Type ID
27	RE_TYPE	☐	CRMT_FS_RE_TYPE	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Real Estate: Type
28	RE_COLL_VALUE	☐	CRMT_FS_RE_COLL_VALUE	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Available Collateral Value
29	RE_COLL_VALUE_CURR	☐	CRMT_FS_RE_COLL_VALUE_CURR	WAERS	CUKY	5	0	Real Estate: Available Collateral Value - Currency	*
30	.INCLUDE	☐				0	0	Real Estate: Additional Fields
31	.INCLUDE	☐				0	0	Real Estate: Data for Value
32	RE_MARKET_VALUE	☐	CRMT_FS_RE_MARKET_VAL	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Market Value
33	RE_MARKET_VALUE_CURR	☐	CRMT_FS_RE_MARKET_VAL_CURR	WAERS	CUKY	5	0	Real Estate: Market Value - Currency	*
34	RE_NOMINAL_VALUE	☐	CRMT_FS_RE_NOMINAL_VAL	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Nominal Value
35	RE_NOMINAL_VALUE_CURR	☐	CRMT_FS_RE_NOMINAL_VAL_CURR	WAERS	CUKY	5	0	Real Estate: Nominal Value - Currency	*
36	RE_SAFE_DISCOUNT_PCT	☐	CRMT_FS_RE_SAFE_DISCOUNT_PCT	CRM_FS_CAG_PCT	DEC	10	6	Real Estate: Collateral Markdown in Percent
37	RE_SAFE_DISCOUNT_AMT	☐	CRMT_FS_RE_SAFE_DISCOUNT_AMT	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Collateral Markdown (Amount)
38	RE_SAFE_DISCOUNT_CURR	☐	CRMT_FS_RE_SAFE_DISCOUNT_CURR	WAERS	CUKY	5	0	Real Estate: Collateral Markdown (Amount) - Currency	*
39	RE_LENDING_VALUE	☐	CRMT_FS_RE_LENDING_VALUE	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Lending Value
40	RE_LENDING_VALUE_CURR	☐	CRMT_FS_RE_LENDING_VALUE_CURR	WAERS	CUKY	5	0	Real Estate: Lending Value - Currency	*
41	RE_LENDING_RATE	☐	CRMT_FS_RE_LENDING_RATE	CRM_FS_CAG_PCT	DEC	10	6	Real Estate: Lending Rate
42	RE_LENDING_LIMIT	☐	CRMT_FS_RE_LENDING_LIMIT	CRM_FS_CAG_AMOUNT	CURR	23	2	Real Estate: Lending Limit
43	RE_LENDING_LIMIT_CURR	☐	CRMT_FS_RE_LENDING_LIMIT_CURR	WAERS	CUKY	5	0	Real Estate: Lending Limit - Currency	*
44	.INCLUDE	☐				0	0	Real Estate: More Details
45	RE_UTILIZATION_ID	☐	CMRT_FS_RE_UTILIZATION_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Real Estate: Utilization ID
46	RE_UTILIZATION	☐	CRMT_FS_RE_UTILIZATION	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Real Estate: Usage
47	RE_PROP_SIZE	☐	CRMT_FS_RE_PROP_SIZE	CRM_FS_RE_SIZE	QUAN	13	3	Real Estate: Property Size
48	RE_PROP_SIZE_UOM	☐	CRMT_FS_RE_PROP_SIZE_UOM	MEINS	UNIT	3	0	Real Estate: Property Size - UoM	*
49	RE_RES_SPACE	☐	CRMT_FS_RE_RES_SPACE	CRM_FS_RE_SIZE	QUAN	13	3	Real Estate: Living Area
50	RE_RES_SPACE_UOM	☐	CRMT_FS_RE_RES_SPACE_UOM	MEINS	UNIT	3	0	Real Estate: Living Area - UoM	*
51	RE_COM_SPACE	☐	CRMT_FS_RE_COM_SPACE	CRM_FS_RE_SIZE	QUAN	13	3	Real Estate: Commercial Space
52	RE_COM_SPACE_UOM	☐	CRMT_FS_RE_COM_SPACE_UOM	MEINS	UNIT	3	0	Real Estate: Commercial Space - UoM	*
53	RE_CONSTR_YEAR	☐	CRMT_FS_RE_CONSTR_YEAR		NUMC	4	0	Real Estate: Construction Year
54	.INCLUDE	☐				0	0	Real Estate: Site
55	RE_MACRO_LOCATION_ID	☐	CRMT_FS_RE_MACRO_LOC_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Real Estate: Macro Location ID
56	RE_MACRO_LOCATION	☐	CRMT_FS_RE_MACRO_LOC	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Real Estate: Macro Location
57	RE_MICRO_LOCATION_ID	☐	CRMT_FS_RE_MICRO_LOC_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Real Estate: Micro Location ID
58	RE_MICRO_LOCATION	☐	CRMT_FS_RE_MICRO_LOC	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Real Estate: Micro Location
59	RE_TRANSPORT_CON_ID	☐	CRMT_FS_RE_TRANS_CON_ID	CRM_FS_CAG_CUST_KEY	CHAR	6	0	Real Estate: Transport Connection ID
60	RE_TRANSPORT_CON	☐	CRMT_FS_RE_TRANSPORT_CON	CRM_FS_CAG_CUST_DESCR	CHAR	30	0	Real Estate: Transport Connection
61	.INCLUDE	☐				0	0	Real Estate: Address
62	RE_STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
63	RE_HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
64	RE_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
65	RE_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
66	RE_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
67	RE_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
68	.INCLUDE	☐				0	0	Collateral Charge: Main Fields
69	CHARGE_DESCR	☐	CRMT_FS_CHARGE_DESCR		CHAR	30	0	Collateral Charge: Description
70	CHARGE_RANK	☐	CRMT_FS_CHARGE_RANK		NUMC	4	0	Collateral Charge: Ranking
71	CHARGE_SEQ	☐	CRMT_FS_CHARGE_SEQ		NUMC	4	0	Collateral Charge: Sequence
72	CHARGE_REG_NO	☐	CRMT_FS_CHARGE_REG_NO		CHAR	32	0	Collateral Charge: Register Number
73	CHARGE_REG_DATE	☐	CRMT_FS_CHARGE_REG_DATE		DATS	8	0	Collateral Charge: Registration Date
74	CHARGE_USED_VALUE	☐	CRMT_FS_CHARGE_USED_VAL	CRM_FS_CAG_AMOUNT	CURR	23	2	Collateral Charge: Object Value Used
75	CHARGE_USED_VALUE_CURR	☐	CRMT_FS_CHARGE_USED_VAL_CURR	WAERS	CUKY	5	0	Collateral Charge: Object Value Used - Currency	*
76	CHARGE_USED_VALUE_PCT	☐	CRMT_FS_CHARGE_USED_VAL_PCT	CRM_FS_CAG_PCT	DEC	10	6	Collateral Charge: Object Value Used in Percent

History

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