SAP ABAP Table CMS_STR_SHP_SHIP_DETAILS_MAP (MAPI : Ship details)

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	INTTAB	Structure
Structure	CMS_STR_SHP_SHIP_DETAILS_MAP	Table Relationship Diagram
Short Description	MAPI : Ship details

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SHP_SHIP_DETAILS_MAP	CLASSIFI_COMPANY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_STR_SHP_SHIP_DETAILS_MAP	HULL_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
3	CMS_STR_SHP_SHIP_DETAILS_MAP	INSURER	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
4	CMS_STR_SHP_SHIP_DETAILS_MAP	INSUR_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

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