SAP ABAP Table CMS_STR_COR_CAG_SHP_DET (Ship details)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CMS (Application Component) Collateral Management System
     ⤷ CMS_COR (Package) Correspondence serivce for CMS

Basic Data

Table Category	INTTAB	Structure
Structure	CMS_STR_COR_CAG_SHP_DET	Table Relationship Diagram
Short Description	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	WA_CMS_SHPHDR	☐	CMS_STR_SHP_MAP_GET_MLT		STRU	0	0
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
73	INSUR_TYPE	☐	CMS_DTE_SHP_ATT_ID_TY_SHP003	CMS_ATT_ID_TYP	CHAR	6	0	Insurance Type
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
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	MAPI : GET : Asset details
84	CATEGORY	☐	CMS_DTE_OMS_OBJ_CAT	CMS_OBJ_CAT	CHAR	6	0	Object Category
85	CATEGORY_NAME	☐	CMS_DTE_OMS_CAT_NAME	CMS_OMS_CAT_NAME	CHAR	40	0	Object Category Name
86	TYPE	☐	CMS_DTE_MOV_TYP	CMS_MOV_TYP	CHAR	6	0	Movable types
87	TYPE_NAME	☐	CMS_DTE_MOV_TYP_NAME	CMS_MOV_NAME	CHAR	40	0	Name in a specified language
88	IDENTIFICATION	☐	CMS_DTE_MOV_ID	CMS_MOV_ID	CHAR	40	0	Identification Number
89	MOV_DESCRIPTION	☐	CMS_DTE_MOV_DESC	CMS_MOV_DESC	CHAR	30	0	Description of the object
90	.INCLUDE	☐				0	0	Structure with Asset Details for Table CMS_AST
91	.INCLUDE	☐				0	0	Basic Asset data
92	DESCRIPTION	☐	CMS_DTE_AST_DESC	CMS_DSC	CHAR	30	0	Description
93	OBJECT_REF_ID	☐	CMS_DTE_OBJ_REFID	CMS_OBJ_REFID	CHAR	40	0	Reference ID for the object
94	OBJECT_TYP	☐	CMS_DTE_OBJ_TYP	CMS_OBJ_TYP	CHAR	32	0	Not used
95	COUNTRY_KEY	☐	CMS_DTE_AST_COUNTRY_KEY	LAND1	CHAR	3	0	Identification Key for Country
96	RISK_CODE	☐	CMS_DTE_RISK_CODE	CMS_RISK_CODE	CHAR	6	0	Risk Code
97	SFTY_IND	☐	CMS_DTE_IND_SFTY_DISC	CMS_IND_SFTY	CHAR	2	0	Indicates if the Asset has a Default Safety Discount
98	SFTY_DSCNT	☐	CMS_DTE_SAFETY_DSCNT	CMS_SFTY_PCT	DEC	10	6	Percentage of Safety Discount
99	SFTY_AMOUNT	☐	CMS_DTE_SAFETY_AMT	CMS_AMOUNT	CURR	17	2	Amount of Safety Discount
100	SFTY_AMT_CURR	☐	CMS_DTE_SAFETY_AMT_CURR	WAERS	CUKY	5	0	Currency of the Safety Discount Amount
101	OBJSYSID	☐	CMS_DTE_OBJ_SYSID	CMS_SYS	CHAR	6	0	Object System Reference ID
102	.INCLUDE	☐				0	0	Valuation data
103	VALUATION_TYP	☐	CMS_DTE_IND_VALN_TYP	CMS_VALN_TYP	CHAR	2	0	Type of Valuation Check performed on Collateral Object
104	UNIT_VALN_FREQ	☐	CMS_DTE_IND_AST_VALN_FREQ_UNIT	CMS_IND_AST_VALN_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for revaluation of an asset
105	PERIOD_VALN_FREQ	☐	CMS_DTE_AST_VALN_FREQ_PERIOD	CMS_AST_VALN_FREQ_PERIOD	NUMC	4	0	Revaluation Period for an Asset
106	PAST_VALUED_DATE	☐	CMS_DTE_VALN_DATE	CMS_DATE	DATS	8	0	Last Date on which the Asset was Valued
107	START_DATE	☐	CMS_DTE_START_DATE	CMS_DATE	DATS	8	0	Date on which the First Valuation is Performed on the Asset
108	END_DATE	☐	CMS_DTE_END_DATE	CMS_DATE	DATS	8	0	Date on which the Last Valuation is Performed on the Asset
109	.INCLUDE	☐				0	0	Lending rate data
110	LENDING_RATE_IND	☐	CMS_DTE_IND_LND_RTE	CMS_IND_LRTE	CHAR	2	0	Indicator to specify if Asset has a Default Lending Rate
111	.INCLUDE	☐				0	0	Lending rates structure
112	LENDING_RATE1	☐	CMS_DTE_LRTE_PCT1	CMS_PCT	DEC	10	6	Lending Rate 1
113	LENDING_RATE2	☐	CMS_DTE_LRTE_PCT2	CMS_PCT	DEC	10	6	Lending Rate 2
114	LENDING_RATE3	☐	CMS_DTE_LRTE_PCT3	CMS_PCT	DEC	10	6	Lending Rate 3
115	LENDING_RATE4	☐	CMS_DTE_LRTE_PCT4	CMS_PCT	DEC	10	6	Lending Rate 4
116	LENDING_RATE5	☐	CMS_DTE_LRTE_PCT5	CMS_PCT	DEC	10	6	Lending Rate 5
117	.INCLUDE	☐				0	0	Liquidation rights data
118	LIQD_TYP	☐	CMS_DTE_LIQD_TYP	CMS_TYP	CHAR	6	0	Liquidation Type
119	LIQD_REASON	☐	CMS_DTE_ATT_ID_TY_AST004	CMS_ATT_ID_TYP	CHAR	6	0	Liquidation Reason
120	LIQD_DATE	☐	CMS_DTE_LIQD_DATE	CMS_DATE	DATS	8	0	Date on which the Collateral was Liquidated
121	LIQD_AMT	☐	CMS_DTE_LIQD_VALUE	CMS_AMOUNT	CURR	17	2	Returns from the Liquidation of Collateral
122	LIQD_CURR	☐	CMS_DTE_LIQD_CURR	WAERS	CUKY	5	0	Currency of Liquidation Value
123	EXP_PRCD_AMNT	☐	CMS_DTE_LIQ_EXP_PRCD_AMOUNT	CMS_AMOUNT	CURR	17	2	Expected Proceed Amount
124	EXP_PRCD_CURR	☐	CMS_DTE_LIQ_EXP_PRCD_CURR	WAERS	CUKY	5	0	Currency: Expected Proceed
125	EXP_ACC_DATE	☐	CMS_DTE_LIQ_EXP_ACCRUAL_DATE	CMS_DATE	DATS	8	0	Expected accrual date
126	.INCLUDE	☐				0	0	Account for liquidation proceeds
127	ACC_NUMBER_LIQ	☐	CMS_DTE_LIQ_ACC_NUMBER	BANKN35	CHAR	35	0	Account number for liquidation proceeds
128	BANK_CNTRY_LIQ	☐	CMS_DTE_LIQ_BNK_CTRY_KY	LAND1	CHAR	3	0	Bank country key
129	BANK_KEY_LIQ	☐	CMS_DTE_LIQ_BNK_KEY	BANKK	CHAR	15	0	Bank Key
130	BANK_CTRLKEY_LIQ	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
131	.INCLUDE	☐				0	0	Verfication Data
132	UNIT_VERF_FREQ	☐	CMS_DTE_IND_AST_VERF_FREQ_UNIT	CMS_IND_AST_VERF_FREQ_UNIT	CHAR	2	0	Indicator: Units of time for verification of an asset
133	PERIOD_VERF_FREQ	☐	CMS_DTE_AST_VERF_FREQ_PERIOD	CMS_AST_VERF_FREQ_PERIOD	NUMC	4	0	Statement Period for an Asset
134	LAST_VERF_DATE	☐	CMS_DTE_AST_VERF_DATE	CMS_DATE	DATS	8	0	Last Verification Date
135	.INCLUDE	☐				0	0	Structure for Asset values
136	NOM_VALUE	☐	CMS_DTE_AST_NOMINAL_VALUE	CMS_AMOUNT	CURR	17	2	Nominal Value of the Asset
137	NOM_VALUE_CURR	☐	CMS_DTE_AST_NOMINAL_VALUE_CURR	WAERS	CUKY	5	0	Currency of Nominal value
138	AST_VALUE	☐	CMS_DTE_AST_VALUE	CMS_AMOUNT	CURR	17	2	Final Asset Value
139	AST_VALUE_CURR	☐	CMS_DTE_AST_VALUE_CURR	WAERS	CUKY	5	0	Currency of the Final Asset Value
140	QUANTITY	☐	CMS_DTE_QTY	CMS_QTY	QUAN	13	3	Quantity
141	UNIT_OF_MEASURE	☐	CMS_DTE_UNIT	MEINS	UNIT	3	0	Unit of Measure of Quantity
142	REC_AT	☐	CMS_DTE_REC_AT	TZNTSTMPS	DEC	15	0	Asset Value Recording Timestamp
143	.INCLUDE	☐				0	0	Purchase price data
144	PUR_PRICE	☐	CMS_DTE_AST_PURCHASE_PRICE	CMS_AMOUNT	CURR	17	2	Purchase Price of the Asset
145	PUR_PRICE_CURR	☐	CMS_DTE_AST_PUR_PRICE_CURR	WAERS	CUKY	5	0	Currency of Purchase Price
146	PUR_DATE	☐	CMS_DTE_AST_PUR_PRICE_DATE	CMS_DATE	DATS	8	0	Date of Purchase
147	.INCLUDE	☐				0	0	Administrative organization unit
148	ADMIN_ORG_UNIT	☐	CMS_DTE_ADMINORG	TEXT12	CHAR	12	0	Administration Organizational Unit
149	.INCLUDE	☐				0	0	Bank area
150	BANKAREA	☐	CMS_DTE_BANKAREA	CMS_BANKAREA	CHAR	4	0	Bank Area in Collateral Management
151	.INCLUDE	☐				0	0	Organization unit structure
152	ORG_UNIT1	☐	CMS_DTE_ORG_UNIT1	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 1
153	ORG_UNIT2	☐	CMS_DTE_ORG_UNIT2	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 2
154	ORG_UNIT3	☐	CMS_DTE_ORG_UNIT3	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 3
155	ORG_UNIT4	☐	CMS_DTE_ORG_UNIT4	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 4
156	ORG_UNIT5	☐	CMS_DTE_ORG_UNIT5	CMS_ORG_UNIT	CHAR	10	0	Organizational Unit 5
157	.INCLUDE	☐				0	0	Stucture to record history of changes in all application tab
158	CREATED_BY	☐	CMS_DTE_USER	CMS_USER	CHAR	12	0	Login ID of the User who created the Record
159	CREATED_AT	☐	CMS_DTE_CREATED_AT	TZNTSTMPS	DEC	15	0	Creation Timestamp
160	CHANGED_BY	☐	CMS_DTE_LAST_CHNG_USER	CMS_USER	CHAR	12	0	Last Changed By
161	CHANGED_AT	☐	CMS_DTE_CHANGED_AT	TZNTSTMPS	DEC	15	0	Change Timestamp
162	SOURCEOFENTRY	☐	CMS_DTE_SOURCE_OF_ENTRY	CMS_SOURCE	CHAR	32	0	Source of Entry

History

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