SAP ABAP Table JVKONV (IS-Oil / Joint Venture / Data table for CRP pricing data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GJVA (Package) Joint venture accounting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVKONV	Table Relationship Diagram
Short Description	IS-Oil / Joint Venture / Data table for CRP pricing data

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	KNUMV	☑	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
3	KPOSN	☑	KPOSN	NUM6	NUMC	6	0	Condition Item Number
4	STUNR	☑	STUNR	STUNR	NUMC	3	0	Level Number	*
5	ZAEHK	☑	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
6	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
7	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
8	KDATU	☐	KDATU	DATUM	DATS	8	0	Condition pricing date
9	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
10	KAWRT	☐	KAWRT	WERTV8	CURR	15	2	Condition Basis
11	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
12	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
13	KKURS	☐	KKURS	KKURS	DEC	9	5	Condition exchange rate for conversion to local currency
14	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
15	KMEIN	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	T006
16	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
17	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
18	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
19	KSTAT	☐	KSTAT	XFELD	CHAR	1	0	Condition is used for statistics
20	KNPRS	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
21	KRUEK	☐	KRUEK	XFELD	CHAR	1	0	Condition is Relevant for Accrual (e.g. Freight)
22	KRELI	☐	KRELI	KRELI	CHAR	1	0	Condition for invoice list
23	KHERK	☐	KHERK	KHERK	CHAR	1	0	Condition Origin
24	KGRPE	☐	KGRPE	KGRPE	CHAR	1	0	Group condition
25	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
26	KOLNR	☐	KOLNR	KOLNR	NUMC	2	0	Access Sequence - Access Number	*
27	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
28	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
29	KVSL1	☐	KVSL1	KVSCHL	CHAR	3	0	Account key	T687
30	SAKN1	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
31	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
32	KVSL2	☐	KVSL2	KVSCHL	CHAR	3	0	Account key - accruals / provisions	T687
33	SAKN2	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
34	MWSK2	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
35	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
36	KUNNR	☐	KUNNR_KO	KUNNR	CHAR	10	0	Customer number (rebate recipient)	KNA1
37	KDIFF	☐	KDIFF	WERTV3	CURR	5	2	Rounding-off difference of the condition
38	KWERT	☐	KWERT	WERTV7	CURR	13	2	Condition Value
39	KSTEU	☐	KSTEU	KSTEU	CHAR	1	0	Condition control
40	KINAK	☐	KINAK	KINAK	CHAR	1	0	Condition is inactive
41	KOAID	☐	KOAID	KOAID	CHAR	1	0	Condition class
42	ZAEKO	☐	DZAEKO	ZAEHK	NUMC	2	0	Condition counter for (header conditions)
43	KMXAW	☐	KMXAW	KMXWR	CHAR	1	0	Indicator for maximum condition base value
44	KMXWR	☐	KMXWR	KMXWR	CHAR	1	0	Indicator for maximum condition amount
45	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVKONV	KAPPL	T681A	KAPPL	REF	1	CN
2	JVKONV	KMEIN	T006	MSEHI	REF	C	CN
3	JVKONV	KUNNR	KNA1	KUNNR	REF	C	CN
4	JVKONV	KVSL1	T687	KVSL1	REF	C	CN
5	JVKONV	KVSL2	T687	KVSL1	REF	C	CN
6	JVKONV	LIFNR	LFA1	LIFNR	REF	C	CN
7	JVKONV	MANDT	T000	MANDT	KEY	1	CN
8	JVKONV	SAKN1	SKA1	SAKNR	REF	C	CN
9	JVKONV	SAKN2	SKA1	SAKNR	REF	C	CN
10	JVKONV	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in