I_JointVentureDetails

Master Data for Joint Venture | view: IJNTVNTR | Extraction: Full only | Component: Joint Venture und Production Sharing Accounting
Tables used: T001, TKA02, T8JF, T8JQ, T8JV
Column Name Description
CompanyCode FK Company Code
JointVenture Joint venture
JntOpgAgrmtEquityGrp Equity group
JointVenturePartner FK JV partner
Column Name Description
💲 Currency Key (Currency):
JntVntrBillgThldDebit Billing threshold (debit)
JntVntrBillgThldCredit Billing threshold (credit)
Column Name Description
Column Name Description
JntVntrDateCreated Date Created
JntVntrDateLastChanged Date Last Changed
Column Name Description
JointVentureType Venture Type Show values
JntVntrInceptionToDateBillg Inception to Date Show values
JntVntrBillgCutbackIsBlk Block Joint Venture for Cutback and Billing Show values
JntVntrBillgFrqcy JV Billing Frequency Show values
JntVntrCrcyIsFundingCrcy Check Funding Currencies Show values
JntVntrBillgThldIsActive Billing threshold active Show values
Column Name Description Domain name
PaymentTerms Terms of payment key ZTERM
CreatedByUser User who Created UNAME
JntVntrTimeCreated Time Created ZEITE
LastChangedByUser User who Last Changed UNAME
JntVntrTimeLastChanged Time Last Changed ZEITE
JntVntrOutPaymentTerms Terms of payment key ZTERM
JntVntrDrillingPayRate % Drilling Payroll Burden in U.S. DEC3_2
JntVntrNonDrillingPayRate Non-Drilling % to Apply for U.S. Payroll Burden Clearing DEC3_2
JntVntrProperty JV Property ID JV_CONTRAC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T001.BUKRS
  • I_JOINTVENTUREDETAILS.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_JOINTVENTUREDETAILS.CURRENCY == TCURC.WAERS
  • I_JOINTVENTUREDETAILS.MANDT == TCURC.MANDT
JOA
  • Company Code
  • Joint Operating Agreement
  • Client
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8JU.BUKRS
  • I_JOINTVENTUREDETAILS.JNTOPGAGRMT == T8JU.JOA
  • I_JOINTVENTUREDETAILS.MANDT == T8JU.MANDT
JV Billing Format
  • Client
  • JV Billing Format
  • I_JOINTVENTUREDETAILS.MANDT == T8J0R.MANDT
  • I_JOINTVENTUREDETAILS.JNTVNTRBILLGFORMAT == T8J0R.BILLFORMAT
Funding Group
  • Company Code
  • Client
  • JV Funding group
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8JM.BUKRS
  • I_JOINTVENTUREDETAILS.MANDT == T8JM.MANDT
  • I_JOINTVENTUREDETAILS.JNTVNTRFUNDINGGROUP == T8JM.FUNDGROUP
Joint Venture Non-operated Billing Form
  • Company Code
  • Joint Venture Non-operated Billing Form
  • Client
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8J3A.BUKRS
  • I_JOINTVENTUREDETAILS.JNTVNTRNONBILLGFORMAT == T8J3A.NBFORM
  • I_JOINTVENTUREDETAILS.MANDT == T8J3A.MANDT
Tax Code
  • ?
  • Client
  • Tax on sales/purchases code
  • I_JOINTVENTUREDETAILS.[column in domain "KALSM_D"] == T007A.KALSM
  • I_JOINTVENTUREDETAILS.MANDT == T007A.MANDT
  • I_JOINTVENTUREDETAILS.JNTVNTROUTTAXCODE == T007A.MWSKZ
Cost Center
  • ?
  • ?
  • Client
  • Cost Centre for posting PCO expense
  • I_JOINTVENTUREDETAILS.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_JOINTVENTUREDETAILS.[column in domain "DATBI"] == CSKS.DATBI
  • I_JOINTVENTUREDETAILS.MANDT == CSKS.MANDT
  • I_JOINTVENTUREDETAILS.JNTVNTRPARENTCOOVHDEXPNCOSTCTR == CSKS.KOSTL
PCO Order
  • Parent Company Overhead Expense Order
  • Client
  • I_JOINTVENTUREDETAILS.JNTVNTRPARENTCOOVHDEXPNORDER == AUFK.AUFNR
  • I_JOINTVENTUREDETAILS.MANDT == AUFK.MANDT
Payment term schema
  • Company Code
  • Client
  • Payment term schema
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8JPTS.BUKRS
  • I_JOINTVENTUREDETAILS.MANDT == T8JPTS.MANDT
  • I_JOINTVENTUREDETAILS.JNTVNTRPAYMENTTERMSCHEMA == T8JPTS.PSCHEM
Cost Centre
  • Date Created
  • ?
  • Substitute Cost Centre
  • Client
  • I_JOINTVENTUREDETAILS.JNTVNTRDATECREATED == CSKS.DATBI
  • I_JOINTVENTUREDETAILS.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_JOINTVENTUREDETAILS.JNTVNTRSUBSTITUTECOSTCTR == CSKS.KOSTL
  • I_JOINTVENTUREDETAILS.MANDT == CSKS.MANDT
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • I_JOINTVENTUREDETAILS.JNTVNTRTAXJURISDICTION == TTXJ.TXJCD
  • I_JOINTVENTUREDETAILS.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_JOINTVENTUREDETAILS.MANDT == TTXJ.MANDT
Billing method
  • Company Code
  • Billing Method
  • Client
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8J0C.BUKRS
  • I_JOINTVENTUREDETAILS.JOINTVENTUREBILLINGTYPE == T8J0C.BMETHOD
  • I_JOINTVENTUREDETAILS.MANDT == T8J0C.MANDT
Venture Class
  • Company Code
  • Client
  • Venture Class
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8JT.BUKRS
  • I_JOINTVENTUREDETAILS.MANDT == T8JT.MANDT
  • I_JOINTVENTUREDETAILS.JOINTVENTURECLASS == T8JT.VCLASS
Operator
  • Operator for Non-Operated Venture
  • Client
  • I_JOINTVENTUREDETAILS.OPERATOR == KNA1.KUNNR
  • I_JOINTVENTUREDETAILS.MANDT == KNA1.MANDT
Tax Code
  • Tax on sales/purchases code
  • ?
  • Client
  • I_JOINTVENTUREDETAILS.TAXCODE == T007A.MWSKZ
  • I_JOINTVENTUREDETAILS.[column in domain "KALSM_D"] == T007A.KALSM
  • I_JOINTVENTUREDETAILS.MANDT == T007A.MANDT
Tax Code
  • Tax Jurisdiction
  • ?
  • Client
  • I_JOINTVENTUREDETAILS.TAXJURISDICTION == TTXJ.TXJCD
  • I_JOINTVENTUREDETAILS.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_JOINTVENTUREDETAILS.MANDT == TTXJ.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
JV partner
  • Company Code
  • JV partner
  • Client
  • I_JOINTVENTUREDETAILS.COMPANYCODE == T8JO.BUKRS
  • I_JOINTVENTUREDETAILS.JOINTVENTUREPARTNER == T8JO.PARTN
  • I_JOINTVENTUREDETAILS.MANDT == T8JO.MANDT