SAP ABAP Table KMBW_VB (SP Calculations: Internal Structure for Posting Comp. Prices)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WVKP (Package) IS-R: Sales pricing

Basic Data

Table Category	INTTAB	Structure
Structure	KMBW_VB	Table Relationship Diagram
Short Description	SP Calculations: Internal Structure for Posting Comp. Prices

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	KMBW_VB	BGINT	KLAH	CLINT
2	KMBW_VB	KAPPL	T681A	KAPPL
3	KMBW_VB	KMEIN	T006	MSEHI
4	KMBW_VB	KNUMA_BO	KONA	KNUMA
5	KMBW_VB	KONMS	T006	MSEHI	REF	1	N
6	KMBW_VB	KONWS	TCURC	WAERS	REF	1	N
7	KMBW_VB	KSCHL	T685A	KSCHL
8	KMBW_VB	KUNNR	KNA1	KUNNR
9	KMBW_VB	KVSL1	T687	KVSL1
10	KMBW_VB	KVSL2	T687	KVSL1
11	KMBW_VB	LIFNR	LFA1	LIFNR
12	KMBW_VB	MANDT	T000	MANDT
13	KMBW_VB	MATNR	MARA	MATNR
14	KMBW_VB	PLTYP	T189	PLTYP
15	KMBW_VB	SAKN1	SKA1	SAKNR
16	KMBW_VB	SAKN2	SKA1	SAKNR
17	KMBW_VB	VHART	TVTY	TRATY	REF	C	CN
18	KMBW_VB	VKORG	TVKO	VKORG
19	KMBW_VB	VRKME	T006	MSEHI
20	KMBW_VB	VTWEG	TVTW	VTWEG
21	KMBW_VB	WAERS	TCURC	WAERS
22	KMBW_VB	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in