1. Home
  2. Resources
  3. SAP Tables
  4. JVSO1 - JV LI Table with Objects for JVTO1

SAP Table JVSO1

JV LI Table with Objects for JVTO1

JVSO1 (JV LI Table with Objects for JVTO1) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JVSO1 to other SAP tables.

JVSO1 table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
GL_SIRID Record number of the line item record GU_RECID CHAR 18 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS T894 CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
RUNIT Base Unit of Measure MEINS T006 UNIT 3 0
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
POPER Posting period POPER NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Line Item in Joint Venture Document JV_DOCLN NUMC 3 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
RJVNAM Joint Venture JV_NAME T8JV CHAR 6 0
REGROU Equity group JV_EGROUP T8JF CHAR 3 0
RACCT Account Number RACCT SKA1 CHAR 10 0
RBUSA Business Area GSBER TGSB CHAR 4 0
RKOKRS Controlling Area KOKRS TKA01 CHAR 4 0
RCNTR Cost Center KOSTL CSKS CHAR 10 0
RORDNR Order Number AUFNR AUFK CHAR 12 0
RPROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
RPRCTR Profit Center PRCTR CHAR 10 0
RANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
RANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
RANBWA Asset Transaction Type ANBWA TABW CHAR 3 0
RRECIN Recovery Indicator JV_RECIND T8JJ CHAR 2 0
RPARTN Partner account number JV_PART KNA1 CHAR 10 0
RDPOM Posting Period Difference for Operational Month JV_DPOM CHAR 4 0
RDBILLM Invoice Month: Posting Period Difference JV_DBILLM CHAR 4 0
NPLNR Network Number for Account Assignment NPLNR AUFK CHAR 12 0
AUFPL Task list number for operations in order AUFPL_CH NUMC 10 0
APLZL General counter for order APLZL_CH NUMC 8 0
VORNR Operation/Activity Number VORNR CHAR 4 0
TSL Value in Transaction Currency VTCUR9 CURR 17 2
HSL Value in local currency VLCUR9 CURR 17 2
KSL Value in group currency VGCUR9 CURR 17 2
MSL Quantity QUAN1 QUAN 15 3
AUNIT Additional unit of measure AUNIT T006 UNIT 3 0
SGTXT Item Text SGTXT CHAR 50 0
AUTOM Indicator: Automatic posting lines AUTOM CHAR 1 0
DOCTY Document Type BLART T003 CHAR 2 0
ACTIV Business Transaction GLVOR CHAR 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WSDAT Value Date for Currency Translation WSDAT DATS 8 0
VALUT Value date VALUT DATS 8 0
REFDOCNR Accounting Document Number BELNR_D CHAR 10 0
REFRYEAR Fiscal Year GJAHR NUMC 4 0
REFDOCLN Line Item in Joint Venture Reference Doc JV_REFDLN NUMC 5 0
REFDOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction GLVOR CHAR 4 0
REFFIDLN Number of Line Item Within Accounting Document BUZEI NUMC 3 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
BLDAT Document Date in Document BLDAT DATS 8 0
BILID Payroll Type JV_BILIND T8JA CHAR 2 0
ORECID Original Recovery Indicator JV_ORECID T8JJ CHAR 2 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
BILLM Billing Month JV_BILLM DATS 8 0
POM Processing operational month JV_POM DATS 8 0
CBPERIOD JV Cutback Period JV_CBPERI NUMC 3 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
KTOSL Transaction Key KTOSL CHAR 3 0
MMACT JVA MM Activity Type JV_MM_ACT CHAR 1 0
1 Goods Receipt or Return to Vendor
2 Invoice Receipt
3 Credit Memo
4 Subsequent Invoice
5 Subsequent Credit Memo
6 GR/IR Maintenance
A Freight clearing invoice
B Freight provisions invoice
C Customs clearing invoice
D Purchasing freight account invoice
E Neutral provisions invoice
LSTAR Activity Type LSTAR CSLA CHAR 6 0
CYCLE Allocation/cycle CYCLE CHAR 10 0
SDATE Start Date SDATE DATS 8 0
SEQNR Segment number within a cycle SQNR T811S NUMC 4 0
SEQNAME Name of a segment in assessment/distribution SEQNAME CHAR 10 0
REFCYC Reference Field for Allocation Cycle JV_REFCYC CHAR 10 0
MATNR Material Number MATNR MARA CHAR 18 0
CONDI Joint Venture Indicator (Condition Key) JV_CONDCOD T8JX CHAR 2 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
REFAWTYP Reference Transaction AWTYP TTYP CHAR 5 0
REFAWREF Reference Document Number AWREF CHAR 10 0
REFAWORG Reference Organizational Units AWORG CHAR 10 0
REFLOGSYS Logical system LOGSYS TBDLS CHAR 10 0
PRODPER Production Month (Date to find period and year) JV_PRODPER DATS 8 0
REFFIDOC Accounting Document Number BELNR_D CHAR 10 0
CBCUSTOMER Customer Number KUNNR CHAR 10 0
CBVENDOR Account Number of Vendor or Creditor LIFNR CHAR 10 0
CBPAYTERM Terms of Payment Key DZTERM CHAR 4 0
XSBL Flag: Line is Split Basis Line JV_XSBLINE CHAR 1 0
X Yes
NULL No
SBREFLN Reference Split Basis Line Number JV_SBREFLN NUMC 5 0

