JVB01 - JV Billing Extract: Invoice
JV Billing Extract: Invoice information is stored in SAP table JVB01.
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 JVB01
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 | |
| RBUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| 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 | |
| ETYPE | Equity type | X | JV_ETYPE | CHAR | 6 | |
| EGRUP | Equity group | X | JV_EGROUP | CHAR | 6 | T8JF |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | T8JV |
| BTYPE | Billing Indicator | X | JV_BILIND | CHAR | 4 | T8JA |
| FUNDING_CURRENCY | Currency Key | X | WAERS | CUKY | 10 | |
| SDS | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| ORSDS | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| 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 |