T8JV is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Joint Venture data. There are total 39 fields in the table. The T8JV table can be found in the Joint venture objects with original in ALR (GJVC) package and is part of the Joint Venture und Production Sharing Accounting (CA-JVA) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full buffering as specified by generic key |
T8JV Table Fields
The following is the list of fields that are available in SAP T8JV table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | BUKRS | T001 | CHAR | 4 |
| VNAME | Joint venture | JV_NAME | JV_NAME | CHAR | 6 | |
| PAYTERMS | Terms of payment key | DZTERM | ZTERM | CHAR | 4 | |
| BMETHOD | Billing Method | JV_BMETHOD | JV_BMETHOD | T8J0C | CHAR | 4 |
| VTYPE | Venture Type | JV_VTYPE | JV_VTYPE | CHAR | 1 | |
| OPERATOR | Operator for Non-Operated Venture | JV_OPERAT | KUNNR | KNA1 | CHAR | 10 |
| TAXCODE | Tax on sales/purchases code | MWSKZ | MWSKZ | T007A | CHAR | 2 |
| VCLASS | Venture Class | JV_VCLASS | JV_VCLASS | T8JT | CHAR | 2 |
| ITD | Inception to Date | JV_ITD | JV_BILLING_PYI | CHAR | 1 | |
| CRUSER | User who Created | JV_CRUSER | UNAME | CHAR | 12 | |
| CRTIME | Time Created | JV_CRTIME | ZEITE | CHAR | 8 | |
| CRDATE | Date Created | JV_CRDATE | DATUM | DATS | 8 | |
| CHUSER | User who Last Changed | JV_CHUSER | UNAME | CHAR | 12 | |
| CHTIME | Time Last Changed | JV_CHTIME | ZEITE | CHAR | 8 | |
| CHDATE | Date Last Changed | JV_CHDATE | DATUM | DATS | 8 | |
| BFORMAT | JV Billing Format | JV_BFORM | JV_BFORM | T8J0R | CHAR | 4 |
| JOA | Joint Operating Agreement | JV_JOA | JV_JOA | T8JU | CHAR | 6 |
| VACTIVE | Block Joint Venture for Cutback and Billing | JV_PROCESS | XFELD | CHAR | 1 | |
| TXJCD | Tax Jurisdiction | TXJCD | TXJCD | TTXJ | CHAR | 15 |
| OUTPAYTERM | Terms of payment key | DZTERM | ZTERM | CHAR | 4 | |
| OUTTAXCODE | Tax on sales/purchases code | MWSKZ | MWSKZ | T007A | CHAR | 2 |
| TXJCD2 | Tax Jurisdiction | TXJCD | TXJCD | TTXJ | CHAR | 15 |
| NBFORMAT | Joint Venture Non-billing Form | JV_NBFORM | JV_NBFORM | T8J3A | CHAR | 4 |
| BFREQ | JV Billing Frequency | JV_BFRQ | JV_BFRQ | NUMC | 1 | |
| OVRDF | % Drilling Payroll Burden in U.S. | JV_DFPAY | DEC3_2 | DEC | 5 | |
| OVRND | Non-Drilling % to Apply for U.S. Payroll Burden Clearing | JV_NDPAY | DEC3_2 | DEC | 5 | |
| PCOCOSTC | Cost Centre for posting PCO expense | JV_PCOCC | KOSTL | CSKS | CHAR | 10 |
| PCOPROJK | Parent Company Overhead Expense WBS Element | JV_PCOWBS | PS_POSNR | PRPS | NUMC | 8 |
| PCOORDNR | Parent Company Overhead Expense Order | JV_PCOORD | AUFNR | AUFK | CHAR | 12 |
| KOSTL | Substitute Cost Centre | JV_VKOSTL | KOSTL | CSKS | CHAR | 10 |
| FUNDGROUP | JV Funding group | JV_FUNDGP | JV_FUNDGP | T8JM | CHAR | 6 |
| CHECKFC | Check Funding Currencies | JV_CHECKFC | XFELD | CHAR | 1 | |
| PROPERTY | JV Property ID | JV_PROPERT | JV_CONTRAC | CHAR | 24 | |
| BILLTHRES | Billing threshold (debit) | JV_BILL_THRESH | WERT7 | CURR | 13 | |
| BILLTHRESC | Billing threshold (credit) | JV_BILL_THRESH_C | WERT7 | CURR | 13 | |
| BILLTHRESA | Billing threshold active | JV_BILL_THRESH_ACTIVE | XFELD | CHAR | 1 | |
| PSCHEM | Payment term schema | JV_PSCHEM | JV_PSCHEM | T8JPTS | CHAR | 4 |
| IC_GROUP | JV Interest calculation group id | JV_INTCALC_GROUP_ID | JV_INTCALC_GROUP_ID | JVA_INTC_GRP | CHAR | 10 |
Availability
The SAP HANA table T8JV is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for T8JV table
We’re updating the content all the time, so check back regularly.
