SAP ABAP Table CRMS_WEC_ITEM_CATEGORY_DATA (Item Category data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ WEC-APP-SLS-CRM (Application Component) WebChannel Sales using CRM Sales
     ⤷ CRM_WEC_SALESTRANSACTIONS (Package) Web Channel: Sales Transactions

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_WEC_ITEM_CATEGORY_DATA	Table Relationship Diagram
Short Description	Item Category data

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	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
2	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
3	DISTRIBUTION_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
4	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
5	.INCLUDE	☐				0	0	Transaction Item Type - Sales Control Parameter
6	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
7	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
8	BILLING_RELEVANT	☐	CRMT_BILLING_RELEVANT	CRM_BILLING_RELEVANT	CHAR	1	0	Billing Relevance
9	PRICING_RELEVANT	☐	CRMT_PRICING_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Start Pricing
10	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
11	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
12	IS_QUOTATION	☐	CRMT_IS_QUOTATION	CRM_IS_QUOTATION	NUMC	1	0	Relevance for Quotation
13	COPY_QUOTE	☐	CRMT_QUOTATION_IS_COPIED	CRM_QUOTATION_IS_COPIED	CHAR	1	0	Subsequent Processing for Quotation
14	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
15	ATP_PROF_QUOTE	☐	CRMT_ATP_PROFILE_QUOTATION	CRM_ATP_PROFILE	CHAR	6	0	ATP Profile for the Quotation	CRMC_ATP_PROFILE
16	COMPLETION_RULE	☐	CRMT_COMPLETION_RULE	CRM_COMPLETION_RULE	CHAR	1	0	Completion Rule for a Quantity / Value Contract
17	CREDITGROUP	☐	CRMT_CREDIT_ORDERITEM_GROUP	CRM_CREDIT_ORDERITEM_GROUP	CHAR	2	0	Credit Group for Grouping of Transaction Items	CRMC_CREDITGROUP
18	FIN_PROFILE_ID	☐	CRMT_FIN_PROFILE_ID	CHAR12	CHAR	12	0	Financing Profile ID	CRMC_FIN_PROFILE
19	PRICING_PROCESS	☐	CRMT_PRICING_PROCESS	CRM_PRICING_PROCESS	CHAR	1	0	Pricing Process
20	OBJ_PROFILE_ID	☐	CRMT_OBJ_PROFILE_ID	CRM_OBJ_PROFILE_ID	CHAR	12	0	Object Profile ID	CRMC_OBJ_PROFILE
21	NRRANGENR	☐	CRMT_GAID_NRRANGE_NR	CHAR2	CHAR	2	0	Number Range Number GAID
22	OPT_CHNG_PROCESS	☐	CRMT_OPT_CHNG_PROCESS	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Option Change Process	*
23	KSCHL	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	/SAPCND/T685
24	GRADE_PROFILE	☐	CRMT_GRADE_PROFILE	CRM_GRADE_PROFILE	CHAR	4	0	Valuation Profile	CRMC_GRADE_PROF
25	INTERCOMP_BILL	☐	CRMT_INTERCOMPANY_BILLING	CRM_INTERCOMPANY_BILLING	CHAR	1	0	Intercompany Billing
26	BILLING_CALCTYPE	☐	CRMT_BILLING_CALCTYPE	CRM_BILLING_CALCTYPE	CHAR	1	0	Billing: Calculation Type
27	MULT_REF	☐	CRMT_MULT_REF	CRMT_MULT_REF	CHAR	1	0	Multiple References of Orders to Quotations Possible
28	MIN_QTY_ACTIVE	☐	CRMT_MIN_QTY_ACTIVE	CRMT_MIN_QTY_ACTIVE	CHAR	1	0	Minimum Quantity: Automatic Change Is Active
29	ROUNDING_ACTIVE	☐	CRMT_ROUNDING_ACTIVE		CHAR	1	0	Rounding Active
30	QUANTITY_FIX	☐	CRMT_QUAN_FIX	CRM_BOOLEAN	CHAR	1	0	Fix the value of the quantity in order as in quotation
31	GTS_RELEVANCE	☐	CRMT_GTS_RELEVANCE	CRM_GTS_RELEVANCE	CHAR	1	0	Global Trade Services Relevance
32	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
33	SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
34	REVRECTYPE	☐	CRMT_REVRECTYPE	CRMT_REVRECTYPE	CHAR	1	0	Revenue recognition type
35	CREDIT_CNTRL_DET	☐	CRMT_CREDIT_CNTRL_DET	CRM_BOOLEAN	CHAR	1	0	Credit Control Area Determination (ERP/CRM)
36	LEAN_BILLING	☐	CRMT_LCB_LEAN_BILLING	CRM_LCB_LEAN_BILLING	CHAR	1	0	Scheduled Billing Method
37	TAX_EXEMPT_ACT	☐	CRM_TAX_EXEMPT_ACTIVE	CRM_BOOLEAN	CHAR	1	0	Flag if Tax Exemption process is active for this Item Cat.
38	EXTERNAL_BILL_SC	☐	CRMT_EXTERNAL_BILL_SCENARIO	CRM_EXTERNAL_BILL_SCENARIO	CHAR	1	0	Billing Scenario for External Billing

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_WEC_ITEM_CATEGORY_DATA	ATP_PROF_QUOTE	CRMC_ATP_PROFILE	ATP_PROFILE
2	CRMS_WEC_ITEM_CATEGORY_DATA	CLIENT	T000	MANDT	KEY	1	CN
3	CRMS_WEC_ITEM_CATEGORY_DATA	CREDITGROUP	CRMC_CREDITGROUP	CREDIT_GROUP	KEY	1	CN
4	CRMS_WEC_ITEM_CATEGORY_DATA	FIN_PROFILE_ID	CRMC_FIN_PROFILE	FIN_PROFILE_ID
5	CRMS_WEC_ITEM_CATEGORY_DATA	GRADE_PROFILE	CRMC_GRADE_PROF	GRADE_PROFILE
6	CRMS_WEC_ITEM_CATEGORY_DATA	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE	KEY	1	CN
7	CRMS_WEC_ITEM_CATEGORY_DATA	KSCHL	/SAPCND/T685	KSCHL
8	CRMS_WEC_ITEM_CATEGORY_DATA	OBJ_PROFILE_ID	CRMC_OBJ_PROFILE	OBJ_PROFILE_ID
9	CRMS_WEC_ITEM_CATEGORY_DATA	SUBJECT_PROFILE	CRMC_SUBJPROFILE	SUBJECT_PROFILE

History

Last changed by/on	SAP	20131122
SAP Release Created in