T8JV table in SAP ERP or S/4HANA stores Joint Venture data. There are total 39 fields in T8JV table. The Joint Venture table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T8JV table. It is in Joint venture objects with original in ALR (GJVC) ABAP package and is part of the Joint Venture und Production Sharing Accounting (CA-JVA) module.
SAP T8JV Table Fields
Following is the list of fields that are available in SAP T8JV table. The primary key fields of Joint Venture table in SAP are MANDT (Client), BUKRS (Company Code), VNAME (Joint venture).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| BUKRS | Company Code | BUKRS | T001 | CHAR(4) |
| VNAME | Joint venture | JV_NAME | CHAR(6) | |
| PAYTERMS | Terms of payment key | DZTERM | CHAR(4) | |
| BMETHOD | Billing Method | JV_BMETHOD | T8J0C | CHAR(4) |
| VTYPE | Venture Type | JV_VTYPE | CHAR(1) | |
| OPERATOR | Operator for Non-Operated Venture | JV_OPERAT | KNA1 | CHAR(10) |
| TAXCODE | Tax on sales/purchases code | MWSKZ | T007A | CHAR(2) |
| VCLASS | Venture Class | JV_VCLASS | T8JT | CHAR(2) |
| ITD | Inception to Date | JV_ITD | CHAR(1) | |
| CRUSER | User who Created | JV_CRUSER | CHAR(12) | |
| CRTIME | Time Created | JV_CRTIME | CHAR(8) | |
| CRDATE | Date Created | JV_CRDATE | DATS(8) | |
| CHUSER | User who Last Changed | JV_CHUSER | CHAR(12) | |
| CHTIME | Time Last Changed | JV_CHTIME | CHAR(8) | |
| CHDATE | Date Last Changed | JV_CHDATE | DATS(8) | |
| BFORMAT | JV Billing Format | JV_BFORM | T8J0R | CHAR(4) |
| JOA | Joint Operating Agreement | JV_JOA | T8JU | CHAR(6) |
| VACTIVE | Block Joint Venture for Cutback and Billing | JV_PROCESS | CHAR(1) | |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR(15) |
| OUTPAYTERM | Terms of payment key | DZTERM | CHAR(4) | |
| OUTTAXCODE | Tax on sales/purchases code | MWSKZ | T007A | CHAR(2) |
| TXJCD2 | Tax Jurisdiction | TXJCD | TTXJ | CHAR(15) |
| NBFORMAT | Joint Venture Non-billing Form | JV_NBFORM | T8J3A | CHAR(4) |
| BFREQ | JV Billing Frequency | JV_BFRQ | NUMC(1) | |
| OVRDF | % Drilling Payroll Burden in U.S. | JV_DFPAY | DEC(5) | |
| OVRND | Non-Drilling % to Apply for U.S. Payroll Burden Clearing | JV_NDPAY | DEC(5) | |
| PCOCOSTC | Cost Centre for posting PCO expense | JV_PCOCC | CSKS | CHAR(10) |
| PCOPROJK | Parent Company Overhead Expense WBS Element | JV_PCOWBS | PRPS | NUMC(8) |
| PCOORDNR | Parent Company Overhead Expense Order | JV_PCOORD | AUFK | CHAR(12) |
| KOSTL | Substitute Cost Centre | JV_VKOSTL | CSKS | CHAR(10) |
| FUNDGROUP | JV Funding group | JV_FUNDGP | T8JM | CHAR(6) |
| CHECKFC | Check Funding Currencies | JV_CHECKFC | CHAR(1) | |
| PROPERTY | JV Property ID | JV_PROPERT | CHAR(24) | |
| BILLTHRES | Billing threshold (debit) | JV_BILL_THRESH | CURR(13) | |
| BILLTHRESC | Billing threshold (credit) | JV_BILL_THRESH_C | CURR(13) | |
| BILLTHRESA | Billing threshold active | JV_BILL_THRESH_ACTIVE | CHAR(1) | |
| PSCHEM | Payment term schema | JV_PSCHEM | T8JPTS | CHAR(4) |
| IC_GROUP | JV Interest calculation group id | JV_INTCALC_GROUP_ID | JVA_INTC_GRP | CHAR(10) |
