SAP Table CMS_SHP

Description of a Ship - Master Table

The table CMS_SHP (Description of a Ship - Master Table) is a standard table in SAP ERP. It belongs to the package CMS_SHP.

Technical Information

Table	CMS_SHP
Short Text	Description of a Ship - Master Table
Package	CMS_SHP
Table Type	Transparent Table

Fields for Table CMS_SHP

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
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	CHAR	6	TCMS_SHP_TYP
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	CHAR	3	T005
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	CHAR	6	TCMS_ATT_ID_TY
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	CUKY	5	TCURC
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	CHAR	3	T005
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	CUKY	5	TCURC
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	UNIT	3	T006
BREADTH		Ship Beam	CMS_DTE_SHP_BREADTH	QUAN	13
BREADTH_UOM		Unit of measure for the breadth	CMS_DTE_SHP_BREADTH_UOM	UNIT	3	T006
DEPTH		Ship Draught	CMS_DTE_SHP_DEPTH	QUAN	13
DEPTH_UOM		Unit of measure for the depth	CMS_DTE_SHP_DEPTH_UOM	UNIT	3	T006
VOLUME		Volume of Ship	CMS_DTE_SHP_VOLUME	QUAN	13
VOLUME_UOM		Unit of Measure for the Ship Volume	CMS_DTE_SHP_VOLUME_UOM	UNIT	3	T006
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	UNIT	3	T006
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	UNIT	3	T006
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	UNIT	3	T006
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	CHAR	6	TCMS_ATT_ID_TY
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	UNIT	3	T006
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	CUKY	5	TCURC
INSUR_TYPE		Insurance Type	CMS_DTE_SHP_ATT_ID_TY_SHP003	CHAR	6	TCMS_ATT_ID_TY
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	CHAR	6	TCMS_ATT_ID_TY
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