SAP ABAP Table CMS_STR_COR_SEC_REQ (Securities)

Hierarchy

☛

EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷

FS-CMS (Application Component) Collateral Management System
⤷

CMS_COR (Package) Correspondence serivce for CMS

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_COR_SEC_REQ	Table Relationship Diagram
Short Description	Securities

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description
1	WA_SEC_GEN	DFKKCOH		STRU	0	0
2	MANDT	MANDT	MANDT	CLNT	3	0	Client
3	COTYP	COTYP_KK	COTYP_KK	CHAR	4	0	Correspondence Type
4	COKEY	COKEY_KK	COKEY_KK	CHAR	36	0	Correspondence key
5	UNAME	SYUNAME	SYCHAR12	CHAR	12	0	User Name
6	CDATE	COCDT_KK	SYDATS	DATS	8	0	Created On
7	CTIME	COCTM_KK	SYTIME	TIMS	6	0	Time of Creation (to the Second)
8	GPART	CREC_GP_KK	BU_PARTNER	CHAR	10	0	Correspondence Recipient
9	GPART_GUID	CREC_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Correspondence Recipient (GUID)
10	GPART_ADR_KIND	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
11	ORG_GPART	CREC_ORG_GP_KK	BU_PARTNER	CHAR	10	0	Original Correspondence Recipient
12	ORG_GPART_GUID	CREC_ORG_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Original Correspondence Recipient (GUID)
13	ADD_GPART	CREC_GP_ADD_KK	BU_PARTNER	CHAR	10	0	Additional Business Partner for Correspondence Recipient
14	ADD_GPART_GUID	CREC_GP_ADD_GUID_KK	SYSUUID_C	CHAR	32	0	Addit. Business Partner for Correspondence Recipient GUID
15	ADD_GPART_CAT	CREC_GP_ADD_CAT_KK	CORR_CREC_ADD_CAT_KK	CHAR	1	0	Type of Additional Correspondence Recipient
16	VKONT	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
17	VTREF	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
18	ADR_VALID_ON	CREC_AD_VALID_ON_KK	TZNTSTMPS	DEC	15	0	Address of Correspondence Recipient Valid On
19	ADRNR	CREC_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Recipient
20	ADR_GUID	CREC_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Recipient
21	ADRNR_INDEP_COMM	CREC_AD_INDEP_COMM_KK	AD_ADDRNUM	CHAR	10	0	Address Number for Address-Independent Communication
22	AGPART	CSEN_GP_KK	BU_PARTNER	CHAR	10	0	Sending Business Partner
23	AGPART_GUID	CSEN_GP_GUID_KK	SYSUUID_C	CHAR	32	0	Sender (GUID)
24	AGPART_ADR_KIND	CORR_ADR_KIND_KK	BU_ADRKIND	CHAR	10	0	Address Type Of Correspondence Recipient
25	AADRNR	CSEN_AD_KK	AD_ADDRNUM	CHAR	10	0	Address Number of Correspondence Sender
26	AADR_GUID	CSEN_AD_GUID_KK	SYSUUID_C	CHAR	32	0	Address GUID of Correspondence Sender
27	FORMKEY	FORMKEY	FORMKEY	CHAR	30	0	Application form
28	FORMKEY_RDI	FORMKEY	FORMKEY	CHAR	30	0	Application form
29	ENTID1	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
30	DATA1	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
31	ENTID2	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
32	DATA2	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
33	ENTID3	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
34	DATA3	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
35	ENTID4	ENTID_KK	ENTID_KK	CHAR	4	0	Correspondence data
36	DATA4	CDATA_KK	CDATA_KK	CHAR	32	0	Correspondence Data Field
37	CSORT	CSORT_KK	CORR_TXT50	CHAR	50	0	Correspondence Sort Field
38	XCODT	XCODT_KK	XFELD	CHAR	1	0	Data Part Is Used
39	XCODT_CLUST	XCODT_CLUST_KK	XFELD	CHAR	1	0	Cluster Data Part is Used
40	LAUFD	CORR_LAUFD_KK	DATUM	DATS	8	0	Date ID for Creation Run
41	LAUFI	CORR_LAUFI_KK	CORR_LAUFI_KK	CHAR	6	0	Additional ID Characteristic for Creation Run
42	XTEST	XTEST_KK	XFELD	CHAR	1	0	Correspondence is Result of Test
43	COPRI	COPRI_KK	SYDATS	DATS	8	0	Print Date
44	COIDT	COIDT_KK	SYDATS	DATS	8	0	Date of Issue
45	COITM	COITM_KK	SYTIME	TIMS	6	0	Issue Time to the Second
46	SPRAS	SPRAS	SPRAS	LANG	1	0	Language Key
47	SALWA	CORR_BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency
48	SALBE	CORR_BETRH_KK	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
49	SENDCONTROL	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
50	PERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
51	APERSNUMBER	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number
52	BUKRS	CORR_BUKRS	CORR_BUKRS	CHAR	4	0	Company Code in Correspondence
53	CORR_ROLE	CORR_ROLE_KK	CORR_ROLE_KK	CHAR	4	0	Correspondence Roles
54	COPRI_LAUFD	COPRI_LAUFD_KK	DATUM	DATS	8	0	Date ID for Print Run
55	COPRI_LAUFI	COPRI_LAUFID_KK	COPRI_LAUFID_KK	CHAR	6	0	ID Characteristic for Run
56	PROCESS_ID_	CORR_PROCESS_ID_KK		CHAR	36	0	Business Process ID
57	NO_DOCPARTS	CORR_NO_DOCPARTS_KK		NUMC	4	0	Number of Document Parts
58	DOCPART_ROLE	CORR_DOCPART_ROLE_KK	CORR_DOCPART_ROLE_KK	CHAR	1	0	Document Part Role
59	XTRIAL	XTRIAL_KK	XFELD	CHAR	1	0	Correspondence Request is Test
60	XREPRINT	XREPRINT_KK	XFELD	CHAR	1	0	Recreate Correspondence
61	.INCLUDE				0	0
62	SUBAP	CORR_SUBAP_KK	CORR_SUBAP_KK	CHAR	1	0	Subapplication Indicator in Correspondence
63	XDELETE	X_CORR_DELETE_KK	XFELD	CHAR	1	0	Correspondence Is Logically Deleted
64	PRINT_MODE	PRINT_MODE_KK	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
65	X_NO_ARC	X_NO_ARC_KK	XFELD	CHAR	1	0	SAP ArchiveLink Object ID Part Is Not Used
66	X_DOCPART_LIST	X_DOCPART_LIST_KK	XFELD	CHAR	1	0	Document Part List Is Used
67	.INCLU--AP				0	0	CMS appends for DFKKCOH
68	.INCLU-CMS				0	0	CMS include for DFKKCOH
69	OBJECT_IDCMS	CMS_DTE_OBJECT_ID	SYSUUID	RAW	16	0	Object Identification Number
70	FLG_ORIGINALCMS	CMS_DTE_FLG_ORIG	CMS_FLG	CHAR	1	0	Flag to indicate if the document is original or duplicate
71	SENDCONTROLCMS	SENDCONTROL	ESENDCONTROL	CHAR	4	0	Dispatch Control
72	.INCLU--AP				0	0	Loans Append for DFKKCOH
73	.INCLU-FVD				0	0	Loans Include for DFKKCOH
74	PRODUCTTYPEFVD	VVSART	VVSART	CHAR	3	0	Product Type
75	BP_ROLEFVD	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role
76	BP_ROLETYPEFVD	BP_ROLE	BP_ROLE	CHAR	4	0	Business Partner Role Type
77	SOBJECTFVD	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
78	CORR_ACTIVITYFVD	KORRVORF	KORRVORF	NUMC	4	0	Correspondence activity
79	REFERENCEDATEFVD	TB_CORR_REFERENCE_DATE	DATUM	DATS	8	0	Reference Date for Creating Correspondence
80	WA_RECEIVER	CMS_STR_BPID		STRU	0	0
81	BU_PARTNERID	CMS_DTE_BPID	CMS_BPID	CHAR	32	0	Business Partner Identification Number
82	BP_DESCRIPTION	CMS_DTE_BP_ADDR_DESC	CMS_BP_ADDR_DESC	CHAR	60	0	Address description of Business Partner
83	WA_SEC_ACT	CMS_STR_SEC_ACC_MAP_GET		STRU	0	0
84	.INCLUDE				0	0	Structure for Account GUID
85	SEC_ACC_GUID	CMS_DTE_SEC_ACC_GUID	SYSUUID	RAW	16	0	GUID for securities account
86	.INCLUDE				0	0	Structure for account id of a securities account
87	DEPO_BANK_ID	CMS_DTE_SEC_DEPO_BNK_ID	CMS_SEC_DEPO_BNK_ID	CHAR	18	0	Depository Bank Identification
88	ACCOUNT_NUMBER	CMS_DTE_SEC_ACC_NUMBER	CMS_SEC_ACC_ID	CHAR	20	0	Securities Account Identification Number
89	.INCLUDE				0	0	Description of the securities account
90	SEC_ACC_DESC	CMS_DTE_SEC_ACC_DESC	CMS_SEC_DESC	CHAR	30	0	Description of the Securities Account
91	ACC_OLD_REF_NO	CMS_DTE_SEC_ACC_REF_NO	CMS_SEC_EXT_REFID	CHAR	32	0	ID of a Securities Account Referenced from External System
92	.INCLUDE				0	0	Valuation details of the securities account
93	SEC_ACC_VAL	CMS_DTE_SEC_ACC_VAL_AMT	CMS_SEC_AMOUNT	CURR	17	2	Value of the Securities Account
94	SEC_ACC_VAL_CURR	CMS_DTE_SEC_ACC_VAL_CURR	WAERS	CUKY	5	0	Currency of Securities Account Value
95	VAL_DATE	CMS_DTE_SEC_ACC_VAL_DATE	CMS_DATE	DATS	8	0	Date of last valuation
96	.INCLUDE				0	0	Administrative organization unit
97	ADMIN_ORG_UNIT	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
98	.INCLUDE				0	0	Bank area
99	BANKAREA	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
100	.INCLUDE				0	0	Structure with Asset Details for Table CMS_AST
101	.INCLUDE				0	0	Basic Asset data
102	RISK_CODE	CMS_DTE_SEC_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
103	SFTY_IND	CMS_DTE_SEC_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates that the asset has a default sfty discount or not
104	SFTY_DSCNT	CMS_DTE_SEC_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Safety discount
105	SFTY_AMOUNT	CMS_DTE_SEC_SAFETY_AMT	CMS_SEC_AMOUNT	CURR	17	2	Safety discount as an amount
106	SFTY_AMT_CURR	CMS_DTE_SEC_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety discount amount
107	.INCLUDE				0	0	Valuation data
108	UNIT_VALN_FREQ	CMS_DTE_SEC_IND_FREQUENCY	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator : Valuation Frequency of Securities Account
109	PERIOD_VALN_FREQ	CMS_DTE_SEC_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Period of revaluation for securities
110	START_DATE	CMS_DTE_SEC_START_DATE	CMS_DATE	DATS	8	0	Valuation Start date
111	END_DATE	CMS_DTE_SEC_END_DATE	CMS_DATE	DATS	8	0	Valuation End date
112	.INCLUDE				0	0	Lending rate data
113	LENDING_RATE_IND	CMS_DTE_SEC_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicates that the asset has a default lending rate or not
114	.INCLUDE				0	0	Lending rates
115	LENDING_RATE1	CMS_DTE_SEC_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending rate 1
116	.INCLUDE				0	0	Liquidation rights data
117	LIQD_TYP	CMS_DTE_SEC_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation type
118	LIQD_REASON	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
119	LIQD_DATE	CMS_DTE_SEC_LIQD_DATE	CMS_DATE	DATS	8	0	Date of Liquidation of Collateral
120	LIQD_AMT	CMS_DTE_SEC_LIQD_VALUE	CMS_SEC_AMOUNT	CURR	17	2	Proceeds obtained from liquidation of the collateral
121	LIQD_CURR	CMS_DTE_SEC_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation value
122	.INCLUDE				0	0	Account for liquidation proceeds
123	ACC_NUMBER_LIQ	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
124	BANK_CNTRY_LIQ	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
125	BANK_KEY_LIQ	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
126	BANK_CTRLKEY_LIQ	BKONT	BKONT	CHAR	2	0	Bank Control Key
127	.INCLUDE				0	0	AST PKy and Type and Parent GUID
128	AST_GUID	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
129	AST_TYP	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type
130	PARENT_GUID	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
131	.INCLUDE				0	0	Structure for Asset values
132	.INCLUDE				0	0	Structure for Asset values
133	NOM_VALUE	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
134	NOM_VALUE_CURR	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
135	AST_VALUE	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
136	AST_VALUE_CURR	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
137	QUANTITY	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
138	UNIT_OF_MEASURE	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
139	REC_AT	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
140	.INCLUDE				0	0	Purchase price data
141	PUR_PRICE	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
142	PUR_PRICE_CURR	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
143	PUR_DATE	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
144	.INCLUDE				0	0	Organization unit structure:SEC
145	ORG_UNIT1	CMS_DTE_SEC_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1: Assets
146	ORG_UNIT2	CMS_DTE_SEC_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2: Assets
147	ORG_UNIT3	CMS_DTE_SEC_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3: Assets
148	ORG_UNIT4	CMS_DTE_SEC_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4: Assets
149	ORG_UNIT5	CMS_DTE_SEC_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5: Assets
150	.INCLUDE				0	0	Structure for history
151	CREATED_BY	CMS_DTE_SEC_CR_BY	CMS_USER	CHAR	12	0	Securities Add-On User
152	CREATED_DATE	CMS_DTE_SEC_CR_ON	CMS_DATE	DATS	8	0	Created On
153	CREATED_TIME	CMS_DTE_SEC_CR_AT	CMS_TIME	TIMS	6	0	Created At
154	LAST_CHG_BY	CMS_DTE_SEC_CH_BY	CMS_USER	CHAR	12	0	Last Changed By
155	LAST_CHG_DATE	CMS_DTE_SEC_CH_ON	CMS_DATE	DATS	8	0	Last Changed on
156	LAST_CHG_TIME	CMS_DTE_SEC_CH_AT	CMS_TIME	TIMS	6	0	Last Changed At
157	WA_SENDER	P1028		STRU	0	0
158	.INCLUDE				0	0	Key Structure for Infotype Structures PNNNN
159	MANDT	MANDT	MANDT	CLNT	3	0	Client
160	PLVAR	PLVAR	PLVAR	CHAR	2	0	Plan Version
161	OTYPE	OTYPE	OTYPE	CHAR	2	0	Object Type
162	OBJID	OBJEKTID	NUM08	NUMC	8	0	Object ID
163	INFTY	INFOTYP	INFOTYP	CHAR	4	0	Infotype
164	SUBTY	SUBTYP	SUBTYP	CHAR	4	0	Subtype
165	ISTAT	ISTAT_D	ISTAT	CHAR	1	0	Planning Status
166	PRIOX	PRIOX	CHAR2	CHAR	2	0	Priority
167	BEGDA	BEGDATUM	DATUM	DATS	8	0	Start Date
168	ENDDA	ENDDATUM	DATUM	DATS	8	0	End Date
169	VARYF	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
170	SEQNR	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
171	.INCLUDE				0	0	Infotype Administration Data
172	AEDTM	AEDTM	DATUM	DATS	8	0	Changed on
173	UNAME	USRNAME	CHAR12	CHAR	12	0	User Name
174	REASN	REASN	CHAR2	CHAR	2	0	Reason
175	HISTO	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
176	ITXNR	ITXNR	NUM08	NUMC	8	0	Text Module for Infotype
177	.INCLUDE				0	0	Infotype 1028 Fields
178	CNAME	CNAME	TEXT25	CHAR	25	0	Address Supplement (c/o)
179	STRAS	PD_STRAS	TEXT30	CHAR	30	0	House Number and Street
180	ORT01	KORT	TEXT40	CHAR	40	0	City
181	PSTLZ	PD_PSTLZ	PSTLZ	CHAR	10	0	Postal Code
182	LAND1	KLAND	LAND1	CHAR	3	0	Country
183	TELNR	TELENR	CHAR25	CHAR	25	0	Telephone Number
184	FAXNR	FAXNR	CHAR25	CHAR	25	0	Fax Number
185	ENTKM	ENTKM	DEC3	DEC	3	0	Distance in Kilometers
186	BUILD	BUILD	BUILD	CHAR	8	0	Building
187	ROOM1	ROOM1	CHAR8	CHAR	8	0	Physical Room Number
188	ADRNR	ADRNR	ADRNR	CHAR	10	0	Address
189	REGIO	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
190	STRS2	STRAS_GP	TEXT35	CHAR	35	0	House number and street
191	HAUSN	HAUSN_BAS	CHAR6	CHAR	6	0	House number
192	.INCLUDE				0	0
193	T_SEC_SYS_ST	CMS_TAB_COR_SEC_SYS_STATUS		TTYP	0	0
194	T_SEC_USR_ST	CMS_TAB_COR_SEC_USR_STATUS		TTYP	0	0
195	T_SEC_NOTES	CMS_TAB_COR_SEC_NOTES		TTYP	0	0
196	T_SEC_DOC	CMS_TAB_COR_SEC_DOC		TTYP	0	0
197	T_SEC_BP	CMS_TAB_COR_SEC_BP		TTYP	0	0
198	T_SEC_POS	CMS_TAB_COR_SEC_POS		TTYP	0	0