CMS_SHP

Description of a Ship - Master Table | #masterdata | Component: Ship
Column Name Description
MANDT FK Client
SHP_GUID Globally Unique Identifier
Column Name Description
💲 Currency for purchase price (PURCH_CURR):
PURCH_PRICE Purchase Price
💲 Currency for construction price (CONS_CURR):
CONS_PRICE Cost incurred in Building the Ship
💲 Currency for insurance premium (INSUR_PRE_CURR):
INSUR_PREMIUM Insurance Premium
💲 Insurance Policy Amount Currency (POLICY_CURR):
POLICY_AMOUNT Insurance Policy Amount
💲 Required Insurance Cover Currency (REQD_INSUR_CURR):
REQD_INSUR_COVER Required Amount of Insurance Cover
Column Name Description
📏 Unit of measure for the ship length (LENGTH_UOM):
LENGTH Ship length
📏 Unit of measure for the breadth (BREADTH_UOM):
BREADTH Ship Beam
📏 Unit of measure for the depth (DEPTH_UOM):
DEPTH Ship Draught
📏 Unit of Measure for the Ship Volume (VOLUME_UOM):
VOLUME Volume of Ship
📏 Unit of measure for the dead weight tonnage (DWT_UOM):
DWT Weight of the Ship excluding the weight of Cargo
📏 Unit of measure for the gross tonnage (GROSST_UOM):
GROSST Volume of the Interiors of a Ship
📏 Unit of Measure for the Track Length in a Ship (TRACK_LENGTH_UOM):
TRACK_LENGTH Length of the Track in a Ship
📏 Unit of measure for the horse power (POWER_UOM):
POWER Engine power
📏 Unit of measure for the speed (SPEED_UOM):
SPEED Speed
📏 Unit of measure for the fuel consumption (FUEL_CONSUM_UOM):
FUEL_CONSUM Fuel Consumption
Column Name Description
REG_DATE Registration date
ISM_VALID_FROM Date from which ISM Certificate Stands Valid
ISM_VALID_TO Date until which ISM Certificate Stands Valid
RATING_DATE Rating date
PURCH_PRICE_DATE Purchase date
DELIVERY_DATE Date of Delivery of the ship
INSUR_VALID_TILL Date of Expiry of the Insurance Policy
Column Name Description
SHP_CLASS Specifies whether the Ship is Sea Ship or Inland Ship Show values
ISOVR_CONTAINER Indicator for Oversize Container Transportable in the Ship Show values
Column Name Description Domain name
NAME Ship name CMS_SHP_NAME
CHARTER_NAME Charter Name used to Lease the Ship CMS_SHP_NAME
CALL_SIGN IMO Number CMS_SHP_NUMBER
REG_NUMBER Registration Number CMS_SHP_NUMBER
REG_PLACE Registration place CMS_SHP_NAME
EXTN_REF_ID External reference ID for the Ship CMS_SHP_NAME
FLEET_NAME Fleet Name CMS_SHP_NAME
SHIP_ID Ship ID CMS_SHP_ID
RATING_CLS Rating Class CMS_SHP_RATING_CLS
COMMENTS Description CMS_SHP_NAME
DOCK Shipyard where the Ship was Built CMS_SHP_NAME
NUM_REF_CONT Number of refrigerated containers CMS_SHP_INT
NUM_CONT_CAP Container Capacity CMS_SHP_INT
NUM_CABIN_ROOM Number of Cabin Rooms CMS_SHP_INT
NUM_VEH_PARK Number of Parking Units in the Vehicle Parking Bay CMS_SHP_INT
NUM_OF_PAX Passenger Capacity of the Ship CMS_SHP_INT
MANUFR_MACHINE Manufacturer of the Machine CMS_SHP_NAME
MACHINE_TYP Name of the Engine Model CMS_SHP_NAME
NUM_MACHINES Number of Main Machines Fitted in the Ship CMS_SHP_INT
CRANE_EQUIP Crane Equipment fitted in the Ship CMS_SHP_NAME
ANNUAL_DEP Annual depreciation in percentage CMS_SHP_PCT
CONTACT_FIRM Contact Firm CMS_SHP_NAME
CONTACT_PERSON Contact Person CMS_SHP_NAME
ADMIN_ORG_UNIT Administration Organizational Unit TEXT12
BANKAREA Bank Area in Collateral Management CMS_BANKAREA
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
BUPR_ID Business Process ID SYSUUID
BUPR_TYPE_CODE Business Process Type Code CMS_BUPR_TYP_CODE
Master Data Relations Join Conditions
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.BREADTH_UOM == T006.MSEHI
Classification Company
  • ?
  • Client
  • Classification Company
Country/Region where the Ship was Built
  • Country/Region where the Ship was Built
  • Client
  • CMS_SHP.CONS_COUNTRY == T005.LAND1
  • CMS_SHP.MANDT == T005.MANDT
Foreign key for Currency
  • CMS_SHP.MANDT == TCURC.MANDT
  • CMS_SHP.CONS_CURR == TCURC.WAERS
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.DEPTH_UOM == T006.MSEHI
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.DWT_UOM == T006.MSEHI
Unit of measure for the gross tonnage
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.GROSST_UOM == T006.MSEHI
Hull Type
  • ?
  • Client
  • Hull Type
Insurer
  • ?
  • Client
  • Insurer
Foreign key for Currency
  • CMS_SHP.MANDT == TCURC.MANDT
  • CMS_SHP.INSUR_PRE_CURR == TCURC.WAERS
Insurance Type
  • ?
  • Client
  • Insurance Type
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.LENGTH_UOM == T006.MSEHI
Foreign key for Client CMS_SHP.MANDT == T000.MANDT
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.POWER_UOM == T006.MSEHI
Foreign key for Currency
  • CMS_SHP.MANDT == TCURC.MANDT
  • CMS_SHP.PURCH_CURR == TCURC.WAERS
Registration Country/Region
  • Registration Country/Region
  • Client
  • CMS_SHP.REG_COUNTRY == T005.LAND1
  • CMS_SHP.MANDT == T005.MANDT
Foreign key for Ship Type CMS_SHP.MANDT == TCMS_SHP_TYP.MANDT
Foreign key for Unit of measure
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.TRACK_LENGTH_UOM == T006.MSEHI
Unit of Measure for the Ship Volume
  • CMS_SHP.MANDT == T006.MANDT
  • CMS_SHP.VOLUME_UOM == T006.MSEHI