1. Home
  2. Resources
  3. SAP Tables
  4. T8JV - Joint Venture

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
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
1 Operated venture
2 Non-operated venture
3 Non-operated venture for on-billing
4 Operated venture (with tax)
5 Corporate venture
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
NULL Non-zero period to date values
A Non-zero year to date values
X Non-zero inception to date values
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
X Yes
NULL No
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
0 Monthly bill
1 Quarterly bill
2 Semi-annual bill
3 Yearly bill
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
X Yes
NULL No
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
X Yes
NULL No
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