SAP ABAP Table CMS_STR_CAG_CHARGE_CRM (Collateral Agreement + Charge)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_CRM_TMP (Package) Temporary!!!: CMS-CRM Interface (to be deleted in ERP2006)

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_CAG_CHARGE_CRM	Table Relationship Diagram
Short Description	Collateral Agreement + Charge

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	COLLATERAL_AGREEMENT	☐	CMS_STR_COLLATERAL_AGREEMT_CRM		STRU	0	0
2	BTD_ID	☐	CMS_STR_BTD_ID_CRM		STRU	0	0
3	ID	☐	CHAR_35	CHAR_35	CHAR	35	0	Text field, length 35
4	SCHEME_ID	☐	CMS_DTE_CHAR60LOW_CRM	CHAR60LOW	CHAR	60	0	60 Characters Lower Case
5	SCHEME_AGENCY_ID	☐	CHAR_60	CHAR_60	CHAR	60	0	Character String 60
6	ID	☐	CMS_DTE_CAGID	CMS_CAGID	CHAR	40	0	Collateral Agreement ID
7	TYPE	☐	BAPICMS_DTE_CAG_TYP	CMS_CAG_TYP	CHAR	6	0	Collateral Agreement Type
8	VALIDITY_START_DATE	☐	BAPICMS_DTE_VALID_FROM	CMS_DATE	DATS	8	0	Date from when it is valid
9	VALIDITY_END_DATE	☐	BAPICMS_DTE_VALID_TO	CMS_DATE	DATS	8	0	Date until when it is valid
10	ASSESSMENT_AMOUNT	☐	BAPICMS_DTE_CAG_ASMT_AMT	BAPICURR	DEC	23	4	Assessment Amount
11	ASSESSMENT_AMOUNT_C	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
12	ASSESSMENT_DATE	☐	BAPICMS_DTE_CAG_ASMT_DATE	CMS_DATE	DATS	8	0	Date on which the Assessment Value was Calculated
13	DESCRIPTION	☐	BAPICMS_DTE_CAG_DESC	CMS_DSC	CHAR	30	0	Description of Collateral Agreement
14	WIDE_PURPOSE_DECLARN_INDICATOR	☐	BAPICMS_DTE_FLG_CAG_GLOBAL	CMS_FLG_GLOBAL_CAGMT	CHAR	1	0	Flag to indicate a Global Collateral Agreement
15	FREE_AMOUNTS	☐	CMS_TAB_FREE_AMOUNT_CRM		TTYP	0	0
16	LAND_CHARGE	☐	CMS_STR_LAND_CHARGE_CRM		STRU	0	0
17	COLLECTIVITY_INDICATOR	☐	CMS_DTE_FLG_CAG_LCHG_COLL	CMS_FLG_CAG_LCHG_COLLECTIVE	CHAR	1	0	Flag: Collective Land Charge
18	CERTIFIATE_EXISTENCY_INDICATOR	☐	CMS_DTE_FLG_CAG_LCHG_CERT	CMS_FLG_LCHG_CERT	CHAR	1	0	Flag: Land Charge certificate exists
19	CERTIFIATE_ID	☐	CMS_DTE_CAG_LCHG_CERT_NUM	CMS_LCHG_CERT_NUM	CHAR	30	0	Charge Certificate Number
20	REGISTER_RECORD_SERIAL_NUMBER	☐	CMS_DTE_CAG_LCHG_FILE_NUM	CMS_LCHG_FILE_NUM	CHAR	30	0	File Number
21	INTEREST	☐	CMS_STR_LAND_CHARGE_INTRST_CRM		STRU	0	0
22	RATE	☐	CMS_DTE_CAG_LCHG_INT_RATE	CMS_PCT	DEC	10	6	Land Charge Interest Rate
23	INCIDENTAL_PAYMENT_PERCENTAGE	☐	CMS_DTE_CAG_LCHG_INCD_PAYMT	CMS_PCT	DEC	10	6	Incidental Payments in Percentage
24	PAYMENT_FREQUENCY	☐	CMS_DTE_CAG_PYMT_FREQ_PERIOD	CMS_CAG_FREQ_PERIOD	NUMC	4	0	Period for Frequency of Payment of Land Charge Interest
25	PAYMENT_FREQUENCY_UNIT	☐	CMS_DTE_IND_CAG_PYMT_FREQ_UNIT	CMS_IND_CAG_FREQ_UNIT	CHAR	2	0	The unit for period of payment frequency
26	CALCULATION_START_DATE	☐	CMS_DTE_CAG_LCHG_INT_START_DAT	CMS_DATE	DATS	8	0	Start Date for Land Charge Interest Calculation
27	CAPITALISATION_YEARS	☐	CMS_DTE_CAG_LCHG_INT_YR	CMS_CAG_LCHG_INT_YR	NUMC	4	0	Number of Years the Land Charge Interest can be Capitalized
28	CHARGE	☐	CMS_STR_CHARGE_CRM		STRU	0	0
29	BTD_ID	☐	CMS_STR_BTD_ID_CRM		STRU	0	0
30	ID	☐	CHAR_35	CHAR_35	CHAR	35	0	Text field, length 35
31	SCHEME_ID	☐	CMS_DTE_CHAR60LOW_CRM	CHAR60LOW	CHAR	60	0	60 Characters Lower Case
32	SCHEME_AGENCY_ID	☐	CHAR_60	CHAR_60	CHAR	60	0	Character String 60
33	REAL_ESTATE_REFERENCE_ID	☐	CMS_STR_BTD_ID_CRM		STRU	0	0
34	ID	☐	CHAR_35	CHAR_35	CHAR	35	0	Text field, length 35
35	SCHEME_ID	☐	CMS_DTE_CHAR60LOW_CRM	CHAR60LOW	CHAR	60	0	60 Characters Lower Case
36	SCHEME_AGENCY_ID	☐	CHAR_60	CHAR_60	CHAR	60	0	Character String 60
37	CAG_REFERENCE_ID	☐	CMS_STR_BTD_ID_CRM		STRU	0	0
38	ID	☐	CHAR_35	CHAR_35	CHAR	35	0	Text field, length 35
39	SCHEME_ID	☐	CMS_DTE_CHAR60LOW_CRM	CHAR60LOW	CHAR	60	0	60 Characters Lower Case
40	SCHEME_AGENCY_ID	☐	CHAR_60	CHAR_60	CHAR	60	0	Character String 60
41	DESCRIPTION	☐	CMS_DTE_CHG_DESC	CMS_DSC	CHAR	30	0	Description for Charges
42	RANKING_ORDER	☐	CMS_DTE_RANKING_ORDER	CMS_PRIORITY	NUMC	4	0	Ranking of a Collateral Agreement in an Asset
43	SEQUENCE	☐	CMS_DTE_SEQUENCE	CMS_PRIORITY	NUMC	4	0	Sequence of an Asset in a Collateral agreement
44	REGISTRATION_NUMBER	☐	CMS_DTE_CHG_REG_NO	CMS_INTFID	CHAR	32	0	Register Number
45	REGISTRATION_DATE	☐	CMS_DTE_CHG_REG_DATE	CMS_DATE	DATS	8	0	Date on which the Land Charge was Registered
46	ASSET_AMOUNT	☐	BAPICMS_DTE_AST_PART_VAL	BAPICURR	DEC	23	4	Asset Value Amount used as Charge
47	ASSET_AMOUNT_CURRENCY	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
48	ASSET_PERCENT	☐	CMS_DTE_AST_PCT_SHARE	CMS_PCT_SHARE	DEC	6	2	Share of the Asset in the Charge

History

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