SAP ABAP Table CRMT_SALES_DB_WRK (Sales Set: Workarea for Database Buffer)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_SALES (Package) CRM Sales Data

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_SALES_DB_WRK	Table Relationship Diagram
Short Description	Sales Set: Workarea for Database Buffer

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Business Transaction - Sales Set
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Sales Set: Structure With System Fields
6	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
7	REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
8	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
9	PCAT_HDR_GUID	☐	COMT_PCAT_HDR_GUID	SYSUUID	RAW	16	0	Product Catalog GUID (Header)
10	PCAT_VRT_GUID	☐	COMT_PCAT_VRT_GUID	SYSUUID	RAW	16	0	Product Catalog Variant GUID
11	PCAT_CTY_GUID	☐	COMT_PCAT_CTY_GUID	SYSUUID	RAW	16	0	GUID of a Product Catalog Area
12	.INCLUDE	☐				0	0	Sales Set: Structure With External Fields
13	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
14	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
15	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
16	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
17	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
18	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
19	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
20	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
21	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
22	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
23	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
24	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
25	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
26	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	CRMC_REJECTION
27	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
28	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
29	REQ_DLV_DATE	☐	CRMT_REQ_DLV_DATE	BCOS_TSTMP	DEC	15	0	Requested Delivery Date Header
30	REQ_TIMEZONE	☐	CRMT_REQ_DATE_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone Requested Delivery Date Header	*
31	RULE_REQ_DATE	☐	CRMT_RULE_REQ_DATE	TIMERULEID	RAW	16	0	Rule Reqested Delivery Date Header	*
32	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
33	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
34	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
35	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
36	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
37	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
38	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
39	MAX_LOC	☐	CRMT_MAX_LOC		INT1	3	0	Maximum Number of Locations
40	CUST_PROFILE	☐	CRMT_CUST_PROFILE	CRM_CUST_PROFILE	CHAR	10	0	ID of Profile of Sold-To Party
41	.INCLUDE	☐				0	0	EEW Extension
42	SALES_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
43	.INCLUDE	☐				0	0
44	.INCLUDE	☐				0	0	Sales Set: Dynamic Fields for Database Buffer
45	NOREC_FLAG	☐	CRMT_NOREC	CRM_BOOLEAN	CHAR	1	0	Entry does not Exist in Database

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_SALES_DB_WRK	CUST_GROUP1	CRMC_CUSTGRP1	CUST_GROUP1	REF	C	CN
2	CRMT_SALES_DB_WRK	CUST_GROUP2	CRMC_CUSTGRP2	CUST_GROUP2	REF	C	CN
3	CRMT_SALES_DB_WRK	CUST_GROUP3	CRMC_CUSTGRP3	CUST_GROUP3	REF	C	CN
4	CRMT_SALES_DB_WRK	CUST_GROUP4	CRMC_CUSTGRP4	CUST_GROUP4	REF	C	CN
5	CRMT_SALES_DB_WRK	CUST_GROUP5	CRMC_CUSTGRP5	CUST_GROUP5	REF	C	CN
6	CRMT_SALES_DB_WRK	REJECTION	CRMC_REJECTION	REJECTION_CODE
7	CRMT_SALES_DB_WRK	SEARCH_PATTERN	CRMC_ATP_SEARCH	SEARCH_PATTERN
8	CRMT_SALES_DB_WRK	SUBST_EXCL	CRMC_SUBST_EXCL	SUBST_EXCL
9	CRMT_SALES_DB_WRK	USAGE_TYPE	CRMC_USAGE	CALL_USAGE	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in