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 |