SAP CMS_MOVABLES Movable Details - Vehicles, Devices & Aircraft Table data and field list

CMS_MOVABLES is a standard SAP Table which is used to store Movable Details - Vehicles, Devices & Aircraft data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_MOVABLES table consists of various fields, each holding specific information or linking keys about Movable Details - Vehicles, Devices & Aircraft data available in SAP. These include MOV_GUID (GUID for CMS_MOVABLES), MOV_CATEGORY (Object Category), MOV_TYP (Movable types), MOV_ID (Identification Number)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_MOVABLES table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CMS_MOVABLES table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_MOVABLES table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
MOV_GUID	GUID for CMS_MOVABLES	CMS_DTE_MOV_GUID	RAW	16			SYSUUID	CMS_MOV_OBJ_GUID
MOV_CATEGORY	Object Category	CMS_DTE_OMS_OBJ_CAT	CHAR	6	TCMS_MOV_TYP		CMS_OBJ_CAT
MOV_TYP	Movable types	CMS_DTE_MOV_TYP	CHAR	6	TCMS_MOV_TYP		CMS_MOV_TYP
MOV_ID	Identification Number	CMS_DTE_MOV_ID	CHAR	40		ALPHA	CMS_MOV_ID		CMS_SRCH_ACR
MOV_DESC	Description of the object	CMS_DTE_MOV_DESC	CHAR	30			CMS_MOV_DESC
MOV_IDT_ACC	Identification accessories	CMS_DTE_MOV_IDT_ACC	CHAR	1			CMS_MOV_IDT_ACC
MOV_MODEL_NAM	Technical Category/Category term/Description	CMS_DTE_MOV_MODEL_NAM	CHAR	30			CMS_MOV_MODEL_NAM
MOV_MANUFACTURER	Object Manufacturer Builder	CMS_DTE_MOV_MANUFACTURER	CHAR	30			CMS_MOV_MANUFACTURER
MOV_MANU_DAT	Date of the Manufacture/Purchase	CMS_DTE_MOV_MANU_DAT	DATS	8			CMS_MOV_MANU_DAT
ADDR_ID	Location / Address	CMS_DTE_MOV_LOCATION	CHAR	10	Assigned to domain	ALPHA	AD_ADDRNUM		ADMC
MOV_LOC_DESC	Location Description	CMS_DTE_MOV_LOC_DESC	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
MOV_LOC_DE_RMRK	Remark Field for Location Description	CMS_DTE_MOV_LOC_DESC_RMRK	CHAR	30			CMS_MOV_LOC_DESC_RMRK
MOV_IDEN_TYP	Type of identification / Marking of the collateral material	CMS_DTE_MOV_TYPE_IDENT	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
MOV_DESC_COL_MAT	Bank's Own Identifcation	CMS_DTE_OMS_DESC_IDENT_COL_MAT	CHAR	30			CMS_OMS_DESC_COL_MAT
MOV_DOP	Date of Purchase	CMS_DTE_MOV_DOP	DATS	8			CMS_MOV_DOP
MOV_IDENT	Commercial usage	CMS_DTE_MOV_IDENT	CHAR	2			CMS_MOV_IDENT
MOV_UOB	Use of the object	CMS_DTE_MOV_UOB	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
MOV_MANU_CNTRY	Manufacturing Country	CMS_DTE_MOV_MANU_CNTRY	CHAR	3	T005		LAND1
MOV_TYPE_FEAT	Classification	CMS_DTE_MOV_TYPE_FEAT	CHAR	6	TCMS_OMS_FEAT		CMS_MOV_TYPE_FEAT
EXT_ITM_NO	Ext. Item no / Number for identification of the objects	CMS_DTE_OMS_EXT_ITM_NO	CHAR	40		ALPHA	CMS_OMS_ID
EXT_REFERENCE	Reference number for the legacy system	CMS_DTE_OMS_REF_ID	CHAR	32			CMS_OMS_REFID
IS_TEMPLATE	Type to be used as template	CMS_DTE_MOV_FLG_TEMPLATE	CHAR	1			CMS_MOV_FLG
TEMPLATE_ID	Template ID	CMS_DTE_MOV_TEMPLATE_ID	RAW	16			SYSUUID
DEV_COUNTRY_KEY	Country Key	CMS_DTE_MOV_COUNTRY_KEY	CHAR	3	T005		LAND1
DEV_MAC_NO	External Item Number - Machine number	CMS_DTE_MOV_MACHINE_NO	CHAR	40		ALPHA	CMS_MOV_ID
ACR_DELVDAT	Delivery Date	CMS_DTE_MOV_DELVDAT	DATS	8			CMS_MOV_DELVDAT
ACR_REG	Registered	CMS_DTE_MOV_REG	CHAR	1			CMS_MOV_REG
ACR_REGC	Registration Country	CMS_DTE_MOV_REGC	CHAR	3	T005		LAND1
ACR_REGM	Registration Mark	CMS_DTE_MOV_REGM	CHAR	6			CMS_MOV_REGM
ACR_RC	Registration Comments	CMS_DTE_MOV_RC	CHAR	30			CMS_MOV_RC
ACR_EMAN	Engine Manufacturer	CMS_DTE_MOV_EMAN	CHAR	30			CMS_MOV_EMAN
ACR_EMOD	Engine Model	CMS_DTE_MOV_EMOD	CHAR	12			CMS_MOV_EMOD
ACR_EPOOL	Engine pooling	CMS_DTE_MOV_EPOOL	CHAR	10			CMS_MOV_EPOOL
ACR_EPRMK	Engine pooling remarks	CMS_DTE_MOV_EPRMK	CHAR	30			CMS_MOV_EPRMK
ACR_NOE	Number of Engines	CMS_DTE_MOV_NOE	INT4	10			CMS_MOV_NOE
ACR_NAME	Object name	CMS_DTE_MOV_OM	CHAR	30			CMS_MOV_OM
ACR_MTOW	Maximum take-off weight	CMS_DTE_MOV_MTOW	QUAN	13(3)			CMS_MOV_MTOW
ACR_MTOW_UNT	Maximum take off weight (Unit)	CMS_DTE_MOV_MTOW_UNT	UNIT	3	T006	CUNIT	MEINS
ACR_NOB	Number of objects	CMS_DTE_MOV_NOB	INT1	3			CMS_MOV_NOB
ACR_MSNNO	MSN Number	CMS_DTE_MOV_MSNNO	CHAR	10			CMS_MOV_MSNNO
ACR_RATCLS	Rating Class	CMS_DTE_MOV_RATCLS	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
ACR_RATD	Rating Date	CMS_DTE_MOV_RATD	DATS	8			CMS_MOV_RATD
PERM_WGHT	Maximum Permissible Weight	CMS_DTE_MOV_PERM_WGHT	QUAN	13(3)			CMS_PERM_WGHT
PERM_WGHT_UNT	Unit of the quantity	CMS_DTE_MOV_PERM_WGHT_UNT	UNIT	3	T006	CUNIT	MEINS
PLACE_LIC	Place of Registration	CMS_DTE_MOV_PLACE_LIC	CHAR	30			CMS_PLACE_LIC
VEH_REG_NO	Vehicle registration mark	CMS_DTE_MOV_REG_NO	CHAR	30			CMS_REG_NO
OFF_IDENT	Identification of the registration certificate	CMS_DTE_MOV_OFF_IDENT	CHAR	30			CMS_VEH_OFF_IDENT
CHAIS_NO	Chassis Number	CMS_DTE_MOV_CHASIS_NO	CHAR	30			CMS_MOV_DESC
IDEN_ACC	Identification land accessories	CMS_DTE_INV_IDEN_ACC	CHAR	1		ALPHA	CMS_SEC_FLG
BILL_NO	Bill number of the inventory	CMS_DTE_INV_BILL_NO	CHAR	20			CMS_INV_BILL_NO
UNIT_PRICE	Unit Price	CMS_DTE_INV_UNIT_PRICE	CURR	17(2)			CMS_AMOUNT
UNIT_PRICE_CURR	Currency for unit price	CMS_DTE_INV_UNIT_CURR	CUKY	5	TCURC		WAERS
TYPE_STK_EXCH	Type of stock exchange	CMS_DTE_INV_TYPE_STK_EXCH	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
STK_EXCH_ID	Place of stock exchange	CMS_DTE_INV_STK_EXCH_ID	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
RATE_FIX_DAT	Date of previous quotation	CMS_DTE_INV_RATE_FIX_DAT	DATS	8			DATUM
DET_PRICE	Determined price	CMS_DTE_INV_DET_PRICE	CURR	17(2)			CMS_AMOUNT
DET_CURR	Currency for determined price	CMS_DTE_INV_DET_CURR	CUKY	5	TCURC		WAERS
STOCK_QUANTITY	Quantity of inventory	CMS_DTE_INV_QTY	QUAN	13(3)			CMS_QTY
STOCK_UOM	Unit of Measure of Quantity	CMS_DTE_UNIT	UNIT	3	T006	CUNIT	MEINS
ADMIN_ORG_UNIT	Administration Organizational Unit	CMS_DTE_ADMINORG	CHAR	12			TEXT12	CMS_ADMINORG
BANKAREA	Bank Area in Collateral Management	CMS_DTE_BANKAREA	CHAR	4	Assigned to domain		CMS_BANKAREA	CMS_BANKAREA
CREATED_BY	Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12			CMS_USER
CREATED_AT	Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15			TZNTSTMPS
CHANGED_BY	Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12			CMS_USER
CHANGED_AT	Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15			TZNTSTMPS
SOURCEOFENTRY	Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32			CMS_SOURCE

Key field

Non-key field

< CMS_MESSAGE_CRM - CMS_MY_OBJ - My Objects (Favorites and Recent Objects) >

How do I retrieve data from SAP table CMS_MOVABLES using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_MOVABLES to SELECT all data from the table
DATA: WA_CMS_MOVABLES TYPE CMS_MOVABLES.

SELECT SINGLE *
FROM CMS_MOVABLES
INTO CORRESPONDING FIELDS OF WA_CMS_MOVABLES
WHERE...

How to access SAP table CMS_MOVABLES

Within an ECC or HANA version of SAP you can also view further information about CMS_MOVABLES and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).