SAP ABAP Table CMS_STR_CHG (Asset - Collateral Agreement Relationship)

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	INTTAB	Structure
Structure	CMS_STR_CHG	Table Relationship Diagram
Short Description	Asset - Collateral Agreement Relationship

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	Primary Key for CMS_CHG
2	CHG_GUID	☐	CMS_DTE_CHG_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_CHG
3	.INCLUDE	☐				0	0	Link to CMS_AST Table
4	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
5	.INCLUDE	☐				0	0	Asset Guid as a parent GUID for a sub-asset
6	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
7	.INCLUDE	☐				0	0	Link to CMS_CAG Table
8	CAG_GUID	☐	CMS_DTE_CAG_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_CAG
9	.INCLUDE	☐				0	0	Asset-Collateral Agreement Relationship
10	.INCLUDE	☐				0	0	Charge details
11	DESCRIPTION	☐	CMS_DTE_CHG_DESC	CMS_DSC	CHAR	30	0	Description for Charges
12	RANKING_ORDER	☐	CMS_DTE_RANKING_ORDER	CMS_PRIORITY	NUMC	4	0	Ranking of a Collateral Agreement in an Asset
13	SEQUENCE	☐	CMS_DTE_SEQUENCE	CMS_PRIORITY	NUMC	4	0	Sequence of an Asset in a Collateral agreement
14	.INCLUDE	☐				0	0	Registration data of a charge
15	REG_ENTRY_NO	☐	CMS_DTE_CHG_REG_NO	CMS_INTFID	CHAR	32	0	Register Number
16	REG_DATE	☐	CMS_DTE_CHG_REG_DATE	CMS_DATE	DATS	8	0	Date on which the Land Charge was Registered
17	.INCLUDE	☐				0	0	Asset data in a Charge
18	AST_PART_NR	☐	CMS_DTE_AST_PART_NR	CMS_RATIO	INT4	10	0	Numerator in Business Partner Share of Asset
19	AST_PART_DN	☐	CMS_DTE_AST_PART_DN	CMS_RATIO	INT4	10	0	Denominator in the Business Partner Share of Asset
20	AST_QTY	☐	CMS_DTE_AST_PART_QTY	CMS_QTY	QUAN	13	3	Size of the Asset used as Charge
21	AST_VALUE	☐	CMS_DTE_AST_PART_VAL	CMS_AMOUNT	CURR	17	2	Amount of Asset used as Charge
22	.INCLUDE	☐				0	0	Assessment data of a Charge
23	ASMT_AMT	☐	CMS_DTE_CHG_ASMT_AMT	CMS_AMOUNT	CURR	17	2	Assessment amount of a charge
24	ASMT_CURR	☐	CMS_DTE_CHG_ASMT_CURR	WAERS	CUKY	5	0	CMS_DTE_CHG_ASMT_CURR	*
25	ASMT_DATE	☐	CMS_DTE_CHG_ASMT_DATE	CMS_DATE	DATS	8	0	Date of assessment
26	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
27	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
28	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
29	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
30	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
31	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
32	.INCLUDE	☐				0	0	Currencies for Charges
33	AST_CURR	☐	CMS_DTE_AST_PART_CURR	WAERS	CUKY	5	0	Currency of the amount from the asset value used in a charge	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_CHG	AST_CURR	TCURC	WAERS

History

Last changed by/on	SAP	20110810
SAP Release Created in	110