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