SAP ABAP Table CMS_STR_RIG_DATA_SCR (Rights - Own Data (Screen))
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CMS (Application Component) Collateral Management System
⤷ CMS_OMS_RIG_UI (Package) Collateral Management Rights
⤷ FS-CMS (Application Component) Collateral Management System
⤷ CMS_OMS_RIG_UI (Package) Collateral Management Rights
Basic Data
Table Category | INTTAB | Structure |
Structure | CMS_STR_RIG_DATA_SCR | Table Relationship Diagram |
Short Description | Rights - Own Data (Screen) |
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 | TCURC | |
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 | T005 | |
44 | RISK_CODE | CMS_DTE_RISK_CODE | CMS_RISK_CODE | CHAR | 6 | 0 | Risk Code | TCMS_RISKCODE | |
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 | Administration organization unit (key conversion) | |||||
100 | ADMIN_ORG_UNIT | CMS_DTE_ADMINORG_KEY | CMS_ADMINORG_KEY | CHAR | 12 | 0 | Administration Organizational Unit (Key conversion) | ||
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 | Active System Statuses | |||||
110 | SYS_STAT | CMS_DTE_SYS_STAT_LINE | TEXT40 | CHAR | 40 | 0 | System Status | ||
111 | .INCLUDE | 0 | 0 | Active User Statuses | |||||
112 | USR_STAT | CMS_DTE_USR_STAT_LINE | TEXT40 | CHAR | 40 | 0 | User Status | ||
113 | .INCLUDE | 0 | 0 | New System Statuses | |||||
114 | SYS_STAT_NEW | CMS_DTE_SYS_STAT_LINE | TEXT40 | CHAR | 40 | 0 | System Status | ||
115 | .INCLUDE | 0 | 0 | New User Statuses | |||||
116 | USR_STAT_NEW | CMS_DTE_USR_STAT_LINE | TEXT40 | CHAR | 40 | 0 | User Status | ||
117 | .INCLUDE | 0 | 0 | Stucture to record history of changes in all application tab | |||||
118 | CREATED_BY | CMS_DTE_USER | CMS_USER | CHAR | 12 | 0 | Login ID of the User who created the Record | ||
119 | CREATED_AT | CMS_DTE_CREATED_AT | TZNTSTMPS | DEC | 15 | 0 | Creation Timestamp | ||
120 | CHANGED_BY | CMS_DTE_LAST_CHNG_USER | CMS_USER | CHAR | 12 | 0 | Last Changed By | ||
121 | CHANGED_AT | CMS_DTE_CHANGED_AT | TZNTSTMPS | DEC | 15 | 0 | Change Timestamp | ||
122 | SOURCEOFENTRY | CMS_DTE_SOURCE_OF_ENTRY | CMS_SOURCE | CHAR | 32 | 0 | Source of Entry | ||
123 | .INCLUDE | 0 | 0 | Change Hsitory Structure (For screen) | |||||
124 | CREATED_DATE | CMS_DTE_DATE | CMS_DATE | DATS | 8 | 0 | Date | ||
125 | CREATED_TIME | CMS_DTE_TIME | CMS_TIME | TIMS | 6 | 0 | Time | ||
126 | CHANGED_DATE | CMS_DTE_DATE | CMS_DATE | DATS | 8 | 0 | Date | ||
127 | CHANGED_TIME | CMS_DTE_TIME | CMS_TIME | TIMS | 6 | 0 | Time | ||
128 | .INCLUDE | 0 | 0 | Structure for Variable object field names | |||||
129 | NOM_VALUE_SCR | CMS_DTE_SCREEN_FLD_NAME | CMS_FLD_TEXT | CHAR | 15 | 0 | Name of the Asset Screen field | ||
130 | AST_VALUE_SCR | CMS_DTE_SCREEN_FLD_NAME | CMS_FLD_TEXT | CHAR | 15 | 0 | Name of the Asset Screen field | ||
131 | OBJECT_REF_ID_SCR | CMS_DTE_SCREEN_FLD_NAME | CMS_FLD_TEXT | CHAR | 15 | 0 | Name of the Asset Screen field | ||
132 | .INCLUDE | 0 | 0 | Bank name | |||||
133 | BANK_NAME | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
134 | .INCLUDE | 0 | 0 | Bank name for rights | |||||
135 | CLM_BANK_NAME | BANKA | TEXT60 | CHAR | 60 | 0 | Name of bank | ||
136 | PARENT_PAT_REF | CMS_DTE_PARENT_PAT_ID | CMS_MOV_ID | CHAR | 40 | 0 | Parent Patent ID |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CMS_STR_RIG_DATA_SCR | ADD_PPTY_RIG | TCMS_ATT_ID_TY | INDICATOR_TYPE | REF | 1 | CN |
2 | CMS_STR_RIG_DATA_SCR | AST_VALUE_CURR | TCURC | WAERS | |||
3 | CMS_STR_RIG_DATA_SCR | BANK_CNTRY_LIQ | T005 | LAND1 | REF | 1 | CN |
4 | CMS_STR_RIG_DATA_SCR | BANK_COUNTRY_KEY | T005 | LAND1 | REF | 1 | CN |
5 | CMS_STR_RIG_DATA_SCR | CLASSIFICATION | TCMS_OMS_FEAT | TYPE_FEAT | REF | ||
6 | CMS_STR_RIG_DATA_SCR | COUNTRY_KEY | T005 | LAND1 | |||
7 | CMS_STR_RIG_DATA_SCR | EXP_PRCD_CURR | TCURC | WAERS | REF | 1 | CN |
8 | CMS_STR_RIG_DATA_SCR | LIQD_CURR | TCURC | WAERS | |||
9 | CMS_STR_RIG_DATA_SCR | LIQD_REASON | TCMS_ATT_ID_TY | INDICATOR_TYPE | |||
10 | CMS_STR_RIG_DATA_SCR | NOM_VALUE_CURR | TCURC | WAERS | |||
11 | CMS_STR_RIG_DATA_SCR | PROVBADDEBT_CURR | TCURC | WAERS | |||
12 | CMS_STR_RIG_DATA_SCR | PUR_PRICE_CURR | TCURC | WAERS | |||
13 | CMS_STR_RIG_DATA_SCR | RISK_CODE | TCMS_RISKCODE | RISK_CODE | |||
14 | CMS_STR_RIG_DATA_SCR | SFTY_AMT_CURR | TCURC | WAERS | REF | 1 | CN |
15 | CMS_STR_RIG_DATA_SCR | UNIT_OF_MEASURE | T006 | MSEHI | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 500 |