The CMS_SHP table in SAP ERP or S/4HANA stores Description of a Ship – Master Table data. There are total 82 fields in CMS_SHP table. The Description of a Ship – Master Table table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_SHP table. It is in Ship: General tables and programs & Persistence layer (CMS_SHP) ABAP package and is part of the Ship (FS-CMS-MD-SHP) module.
SAP CMS_SHP Table Fields
Following is the list of fields that are available in SAP CMS_SHP table. The primary key fields of the table are MANDT (Client), SHP_GUID (Globally Unique Identifier).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| SHP_GUID | Globally Unique Identifier | OS_GUID | RAW (16) | |
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | * | RAW (16) |
| SHP_TYPE | Ship Type | CMS_DTE_SHP_TYP | TCMS_SHP_TYP | CHAR (6) |
| NAME | Ship name | CMS_DTE_SHP_NAME | CHAR (40) | |
| CHARTER_NAME | Charter Name used to Lease the Ship | CMS_DTE_SHP_CH_NAME | CHAR (40) | |
| CALL_SIGN | IMO Number | CMS_DTE_SHP_CALL_SIGN | CHAR (20) | |
| SHP_CLASS | Specifies whether the Ship is Sea Ship or Inland Ship | CMS_DTE_SHP_CLASS | CHAR (2) | |
| REG_NUMBER | Registration Number | CMS_DTE_SHP_REG_NUM | CHAR (20) | |
| REG_DATE | Registration date | CMS_DTE_SHP_REG_DATE | DATS (8) | |
| REG_PLACE | Registration place | CMS_DTE_SHP_REG_PLACE | CHAR (40) | |
| REG_COUNTRY | Registration country | CMS_DTE_SHP_REG_COUNTRY | T005 | CHAR (3) |
| EXTN_REF_ID | External reference ID for the Ship | CMS_DTE_SHP_OBJ_REFID | CHAR (40) | |
| FLEET_NAME | Fleet Name | CMS_DTE_SHP_FLEET_NAME | CHAR (40) | |
| SHIP_ID | Ship ID | CMS_DTE_SHP_ID | CHAR (40) | |
| ISM_VALID_FROM | Date from which ISM Certificate Stands Valid | CMS_DTE_SHP_ISM_FROM | DATS (8) | |
| ISM_VALID_TO | Date until which ISM Certificate Stands Valid | CMS_DTE_SHP_ISM_TO | DATS (8) | |
| RATING_DATE | Rating date | CMS_DTE_SHP_RATE_DATE | DATS (8) | |
| RATING_CLS | Rating Class | CMS_DTE_SHP_RATING_CLS | CHAR (20) | |
| CLASSIFICATION | Classification of a Ship | CMS_DTE_SHP_CLASSIFICATION | * | CHAR (40) |
| CLASSIFI_COMPANY | Classification Company | CMS_DTE_SHP_ATT_ID_TY_SHP002 | TCMS_ATT_ID_TY | CHAR (6) |
| COMMENTS | Description | CMS_DTE_SHP_COMMENTS | CHAR (40) | |
| PURCH_PRICE | Purchase Price | CMS_DTE_SHP_PUR_PRI | CURR (17) | |
| PURCH_CURR | Currency for purchase price | CMS_DTE_SHP_PUR_CURR | TCURC | CUKY (5) |
| PURCH_PRICE_DATE | Purchase date | CMS_DTE_SHP_PUR_DATE | DATS (8) | |
| CONS_COUNTRY | Country where the Ship was Built | CMS_DTE_SHP_CONS_COUNTRY | T005 | CHAR (3) |
| CONS_PRICE | Cost incurred in Building the Ship | CMS_DTE_SHP_CONS_PRICE | CURR (17) | |
| CONS_CURR | Currency for construction price | CMS_DTE_SHP_CONS_CURR | TCURC | CUKY (5) |
| DELIVERY_DATE | Date of Delivery of the ship | CMS_DTE_SHP_DELIVERY_DATE | DATS (8) | |
| DOCK | Shipyard where the Ship was Built | CMS_DTE_SHP_DOCK | CHAR (40) | |
| LENGTH | Ship length | CMS_DTE_SHP_LENGTH | QUAN (13) | |
| LENGTH_UOM | Unit of measure for the ship length | CMS_DTE_SHP_LENGTH_UOM | T006 | UNIT (3) |
| BREADTH | Ship Beam | CMS_DTE_SHP_BREADTH | QUAN (13) | |
| BREADTH_UOM | Unit of measure for the breadth | CMS_DTE_SHP_BREADTH_UOM | T006 | UNIT (3) |
| DEPTH | Ship Draught | CMS_DTE_SHP_DEPTH | QUAN (13) | |
| DEPTH_UOM | Unit of measure for the depth | CMS_DTE_SHP_DEPTH_UOM | T006 | UNIT (3) |
| VOLUME | Volume of Ship | CMS_DTE_SHP_VOLUME | QUAN (13) | |
| VOLUME_UOM | Unit of Measure for the Ship Volume | CMS_DTE_SHP_VOLUME_UOM | T006 | UNIT (3) |
| DWT | Weight of the Ship excluding the weight of Cargo | CMS_DTE_SHP_DWT | QUAN (13) | |
| DWT_UOM | Unit of measure for the dead weight tonnage | CMS_DTE_SHP_DWT_UOM | T006 | UNIT (3) |
| GROSST | Volume of the Interiors of a Ship | CMS_DTE_SHP_GROSST | QUAN (13) | |
| GROSST_UOM | Unit of measure for the gross tonnage | CMS_DTE_SHP_GROSST_UOM | T006 | UNIT (3) |
| TRACK_LENGTH | Length of the Track in a Ship | CMS_DTE_SHP_TRK_LEN | QUAN (13) | |
| TRACK_LENGTH_UOM | Unit of Measure for the Track Length in a Ship | CMS_DTE_SHP_TRK_LEN_UOM | T006 | UNIT (3) |
| NUM_REF_CONT | Number of refrigerated containers | CMS_DTE_SHP_NO_REF_CONT | DEC (10) | |
| NUM_CONT_CAP | Container Capacity | CMS_DTE_SHP_CONT_CAP | DEC (10) | |
| NUM_CABIN_ROOM | Number of Cabin Rooms | CMS_DTE_SHP_CAB_ROOM | DEC (10) | |
| NUM_VEH_PARK | Number of Parking Units in the Vehicle Parking Bay | CMS_DTE_SHP_NO_PARK | DEC (10) | |
| NUM_OF_PAX | Passenger Capacity of the Ship | CMS_DTE_SHP_NO_PAX | DEC (10) | |
| ISOVR_CONTAINER | Indicator for Oversize Container Transportable in the Ship | CMS_DTE_SHP_OVERSIZE_CONTAINER | CHAR (1) | |
| HULL_TYP | Hull Type | CMS_DTE_SHP_ATT_ID_TY_SHP001 | TCMS_ATT_ID_TY | CHAR (6) |
| MANUFR_MACHINE | Manufacturer of the Machine | CMS_DTE_SHP_MANUFR_MACHINE | CHAR (40) | |
| MACHINE_TYP | Name of the Engine Model | CMS_DTE_SHP_MAC_TYP | CHAR (40) | |
| NUM_MACHINES | Number of Main Machines Fitted in the Ship | CMS_DTE_SHP_NO_MACHINES | DEC (10) | |
| CRANE_EQUIP | Crane Equipment fitted in the Ship | CMS_DTE_SHP_CRANE_EQUIP | CHAR (40) | |
| POWER | Engine power | CMS_DTE_SHP_POWER | QUAN (13) | |
| POWER_UOM | Unit of measure for the horse power | CMS_DTE_SHP_POWER_UOM | T006 | UNIT (3) |
| SPEED | Speed | CMS_DTE_SHP_SPEED | QUAN (13) | |
| SPEED_UOM | Unit of measure for the speed | CMS_DTE_SHP_SPEED_UOM | * | UNIT (3) |
| FUEL_CONSUM | Fuel Consumption | CMS_DTE_SHP_FUEL_CONSUM | QUAN (13) | |
| FUEL_CONSUM_UOM | Unit of measure for the fuel consumption | CMS_DTE_SHP_FUEL_CONSUM_UOM | * | UNIT (3) |
| INSUR_PREMIUM | Insurance Premium | CMS_DTE_SHP_INSUR_PREMIUM | CURR (17) | |
| INSUR_PRE_CURR | Currency for insurance premium | CMS_DTE_SHP_INSUR_PREMIUM_CURR | TCURC | CUKY (5) |
| INSUR_TYPE | Insurance Type | CMS_DTE_SHP_ATT_ID_TY_SHP003 | TCMS_ATT_ID_TY | CHAR (6) |
| ANNUAL_DEP | Annual depreciation in percentage | CMS_DTE_SHP_ANNUAL_DEP | DEC (10) | |
| INSUR_VALID_TILL | Date of Expiry of the Insurance Policy | CMS_DTE_SHP_INSUR_VALID_TILL | DATS (8) | |
| POLICY_AMOUNT | Insurance Policy Amount | CMS_DTE_SHP_POLICY_AMOUNT | CURR (17) | |
| POLICY_CURR | Insurance Policy Amount Currency | CMS_DTE_SHP_POLICY_CURR | * | CUKY (5) |
| REQD_INSUR_COVER | Required Amount of Insurance Cover | CMS_DTE_SHP_REQD_INSUR_COVER | CURR (17) | |
| REQD_INSUR_CURR | Required Insurance Cover Currency | CMS_DTE_SHP_REQD_INSUR_CURR | * | CUKY (5) |
| INSURER | Insurer | CMS_DTE_SHP_ATT_ID_TY_SHP004 | TCMS_ATT_ID_TY | CHAR (6) |
| CONTACT_FIRM | Contact Firm | CMS_DTE_SHP_CONTACT_FIRM | CHAR (40) | |
| CONTACT_PERSON | Contact Person | CMS_DTE_SHP_CONTACT_PERSON | CHAR (40) | |
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR (12) | |
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | * | CHAR (4) |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR (12) | |
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC (15) | |
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR (12) | |
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC (15) | |
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR (32) | |
| BUPR_ID | Business Process ID | CMS_DTE_BUPR_ID | RAW (16) | |
| BUPR_TYPE_CODE | Business Process Type Code | CMS_DTE_BUPR_TYP_CODE | CHAR (6) |
