SAP ABAP Table CMS_STR_PAT_DATA_SET (Claims GET data)
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_PAT_DATA_SET   Table Relationship Diagram
Short Description Claims GET data    
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   Rights Common data  
8 ADD_DESCR CMS_DTE_CLM_DESC CMS_DSC CHAR 30   0   Additional description of the right  
9 DURATION_BEGIN CMS_DTE_RIG_BEGIN CMS_DATE DATS 8   0   Start date of the right  
10 DURATION_END CMS_DTE_RIG_END CMS_DATE DATS 8   0   Validity End Date of the Right or Patent  
11 CLASSIFICATION CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification TCMS_OMS_FEAT
12 .INCLUDE       0   0   Common OMS data  
13 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
14 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
15 .INCLUDE       0   0   Right Specific data  
16 NOTAR_DATE CMS_DTE_RIG_NOT_DAT DATUM DATS 8   0   Notarization Date  
17 REGIS_DATE CMS_DTE_RIG_REG_DAT DATUM DATS 8   0   Date of Patent Registration  
18 PATENT_NO CMS_DTE_RIG_PATENT_NO CMS_OMS_ID CHAR 40   0   Patent Number  
19 REGISTRY_NO CMS_DTE_RIG_REG_NO CMS_RIG_REG_NO CHAR 20   0   No. of the Register in the Patent Office  
20 PATENT_OFFICE CMS_DTE_RIG_PT_OFF CMS_DSC CHAR 30   0   Patent Office  
21 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
22 .INCLUDE       0   0   Link to rights primary key  
23 PAT_PARENT_GUID CMS_DTE_PARENT_GUID SYSUUID RAW 16   0   Links to Parent Patent - GUID of the Parent  
24 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
25 .INCLUDE       0   0   Basic Asset data  
26 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
27 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
28 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
29 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country *
30 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code *
31 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
32 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
33 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
34 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount TCURC
35 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
36 .INCLUDE       0   0   Valuation data  
37 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
38 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  
39 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
40 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
41 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
42 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
43 .INCLUDE       0   0   Lending rate data  
44 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
45 .INCLUDE       0   0   Lending rates structure  
46 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
47 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
48 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
49 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
50 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
51 .INCLUDE       0   0   Liquidation rights data  
52 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
53 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason TCMS_ATT_ID_TY
54 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
55 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
56 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value TCURC
57 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
58 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed TCURC
59 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
60 .INCLUDE       0   0   Account for liquidation proceeds  
61 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
62 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key T005
63 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
64 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
65 .INCLUDE       0   0   Verfication Data  
66 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  
67 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
68 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
69 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
70 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
71 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type *
72 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
73 .INCLUDE       0   0   Structure for Asset values  
74 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
75 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value TCURC
76 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
77 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
78 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
79 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
80 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
81 .INCLUDE       0   0   Purchase price data  
82 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
83 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price TCURC
84 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
85 .INCLUDE       0   0   Administrative organization unit  
86 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
87 .INCLUDE       0   0   Bank area  
88 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management *
89 .INCLUDE       0   0   Organization unit structure  
90 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1 *
91 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2 *
92 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3 *
93 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4 *
94 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5 *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_STR_PAT_DATA_SET ADD_PPTY_RIG TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
2 CMS_STR_PAT_DATA_SET AST_VALUE_CURR TCURC WAERS    
3 CMS_STR_PAT_DATA_SET BANK_CNTRY_LIQ T005 LAND1 REF 1 CN
4 CMS_STR_PAT_DATA_SET CLASSIFICATION TCMS_OMS_FEAT TYPE_FEAT REF    
5 CMS_STR_PAT_DATA_SET EXP_PRCD_CURR TCURC WAERS REF 1 CN
6 CMS_STR_PAT_DATA_SET LIQD_CURR TCURC WAERS    
7 CMS_STR_PAT_DATA_SET LIQD_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
8 CMS_STR_PAT_DATA_SET NOM_VALUE_CURR TCURC WAERS    
9 CMS_STR_PAT_DATA_SET PUR_PRICE_CURR TCURC WAERS    
10 CMS_STR_PAT_DATA_SET SFTY_AMT_CURR TCURC WAERS REF 1 CN
11 CMS_STR_PAT_DATA_SET UNIT_OF_MEASURE T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 500