SAP ABAP Table CMS_STR_MOV_GET_DATA (Movables GET data)

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_MOV_GET_DATA	Table Relationship Diagram
Short Description	Movables 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	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	Inventory Specific details
63	IDEN_ACC	☐	CMS_DTE_INV_IDEN_ACC	CMS_SEC_FLG	CHAR	1	0	Identification land accessories
64	BILL_NO	☐	CMS_DTE_INV_BILL_NO	CMS_INV_BILL_NO	CHAR	20	0	Bill number of the inventory
65	UNIT_PRICE	☐	CMS_DTE_INV_UNIT_PRICE	CMS_AMOUNT	CURR	17	2	Unit Price
66	UNIT_PRICE_CURR	☐	CMS_DTE_INV_UNIT_CURR	WAERS	CUKY	5	0	Currency for unit price	TCURC
67	TYPE_STK_EXCH	☐	CMS_DTE_INV_TYPE_STK_EXCH	CMS_ATT_ID_TYP	CHAR	6	0	Type of stock exchange	TCMS_ATT_ID_TY
68	STK_EXCH_ID	☐	CMS_DTE_INV_STK_EXCH_ID	CMS_ATT_ID_TYP	CHAR	6	0	Place of stock exchange	TCMS_ATT_ID_TY
69	RATE_FIX_DAT	☐	CMS_DTE_INV_RATE_FIX_DAT	DATUM	DATS	8	0	Date of previous quotation
70	DET_PRICE	☐	CMS_DTE_INV_DET_PRICE	CMS_AMOUNT	CURR	17	2	Determined price
71	DET_CURR	☐	CMS_DTE_INV_DET_CURR	WAERS	CUKY	5	0	Currency for determined price	TCURC
72	STOCK_QUANTITY	☐	CMS_DTE_INV_QTY	CMS_QTY	QUAN	13	3	Quantity of inventory
73	STOCK_UOM	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity	T006
74	.INCLUDE	☐				0	0	Administrative organization unit
75	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
76	.INCLUDE	☐				0	0	Bank area
77	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
78	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
79	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
80	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
81	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
82	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
83	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_MOV_GET_DATA	ACR_MTOW_UNT	T006	MSEHI
2	CMS_STR_MOV_GET_DATA	ACR_RATCLS	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
3	CMS_STR_MOV_GET_DATA	ACR_REGC	T005	LAND1	REF	1	CN
4	CMS_STR_MOV_GET_DATA	DET_CURR	TCURC	WAERS
5	CMS_STR_MOV_GET_DATA	DEV_COUNTRY_KEY	T005	LAND1
6	CMS_STR_MOV_GET_DATA	MOV_IDEN_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
7	CMS_STR_MOV_GET_DATA	MOV_LOC_DESC	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
8	CMS_STR_MOV_GET_DATA	MOV_MANU_CNTRY	T005	LAND1	REF	1	CN
9	CMS_STR_MOV_GET_DATA	MOV_TYP	TCMS_MOV_TYP	MOV_CATEGORY	REF	1	CN
10	CMS_STR_MOV_GET_DATA	MOV_TYPE_FEAT	TCMS_OMS_FEAT	TYPE_FEAT	REF	1	CN
11	CMS_STR_MOV_GET_DATA	MOV_UOB	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
12	CMS_STR_MOV_GET_DATA	PERM_WGHT_UNT	T006	MSEHI	REF
13	CMS_STR_MOV_GET_DATA	STK_EXCH_ID	TCMS_ATT_ID_TY	INDICATOR_TYPE
14	CMS_STR_MOV_GET_DATA	STOCK_UOM	T006	MSEHI
15	CMS_STR_MOV_GET_DATA	TYPE_STK_EXCH	TCMS_ATT_ID_TY	INDICATOR_TYPE
16	CMS_STR_MOV_GET_DATA	UNIT_PRICE_CURR	TCURC	WAERS

History

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