1. SAP Tutorial
  2. Financial Services

CMS_MOVABLES SAP table for – Movable Details – Vehicles, Devices & Aircraft

Here we would like to draw your attention to CMS_MOVABLES table in SAP. As we know it is being mainly used with the SAP FS-CMS (Collateral Management System in FS) component which is coming under FS module (Financial Services). CMS_MOVABLES is a SAP standard transp table used for storing Movable Details – Vehicles, Devices & Aircraft related data in SAP. It comes under the package CMS_OMS_MOV.

SAP CMS_MOVABLES table

Table CMS_MOVABLES technical data

TableCMS_MOVABLES
Data storingMovable Details – Vehicles, Devices & Aircraft
ModuleFS
Sub ModuleFS-CMS-MD-MOV
SAP PackageCMS_OMS_MOV
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_MOVABLES Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMS_MOVABLES table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary Key for CMS_MOVABLES
    Its a key field.
  • MOV_GUID : GUID for CMS_MOVABLES
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Semantic Key
  • MOV_CATEGORY : Object Category
    Its data type is CHAR (Character String) with field length 6
  • MOV_TYP : Movable types
    Its data type is CHAR (Character String) with field length 6
  • MOV_ID : Identification Number
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Common Movable data
  • MOV_DESC : Description of the object
    Its data type is CHAR (Character String) with field length 30
  • MOV_IDT_ACC : Identification accessories
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Object Specific Features for Description
  • MOV_MODEL_NAM : Technical Category/Category term/Description
    Its data type is CHAR (Character String) with field length 30
  • MOV_MANUFACTURER : Object Manufacturer Builder
    Its data type is CHAR (Character String) with field length 30
  • MOV_MANU_DAT : Date of the Manufacture/Purchase
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ADDR_ID : Location / Address
    Its data type is CHAR (Character String) with field length 10
  • MOV_LOC_DESC : Location Description
    Its data type is CHAR (Character String) with field length 6
  • MOV_LOC_DE_RMRK : Remark Field for Location Description
    Its data type is CHAR (Character String) with field length 30
  • MOV_IDEN_TYP : Type of identification / Marking of the collateral material
    Its data type is CHAR (Character String) with field length 6
  • MOV_DESC_COL_MAT : Bank’s Own Identifcation
    Its data type is CHAR (Character String) with field length 30
  • MOV_DOP : Date of Purchase
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MOV_IDENT : Commercial usage
    Its data type is CHAR (Character String) with field length 2
  • MOV_UOB : Use of the object
    Its data type is CHAR (Character String) with field length 6
  • MOV_MANU_CNTRY : Manufacturing Country
    Its data type is CHAR (Character String) with field length 3
  • MOV_TYPE_FEAT : Classification
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Common OMS data
  • EXT_ITM_NO : Ext. Item no / Number for identification of the objects
    Its data type is CHAR (Character String) with field length 40
  • EXT_REFERENCE : Reference number for the legacy system
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Template Information
  • IS_TEMPLATE : Type to be used as template
    Its data type is CHAR (Character String) with field length 1
  • TEMPLATE_ID : Template ID
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Devices Data
  • .INCLUDE : Devices data
  • DEV_COUNTRY_KEY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • DEV_MAC_NO : External Item Number – Machine number
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Aircraft data
  • .INCLUDE : Aircraft data
  • ACR_DELVDAT : Delivery Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ACR_REG : Registered
    Its data type is CHAR (Character String) with field length 1
  • ACR_REGC : Registration Country
    Its data type is CHAR (Character String) with field length 3
  • ACR_REGM : Registration Mark
    Its data type is CHAR (Character String) with field length 6
  • ACR_RC : Registration Comments
    Its data type is CHAR (Character String) with field length 30
  • ACR_EMAN : Engine Manufacturer
    Its data type is CHAR (Character String) with field length 30
  • ACR_EMOD : Engine Model
    Its data type is CHAR (Character String) with field length 12
  • ACR_EPOOL : Engine pooling
    Its data type is CHAR (Character String) with field length 10
  • ACR_EPRMK : Engine pooling remarks
    Its data type is CHAR (Character String) with field length 30
  • ACR_NOE : Number of Engines
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • ACR_NAME : Object name
    Its data type is CHAR (Character String) with field length 30
  • ACR_MTOW : Maximum take-off weight
    Its data type is QUAN (Quantity field) with field length 13
  • ACR_MTOW_UNT : Maximum take off weight (Unit)
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACR_NOB : Number of objects
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • ACR_MSNNO : MSN Number
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Rating
  • ACR_RATCLS : Rating Class
    Its data type is CHAR (Character String) with field length 6
  • ACR_RATD : Rating Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Vehicles data
  • .INCLUDE : Vehicles data
  • PERM_WGHT : Maximum Permissible Weight
    Its data type is QUAN (Quantity field) with field length 13
  • PERM_WGHT_UNT : Unit of the quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • PLACE_LIC : Place of Registration
    Its data type is CHAR (Character String) with field length 30
  • VEH_REG_NO : Vehicle registration mark
    Its data type is CHAR (Character String) with field length 30
  • OFF_IDENT : Identification of the registration certificate
    Its data type is CHAR (Character String) with field length 30
  • CHAIS_NO : Chassis Number
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Inventory Specific details
  • IDEN_ACC : Identification land accessories
    Its data type is CHAR (Character String) with field length 1
  • BILL_NO : Bill number of the inventory
    Its data type is CHAR (Character String) with field length 20
  • UNIT_PRICE : Unit Price
    Its data type is CURR (Currency Field) with field length 17
  • UNIT_PRICE_CURR : Currency for unit price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TYPE_STK_EXCH : Type of stock exchange
    Its data type is CHAR (Character String) with field length 6
  • STK_EXCH_ID : Place of stock exchange
    Its data type is CHAR (Character String) with field length 6
  • RATE_FIX_DAT : Date of previous quotation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DET_PRICE : Determined price
    Its data type is CURR (Currency Field) with field length 17
  • DET_CURR : Currency for determined price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • STOCK_QUANTITY : Quantity of inventory
    Its data type is QUAN (Quantity field) with field length 13
  • STOCK_UOM : Unit of Measure of Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Administrative organization unit
  • ADMIN_ORG_UNIT : Administration Organizational Unit
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Bank area
  • BANKAREA : Bank Area in Collateral Management
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Stucture to record history of changes in all application tab
  • CREATED_BY : Login ID of the User who created the Record
    Its data type is CHAR (Character String) with field length 12
  • CREATED_AT : Creation Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Change Timestamp
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • SOURCEOFENTRY : Source of Entry
    Its data type is CHAR (Character String) with field length 32

    • CMS_MOVABLES related tables

    • TCMS_MOV_TYP_T : Text Table for TCMS_MOV_TYP_T
    • TCMS_MOV_TYP : Customizing table for Movable Type
    • TCMS_MVTY_PRTY_T : Text table for TCMS_MVTY_PRTY
    • TCMS_MVTY_PRTY : Relation between Object Types -> Part Types
    • CMS_OMS_PRT_LNK : Part-Link Data
    • CMS_MOVABLES : Movable Details – Vehicles, Devices & Aircraft

    CMS_MOVABLES related transaction codes under SAP package CMS_OMS_MOV

    • CMS_DEL_SUBAST_MOV : Delete wrong subassets for Movables

    Related References

    Related Tutorials

    TCMS_MOV_TYP SAP table for – Customizing table for Movable Type

    TCMS_MOV_TYP table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Customizing...

    CMS_SEC_ACC SAP table for – Securities account details

    CMS_SEC_ACC table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Securities...

    CMS_AST SAP table for – Asset Details

    CMS_AST table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Asset...

    CMS_RBL SAP table for – Receivable Details

    CMS_RBL table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Receivable...

    CMS_RE_OBJ SAP table for – Real estate header details

    CMS_RE_OBJ table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    CMS_SEC_ACC_POS SAP table for – Securities position details

    CMS_SEC_ACC_POS table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Securities...

    CMS_RE_OBJ_PRT SAP table for – Real Estate Object part details

    CMS_RE_OBJ_PRT table in SAP FS (Collateral Management System in FS) module. This table is used for storing data of Real...

    «
    »