CRMD_SALES SAP (Business Transaction - Sales Set) Table details

Dictionary Type: Table
Description: Business Transaction - Sales Set




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




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

CRMD_SALES is a standard SAP Table which is used to store Business Transaction - Sales Set data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_SALES table consists of various fields, each holding specific information or linking keys about Business Transaction - Sales Set data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), PO_NUMBER_UC (Sold-to Party's External Reference No. (in Capital Letters)), REGION (Region (State, Province, County)).. 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 CRMD_SALES 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
PO_NUMBER_UCSold-to Party's External Reference No. (in Capital Letters) CRMT_PO_NUMBER_UCCHAR35CHAR35
REGIONRegion (State, Province, County) CRMT_REGIONCHAR3Assigned to domainREGIO
INDUSTRYIndustry Sector CRMT_INDUSTRYCHAR4Assigned to domainCRM_INDUSTRY
PCAT_HDR_GUIDProduct Catalog GUID (Header) COMT_PCAT_HDR_GUIDRAW16SYSUUID
PCAT_VRT_GUIDProduct Catalog Variant GUID COMT_PCAT_VRT_GUIDRAW16SYSUUID
PCAT_CTY_GUIDGUID of a Product Catalog Area COMT_PCAT_CTY_GUIDRAW16SYSUUID
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3CRMC_CUSTGRP1CRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3CRMC_CUSTGRP2CRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3CRMC_CUSTGRP3CRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3CRMC_CUSTGRP4CRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3CRMC_CUSTGRP5CRM_CUST_GROUP5
PO_NUMBER_SOLDSold-To Party's External Reference Number CRMT_PO_NUMBER_SOLDCHAR35TEXT35
PO_DATE_SOLDReference Document Date CRMT_PO_DATE_SOLDDATS8DATUM
YOUR_REF_SOLDSold-to Party Reference CRMT_YOUR_REFERENCE_SOLDCHAR12TEXT12
PO_NUMBER_SHIPShip-To Party's External Reference Number CRMT_PO_NUMBER_SHIPCHAR35TEXT35
PO_DATE_SHIPShip-To Party's Reference Document Date CRMT_PO_DATE_SHIPDATS8DATUM
YOUR_REF_SHIPShip-To Party Reference CRMT_YOUR_REFERENCE_SHIPCHAR12TEXT12
USAGE_TYPEUsage Indicator CRMT_USAGECHAR3CRMC_USAGECRM_USAGE
SUBMISSIONCollective Number for Quotations CRMT_SUBMISSIONCHAR10TEXT10
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2CRMC_REJECTIONCRM_REJECTION_CODE
PROBABILITYOrder Probability CRMT_ORDER_PROBABILITYNUMC3CRM_PROBABILITY
DATE_QTY_FIXEDFixed Date and Quantity CRMT_DATE_QTY_FIXEDCHAR1CRM_BOOLEAN
REQ_DLV_DATERequested Delivery Date Header CRMT_REQ_DLV_DATEDEC15TSTPSBCOS_TSTMP
REQ_TIMEZONETime Zone Requested Delivery Date Header CRMT_REQ_DATE_TIMEZONECHAR6Assigned to domainTZNZONE
RULE_REQ_DATERule Reqested Delivery Date Header CRMT_RULE_REQ_DATERAW16Assigned to domainTIMERULEID
ROUNDINGRound Requirement Quantity CRMT_ROUNDINGCHAR1CRM_ROUNDING
PAR_ATP_SSTOCKParameter-Dependent ATP Safety Stock CRMT_PAR_ATP_SSTOCKCHAR1CRM_PAR_ATP_SSTOCK
CONF_RULEConfirmation Rule CRMT_CONF_RULECHAR1CRM_CONF_RULE
SUBST_EXCLRule Criterion 1 CRMT_ATP_SUBST_EXCLCHAR2CRMC_SUBST_EXCLCRM_ATP_SUBST_EXCL
SEARCH_PATTERNRule Criterion 2 CRMT_SEARCH_PATTERNCHAR10CRMC_ATP_SEARCHCRM_SEARCH_PATTERN
REASSIGN_ABILITYReassignment of Order Confirmations CRMT_REASSIGN_ABILITYCHAR1CRM_REASSIGN_ABILITY
ABNORMAL_DEMANDAbnormal Demand CRMT_ABNORMAL_DEMANDCHAR1CRM_ABNORMAL_DEMAND

Key field Non-key field



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

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

SELECT SINGLE *
FROM CRMD_SALES
INTO CORRESPONDING FIELDS OF WA_CRMD_SALES
WHERE...

How to access SAP table CRMD_SALES

Within an ECC or HANA version of SAP you can also view further information about CRMD_SALES 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!