CMS_SEC_ACC - Securities account details

Securities account details information is stored in SAP table CMS_SEC_ACC.
It is part of development package CMS_SEC in software component FS-CMS-MD-SEC. This development package consists of objects that can be grouped under "Securities: General tables and programs & Persistence layer".

Fields for table CMS_SEC_ACC

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		CMS_STR_SEC_ACC_PKY	0
SEC_ACC_GUID	GUID for securities account	X	CMS_DTE_SEC_ACC_GUID	RAW	16
.INCLUDE				CMS_STR_SEC_ACC_ID	0
DEPO_BANK_ID	Depository Bank Identification		CMS_DTE_SEC_DEPO_BNK_ID	CHAR	36
ACCOUNT_NUMBER	Securities Account Identification Number		CMS_DTE_SEC_ACC_NUMBER	CHAR	40
.INCLUDE				CMS_STR_SEC_ACC_DESC	0
SEC_ACC_DESC	Description of the Securities Account		CMS_DTE_SEC_ACC_DESC	CHAR	60
ACC_OLD_REF_NO	ID of a Securities Account Referenced from External System		CMS_DTE_SEC_ACC_REF_NO	CHAR	64
.INCLUDE				CMS_STR_SEC_ACC_VAL_DATA	0
SEC_ACC_VAL	Value of the Securities Account		CMS_DTE_SEC_ACC_VAL_AMT	CURR	9
SEC_ACC_VAL_CURR	Currency of Securities Account Value		CMS_DTE_SEC_ACC_VAL_CURR	CUKY	10	TCURC
VAL_DATE	Date of last valuation		CMS_DTE_SEC_ACC_VAL_DATE	DATS	16
.INCLUDE	ADMIN_ORG			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				CMS_STR_SEC_AST_DATA_DB	0
.INCLUDE	BASIC_DATA			CMS_STR_SEC_AST_BASIC_DATA	0
RISK_CODE	Risk Code		CMS_DTE_SEC_RISK_CODE	CHAR	12	*
SFTY_IND	Indicates that the asset has a default sfty discount or not		CMS_DTE_SEC_IND_SFTY_DISC	CHAR	4
SFTY_DSCNT	Safety discount		CMS_DTE_SEC_SAFETY_DSCNT	DEC	6
SFTY_AMOUNT	Safety discount as an amount		CMS_DTE_SEC_SAFETY_AMT	CURR	9
SFTY_AMT_CURR	Currency of the Safety discount amount		CMS_DTE_SEC_SAFETY_AMT_CURR	CUKY	10	TCURC
.INCLUDE	VALUATION_DATA			CMS_STR_SEC_VALUATION_DATA	0
UNIT_VALN_FREQ	Indicator : Valuation Frequency of Securities Account		CMS_DTE_SEC_IND_FREQUENCY	CHAR	4
PERIOD_VALN_FREQ	Period of revaluation for securities		CMS_DTE_SEC_VALN_FREQ_PERIOD	NUMC	8
START_DATE	Valuation Start date		CMS_DTE_SEC_START_DATE	DATS	16
END_DATE	Valuation End date		CMS_DTE_SEC_END_DATE	DATS	16
.INCLUDE				CMS_STR_SEC_LND_RTE_DATA	0
LENDING_RATE_IND	Indicates that the asset has a default lending rate or not		CMS_DTE_SEC_IND_LND_RTE	CHAR	4
.INCLUDE	LENDING_RATE			CMS_STR_SEC_LENDING_RATE	0
LENDING_RATE1	Lending rate 1		CMS_DTE_SEC_LRTE_PCT1	DEC	6
.INCLUDE				CMS_STR_SEC_LIQDTN_DATA_DB	0
LIQD_TYP	Liquidation type		CMS_DTE_SEC_LIQD_TYP	CHAR	12
LIQD_REASON	Liquidation Reason		CMS_DTE_ATT_ID_TY_AST004	CHAR	12
LIQD_DATE	Date of Liquidation of Collateral		CMS_DTE_SEC_LIQD_DATE	DATS	16
LIQD_AMT	Proceeds obtained from liquidation of the collateral		CMS_DTE_SEC_LIQD_VALUE	CURR	9
LIQD_CURR	Currency of Liquidation value		CMS_DTE_SEC_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
.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				CMS_STR_SEC_ORG_UNIT	0
ORG_UNIT1	Organizational Unit 1: Assets		CMS_DTE_SEC_ORG_UNIT1	CHAR	20	*
ORG_UNIT2	Organizational Unit 2: Assets		CMS_DTE_SEC_ORG_UNIT2	CHAR	20	*
ORG_UNIT3	Organizational Unit 3: Assets		CMS_DTE_SEC_ORG_UNIT3	CHAR	20	*
ORG_UNIT4	Organizational Unit 4: Assets		CMS_DTE_SEC_ORG_UNIT4	CHAR	20	*
ORG_UNIT5	Organizational Unit 5: Assets		CMS_DTE_SEC_ORG_UNIT5	CHAR	20	*
.INCLUDE				CMS_STR_SEC_HIST	0
CREATED_BY	Securities Add-On User		CMS_DTE_SEC_CR_BY	CHAR	24
CREATED_DATE	Created On		CMS_DTE_SEC_CR_ON	DATS	16
CREATED_TIME	Created At		CMS_DTE_SEC_CR_AT	TIMS	12
LAST_CHG_BY	Last Changed By		CMS_DTE_SEC_CH_BY	CHAR	24
LAST_CHG_DATE	Last Changed on		CMS_DTE_SEC_CH_ON	DATS	16
LAST_CHG_TIME	Last Changed At		CMS_DTE_SEC_CH_AT	TIMS	12
.INCLUDE	BPCA			CMS_STR_BUSINESS_PROCESS	0
BUPR_ID	Business Process ID		CMS_DTE_BUPR_ID	RAW	16
BUPR_TYPE_CODE	Business Process Type Code		CMS_DTE_BUPR_TYP_CODE	CHAR	12