SAP ABAP Table CRMST_L2_ITEM_COMV (Lean Order - RFC - Item Data (Values))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ERP (Application Component) BSP for ERP Sales Order
     ⤷ CRM_ERP_IL (Package) ERP Sales Order: GENIL Implementation

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_L2_ITEM_COMV	Table Relationship Diagram
Short Description	Lean Order - RFC - Item Data (Values)

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	HANDLE	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
2	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
3	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
4	MABNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
5	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
6	KDMAT	☐	MATNR_KU	CRM_R3_VEND_MAT	CHAR	35	0	Customer Material Number
7	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
8	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
9	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
10	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
11	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
12	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
13	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
14	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
15	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
16	ETDAT	☐	ETDAT_ERP	ETDAT	CHAR	10	0	Schedule line date
17	PRGBZ	☐	PRGBZ_ERP	PRGBZ	CHAR	1	0	External date type	*
18	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
19	WERKS	☐	DWERK_ERP	WERKS	CHAR	4	0	Delivering Plant (Own or External)	*
20	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
21	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
22	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route
23	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
24	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
25	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
26	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
27	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
28	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
29	KURSK_INT	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
30	KURSK_EXT	☐			CHAR	12	0
31	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
32	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	CRMC_INCOTERM
33	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
34	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
35	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
36	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
37	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
38	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
39	VOLUM	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
40	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
41	SPART	☐	SPART	SPART	CHAR	2	0	Division
42	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
43	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
44	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
45	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
46	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
47	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
48	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
49	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
50	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
51	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
52	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
53	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
54	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
55	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
56	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
57	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group
58	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type
59	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	*
60	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
61	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
62	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1
63	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2
64	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3
65	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4
66	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5
67	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	*
68	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	*
69	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	*
70	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	*
71	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	*
72	VBELN_REF	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
73	POSNR_REF	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
74	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
75	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
76	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
77	UEBTO	☐	CRMT_UEBTO_ERPIL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
78	UNTTO	☐	CRMT_UNTTO_ERPIL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
79	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
80	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy
81	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
82	ZWERT_INT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
83	ZWERT_EXT	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
84	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion
85	SKOPF	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module
86	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
87	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
88	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
89	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
90	PCTRF	☐	CRMT_PCTRF_ERPIL	PRCTR	CHAR	10	0	Profit Center for Billing
91	ABGRS	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key
92	KALSM_K	☐	AUFKALSM	KALSM	CHAR	6	0	Costing Sheet	*
93	ZSCHL_K	☐	AUFZSCHL	CHAR6	CHAR	6	0	Overhead key
94	POSGUID	☐	POSGUID	SYSUUID_22	CHAR	22	0	ATP: Encryption of DELNR and DELPS
95	IUID_RELEVANT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
96	AWERT	☐	CRMT_ERP_AWERT	CRM_ERP_AWERT	CURR	17	2	Value of the Value Contract Already Released
97	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
98	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
99	SEPON	☐	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMST_L2_ITEM_COMV	GEWEI	T006	MSEHI	REF	C	CN
2	CRMST_L2_ITEM_COMV	INCO1	CRMC_INCOTERM	INCOTERMS1	REF	C	CN
3	CRMST_L2_ITEM_COMV	VOLEH	T006	MSEHI	REF	C	CN
4	CRMST_L2_ITEM_COMV	WAERK	TCURC	WAERS	REF	C	CN
5	CRMST_L2_ITEM_COMV	ZIEME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	700