SAP ABAP Table CMS_STR_ACR_MAP_GET_MLT (MAPI: GET: Structure for aircraft details)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS-MD-MOV (Application Component) Movables
     CMS_OMS_MOV (Package) Object Systems for Collateral Management: Movables
Basic Data
Table Category INTTAB    Structure 
Structure CMS_STR_ACR_MAP_GET_MLT   Table Relationship Diagram
Short Description MAPI: GET: Structure for aircraft details    
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 MOV_CAT_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
8 MOV_TYP_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
9 .INCLUDE       0   0   Common Movable data  
10 MOV_DESC CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
11 MOV_IDT_ACC CMS_DTE_MOV_IDT_ACC CMS_MOV_IDT_ACC CHAR 1   0   Identification accessories  
12 .INCLUDE       0   0   Object Specific Features for Description  
13 MOV_MODEL_NAM CMS_DTE_MOV_MODEL_NAM CMS_MOV_MODEL_NAM CHAR 30   0   Technical Category/Category term/Description  
14 MOV_MANUFACTURER CMS_DTE_MOV_MANUFACTURER CMS_MOV_MANUFACTURER CHAR 30   0   Object Manufacturer Builder  
15 MOV_MANU_DAT CMS_DTE_MOV_MANU_DAT CMS_MOV_MANU_DAT DATS 8   0   Date of the Manufacture/Purchase  
16 ADDR_ID CMS_DTE_MOV_LOCATION AD_ADDRNUM CHAR 10   0   Location / Address *
17 MOV_LOC_DESC CMS_DTE_MOV_LOC_DESC CMS_ATT_ID_TYP CHAR 6   0   Location Description TCMS_ATT_ID_TY
18 MOV_LOC_DE_RMRK CMS_DTE_MOV_LOC_DESC_RMRK CMS_MOV_LOC_DESC_RMRK CHAR 30   0   Remark Field for Location Description  
19 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
20 MOV_DESC_COL_MAT CMS_DTE_OMS_DESC_IDENT_COL_MAT CMS_OMS_DESC_COL_MAT CHAR 30   0   Bank's Own Identifcation  
21 MOV_DOP CMS_DTE_MOV_DOP CMS_MOV_DOP DATS 8   0   Date of Purchase  
22 MOV_IDENT CMS_DTE_MOV_IDENT CMS_MOV_IDENT CHAR 2   0   Commercial usage  
23 MOV_UOB CMS_DTE_MOV_UOB CMS_ATT_ID_TYP CHAR 6   0   Use of the object TCMS_ATT_ID_TY
24 MOV_MANU_CNTRY CMS_DTE_MOV_MANU_CNTRY LAND1 CHAR 3   0   Manufacturing Country T005
25 MOV_TYPE_FEAT CMS_DTE_MOV_TYPE_FEAT CMS_MOV_TYPE_FEAT CHAR 6   0   Classification TCMS_OMS_FEAT
26 .INCLUDE       0   0   Common OMS data  
27 EXT_ITM_NO CMS_DTE_OMS_EXT_ITM_NO CMS_OMS_ID CHAR 40   0   Ext. Item no / Number for identification of the objects  
28 EXT_REFERENCE CMS_DTE_OMS_REF_ID CMS_OMS_REFID CHAR 32   0   Reference number for the legacy system  
29 .INCLUDE       0   0   Template Information  
30 IS_TEMPLATE CMS_DTE_MOV_FLG_TEMPLATE CMS_MOV_FLG CHAR 1   0   Type to be used as template  
31 TEMPLATE_ID CMS_DTE_MOV_TEMPLATE_ID SYSUUID RAW 16   0   Template ID  
32 .INCLUDE       0   0   Aircraft data  
33 .INCLUDE       0   0   Aircraft data  
34 ACR_DELVDAT CMS_DTE_MOV_DELVDAT CMS_MOV_DELVDAT DATS 8   0   Delivery Date  
35 ACR_REG CMS_DTE_MOV_REG CMS_MOV_REG CHAR 1   0   Registered  
36 ACR_REGC CMS_DTE_MOV_REGC LAND1 CHAR 3   0   Registration Country T005
37 ACR_REGM CMS_DTE_MOV_REGM CMS_MOV_REGM CHAR 6   0   Registration Mark  
38 ACR_RC CMS_DTE_MOV_RC CMS_MOV_RC CHAR 30   0   Registration Comments  
39 ACR_EMAN CMS_DTE_MOV_EMAN CMS_MOV_EMAN CHAR 30   0   Engine Manufacturer  
40 ACR_EMOD CMS_DTE_MOV_EMOD CMS_MOV_EMOD CHAR 12   0   Engine Model  
41 ACR_EPOOL CMS_DTE_MOV_EPOOL CMS_MOV_EPOOL CHAR 10   0   Engine pooling  
42 ACR_EPRMK CMS_DTE_MOV_EPRMK CMS_MOV_EPRMK CHAR 30   0   Engine pooling remarks  
43 ACR_NOE CMS_DTE_MOV_NOE CMS_MOV_NOE INT4 10   0   Number of Engines  
44 ACR_NAME CMS_DTE_MOV_OM CMS_MOV_OM CHAR 30   0   Object name  
45 ACR_MTOW CMS_DTE_MOV_MTOW CMS_MOV_MTOW QUAN 13   3   Maximum take-off weight  
46 ACR_MTOW_UNT CMS_DTE_MOV_MTOW_UNT MEINS UNIT 3   0   Maximum take off weight (Unit) T006
47 ACR_NOB CMS_DTE_MOV_NOB CMS_MOV_NOB INT1 3   0   Number of objects  
48 ACR_MSNNO CMS_DTE_MOV_MSNNO CMS_MOV_MSNNO CHAR 10   0   MSN Number  
49 .INCLUDE       0   0   Rating  
50 ACR_RATCLS CMS_DTE_MOV_RATCLS CMS_ATT_ID_TYP CHAR 6   0   Rating Class TCMS_ATT_ID_TY
51 ACR_RATD CMS_DTE_MOV_RATD CMS_MOV_RATD DATS 8   0   Rating Date  
52 .INCLUDE       0   0   MAPI : GET : Asset details  
53 CATEGORY CMS_DTE_OMS_OBJ_CAT CMS_OBJ_CAT CHAR 6   0   Object Category *
54 CATEGORY_NAME CMS_DTE_OMS_CAT_NAME CMS_OMS_CAT_NAME CHAR 40   0   Object Category Name  
55 TYPE CMS_DTE_MOV_TYP CMS_MOV_TYP CHAR 6   0   Movable types *
56 TYPE_NAME CMS_DTE_MOV_TYP_NAME CMS_MOV_NAME CHAR 40   0   Name in a specified language  
57 IDENTIFICATION CMS_DTE_MOV_ID CMS_MOV_ID CHAR 40   0   Identification Number  
58 MOV_DESCRIPTION CMS_DTE_MOV_DESC CMS_MOV_DESC CHAR 30   0   Description of the object  
59 .INCLUDE       0   0   Structure with Asset Details for Table CMS_AST  
60 .INCLUDE       0   0   Basic Asset data  
61 DESCRIPTION CMS_DTE_AST_DESC CMS_DSC CHAR 30   0   Description  
62 OBJECT_REF_ID CMS_DTE_OBJ_REFID CMS_OBJ_REFID CHAR 40   0   Reference ID for the object  
63 OBJECT_TYP CMS_DTE_OBJ_TYP CMS_OBJ_TYP CHAR 32   0   Not used  
64 COUNTRY_KEY CMS_DTE_AST_COUNTRY_KEY LAND1 CHAR 3   0   Identification Key for Country *
65 RISK_CODE CMS_DTE_RISK_CODE CMS_RISK_CODE CHAR 6   0   Risk Code *
66 SFTY_IND CMS_DTE_IND_SFTY_DISC CMS_IND_SFTY CHAR 2   0   Indicates if the Asset has a Default Safety Discount  
67 SFTY_DSCNT CMS_DTE_SAFETY_DSCNT CMS_SFTY_PCT DEC 10   6   Percentage of Safety Discount  
68 SFTY_AMOUNT CMS_DTE_SAFETY_AMT CMS_AMOUNT CURR 17   2   Amount of Safety Discount  
69 SFTY_AMT_CURR CMS_DTE_SAFETY_AMT_CURR WAERS CUKY 5   0   Currency of the Safety Discount Amount TCURC
70 OBJSYSID CMS_DTE_OBJ_SYSID CMS_SYS CHAR 6   0   Object System Reference ID  
71 .INCLUDE       0   0   Valuation data  
72 VALUATION_TYP CMS_DTE_IND_VALN_TYP CMS_VALN_TYP CHAR 2   0   Type of Valuation Check performed on Collateral Object  
73 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  
74 PERIOD_VALN_FREQ CMS_DTE_AST_VALN_FREQ_PERIOD CMS_AST_VALN_FREQ_PERIOD NUMC 4   0   Revaluation Period for an Asset  
75 PAST_VALUED_DATE CMS_DTE_VALN_DATE CMS_DATE DATS 8   0   Last Date on which the Asset was Valued  
76 START_DATE CMS_DTE_START_DATE CMS_DATE DATS 8   0   Date on which the First Valuation is Performed on the Asset  
77 END_DATE CMS_DTE_END_DATE CMS_DATE DATS 8   0   Date on which the Last Valuation is Performed on the Asset  
78 .INCLUDE       0   0   Lending rate data  
79 LENDING_RATE_IND CMS_DTE_IND_LND_RTE CMS_IND_LRTE CHAR 2   0   Indicator to specify if Asset has a Default Lending Rate  
80 .INCLUDE       0   0   Lending rates structure  
81 LENDING_RATE1 CMS_DTE_LRTE_PCT1 CMS_PCT DEC 10   6   Lending Rate 1  
82 LENDING_RATE2 CMS_DTE_LRTE_PCT2 CMS_PCT DEC 10   6   Lending Rate 2  
83 LENDING_RATE3 CMS_DTE_LRTE_PCT3 CMS_PCT DEC 10   6   Lending Rate 3  
84 LENDING_RATE4 CMS_DTE_LRTE_PCT4 CMS_PCT DEC 10   6   Lending Rate 4  
85 LENDING_RATE5 CMS_DTE_LRTE_PCT5 CMS_PCT DEC 10   6   Lending Rate 5  
86 .INCLUDE       0   0   Liquidation rights data  
87 LIQD_TYP CMS_DTE_LIQD_TYP CMS_TYP CHAR 6   0   Liquidation Type  
88 LIQD_REASON CMS_DTE_ATT_ID_TY_AST004 CMS_ATT_ID_TYP CHAR 6   0   Liquidation Reason TCMS_ATT_ID_TY
89 LIQD_DATE CMS_DTE_LIQD_DATE CMS_DATE DATS 8   0   Date on which the Collateral was Liquidated  
90 LIQD_AMT CMS_DTE_LIQD_VALUE CMS_AMOUNT CURR 17   2   Returns from the Liquidation of Collateral  
91 LIQD_CURR CMS_DTE_LIQD_CURR WAERS CUKY 5   0   Currency of Liquidation Value TCURC
92 EXP_PRCD_AMNT CMS_DTE_LIQ_EXP_PRCD_AMOUNT CMS_AMOUNT CURR 17   2   Expected Proceed Amount  
93 EXP_PRCD_CURR CMS_DTE_LIQ_EXP_PRCD_CURR WAERS CUKY 5   0   Currency: Expected Proceed TCURC
94 EXP_ACC_DATE CMS_DTE_LIQ_EXP_ACCRUAL_DATE CMS_DATE DATS 8   0   Expected accrual date  
95 .INCLUDE       0   0   Account for liquidation proceeds  
96 ACC_NUMBER_LIQ CMS_DTE_LIQ_ACC_NUMBER BANKN35 CHAR 35   0   Account number for liquidation proceeds  
97 BANK_CNTRY_LIQ CMS_DTE_LIQ_BNK_CTRY_KY LAND1 CHAR 3   0   Bank country key T005
98 BANK_KEY_LIQ CMS_DTE_LIQ_BNK_KEY BANKK CHAR 15   0   Bank Key  
99 BANK_CTRLKEY_LIQ BKONT BKONT CHAR 2   0   Bank Control Key  
100 .INCLUDE       0   0   Verfication Data  
101 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  
102 PERIOD_VERF_FREQ CMS_DTE_AST_VERF_FREQ_PERIOD CMS_AST_VERF_FREQ_PERIOD NUMC 4   0   Statement Period for an Asset  
103 LAST_VERF_DATE CMS_DTE_AST_VERF_DATE CMS_DATE DATS 8   0   Last Verification Date  
104 .INCLUDE       0   0   AST PKy and Type and Parent GUID  
105 AST_GUID CMS_DTE_AST_GUID SYSUUID RAW 16   0   GUID for Table CMS_AST  
106 AST_TYP CMS_DTE_AST_TYP CMS_AST_TYP CHAR 6   0   Asset Type *
107 PARENT_GUID CMS_DTE_SAS_PAR_GUID SYSUUID RAW 16   0   Asset Guid as a parent GUID for a sub-asset  
108 .INCLUDE       0   0   Structure for Asset values  
109 NOM_VALUE CMS_DTE_AST_NOMINAL_VALUE CMS_AMOUNT CURR 17   2   Nominal Value of the Asset  
110 NOM_VALUE_CURR CMS_DTE_AST_NOMINAL_VALUE_CURR WAERS CUKY 5   0   Currency of Nominal value TCURC
111 AST_VALUE CMS_DTE_AST_VALUE CMS_AMOUNT CURR 17   2   Final Asset Value  
112 AST_VALUE_CURR CMS_DTE_AST_VALUE_CURR WAERS CUKY 5   0   Currency of the Final Asset Value TCURC
113 QUANTITY CMS_DTE_QTY CMS_QTY QUAN 13   3   Quantity  
114 UNIT_OF_MEASURE CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
115 REC_AT CMS_DTE_REC_AT TZNTSTMPS DEC 15   0   Asset Value Recording Timestamp  
116 .INCLUDE       0   0   Purchase price data  
117 PUR_PRICE CMS_DTE_AST_PURCHASE_PRICE CMS_AMOUNT CURR 17   2   Purchase Price of the Asset  
118 PUR_PRICE_CURR CMS_DTE_AST_PUR_PRICE_CURR WAERS CUKY 5   0   Currency of Purchase Price TCURC
119 PUR_DATE CMS_DTE_AST_PUR_PRICE_DATE CMS_DATE DATS 8   0   Date of Purchase  
120 .INCLUDE       0   0   Administrative organization unit  
121 ADMIN_ORG_UNIT CMS_DTE_ADMINORG TEXT12 CHAR 12   0   Administration Organizational Unit  
122 .INCLUDE       0   0   Bank area  
123 BANKAREA CMS_DTE_BANKAREA CMS_BANKAREA CHAR 4   0   Bank Area in Collateral Management *
124 .INCLUDE       0   0   Organization unit structure  
125 ORG_UNIT1 CMS_DTE_ORG_UNIT1 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 1 *
126 ORG_UNIT2 CMS_DTE_ORG_UNIT2 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 2 *
127 ORG_UNIT3 CMS_DTE_ORG_UNIT3 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 3 *
128 ORG_UNIT4 CMS_DTE_ORG_UNIT4 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 4 *
129 ORG_UNIT5 CMS_DTE_ORG_UNIT5 CMS_ORG_UNIT CHAR 10   0   Organizational Unit 5 *
130 .INCLUDE       0   0   Inventory Specific details  
131 IDEN_ACC CMS_DTE_INV_IDEN_ACC CMS_SEC_FLG CHAR 1   0   Identification land accessories  
132 BILL_NO CMS_DTE_INV_BILL_NO CMS_INV_BILL_NO CHAR 20   0   Bill number of the inventory  
133 UNIT_PRICE CMS_DTE_INV_UNIT_PRICE CMS_AMOUNT CURR 17   2   Unit Price  
134 UNIT_PRICE_CURR CMS_DTE_INV_UNIT_CURR WAERS CUKY 5   0   Currency for unit price TCURC
135 TYPE_STK_EXCH CMS_DTE_INV_TYPE_STK_EXCH CMS_ATT_ID_TYP CHAR 6   0   Type of stock exchange TCMS_ATT_ID_TY
136 STK_EXCH_ID CMS_DTE_INV_STK_EXCH_ID CMS_ATT_ID_TYP CHAR 6   0   Place of stock exchange TCMS_ATT_ID_TY
137 RATE_FIX_DAT CMS_DTE_INV_RATE_FIX_DAT DATUM DATS 8   0   Date of previous quotation  
138 DET_PRICE CMS_DTE_INV_DET_PRICE CMS_AMOUNT CURR 17   2   Determined price  
139 DET_CURR CMS_DTE_INV_DET_CURR WAERS CUKY 5   0   Currency for determined price TCURC
140 STOCK_QUANTITY CMS_DTE_INV_QTY CMS_QTY QUAN 13   3   Quantity of inventory  
141 STOCK_UOM CMS_DTE_UNIT MEINS UNIT 3   0   Unit of Measure of Quantity T006
142 .INCLUDE       0   0   Stucture to record history of changes in all application tab  
143 CREATED_BY CMS_DTE_USER CMS_USER CHAR 12   0   Login ID of the User who created the Record  
144 CREATED_AT CMS_DTE_CREATED_AT TZNTSTMPS DEC 15   0   Creation Timestamp  
145 CHANGED_BY CMS_DTE_LAST_CHNG_USER CMS_USER CHAR 12   0   Last Changed By  
146 CHANGED_AT CMS_DTE_CHANGED_AT TZNTSTMPS DEC 15   0   Change Timestamp  
147 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_ACR_MAP_GET_MLT ACR_MTOW_UNT T006 MSEHI    
2 CMS_STR_ACR_MAP_GET_MLT ACR_RATCLS TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
3 CMS_STR_ACR_MAP_GET_MLT ACR_REGC T005 LAND1 REF 1 CN
4 CMS_STR_ACR_MAP_GET_MLT AST_VALUE_CURR TCURC WAERS    
5 CMS_STR_ACR_MAP_GET_MLT BANK_CNTRY_LIQ T005 LAND1 REF 1 CN
6 CMS_STR_ACR_MAP_GET_MLT DET_CURR TCURC WAERS    
7 CMS_STR_ACR_MAP_GET_MLT EXP_PRCD_CURR TCURC WAERS REF 1 CN
8 CMS_STR_ACR_MAP_GET_MLT LIQD_CURR TCURC WAERS    
9 CMS_STR_ACR_MAP_GET_MLT LIQD_REASON TCMS_ATT_ID_TY INDICATOR_TYPE    
10 CMS_STR_ACR_MAP_GET_MLT MOV_IDEN_TYP TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
11 CMS_STR_ACR_MAP_GET_MLT MOV_LOC_DESC TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
12 CMS_STR_ACR_MAP_GET_MLT MOV_MANU_CNTRY T005 LAND1 REF 1 CN
13 CMS_STR_ACR_MAP_GET_MLT MOV_TYP TCMS_MOV_TYP MOV_CATEGORY REF 1 CN
14 CMS_STR_ACR_MAP_GET_MLT MOV_TYPE_FEAT TCMS_OMS_FEAT TYPE_FEAT REF 1 CN
15 CMS_STR_ACR_MAP_GET_MLT MOV_UOB TCMS_ATT_ID_TY INDICATOR_TYPE REF 1 CN
16 CMS_STR_ACR_MAP_GET_MLT NOM_VALUE_CURR TCURC WAERS    
17 CMS_STR_ACR_MAP_GET_MLT PUR_PRICE_CURR TCURC WAERS    
18 CMS_STR_ACR_MAP_GET_MLT SFTY_AMT_CURR TCURC WAERS REF 1 CN
19 CMS_STR_ACR_MAP_GET_MLT STK_EXCH_ID TCMS_ATT_ID_TY INDICATOR_TYPE    
20 CMS_STR_ACR_MAP_GET_MLT STOCK_UOM T006 MSEHI    
21 CMS_STR_ACR_MAP_GET_MLT TYPE_STK_EXCH TCMS_ATT_ID_TY INDICATOR_TYPE    
22 CMS_STR_ACR_MAP_GET_MLT UNIT_OF_MEASURE T006 MSEHI REF 1 CN
23 CMS_STR_ACR_MAP_GET_MLT UNIT_PRICE_CURR TCURC WAERS    
History
Last changed by/on SAP  20110901 
SAP Release Created in 500