JVSO1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JVSO1 AUNIT JVSO1 RCLNT T006 Units of Measurement MANDT
JVSO1 AUNIT JVSO1 AUNIT T006 Units of Measurement MSEHI
JVSO1 AWTYP JVSO1 AWTYP TTYP Object Types for Accounting AWTYP
JVSO1 BILID JVSO1 BILID T8JA Payroll Type BILIND
JVSO1 BILID JVSO1 RCLNT T8JA Payroll Type MANDT
JVSO1 CONDI JVSO1 CONDI T8JX JV Conditional Code CONDCODE
JVSO1 CONDI JVSO1 RCLNT T8JX JV Conditional Code MANDT
JVSO1 CONDI JVSO1 RBUKRS T8JX JV Conditional Code BUKRS
JVSO1 DOCTY JVSO1 RCLNT T003 Document Types MANDT
JVSO1 DOCTY JVSO1 DOCTY T003 Document Types BLART
JVSO1 EBELN JVSO1 RCLNT EKKO Purchasing Document Header MANDT
JVSO1 EBELN JVSO1 EBELN EKKO Purchasing Document Header EBELN
JVSO1 EBELP JVSO1 RCLNT EKPO Purchasing Document Item MANDT
JVSO1 EBELP JVSO1 EBELN EKPO Purchasing Document Item EBELN
JVSO1 EBELP JVSO1 EBELP EKPO Purchasing Document Item EBELP
JVSO1 LOGSYS JVSO1 LOGSYS TBDLS Logical system LOGSYS
JVSO1 LSTAR JVSO1 RCLNT CSLA Activity master MANDT
JVSO1 LSTAR JVSO1 RKOKRS CSLA Activity master KOKRS
JVSO1 LSTAR JVSO1 LSTAR CSLA Activity master LSTAR
JVSO1 LSTAR JVSO1 BUDAT CSLA Activity master DATBI
JVSO1 MATNR JVSO1 RCLNT MARA General Material Data MANDT
JVSO1 MATNR JVSO1 MATNR MARA General Material Data MATNR
JVSO1 MWSKZ JVSO1 RCLNT T007A Tax Keys MANDT
JVSO1 MWSKZ * T007A Tax Keys KALSM
JVSO1 MWSKZ JVSO1 MWSKZ T007A Tax Keys MWSKZ
JVSO1 NPLNR JVSO1 NPLNR AUFK Order master data AUFNR
JVSO1 NPLNR JVSO1 RCLNT AUFK Order master data MANDT
JVSO1 ORECID JVSO1 RBUKRS T8JJ Recovery Indicator BUKRS
JVSO1 ORECID JVSO1 ORECID T8JJ Recovery Indicator RECID
JVSO1 ORECID JVSO1 RCLNT T8JJ Recovery Indicator MANDT
JVSO1 RACCT JVSO1 RCLNT SKA1 G/L Account Master (Chart of Accounts) MANDT
JVSO1 RACCT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
JVSO1 RACCT JVSO1 RACCT SKA1 G/L Account Master (Chart of Accounts) SAKNR
JVSO1 RANBWA JVSO1 RCLNT TABW Asset transaction types MANDT
JVSO1 RANBWA JVSO1 RANBWA TABW Asset transaction types BWASL
JVSO1 RANLN1 JVSO1 RCLNT ANLH Main asset number MANDT
JVSO1 RANLN1 JVSO1 RBUKRS ANLH Main asset number BUKRS
JVSO1 RANLN1 JVSO1 RANLN1 ANLH Main asset number ANLN1
JVSO1 RANLN2 JVSO1 RANLN2 ANLA Asset Master Record Segment ANLN2
JVSO1 RANLN2 JVSO1 RCLNT ANLA Asset Master Record Segment MANDT
JVSO1 RANLN2 JVSO1 RBUKRS ANLA Asset Master Record Segment BUKRS
JVSO1 RANLN2 JVSO1 RANLN1 ANLA Asset Master Record Segment ANLN1
JVSO1 RBUKRS JVSO1 RBUKRS T001 Company Codes BUKRS
JVSO1 RBUKRS JVSO1 RCLNT T001 Company Codes MANDT
JVSO1 RBUSA JVSO1 RCLNT TGSB Business Areas MANDT
JVSO1 RBUSA JVSO1 RBUSA TGSB Business Areas GSBER
JVSO1 RCLNT JVSO1 RCLNT T000 Clients MANDT
JVSO1 RCNTR JVSO1 BUDAT CSKS Cost Center Master Data DATBI
JVSO1 RCNTR JVSO1 RCLNT CSKS Cost Center Master Data MANDT
JVSO1 RCNTR JVSO1 RKOKRS CSKS Cost Center Master Data KOKRS
JVSO1 RCNTR JVSO1 RCNTR CSKS Cost Center Master Data KOSTL
JVSO1 REFAWTYP JVSO1 REFAWTYP TTYP Object Types for Accounting AWTYP
JVSO1 REFLOGSYS JVSO1 REFLOGSYS TBDLS Logical system LOGSYS
JVSO1 REGROU JVSO1 RCLNT T8JF Investment Group MANDT
JVSO1 REGROU JVSO1 RBUKRS T8JF Investment Group BUKRS
JVSO1 REGROU JVSO1 RJVNAM T8JF Investment Group VNAME
JVSO1 REGROU JVSO1 REGROU T8JF Investment Group EGRUP
JVSO1 RJVNAM JVSO1 RCLNT T8JV Joint Venture MANDT
JVSO1 RJVNAM JVSO1 RBUKRS T8JV Joint Venture BUKRS
JVSO1 RJVNAM JVSO1 RJVNAM T8JV Joint Venture VNAME
JVSO1 RKOKRS JVSO1 RCLNT TKA01 Controlling Areas MANDT
JVSO1 RKOKRS JVSO1 RKOKRS TKA01 Controlling Areas KOKRS
JVSO1 RLDNR JVSO1 RLDNR T881 Ledger Master RLDNR
JVSO1 RLDNR JVSO1 RCLNT T881 Ledger Master MANDT
JVSO1 RORDNR JVSO1 RCLNT AUFK Order master data MANDT
JVSO1 RORDNR JVSO1 RORDNR AUFK Order master data AUFNR
JVSO1 RPARTN JVSO1 RCLNT KNA1 General Data in Customer Master MANDT
JVSO1 RPARTN JVSO1 RPARTN KNA1 General Data in Customer Master KUNNR
JVSO1 RPROJK JVSO1 RCLNT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
JVSO1 RPROJK JVSO1 RPROJK PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
JVSO1 RRECIN JVSO1 RCLNT T8JJ Recovery Indicator MANDT
JVSO1 RRECIN JVSO1 RBUKRS T8JJ Recovery Indicator BUKRS
JVSO1 RRECIN JVSO1 RRECIN T8JJ Recovery Indicator RECID
JVSO1 RTCUR JVSO1 RTCUR TCURC Currency Codes WAERS
JVSO1 RTCUR JVSO1 RCLNT TCURC Currency Codes MANDT
JVSO1 RUNIT JVSO1 RCLNT T006 Units of Measurement MANDT
JVSO1 RUNIT JVSO1 RUNIT T006 Units of Measurement MSEHI
JVSO1 RVERS JVSO1 RCLNT T894 FI-SL and FI-LC Versions MANDT
JVSO1 RVERS JVSO1 RLDNR T894 FI-SL and FI-LC Versions RLDNR
JVSO1 RVERS JVSO1 RVERS T894 FI-SL and FI-LC Versions RVERS
JVSO1 SEQNR * T811S Allocations: Segments TAB
JVSO1 SEQNR JVSO1 CYCLE T811S Allocations: Segments CYCLE
JVSO1 SEQNR * T811S Allocations: Segments SDATE
JVSO1 SEQNR JVSO1 SEQNR T811S Allocations: Segments SEQNR
JVSO1 SEQNR JVSO1 RCLNT T811S Allocations: Segments MANDT