SAP ABAP Table CMS_STR_RIG_GET_DATA_API (Right GET data API layer)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-RIG (Application Component) Rights
     ⤷ CMS_OMS_RIG (Package) Collateral Management Rights

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_RIG_GET_DATA_API	Table Relationship Diagram
Short Description	Right GET data API layer

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	Rights primary key
2	RIG_GUID	☐	CMS_DTE_RIG_GUID	SYSUUID	RAW	16	0	Rights GUID
3	.INCLUDE	☐				0	0	Semantic Key for insurance
4	RIG_CATEGORY	☐	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category	*
5	RIG_TYP	☐	CMS_DTE_RIG_TYP	CMS_RIG_TYP	CHAR	6	0	Right Type
6	RIG_ID	☐	CMS_DTE_RIG_ID	CMS_MOV_ID	CHAR	40	0	Rights ID
7	.INCLUDE	☐				0	0	Right Specific data
8	.INCLUDE	☐				0	0	Rights Common data
9	ADD_DESCR	☐	CMS_DTE_CLM_DESC	CMS_DSC	CHAR	30	0	Additional description of the right
10	DURATION_BEGIN	☐	CMS_DTE_RIG_BEGIN	CMS_DATE	DATS	8	0	Start date of the right
11	DURATION_END	☐	CMS_DTE_RIG_END	CMS_DATE	DATS	8	0	Validity End Date of the Right or Patent
12	CLASSIFICATION	☐	CMS_DTE_MOV_TYPE_FEAT	CMS_MOV_TYPE_FEAT	CHAR	6	0	Classification	TCMS_OMS_FEAT
13	.INCLUDE	☐				0	0	Common OMS data
14	EXT_ITM_NO	☐	CMS_DTE_OMS_EXT_ITM_NO	CMS_OMS_ID	CHAR	40	0	Ext. Item no / Number for identification of the objects
15	EXT_REFERENCE	☐	CMS_DTE_OMS_REF_ID	CMS_OMS_REFID	CHAR	32	0	Reference number for the legacy system
16	.INCLUDE	☐				0	0	Right Specific data
17	NOTAR_DATE	☐	CMS_DTE_RIG_NOT_DAT	DATUM	DATS	8	0	Notarization Date
18	REGIS_DATE	☐	CMS_DTE_RIG_REG_DAT	DATUM	DATS	8	0	Date of Patent Registration
19	PATENT_NO	☐	CMS_DTE_RIG_PATENT_NO	CMS_OMS_ID	CHAR	40	0	Patent Number
20	REGISTRY_NO	☐	CMS_DTE_RIG_REG_NO	CMS_RIG_REG_NO	CHAR	20	0	No. of the Register in the Patent Office
21	PATENT_OFFICE	☐	CMS_DTE_RIG_PT_OFF	CMS_DSC	CHAR	30	0	Patent Office
22	ADD_PPTY_RIG	☐	CMS_DTE_RIG_AV_PTY	CMS_ATT_ID_TYP	CHAR	6	0	Additional Property Rights that are Available	TCMS_ATT_ID_TY
23	.INCLUDE	☐				0	0	Link to rights primary key
24	PAT_PARENT_GUID	☐	CMS_DTE_PARENT_GUID	SYSUUID	RAW	16	0	Links to Parent Patent - GUID of the Parent
25	.INCLUDE	☐				0	0	Claim data
26	DUE_DATE	☐	CMS_DTE_CLM_DUE_DATE	DATUM	DATS	8	0	Due date of a claim
27	COMPOSITION	☐	CMS_DTE_CLM_COMP	CMS_DSC	CHAR	30	0	Composition of the claim
28	SAV_SUM	☐	CMS_DTE_CLM_SAV_SUM	CMS_SEC_PCT	DEC	10	6	Savings sum in Percentage (In building savings contracts)
29	PROVBADDEBT_AMT	☐	CMS_DTE_CLM_DBTDBT_AMT	CMS_AMOUNT	CURR	17	2	Provision doubtful debt amount
30	PROVBADDEBT_CURR	☐	CMS_DTE_CLM_DBTDBT_CURR	WAERS	CUKY	5	0	Currency of Provision of doubfull debt	*
31	.INCLUDE	☐				0	0	Address ID
32	ADDR_ID	☐	CMS_DTE_CLM_ADDRESS	AD_ADDRNUM	CHAR	10	0	Address of the object (for build.sav.contr./rental claim)	*
33	.INCLUDE	☐				0	0	Account Details
34	ACC_NUMBER	☐	CMS_DTE_CLM_ACC_NUMBER	BANKN35	CHAR	35	0	Account number
35	BANK_COUNTRY_KEY	☐	CMS_DTE_CLM_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
36	BANK_KEY	☐	CMS_DTE_CLM_BNK_KEY	BANKK	CHAR	15	0	Bank Key
37	BANK_CTRL_KEY	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
38	.INCLUDE	☐				0	0	Structure with Asset Details for Table CMS_AST
39	.INCLUDE	☐				0	0	Basic Asset data
40	DESCRIPTION	☐	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
41	OBJECT_REF_ID	☐	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
42	OBJECT_TYP	☐	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
43	COUNTRY_KEY	☐	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country	*
44	RISK_CODE	☐	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code	*
45	SFTY_IND	☐	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
46	SFTY_DSCNT	☐	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
47	SFTY_AMOUNT	☐	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
48	SFTY_AMT_CURR	☐	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount	TCURC
49	OBJSYSID	☐	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
50	.INCLUDE	☐				0	0	Valuation data
51	VALUATION_TYP	☐	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
52	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
53	PERIOD_VALN_FREQ	☐	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
54	PAST_VALUED_DATE	☐	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
55	START_DATE	☐	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
56	END_DATE	☐	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
57	.INCLUDE	☐				0	0	Lending rate data
58	LENDING_RATE_IND	☐	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
59	.INCLUDE	☐				0	0	Lending rates structure
60	LENDING_RATE1	☐	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
61	LENDING_RATE2	☐	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
62	LENDING_RATE3	☐	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
63	LENDING_RATE4	☐	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
64	LENDING_RATE5	☐	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
65	.INCLUDE	☐				0	0	Liquidation rights data
66	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
67	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason	TCMS_ATT_ID_TY
68	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
69	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
70	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value	TCURC
71	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
72	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed	TCURC
73	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
74	.INCLUDE	☐				0	0	Account for liquidation proceeds
75	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
76	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key	T005
77	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
78	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
79	.INCLUDE	☐				0	0	Verfication Data
80	UNIT_VERF_FREQ	☐	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
81	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
82	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
83	.INCLUDE	☐				0	0	AST PKy and Type and Parent GUID
84	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST
85	AST_TYP	☐	CMS_DTE_AST_TYP	CMS_AST_TYP	CHAR	6	0	Asset Type	*
86	PARENT_GUID	☐	CMS_DTE_SAS_PAR_GUID	SYSUUID	RAW	16	0	Asset Guid as a parent GUID for a sub-asset
87	.INCLUDE	☐				0	0	Structure for Asset values
88	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
89	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value	TCURC
90	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
91	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value	TCURC
92	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
93	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
94	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
95	.INCLUDE	☐				0	0	Purchase price data
96	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
97	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price	TCURC
98	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
99	.INCLUDE	☐				0	0	Administrative organization unit
100	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
101	.INCLUDE	☐				0	0	Bank area
102	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
103	.INCLUDE	☐				0	0	Organization unit structure
104	ORG_UNIT1	☐	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1	*
105	ORG_UNIT2	☐	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2	*
106	ORG_UNIT3	☐	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3	*
107	ORG_UNIT4	☐	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4	*
108	ORG_UNIT5	☐	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5	*
109	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
110	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
111	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
112	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
113	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
114	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_RIG_GET_DATA_API	ADD_PPTY_RIG	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_STR_RIG_GET_DATA_API	AST_VALUE_CURR	TCURC	WAERS
3	CMS_STR_RIG_GET_DATA_API	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
4	CMS_STR_RIG_GET_DATA_API	BANK_COUNTRY_KEY	T005	LAND1	REF	1	CN
5	CMS_STR_RIG_GET_DATA_API	CLASSIFICATION	TCMS_OMS_FEAT	TYPE_FEAT	REF
6	CMS_STR_RIG_GET_DATA_API	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
7	CMS_STR_RIG_GET_DATA_API	LIQD_CURR	TCURC	WAERS
8	CMS_STR_RIG_GET_DATA_API	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
9	CMS_STR_RIG_GET_DATA_API	NOM_VALUE_CURR	TCURC	WAERS
10	CMS_STR_RIG_GET_DATA_API	PUR_PRICE_CURR	TCURC	WAERS
11	CMS_STR_RIG_GET_DATA_API	SFTY_AMT_CURR	TCURC	WAERS	REF	1	CN
12	CMS_STR_RIG_GET_DATA_API	UNIT_OF_MEASURE	T006	MSEHI	REF	1	CN

History

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