T8JV SAP (Joint Venture) Table details
Dictionary Type: Table
Description: Joint Venture
Description: Joint Venture
Table field list including key, data, relationships and ABAP select examples
T8JV is a standard SAP Table which is used to store Joint Venture data and is available within R/3 SAP systems depending on the version and release level.
The T8JV table consists of various fields, each holding specific information or linking keys about Joint Venture data available in SAP. These include BUKRS (Company Code), VNAME (Joint Venture), PAYTERMS (Terms of Payment Key), BMETHOD (Billing Method).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = T8JVT
SAP T8JV table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | ALPHA | JV_NAME | JVV | ||
PAYTERMS | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
BMETHOD | Billing Method | JV_BMETHOD | CHAR | 4 | T8J0C | ALPHA | JV_BMETHOD | ||
VTYPE | Venture Type | JV_VTYPE | CHAR | 1 | JV_VTYPE | ||||
OPERATOR | Operator for Non-Operated Venture | JV_OPERAT | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
VCLASS | Venture class | JV_VCLASS | CHAR | 2 | T8JT | ALPHA | JV_VCLASS | ||
ITD | Inception to Date | JV_ITD | CHAR | 1 | JV_BILLING_PYI | ||||
CRUSER | User who Created | JV_CRUSER | CHAR | 12 | UNAME | ||||
CRTIME | Time Created | JV_CRTIME | CHAR | 8 | ZEITE | ||||
CRDATE | Date Created | JV_CRDATE | DATS | 8 | DATUM | ||||
CHUSER | User who Last Changed | JV_CHUSER | CHAR | 12 | UNAME | ||||
CHTIME | Time Last Changed | JV_CHTIME | CHAR | 8 | ZEITE | ||||
CHDATE | Date Last Changed | JV_CHDATE | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
BFORMAT | JV Billing Format | JV_BFORM | CHAR | 4 | T8J0R | JV_BFORM | |||
JOA | Joint Operating Agreement | JV_JOA | CHAR | 6 | T8JU | ALPHA | JV_JOA | JVJ | |
VACTIVE | Block Joint Venture for Cutback and Billing | JV_PROCESS | CHAR | 1 | XFELD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
OUTPAYTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
OUTTAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
TXJCD2 | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
NBFORMAT | Joint Venture Non-billing Form | JV_NBFORM | CHAR | 4 | T8J3A | JV_NBFORM | |||
BFREQ | JV Billing Frequency | JV_BFRQ | NUMC | 1 | JV_BFRQ | ||||
OVRDF | % Drilling Payroll Burden in U.S. | JV_DFPAY | DEC | 5(2) | DEC3_2 | ||||
OVRND | Non-Drilling % to Apply for U.S. Payroll Burden Clearing | JV_NDPAY | DEC | 5(2) | DEC3_2 | ||||
PCOCOSTC | Cost Centre for posting PCO expense | JV_PCOCC | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
PCOPROJK | Parent Company Overhead Expense WBS Element | JV_PCOWBS | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
PCOORDNR | Parent Company Overhead Expense Order | JV_PCOORD | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
KOSTL | Substitute Cost Centre | JV_VKOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
FUNDGROUP | JV Funding group | JV_FUNDGP | CHAR | 6 | T8JM | JV_FUNDGP | |||
CHECKFC | Check Funding Currencies | JV_CHECKFC | CHAR | 1 | XFELD | ||||
PROPERTY | JV Property ID | JV_PROPERT | CHAR | 24 | ALPHA | JV_CONTRAC | |||
BILLTHRES | Billing threshold (debit) | JV_BILL_THRESH | CURR | 13(2) | WERT7 | ||||
BILLTHRESC | Billing threshold (credit) | JV_BILL_THRESH_C | CURR | 13(2) | WERT7 | ||||
BILLTHRESA | Billing threshold active | JV_BILL_THRESH_ACTIVE | CHAR | 1 | XFELD | ||||
PSCHEM | Payment term schema | JV_PSCHEM | CHAR | 4 | T8JPTS | JV_PSCHEM |
Key field | Non-key field |
How do I retrieve data from SAP table T8JV using ABAP code
The following ABAP code Example will allow you to do a basic selection on T8JV to SELECT all data from the tableDATA: WA_T8JV TYPE T8JV.
SELECT SINGLE *
FROM T8JV
INTO CORRESPONDING FIELDS OF WA_T8JV
WHERE...
How to access SAP table T8JV
Within an ECC or HANA version of SAP you can also view further information about T8JV and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects