JVB07 - JV Billing Extract: Supplemental Detail (JIB Mapped) EDI
JV Billing Extract: Supplemental Detail (JIB Mapped) EDI information is stored in SAP table JVB07.
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 JVB07
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 | |
| BTYPE | Billing Indicator | X | JV_BILIND | CHAR | 4 | T8JA |
| RBUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| RCNTR | Cost Center | X | KOSTL | CHAR | 20 | |
| RORDNR | Order Number | X | AUFNR | CHAR | 24 | |
| BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
| DOCLN | Six-Character Posting Item for Ledger | X | DOCLN6 | CHAR | 12 | |
| FUNDCUR | Funding currency | X | JV_FUNDCUR | CUKY | 10 | TCURC |
| RACCT | Account Number | X | RACCT | CHAR | 20 | SKA1 |
| SDS | Supplemental detail set for JV billing | JV_SDS | CHAR | 8 | ||
| PRODPER | Production Month (Date to find period and year) | JV_PRODPER | DATS | 16 | ||
| AWTYP | Reference procedure | AWTYP | CHAR | 10 | ||
| AWORG | Reference Organizational Units | AWORG | CHAR | 20 | ||
| AWREF | Reference document number | AWREF | CHAR | 20 | ||
| BLART | Document Type | BLART | CHAR | 4 | ||
| 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 | ||
| 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 |