In this post, I will try and describe everything you need to know about the SAP crmd_shipping table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_SHIPPING what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_SHIPPING....Right lets get started!
Object Name: CRMD_SHIPPING
Dictionary Type: Transparent table
Description: Business Transaction - Shipping Set
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| INCOTERMS1 | CRMT_INCOTERMS1 | CHAR | 3(0) | CRMC_INCOTERM | Incoterms (Part 1) | CRM_INCOTERMS1 | CRM | |||||
| INCOTERMS2 | CRMT_INCOTERMS2 | CHAR | 28(0) | Incoterms (Part 2) | CRM_INCOTERMS2 | CRM | ||||||
| SHIP_COND | CRMT_SHIP_COND | CHAR | 2(0) | CRMC_SHIP_COND | Shipping Conditions | CRM_SHIP_COND | CRM | |||||
| DELI_UNLIM_TOL | CRMT_DELI_UNLIM_TOL | CHAR | 1(0) | Indicator: Unlimited Overdelivery Allowed | CRM_BOOLEAN | CRM | ||||||
| OVER_DLV_TOL | CRMT_OVER_DLV_TOL | DEC | 3(1) | Overdelivery Tolerance Limit | PRZ21 | CRM | ||||||
| UNDER_DLV_TOL | CRMT_UNDER_DLV_TOL | DEC | 3(1) | Underdelivery Tolerance Limit | PRZ21 | CRM | ||||||
| DLV_PRIO | CRMT_DLV_PRIO | NUMC | 2(0) | CRMC_DLV_PRIO | Delivery Priority | CRM_DLV_PRIO | CRM_DELIVERY_PRIORITY | DLV_PRIO | CRM | |||
| ORDERCOMBIND | CRMT_ORDERCOMBIND | CHAR | 1(0) | Indicator: Order Combination | CRM_BOOLEAN | CRM | ||||||
| PART_DLV | CRMT_PART_DLV | CHAR | 1(0) | Delivery Control | CRM_PART_DLV | CRM | ||||||
| DLV_GROUP | CRMT_DLV_GROUP | NUMC | 3(0) | Delivery Group (Items are Delivered Together) | CRMT_DLV_GROUP | CRM | ||||||
| DELIVERY_BLOCK | CRMT_BUS_DEL_BLOCK_REASON | CHAR | 2(0) | * | Business Partner (CRM): Delivery Block Reason | CRMT_BUS_DEL_BLOCK_REASON | CRM | |||||
| PART_DLV_ITM | CRMT_PART_DLV_ITM | CHAR | 1(0) | Delivery Control (Item) | CRM_PART_DLV_ITM | CRM | ||||||
| TRANS_MOT | CRMT_TRANS_MOT | CHAR | 2(0) | * | Mode of Transport | CRM_TRANS_MOT | CRM | |||||
| GEOROUTE | CRMT_GEOROUTE | CHAR | 10(0) | Route | CRM_GEOROUTE | CRM_GEOROUTE | GEOROUTE | CRM | ||||
| DIRECT_SHIP | CRMT_DIRECT_SHIP | CHAR | 1(0) | Direct Delivery Without Consolidation | FLAG | CRM | ||||||
| TRANS_MEANS | CRMT_TRANS_MEANS | CHAR | 10(0) | Means of Transport (from SCM System) | CRM_TRANS_MEANS | CRM_TRANS_MEANS | TTYPE | CRM | ||||
| INV_BEFORE_GI | CRMT_BEFORE_LOADING | CHAR | 1(0) | Invoice Before Goods Issue (IBGI) | CRM_BEFORE_LOADING | CRM |