1. Home
  2. Resources
  3. SAP Tables
  4. JVAP - Joint venture item

SAP Table JVAP

Joint venture item

JVAP (Joint venture item) 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 JVAP to other SAP tables.

JVAP 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
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
BUZID Identification of the Line Item BUZID CHAR 1 0
TABIX 10 digit number NUM10 NUMC 10 0
CURT1 Currency type of the first local currency CURT1 CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURT2 Currency Type of Second Local Currency CURT2 CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURT3 Currency Type of Third Local Currency CURT3 CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
CURT4 Currency type of the fourth local currency CURT4 CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
HWAER Local Currency HWAER TCURC CUKY 5 0
HWAE2 Currency Key of Second Local Currency HWAE2 TCURC CUKY 5 0
HWAE3 Currency Key of Third Local Currency HWAE3 TCURC CUKY 5 0
HWAE4 Currency key of the fourth local currency HWAE4 CUKY 5 0
DMBE2 Value in local currency VLCUR9 CURR 17 2
DMBE3 Value in local currency VLCUR9 CURR 17 2
DMBE4 Value in local currency VLCUR9 CURR 17 2
PSWSL Update Currency for General Ledger Transaction Figures PSWSL TCURC CUKY 5 0
PSWBT Value in local currency VLCUR9 CURR 17 2
ABPER Settlement period ABPER_RF ACCP 6 0
LINE_SRC Line Source JVAP_LINE_SRC CHAR 3 0
RND_DIFF_SIGN JVA Position - sign of rounding differences JVAP_RND_DIFF_SIGN CHAR 1 0

JVAP foreign key relationships

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