SAP ABAP Table JVPO1 (JVA: Plan Line Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GJVC (Package) Joint venture objects with original in ALR

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JVPO1	Table Relationship Diagram
Short Description	JVA: Plan Line Items

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	RCLNT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	GL_SIRID	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
3	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
4	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
5	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
6	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
8	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
9	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
10	RPMAX	☐	RPMAX	RPMAX	NUMC	3	0	Period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	DOCNR	BELNR	CHAR	10	0	Doc. Number
13	DOCLN	☐	JV_DOCLN	BUZEI	NUMC	3	0	Line Item in Joint Venture Document
14	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
15	RJVNAM	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
16	REGROU	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
17	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
18	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
19	RKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
20	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
21	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
22	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
23	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
24	RANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
25	RANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
26	RANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
27	RRECIN	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
28	RPARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
29	RDPOM	☐	JV_DPOM	CHAR4	CHAR	4	0	Posting Period Difference for Operational Month
30	RDBILLM	☐	JV_DBILLM	CHAR4	CHAR	4	0	Invoice Month: Posting Period Difference
31	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
32	AUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
33	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
34	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
35	TSLVT	☐	TSLVT9	WERTV9	CURR	17	2	Balance carried forward in transaction currency
36	TSL01	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
37	TSL02	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
38	TSL03	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
39	TSL04	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
40	TSL05	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
41	TSL06	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
42	TSL07	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
43	TSL08	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
44	TSL09	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
45	TSL10	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
46	TSL11	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
47	TSL12	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
48	TSL13	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
49	TSL14	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
50	TSL15	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
51	TSL16	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
52	HSLVT	☐	HSLVT9	WERTV9	CURR	17	2	Balance carried forward in local currency
53	HSL01	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
54	HSL02	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
55	HSL03	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
56	HSL04	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
57	HSL05	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
58	HSL06	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
59	HSL07	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
60	HSL08	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
61	HSL09	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
62	HSL10	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
63	HSL11	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
64	HSL12	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
65	HSL13	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
66	HSL14	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
67	HSL15	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
68	HSL16	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
69	KSLVT	☐	KSLVT9	WERTV9	CURR	17	2	Balance carried forward in group currency
70	KSL01	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
71	KSL02	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
72	KSL03	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
73	KSL04	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
74	KSL05	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
75	KSL06	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
76	KSL07	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
77	KSL08	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
78	KSL09	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
79	KSL10	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
80	KSL11	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
81	KSL12	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
82	KSL13	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
83	KSL14	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
84	KSL15	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
85	KSL16	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
86	MSLVT	☐	MSLVT	MENGV8	QUAN	15	3	Balance carried forward of quantity
87	MSL01	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
88	MSL02	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
89	MSL03	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
90	MSL04	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
91	MSL05	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
92	MSL06	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
93	MSL07	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
94	MSL08	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
95	MSL09	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
96	MSL10	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
97	MSL11	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
98	MSL12	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
99	MSL13	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
100	MSL14	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
101	MSL15	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
102	MSL16	☐	MSLXX	MENGV8	QUAN	15	3	Total of the transactions of period in units of measure
103	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
104	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
105	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
106	DOCTY	☐	BLART	BLART	CHAR	2	0	Document type	T003
107	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
108	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
109	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
110	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
111	REFDOCNR	☐	DOCNR	BELNR	CHAR	10	0	Doc. Number
112	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
113	REFDOCLN	☐	JV_REFDLN	NUMC5	NUMC	5	0	Line Item in Joint Venture Reference Doc
114	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
115	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
116	REFFIDLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
117	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
118	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
119	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
120	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
121	BILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
122	ORECID	☐	JV_ORECID	JV_RECIND	CHAR	2	0	Original Recovery Indicator	T8JJ
123	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
124	BILLM	☐	JV_BILLM	DATUM	DATS	8	0	Billing Month
125	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month
126	CBPERIOD	☐	JV_CBPERI	POPER	NUMC	3	0	JV Cutback Period
127	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
128	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
129	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
130	MMACT	☐	JV_MM_ACT	JV_MM_ACT	CHAR	1	0	JVA MM Activity Type
131	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
132	CYCLE	☐	CYCLE	CYCLE	CHAR	10	0	Allocation/cycle
133	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
134	SEQNR	☐	SQNR	SQNR	NUMC	4	0	Segment number within a cycle	*
135	SEQNAME	☐	SEQNAME	SEQNAME	CHAR	10	0	Name of a segment in assessment/distribution
136	REFCYC	☐	JV_REFCYC	TEXT10	CHAR	10	0	Reference Field for Allocation Cycle
137	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
138	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	T8JX
139	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
140	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
141	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
142	REFAWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
143	REFAWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
144	REFAWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
145	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVPO1	AUNIT	T006	MSEHI
2	JVPO1	BILID	T8JA	BILIND
3	JVPO1	CONDI	T8JX	CONDCODE
4	JVPO1	DOCTY	T003	BLART
5	JVPO1	EBELN	EKKO	EBELN
6	JVPO1	EBELP	EKPO	EBELP
7	JVPO1	LOGSYS	TBDLS	LOGSYS
8	JVPO1	MATNR	MARA	MATNR
9	JVPO1	NPLNR	AUFK	AUFNR
10	JVPO1	ORECID	T8JJ	RECID
11	JVPO1	RANBWA	TABW	BWASL
12	JVPO1	RANLN1	ANLH	ANLN1
13	JVPO1	RANLN2	ANLA	ANLN2
14	JVPO1	RBUKRS	T001	BUKRS
15	JVPO1	RBUSA	TGSB	GSBER
16	JVPO1	RCLNT	T000	MANDT
17	JVPO1	REFAWTYP	TTYP	AWTYP
18	JVPO1	REFLOGSYS	TBDLS	LOGSYS
19	JVPO1	REGROU	T8JF	EGRUP
20	JVPO1	RJVNAM	T8JV	VNAME
21	JVPO1	RKOKRS	TKA01	KOKRS
22	JVPO1	RLDNR	T881	RLDNR
23	JVPO1	RORDNR	AUFK	AUFNR
24	JVPO1	RPARTN	KNA1	KUNNR
25	JVPO1	RPROJK	PRPS	PSPNR
26	JVPO1	RRECIN	T8JJ	RECID
27	JVPO1	RTCUR	TCURC	WAERS
28	JVPO1	RUNIT	T006	MSEHI
29	JVPO1	RVERS	T894	RVERS

History

Last changed by/on	SAP	20130529
SAP Release Created in