SAP Table CMS_SHP
Description of a Ship - Master Table
Unsere Literaturempfehlung
SAP – Der technische Einstieg: SAP-Technologien und Konzepte
Sind Sie neu in der SAP-Welt und möchten schnell mitreden? Mit diesem Buch finden Sie sich erfolgreich im SAP-Umfeld zurecht! Sie steigen direkt in die Konzepte und Technologien der SAP-Software ein und lernen die unterschiedlichen Systeme und Prozesse kennen. Schritt für Schritt zeigen die Autoren Ihnen die wichtigsten technischen Aufgaben und die Zusammenhänge zwischen den Objekten. Dank der vielen Beispiele und Abbildungen finden Sie sich schnell im SAP-Umfeld zurecht und können direkt in SAP ERP oder SAP S/4HANA anfangen.
Bei amazon.de ansehen →
The table CMS_SHP (Description of a Ship - Master Table) is a standard table in SAP ERP. It belongs to the package CMS_SHP.
Technical Information
| Table | CMS_SHP |
| Short Text | Description of a Ship - Master Table |
| Package | CMS_SHP |
| Table Type | Transparent Table |
Fields for Table CMS_SHP
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SHP_GUID | ✔ | Globally Unique Identifier | OS_GUID | RAW | 16 | |
| AST_GUID | GUID for Table CMS_AST | CMS_DTE_AST_GUID | RAW | 16 | * | |
| SHP_TYPE | Ship Type | CMS_DTE_SHP_TYP | CHAR | 6 | TCMS_SHP_TYP | |
| NAME | Ship name | CMS_DTE_SHP_NAME | CHAR | 40 | ||
| CHARTER_NAME | Charter Name used to Lease the Ship | CMS_DTE_SHP_CH_NAME | CHAR | 40 | ||
| CALL_SIGN | IMO Number | CMS_DTE_SHP_CALL_SIGN | CHAR | 20 | ||
| SHP_CLASS | Specifies whether the Ship is Sea Ship or Inland Ship | CMS_DTE_SHP_CLASS | CHAR | 2 | ||
| REG_NUMBER | Registration Number | CMS_DTE_SHP_REG_NUM | CHAR | 20 | ||
| REG_DATE | Registration date | CMS_DTE_SHP_REG_DATE | DATS | 8 | ||
| REG_PLACE | Registration place | CMS_DTE_SHP_REG_PLACE | CHAR | 40 | ||
| REG_COUNTRY | Registration country | CMS_DTE_SHP_REG_COUNTRY | CHAR | 3 | T005 | |
| EXTN_REF_ID | External reference ID for the Ship | CMS_DTE_SHP_OBJ_REFID | CHAR | 40 | ||
| FLEET_NAME | Fleet Name | CMS_DTE_SHP_FLEET_NAME | CHAR | 40 | ||
| SHIP_ID | Ship ID | CMS_DTE_SHP_ID | CHAR | 40 | ||
| ISM_VALID_FROM | Date from which ISM Certificate Stands Valid | CMS_DTE_SHP_ISM_FROM | DATS | 8 | ||
| ISM_VALID_TO | Date until which ISM Certificate Stands Valid | CMS_DTE_SHP_ISM_TO | DATS | 8 | ||
| RATING_DATE | Rating date | CMS_DTE_SHP_RATE_DATE | DATS | 8 | ||
| RATING_CLS | Rating Class | CMS_DTE_SHP_RATING_CLS | CHAR | 20 | ||
| CLASSIFICATION | Classification of a Ship | CMS_DTE_SHP_CLASSIFICATION | CHAR | 40 | * | |
| CLASSIFI_COMPANY | Classification Company | CMS_DTE_SHP_ATT_ID_TY_SHP002 | CHAR | 6 | TCMS_ATT_ID_TY | |
| COMMENTS | Description | CMS_DTE_SHP_COMMENTS | CHAR | 40 | ||
| PURCH_PRICE | Purchase Price | CMS_DTE_SHP_PUR_PRI | CURR | 17 | ||
| PURCH_CURR | Currency for purchase price | CMS_DTE_SHP_PUR_CURR | CUKY | 5 | TCURC | |
| PURCH_PRICE_DATE | Purchase date | CMS_DTE_SHP_PUR_DATE | DATS | 8 | ||
| CONS_COUNTRY | Country where the Ship was Built | CMS_DTE_SHP_CONS_COUNTRY | CHAR | 3 | T005 | |
| CONS_PRICE | Cost incurred in Building the Ship | CMS_DTE_SHP_CONS_PRICE | CURR | 17 | ||
| CONS_CURR | Currency for construction price | CMS_DTE_SHP_CONS_CURR | CUKY | 5 | TCURC | |
| DELIVERY_DATE | Date of Delivery of the ship | CMS_DTE_SHP_DELIVERY_DATE | DATS | 8 | ||
| DOCK | Shipyard where the Ship was Built | CMS_DTE_SHP_DOCK | CHAR | 40 | ||
| LENGTH | Ship length | CMS_DTE_SHP_LENGTH | QUAN | 13 | ||
| LENGTH_UOM | Unit of measure for the ship length | CMS_DTE_SHP_LENGTH_UOM | UNIT | 3 | T006 | |
| BREADTH | Ship Beam | CMS_DTE_SHP_BREADTH | QUAN | 13 | ||
| BREADTH_UOM | Unit of measure for the breadth | CMS_DTE_SHP_BREADTH_UOM | UNIT | 3 | T006 | |
| DEPTH | Ship Draught | CMS_DTE_SHP_DEPTH | QUAN | 13 | ||
| DEPTH_UOM | Unit of measure for the depth | CMS_DTE_SHP_DEPTH_UOM | UNIT | 3 | T006 | |
| VOLUME | Volume of Ship | CMS_DTE_SHP_VOLUME | QUAN | 13 | ||
| VOLUME_UOM | Unit of Measure for the Ship Volume | CMS_DTE_SHP_VOLUME_UOM | UNIT | 3 | T006 | |
| DWT | Weight of the Ship excluding the weight of Cargo | CMS_DTE_SHP_DWT | QUAN | 13 | ||
| DWT_UOM | Unit of measure for the dead weight tonnage | CMS_DTE_SHP_DWT_UOM | UNIT | 3 | T006 | |
| GROSST | Volume of the Interiors of a Ship | CMS_DTE_SHP_GROSST | QUAN | 13 | ||
| GROSST_UOM | Unit of measure for the gross tonnage | CMS_DTE_SHP_GROSST_UOM | UNIT | 3 | T006 | |
| TRACK_LENGTH | Length of the Track in a Ship | CMS_DTE_SHP_TRK_LEN | QUAN | 13 | ||
| TRACK_LENGTH_UOM | Unit of Measure for the Track Length in a Ship | CMS_DTE_SHP_TRK_LEN_UOM | UNIT | 3 | T006 | |
| NUM_REF_CONT | Number of refrigerated containers | CMS_DTE_SHP_NO_REF_CONT | DEC | 10 | ||
| NUM_CONT_CAP | Container Capacity | CMS_DTE_SHP_CONT_CAP | DEC | 10 | ||
| NUM_CABIN_ROOM | Number of Cabin Rooms | CMS_DTE_SHP_CAB_ROOM | DEC | 10 | ||
| NUM_VEH_PARK | Number of Parking Units in the Vehicle Parking Bay | CMS_DTE_SHP_NO_PARK | DEC | 10 | ||
| NUM_OF_PAX | Passenger Capacity of the Ship | CMS_DTE_SHP_NO_PAX | DEC | 10 | ||
| ISOVR_CONTAINER | Indicator for Oversize Container Transportable in the Ship | CMS_DTE_SHP_OVERSIZE_CONTAINER | CHAR | 1 | ||
| HULL_TYP | Hull Type | CMS_DTE_SHP_ATT_ID_TY_SHP001 | CHAR | 6 | TCMS_ATT_ID_TY | |
| MANUFR_MACHINE | Manufacturer of the Machine | CMS_DTE_SHP_MANUFR_MACHINE | CHAR | 40 | ||
| MACHINE_TYP | Name of the Engine Model | CMS_DTE_SHP_MAC_TYP | CHAR | 40 | ||
| NUM_MACHINES | Number of Main Machines Fitted in the Ship | CMS_DTE_SHP_NO_MACHINES | DEC | 10 | ||
| CRANE_EQUIP | Crane Equipment fitted in the Ship | CMS_DTE_SHP_CRANE_EQUIP | CHAR | 40 | ||
| POWER | Engine power | CMS_DTE_SHP_POWER | QUAN | 13 | ||
| POWER_UOM | Unit of measure for the horse power | CMS_DTE_SHP_POWER_UOM | UNIT | 3 | T006 | |
| SPEED | Speed | CMS_DTE_SHP_SPEED | QUAN | 13 | ||
| SPEED_UOM | Unit of measure for the speed | CMS_DTE_SHP_SPEED_UOM | UNIT | 3 | * | |
| FUEL_CONSUM | Fuel Consumption | CMS_DTE_SHP_FUEL_CONSUM | QUAN | 13 | ||
| FUEL_CONSUM_UOM | Unit of measure for the fuel consumption | CMS_DTE_SHP_FUEL_CONSUM_UOM | UNIT | 3 | * | |
| INSUR_PREMIUM | Insurance Premium | CMS_DTE_SHP_INSUR_PREMIUM | CURR | 17 | ||
| INSUR_PRE_CURR | Currency for insurance premium | CMS_DTE_SHP_INSUR_PREMIUM_CURR | CUKY | 5 | TCURC | |
| INSUR_TYPE | Insurance Type | CMS_DTE_SHP_ATT_ID_TY_SHP003 | CHAR | 6 | TCMS_ATT_ID_TY | |
| ANNUAL_DEP | Annual depreciation in percentage | CMS_DTE_SHP_ANNUAL_DEP | DEC | 10 | ||
| INSUR_VALID_TILL | Date of Expiry of the Insurance Policy | CMS_DTE_SHP_INSUR_VALID_TILL | DATS | 8 | ||
| POLICY_AMOUNT | Insurance Policy Amount | CMS_DTE_SHP_POLICY_AMOUNT | CURR | 17 | ||
| POLICY_CURR | Insurance Policy Amount Currency | CMS_DTE_SHP_POLICY_CURR | CUKY | 5 | * | |
| REQD_INSUR_COVER | Required Amount of Insurance Cover | CMS_DTE_SHP_REQD_INSUR_COVER | CURR | 17 | ||
| REQD_INSUR_CURR | Required Insurance Cover Currency | CMS_DTE_SHP_REQD_INSUR_CURR | CUKY | 5 | * | |
| INSURER | Insurer | CMS_DTE_SHP_ATT_ID_TY_SHP004 | CHAR | 6 | TCMS_ATT_ID_TY | |
| CONTACT_FIRM | Contact Firm | CMS_DTE_SHP_CONTACT_FIRM | CHAR | 40 | ||
| CONTACT_PERSON | Contact Person | CMS_DTE_SHP_CONTACT_PERSON | CHAR | 40 | ||
| ADMIN_ORG_UNIT | Administration Organizational Unit | CMS_DTE_ADMINORG | CHAR | 12 | ||
| BANKAREA | Bank Area in Collateral Management | CMS_DTE_BANKAREA | CHAR | 4 | * | |
| CREATED_BY | Login ID of the User who created the Record | CMS_DTE_USER | CHAR | 12 | ||
| CREATED_AT | Creation Timestamp | CMS_DTE_CREATED_AT | DEC | 15 | ||
| CHANGED_BY | Last Changed By | CMS_DTE_LAST_CHNG_USER | CHAR | 12 | ||
| CHANGED_AT | Change Timestamp | CMS_DTE_CHANGED_AT | DEC | 15 | ||
| SOURCEOFENTRY | Source of Entry | CMS_DTE_SOURCE_OF_ENTRY | CHAR | 32 |