SAP ABAP Table CMS_STR_SHP_SCR (Screen structure for Ship Details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS-MD-SHP (Application Component) Ship
     ⤷ CMS_SHP_UI (Package) Ship User Interface

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMS_STR_SHP_SCR	BANK_CNTRY_LIQ	T005	LAND1	REF	1	CN
2	CMS_STR_SHP_SCR	BREADTH_UOM	T006	MSEHI	REF	1	CN
3	CMS_STR_SHP_SCR	CLASSIFI_COMPANY	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
4	CMS_STR_SHP_SCR	CONS_COUNTRY	T005	LAND1	REF	1	CN
5	CMS_STR_SHP_SCR	CONS_CURR	TCURC	WAERS	REF	1	CN
6	CMS_STR_SHP_SCR	DEPTH_UOM	T006	MSEHI	REF	1	CN
7	CMS_STR_SHP_SCR	EXP_PRCD_CURR	TCURC	WAERS	REF	1	CN
8	CMS_STR_SHP_SCR	FUEL_CONSUM_UOM	T006	MSEHI	REF	1	CN
9	CMS_STR_SHP_SCR	HULL_TYP	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
10	CMS_STR_SHP_SCR	INSURER	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
11	CMS_STR_SHP_SCR	INSUR_PRE_CURR	TCURC	WAERS	REF	1	CN
12	CMS_STR_SHP_SCR	INSUR_TYPE	TCMS_ATT_ID_TY	INDICATOR_TYPE	REF	1	CN
13	CMS_STR_SHP_SCR	LENGTH_UOM	T006	MSEHI	REF	1	CN
14	CMS_STR_SHP_SCR	LIQD_CURR	TCURC	WAERS
15	CMS_STR_SHP_SCR	LIQD_REASON	TCMS_ATT_ID_TY	INDICATOR_TYPE
16	CMS_STR_SHP_SCR	POLICY_CURR	TCURC	WAERS	REF	1	CN
17	CMS_STR_SHP_SCR	POWER_UOM	T006	MSEHI	REF	1	CN
18	CMS_STR_SHP_SCR	PURCH_CURR	TCURC	WAERS	REF	1	CN
19	CMS_STR_SHP_SCR	REG_COUNTRY	T005	LAND1	REF	1	CN
20	CMS_STR_SHP_SCR	REQD_INSUR_CURR	TCURC	WAERS	REF	1	CN
21	CMS_STR_SHP_SCR	SPEED_UOM	T006	MSEHI	REF	1	CN
22	CMS_STR_SHP_SCR	TRACK_LENGTH_UOM	T006	MSEHI	REF	1	CN

History

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