1. SAP Tutorial
  2. Financial Services

CMS_SHP SAP table for – Description of a Ship – Master Table

Here we would like to draw your attention to CMS_SHP 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_SHP is a SAP standard transp table used for storing Description of a Ship – Master Table related data in SAP. It comes under the package CMS_SHP.

SAP CMS_SHP table

Table CMS_SHP technical data

TableCMS_SHP
Data storingDescription of a Ship – Master Table
ModuleFS
Sub ModuleFS-CMS-MD-SHP
SAP PackageCMS_SHP
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP CMS_SHP 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_SHP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Primary key for Ship
    Its a key field.
  • SHP_GUID : Globally Unique Identifier
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Asset Guid – Link key to Ship
  • AST_GUID : GUID for Table CMS_AST
    Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Identification of Ship
  • SHP_TYPE : Ship Type
    Its data type is CHAR (Character String) with field length 6
  • NAME : Ship name
    Its data type is CHAR (Character String) with field length 40
  • CHARTER_NAME : Charter Name used to Lease the Ship
    Its data type is CHAR (Character String) with field length 40
  • CALL_SIGN : IMO Number
    Its data type is CHAR (Character String) with field length 20
  • SHP_CLASS : Specifies whether the Ship is Sea Ship or Inland Ship
    Its data type is CHAR (Character String) with field length 2
  • REG_NUMBER : Registration Number
    Its data type is CHAR (Character String) with field length 20
  • REG_DATE : Registration date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REG_PLACE : Registration place
    Its data type is CHAR (Character String) with field length 40
  • REG_COUNTRY : Registration country
    Its data type is CHAR (Character String) with field length 3
  • EXTN_REF_ID : External reference ID for the Ship
    Its data type is CHAR (Character String) with field length 40
  • FLEET_NAME : Fleet Name
    Its data type is CHAR (Character String) with field length 40
  • SHIP_ID : Ship ID
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : General Description of Ship
  • ISM_VALID_FROM : Date from which ISM Certificate Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ISM_VALID_TO : Date until which ISM Certificate Stands Valid
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RATING_DATE : Rating date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RATING_CLS : Rating Class
    Its data type is CHAR (Character String) with field length 20
  • CLASSIFICATION : Classification of a Ship
    Its data type is CHAR (Character String) with field length 40
  • CLASSIFI_COMPANY : Classification Company
    Its data type is CHAR (Character String) with field length 6
  • COMMENTS : Description
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Purchase Details of Ship
  • PURCH_PRICE : Purchase Price
    Its data type is CURR (Currency Field) with field length 17
  • PURCH_CURR : Currency for purchase price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PURCH_PRICE_DATE : Purchase date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Construction Details of Ship
  • CONS_COUNTRY : Country where the Ship was Built
    Its data type is CHAR (Character String) with field length 3
  • CONS_PRICE : Cost incurred in Building the Ship
    Its data type is CURR (Currency Field) with field length 17
  • CONS_CURR : Currency for construction price
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DELIVERY_DATE : Date of Delivery of the ship
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCK : Shipyard where the Ship was Built
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Size Details of Ship
  • LENGTH : Ship length
    Its data type is QUAN (Quantity field) with field length 13
  • LENGTH_UOM : Unit of measure for the ship length
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BREADTH : Ship Beam
    Its data type is QUAN (Quantity field) with field length 13
  • BREADTH_UOM : Unit of measure for the breadth
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DEPTH : Ship Draught
    Its data type is QUAN (Quantity field) with field length 13
  • DEPTH_UOM : Unit of measure for the depth
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VOLUME : Volume of Ship
    Its data type is QUAN (Quantity field) with field length 13
  • VOLUME_UOM : Unit of Measure for the Ship Volume
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DWT : Weight of the Ship excluding the weight of Cargo
    Its data type is QUAN (Quantity field) with field length 13
  • DWT_UOM : Unit of measure for the dead weight tonnage
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • GROSST : Volume of the Interiors of a Ship
    Its data type is QUAN (Quantity field) with field length 13
  • GROSST_UOM : Unit of measure for the gross tonnage
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TRACK_LENGTH : Length of the Track in a Ship
    Its data type is QUAN (Quantity field) with field length 13
  • TRACK_LENGTH_UOM : Unit of Measure for the Track Length in a Ship
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • NUM_REF_CONT : Number of refrigerated containers
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • NUM_CONT_CAP : Container Capacity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • NUM_CABIN_ROOM : Number of Cabin Rooms
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • NUM_VEH_PARK : Number of Parking Units in the Vehicle Parking Bay
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • NUM_OF_PAX : Passenger Capacity of the Ship
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • ISOVR_CONTAINER : Indicator for Oversize Container Transportable in the Ship
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Technical Details of Ship
  • HULL_TYP : Hull Type
    Its data type is CHAR (Character String) with field length 6
  • MANUFR_MACHINE : Manufacturer of the Machine
    Its data type is CHAR (Character String) with field length 40
  • MACHINE_TYP : Name of the Engine Model
    Its data type is CHAR (Character String) with field length 40
  • NUM_MACHINES : Number of Main Machines Fitted in the Ship
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • CRANE_EQUIP : Crane Equipment fitted in the Ship
    Its data type is CHAR (Character String) with field length 40
  • POWER : Engine power
    Its data type is QUAN (Quantity field) with field length 13
  • POWER_UOM : Unit of measure for the horse power
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SPEED : Speed
    Its data type is QUAN (Quantity field) with field length 13
  • SPEED_UOM : Unit of measure for the speed
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FUEL_CONSUM : Fuel Consumption
    Its data type is QUAN (Quantity field) with field length 13
  • FUEL_CONSUM_UOM : Unit of measure for the fuel consumption
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Insurance Details of Ship
  • INSUR_PREMIUM : Insurance Premium
    Its data type is CURR (Currency Field) with field length 17
  • INSUR_PRE_CURR : Currency for insurance premium
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INSUR_TYPE : Insurance Type
    Its data type is CHAR (Character String) with field length 6
  • ANNUAL_DEP : Annual depreciation in percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • INSUR_VALID_TILL : Date of Expiry of the Insurance Policy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • POLICY_AMOUNT : Insurance Policy Amount
    Its data type is CURR (Currency Field) with field length 17
  • POLICY_CURR : Insurance Policy Amount Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • REQD_INSUR_COVER : Required Amount of Insurance Cover
    Its data type is CURR (Currency Field) with field length 17
  • REQD_INSUR_CURR : Required Insurance Cover Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • INSURER : Insurer
    Its data type is CHAR (Character String) with field length 6
  • CONTACT_FIRM : Contact Firm
    Its data type is CHAR (Character String) with field length 40
  • CONTACT_PERSON : Contact Person
    Its data type is CHAR (Character String) with field length 40
  • .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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • CMS_SHP related tables

    • CMS_SHP : Description of a Ship – Master Table
    • TCMS_SHP_TYP_T : Customizing table for Ship type (Text table)
    • TCMS_SHP_TYP : Customizing table for Ship type

    Related References

    Related Tutorials

    S410BIW1 SAP table for – S410BIW1 * SIS: Business Location Statistics via ‘Ship-to’ (

    S410BIW1 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of S410BIW1 * SIS:...

    S410BIW2 SAP table for – S410BIW2 * SIS: Business Location Statistics via ‘Ship-to’ (

    S410BIW2 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of S410BIW2 * SIS:...

    TCMS_SHP_TYP SAP table for – Customizing table for Ship type

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

    TCMS_SHP_TYP_T SAP table for – Customizing table for Ship type (Text table)

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

    GLISDEP SAP table for – Plan Line Item Table for Insurance (DE)

    GLISDEP table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Plan Line Item...

    GRISDEP SAP table for – Plan Line Item Table for Insurance (DE) – Rollup

    GRISDEP table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Plan Line Item...

    GRISDET SAP table for – Summary Table for Insurance (DE) – Rollup

    GRISDET table in SAP FS (Collections/Disbursements in FS) module. This table is used for storing data of Summary Table for...

    «
    »