SAP ABAP Table CMS_STR_SHP_SHIP_DETAILS (Ship Details (without MANDT))

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	Table Relationship Diagram
Short Description	Ship Details (without MANDT)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SHP_SHIP_DETAILS	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
2	CMS_STR_SHP_SHIP_DETAILS	CLASSIFI_COMPANY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
3	CMS_STR_SHP_SHIP_DETAILS	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
4	CMS_STR_SHP_SHIP_DETAILS	HULL_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
5	CMS_STR_SHP_SHIP_DETAILS	INSURER	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
6	CMS_STR_SHP_SHIP_DETAILS	INSUR_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
7	CMS_STR_SHP_SHIP_DETAILS	LIQD_CURR	TCURC	WAERS
8	CMS_STR_SHP_SHIP_DETAILS	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE

History

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