SAP Table CRMD_SALES stores Business Transaction - Sales Setdata

  

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!


SAP CRMD_SALES dictionary attributes

Object Name: CRMD_SALES
Dictionary Type: Transparent table
Description: Business Transaction - Sales Set


CRMD_SALES field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
PO_NUMBER_UCCRMT_PO_NUMBER_UCCHAR35(0) Sold-to Party's External Reference No. (in Capital Letters)CHAR35CRM
REGIONCRMT_REGIONCHAR3(0) *Region (State, Province, County)REGIOCRM
INDUSTRYCRMT_INDUSTRYCHAR4(0) *Industry SectorCRM_INDUSTRYCRM
PCAT_HDR_GUIDCOMT_PCAT_HDR_GUIDRAW16(0) Product Catalog GUID (Header)SYSUUIDCRM
PCAT_VRT_GUIDCOMT_PCAT_VRT_GUIDRAW16(0) Product Catalog Variant GUIDSYSUUIDCRM
PCAT_CTY_GUIDCOMT_PCAT_CTY_GUIDRAW16(0) GUID of a Product Catalog AreaSYSUUIDCRM
CUST_GROUP1CRMT_CUST_GROUP1CHAR3(0) CRMC_CUSTGRP1Customer Group 1CRM_CUST_GROUP1CRM
CUST_GROUP2CRMT_CUST_GROUP2CHAR3(0) CRMC_CUSTGRP2Customer Group 2CRM_CUST_GROUP2CRM
CUST_GROUP3CRMT_CUST_GROUP3CHAR3(0) CRMC_CUSTGRP3Dishonour ReasonCRM_CUST_GROUP3CRM
CUST_GROUP4CRMT_CUST_GROUP4CHAR3(0) CRMC_CUSTGRP4Customer Group 4CRM_CUST_GROUP4CRM
CUST_GROUP5CRMT_CUST_GROUP5CHAR3(0) CRMC_CUSTGRP5Customer Group 5CRM_CUST_GROUP5CRM
PO_NUMBER_SOLDCRMT_PO_NUMBER_SOLDCHAR35(0) Sold-To Party's External Reference NumberTEXT35CRM
PO_DATE_SOLDCRMT_PO_DATE_SOLDDATS8(0) Reference Document DateDATUMCRM
YOUR_REF_SOLDCRMT_YOUR_REFERENCE_SOLDCHAR12(0) Sold-to Party ReferenceTEXT12CRM
PO_NUMBER_SHIPCRMT_PO_NUMBER_SHIPCHAR35(0) Ship-To Party's External Reference NumberTEXT35CRM
PO_DATE_SHIPCRMT_PO_DATE_SHIPDATS8(0) Ship-To Party's Reference Document DateDATUMCRM
YOUR_REF_SHIPCRMT_YOUR_REFERENCE_SHIPCHAR12(0) Ship-To Party ReferenceTEXT12CRM
USAGE_TYPECRMT_USAGECHAR3(0) CRMC_USAGEUsage IndicatorCRM_USAGECRM
SUBMISSIONCRMT_SUBMISSIONCHAR10(0) Collective Number for QuotationsTEXT10CRM
REJECTIONCRMT_REJECTION_CODECHAR2(0) CRMC_REJECTIONCancellation Reason CodeCRM_REJECTION_CODECRM
PROBABILITYCRMT_ORDER_PROBABILITYNUMC3(0) Order ProbabilityCRM_PROBABILITYCRM
DATE_QTY_FIXEDCRMT_DATE_QTY_FIXEDCHAR1(0) Fixed Date and QuantityCRM_BOOLEANCRM
REQ_DLV_DATECRMT_REQ_DLV_DATEDEC15(0) Requested Delivery Date HeaderBCOS_TSTMPCRM
REQ_TIMEZONECRMT_REQ_DATE_TIMEZONECHAR6(0) *Time Zone Requested Delivery Date HeaderTZNZONECRM
RULE_REQ_DATECRMT_RULE_REQ_DATERAW16(0) *Rule Reqested Delivery Date HeaderTIMERULEIDCRM
ROUNDINGCRMT_ROUNDINGCHAR1(0) Round Requirement QuantityCRM_ROUNDINGCRM
PAR_ATP_SSTOCKCRMT_PAR_ATP_SSTOCKCHAR1(0) Parameter-Dependent ATP Safety StockCRM_PAR_ATP_SSTOCKCRM
CONF_RULECRMT_CONF_RULECHAR1(0) Confirmation RuleCRM_CONF_RULECRM
SUBST_EXCLCRMT_ATP_SUBST_EXCLCHAR2(0) CRMC_SUBST_EXCLRule Criterion 1CRM_ATP_SUBST_EXCLCRM
SEARCH_PATTERNCRMT_SEARCH_PATTERNCHAR10(0) CRMC_ATP_SEARCHRule Criterion 2CRM_SEARCH_PATTERNCRM
REASSIGN_ABILITYCRMT_REASSIGN_ABILITYCHAR1(0) Reassignment of Order ConfirmationsCRM_REASSIGN_ABILITYCRM
ABNORMAL_DEMANDCRMT_ABNORMAL_DEMANDCHAR1(0) Abnormal DemandCRM_ABNORMAL_DEMANDCRM


View list of all tables