SAP ABAP Table CMS_STR_BII_SEC_ACC_DETAIL_SNG (CMS-Basel: Securities Account Details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-IS (Application Component) Information System
     ⤷ CMS_BASEL (Package) Basel II

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_BII_SEC_ACC_DETAIL_SNG	Table Relationship Diagram
Short Description	CMS-Basel: Securities Account Details

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	SECURITIES_ACCOUNT_KEY	☐	BAPICMS_STR_SEC_KEYS_GET		STRU	0	0
2	SEC_ACC_IDENTIFIER	☐	BAPICMS_DTE_SEC_ACC_GUID	SYSUUID_C	CHAR	32	0	GUID for Securities Accounts - Primary key
3	ACCOUNT_HOLDING_BANK	☐	BAPICMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository bank identification
4	ACCOUNT_NUMBER	☐	BAPICMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities account number
5	SECURITIES_ACCOUNT_DATA	☐	BAPICMS_STR_SEC_ACC_GET		STRU	0	0
6	ACCOUNT_HOLDING_BANK	☐	BAPICMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository bank identification
7	ACCOUNT_NUMBER	☐	BAPICMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities account number
8	DESCRIPTION	☐	BAPICMS_DTE_SEC_ACC_DESC	CMS_SEC_DESC	CHAR	30	0	Description of the securities account
9	ACCOUNT_OLD_REFERENCE	☐	BAPICMS_DTE_SEC_ACC_REF_NO	CMS_SEC_EXT_REFID	CHAR	32	0	Reference number for an external system
10	ACCOUNT_VALUE	☐	BAPICMS_DTE_SEC_ACC_VAL_AMT	BAPICURR	DEC	23	4	Value of the securities account
11	CURRENCY_ACCOUNT_VALUE	☐	BAPICMS_DTE_SEC_ACC_VAL_CURR	WAERS	CUKY	5	0	Securities Account value Currency
12	CURRENCY_ACCOUNT_VALUE_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
13	VALUATION_DATE	☐	BAPICMS_DTE_SEC_ACC_VAL_DATE	CMS_DATE	DATS	8	0	Date of last valuation
14	ADMINISTRATION_ORG_UNIT	☐	BAPICMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
15	BANKAREA	☐	BAPICMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
16	RISK_CODE	☐	BAPICMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
17	SAFETY_INDICATOR	☐	BAPICMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
18	SAFETY_DISCOUNT	☐	BAPICMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
19	SAFETY_AMOUNT	☐	BAPICMS_DTE_SAFETY_AMT	BAPICURR	DEC	23	4	Safety discount as an amount
20	SAFETY_AMOUNT_CURRENCY	☐	BAPICMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount
21	SAFETY_AMOUNT_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
22	UNIT_VALUATION_FREQUENCY	☐	BAPICMS_DTE_IND_AST_VLN_FQ_UNT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
23	PERIOD_VALUATION_FREQUENCY	☐	BAPICMS_DTE_AST_VLN_FQ_PRD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for an asset
24	START_DATE	☐	BAPICMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
25	END_DATE	☐	BAPICMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
26	DEFAULT_LENDING_RATE_INDICATOR	☐	BAPICMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
27	LENDING_RATE1	☐	BAPICMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
28	LIQUIDATION_TYPE	☐	BAPICMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
29	LIQUIDATION_REASON	☐	BAPICMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
30	LIQUIDATION_DATE	☐	BAPICMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Collateral Liquidation Date
31	LIQUIDATION_AMOUNT	☐	BAPICMS_DTE_LIQD_VALUE	BAPICURR	DEC	23	4	Returns from the Liquidation of Collateral
32	LIQUIDATION_CURRENCY	☐	BAPICMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
33	LIQUIDATION_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
34	ASSET_GUID	☐	BAPICMS_DTE_AST_GUID	SYSUUID_C	CHAR	32	0	GUID for Table CMS_AST
35	ASSET_TYPE	☐	BAPICMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
36	PARENT_GUID	☐	BAPICMS_DTE_AST_PAR_GUID	SYSUUID_C	CHAR	32	0	Asset Guid as a parent GUID for a sub-asset
37	NOMINAL_VALUE	☐	BAPICMS_DTE_AST_NOMINAL_VALUE	BAPICURR	DEC	23	4	Nominal Value of the Asset
38	ASSET_VALUE	☐	BAPICMS_DTE_AST_VALUE	BAPICURR	DEC	23	4	Final Asset Value
39	NOMINAL_VALUE_CURRENCY	☐	BAPICMS_DTE_AST_NOMINL_VAL_CUR	WAERS	CUKY	5	0	Currency of Nominal value
40	NOMINAL_VALUE_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
41	ASSET_VALUE_CURRENCY	☐	BAPICMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the final Asset Value
42	ASSET_VALUE_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
43	QUANTITY	☐	BAPICMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
44	UNIT_OF_MEASURE_FOR_QUANTITY	☐	BAPICMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
45	UNIT_OF_MEASURE_QUANTITY_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement
46	ASSET_VALUE_REC_TIMESTAMP	☐	BAPICMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
47	ORGANIZATION_UNIT1	☐	BAPICMS_DTE_AST_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organization Unit 1 for an Asset
48	ORGANIZATION_UNIT2	☐	BAPICMS_DTE_AST_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organization Unit 2 for an Asset
49	ORGANIZATION_UNIT3	☐	BAPICMS_DTE_AST_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organization Unit 3 for an Asset
50	ORGANIZATION_UNIT4	☐	BAPICMS_DTE_AST_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organization Unit 4 for an Asset
51	ORGANIZATION_UNIT5	☐	BAPICMS_DTE_AST_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organization Unit 5 for an Asset
52	CREATED_BY	☐	BAPICMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
53	CREATED_ON	☐	BAPICMS_DTE_SEC_CR_ON	CMS_DATE	DATS	8	0	Created On
54	CREATED_AT	☐	BAPICMS_DTE_SEC_CR_AT	CMS_TIME	TIMS	6	0	Created At
55	CHANGED_BY	☐	BAPICMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
56	LAST_CHANGED_ON	☐	BAPICMS_DTE_SEC_CH_ON	CMS_DATE	DATS	8	0	Last Changed on
57	LAST_CHANGED_AT	☐	BAPICMS_DTE_SEC_CH_AT	CMS_TIME	TIMS	6	0	Last Changed At
58	SECURITIES_ACCOUNT_POSITIONS	☐	BAPICMS_TAB_SEC_ACC_POS_GET		TTYP	0	0
59	BUSINESS_PARTNER_DATA	☐	BAPICMS_TAB_SEC_BP_GET		TTYP	0	0
60	DOCUMENTS_DATA	☐	BAPICMS_TAB_SEC_DOC_GET		TTYP	0	0
61	NOTES	☐	BAPICMS_TAB_SEC_NOTES_GET		TTYP	0	0
62	USER_STATUS	☐	BAPICMS_TAB_SEC_USR_STAT_GET		TTYP	0	0
63	SYSTEM_STATUS	☐	BAPICMS_TAB_SEC_SYS_STAT_GET		TTYP	0	0
64	CALCULATION_RESULTS	☐	BAPICMS_STR_SEC_CALC_GET		STRU	0	0
65	ACCOUNT_HOLDING_BANK	☐	BAPICMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository bank identification
66	ACCOUNT_NUMBER	☐	BAPICMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities account number
67	ASSET_GUID	☐	BAPICMS_DTE_AST_GUID	SYSUUID_C	CHAR	32	0	GUID for Table CMS_AST
68	RESULT_CURRENCY	☐	BAPICMS_DTE_CALC_RES_CURR	WAERS	CUKY	5	0	Calculations Result Currency
69	RESULT_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
70	LENDING_VALUE_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_VALUE	BAPICURR	DEC	23	4	Lending value Calculation for Asset
71	LENDING_VALUE_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
72	LENDING_LIMIT1_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT1	BAPICURR	DEC	23	4	Lending Limit 1 Calculation for Asset
73	LENDING_LIMIT1_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
74	LENDING_LIMIT2_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT2	BAPICURR	DEC	23	4	Lending Limit 2 Calculation for Asset
75	LENDING_LIMIT2_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
76	LENDING_LIMIT3_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT3	BAPICURR	DEC	23	4	Lending Limit 3 Calculation for Asset
77	LENDING_LIMIT3_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
78	LENDING_LIMIT4_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT4	BAPICURR	DEC	23	4	Lending Limit 4 Calculation for Asset
79	LENDING_LIMIT4_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
80	LENDING_LIMIT5_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT5	BAPICURR	DEC	23	4	Lending Limit 5 Calculation for Asset
81	LENDING_LIMIT5_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
82	LENDING_RANGE1_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE1	BAPICURR	DEC	23	4	Lending Range 1 calculation for Asset
83	LENDING_RANGE1_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
84	LENDING_RANGE2_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE2	BAPICURR	DEC	23	4	Lending Range 2 calculation for Asset
85	LENDING_RANGE2_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
86	LENDING_RANGE3_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE3	BAPICURR	DEC	23	4	Lending Range 3 calculation for Asset
87	LENDING_RANGE3_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
88	LENDING_RANGE4_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE4	BAPICURR	DEC	23	4	Lending Range 4 calculation for Asset
89	LENDING_RANGE4_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
90	LENDING_RANGE5_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE5	BAPICURR	DEC	23	4	Lending Range 5 calculation for Asset
91	LENDING_RANGE5_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
92	CALCULATION_RESULTS_MAIN	☐	BAPICMS_STR_SEC_CALC_GET		STRU	0	0
93	ACCOUNT_HOLDING_BANK	☐	BAPICMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository bank identification
94	ACCOUNT_NUMBER	☐	BAPICMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities account number
95	ASSET_GUID	☐	BAPICMS_DTE_AST_GUID	SYSUUID_C	CHAR	32	0	GUID for Table CMS_AST
96	RESULT_CURRENCY	☐	BAPICMS_DTE_CALC_RES_CURR	WAERS	CUKY	5	0	Calculations Result Currency
97	RESULT_CURRENCY_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
98	LENDING_VALUE_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_VALUE	BAPICURR	DEC	23	4	Lending value Calculation for Asset
99	LENDING_VALUE_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
100	LENDING_LIMIT1_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT1	BAPICURR	DEC	23	4	Lending Limit 1 Calculation for Asset
101	LENDING_LIMIT1_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
102	LENDING_LIMIT2_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT2	BAPICURR	DEC	23	4	Lending Limit 2 Calculation for Asset
103	LENDING_LIMIT2_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
104	LENDING_LIMIT3_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT3	BAPICURR	DEC	23	4	Lending Limit 3 Calculation for Asset
105	LENDING_LIMIT3_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
106	LENDING_LIMIT4_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT4	BAPICURR	DEC	23	4	Lending Limit 4 Calculation for Asset
107	LENDING_LIMIT4_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
108	LENDING_LIMIT5_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_LIMIT5	BAPICURR	DEC	23	4	Lending Limit 5 Calculation for Asset
109	LENDING_LIMIT5_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
110	LENDING_RANGE1_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE1	BAPICURR	DEC	23	4	Lending Range 1 calculation for Asset
111	LENDING_RANGE1_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
112	LENDING_RANGE2_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE2	BAPICURR	DEC	23	4	Lending Range 2 calculation for Asset
113	LENDING_RANGE2_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
114	LENDING_RANGE3_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE3	BAPICURR	DEC	23	4	Lending Range 3 calculation for Asset
115	LENDING_RANGE3_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
116	LENDING_RANGE4_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE4	BAPICURR	DEC	23	4	Lending Range 4 calculation for Asset
117	LENDING_RANGE4_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
118	LENDING_RANGE5_AMOUNT	☐	BAPICMS_DTE_AST_LENDING_RANGE5	BAPICURR	DEC	23	4	Lending Range 5 calculation for Asset
119	LENDING_RANGE5_AMOUNT_ISO	☐	BAPIISOCD	ISOCD	CHAR	3	0	ISO Currency Code
120	CALCULATION_RESULTS_PARTS	☐	BAPICMS_TAB_SEC_SAS_CALC_GET		TTYP	0	0
121	EXTENSIONOUT	☐	BAPIPAREXTAB		TTYP	0	0

History

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