SAP ABAP Table CRMT_BSP_FSQ_CAG_RE_LST_UI (FSQ Collateral Agreement and Real Estate)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM (Application Component) CRM Leasing
     ⤷ CRM_BSP_MODEL_IL_FSQ (Package) FS: Quotations in People Centric UI

Basic Data

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

History

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