CMS_SHP SAP (Description of a Ship - Master Table) Table details

Dictionary Type: Table
Description: Description of a Ship - Master Table




ABAP Code to SELECT data from CMS_SHP
Related tables to CMS_SHP
Access table CMS_SHP




Table field list including key, data, relationships and ABAP select examples

CMS_SHP is a standard SAP Table which is used to store Description of a Ship - Master Table data and is available within R/3 SAP systems depending on the version and release level.

The CMS_SHP table consists of various fields, each holding specific information or linking keys about Description of a Ship - Master Table data available in SAP. These include SHP_GUID (Globally Unique Identifier), AST_GUID (GUID for Table CMS_AST), SHP_TYPE (Ship Type), NAME (Ship name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CMS_SHP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SHP_GUIDGlobally Unique Identifier OS_GUIDRAW16SYSUUID
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16Assigned to domainSYSUUID
SHP_TYPEShip Type CMS_DTE_SHP_TYPCHAR6TCMS_SHP_TYPCMS_SHP_TYPCMS_SHP_TYP
NAMEShip name CMS_DTE_SHP_NAMECHAR40CMS_SHP_NAMECMS_SHP_NAME
CHARTER_NAMECharter Name used to Lease the Ship CMS_DTE_SHP_CH_NAMECHAR40CMS_SHP_NAMECMS_SHP_CH_NAME
CALL_SIGNIMO Number CMS_DTE_SHP_CALL_SIGNCHAR20CMS_SHP_NUMBER
SHP_CLASSSpecifies whether the Ship is Sea Ship or Inland Ship CMS_DTE_SHP_CLASSCHAR2CMS_SHP_CLASS
REG_NUMBERRegistration Number CMS_DTE_SHP_REG_NUMCHAR20CMS_SHP_NUMBER
REG_DATERegistration date CMS_DTE_SHP_REG_DATEDATS8CMS_SHP_DATE
REG_PLACERegistration place CMS_DTE_SHP_REG_PLACECHAR40CMS_SHP_NAME
REG_COUNTRYRegistration country CMS_DTE_SHP_REG_COUNTRYCHAR3T005LAND1
EXTN_REF_IDExternal reference ID for the Ship CMS_DTE_SHP_OBJ_REFIDCHAR40CMS_SHP_NAME
FLEET_NAMEFleet Name CMS_DTE_SHP_FLEET_NAMECHAR40CMS_SHP_NAME
SHIP_IDShip ID CMS_DTE_SHP_IDCHAR40ALPHACMS_SHP_IDCMS_SHP_ID
ISM_VALID_FROMDate from which ISM Certificate Stands Valid CMS_DTE_SHP_ISM_FROMDATS8CMS_SHP_DATE
ISM_VALID_TODate until which ISM Certificate Stands Valid CMS_DTE_SHP_ISM_TODATS8CMS_SHP_DATE
RATING_DATERating date CMS_DTE_SHP_RATE_DATEDATS8CMS_SHP_DATE
RATING_CLSRating Class CMS_DTE_SHP_RATING_CLSCHAR20CMS_SHP_RATING_CLS
CLASSIFICATIONClassification of a Ship CMS_DTE_SHP_CLASSIFICATIONCHAR40Assigned to domainCMS_SHP_NAME
CLASSIFI_COMPANYClassification Company CMS_DTE_SHP_ATT_ID_TY_SHP002CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
COMMENTSDescription CMS_DTE_SHP_COMMENTSCHAR40CMS_SHP_NAME
PURCH_PRICEPurchase Price CMS_DTE_SHP_PUR_PRICURR17(2) CMS_SHP_AMOUNT
PURCH_CURRCurrency for purchase price CMS_DTE_SHP_PUR_CURRCUKY5TCURCWAERS
PURCH_PRICE_DATEPurchase date CMS_DTE_SHP_PUR_DATEDATS8CMS_SHP_DATE
CONS_COUNTRYCountry where the Ship was Built CMS_DTE_SHP_CONS_COUNTRYCHAR3T005LAND1
CONS_PRICECost incurred in Building the Ship CMS_DTE_SHP_CONS_PRICECURR17(2) CMS_SHP_AMOUNT
CONS_CURRCurrency for construction price CMS_DTE_SHP_CONS_CURRCUKY5TCURCWAERS
DELIVERY_DATEDate of Delivery of the ship CMS_DTE_SHP_DELIVERY_DATEDATS8CMS_SHP_DATE
DOCKShipyard where the Ship was Built CMS_DTE_SHP_DOCKCHAR40CMS_SHP_NAME
LENGTHShip length CMS_DTE_SHP_LENGTHQUAN13(3) CMS_SHP_SIZE
LENGTH_UOMUnit of measure for the ship length CMS_DTE_SHP_LENGTH_UOMUNIT3T006CUNITMEINS
BREADTHShip Beam CMS_DTE_SHP_BREADTHQUAN13(3) CMS_SHP_SIZE
BREADTH_UOMUnit of measure for the breadth CMS_DTE_SHP_BREADTH_UOMUNIT3T006CUNITMEINS
DEPTHShip Draught CMS_DTE_SHP_DEPTHQUAN13(3) CMS_SHP_SIZE
DEPTH_UOMUnit of measure for the depth CMS_DTE_SHP_DEPTH_UOMUNIT3T006CUNITMEINS
VOLUMEVolume of Ship CMS_DTE_SHP_VOLUMEQUAN13(3) CMS_SHP_SIZE
VOLUME_UOMUnit of Measure for the Ship Volume CMS_DTE_SHP_VOLUME_UOMUNIT3T006CUNITMEINSCMS_ELM_VOLUME_UOM
DWTWeight of the Ship excluding the weight of Cargo CMS_DTE_SHP_DWTQUAN13(3) CMS_SHP_SIZE
DWT_UOMUnit of measure for the dead weight tonnage CMS_DTE_SHP_DWT_UOMUNIT3T006CUNITMEINS
GROSSTVolume of the Interiors of a Ship CMS_DTE_SHP_GROSSTQUAN13(3) CMS_SHP_SIZE
GROSST_UOMUnit of measure for the gross tonnage CMS_DTE_SHP_GROSST_UOMUNIT3T006CUNITMEINS
TRACK_LENGTHLength of the Track in a Ship CMS_DTE_SHP_TRK_LENQUAN13(3) CMS_SHP_SIZE
TRACK_LENGTH_UOMUnit of Measure for the Track Length in a Ship CMS_DTE_SHP_TRK_LEN_UOMUNIT3T006CUNITMEINS
NUM_REF_CONTNumber of refrigerated containers CMS_DTE_SHP_NO_REF_CONTDEC10CMS_SHP_INT
NUM_CONT_CAPContainer Capacity CMS_DTE_SHP_CONT_CAPDEC10CMS_SHP_INT
NUM_CABIN_ROOMNumber of Cabin Rooms CMS_DTE_SHP_CAB_ROOMDEC10CMS_SHP_INT
NUM_VEH_PARKNumber of Parking Units in the Vehicle Parking Bay CMS_DTE_SHP_NO_PARKDEC10CMS_SHP_INT
NUM_OF_PAXPassenger Capacity of the Ship CMS_DTE_SHP_NO_PAXDEC10CMS_SHP_INT
ISOVR_CONTAINERIndicator for Oversize Container Transportable in the Ship CMS_DTE_SHP_OVERSIZE_CONTAINERCHAR1CMS_SHP_FLG
HULL_TYPHull Type CMS_DTE_SHP_ATT_ID_TY_SHP001CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MANUFR_MACHINEManufacturer of the Machine CMS_DTE_SHP_MANUFR_MACHINECHAR40CMS_SHP_NAME
MACHINE_TYPName of the Engine Model CMS_DTE_SHP_MAC_TYPCHAR40CMS_SHP_NAME
NUM_MACHINESNumber of Main Machines Fitted in the Ship CMS_DTE_SHP_NO_MACHINESDEC10CMS_SHP_INT
CRANE_EQUIPCrane Equipment fitted in the Ship CMS_DTE_SHP_CRANE_EQUIPCHAR40CMS_SHP_NAME
POWEREngine power CMS_DTE_SHP_POWERQUAN13(3) CMS_SHP_SIZE
POWER_UOMUnit of measure for the horse power CMS_DTE_SHP_POWER_UOMUNIT3T006CUNITMEINS
SPEEDSpeed CMS_DTE_SHP_SPEEDQUAN13(3) CMS_SHP_SIZE
SPEED_UOMUnit of measure for the speed CMS_DTE_SHP_SPEED_UOMUNIT3Assigned to domainCUNITMEINS
FUEL_CONSUMFuel Consumption CMS_DTE_SHP_FUEL_CONSUMQUAN13(3) CMS_SHP_SIZE
FUEL_CONSUM_UOMUnit of measure for the fuel consumption CMS_DTE_SHP_FUEL_CONSUM_UOMUNIT3Assigned to domainCUNITMEINS
INSUR_PREMIUMInsurance Premium CMS_DTE_SHP_INSUR_PREMIUMCURR17(2) CMS_SHP_AMOUNT
INSUR_PRE_CURRCurrency for insurance premium CMS_DTE_SHP_INSUR_PREMIUM_CURRCUKY5TCURCWAERS
INSUR_TYPEInsurance Type CMS_DTE_SHP_ATT_ID_TY_SHP003CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
ANNUAL_DEPAnnual depreciation in percentage CMS_DTE_SHP_ANNUAL_DEPDEC10(6) CMS_SHP_PCT
INSUR_VALID_TILLDate of Expiry of the Insurance Policy CMS_DTE_SHP_INSUR_VALID_TILLDATS8CMS_SHP_DATE
POLICY_AMOUNTInsurance Policy Amount CMS_DTE_SHP_POLICY_AMOUNTCURR17(2) CMS_SHP_AMOUNT
POLICY_CURRInsurance Policy Amount Currency CMS_DTE_SHP_POLICY_CURRCUKY5Assigned to domainWAERS
REQD_INSUR_COVERRequired Amount of Insurance Cover CMS_DTE_SHP_REQD_INSUR_COVERCURR17(2) CMS_SHP_AMOUNT
REQD_INSUR_CURRRequired Insurance Cover Currency CMS_DTE_SHP_REQD_INSUR_CURRCUKY5Assigned to domainWAERS
INSURERInsurer CMS_DTE_SHP_ATT_ID_TY_SHP004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
CONTACT_FIRMContact Firm CMS_DTE_SHP_CONTACT_FIRMCHAR40CMS_SHP_NAME
CONTACT_PERSONContact Person CMS_DTE_SHP_CONTACT_PERSONCHAR40CMS_SHP_NAME
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



How do I retrieve data from SAP table CMS_SHP using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_SHP to SELECT all data from the table
DATA: WA_CMS_SHP TYPE CMS_SHP.

SELECT SINGLE *
FROM CMS_SHP
INTO CORRESPONDING FIELDS OF WA_CMS_SHP
WHERE...

How to access SAP table CMS_SHP

Within an ECC or HANA version of SAP you can also view further information about CMS_SHP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!