SAP CMS_SHP Description of a Ship - Master Table Table data and field list

CMS_SHP is a standard SAP Table which is used to store Description of a Ship - Master Table data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_SHP table consists of various fields, each holding specific information or linking keys about Description of a Ship - Master Table data available in SAP. These include SHP_GUID (Globally Unique Identifier), AST_GUID (GUID for Table CMS_AST), SHP_TYPE (Ship Type), NAME (Ship name)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CMS_SHP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP CMS_SHP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_SHP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
SHP_GUID	Globally Unique Identifier	OS_GUID	RAW	16			SYSUUID
AST_GUID	GUID for Table CMS_AST	CMS_DTE_AST_GUID	RAW	16	Assigned to domain		SYSUUID
SHP_TYPE	Ship Type	CMS_DTE_SHP_TYP	CHAR	6	TCMS_SHP_TYP		CMS_SHP_TYP	CMS_SHP_TYP
NAME	Ship name	CMS_DTE_SHP_NAME	CHAR	40			CMS_SHP_NAME	CMS_SHP_NAME
CHARTER_NAME	Charter Name used to Lease the Ship	CMS_DTE_SHP_CH_NAME	CHAR	40			CMS_SHP_NAME	CMS_SHP_CH_NAME
CALL_SIGN	IMO Number	CMS_DTE_SHP_CALL_SIGN	CHAR	20			CMS_SHP_NUMBER
SHP_CLASS	Specifies whether the Ship is Sea Ship or Inland Ship	CMS_DTE_SHP_CLASS	CHAR	2			CMS_SHP_CLASS
REG_NUMBER	Registration Number	CMS_DTE_SHP_REG_NUM	CHAR	20			CMS_SHP_NUMBER
REG_DATE	Registration date	CMS_DTE_SHP_REG_DATE	DATS	8			CMS_SHP_DATE
REG_PLACE	Registration place	CMS_DTE_SHP_REG_PLACE	CHAR	40			CMS_SHP_NAME
REG_COUNTRY	Registration country	CMS_DTE_SHP_REG_COUNTRY	CHAR	3	T005		LAND1
EXTN_REF_ID	External reference ID for the Ship	CMS_DTE_SHP_OBJ_REFID	CHAR	40			CMS_SHP_NAME
FLEET_NAME	Fleet Name	CMS_DTE_SHP_FLEET_NAME	CHAR	40			CMS_SHP_NAME
SHIP_ID	Ship ID	CMS_DTE_SHP_ID	CHAR	40		ALPHA	CMS_SHP_ID	CMS_SHP_ID
ISM_VALID_FROM	Date from which ISM Certificate Stands Valid	CMS_DTE_SHP_ISM_FROM	DATS	8			CMS_SHP_DATE
ISM_VALID_TO	Date until which ISM Certificate Stands Valid	CMS_DTE_SHP_ISM_TO	DATS	8			CMS_SHP_DATE
RATING_DATE	Rating date	CMS_DTE_SHP_RATE_DATE	DATS	8			CMS_SHP_DATE
RATING_CLS	Rating Class	CMS_DTE_SHP_RATING_CLS	CHAR	20			CMS_SHP_RATING_CLS
CLASSIFICATION	Classification of a Ship	CMS_DTE_SHP_CLASSIFICATION	CHAR	40	Assigned to domain		CMS_SHP_NAME
CLASSIFI_COMPANY	Classification Company	CMS_DTE_SHP_ATT_ID_TY_SHP002	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
COMMENTS	Description	CMS_DTE_SHP_COMMENTS	CHAR	40			CMS_SHP_NAME
PURCH_PRICE	Purchase Price	CMS_DTE_SHP_PUR_PRI	CURR	17(2)			CMS_SHP_AMOUNT
PURCH_CURR	Currency for purchase price	CMS_DTE_SHP_PUR_CURR	CUKY	5	TCURC		WAERS
PURCH_PRICE_DATE	Purchase date	CMS_DTE_SHP_PUR_DATE	DATS	8			CMS_SHP_DATE
CONS_COUNTRY	Country where the Ship was Built	CMS_DTE_SHP_CONS_COUNTRY	CHAR	3	T005		LAND1
CONS_PRICE	Cost incurred in Building the Ship	CMS_DTE_SHP_CONS_PRICE	CURR	17(2)			CMS_SHP_AMOUNT
CONS_CURR	Currency for construction price	CMS_DTE_SHP_CONS_CURR	CUKY	5	TCURC		WAERS
DELIVERY_DATE	Date of Delivery of the ship	CMS_DTE_SHP_DELIVERY_DATE	DATS	8			CMS_SHP_DATE
DOCK	Shipyard where the Ship was Built	CMS_DTE_SHP_DOCK	CHAR	40			CMS_SHP_NAME
LENGTH	Ship length	CMS_DTE_SHP_LENGTH	QUAN	13(3)			CMS_SHP_SIZE
LENGTH_UOM	Unit of measure for the ship length	CMS_DTE_SHP_LENGTH_UOM	UNIT	3	T006	CUNIT	MEINS
BREADTH	Ship Beam	CMS_DTE_SHP_BREADTH	QUAN	13(3)			CMS_SHP_SIZE
BREADTH_UOM	Unit of measure for the breadth	CMS_DTE_SHP_BREADTH_UOM	UNIT	3	T006	CUNIT	MEINS
DEPTH	Ship Draught	CMS_DTE_SHP_DEPTH	QUAN	13(3)			CMS_SHP_SIZE
DEPTH_UOM	Unit of measure for the depth	CMS_DTE_SHP_DEPTH_UOM	UNIT	3	T006	CUNIT	MEINS
VOLUME	Volume of Ship	CMS_DTE_SHP_VOLUME	QUAN	13(3)			CMS_SHP_SIZE
VOLUME_UOM	Unit of Measure for the Ship Volume	CMS_DTE_SHP_VOLUME_UOM	UNIT	3	T006	CUNIT	MEINS		CMS_ELM_VOLUME_UOM
DWT	Weight of the Ship excluding the weight of Cargo	CMS_DTE_SHP_DWT	QUAN	13(3)			CMS_SHP_SIZE
DWT_UOM	Unit of measure for the dead weight tonnage	CMS_DTE_SHP_DWT_UOM	UNIT	3	T006	CUNIT	MEINS
GROSST	Volume of the Interiors of a Ship	CMS_DTE_SHP_GROSST	QUAN	13(3)			CMS_SHP_SIZE
GROSST_UOM	Unit of measure for the gross tonnage	CMS_DTE_SHP_GROSST_UOM	UNIT	3	T006	CUNIT	MEINS
TRACK_LENGTH	Length of the Track in a Ship	CMS_DTE_SHP_TRK_LEN	QUAN	13(3)			CMS_SHP_SIZE
TRACK_LENGTH_UOM	Unit of Measure for the Track Length in a Ship	CMS_DTE_SHP_TRK_LEN_UOM	UNIT	3	T006	CUNIT	MEINS
NUM_REF_CONT	Number of refrigerated containers	CMS_DTE_SHP_NO_REF_CONT	DEC	10			CMS_SHP_INT
NUM_CONT_CAP	Container Capacity	CMS_DTE_SHP_CONT_CAP	DEC	10			CMS_SHP_INT
NUM_CABIN_ROOM	Number of Cabin Rooms	CMS_DTE_SHP_CAB_ROOM	DEC	10			CMS_SHP_INT
NUM_VEH_PARK	Number of Parking Units in the Vehicle Parking Bay	CMS_DTE_SHP_NO_PARK	DEC	10			CMS_SHP_INT
NUM_OF_PAX	Passenger Capacity of the Ship	CMS_DTE_SHP_NO_PAX	DEC	10			CMS_SHP_INT
ISOVR_CONTAINER	Indicator for Oversize Container Transportable in the Ship	CMS_DTE_SHP_OVERSIZE_CONTAINER	CHAR	1			CMS_SHP_FLG
HULL_TYP	Hull Type	CMS_DTE_SHP_ATT_ID_TY_SHP001	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
MANUFR_MACHINE	Manufacturer of the Machine	CMS_DTE_SHP_MANUFR_MACHINE	CHAR	40			CMS_SHP_NAME
MACHINE_TYP	Name of the Engine Model	CMS_DTE_SHP_MAC_TYP	CHAR	40			CMS_SHP_NAME
NUM_MACHINES	Number of Main Machines Fitted in the Ship	CMS_DTE_SHP_NO_MACHINES	DEC	10			CMS_SHP_INT
CRANE_EQUIP	Crane Equipment fitted in the Ship	CMS_DTE_SHP_CRANE_EQUIP	CHAR	40			CMS_SHP_NAME
POWER	Engine power	CMS_DTE_SHP_POWER	QUAN	13(3)			CMS_SHP_SIZE
POWER_UOM	Unit of measure for the horse power	CMS_DTE_SHP_POWER_UOM	UNIT	3	T006	CUNIT	MEINS
SPEED	Speed	CMS_DTE_SHP_SPEED	QUAN	13(3)			CMS_SHP_SIZE
SPEED_UOM	Unit of measure for the speed	CMS_DTE_SHP_SPEED_UOM	UNIT	3	Assigned to domain	CUNIT	MEINS
FUEL_CONSUM	Fuel Consumption	CMS_DTE_SHP_FUEL_CONSUM	QUAN	13(3)			CMS_SHP_SIZE
FUEL_CONSUM_UOM	Unit of measure for the fuel consumption	CMS_DTE_SHP_FUEL_CONSUM_UOM	UNIT	3	Assigned to domain	CUNIT	MEINS
INSUR_PREMIUM	Insurance Premium	CMS_DTE_SHP_INSUR_PREMIUM	CURR	17(2)			CMS_SHP_AMOUNT
INSUR_PRE_CURR	Currency for insurance premium	CMS_DTE_SHP_INSUR_PREMIUM_CURR	CUKY	5	TCURC		WAERS
INSUR_TYPE	Insurance Type	CMS_DTE_SHP_ATT_ID_TY_SHP003	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
ANNUAL_DEP	Annual depreciation in percentage	CMS_DTE_SHP_ANNUAL_DEP	DEC	10(6)			CMS_SHP_PCT
INSUR_VALID_TILL	Date of Expiry of the Insurance Policy	CMS_DTE_SHP_INSUR_VALID_TILL	DATS	8			CMS_SHP_DATE
POLICY_AMOUNT	Insurance Policy Amount	CMS_DTE_SHP_POLICY_AMOUNT	CURR	17(2)			CMS_SHP_AMOUNT
POLICY_CURR	Insurance Policy Amount Currency	CMS_DTE_SHP_POLICY_CURR	CUKY	5	Assigned to domain		WAERS
REQD_INSUR_COVER	Required Amount of Insurance Cover	CMS_DTE_SHP_REQD_INSUR_COVER	CURR	17(2)			CMS_SHP_AMOUNT
REQD_INSUR_CURR	Required Insurance Cover Currency	CMS_DTE_SHP_REQD_INSUR_CURR	CUKY	5	Assigned to domain		WAERS
INSURER	Insurer	CMS_DTE_SHP_ATT_ID_TY_SHP004	CHAR	6	TCMS_ATT_ID_TY		CMS_ATT_ID_TYP
CONTACT_FIRM	Contact Firm	CMS_DTE_SHP_CONTACT_FIRM	CHAR	40			CMS_SHP_NAME
CONTACT_PERSON	Contact Person	CMS_DTE_SHP_CONTACT_PERSON	CHAR	40			CMS_SHP_NAME
ADMIN_ORG_UNIT	Administration Organizational Unit	CMS_DTE_ADMINORG	CHAR	12			TEXT12	CMS_ADMINORG
BANKAREA	Bank Area in Collateral Management	CMS_DTE_BANKAREA	CHAR	4	Assigned to domain		CMS_BANKAREA	CMS_BANKAREA
CREATED_BY	Login ID of the User who created the Record	CMS_DTE_USER	CHAR	12			CMS_USER
CREATED_AT	Creation Timestamp	CMS_DTE_CREATED_AT	DEC	15			TZNTSTMPS
CHANGED_BY	Last Changed By	CMS_DTE_LAST_CHNG_USER	CHAR	12			CMS_USER
CHANGED_AT	Change Timestamp	CMS_DTE_CHANGED_AT	DEC	15			TZNTSTMPS
SOURCEOFENTRY	Source of Entry	CMS_DTE_SOURCE_OF_ENTRY	CHAR	32			CMS_SOURCE

Key field

Non-key field

< CMS_SEC_VALUE - Securities value details for every ISIN CMS_STR_ACG - Approcved Coverage Gap Details >

How do I retrieve data from SAP table CMS_SHP using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_SHP to SELECT all data from the table
DATA: WA_CMS_SHP TYPE CMS_SHP.

SELECT SINGLE *
FROM CMS_SHP
INTO CORRESPONDING FIELDS OF WA_CMS_SHP
WHERE...

How to access SAP table CMS_SHP

Within an ECC or HANA version of SAP you can also view further information about CMS_SHP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).