CMS_AST - Asset Details

Asset Details information is stored in SAP table CMS_AST.
It is part of development package CMS_CORE in software component FS-CMS-MD. This development package consists of objects that can be grouped under "Collateral Management System".

Fields for table CMS_AST

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
.INCLUDE		X		CMS_STR_AST_PKY	0
AST_GUID	GUID for Table CMS_AST	X	CMS_DTE_AST_GUID	RAW	16
.INCLUDE	SEMANTIC_KEY			CMS_STR_AST_SKY	0
AST_ID	Asset ID		CMS_DTE_AST_ID	CHAR	80
AST_TYP	Asset Type		CMS_DTE_AST_TYP	CHAR	12	TCMS_AST_TYP
.INCLUDE				CMS_STR_SAS_PAR_GUID	0
PARENT_GUID	Asset Guid as a parent GUID for a sub-asset		CMS_DTE_SAS_PAR_GUID	RAW	16
.INCLUDE				CMS_STR_SAS_ID	0
SUBAST_ID	Sub-asset ID		CMS_DTE_SAS_ID	NUMC	8
SUBAST_TYP	Sub-asset Type		CMS_DTE_SAS_TYP	CHAR	12
.INCLUDE				CMS_STR_AST_DATA	0
.INCLUDE	BASIC_DATA			CMS_STR_AST_BASIC_DATA	0
DESCRIPTION	Description		CMS_DTE_AST_DESC	CHAR	60
OBJECT_REF_ID	Reference ID for the object		CMS_DTE_OBJ_REFID	CHAR	80
OBJECT_TYP	Not used		CMS_DTE_OBJ_TYP	CHAR	64
COUNTRY_KEY	Identification Key for Country/Region		CMS_DTE_AST_COUNTRY_KEY	CHAR	6	T005
RISK_CODE	Risk Code		CMS_DTE_RISK_CODE	CHAR	12	*
SFTY_IND	Indicates if the Asset has a Default Safety Discount		CMS_DTE_IND_SFTY_DISC	CHAR	4
SFTY_DSCNT	Percentage of Safety Discount		CMS_DTE_SAFETY_DSCNT	DEC	6
SFTY_AMOUNT	Amount of Safety Discount		CMS_DTE_SAFETY_AMT	CURR	9
SFTY_AMT_CURR	Currency of the Safety Discount Amount		CMS_DTE_SAFETY_AMT_CURR	CUKY	10	TCURC
OBJSYSID	Object System Reference ID		CMS_DTE_OBJ_SYSID	CHAR	12
.INCLUDE	VALUATION_DATA			CMS_STR_VALUATION_DATA	0
VALUATION_TYP	Type of Valuation Check performed on Collateral Object		CMS_DTE_IND_VALN_TYP	CHAR	4
UNIT_VALN_FREQ	Indicator: Units of time for revaluation of an asset		CMS_DTE_IND_AST_VALN_FREQ_UNIT	CHAR	4
PERIOD_VALN_FREQ	Revaluation Period for an Asset		CMS_DTE_AST_VALN_FREQ_PERIOD	NUMC	8
PAST_VALUED_DATE	Last Date on which the Asset was Valued		CMS_DTE_VALN_DATE	DATS	16
START_DATE	Date on which the First Valuation is Performed on the Asset		CMS_DTE_START_DATE	DATS	16
END_DATE	Date on which the Last Valuation is Performed on the Asset		CMS_DTE_END_DATE	DATS	16
.INCLUDE				CMS_STR_LND_RTE_DATA	0
LENDING_RATE_IND	Indicator to specify if Asset has a Default Lending Rate		CMS_DTE_IND_LND_RTE	CHAR	4
.INCLUDE	LENDING_RATE			CMS_STR_LENDING_RATE	0
LENDING_RATE1	Lending Rate 1		CMS_DTE_LRTE_PCT1	DEC	6
LENDING_RATE2	Lending Rate 2		CMS_DTE_LRTE_PCT2	DEC	6
LENDING_RATE3	Lending Rate 3		CMS_DTE_LRTE_PCT3	DEC	6
LENDING_RATE4	Lending Rate 4		CMS_DTE_LRTE_PCT4	DEC	6
LENDING_RATE5	Lending Rate 5		CMS_DTE_LRTE_PCT5	DEC	6
.INCLUDE	LIQUIDATION_DATA			CMS_STR_LIQUIDATION_DATA	0
LIQD_TYP	Liquidation Type		CMS_DTE_LIQD_TYP	CHAR	12	TCMS_AST_LTYP
LIQD_REASON	Liquidation Reason		CMS_DTE_ATT_ID_TY_AST004	CHAR	12	TCMS_ATT_ID_TY
LIQD_DATE	Date on which the Collateral was Liquidated		CMS_DTE_LIQD_DATE	DATS	16
LIQD_AMT	Returns from the Liquidation of Collateral		CMS_DTE_LIQD_VALUE	CURR	9
LIQD_CURR	Currency of Liquidation Value		CMS_DTE_LIQD_CURR	CUKY	10	TCURC
EXP_PRCD_AMNT	Expected Proceed Amount		CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CURR	9
EXP_PRCD_CURR	Currency: Expected Proceed		CMS_DTE_LIQ_EXP_PRCD_CURR	CUKY	10	TCURC
EXP_ACC_DATE	Expected accrual date		CMS_DTE_LIQ_EXP_ACCRUAL_DATE	DATS	16
OBJ_EXP_PRC_TIME	Expected Time of Proceeds		CMS_DTE_LIQ_OBJ_EXP_PRO_DATE	DATS	16
.INCLUDE				CMS_STR_LIQ_ACC_DET	0
ACC_NUMBER_LIQ	Account number for liquidation proceeds		CMS_DTE_LIQ_ACC_NUMBER	CHAR	70
BANK_CNTRY_LIQ	Key of Bank Country/Region		CMS_DTE_LIQ_BNK_CTRY_KY	CHAR	6	T005
BANK_KEY_LIQ	Bank Key		CMS_DTE_LIQ_BNK_KEY	CHAR	30
BANK_CTRLKEY_LIQ	Bank Control Key		BKONT	CHAR	4
.INCLUDE	VERIFICATION_DATA			CMS_STR_VERIFICATION_DATA	0
UNIT_VERF_FREQ	Indicator: Units of time for verification of an asset		CMS_DTE_IND_AST_VERF_FREQ_UNIT	CHAR	4
PERIOD_VERF_FREQ	Statement Period for an Asset		CMS_DTE_AST_VERF_FREQ_PERIOD	NUMC	8
LAST_VERF_DATE	Last Verification Date		CMS_DTE_AST_VERF_DATE	DATS	16
.INCLUDE				CMS_STR_AST_VALUE	0
NOM_VALUE	Nominal Value of the Asset		CMS_DTE_AST_NOMINAL_VALUE	CURR	9
NOM_VALUE_CURR	Currency of Nominal value		CMS_DTE_AST_NOMINAL_VALUE_CURR	CUKY	10	TCURC
AST_VALUE	Final Asset Value		CMS_DTE_AST_VALUE	CURR	9
AST_VALUE_CURR	Currency of the Final Asset Value		CMS_DTE_AST_VALUE_CURR	CUKY	10	TCURC
QUANTITY	Quantity		CMS_DTE_QTY	QUAN	7
UNIT_OF_MEASURE	Unit of Measure of Quantity		CMS_DTE_UNIT	UNIT	6	T006
REC_AT	Asset Value Recording Timestamp		CMS_DTE_REC_AT	DEC	8
.INCLUDE	PURCHASE_PRICE_DATA			CMS_STR_AST_PUR_PRICE_DATA	0
PUR_PRICE	Purchase Price of the Asset		CMS_DTE_AST_PURCHASE_PRICE	CURR	9
PUR_PRICE_CURR	Currency of Purchase Price		CMS_DTE_AST_PUR_PRICE_CURR	CUKY	10	TCURC
PUR_DATE	Date of Purchase		CMS_DTE_AST_PUR_PRICE_DATE	DATS	16
ORI_VALUE	Original Protection of the Asset		CMS_DTE_AST_ORIGINAL_VALUE	CURR	9
ORI_VALUE_CURR	Currency of the Original Protection Value		CMS_DTE_ORI_VALUE_CURR	CUKY	10	TCURC
.INCLUDE				CMS_STR_ADMINORG	0
ADMIN_ORG_UNIT	Administration Organizational Unit		CMS_DTE_ADMINORG	CHAR	24
.INCLUDE				CMS_STR_BANKAREA	0
BANKAREA	Bank Area in Collateral Management		CMS_DTE_BANKAREA	CHAR	8	*
.INCLUDE	ORG_UNIT			CMS_STR_AST_ORG_UNIT	0
ORG_UNIT1	Organizational Unit 1 of an Asset		CMS_DTE_AST_ORG_UNIT1	CHAR	20	*
ORG_UNIT2	Organizational Unit 2 of an Asset		CMS_DTE_AST_ORG_UNIT2	CHAR	20	*
ORG_UNIT3	Organizational Unit 3 of an Asset		CMS_DTE_AST_ORG_UNIT3	CHAR	20	*
ORG_UNIT4	Organizational Unit 4 of an Asset		CMS_DTE_AST_ORG_UNIT4	CHAR	20	*
ORG_UNIT5	Organizational Unit 5 of an Asset		CMS_DTE_AST_ORG_UNIT5	CHAR	20	*
.INCLUDE	CHG_HISTORY			CMS_STR_CHG_HISTORY	0
CREATED_BY	Login ID of the User who created the Record		CMS_DTE_USER	CHAR	24
CREATED_AT	Creation Timestamp		CMS_DTE_CREATED_AT	DEC	8
CHANGED_BY	Last Changed By		CMS_DTE_LAST_CHNG_USER	CHAR	24
CHANGED_AT	Change Timestamp		CMS_DTE_CHANGED_AT	DEC	8
SOURCEOFENTRY	Source of Entry		CMS_DTE_SOURCE_OF_ENTRY	CHAR	64
.INCLUDE				CMS_STR_NXT_REVAL_DATE	0
NXT_VALUED_DATE	Next revalution date of object		CMS_DTE_NXT_VALN_DATE	DATS	16