SAP ABAP Table JVSO1 (JV LI Table with Objects for JVTO1)

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	JVSO1	Table Relationship Diagram
Short Description	JV LI Table with Objects for JVTO1

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	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
11	DOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
12	DOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document 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	SKA1
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	CSKS
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	TSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
36	HSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
37	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
38	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
39	AUNIT	☐	AUNIT	MEINS	UNIT	3	0	Additional unit of measure	T006
40	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
41	AUTOM	☐	AUTOM	TEXT1	CHAR	1	0	Indicator: Automatic posting lines
42	DOCTY	☐	BLART	BLART	CHAR	2	0	Document type	T003
43	ACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
44	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
45	WSDAT	☐	WSDAT	DATUM	DATS	8	0	Value Date for Currency Translation
46	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
47	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
48	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
49	REFDOCLN	☐	JV_REFDLN	NUMC5	NUMC	5	0	Line Item in Joint Venture Reference Doc
50	REFDOCCT	☐	DOCCT	DOCCT	CHAR	1	0	Document Type
51	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
52	REFFIDLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
53	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
54	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
55	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
56	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
57	BILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
58	ORECID	☐	JV_ORECID	JV_RECIND	CHAR	2	0	Original Recovery Indicator	T8JJ
59	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
60	BILLM	☐	JV_BILLM	DATUM	DATS	8	0	Billing Month
61	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month
62	CBPERIOD	☐	JV_CBPERI	POPER	NUMC	3	0	JV Cutback Period
63	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
64	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
65	KTOSL	☐	KTOSL	CHAR3	CHAR	3	0	Transaction Key
66	MMACT	☐	JV_MM_ACT	JV_MM_ACT	CHAR	1	0	JVA MM Activity Type
67	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
68	CYCLE	☐	CYCLE	CYCLE	CHAR	10	0	Allocation/cycle
69	SDATE	☐	SDATE	SDATE	DATS	8	0	Start Date	*
70	SEQNR	☐	SQNR	SQNR	NUMC	4	0	Segment number within a cycle	T811S
71	SEQNAME	☐	SEQNAME	SEQNAME	CHAR	10	0	Name of a segment in assessment/distribution
72	REFCYC	☐	JV_REFCYC	TEXT10	CHAR	10	0	Reference Field for Allocation Cycle
73	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
74	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	T8JX
75	AWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
76	AWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
77	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
78	REFAWTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	TTYP
79	REFAWREF	☐	AWREF	AWREF	CHAR	10	0	Reference document number
80	REFAWORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
81	REFLOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
82	PRODPER	☐	JV_PRODPER	JV_PRODPER	DATS	8	0	Production Month (Date to find period and year)
83	.INCLU--AP	☐				0	0	Additional Fields Required by Joint Venture Accounting
84	REFFIDOC	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
85	CBCUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
86	CBVENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
87	CBPAYTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
88	XSBL	☐	JV_XSBLINE	XFELD	CHAR	1	0	Flag: Line is Split Basis Line
89	SBREFLN	☐	JV_SBREFLN	JV_SBREFLN	NUMC	5	0	Reference Split Basis Line Number

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in