SAP ABAP Table CMS_STR_MOV_DATA_SCR (Movables - Own Data (Screen))
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS-MD (Application Component) Master Data
     CMS_OMS_MOV_UI (Package) Objects for Collateral Management: User Interface Movables
Basic Data
Table Category INTTAB    Structure 
Structure CMS_STR_MOV_DATA_SCR   Table Relationship Diagram
Short Description Movables - 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   Primary Key for CMS_MOVABLES  
2 MOV_GUID CMS_DTE_MOV_GUID SYSUUID RAW 16   0   GUID for CMS_MOVABLES  
3 .INCLUDE       0   0   Semantic Key  
4 MOV_CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category TCMS_MOV_TYP
5 MOV_TYP CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types TCMS_MOV_TYP
6 MOV_ID CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
7 .INCLUDE       0   0   Common Movable data  
8 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
9 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
10 .INCLUDE       0   0   Object Specific Features for Description  
11 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
12 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
13 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
14 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address *
15 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description TCMS_ATT_ID_TY
16 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
17 MOV_IDEN_TYP CMS_DTE_MOV_TYPE_IDENT CMS_ATT_ID_TYP CHAR 6   0   Type of identification / Marking of the collateral material TCMS_ATT_ID_TY
18 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
19 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
20 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
21 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object TCMS_ATT_ID_TY
22 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country T005
23 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification TCMS_OMS_FEAT
24 .INCLUDE       0   0   Common OMS data  
25 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
26 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
27 .INCLUDE       0   0   Template Information  
28 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
29 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
30 .INCLUDE       0   0   Devices Data  
31 .INCLUDE       0   0   Devices data  
32 DEV_COUNTRY_KEY CMS_DTE_MOV_COUNTRY_KEY LAND1 CHAR 3   0   Country Key T005
33 DEV_MAC_NO CMS_DTE_MOV_MACHINE_NO CMS_MOV_ID CHAR 40   0   External Item Number - Machine number  
34 .INCLUDE       0   0   Aircraft data  
35 .INCLUDE       0   0   Aircraft data  
36 ACR_DELVDAT CMS_DTE_MOV_DELVDAT CMS_MOV_DELVDAT DATS 8   0   Delivery Date  
37 ACR_REG CMS_DTE_MOV_REG CMS_MOV_REG CHAR 1   0   Registered  
38 ACR_REGC CMS_DTE_MOV_REGC LAND1 CHAR 3   0   Registration Country T005
39 ACR_REGM CMS_DTE_MOV_REGM CMS_MOV_REGM CHAR 6   0   Registration Mark  
40 ACR_RC CMS_DTE_MOV_RC CMS_MOV_RC CHAR 30   0   Registration Comments  
41 ACR_EMAN CMS_DTE_MOV_EMAN CMS_MOV_EMAN CHAR 30   0   Engine Manufacturer  
42 ACR_EMOD CMS_DTE_MOV_EMOD CMS_MOV_EMOD CHAR 12   0   Engine Model  
43 ACR_EPOOL CMS_DTE_MOV_EPOOL CMS_MOV_EPOOL CHAR 10   0   Engine pooling  
44 ACR_EPRMK CMS_DTE_MOV_EPRMK CMS_MOV_EPRMK CHAR 30   0   Engine pooling remarks  
45 ACR_NOE CMS_DTE_MOV_NOE CMS_MOV_NOE INT4 10   0   Number of Engines  
46 ACR_NAME CMS_DTE_MOV_OM CMS_MOV_OM CHAR 30   0   Object name  
47 ACR_MTOW CMS_DTE_MOV_MTOW CMS_MOV_MTOW QUAN 13   3   Maximum take-off weight  
48 ACR_MTOW_UNT CMS_DTE_MOV_MTOW_UNT MEINS UNIT 3   0   Maximum take off weight (Unit) T006
49 ACR_NOB CMS_DTE_MOV_NOB CMS_MOV_NOB INT1 3   0   Number of objects  
50 ACR_MSNNO CMS_DTE_MOV_MSNNO CMS_MOV_MSNNO CHAR 10   0   MSN Number  
51 .INCLUDE       0   0   Rating  
52 ACR_RATCLS CMS_DTE_MOV_RATCLS CMS_ATT_ID_TYP CHAR 6   0   Rating Class TCMS_ATT_ID_TY
53 ACR_RATD CMS_DTE_MOV_RATD CMS_MOV_RATD DATS 8   0   Rating Date  
54 .INCLUDE       0   0   Vehicles data  
55 .INCLUDE       0   0   Vehicles data  
56 PERM_WGHT CMS_DTE_MOV_PERM_WGHT CMS_PERM_WGHT QUAN 13   3   Maximum Permissible Weight  
57 PERM_WGHT_UNT CMS_DTE_MOV_PERM_WGHT_UNT MEINS UNIT 3   0   Unit of the quantity T006
58 PLACE_LIC CMS_DTE_MOV_PLACE_LIC CMS_PLACE_LIC CHAR 30   0   Place of Registration  
59 VEH_REG_NO CMS_DTE_MOV_REG_NO CMS_REG_NO CHAR 30   0   Vehicle registration mark  
60 OFF_IDENT CMS_DTE_MOV_OFF_IDENT CMS_VEH_OFF_IDENT CHAR 30   0   Identification of the registration certificate  
61 CHAIS_NO CMS_DTE_MOV_CHASIS_NO CMS_MOV_DESC CHAR 30   0   Chassis Number  
62 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
63 .INCLUDE       0   0   Basic Asset data  
64 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
65 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
66 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
67 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country T005
68 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code TCMS_RISKCODE
69 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
70 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
71 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
72 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount TCURC
73 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
74 .INCLUDE       0   0   Valuation data  
75 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
76 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  
77 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
78 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
79 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
80 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
81 .INCLUDE       0   0   Lending rate data  
82 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
83 .INCLUDE       0   0   Lending rates structure  
84 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
85 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
86 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
87 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
88 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
89 .INCLUDE       0   0   Liquidation rights data  
90 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
91 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason TCMS_ATT_ID_TY
92 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
93 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
94 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value TCURC
95 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
96 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed TCURC
97 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
98 .INCLUDE       0   0   Account for liquidation proceeds  
99 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
100 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key T005
101 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key *
102 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
103 .INCLUDE       0   0   Verfication Data  
104 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  
105 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
106 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
107 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
108 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
109 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type *
110 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
111 .INCLUDE       0   0   Structure for Asset values  
112 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
113 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value TCURC
114 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
115 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
116 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
117 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
118 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
119 .INCLUDE       0   0   Purchase price data  
120 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
121 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price TCURC
122 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
123 .INCLUDE       0   0   Administration organization unit (key conversion)  
124 ADMIN_ORG_UNIT CMS_DTE_ADMINORG_KEY CMS_ADMINORG_KEY CHAR 12   0   Administration Organizational Unit (Key conversion)  
125 .INCLUDE       0   0   Bank area  
126 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management *
127 .INCLUDE       0   0   Organization unit structure  
128 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1 *
129 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2 *
130 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3 *
131 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4 *
132 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5 *
133 .INCLUDE       0   0   Active System Statuses  
134 SYS_STAT CMS_DTE_SYS_STAT_LINE TEXT40 CHAR 40   0   System Status  
135 .INCLUDE       0   0   Active User Statuses  
136 USR_STAT CMS_DTE_USR_STAT_LINE TEXT40 CHAR 40   0   User Status  
137 .INCLUDE       0   0   New System Statuses  
138 SYS_STAT_NEW CMS_DTE_SYS_STAT_LINE TEXT40 CHAR 40   0   System Status  
139 .INCLUDE       0   0   New User Statuses  
140 USR_STAT_NEW CMS_DTE_USR_STAT_LINE TEXT40 CHAR 40   0   User Status  
141 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
142 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
143 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
144 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
145 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
146 SOURCEOFENTRY CMS_DTE_SOURCE_OF_ENTRY CMS_SOURCE CHAR 32   0   Source of Entry  
147 .INCLUDE       0   0   Change Hsitory Structure (For screen)  
148 CREATED_DATE CMS_DTE_DATE CMS_DATE DATS 8   0   Date  
149 CREATED_TIME CMS_DTE_TIME CMS_TIME TIMS 6   0   Time  
150 CHANGED_DATE CMS_DTE_DATE CMS_DATE DATS 8   0   Date  
151 CHANGED_TIME CMS_DTE_TIME CMS_TIME TIMS 6   0   Time  
152 .INCLUDE       0   0   Structure for Variable object field names  
153 NOM_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
154 AST_VALUE_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
155 OBJECT_REF_ID_SCR CMS_DTE_SCREEN_FLD_NAME CMS_FLD_TEXT CHAR 15   0   Name of the Asset Screen field  
156 .INCLUDE       0   0   Bank name  
157 BANK_NAME BANKA TEXT60 CHAR 60   0   Name of bank  
158 .INCLUDE       0   0   Movables- Total value  
159 TOTAL_VALUE CMS_DTE_MOV_TOTAL_VALUE CMS_AMOUNT CURR 17   2   Total value  
160 TOTAL_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
161 .INCLUDE       0   0   Month and year of the day  
162 MANU_MONTH CMS_DTE_OMS_MANUF_MONTH KMONAT NUMC 2   0   Manufacture month  
163 MANU_YEAR CMS_DTE_OMS_MANUF_YEAR GJAHR NUMC 4   0   Manufacture year  
164 DELV_MONTH CMS_DTE_OMS_DELV_MONTH KMONAT NUMC 2   0   Delivery month  
165 DELV_YEAR CMS_DTE_OMS_DELV_YEAR GJAHR NUMC 4   0   Delivery year  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CMS_STR_MOV_DATA_SCR ACR_MTOW_UNT T006 MSEHI    
2 CMS_STR_MOV_DATA_SCR ACR_RATCLS TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
3 CMS_STR_MOV_DATA_SCR ACR_REGC T005 LAND1 REF 1 CN
4 CMS_STR_MOV_DATA_SCR AST_VALUE_CURR TCURC WAERS    
5 CMS_STR_MOV_DATA_SCR BANK_CNTRY_LIQ T005 LAND1    
6 CMS_STR_MOV_DATA_SCR COUNTRY_KEY T005 LAND1    
7 CMS_STR_MOV_DATA_SCR DEV_COUNTRY_KEY T005 LAND1    
8 CMS_STR_MOV_DATA_SCR EXP_PRCD_CURR TCURC WAERS REF 1 CN
9 CMS_STR_MOV_DATA_SCR LIQD_CURR TCURC WAERS    
10 CMS_STR_MOV_DATA_SCR LIQD_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
11 CMS_STR_MOV_DATA_SCR MOV_IDEN_TYP TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
12 CMS_STR_MOV_DATA_SCR MOV_LOC_DESC TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
13 CMS_STR_MOV_DATA_SCR MOV_MANU_CNTRY T005 LAND1 REF 1 CN
14 CMS_STR_MOV_DATA_SCR MOV_TYP TCMS_MOV_TYP MOV_CATEGORY REF 1 CN
15 CMS_STR_MOV_DATA_SCR MOV_TYPE_FEAT TCMS_OMS_FEAT TYPE_FEAT REF 1 CN
16 CMS_STR_MOV_DATA_SCR MOV_UOB TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
17 CMS_STR_MOV_DATA_SCR NOM_VALUE_CURR TCURC WAERS    
18 CMS_STR_MOV_DATA_SCR PERM_WGHT_UNT T006 MSEHI REF    
19 CMS_STR_MOV_DATA_SCR PUR_PRICE_CURR TCURC WAERS    
20 CMS_STR_MOV_DATA_SCR RISK_CODE TCMS_RISKCODE RISK_CODE    
21 CMS_STR_MOV_DATA_SCR SFTY_AMT_CURR TCURC WAERS REF 1 CN
22 CMS_STR_MOV_DATA_SCR TOTAL_VALUE_CURR TCURC WAERS    
23 CMS_STR_MOV_DATA_SCR UNIT_OF_MEASURE T006 MSEHI REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 500