SAP ABAP Table CRMT_FS_COLLATERAL_CONSTEL (Collateral Constellation)

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_COLLATERAL_CONSTEL	Table Relationship Diagram
Short Description	Collateral Constellation

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

History

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