In this post, I will try and describe everything you need to know about the SAP crmd_sales 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_SALES 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_SALES....Right lets get started!
Object Name: CRMD_SALES
Dictionary Type: Transparent table
Description: Business Transaction - Sales 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 | ||||||
| PO_NUMBER_UC | CRMT_PO_NUMBER_UC | CHAR | 35(0) | Sold-to Party's External Reference No. (in Capital Letters) | CHAR35 | CRM | ||||||
| REGION | CRMT_REGION | CHAR | 3(0) | * | Region (State, Province, County) | REGIO | CRM | |||||
| INDUSTRY | CRMT_INDUSTRY | CHAR | 4(0) | * | Industry Sector | CRM_INDUSTRY | CRM | |||||
| PCAT_HDR_GUID | COMT_PCAT_HDR_GUID | RAW | 16(0) | Product Catalog GUID (Header) | SYSUUID | CRM | ||||||
| PCAT_VRT_GUID | COMT_PCAT_VRT_GUID | RAW | 16(0) | Product Catalog Variant GUID | SYSUUID | CRM | ||||||
| PCAT_CTY_GUID | COMT_PCAT_CTY_GUID | RAW | 16(0) | GUID of a Product Catalog Area | SYSUUID | CRM | ||||||
| CUST_GROUP1 | CRMT_CUST_GROUP1 | CHAR | 3(0) | CRMC_CUSTGRP1 | Customer Group 1 | CRM_CUST_GROUP1 | CRM | |||||
| CUST_GROUP2 | CRMT_CUST_GROUP2 | CHAR | 3(0) | CRMC_CUSTGRP2 | Customer Group 2 | CRM_CUST_GROUP2 | CRM | |||||
| CUST_GROUP3 | CRMT_CUST_GROUP3 | CHAR | 3(0) | CRMC_CUSTGRP3 | Dishonour Reason | CRM_CUST_GROUP3 | CRM | |||||
| CUST_GROUP4 | CRMT_CUST_GROUP4 | CHAR | 3(0) | CRMC_CUSTGRP4 | Customer Group 4 | CRM_CUST_GROUP4 | CRM | |||||
| CUST_GROUP5 | CRMT_CUST_GROUP5 | CHAR | 3(0) | CRMC_CUSTGRP5 | Customer Group 5 | CRM_CUST_GROUP5 | CRM | |||||
| PO_NUMBER_SOLD | CRMT_PO_NUMBER_SOLD | CHAR | 35(0) | Sold-To Party's External Reference Number | TEXT35 | CRM | ||||||
| PO_DATE_SOLD | CRMT_PO_DATE_SOLD | DATS | 8(0) | Reference Document Date | DATUM | CRM | ||||||
| YOUR_REF_SOLD | CRMT_YOUR_REFERENCE_SOLD | CHAR | 12(0) | Sold-to Party Reference | TEXT12 | CRM | ||||||
| PO_NUMBER_SHIP | CRMT_PO_NUMBER_SHIP | CHAR | 35(0) | Ship-To Party's External Reference Number | TEXT35 | CRM | ||||||
| PO_DATE_SHIP | CRMT_PO_DATE_SHIP | DATS | 8(0) | Ship-To Party's Reference Document Date | DATUM | CRM | ||||||
| YOUR_REF_SHIP | CRMT_YOUR_REFERENCE_SHIP | CHAR | 12(0) | Ship-To Party Reference | TEXT12 | CRM | ||||||
| USAGE_TYPE | CRMT_USAGE | CHAR | 3(0) | CRMC_USAGE | Usage Indicator | CRM_USAGE | CRM | |||||
| SUBMISSION | CRMT_SUBMISSION | CHAR | 10(0) | Collective Number for Quotations | TEXT10 | CRM | ||||||
| REJECTION | CRMT_REJECTION_CODE | CHAR | 2(0) | CRMC_REJECTION | Cancellation Reason Code | CRM_REJECTION_CODE | CRM | |||||
| PROBABILITY | CRMT_ORDER_PROBABILITY | NUMC | 3(0) | Order Probability | CRM_PROBABILITY | CRM | ||||||
| DATE_QTY_FIXED | CRMT_DATE_QTY_FIXED | CHAR | 1(0) | Fixed Date and Quantity | CRM_BOOLEAN | CRM | ||||||
| REQ_DLV_DATE | CRMT_REQ_DLV_DATE | DEC | 15(0) | Requested Delivery Date Header | BCOS_TSTMP | CRM | ||||||
| REQ_TIMEZONE | CRMT_REQ_DATE_TIMEZONE | CHAR | 6(0) | * | Time Zone Requested Delivery Date Header | TZNZONE | CRM | |||||
| RULE_REQ_DATE | CRMT_RULE_REQ_DATE | RAW | 16(0) | * | Rule Reqested Delivery Date Header | TIMERULEID | CRM | |||||
| ROUNDING | CRMT_ROUNDING | CHAR | 1(0) | Round Requirement Quantity | CRM_ROUNDING | CRM | ||||||
| PAR_ATP_SSTOCK | CRMT_PAR_ATP_SSTOCK | CHAR | 1(0) | Parameter-Dependent ATP Safety Stock | CRM_PAR_ATP_SSTOCK | CRM | ||||||
| CONF_RULE | CRMT_CONF_RULE | CHAR | 1(0) | Confirmation Rule | CRM_CONF_RULE | CRM | ||||||
| SUBST_EXCL | CRMT_ATP_SUBST_EXCL | CHAR | 2(0) | CRMC_SUBST_EXCL | Rule Criterion 1 | CRM_ATP_SUBST_EXCL | CRM | |||||
| SEARCH_PATTERN | CRMT_SEARCH_PATTERN | CHAR | 10(0) | CRMC_ATP_SEARCH | Rule Criterion 2 | CRM_SEARCH_PATTERN | CRM | |||||
| REASSIGN_ABILITY | CRMT_REASSIGN_ABILITY | CHAR | 1(0) | Reassignment of Order Confirmations | CRM_REASSIGN_ABILITY | CRM | ||||||
| ABNORMAL_DEMAND | CRMT_ABNORMAL_DEMAND | CHAR | 1(0) | Abnormal Demand | CRM_ABNORMAL_DEMAND | CRM |