SAP ABAP Table CRMT_SALES_IX (Index Structure for Sales Set)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-BF (Application Component) Basic Functions for Business Transactions
     ⤷ CRM_IC_APPL_SOS (Package) CRM Interaction Center Simple Order Search

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_SALES_IX	Table Relationship Diagram
Short Description	Index Structure for Sales Set

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	Sales Set: Structure With External Fields
2	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
3	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
4	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
5	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
6	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
7	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
8	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
9	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
10	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
11	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
12	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
13	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
14	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
15	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	CRMC_REJECTION
16	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
17	DATE_QTY_FIXED	☐	CRMT_DATE_QTY_FIXED	CRM_BOOLEAN	CHAR	1	0	Fixed Date and Quantity
18	REQ_DLV_DATE	☐	CRMT_REQ_DLV_DATE	BCOS_TSTMP	DEC	15	0	Requested Delivery Date Header
19	REQ_TIMEZONE	☐	CRMT_REQ_DATE_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone Requested Delivery Date Header	*
20	RULE_REQ_DATE	☐	CRMT_RULE_REQ_DATE	TIMERULEID	RAW	16	0	Rule Reqested Delivery Date Header	*
21	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
22	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
23	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
24	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
25	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
26	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
27	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
28	MAX_LOC	☐	CRMT_MAX_LOC		INT1	3	0	Maximum Number of Locations
29	CUST_PROFILE	☐	CRMT_CUST_PROFILE	CRM_CUST_PROFILE	CHAR	10	0	ID of Profile of Sold-To Party
30	.INCLUDE	☐				0	0	EEW Extension
31	SALES_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
32	.INCLUDE	☐				0	0
33	CUST_GROUP1_XTXT	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
34	CUST_GROUP2_XTXT	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
35	CUST_GROUP3_XTXT	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
36	CUST_GROUP4_XTXT	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
37	CUST_GROUP5_XTXT	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
38	USAGE_TYPE_XTXT	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	*
39	REJECTION_XTXT	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
40	.INCLUDE	☐				0	0	Sales Set: Structure With External Dynamic Fields
41	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
42	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
43	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
44	RULE_REQ_DATE_T	☐	CRMT_RULE_REQ_DATE_T	TIMENAME	CHAR	12	0	Rule Req Delivery Date

Foreign Keys

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

History

Last changed by/on	SAP	20110908
SAP Release Created in	500