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

History

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