SAP ABAP Table CMS_STR_SHP_DETAILS_MAP_CRT (MAPI : Ship details - Create)

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_DETAILS_MAP_CRT	Table Relationship Diagram
Short Description	MAPI : Ship details - Create

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	NAME	☐	CMS_DTE_SHP_NAME	CMS_SHP_NAME	CHAR	40	0	Ship name
2	CHARTER_NAME	☐	CMS_DTE_SHP_CH_NAME	CMS_SHP_NAME	CHAR	40	0	Charter Name used to Lease the Ship
3	SHIP_ID	☐	CMS_DTE_SHP_ID	CMS_SHP_ID	CHAR	40	0	Ship ID
4	CALL_SIGN	☐	CMS_DTE_SHP_CALL_SIGN	CMS_SHP_NUMBER	CHAR	20	0	IMO Number
5	SHP_CLASS	☐	CMS_DTE_SHP_CLASS	CMS_SHP_CLASS	CHAR	2	0	Specifies whether the Ship is Sea Ship or Inland Ship
6	REG_NUMBER	☐	CMS_DTE_SHP_REG_NUM	CMS_SHP_NUMBER	CHAR	20	0	Registration Number
7	REG_DATE	☐	CMS_DTE_SHP_REG_DATE	CMS_SHP_DATE	DATS	8	0	Registration date
8	REG_PLACE	☐	CMS_DTE_SHP_REG_PLACE	CMS_SHP_NAME	CHAR	40	0	Registration place
9	REG_COUNTRY	☐	CMS_DTE_SHP_REG_COUNTRY	LAND1	CHAR	3	0	Registration country	*
10	EXTN_REF_ID	☐	CMS_DTE_SHP_OBJ_REFID	CMS_SHP_NAME	CHAR	40	0	External reference ID for the Ship
11	FLEET_NAME	☐	CMS_DTE_SHP_FLEET_NAME	CMS_SHP_NAME	CHAR	40	0	Fleet Name
12	ISM_VALID_FROM	☐	CMS_DTE_SHP_ISM_FROM	CMS_SHP_DATE	DATS	8	0	Date from which ISM Certificate Stands Valid
13	ISM_VALID_TO	☐	CMS_DTE_SHP_ISM_TO	CMS_SHP_DATE	DATS	8	0	Date until which ISM Certificate Stands Valid
14	RATING_DATE	☐	CMS_DTE_SHP_RATE_DATE	CMS_SHP_DATE	DATS	8	0	Rating date
15	RATING_CLS	☐	CMS_DTE_SHP_RATING_CLS	CMS_SHP_RATING_CLS	CHAR	20	0	Rating Class
16	CLASSIFICATION	☐	CMS_DTE_SHP_CLASSIFICATION	CMS_SHP_NAME	CHAR	40	0	Classification of a Ship
17	CLASSIFI_COMPANY	☐	CMS_DTE_SHP_ATT_ID_TY_SHP002	CMS_ATT_ID_TYP	CHAR	6	0	Classification Company	TCMS_ATT_ID_TY
18	COMMENTS	☐	CMS_DTE_SHP_COMMENTS	CMS_SHP_NAME	CHAR	40	0	Description
19	CONS_COUNTRY	☐	CMS_DTE_SHP_CONS_COUNTRY	LAND1	CHAR	3	0	Country where the Ship was Built	*
20	CONS_PRICE	☐	CMS_DTE_SHP_CONS_PRICE	CMS_SHP_AMOUNT	CURR	17	2	Cost incurred in Building the Ship
21	CONS_CURR	☐	CMS_DTE_SHP_CONS_CURR	WAERS	CUKY	5	0	Currency for construction price	*
22	DELIVERY_DATE	☐	CMS_DTE_SHP_DELIVERY_DATE	CMS_SHP_DATE	DATS	8	0	Date of Delivery of the ship
23	DOCK	☐	CMS_DTE_SHP_DOCK	CMS_SHP_NAME	CHAR	40	0	Shipyard where the Ship was Built
24	LENGTH	☐	CMS_DTE_SHP_LENGTH	CMS_SHP_SIZE	QUAN	13	3	Ship length
25	LENGTH_UOM	☐	CMS_DTE_SHP_LENGTH_UOM	MEINS	UNIT	3	0	Unit of measure for the ship length	*
26	BREADTH	☐	CMS_DTE_SHP_BREADTH	CMS_SHP_SIZE	QUAN	13	3	Ship Beam
27	BREADTH_UOM	☐	CMS_DTE_SHP_BREADTH_UOM	MEINS	UNIT	3	0	Unit of measure for the breadth	*
28	DEPTH	☐	CMS_DTE_SHP_DEPTH	CMS_SHP_SIZE	QUAN	13	3	Ship Draught
29	DEPTH_UOM	☐	CMS_DTE_SHP_DEPTH_UOM	MEINS	UNIT	3	0	Unit of measure for the depth	*
30	VOLUME	☐	CMS_DTE_SHP_VOLUME	CMS_SHP_SIZE	QUAN	13	3	Volume of Ship
31	VOLUME_UOM	☐	CMS_DTE_SHP_VOLUME_UOM	MEINS	UNIT	3	0	Unit of Measure for the Ship Volume	*
32	DWT	☐	CMS_DTE_SHP_DWT	CMS_SHP_SIZE	QUAN	13	3	Weight of the Ship excluding the weight of Cargo
33	DWT_UOM	☐	CMS_DTE_SHP_DWT_UOM	MEINS	UNIT	3	0	Unit of measure for the dead weight tonnage	*
34	GROSST	☐	CMS_DTE_SHP_GROSST	CMS_SHP_SIZE	QUAN	13	3	Volume of the Interiors of a Ship
35	GROSST_UOM	☐	CMS_DTE_SHP_GROSST_UOM	MEINS	UNIT	3	0	Unit of measure for the gross tonnage	*
36	TRACK_LENGTH	☐	CMS_DTE_SHP_TRK_LEN	CMS_SHP_SIZE	QUAN	13	3	Length of the Track in a Ship
37	TRACK_LENGTH_UOM	☐	CMS_DTE_SHP_TRK_LEN_UOM	MEINS	UNIT	3	0	Unit of Measure for the Track Length in a Ship	*
38	NUM_REF_CONT	☐	CMS_DTE_SHP_NO_REF_CONT	CMS_SHP_INT	DEC	10	0	Number of refrigerated containers
39	NUM_CONT_CAP	☐	CMS_DTE_SHP_CONT_CAP	CMS_SHP_INT	DEC	10	0	Container Capacity
40	NUM_CABIN_ROOM	☐	CMS_DTE_SHP_CAB_ROOM	CMS_SHP_INT	DEC	10	0	Number of Cabin Rooms
41	NUM_VEH_PARK	☐	CMS_DTE_SHP_NO_PARK	CMS_SHP_INT	DEC	10	0	Number of Parking Units in the Vehicle Parking Bay
42	NUM_OF_PAX	☐	CMS_DTE_SHP_NO_PAX	CMS_SHP_INT	DEC	10	0	Passenger Capacity of the Ship
43	ISOVR_CONTAINER	☐	CMS_DTE_SHP_OVERSIZE_CONTAINER	CMS_SHP_FLG	CHAR	1	0	Indicator for Oversize Container Transportable in the Ship
44	HULL_TYP	☐	CMS_DTE_SHP_ATT_ID_TY_SHP001	CMS_ATT_ID_TYP	CHAR	6	0	Hull Type	TCMS_ATT_ID_TY
45	MANUFR_MACHINE	☐	CMS_DTE_SHP_MANUFR_MACHINE	CMS_SHP_NAME	CHAR	40	0	Manufacturer of the Machine
46	MACHINE_TYP	☐	CMS_DTE_SHP_MAC_TYP	CMS_SHP_NAME	CHAR	40	0	Name of the Engine Model
47	NUM_MACHINES	☐	CMS_DTE_SHP_NO_MACHINES	CMS_SHP_INT	DEC	10	0	Number of Main Machines Fitted in the Ship
48	CRANE_EQUIP	☐	CMS_DTE_SHP_CRANE_EQUIP	CMS_SHP_NAME	CHAR	40	0	Crane Equipment fitted in the Ship
49	POWER	☐	CMS_DTE_SHP_POWER	CMS_SHP_SIZE	QUAN	13	3	Engine power
50	POWER_UOM	☐	CMS_DTE_SHP_POWER_UOM	MEINS	UNIT	3	0	Unit of measure for the horse power	*
51	SPEED	☐	CMS_DTE_SHP_SPEED	CMS_SHP_SIZE	QUAN	13	3	Speed
52	SPEED_UOM	☐	CMS_DTE_SHP_SPEED_UOM	MEINS	UNIT	3	0	Unit of measure for the speed	*
53	FUEL_CONSUM	☐	CMS_DTE_SHP_FUEL_CONSUM	CMS_SHP_SIZE	QUAN	13	3	Fuel Consumption
54	FUEL_CONSUM_UOM	☐	CMS_DTE_SHP_FUEL_CONSUM_UOM	MEINS	UNIT	3	0	Unit of measure for the fuel consumption	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SHP_DETAILS_MAP_CRT	CLASSIFI_COMPANY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
2	CMS_STR_SHP_DETAILS_MAP_CRT	HULL_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN

History

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