JVB03 - JV Billing Extract: Expenditure Detail Rpt
JV Billing Extract: Expenditure Detail Rpt information is stored in SAP table JVB03.
It is part of development package GJVA_BILLING in software component CA-JVA-JVA. This development package consists of objects that can be grouped under "Billing functionality for Joint Venture Accounting".
It is part of development package GJVA_BILLING in software component CA-JVA-JVA. This development package consists of objects that can be grouped under "Billing functionality for Joint Venture Accounting".
Fields for table JVB03
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| RCLNT | Client | X | MANDT | CLNT | 6 | |
| ID | 16 byte UUID in 36 chars according to RFC4122 | X | SYSUUID_C36 | CHAR | 72 | JVB00 |
| RYEAR | General Ledger Fiscal Year | X | GJAHR_POS | NUMC | 8 | |
| POPER | Posting period | X | POPER | NUMC | 6 | |
| VPTNR | Partner account number | X | JV_PART | CHAR | 20 | KNA1 |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | X | PS_PSP_PNR | NUMC | 16 | |
| PRODPER | Production Month (Date to find period and year) | X | JV_PRODPER | DATS | 16 | |
| RBUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| RCNTR | Cost Center | X | KOSTL | CHAR | 20 | |
| RORDNR | Order Number | X | AUFNR | CHAR | 24 | |
| NPLNR | Network Number for Account Assignment | X | NPLNR | CHAR | 24 | |
| NPLNR_VORGN | Network activity | X | NPVRG | CHAR | 8 | |
| EGRUP | Equity group | X | JV_EGROUP | CHAR | 6 | T8JF |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | T8JV |
| FUNDING_CURRENCY | Funding currency | X | JV_FUNDCUR | CUKY | 10 | TCURC |
| RACCT | Account Number | X | RACCT | CHAR | 20 | SKA1 |
| SDS_CO | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| ORSDS_CO | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| PROJ_SDS | JV Project | JV_PROJ | NUMC | 16 | ||
| PROJ_SUP | JV Project | JV_PROJ | NUMC | 16 | ||
| ORDER_SDS | Order Number | AUFNR | CHAR | 24 | ||
| BILLCODE | JV Billing code | JV_BILLCO | CHAR | 6 | ||
| SDS_ACC | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| ORSDS_ACC | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| ACC_SDS | Account Number | RACCT | CHAR | 20 | ||
| SDS_RI | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| ORSDS_RI | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| RI_SDS | Recovery Indicator | JV_RECIND | CHAR | 4 | ||
| TANGIND | JV Tangible/Intangible Indicator | JV_TANGI | CHAR | 2 | ||
| AFEIND | JV AFE Indicator | JV_AFEIND | CHAR | 2 | ||
| AFENUM | AFE (authorization for expenditure) | JV_AFENUM | CHAR | 44 | ||
| ETYPE | Equity type | JV_ETYPE | CHAR | 6 | ||
| JIBCL | JIB/JIBE Class | JV_JIBCL | CHAR | 6 | T8J6A | |
| JIBSA | JIB/JIBE Subclass A | JV_JIBSA | CHAR | 10 | T8J6C | |
| JIBSB | JV Subclass B | JV_JIBSB | CHAR | 48 | T8J6E | |
| CEIND | Indicator: Capital | JV_CEIND | CHAR | 2 | ||
| FCURR_PTD | Value field 12(23) characters with 2 decimal places | WERTV12 | CURR | 12 | ||
| FCURR_YTD | Value field 12(23) characters with 2 decimal places | WERTV12 | CURR | 12 | ||
| FCURR_ITD | Value field 12(23) characters with 2 decimal places | WERTV12 | CURR | 12 | ||
| RWCUR | Transaction Currency | FINS_CURRW | CUKY | 10 | TCURC | |
| WSL_PTD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| WSL_YTD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| WSL_ITD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| RHCUR | Company Code Currency | FINS_CURRH | CUKY | 10 | TCURC | |
| HSL_PTD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| HSL_YTD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| HSL_ITD | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
| RKCUR | Global Currency | FINS_CURRK | CUKY | 10 | TCURC | |
| KSL_PTD | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
| KSL_YTD | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
| KSL_ITD | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
| ROCUR | Freely Defined Currency 1 | FINS_CURR1 | CUKY | 10 | TCURC | |
| OSL_PTD | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR | 12 | ||
| OSL_YTD | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR | 12 | ||
| OSL_ITD | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR | 12 | ||
| RVCUR | Freely Defined Currency 2 | FINS_CURR2 | CUKY | 10 | TCURC | |
| VSL_PTD | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR | 12 | ||
| VSL_YTD | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR | 12 | ||
| VSL_ITD | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR | 12 | ||
| RBCUR | Freely Defined Currency 3 | FINS_CURR3 | CUKY | 10 | TCURC | |
| BSL_PTD | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR | 12 | ||
| BSL_YTD | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR | 12 | ||
| BSL_ITD | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR | 12 | ||
| RCCUR | Freely Defined Currency 4 | FINS_CURR4 | CUKY | 10 | TCURC | |
| CSL_PTD | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR | 12 | ||
| CSL_YTD | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR | 12 | ||
| CSL_ITD | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR | 12 | ||
| RDCUR | Freely Defined Currency 5 | FINS_CURR5 | CUKY | 10 | TCURC | |
| DSL_PTD | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR | 12 | ||
| DSL_YTD | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR | 12 | ||
| DSL_ITD | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR | 12 | ||
| RECUR | Freely Defined Currency 6 | FINS_CURR6 | CUKY | 10 | TCURC | |
| ESL_PTD | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR | 12 | ||
| ESL_YTD | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR | 12 | ||
| ESL_ITD | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR | 12 | ||
| RFCUR | Freely Defined Currency 7 | FINS_CURR7 | CUKY | 10 | TCURC | |
| FSL_PTD | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR | 12 | ||
| FSL_YTD | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR | 12 | ||
| FSL_ITD | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR | 12 | ||
| RGCUR | Freely Defined Currency 8 | FINS_CURR8 | CUKY | 10 | TCURC | |
| GSL_PTD | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR | 12 | ||
| GSL_YTD | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR | 12 | ||
| GSL_ITD | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR | 12 |