SAP ABAP Table CMP_ITEM_DATA (Billing: Complaint Management - Item Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-BIL-IV-CP (Application Component) Complaints Processing
     ⤷ CMP (Package) Complaints Processing

Basic Data

Table Category	INTTAB	Structure
Structure	CMP_ITEM_DATA	Table Relationship Diagram
Short Description	Billing: Complaint Management - Item 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	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
2	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
3	ITEM_TYPE	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
4	DOCTYP	☐	CMP_COMPL_DOCTYP	CMP_COMPLAINT_DOCTYP	CHAR	6	0	Document Category of Complaint
5	CHGFLAG	☐	CMP_CHANGE	XFELD	CHAR	1	0	Item in Complaints Processing Can Be Changed
6	CHKFLAG	☐	CMP_CHKFLAG	XFELD	CHAR	1	0	Check Quantities in Complaints Processing
7	COMPREASTXT	☐	CMP_COMPREASTXT	CHAR50	CHAR	50	0	Text for Complaints Reason
8	SELFLAG	☐	CMP_SELFLAG	CHAR1	CHAR	1	0	Selected Item
9	DOCNR	☐	CMPDOCNR	BELNR	CHAR	10	0	Follow-On Document
10	LDOCNR	☐	CMPVBLNR	VBELN	CHAR	10	0	Reference Document	*
11	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
12	INTPOS	☐	CMPINTPOS	POSNR	NUMC	6	0	Subitem	*
13	LASTINTPOS	☐	LASTINTPOS	POSNR	NUMC	6	0	Item Number of the SD Document	*
14	UPOS	☐	UPOSNRCMP	POSNR	NUMC	6	0	Item Number of the SD Document	*
15	CREDITMNG	☐	CMP_CREDITMNG	MENG13	QUAN	13	3	Cumulated Credit Memo Quantity
16	CREDITMEINS	☐	CMP_CREDITMEINS	MEINS	UNIT	3	0	Cumulated Credit Memo Unit of Measure	*
17	PRINTSTATUS	☐	CMP_PRINTSTATUS	CHAR1	CHAR	1	0	Complaints Processing: Document Already Printed?
18	RETURNSTATUS	☐	CMP_RETURNSTATUS	CHAR1	CHAR	1	0	Complaints Processing: Returns Completed?
19	CMP_PRICE1	☐	CMP_PRICE1	WERTV6	CURR	11	2	Complaints Processing: Price 1
20	CMP_KPEIN1	☐	CMP_KPEIN1	KPEIN	DEC	5	0	Condition Pricing Unit 1
21	CMP_KMEIN1	☐	CMP_KMEIN1	MEINS	UNIT	3	0	Condition Unit 1	*
22	CMP_KWAEH1	☐	CMP_KWAEH1	WAERS	CUKY	5	0	Condition Currency (for Cumulation Fields)	*
23	CMP_KWAEH1_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	CMP_KOEIN1	☐	KOEIN	KOEIN	CUKY	5	0	Rate unit (currency, sales unit, or %)
25	CMP_PRICE2	☐	CMP_PRICE2	WERTV6	CURR	11	2	Complaints Processing: Price 2
26	CMP_KPEIN2	☐	CMP_KPEIN2	KPEIN	DEC	5	0	Condition Pricing Unit 2
27	CMP_KMEIN2	☐	CMP_KMEIN2	MEINS	UNIT	3	0	Condition Unit 2	*
28	CMP_KWAEH2	☐	CMP_KWAEH2	WAERS	CUKY	5	0	Condition Currency 2	*
29	CMP_KWAEH2_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	CMP_PRICE3	☐	CMP_PRICE3	WERTV6	CURR	11	2	Complaints Processing: Price 3
31	CMP_KPEIN3	☐	CMP_KPEIN3	KPEIN	DEC	5	0	Condition Pricing Unit 3
32	CMP_KMEIN3	☐	CMP_KMEIN3	MEINS	UNIT	3	0	Condition Unit 3	*
33	CMP_KWAEH3	☐	CMP_KWAEH3	WAERS	CUKY	5	0	Condition Currency 3	*
34	CMP_KWAEH3_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
35	CMP_PRICE4	☐	CMP_PRICE4	WERTV6	CURR	11	2	Complaints Processing: Price 4
36	CMP_KPEIN4	☐	CMP_KPEIN4	KPEIN	DEC	5	0	Condition Pricing Unit 4
37	CMP_KMEIN4	☐	CMP_KMEIN4	MEINS	UNIT	3	0	Unit of Measure 4	*
38	CMP_KWAEH4	☐	CMP_KWAEH4	WAERS	CUKY	5	0	Condition Currency 4	*
39	CMP_KWAEH4_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
40	CMP_PRICE5	☐	CMP_PRICE5	WERTV6	CURR	11	2	Complaints Processing: Price 5
41	CMP_KPEIN5	☐	CMP_KPEIN5	KPEIN	DEC	5	0	Condition Pricing Unit 5
42	CMP_KMEIN5	☐	CMP_KMEIN5	MEINS	UNIT	3	0	Condition Unit 5	*
43	CMP_KWAEH5	☐	CMP_KWAEH5	WAERS	CUKY	5	0	Condition Currency 5	*
44	CMP_KWAEH5_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
45	CMP_PRICE6	☐	CMP_PRICE6	WERTV6	CURR	11	2	Complaints Processing: Price 6
46	CMP_KPEIN6	☐	CMP_KPEIN6	KPEIN	DEC	5	0	Condition Pricing Unit 6
47	CMP_KMEIN6	☐	CMP_KMEIN6	MEINS	UNIT	3	0	Condition Unit 6	*
48	CMP_KWAEH6	☐	CMP_KWAEH6	WAERS	CUKY	5	0	Condition Currency 6	*
49	CMP_KWAEH6_INT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
50	CMP_MATNR_NEU	☐	CMP_MATNR_NEU	XFELD	CHAR	1	0	New Article Number Entered
51	CMP_FKIMG_NEW	☐	CMP_FKIMG_NEW	XFELD	CHAR	1	0	New Quantity Entered
52	CMP_VRKME_NEW	☐	CMP_VRKME_NEW	XFELD	CHAR	1	0	New Sales Unit Entered
53	CMP_PRICE_NEW	☐	CMP_PRICE_NEW	XFELD	CHAR	1	0	New Price Entered
54	.INCLUDE	☐				0	0	Extract from VBRP, Relevant Fields for Complaints Processing
55	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
56	POSNR	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
57	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
58	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
59	VRKME	☐	CMP_VRKME	MEINS	UNIT	3	0	Sales Unit	T006
60	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
61	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
62	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
63	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
64	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
65	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
66	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
67	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
68	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
69	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
70	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
71	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
72	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
73	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
74	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
75	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
76	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document	VBUK
77	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	VBUP
78	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
79	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
80	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
81	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
82	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
83	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
84	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
85	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
86	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
87	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
88	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
89	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
90	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
91	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
92	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	*
93	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
94	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
95	COMPREAS	☐	CMP_COMPREAS	CMP_COMPREAS	CHAR	4	0	Abbreviation for Complaints Reason	*
96	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
97	ETENR	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
98	ZAEHL	☐	DZAEHLER	NUMC2	NUMC	2	0	Counter in control tables
99	MSGID	☐	MSGID	ARBGB	CHAR	20	0	Message identification	*
100	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	*
101	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
102	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
103	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
104	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
105	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
106	SMART	☐	SMART	SMART	CHAR	1	0	Group type	*
107	LOEKZ	☐	LOEKZ	XFELD	CHAR	1	0	Asset class marked for deletion
108	UPOS_CHG	☐	UPOS_CHG	XCHAR	CHAR	1	0	Subitem has already been processed
109	MERK_MENG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
110	KDREF	☐	KDREF	KDREF	CHAR	20	0	Customer Reference Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMP_ITEM_DATA	AUBEL	VBUK	VBELN	REF	C	CN
2	CMP_ITEM_DATA	AUPOS	VBUP	POSNR	REF	C	CN
3	CMP_ITEM_DATA	GEWEI	T006	MSEHI	REF	C	CN
4	CMP_ITEM_DATA	LGORT	T001L	LGORT	REF	C	CN
5	CMP_ITEM_DATA	MATKL	T023	MATKL	REF	C	CN
6	CMP_ITEM_DATA	MEINS	T006	MSEHI	REF	C	CN
7	CMP_ITEM_DATA	POSNV	VBUP	POSNR	REF	C	CN
8	CMP_ITEM_DATA	PRODH	T179	PRODH	REF	C	CN
9	CMP_ITEM_DATA	UEPOS	VBUP	POSNR	REF	C	CN
10	CMP_ITEM_DATA	VBELV	VBUK	VBELN	REF	C	CN
11	CMP_ITEM_DATA	VGBEL	VBUK	VBELN	REF	1	CN
12	CMP_ITEM_DATA	VGPOS	VBUP	POSNR	REF	1	CN
13	CMP_ITEM_DATA	VOLEH	T006	MSEHI	REF	C	CN
14	CMP_ITEM_DATA	VRKME	T006	MSEHI	REF	C	CN
15	CMP_ITEM_DATA	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in