SAP ABAP Table CRMV_SALES_ITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_SALES_ITEM	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ITM_TYPE	☑	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
3	BILLING_RELEVANT	☐	CRMT_BILLING_RELEVANT	CRM_BILLING_RELEVANT	CHAR	1	0	Billing Relevance
4	PRICING_RELEVANT	☐	CRMT_PRICING_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Start Pricing
5	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
6	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
7	IS_QUOTATION	☐	CRMT_IS_QUOTATION	CRM_IS_QUOTATION	NUMC	1	0	Relevance for Quotation
8	COPY_QUOTE	☐	CRMT_QUOTATION_IS_COPIED	CRM_QUOTATION_IS_COPIED	CHAR	1	0	Subsequent Processing for Quotation
9	PROBABILITY	☐	CRMT_ORDER_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Order Probability
10	ATP_PROF_QUOTE	☐	CRMT_ATP_PROFILE_QUOTATION	CRM_ATP_PROFILE	CHAR	6	0	ATP Profile for the Quotation	CRMC_ATP_PROFILE
11	COMPLETION_RULE	☐	CRMT_COMPLETION_RULE	CRM_COMPLETION_RULE	CHAR	1	0	Completion Rule for a Quantity / Value Contract
12	CREDITGROUP	☐	CRMT_CREDIT_ORDERITEM_GROUP	CRM_CREDIT_ORDERITEM_GROUP	CHAR	2	0	Credit Group for Grouping of Transaction Items	CRMC_CREDITGROUP
13	DESCRIPTION_CG	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
14	FIN_PROFILE_ID	☐	CRMT_FIN_PROFILE_ID	CHAR12	CHAR	12	0	Financing Profile ID	CRMC_FIN_PROFILE
15	PRICING_PROCESS	☐	CRMT_PRICING_PROCESS	CRM_PRICING_PROCESS	CHAR	1	0	Pricing Process
16	KSCHL	☐	PRCT_COND_TYPE	/SAPCND/COND_TYPE	CHAR	4	0	Pricing - Condition Type	/SAPCND/T685
17	GRADE_PROFILE	☐	CRMT_GRADE_PROFILE	CRM_GRADE_PROFILE	CHAR	4	0	Valuation Profile	CRMC_GRADE_PROF
18	OBJ_PROFILE_ID	☐	CRMT_OBJ_PROFILE_ID	CRM_OBJ_PROFILE_ID	CHAR	12	0	Object Profile ID	CRMC_OBJ_PROFILE
19	NRRANGENR	☐	CRMT_GAID_NRRANGE_NR	CHAR2	CHAR	2	0	Number Range Number GAID
20	OPT_CHNG_PROCESS	☐	CRMT_OPT_CHNG_PROCESS	CRMT_LEAS_CHNG_PROC	CHAR	4	0	Option Change Process
21	INTERCOMP_BILL	☐	CRMT_INTERCOMPANY_BILLING	CRM_INTERCOMPANY_BILLING	CHAR	1	0	Intercompany Billing
22	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	CRMC_SUBOB_CAT_I
23	I_DESCRIPTION_20	☐	CRMT_ITM_TYPE_DESC_20	TEXT20	CHAR	20	0	Item Category Text(20 character)
24	BILLING_CALCTYPE	☐	CRMT_BILLING_CALCTYPE	CRM_BILLING_CALCTYPE	CHAR	1	0	Billing: Calculation Type
25	MULT_REF	☐	CRMT_MULT_REF	CRMT_MULT_REF	CHAR	1	0	Multiple References of Orders to Quotations Possible
26	ROUNDING_ACTIVE	☐	CRMT_ROUNDING_ACTIVE		CHAR	1	0	Rounding Active
27	MIN_QTY_ACTIVE	☐	CRMT_MIN_QTY_ACTIVE	CRMT_MIN_QTY_ACTIVE	CHAR	1	0	Minimum Quantity: Automatic Change Is Active
28	QUANTITY_FIX	☐	CRMT_QUAN_FIX	CRM_BOOLEAN	CHAR	1	0	Fix the value of the quantity in order as in quotation
29	GTS_RELEVANCE	☐	CRMT_GTS_RELEVANCE	CRM_GTS_RELEVANCE	CHAR	1	0	Global Trade Services Relevance
30	DLV_RELEVANCE	☐	CRMT_DELIVERY_RELEVANT	CRM_DELIVERY_RELEVANT	CHAR	1	0	Delivery-Relevant
31	SUBJECT_PROFILE	☐	CRMT_SUBJECT_PROFILE	CRM_SUBJECT_PROFILE	CHAR	9	0	Subject Profile	CRMC_SUBJPROFILE
32	REVRECTYPE	☐	CRMT_REVRECTYPE	CRMT_REVRECTYPE	CHAR	1	0	Revenue recognition type
33	CREDIT_CNTRL_DET	☐	CRMT_CREDIT_CNTRL_DET	CRM_BOOLEAN	CHAR	1	0	Credit Control Area Determination (ERP/CRM)
34	LEAN_BILLING	☐	CRMT_LCB_LEAN_BILLING	CRM_LCB_LEAN_BILLING	CHAR	1	0	Scheduled Billing Method
35	TAX_EXEMPT_ACT	☐	CRM_TAX_EXEMPT_ACTIVE	CRM_BOOLEAN	CHAR	1	0	Flag if Tax Exemption process is active for this Item Cat.
36	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	CRMV_SALES_ITEM	ATP_PROF_QUOTE	CRMC_ATP_PROFILE	ATP_PROFILE
2	CRMV_SALES_ITEM	CLIENT	T000	MANDT	KEY	1	CN
3	CRMV_SALES_ITEM	CREDITGROUP	CRMC_CREDITGROUP	CREDIT_GROUP	KEY	1	CN
4	CRMV_SALES_ITEM	FIN_PROFILE_ID	CRMC_FIN_PROFILE	FIN_PROFILE_ID
5	CRMV_SALES_ITEM	GRADE_PROFILE	CRMC_GRADE_PROF	GRADE_PROFILE
6	CRMV_SALES_ITEM	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE	KEY	1	CN
7	CRMV_SALES_ITEM	KSCHL	/SAPCND/T685	KSCHL
8	CRMV_SALES_ITEM	OBJECT_TYPE	CRMC_SUBOB_CAT_I	SUBOBJ_CATEGORY
9	CRMV_SALES_ITEM	OBJ_PROFILE_ID	CRMC_OBJ_PROFILE	OBJ_PROFILE_ID
10	CRMV_SALES_ITEM	SUBJECT_PROFILE	CRMC_SUBJPROFILE	SUBJECT_PROFILE

History

Last changed by/on	SAP	20130604
SAP Release Created in