SAP ABAP Table CMS_SHP (Description of a Ship - Master Table)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-SHP (Application Component) Ship
     ⤷ CMS_SHP (Package) Ship: General tables and programs & Persistence layer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMS_SHP	Table Relationship Diagram
Short Description	Description of a Ship - Master Table

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	.INCLUDE	☑				0	0	Primary key for Ship
3	SHP_GUID	☑	OS_GUID	SYSUUID	RAW	16	0	Globally Unique Identifier
4	.INCLUDE	☐				0	0	Asset Guid - Link key to Ship
5	AST_GUID	☐	CMS_DTE_AST_GUID	SYSUUID	RAW	16	0	GUID for Table CMS_AST	*
6	.INCLUDE	☐				0	0	Identification of Ship
7	SHP_TYPE	☐	CMS_DTE_SHP_TYP	CMS_SHP_TYP	CHAR	6	0	Ship Type	TCMS_SHP_TYP
8	NAME	☐	CMS_DTE_SHP_NAME	CMS_SHP_NAME	CHAR	40	0	Ship name
9	CHARTER_NAME	☐	CMS_DTE_SHP_CH_NAME	CMS_SHP_NAME	CHAR	40	0	Charter Name used to Lease the Ship
10	CALL_SIGN	☐	CMS_DTE_SHP_CALL_SIGN	CMS_SHP_NUMBER	CHAR	20	0	IMO Number
11	SHP_CLASS	☐	CMS_DTE_SHP_CLASS	CMS_SHP_CLASS	CHAR	2	0	Specifies whether the Ship is Sea Ship or Inland Ship
12	REG_NUMBER	☐	CMS_DTE_SHP_REG_NUM	CMS_SHP_NUMBER	CHAR	20	0	Registration Number
13	REG_DATE	☐	CMS_DTE_SHP_REG_DATE	CMS_SHP_DATE	DATS	8	0	Registration date
14	REG_PLACE	☐	CMS_DTE_SHP_REG_PLACE	CMS_SHP_NAME	CHAR	40	0	Registration place
15	REG_COUNTRY	☐	CMS_DTE_SHP_REG_COUNTRY	LAND1	CHAR	3	0	Registration country	T005
16	EXTN_REF_ID	☐	CMS_DTE_SHP_OBJ_REFID	CMS_SHP_NAME	CHAR	40	0	External reference ID for the Ship
17	FLEET_NAME	☐	CMS_DTE_SHP_FLEET_NAME	CMS_SHP_NAME	CHAR	40	0	Fleet Name
18	SHIP_ID	☐	CMS_DTE_SHP_ID	CMS_SHP_ID	CHAR	40	0	Ship ID
19	.INCLUDE	☐				0	0	General Description of Ship
20	ISM_VALID_FROM	☐	CMS_DTE_SHP_ISM_FROM	CMS_SHP_DATE	DATS	8	0	Date from which ISM Certificate Stands Valid
21	ISM_VALID_TO	☐	CMS_DTE_SHP_ISM_TO	CMS_SHP_DATE	DATS	8	0	Date until which ISM Certificate Stands Valid
22	RATING_DATE	☐	CMS_DTE_SHP_RATE_DATE	CMS_SHP_DATE	DATS	8	0	Rating date
23	RATING_CLS	☐	CMS_DTE_SHP_RATING_CLS	CMS_SHP_RATING_CLS	CHAR	20	0	Rating Class
24	CLASSIFICATION	☐	CMS_DTE_SHP_CLASSIFICATION	CMS_SHP_NAME	CHAR	40	0	Classification of a Ship	*
25	CLASSIFI_COMPANY	☐	CMS_DTE_SHP_ATT_ID_TY_SHP002	CMS_ATT_ID_TYP	CHAR	6	0	Classification Company	TCMS_ATT_ID_TY
26	COMMENTS	☐	CMS_DTE_SHP_COMMENTS	CMS_SHP_NAME	CHAR	40	0	Description
27	.INCLUDE	☐				0	0	Purchase Details of Ship
28	PURCH_PRICE	☐	CMS_DTE_SHP_PUR_PRI	CMS_SHP_AMOUNT	CURR	17	2	Purchase Price
29	PURCH_CURR	☐	CMS_DTE_SHP_PUR_CURR	WAERS	CUKY	5	0	Currency for purchase price	TCURC
30	PURCH_PRICE_DATE	☐	CMS_DTE_SHP_PUR_DATE	CMS_SHP_DATE	DATS	8	0	Purchase date
31	.INCLUDE	☐				0	0	Construction Details of Ship
32	CONS_COUNTRY	☐	CMS_DTE_SHP_CONS_COUNTRY	LAND1	CHAR	3	0	Country where the Ship was Built	T005
33	CONS_PRICE	☐	CMS_DTE_SHP_CONS_PRICE	CMS_SHP_AMOUNT	CURR	17	2	Cost incurred in Building the Ship
34	CONS_CURR	☐	CMS_DTE_SHP_CONS_CURR	WAERS	CUKY	5	0	Currency for construction price	TCURC
35	DELIVERY_DATE	☐	CMS_DTE_SHP_DELIVERY_DATE	CMS_SHP_DATE	DATS	8	0	Date of Delivery of the ship
36	DOCK	☐	CMS_DTE_SHP_DOCK	CMS_SHP_NAME	CHAR	40	0	Shipyard where the Ship was Built
37	.INCLUDE	☐				0	0	Size Details of Ship
38	LENGTH	☐	CMS_DTE_SHP_LENGTH	CMS_SHP_SIZE	QUAN	13	3	Ship length
39	LENGTH_UOM	☐	CMS_DTE_SHP_LENGTH_UOM	MEINS	UNIT	3	0	Unit of measure for the ship length	T006
40	BREADTH	☐	CMS_DTE_SHP_BREADTH	CMS_SHP_SIZE	QUAN	13	3	Ship Beam
41	BREADTH_UOM	☐	CMS_DTE_SHP_BREADTH_UOM	MEINS	UNIT	3	0	Unit of measure for the breadth	T006
42	DEPTH	☐	CMS_DTE_SHP_DEPTH	CMS_SHP_SIZE	QUAN	13	3	Ship Draught
43	DEPTH_UOM	☐	CMS_DTE_SHP_DEPTH_UOM	MEINS	UNIT	3	0	Unit of measure for the depth	T006
44	VOLUME	☐	CMS_DTE_SHP_VOLUME	CMS_SHP_SIZE	QUAN	13	3	Volume of Ship
45	VOLUME_UOM	☐	CMS_DTE_SHP_VOLUME_UOM	MEINS	UNIT	3	0	Unit of Measure for the Ship Volume	T006
46	DWT	☐	CMS_DTE_SHP_DWT	CMS_SHP_SIZE	QUAN	13	3	Weight of the Ship excluding the weight of Cargo
47	DWT_UOM	☐	CMS_DTE_SHP_DWT_UOM	MEINS	UNIT	3	0	Unit of measure for the dead weight tonnage	T006
48	GROSST	☐	CMS_DTE_SHP_GROSST	CMS_SHP_SIZE	QUAN	13	3	Volume of the Interiors of a Ship
49	GROSST_UOM	☐	CMS_DTE_SHP_GROSST_UOM	MEINS	UNIT	3	0	Unit of measure for the gross tonnage	T006
50	TRACK_LENGTH	☐	CMS_DTE_SHP_TRK_LEN	CMS_SHP_SIZE	QUAN	13	3	Length of the Track in a Ship
51	TRACK_LENGTH_UOM	☐	CMS_DTE_SHP_TRK_LEN_UOM	MEINS	UNIT	3	0	Unit of Measure for the Track Length in a Ship	T006
52	NUM_REF_CONT	☐	CMS_DTE_SHP_NO_REF_CONT	CMS_SHP_INT	DEC	10	0	Number of refrigerated containers
53	NUM_CONT_CAP	☐	CMS_DTE_SHP_CONT_CAP	CMS_SHP_INT	DEC	10	0	Container Capacity
54	NUM_CABIN_ROOM	☐	CMS_DTE_SHP_CAB_ROOM	CMS_SHP_INT	DEC	10	0	Number of Cabin Rooms
55	NUM_VEH_PARK	☐	CMS_DTE_SHP_NO_PARK	CMS_SHP_INT	DEC	10	0	Number of Parking Units in the Vehicle Parking Bay
56	NUM_OF_PAX	☐	CMS_DTE_SHP_NO_PAX	CMS_SHP_INT	DEC	10	0	Passenger Capacity of the Ship
57	ISOVR_CONTAINER	☐	CMS_DTE_SHP_OVERSIZE_CONTAINER	CMS_SHP_FLG	CHAR	1	0	Indicator for Oversize Container Transportable in the Ship
58	.INCLUDE	☐				0	0	Technical Details of Ship
59	HULL_TYP	☐	CMS_DTE_SHP_ATT_ID_TY_SHP001	CMS_ATT_ID_TYP	CHAR	6	0	Hull Type	TCMS_ATT_ID_TY
60	MANUFR_MACHINE	☐	CMS_DTE_SHP_MANUFR_MACHINE	CMS_SHP_NAME	CHAR	40	0	Manufacturer of the Machine
61	MACHINE_TYP	☐	CMS_DTE_SHP_MAC_TYP	CMS_SHP_NAME	CHAR	40	0	Name of the Engine Model
62	NUM_MACHINES	☐	CMS_DTE_SHP_NO_MACHINES	CMS_SHP_INT	DEC	10	0	Number of Main Machines Fitted in the Ship
63	CRANE_EQUIP	☐	CMS_DTE_SHP_CRANE_EQUIP	CMS_SHP_NAME	CHAR	40	0	Crane Equipment fitted in the Ship
64	POWER	☐	CMS_DTE_SHP_POWER	CMS_SHP_SIZE	QUAN	13	3	Engine power
65	POWER_UOM	☐	CMS_DTE_SHP_POWER_UOM	MEINS	UNIT	3	0	Unit of measure for the horse power	T006
66	SPEED	☐	CMS_DTE_SHP_SPEED	CMS_SHP_SIZE	QUAN	13	3	Speed
67	SPEED_UOM	☐	CMS_DTE_SHP_SPEED_UOM	MEINS	UNIT	3	0	Unit of measure for the speed	*
68	FUEL_CONSUM	☐	CMS_DTE_SHP_FUEL_CONSUM	CMS_SHP_SIZE	QUAN	13	3	Fuel Consumption
69	FUEL_CONSUM_UOM	☐	CMS_DTE_SHP_FUEL_CONSUM_UOM	MEINS	UNIT	3	0	Unit of measure for the fuel consumption	*
70	.INCLUDE	☐				0	0	Insurance Details of Ship
71	INSUR_PREMIUM	☐	CMS_DTE_SHP_INSUR_PREMIUM	CMS_SHP_AMOUNT	CURR	17	2	Insurance Premium
72	INSUR_PRE_CURR	☐	CMS_DTE_SHP_INSUR_PREMIUM_CURR	WAERS	CUKY	5	0	Currency for insurance premium	TCURC
73	INSUR_TYPE	☐	CMS_DTE_SHP_ATT_ID_TY_SHP003	CMS_ATT_ID_TYP	CHAR	6	0	Insurance Type	TCMS_ATT_ID_TY
74	ANNUAL_DEP	☐	CMS_DTE_SHP_ANNUAL_DEP	CMS_SHP_PCT	DEC	10	6	Annual depreciation in percentage
75	INSUR_VALID_TILL	☐	CMS_DTE_SHP_INSUR_VALID_TILL	CMS_SHP_DATE	DATS	8	0	Date of Expiry of the Insurance Policy
76	POLICY_AMOUNT	☐	CMS_DTE_SHP_POLICY_AMOUNT	CMS_SHP_AMOUNT	CURR	17	2	Insurance Policy Amount
77	POLICY_CURR	☐	CMS_DTE_SHP_POLICY_CURR	WAERS	CUKY	5	0	Insurance Policy Amount Currency	*
78	REQD_INSUR_COVER	☐	CMS_DTE_SHP_REQD_INSUR_COVER	CMS_SHP_AMOUNT	CURR	17	2	Required Amount of Insurance Cover
79	REQD_INSUR_CURR	☐	CMS_DTE_SHP_REQD_INSUR_CURR	WAERS	CUKY	5	0	Required Insurance Cover Currency	*
80	INSURER	☐	CMS_DTE_SHP_ATT_ID_TY_SHP004	CMS_ATT_ID_TYP	CHAR	6	0	Insurer	TCMS_ATT_ID_TY
81	CONTACT_FIRM	☐	CMS_DTE_SHP_CONTACT_FIRM	CMS_SHP_NAME	CHAR	40	0	Contact Firm
82	CONTACT_PERSON	☐	CMS_DTE_SHP_CONTACT_PERSON	CMS_SHP_NAME	CHAR	40	0	Contact Person
83	.INCLUDE	☐				0	0	Administrative organization unit
84	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
85	.INCLUDE	☐				0	0	Bank area
86	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management	*
87	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
88	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
89	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
90	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
91	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
92	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry
93	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_SHP	BREADTH_UOM	T006	MSEHI	REF	1	CN
2	CMS_SHP	CLASSIFI_COMPANY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
3	CMS_SHP	CONS_COUNTRY	T005	LAND1	REF	1	CN
4	CMS_SHP	CONS_CURR	TCURC	WAERS	REF	1	CN
5	CMS_SHP	DEPTH_UOM	T006	MSEHI	REF	1	CN
6	CMS_SHP	DWT_UOM	T006	MSEHI	REF	1	CN
7	CMS_SHP	GROSST_UOM	T006	MSEHI	REF	1	CN
8	CMS_SHP	HULL_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
9	CMS_SHP	INSURER	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
10	CMS_SHP	INSUR_PRE_CURR	TCURC	WAERS	REF	1	CN
11	CMS_SHP	INSUR_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
12	CMS_SHP	LENGTH_UOM	T006	MSEHI	REF	1	CN
13	CMS_SHP	MANDT	T000	MANDT	KEY	1	CN
14	CMS_SHP	POWER_UOM	T006	MSEHI	REF	1	CN
15	CMS_SHP	PURCH_CURR	TCURC	WAERS	REF	1	CN
16	CMS_SHP	REG_COUNTRY	T005	LAND1	REF	1	CN
17	CMS_SHP	TRACK_LENGTH_UOM	T006	MSEHI	REF	1	CN
18	CMS_SHP	VOLUME_UOM	T006	MSEHI	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	200