SAP ABAP Table JVAP (Joint venture item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GBAS (Package) FI-SL Customizing / integration / Basis

Basic Data

Table Category	INTTAB	Structure
Structure	JVAP	Table Relationship Diagram
Short Description	Joint venture item

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	JV LI Table with Objects for JVTO1
2	RCLNT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	GL_SIRID	☐	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
4	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	T881
5	RRCTY	☐	RRCTY	RRCTY	CHAR	1	0	Record Type
6	RVERS	☐	RVERS	RVERS	CHAR	3	0	Version	T894
7	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
9	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
10	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
11	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
12	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
13	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
14	DOCLN	☐	JV_DOCLN	BUZEI	NUMC	3	0	Line Item in Joint Venture Document
15	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
16	RJVNAM	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
17	REGROU	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
18	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKA1
19	RBUSA	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
20	RKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
21	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
22	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
23	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
24	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
25	RANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
26	RANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
27	RANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
28	RRECIN	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	T8JJ
29	RPARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
30	RDPOM	☐	JV_DPOM	CHAR4	CHAR	4	0	Posting Period Difference for Operational Month
31	RDBILLM	☐	JV_DBILLM	CHAR4	CHAR	4	0	Invoice Month: Posting Period Difference
32	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
33	AUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
34	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
35	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
36	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
37	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
38	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
39	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
40	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
41	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
42	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
43	DOCTY	☐	BLART	BLART	CHAR	2	0	Document type	T003
44	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
45	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
46	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
47	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
48	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
49	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
50	REFDOCLN	☐	JV_REFDLN	NUMC5	NUMC	5	0	Line Item in Joint Venture Reference Doc
51	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
52	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
53	REFFIDLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
54	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
55	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
56	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
57	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
58	BILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
59	ORECID	☐	JV_ORECID	JV_RECIND	CHAR	2	0	Original Recovery Indicator	T8JJ
60	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
61	BILLM	☐	JV_BILLM	DATUM	DATS	8	0	Billing Month
62	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month
63	CBPERIOD	☐	JV_CBPERI	POPER	NUMC	3	0	JV Cutback Period
64	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
65	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
66	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
67	MMACT	☐	JV_MM_ACT	JV_MM_ACT	CHAR	1	0	JVA MM Activity Type
68	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
69	CYCLE	☐	CYCLE	CYCLE	CHAR	10	0	Allocation/cycle
70	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
71	SEQNR	☐	SQNR	SQNR	NUMC	4	0	Segment number within a cycle	T811S
72	SEQNAME	☐	SEQNAME	SEQNAME	CHAR	10	0	Name of a segment in assessment/distribution
73	REFCYC	☐	JV_REFCYC	TEXT10	CHAR	10	0	Reference Field for Allocation Cycle
74	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
75	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	T8JX
76	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
77	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
78	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
79	REFAWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
80	REFAWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
81	REFAWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
82	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
83	PRODPER	☐	JV_PRODPER	JV_PRODPER	DATS	8	0	Production Month (Date to find period and year)
84	.INCLU--AP	☐				0	0	Additional Fields Required by Joint Venture Accounting
85	REFFIDOC	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
86	CBCUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
87	CBVENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
88	CBPAYTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
89	XSBL	☐	JV_XSBLINE	XFELD	CHAR	1	0	Flag: Line is Split Basis Line
90	SBREFLN	☐	JV_SBREFLN	JV_SBREFLN	NUMC	5	0	Reference Split Basis Line Number
91	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
92	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
93	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
94	TABIX	☐	NUM10	NUM10	NUMC	10	0	10 digit number
95	CURT1	☐	CURT1	CURTP	CHAR	2	0	Currency type of the first local currency
96	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
97	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
98	CURT4	☐	CURT4	CURTP	CHAR	2	0	Currency type of the fourth local currency
99	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
100	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	TCURC
101	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	TCURC
102	HWAE4	☐	HWAE4	WAERS	CUKY	5	0	Currency key of the fourth local currency	*
103	DMBE2	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
104	DMBE3	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
105	DMBE4	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
106	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
107	PSWBT	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
108	ABPER	☐	ABPER_RF	BUPER	ACCP	6	0	Settlement period
109	.INCLU--AP	☐				0	0	JV Append for JVAP - additional items
110	LINE_SRC	☐	JVAP_LINE_SRC	CHAR3	CHAR	3	0	Line Source
111	RND_DIFF_SIGN	☐	JVAP_RND_DIFF_SIGN	CHAR1	CHAR	1	0	JVA Position - sign of rounding differences

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JVAP	AUNIT	T006	MSEHI
2	JVAP	AWTYP	TTYP	AWTYP	REF	1	CN
3	JVAP	BILID	T8JA	BILIND	REF	C	CN
4	JVAP	CONDI	T8JX	CONDCODE	REF	1	CN
5	JVAP	DOCTY	T003	BLART
6	JVAP	EBELN	EKKO	EBELN	REF	C	CN
7	JVAP	EBELP	EKPO	EBELP	REF	C	CN
8	JVAP	HWAE2	TCURC	WAERS
9	JVAP	HWAE3	TCURC	WAERS
10	JVAP	HWAER	TCURC	WAERS
11	JVAP	KUNNR	KNA1	KUNNR
12	JVAP	LIFNR	LFA1	LIFNR
13	JVAP	LOGSYS	TBDLS	LOGSYS		1	CN
14	JVAP	LSTAR	CSLA	LSTAR
15	JVAP	MATNR	MARA	MATNR	REF	1	CN
16	JVAP	MWSKZ	T007A	MWSKZ	REF	C	CN
17	JVAP	NPLNR	AUFK	AUFNR	REF	1	CN
18	JVAP	ORECID	T8JJ	RECID	REF	C	CN
19	JVAP	PSWSL	TCURC	WAERS
20	JVAP	RACCT	SKA1	SAKNR	REF	C	CN
21	JVAP	RANBWA	TABW	BWASL	REF	C	CN
22	JVAP	RANLN1	ANLH	ANLN1	REF	C	CN
23	JVAP	RANLN2	ANLA	ANLN2	REF	C	CN
24	JVAP	RBUKRS	T001	BUKRS
25	JVAP	RBUSA	TGSB	GSBER	REF	C	CN
26	JVAP	RCLNT	T000	MANDT
27	JVAP	RCNTR	CSKS	KOSTL
28	JVAP	REFAWTYP	TTYP	AWTYP		1	CN
29	JVAP	REFLOGSYS	TBDLS	LOGSYS	REF	1	CN
30	JVAP	REGROU	T8JF	EGRUP
31	JVAP	RJVNAM	T8JV	VNAME	REF	C	CN
32	JVAP	RKOKRS	TKA01	KOKRS
33	JVAP	RLDNR	T881	RLDNR
34	JVAP	RORDNR	AUFK	AUFNR
35	JVAP	RPARTN	KNA1	KUNNR
36	JVAP	RPROJK	PRPS	PSPNR
37	JVAP	RRECIN	T8JJ	RECID
38	JVAP	RTCUR	TCURC	WAERS
39	JVAP	RUNIT	T006	MSEHI
40	JVAP	RVERS	T894	RVERS
41	JVAP	SEQNR	T811S	SEQNR	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in