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

SAP table JVSO1 has 2 primary key fields being RCLNT,GL_SIRID.

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

JVSO1 foreign key relationships

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