SAP ABAP Table MCJKOMVB (Billing KOMV LIS communication structure for sales area)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	MCJKOMVB	Table Relationship Diagram
Short Description	Billing KOMV LIS communication structure for sales area

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	Update Indicator for Statistics Updating
2	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
3	.INCLUDE	☐				0	0	Pricing Communications-Condition Record
4	.INCLUDE	☐				0	0	Conditions (Transaction Data)
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
7	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
8	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
9	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
10	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
11	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685A
12	KDATU	☐	KDATU	DATUM	DATS	8	0	Condition pricing date
13	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
14	KAWRT	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
15	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	KKURS	☐	KKURS	KKURS	DEC	9	5	Condition exchange rate for conversion to local currency
18	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
19	KMEIN	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
20	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
21	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
22	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
23	KSTAT	☐	KSTAT	XFELD	CHAR	1	0	Condition is used for statistics
24	KNPRS	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
25	KRUEK	☐	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
26	KRELI	☐	KRELI	KRELI	CHAR	1	0	Condition for invoice list
27	KHERK	☐	KHERK	KHERK	CHAR	1	0	Condition Origin
28	KGRPE	☐	KGRPE	KGRPE	CHAR	1	0	Group condition
29	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
30	KOLNR	☐	KOLNR	KOLNR	NUMC	2	0	Access Sequence - Access Number	*
31	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
32	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
33	KVSL1	☐	KVSL1	KVSCHL	CHAR	3	0	Account key	T687
34	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
35	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
36	KVSL2	☐	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	T687
37	SAKN2	☐	SAKNR_ACCR	SAKNR	CHAR	10	0	Number of Provision Account	SKA1
38	MWSK2	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
39	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
40	KUNNR	☐	KUNNR_KO	KUNNR	CHAR	10	0	Customer number (rebate recipient)	KNA1
41	KDIFF	☐	KDIFF	WERTV3	CURR	5	2	Rounding-off difference of the condition
42	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
43	KSTEU	☐	KSTEU	KSTEU	CHAR	1	0	Condition control
44	KINAK	☐	KINAK	KINAK	CHAR	1	0	Condition is inactive
45	KOAID	☐	KOAID	KOAID	CHAR	1	0	Condition class
46	ZAEKO	☐	DZAEKO	ZAEHK	NUMC	2	0	Condition counter for (header conditions)
47	KMXAW	☐	KMXAW	KMXWR	CHAR	1	0	Indicator for maximum condition base value
48	KMXWR	☐	KMXWR	KMXWR	CHAR	1	0	Indicator for maximum condition amount
49	KFAKTOR	☐	KFAKTOR	FLTP	FLTP	16	16	Factor for condition base value
50	KDUPL	☐	KDUPL	KDUPL	CHAR	1	0	Structure condition
51	KFAKTOR1	☐	KFAKTOR1	FLTP	FLTP	16	16	Factor for condition basis (period)
52	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
53	KSTBS	☐	KSTBS	WERTV8	CURR	15	2	Scale base value of the condition
54	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
55	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
56	KAWRT_K	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
57	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
58	KWERT_K	☐	KWERT	WERTV7	CURR	13	2	Condition Value
59	KFKIV	☐	KFKIV	XFELD	CHAR	1	0	Condition for Inter-Company Billing
60	KVARC	☐	KVARC	XFELD	CHAR	1	0	Condition for Configuration
61	KMPRS	☐	KMPRS	XFELD	CHAR	1	0	Condition changed manually
62	PRSQU	☐	PRSQU1	PRSQU	CHAR	1	0	Price source
63	VARCOND	☐	VARCOND	VARCON	CHAR	26	0	Variant condition	*
64	STUFE	☐	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
65	WEGXX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
66	KTREL	☐	KTREL	KTREL	CHAR	1	0	Relevance for account assignment
67	MDFLG	☐	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
68	TXJLV	☐	TXJCD_LEVEL	CHAR1	CHAR	1	0	Tax jurisdiction code level
69	KBFLAG	☐	KBFLAG	KBFLAG	RAW	2	0	Bit encrypted flags in Pricing
70	KOLNR3	☐	KOLNR3	KOLNR3	NUMC	3	0	Access Sequence - Access Number	*
71	CPF_GUID	☐	CPF_GUID	SYSUUID_C	CHAR	32	0	Identifier of CPF Formula in Document
72	.INCLUDE	☐				0	0	User Structure: Pricing
73	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
74	.INCLUDE	☐				0	0	Pricing Communication Condition Record, Dynamic
75	PRSCH	☐	PRSCH	CHAR4	CHAR	4	0	Price levels
76	KOFRM	☐	KOFRM	KOFRM	NUMC	3	0	Condition formula for alternative calculation type
77	STFKZ	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
78	KSTBM	☐	KSTBM_AKT	WERT8	CURR	15	2	Incremental scale: start of interval
79	KSTBM_NEXT	☐	KSTBM_NEXT	WERT8	CURR	15	2	Increase scale: end of interval
80	IX_KOMT1	☐	KOIDX	KOIDX	INT4	10	0	Index number for internal tables
81	IX_GKOMV	☐	KOIDX	KOIDX	INT4	10	0	Index number for internal tables
82	ZAEHK_IND	☐	DZAEHK_IND	ZAEHK	NUMC	2	0	Condition item index
83	DRUKZ	☐	DRUKZ	DRUKZ	CHAR	1	0	Print Indicator
84	STUNB	☐	STUNB	STUNR	NUMC	3	0	From reference step (for percentage conditions)	*
85	STUN2	☐	STUNB	STUNR	NUMC	3	0	From reference step (for percentage conditions)	*
86	KZWIW	☐	KZWIW	KZWIW	CHAR	1	0	Condition subtotal
87	KOFRA	☐	KOFRA	KOFRM	NUMC	3	0	Condition Formula for Condition Basis
88	KOFRS	☐	KOFRS	KOFRM	NUMC	3	0	Formula for scale base value
89	KMANU	☐	KMANU	KMANU	CHAR	1	0	Making manual entries
90	TXPRF	☐	TXPRF	TXPRF	CHAR	1	0	Rounding rule
91	KNEGA	☐	KNEGA	KNEGA	CHAR	1	0	Plus/minus sign of the condition amount
92	GANZZ	☐	GANZZ	XFELD	CHAR	1	0	Indicator: Currency Conversion after Multiplication
93	KOBLI	☐	KOBLI	XFELD	CHAR	1	0	Condition is mandatory
94	KAEND_BTR	☐	KAEND_BTR	XFELD	CHAR	1	0	Condition rate of change for amount/percentage
95	KAEND_WRT	☐	KAEND_WRT	XFELD	CHAR	1	0	Scope for changing the value
96	KAEND_UFK	☐	KAEND_UFK	XFELD	CHAR	1	0	Scope for changing conversion factors
97	KAEND_RCH	☐	KAEND_RCH	XFELD	CHAR	1	0	Condition Rate of Change for Calculation Type
98	KAEND_LOE	☐	KAEND_LOE	XFELD	CHAR	1	0	Delete the scope for changing rate
99	KAEND_MEH	☐	KAEND_MEH	XFELD	CHAR	1	0	Condition scope of change for unit of measure
100	KZTERM	☐	KZTERM	XFELD	CHAR	1	0	Terms of payment ID in the condition
101	FXMSG	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
102	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
103	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
104	BOSTA	☐	BOSTA	BOSTA	CHAR	1	0	Status of the agreement
105	KSPAE	☐	KSPAE	XFELD	CHAR	1	0	Rebate was set up retroactively
106	LOEVM_KO	☐	LOEVM_KO	XFELD	CHAR	1	0	Deletion indicator for condition item
107	KNUMA_BO	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)	KONA
108	BERGL	☐	BERGL	BERGL	CHAR	1	0	Calculation Base
109	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
110	RDIFA	☐	RDIFA	XFELD	CHAR	1	0	Rounding Difference Clearing
111	KMENG	☐	KMENG	XFELD	CHAR	1	0	Quantity conversion
112	KBUFF	☐	KBUFF	XFELD	CHAR	1	0	Condition read from buffer
113	BOSTA_CR	☐	BOSTA_CR	BOSTA_CR	CHAR	1	0	Condition Record Status (Rebate)
114	IS_CPF_ENABLED	☐	COND_IS_CPF_ENABLED	IS_CPF_ENABLED	CHAR	1	0	Condition Enabled for Config. Parameters and Formulas (CPF)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCJKOMVB	KAPPL	T681A	KAPPL
2	MCJKOMVB	KMEIN	T006	MSEHI
3	MCJKOMVB	KNUMA_BO	KONA	KNUMA
4	MCJKOMVB	KONMS	T006	MSEHI	REF	1	N
5	MCJKOMVB	KONWS	TCURC	WAERS	REF	1	N
6	MCJKOMVB	KSCHL	T685A	KSCHL
7	MCJKOMVB	KUNNR	KNA1	KUNNR
8	MCJKOMVB	KVSL1	T687	KVSL1
9	MCJKOMVB	KVSL2	T687	KVSL1
10	MCJKOMVB	LIFNR	LFA1	LIFNR
11	MCJKOMVB	MANDT	T000	MANDT
12	MCJKOMVB	SAKN1	SKA1	SAKNR
13	MCJKOMVB	SAKN2	SKA1	SAKNR
14	MCJKOMVB	VHART	TVTY	TRATY	REF	C	CN
15	MCJKOMVB	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in