JVB09 - JV Billing Extract: EDI Supplem. Detail - Expendit. Detail
JV Billing Extract: EDI Supplem. Detail - Expendit. Detail information is stored in SAP table JVB09.
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 JVB09
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 |
RBUKRS | Company Code | X | BUKRS | CHAR | 8 | |
RYEAR | General Ledger Fiscal Year | X | GJAHR_POS | NUMC | 8 | |
POPER | Posting period | X | POPER | NUMC | 6 | |
SDS | Supplemental detail set for JV billing | X | JV_SDS | CHAR | 8 | |
RCNTR | Cost Center | X | KOSTL | CHAR | 20 | |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | X | PS_PSP_PNR | NUMC | 16 | |
RORDNR | Order Number | X | AUFNR | CHAR | 24 | |
VPTNR | Partner account number | X | JV_PART | CHAR | 20 | KNA1 |
BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
DOCLN | Six-Character Posting Item for Ledger | X | DOCLN6 | CHAR | 12 | |
EGRUP | Equity group | X | JV_EGROUP | CHAR | 6 | T8JF |
VNAME | Joint venture | X | JV_NAME | CHAR | 12 | T8JV |
FUNDING_CURRENCY | Currency Key | X | WAERS | CUKY | 10 | |
RACCT | Account Number | X | RACCT | CHAR | 20 | SKA1 |
ETYPE | Equity type | JV_ETYPE | CHAR | 6 | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 24 | ||
NPLNR_VORGN | Network activity | NPVRG | CHAR | 8 | ||
PRODPER | Production Month (Date to find period and year) | JV_PRODPER | DATS | 16 | ||
JVACTIVITY | JVA Activity (Joint Venture Accounting) | JV_ACTIVITY | CHAR | 4 | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 20 | ||
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 10 | ||
AWTYP | Reference procedure | AWTYP | CHAR | 10 | ||
AWORG | Reference Organizational Units | AWORG | CHAR | 20 | ||
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 | ||
PROJ_SUP | JV Project | JV_PROJ | NUMC | 16 | ||
BILLCODE | JV Billing code | JV_BILLCO | CHAR | 6 | ||
MATNR | Material Number | MATNR | CHAR | 80 | ||
BLART | Document Type | BLART | CHAR | 4 | ||
PROJ_SDS | JV Project | JV_PROJ | NUMC | 16 | ||
ORDER_SDS | Order Number | AUFNR | CHAR | 24 | ||
ACCT_SDS | Account Number | RACCT | CHAR | 20 | ||
RECIND_SDS | Recovery Indicator | JV_RECIND | CHAR | 4 | ||
RCNTR_SDS | Cost Center | KOSTL | CHAR | 20 | ||
AWREF | Reference document number | AWREF | CHAR | 20 | ||
MSL | Quantity | QUAN1_12 | QUAN | 12 | ||
RUNIT | Base Unit of Measure | MEINS | UNIT | 6 | ||
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 | ||
FCURR | Value field 12(23) characters with 2 decimal places | WERTV12 | CURR | 12 | ||
RWCUR | Transaction Currency | FINS_CURRW | CUKY | 10 | ||
WSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
RHCUR | Company Code Currency | FINS_CURRH | CUKY | 10 | ||
HSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
RKCUR | Global Currency | FINS_CURRK | CUKY | 10 | ||
KSL | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
ROCUR | Freely Defined Currency 1 | FINS_CURR1 | CUKY | 10 | ||
OSL | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR | 12 | ||
RVCUR | Freely Defined Currency 2 | FINS_CURR2 | CUKY | 10 | ||
VSL | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR | 12 | ||
RBCUR | Freely Defined Currency 3 | FINS_CURR3 | CUKY | 10 | ||
BSL | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR | 12 | ||
RCCUR | Freely Defined Currency 4 | FINS_CURR4 | CUKY | 10 | ||
CSL | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR | 12 | ||
RDCUR | Freely Defined Currency 5 | FINS_CURR5 | CUKY | 10 | ||
DSL | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR | 12 | ||
RECUR | Freely Defined Currency 6 | FINS_CURR6 | CUKY | 10 | ||
ESL | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR | 12 | ||
RFCUR | Freely Defined Currency 7 | FINS_CURR7 | CUKY | 10 | ||
FSL | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR | 12 | ||
RGCUR | Freely Defined Currency 8 | FINS_CURR8 | CUKY | 10 | ||
GSL | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR | 12 |