SAP ABAP Table CMS_CAG_SA (Special Arrangements)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD (Application Component) Master Data
     ⤷ CMS_CORE (Package) Collateral Management System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_CAG_SA	Table Relationship Diagram
Short Description	Special Arrangements

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Primary Key for CMS_CAG_SA
3	CAG_SA_GUID	☑	CMS_DTE_CAG_SA_GUID	SYSUUID	RAW	16	0	Primary key for CMS_CAG_SA
4	.INCLUDE	☐				0	0	Link Key for CMS_CAG_SA
5	REF_GUID	☐	CMS_DTE_CAG_SA_REF_GUID	SYSUUID	RAW	16	0	Link Key for CMS_CAG_SA
6	.INCLUDE	☐				0	0	Special Arrangement Details
7	SA_TYPE	☐	CMS_DTE_CAG_SA_TYP	CMS_CAG_SA_TYP	CHAR	6	0	Special Arrangement Type	TCMS_CAG_SA_TY
8	SA_ID	☐	CMS_DTE_CAG_SA_ID	CMS_CAG_SA_ID	CHAR	40	0	Special Arrangement ID
9	PROC_STAT	☐	CMS_DTE_CAG_SA_PROC_STAT	CMS_CAG_SA_PROC_STAT	CHAR	2	0	Processing Status of Special Arrangement
10	LEGAL_STAT	☐	CMS_DTE_CAG_SA_LEGAL_STAT	CMS_CAG_CA_LEGAL_STAT	CHAR	2	0	Special Arrangement Legal Status
11	VALID_FROM	☐	CMS_DTE_CAG_SA_VALID_FROM	CMS_DATE	DATS	8	0	Date from which Special Arrangement Stands Valid
12	VALID_TO	☐	CMS_DTE_CAG_SA_VALID_TO	CMS_DATE	DATS	8	0	Date from which Special Arrangement Stands Valid
13	NOM_VALUE	☐	CMS_DTE_CAG_SA_NOM_VALUE	CMS_AMOUNT	CURR	17	2	Special Arrangement Nominal Value
14	NOM_VALUE_CURR	☐	CMS_DTE_CAG_SA_NOM_CURR	WAERS	CUKY	5	0	Currency of Special Arrangement: Nominal Value	TCURC
15	ASMT_AMT	☐	CMS_DTE_CAG_SA_ASMT_AMT	CMS_AMOUNT	CURR	17	2	Special Arrangement Assessment Amount
16	ASMT_AMT_CURR	☐	CMS_DTE_CAG_SA_ASMT_CURR	WAERS	CUKY	5	0	Currency of Special Arrangement: Assessment Amount	TCURC
17	BANK_CTRY	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
18	BANK_KEY	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
19	BANK_ACCT	☐	BANKN35	BANKN35	CHAR	35	0	Bank account number
20	BANK_CTRL_KEY	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
21	REF_AGMT_ID	☐	CMS_DTE_CAG_SA_REFAGMT_ID	CMS_CAG_SA_REFAGMT_ID	CHAR	40	0	Pruchase Agreement ID of a Special Arrangement
22	REF_AGMT_DATE	☐	CMS_DTE_CAG_SA_REFAGMT_DATE	CMS_DATE	DATS	8	0	Purchase Agreement Date of Special Arrangement
23	DESCRIPTION	☐	CMS_DTE_CAG_SA_DESC	CMS_DSC	CHAR	30	0	Description for Special Arrangement
24	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
25	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
26	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
27	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
28	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
29	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_CAG_SA	ASMT_AMT_CURR	TCURC	WAERS	REF	1	CN
2	CMS_CAG_SA	BANK_CTRY	T005	LAND1	REF	1	CN
3	CMS_CAG_SA	MANDT	T000	MANDT	KEY	1	CN
4	CMS_CAG_SA	NOM_VALUE_CURR	TCURC	WAERS	REF	1	CN

History

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