SAP JVA_BROWSER Table in S/4 HANA - JV line items
JVA_BROWSER is a standard SAP Table which is used to store JV line items data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP JVA_BROWSER table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: JVA_BROWSER
JVA_BROWSER table structure field list
Below is the full JVA_BROWSER field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
RCLNT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18(0) | OBJNR | OBN | ||||
RLDNR | Ledger | RLDNR | CHAR | 2(0) | T881 | ALPHA | RLDNR | GLN | H_T881 | RLDNR |
RRCTY | Record Type | RRCTY | CHAR | 1(0) | RRCTY | |||||
RVERS | Version | RVERS | CHAR | 3(0) | T894 | ALPHA | RVERS | GVS | ||
RYEAR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
RTCUR | Currency Key | RTCUR | CUKY | 5(0) | TCURC | WAERS | FWS | |||
RUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 1(0) | SHKZG | |||||
POPER | Posting period | POPER | NUMC | 3(0) | POPER | POPR | ||||
DOCCT | Document Category | DOCCT | CHAR | 1(0) | DOCCT | GCT | ||||
DOCNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
DOCLN | Line Item in Joint Venture Document | JV_DOCLN | NUMC | 3(0) | BUZEI | |||||
RBUKRS | Company Code | BUKRS | CHAR | 4(0) | T001 | BUKRS | BUK | C_T001 | BUKRS | |
RJVNAM | Joint venture | JV_NAME | CHAR | 6(0) | T8JV | ALPHA | JV_NAME | JVV | ||
REGROU | Equity group | JV_EGROUP | CHAR | 3(0) | T8JF | ALPHA | JV_EGROUP | GJE | ||
RACCT | Account Number | RACCT | CHAR | 10(0) | SKA1 | ALPHA | SAKNR | ACC | ||
RBUSA | Business Area | GSBER | CHAR | 4(0) | TGSB | GSBER | GSB | |||
RKOKRS | Controlling Area | KOKRS | CHAR | 4(0) | TKA01 | CACCD | CAC | |||
RCNTR | Cost Center | KOSTL | CHAR | 10(0) | CSKS | ALPHA | KOSTL | KOS | ||
RORDNR | Order Number | AUFNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | ANR | ||
RPROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | PRPS | ABPSP | PS_POSNR | |||
RPRCTR | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
RANLN1 | Main Asset Number | ANLN1 | CHAR | 12(0) | ANLH | ALPHA | ANLN1 | AN1 | ||
RANLN2 | Asset Subnumber | ANLN2 | CHAR | 4(0) | ANLA | ALPHA | ANLN2 | AN2 | ||
RANBWA | Asset Transaction Type | ANBWA | CHAR | 3(0) | TABW | BWASL | ||||
RRECIN | Recovery Indicator | JV_RECIND | CHAR | 2(0) | T8JJ | ALPHA | JV_RECIND | |||
RPARTN | Partner account number | JV_PART | CHAR | 10(0) | KNA1 | ALPHA | KUNNR | |||
RDPOM | Posting Period Difference for Operational Month | JV_DPOM | CHAR | 4(0) | CHAR4 | |||||
RDBILLM | Invoice Month: Posting Period Difference | JV_DBILLM | CHAR | 4(0) | CHAR4 | |||||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12(0) | AUFK | ALPHA | AUFNR | NET | ||
AUFPL | Task List Number for Operations in Order | AUFPL_CH | NUMC | 10(0) | AUFPL | |||||
APLZL | General Counter for Order | APLZL_CH | NUMC | 8(0) | Assigned to domain | CO_APLZL | ||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4(0) | NUMCV | VORNR | VGN | |||
TSL | Value in Transaction Currency | VTCUR9_CS | CURR | 17(2) | WERTV9 | |||||
HSL | Value in local currency | VLCUR9_CS | CURR | 17(2) | WERTV9 | |||||
KSL | Value in group currency | VGCUR9_CS | CURR | 17(2) | WERTV9 | |||||
MSL | Quantity | QUAN1 | QUAN | 15(3) | MENG8 | |||||
AUNIT | Additional unit of measure | AUNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
SGTXT | Item Text | SGTXT | CHAR | 50(0) | TEXT50 | |||||
AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR | 1(0) | TEXT1 | |||||
DOCTY | Document type | BLART | CHAR | 2(0) | T003 | BLART | BAR | |||
ACTIV | Business Transaction | GLVOR | CHAR | 4(0) | CHAR4 | |||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8(0) | DATUM | |||||
WSDAT | Value Date for Currency Translation | WSDAT | DATS | 8(0) | DATUM | WSD | ||||
VALUT | Value date | VALUT | DATS | 8(0) | DATUM | |||||
REFDOCNR | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
REFRYEAR | Fiscal Year | GJAHR | NUMC | 4(0) | GJAHR | GJAHR | GJR | |||
REFDOCLN | Line Item in Joint Venture Reference Doc | JV_REFDLN | NUMC | 5(0) | NUMC5 | |||||
REFDOCCT | Document Category | DOCCT | CHAR | 1(0) | DOCCT | GCT | ||||
REFACTIV | Business Transaction | GLVOR | CHAR | 4(0) | CHAR4 | |||||
REFFIDLN | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3(0) | BUZEI | BUZ | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8(0) | DATUM | |||||
CPUTM | Time of Entry | CPUTM | TIMS | 6(0) | UZEIT | |||||
USNAM | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
BLDAT | Document Date in Document | BLDAT | DATS | 8(0) | DATUM | |||||
BILID | Payroll Type | JV_BILIND | CHAR | 2(0) | T8JA | ALPHA | JV_BILIND | |||
ORECID | Original Recovery Indicator | JV_ORECID | CHAR | 2(0) | T8JJ | ALPHA | JV_RECIND | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2(0) | T007A | MWSKZ | ||||
BILLM | Billing Month | JV_BILLM | DATS | 8(0) | DATUM | |||||
POM | Processing operational month | JV_POM | DATS | 8(0) | DATUM | |||||
CBPERIOD | JV Cutback Period | JV_CBPERI | NUMC | 3(0) | POPER | |||||
EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EKPO | EBELP | BSP | |||
KTOSL | Transaction Key | KTOSL | CHAR | 3(0) | CHAR3 | |||||
MMACT | JVA MM Activity Type | JV_MM_ACT | CHAR | 1(0) | JV_MM_ACT | |||||
LSTAR | Activity Type | LSTAR | CHAR | 6(0) | CSLA | LSTAR | LAR | LART_EMPTY | LSTAR | |
CYCLE | Allocation/cycle | CYCLE | CHAR | 10(0) | CYCLE | GCY | ||||
SDATE | Start Date | SDATE | DATS | 8(0) | SDATE | GAS | ||||
SEQNR | Segment Number Within a Cycle | SQNR | NUMC | 4(0) | T811S | SQNR | ||||
SEQNAME | Name of a Segment in Assessment/Distribution | SEQNAME | CHAR | 10(0) | SEQNAME | FSR | ||||
REFCYC | Reference Field for Allocation Cycle | JV_REFCYC | CHAR | 10(0) | TEXT10 | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
CONDI | Joint Venture Indicator (Condition Key) | JV_CONDCOD | CHAR | 2(0) | T8JX | ALPHA | JV_CONDCOD | |||
AWTYP | Reference procedure | AWTYP | CHAR | 5(0) | TTYP | AWTYP | ||||
AWORG | Reference Organizational Units | AWORG | CHAR | 10(0) | AWORG | |||||
LOGSYS | Logical system | LOGSYS | CHAR | 10(0) | TBDLS | ALPHA | LOGSYS | |||
REFAWTYP | Reference procedure | AWTYP | CHAR | 5(0) | TTYP | AWTYP | ||||
REFAWREF | Reference document number | AWREF | CHAR | 10(0) | ALPHA | AWREF | ||||
REFAWORG | Reference Organizational Units | AWORG | CHAR | 10(0) | AWORG | |||||
REFLOGSYS | Logical system | LOGSYS | CHAR | 10(0) | TBDLS | ALPHA | LOGSYS | |||
PRODPER | Production Month (Date to find period and year) | JV_PRODPER | DATS | 8(0) | JV_PRODPER | |||||
.INCLU--AP | 0(0) | |||||||||
REFFIDOC | Accounting Document Number | BELNR_D | CHAR | 10(0) | ALPHA | BELNR | BLN | |||
CBCUSTOMER | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
CBVENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
CBPAYTERM | Terms of payment key | DZTERM | CHAR | 4(0) | ZTERM | |||||
XSBL | Flag: Line is Split Basis Line | JV_XSBLINE | CHAR | 1(0) | XFELD | |||||
SBREFLN | Reference Split Basis Line Number | JV_SBREFLN | NUMC | 5(0) | JV_SBREFLN | |||||
JOA | Joint Operating Agreement | JV_JOA | CHAR | 6(0) | Assigned to domain | ALPHA | JV_JOA | JVJ | ||
PER1 | Percent 1 (% Producing U.S., % Regular Canada) (JVA) | JV_PER1 | DEC | 5(2) | DEC3_2 | |||||
PER2 | Percent 2 (% Development U.S., % Special Canada) (JVA) | JV_PER2 | DEC | 5(2) | DEC3_2 | |||||
HSL_1 | JV Local amount 1 | JV_HSL_1 | CURR | 17(2) | WERTV9 | |||||
CURR1 | JV Local currency 1 | JV_CURR1 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
CURT1 | JV Currency type 1 | JV_CURT1 | CHAR | 2(0) | CURRTYP | |||||
KSL_1 | JV Local amount 2 | JV_KSL_1 | CURR | 17(2) | WERTV9 | |||||
CURR2 | JV Local currency 2 | JV_CURR2 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
CURT2 | JV Currency type 2 | JV_CURT2 | CHAR | 2(0) | CURRTYP | |||||
HSL_2 | JV Local amount 3 | JV_HSL_2 | CURR | 17(2) | WERTV9 | |||||
CURR3 | JV Local currency 3 | JV_CURR3 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
CURT3 | JV Currency type 3 | JV_CURT3 | CHAR | 2(0) | CURRTYP | |||||
KSL_2 | JV Local amount 4 | JV_KSL_2 | CURR | 17(2) | WERTV9 | |||||
CURR4 | JV Local currency 4 | JV_CURR4 | CUKY | 5(0) | Assigned to domain | WAERS | ||||
CURT4 | JV Currency type 4 | JV_CURT4 | CHAR | 2(0) | CURRTYP | |||||
FSL | Funding Currency Amount | JV_FCVAL | CURR | 17(2) | WERTV9 | |||||
FCURR | Funding currency | JV_FCURR | CUKY | 5(0) | Assigned to domain | WAERS | FWS | |||
FCURT | Currency Type | CURRTYP | CHAR | 2(0) | CURRTYP | |||||
OBJ_TYPE | JV cost object type | JV_OBJ_TYPE | CHAR | 3(0) | CHAR03 | |||||
OBJ_ID | JV Cost object identifier | JV_OBJ_ID | CHAR | 24(0) | CHAR24 | |||||
OBJ_NAME | JV Cost object name | JV_OBJ_NAME | CHAR | 30(0) | CHAR30 | |||||
ICON_BILLABLE | Icon - JV item is billable | JV_ICON_BILLABLE | CHAR | 4(0) | Assigned to domain | ICON | ||||
ICON_SUSPENSE | Icon - JV item suspense status | JV_ICON_SUSPENSE | CHAR | 4(0) | Assigned to domain | ICON | ||||
ICON_DRCRK | Icon - JV item debit or credit | JV_ICON_DRCRK | CHAR | 4(0) | Assigned to domain | ICON | ||||
ITEM_SEL | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
DBCNT | Processed Database Table Rows | SYDBCNT | INT4 | 10(0) | SYST_LONG |
Search for further information about these or an SAP related objects