SAP ABAP Table MCKONV (Pricing Communications-Condition Record)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCV (Package) R/3 application development: Sales Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCKONV	Table Relationship Diagram
Short Description	Pricing Communications-Condition Record

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	Conditions (Transaction Data)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
4	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
5	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
6	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
7	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
8	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685A
9	KDATU	☐	KDATU	DATUM	DATS	8	0	Condition pricing date
10	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
11	KAWRT	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
12	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
13	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
14	KKURS	☐	KKURS	KKURS	DEC	9	5	Condition exchange rate for conversion to local currency
15	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
16	KMEIN	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
17	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
18	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
19	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
20	KSTAT	☐	KSTAT	XFELD	CHAR	1	0	Condition is used for statistics
21	KNPRS	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
22	KRUEK	☐	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
23	KRELI	☐	KRELI	KRELI	CHAR	1	0	Condition for invoice list
24	KHERK	☐	KHERK	KHERK	CHAR	1	0	Condition Origin
25	KGRPE	☐	KGRPE	KGRPE	CHAR	1	0	Group condition
26	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
27	KOLNR	☐	KOLNR	KOLNR	NUMC	2	0	Access Sequence - Access Number	*
28	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
29	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
30	KVSL1	☐	KVSL1	KVSCHL	CHAR	3	0	Account key	T687
31	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
32	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
33	KVSL2	☐	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	T687
34	SAKN2	☐	SAKNR_ACCR	SAKNR	CHAR	10	0	Number of Provision Account	SKA1
35	MWSK2	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
36	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
37	KUNNR	☐	KUNNR_KO	KUNNR	CHAR	10	0	Customer number (rebate recipient)	KNA1
38	KDIFF	☐	KDIFF	WERTV3	CURR	5	2	Rounding-off difference of the condition
39	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
40	KSTEU	☐	KSTEU	KSTEU	CHAR	1	0	Condition control
41	KINAK	☐	KINAK	KINAK	CHAR	1	0	Condition is inactive
42	KOAID	☐	KOAID	KOAID	CHAR	1	0	Condition class
43	ZAEKO	☐	DZAEKO	ZAEHK	NUMC	2	0	Condition counter for (header conditions)
44	KMXAW	☐	KMXAW	KMXWR	CHAR	1	0	Indicator for maximum condition base value
45	KMXWR	☐	KMXWR	KMXWR	CHAR	1	0	Indicator for maximum condition amount
46	KFAKTOR	☐	KFAKTOR	FLTP	FLTP	16	16	Factor for condition base value
47	KDUPL	☐	KDUPL	KDUPL	CHAR	1	0	Structure condition
48	KFAKTOR1	☐	KFAKTOR1	FLTP	FLTP	16	16	Factor for condition basis (period)
49	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
50	KSTBS	☐	KSTBS	WERTV8	CURR	15	2	Scale base value of the condition
51	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
52	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
53	KAWRT_K	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
54	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	*
55	KWERT_K	☐	KWERT	WERTV7	CURR	13	2	Condition Value
56	KFKIV	☐	KFKIV	XFELD	CHAR	1	0	Condition for Inter-Company Billing
57	KVARC	☐	KVARC	XFELD	CHAR	1	0	Condition for Configuration
58	KMPRS	☐	KMPRS	XFELD	CHAR	1	0	Condition changed manually
59	PRSQU	☐	PRSQU1	PRSQU	CHAR	1	0	Price source
60	VARCOND	☐	VARCOND	VARCON	CHAR	26	0	Variant condition	*
61	STUFE	☐	HISTU	DEC2	DEC	2	0	Level (in Multi-Level BOM Explosions)
62	WEGXX	☐	WEGXX	DEC4	DEC	4	0	Path (for Multi-Level BOM Explosions)
63	KTREL	☐	KTREL	KTREL	CHAR	1	0	Relevance for account assignment
64	MDFLG	☐	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
65	TXJLV	☐	TXJCD_LEVEL	CHAR1	CHAR	1	0	Tax jurisdiction code level
66	KBFLAG	☐	KBFLAG	KBFLAG	RAW	2	0	Bit encrypted flags in Pricing
67	KOLNR3	☐	KOLNR3	KOLNR3	NUMC	3	0	Access Sequence - Access Number	*
68	CPF_GUID	☐	CPF_GUID	SYSUUID_C	CHAR	32	0	Identifier of CPF Formula in Document
69	.INCLUDE	☐				0	0	User Structure: Pricing
70	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in