SAP Table T8JV
Joint Venture
T8JV (Joint Venture) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link T8JV to other SAP tables.
T8JV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||
|
VNAME
Joint Venture
|
JV_NAME |
CHAR
|
6 | 0 | ||||||||||||||
|
PAYTERMS
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||
|
BMETHOD
Billing Method
|
JV_BMETHOD | T8J0C |
CHAR
|
4 | 0 | |||||||||||||
|
VTYPE
Venture Type
|
JV_VTYPE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OPERATOR
Operator for Non-Operated Venture
|
JV_OPERAT | KNA1 |
CHAR
|
10 | 0 | |||||||||||||
|
TAXCODE
Tax on sales/purchases code
|
MWSKZ | T007A |
CHAR
|
2 | 0 | |||||||||||||
|
VCLASS
Venture class
|
JV_VCLASS | T8JT |
CHAR
|
2 | 0 | |||||||||||||
|
ITD
Inception to Date
|
JV_ITD |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
CRUSER
User who Created
|
JV_CRUSER |
CHAR
|
12 | 0 | ||||||||||||||
|
CRTIME
Time Created
|
JV_CRTIME |
CHAR
|
8 | 0 | ||||||||||||||
|
CRDATE
Date Created
|
JV_CRDATE |
DATS
|
8 | 0 | ||||||||||||||
|
CHUSER
User who Last Changed
|
JV_CHUSER |
CHAR
|
12 | 0 | ||||||||||||||
|
CHTIME
Time Last Changed
|
JV_CHTIME |
CHAR
|
8 | 0 | ||||||||||||||
|
CHDATE
Date Last Changed
|
JV_CHDATE |
DATS
|
8 | 0 | ||||||||||||||
|
BFORMAT
JV Billing Format
|
JV_BFORM | T8J0R |
CHAR
|
4 | 0 | |||||||||||||
|
JOA
Joint Operating Agreement
|
JV_JOA | T8JU |
CHAR
|
6 | 0 | |||||||||||||
|
VACTIVE
Block Joint Venture for Cutback and Billing
|
JV_PROCESS |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||
|
OUTPAYTERM
Terms of Payment Key
|
DZTERM |
CHAR
|
4 | 0 | ||||||||||||||
|
OUTTAXCODE
Tax on sales/purchases code
|
MWSKZ | T007A |
CHAR
|
2 | 0 | |||||||||||||
|
TXJCD2
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||
|
NBFORMAT
Joint Venture Non-billing Form
|
JV_NBFORM | T8J3A |
CHAR
|
4 | 0 | |||||||||||||
|
BFREQ
JV Billing Frequency
|
JV_BFRQ |
NUMC
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
OVRDF
% Drilling Payroll Burden in U.S.
|
JV_DFPAY |
DEC
|
5 | 2 | ||||||||||||||
|
OVRND
Non-Drilling % to Apply for U.S. Payroll Burden Clearing
|
JV_NDPAY |
DEC
|
5 | 2 | ||||||||||||||
|
PCOCOSTC
Cost Centre for posting PCO expense
|
JV_PCOCC | CSKS |
CHAR
|
10 | 0 | |||||||||||||
|
PCOPROJK
Parent Company Overhead Expense WBS Element
|
JV_PCOWBS | PRPS |
NUMC
|
8 | 0 | |||||||||||||
|
PCOORDNR
Parent Company Overhead Expense Order
|
JV_PCOORD | AUFK |
CHAR
|
12 | 0 | |||||||||||||
|
KOSTL
Substitute Cost Centre
|
JV_VKOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||||
|
FUNDGROUP
JV Funding group
|
JV_FUNDGP | T8JM |
CHAR
|
6 | 0 | |||||||||||||
|
CHECKFC
Check Funding Currencies
|
JV_CHECKFC |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PROPERTY
JV Property ID
|
JV_PROPERT |
CHAR
|
24 | 0 | ||||||||||||||
|
BILLTHRES
Billing threshold (debit)
|
JV_BILL_THRESH |
CURR
|
13 | 2 | ||||||||||||||
|
BILLTHRESC
Billing threshold (credit)
|
JV_BILL_THRESH_C |
CURR
|
13 | 2 | ||||||||||||||
|
BILLTHRESA
Billing threshold active
|
JV_BILL_THRESH_ACTIVE |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
PSCHEM
Payment term schema
|
JV_PSCHEM | T8JPTS |
CHAR
|
4 | 0 | |||||||||||||
T8JV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T8JV | BFORMAT | T8JV | BFORMAT |
T8J0R
JV Billing format
|
BILLFORMAT |
| T8JV | BFORMAT | T8JV | MANDT |
T8J0R
JV Billing format
|
MANDT |
| T8JV | BMETHOD | T8JV | MANDT |
T8J0C
Billing Methods
|
MANDT |
| T8JV | BMETHOD | T8JV | BUKRS |
T8J0C
Billing Methods
|
BUKRS |
| T8JV | BMETHOD | T8JV | BMETHOD |
T8J0C
Billing Methods
|
BMETHOD |
| T8JV | BUKRS | T8JV | BUKRS |
T001
Company Codes
|
BUKRS |
| T8JV | BUKRS | T8JV | MANDT |
T001
Company Codes
|
MANDT |
| T8JV | FUNDGROUP | T8JV | BUKRS |
T8JM
Funding Group
|
BUKRS |
| T8JV | FUNDGROUP | T8JV | FUNDGROUP |
T8JM
Funding Group
|
FUNDGROUP |
| T8JV | FUNDGROUP | T8JV | MANDT |
T8JM
Funding Group
|
MANDT |
| T8JV | JOA | T8JV | MANDT |
T8JU
Joint Operating Agreement
|
MANDT |
| T8JV | JOA | T8JV | BUKRS |
T8JU
Joint Operating Agreement
|
BUKRS |
| T8JV | JOA | T8JV | JOA |
T8JU
Joint Operating Agreement
|
JOA |
| T8JV | KOSTL | T8JV | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| T8JV | KOSTL | * |
CSKS
Cost Center Master Data
|
KOKRS | |
| T8JV | KOSTL | T8JV | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| T8JV | KOSTL | T8JV | CRDATE |
CSKS
Cost Center Master Data
|
DATBI |
| T8JV | MANDT | T8JV | MANDT |
T000
Clients
|
MANDT |
| T8JV | NBFORMAT | T8JV | MANDT |
T8J3A
Non-operated Billing Form
|
MANDT |
| T8JV | NBFORMAT | T8JV | BUKRS |
T8J3A
Non-operated Billing Form
|
BUKRS |
| T8JV | NBFORMAT | T8JV | NBFORMAT |
T8J3A
Non-operated Billing Form
|
NBFORM |
| T8JV | OPERATOR | T8JV | OPERATOR |
KNA1
General Data in Customer Master
|
KUNNR |
| T8JV | OPERATOR | T8JV | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| T8JV | OUTTAXCODE | T8JV | MANDT |
T007A
Tax Keys
|
MANDT |
| T8JV | OUTTAXCODE | * |
T007A
Tax Keys
|
KALSM | |
| T8JV | OUTTAXCODE | T8JV | OUTTAXCODE |
T007A
Tax Keys
|
MWSKZ |
| T8JV | PCOCOSTC | T8JV | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| T8JV | PCOCOSTC | * |
CSKS
Cost Center Master Data
|
KOKRS | |
| T8JV | PCOCOSTC | T8JV | PCOCOSTC |
CSKS
Cost Center Master Data
|
KOSTL |
| T8JV | PCOCOSTC | * |
CSKS
Cost Center Master Data
|
DATBI | |
| T8JV | PCOORDNR | T8JV | MANDT |
AUFK
Order master data
|
MANDT |
| T8JV | PCOORDNR | T8JV | PCOORDNR |
AUFK
Order master data
|
AUFNR |
| T8JV | PCOPROJK | T8JV | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| T8JV | PCOPROJK | T8JV | PCOPROJK |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| T8JV | PSCHEM | T8JV | MANDT |
T8JPTS
Payment Term Schema
|
MANDT |
| T8JV | PSCHEM | T8JV | BUKRS |
T8JPTS
Payment Term Schema
|
BUKRS |
| T8JV | PSCHEM | T8JV | PSCHEM |
T8JPTS
Payment Term Schema
|
PSCHEM |
| T8JV | TAXCODE | T8JV | TAXCODE |
T007A
Tax Keys
|
MWSKZ |
| T8JV | TAXCODE | T8JV | MANDT |
T007A
Tax Keys
|
MANDT |
| T8JV | TAXCODE | * |
T007A
Tax Keys
|
KALSM | |
| T8JV | TXJCD | T8JV | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| T8JV | TXJCD | * |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM | |
| T8JV | TXJCD | T8JV | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| T8JV | TXJCD2 | T8JV | TXJCD2 |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| T8JV | TXJCD2 | T8JV | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| T8JV | TXJCD2 | * |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM | |
| T8JV | VCLASS | T8JV | BUKRS |
T8JT
Venture Class
|
BUKRS |
| T8JV | VCLASS | T8JV | VCLASS |
T8JT
Venture Class
|
VCLASS |
| T8JV | VCLASS | T8JV | MANDT |
T8JT
Venture Class
|
MANDT |