SAP ABAP Table KONP (Conditions (Item))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ AP-PRC-PR (Application Component) Pricing
     ⤷ VKON (Package) Application development R/3 conditions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	KONP	Table Relationship Diagram
Short Description	Conditions (Item)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KNUMH	☑	KNUMH	KNUMB	CHAR	10	0	Condition record number
3	KOPOS	☑	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
4	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
5	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
6	KNUMT	☐	KNUMT	KNUMB	CHAR	10	0	Number of texts
7	STFKZ	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
8	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
9	KSTBM	☐	KSTBM	MENG15	QUAN	15	3	Condition scale quantity
10	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
11	KSTBW	☐	KSTBW	WERT8	CURR	15	2	Scale value
12	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
13	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
14	KBETR	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
15	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
16	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
17	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
18	PRSCH	☐	SCLGR	CHAR4	CHAR	4	0	Scale Group
19	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
20	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
21	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
22	MXWRT	☐	MXWRT	WERTV6	CURR	11	2	Lower limit of the condition rate/amount
23	GKWRT	☐	GKWRT	WERTV6	CURR	11	2	Upper limit for the condition rate
24	PKWRT	☐	PKWRT	WERTV8	CURR	15	2	Planned condition value
25	FKWRT	☐	FKWRT	WERTV8	CURR	15	2	Cumulative guaranteed discount (not used)
26	RSWRT	☐	RSWRT	WERTV8	CURR	15	2	Accumulated accruals values (not used)
27	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	TCURC
28	UKBAS	☐	UKBAS	WERTV8	CURR	15	2	Planned condition basis
29	KZNEP	☐	KZNEP	KZNEP	CHAR	1	0	Condition exclusion indicator	T686A
30	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
31	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
32	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
33	LOEVM_KO	☐	LOEVM_KO	XFELD	CHAR	1	0	Deletion indicator for condition item
34	ZAEHK_IND	☐	DZAEHK_IND	ZAEHK	NUMC	2	0	Condition item index
35	BOMAT	☐	BOMAT	MATNR	CHAR	18	0	Material for rebate settlement	MARA
36	KBRUE	☐	KBRUE	WERTV6	CURR	11	2	Accrual Amount
37	KSPAE	☐	KSPAE	XFELD	CHAR	1	0	Rebate was set up retroactively
38	BOSTA	☐	BOSTA_CR	BOSTA_CR	CHAR	1	0	Condition Record Status (Rebate)
39	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
40	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
41	KNUMA_SQ	☐	KNUMA_SQ	KNUMA	CHAR	10	0	Sales quote	KONA
42	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
43	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
44	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
45	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
46	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
47	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value
48	KOMXWRT	☐	KOMXWRT	WERTV7	CURR	13	2	Maximum condition value
49	KLF_STG	☐	KLF_STG	KLFNR	NUMC	4	0	Number of incremental scale
50	KLF_KAL	☐	KLF_KAL	KLFNR	NUMC	4	0	Scale number for pricing
51	VKKAL	☐	VKKAL	XFELD	CHAR	1	0	Sales Price Calculation: Relevant to pricing
52	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
53	KNUMA_BO	☐	KNUMA_BO	KNUMA	CHAR	10	0	Agreement (subsequent settlement)	KONA
54	MWSK2	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
55	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
56	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
57	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
58	MDFLG	☐	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
59	KFRST	☐	KFRST	KFRST	CHAR	1	0	Release Status
60	UASTA	☐	UASTA	UASTA	CHAR	1	0	Status of business volume comparison for a condition
61	.INCLU--AP	☐				0	0	Customer Fields for KONP
62	/BEV1/ECRTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
63	/BEV1/ECRTN	☐	RANL	RANL	CHAR	13	0	Contract Number
64	/BEV1/ECEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KONP	BOMAT	MARA	MATNR	KEY	1	CN
2	KONP	KAPPL	T681A	KAPPL	REF	C	CN
3	KONP	KMEIN	T006	MSEHI	REF	C	CN
4	KONP	KNUMA_AG	KONA	KNUMA	REF	C	CN
5	KONP	KNUMA_BO	KONA	KNUMA
6	KONP	KNUMA_PI	KONA	KNUMA	REF	C	CN
7	KONP	KNUMA_SQ	KONA	KNUMA	REF	C	CN
8	KONP	KONMS	T006	MSEHI	REF	C	CN
9	KONP	KONWA	TCURC	WAERS	REF	C	CN
10	KONP	KONWS	TCURC	WAERS	REF	C	CN
11	KONP	KSCHL	T685	KSCHL
12	KONP	KUNNR	KNA1	KUNNR	REF	C	CN
13	KONP	KWAEH	TCURC	WAERS	REF	C	CN
14	KONP	KZNEP	T686A	KZNEP	REF	C	CN
15	KONP	LIFNR	LFA1	LIFNR	REF	C	CN
16	KONP	MANDT	T000	MANDT	KEY	1	CN
17	KONP	MEINS	T006	MSEHI	REF	C	CN
18	KONP	VBEWA	TZB0A	SBEWART		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in