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 |