CRMD_SALES - Business Transaction - Sales Set

Business Transaction - Sales Set information is stored in SAP table CRMD_SALES.
It is part of development package CRM_SALES in software component CRM-BTX. This development package consists of objects that can be grouped under "CRM Sales Data".

Fields for table CRMD_SALES

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMT_OBJECT_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID	GUID of a CRM Order Object	X	CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_SALES_INT	0
PO_NUMBER_UC	Sold-to Party's External Reference No. (in Capital Letters)		CRMT_PO_NUMBER_UC	CHAR	70
REGION	Region (State, Province, County)		CRMT_REGION	CHAR	6	*
INDUSTRY	Industry Sector		CRMT_INDUSTRY	CHAR	8	*
PCAT_HDR_GUID	Product Catalog GUID (header)			RAW	16
PCAT_VRT_GUID	Product Catalog Variant GUID			RAW	16
PCAT_CTY_GUID	GUID of a Product Catalog Area			RAW	16
.INCLUDE				CRMT_SALES_EXT	0
CUST_GROUP1	Customer Group 1		CRMT_CUST_GROUP1	CHAR	6	TVV1
CUST_GROUP2	Customer Group 2		CRMT_CUST_GROUP2	CHAR	6	TVV2
CUST_GROUP3	Customer Group 3		CRMT_CUST_GROUP3	CHAR	6	TVV3
CUST_GROUP4	Customer Group 4		CRMT_CUST_GROUP4	CHAR	6	TVV4
CUST_GROUP5	Customer Group 5		CRMT_CUST_GROUP5	CHAR	6	TVV5
PO_NUMBER_SOLD	Sold-To Party's External Reference Number		CRMT_PO_NUMBER_SOLD	CHAR	70
PO_DATE_SOLD	Reference Document Date		CRMT_PO_DATE_SOLD	DATS	16
YOUR_REF_SOLD	Sold-to Party Reference		CRMT_YOUR_REFERENCE_SOLD	CHAR	24
PO_NUMBER_SHIP	Ship-To Party's External Reference Number		CRMT_PO_NUMBER_SHIP	CHAR	70
PO_DATE_SHIP	Ship-To Party's Reference Document Date		CRMT_PO_DATE_SHIP	DATS	16
YOUR_REF_SHIP	Ship-To Party Reference		CRMT_YOUR_REFERENCE_SHIP	CHAR	24
USAGE_TYPE	Usage Indicator		CRMT_USAGE	CHAR	6	TVLV
SUBMISSION	Collective Number for Quotations		CRMT_SUBMISSION	CHAR	20
REJECTION	Cancellation Reason Code		CRMT_REJECTION_CODE	CHAR	4	CRMC_REJECTION
PROBABILITY	Order Probability		CRMT_ORDER_PROBABILITY	NUMC	6
DATE_QTY_FIXED	Fixed Date and Quantity		CRMT_DATE_QTY_FIXED	CHAR	2
REQ_DLV_DATE	Requested Delivery Date Header		CRMT_REQ_DLV_DATE	DEC	8
REQ_TIMEZONE	Time Zone Requested Delivery Date Header		CRMT_REQ_DATE_TIMEZONE	CHAR	12	*
RULE_REQ_DATE	Rule Reqested Delivery Date Header		CRMT_RULE_REQ_DATE	RAW	16	*
ROUNDING	Round Requirement Quantity		CRMT_ROUNDING	CHAR	2
PAR_ATP_SSTOCK	Parameter-Dependent ATP Safety Stock		CRMT_PAR_ATP_SSTOCK	CHAR	2
CONF_RULE	Confirmation Rule		CRMT_CONF_RULE	CHAR	2
SUBST_EXCL	Rule Criterion 1		CRMT_ATP_SUBST_EXCL	CHAR	4	CRMC_SUBST_EXCL
SEARCH_PATTERN	Rule Criterion 2		CRMT_SEARCH_PATTERN	CHAR	20	CRMC_ATP_SEARCH
REASSIGN_ABILITY	Reassignment of Order Confirmations		CRMT_REASSIGN_ABILITY	CHAR	2
ABNORMAL_DEMAND	Abnormal Demand		CRMT_ABNORMAL_DEMAND	CHAR	2
MAX_LOC	Maximum Number of Locations		CRMT_MAX_LOC	INT1	1
REQ_SOLUTION	Complaint Requested Solution		CRMS4_REQ_SOLUTION	CHAR	8	*
ISSUE_CAUSED_BY	Complaint Issue Caused By		CRMS4_COMP_ISS_CAU	CHAR	8	*
COMPLAINT_IMPACT	Complaint Impact		CRMS4_COMP_IMPACT	CHAR	8	*
COMPLAINT_REASON	Complaint Reason		CRMS4_COMP_REASON	CHAR	8	*
CUST_PROFILE	ID of Profile of Sold-To Party			CHAR	20
.INCLUDE				INCL_EEW_SALES	0
SALES_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_EEW_SALES	0
.INCLUDE				CRMS_NFE_REF	0
NFE_REF_NUM	Text (length 35)		TEXT35	CHAR	70
NFE_REF_DATE	NFe External Reference Date			DATS	16