SAP ABAP Table CMS_STR_COR_CAG_ACR_DET (Aircraft details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_COR (Package) Correspondence serivce for CMS

Basic Data

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

History

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