SAP ABAP Table CMS_STR_SAS_DETAILS_API (Sub-asset details (API layer and above))

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_SAS_DETAILS_API	Table Relationship Diagram
Short Description	Sub-asset details (API layer and above)

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_AST
2	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
3	.INCLUDE	☐				0	0	Sub-asset Identification
4	SUBAST_ID	☐	CMS_DTE_SAS_ID	CMS_SAS_ID	NUMC	4	0	Sub-asset ID
5	SUBAST_TYP	☐	CMS_DTE_SAS_TYP	CMS_TYP	CHAR	6	0	Sub-asset Type
6	.INCLUDE	☐				0	0	Asset Guid as a parent GUID for a sub-asset
7	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
8	.INCLUDE	☐				0	0	Semantic Key for Table CMS_AST
9	AST_ID	☐	CMS_DTE_AST_ID	CMS_AST_ID	CHAR	40	0	Asset ID
10	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
11	.INCLUDE	☐				0	0	Sub-asset data
12	.INCLUDE	☐				0	0	Basic Sub-asset data
13	DESCRIPTION	☐	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
14	OBJECT_REF_ID	☐	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
15	RISK_CODE	☐	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
16	SFTY_IND	☐	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
17	SFTY_DSCNT	☐	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
18	SFTY_AMOUNT	☐	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
19	SFTY_AMT_CURR	☐	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount	*
20	.INCLUDE	☐				0	0	Valuation data
21	VALUATION_TYP	☐	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
22	UNIT_VALN_FREQ	☐	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
23	PERIOD_VALN_FREQ	☐	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
24	PAST_VALUED_DATE	☐	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
25	START_DATE	☐	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
26	END_DATE	☐	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
27	.INCLUDE	☐				0	0	Lending rate data
28	LENDING_RATE_IND	☐	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
29	.INCLUDE	☐				0	0	Lending rates structure
30	LENDING_RATE1	☐	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
31	LENDING_RATE2	☐	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
32	LENDING_RATE3	☐	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
33	LENDING_RATE4	☐	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
34	LENDING_RATE5	☐	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
35	.INCLUDE	☐				0	0	Liquidation rights data
36	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
37	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
38	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
39	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
40	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value	TCURC
41	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
42	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed	TCURC
43	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
44	.INCLUDE	☐				0	0	Account for liquidation proceeds
45	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
46	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
47	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
48	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
49	.INCLUDE	☐				0	0	Structure for Asset values
50	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
51	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value	*
52	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
53	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value	*
54	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
55	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
56	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
57	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
58	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
59	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
60	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
61	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
62	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
63	.INCLUDE	☐				0	0	Asset IF: SubObj Display Details (Instead of SAS_TYP+SAS_ID)
64	SAS_DISP_DATA	☐	CMS_DTE_AST_IF_SUB_OBJ_ID_SCR	CMS_SCR_TEXT	CHAR	90	0	Asset IF : Screen Data for Sub Object ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SAS_DETAILS_API	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
2	CMS_STR_SAS_DETAILS_API	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
3	CMS_STR_SAS_DETAILS_API	LIQD_CURR	TCURC	WAERS
4	CMS_STR_SAS_DETAILS_API	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
5	CMS_STR_SAS_DETAILS_API	UNIT_OF_MEASURE	T006	MSEHI	REF	1	CN

History

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