I_JntOpgAgrmt

Joint Operating Agreement | view: IJOA | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: T001TKA02T8JU
Column Name Description
CompanyCode FK Company Code
JntOpgAgrmt Joint Operating Agreement
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
JntVntrOvhdFlatRateAmt Flat Rate - JV overheads
Column Name Description
Column Name Description
JntOpgAgrmtCreationTime null
JntOpgAgrmtCreationDate null
JntOpgAgrmtLastChangedTime null
JntOpgAgrmtLastChangedDate null
Column Name Description
JntOpgAgrmtProdgWellThld Perform Producing Well Threshold Calculation at JOA Level Show values
JntVntrExpnIsEscalated Escalatable Show values
JntVntrPrioPerdDrillingIsCalc Calculate Drilling Days using prior period. Show values
JntVntrWBSElmntOvhdIsCalc Calculate all WBS elements for overhead Show values
Column Name Description Domain name
JntVntrContractNmbr JV Contract Number JV_CONTRAC
JntVntrPayrollClearingSet Set of Accounts to Which Payroll Burden Clearing Applies SETNAME
JntVntrConstructionExclsnSet Set of Accounts to Exclude from Construction Overhead Calc. SETNAME
JntVntrCatastropheExclsnSet Set of Accounts to Exclude from Catastrophe Overhead Calc. SETNAME
JVAOvhdPercentProdg Percent 1 (% Producing U.S., % Regular Canada) (JVA) DEC3_2
JVAExclsnAcctSetPercentProdg Exclusion Set of Accounts - Percent 1 (JVA) SETNAME
JVAOvhdPercentDev Percent 2 (% Development U.S., % Special Canada) (JVA) DEC3_2
JVAExclsnAcctSetPercentDev Exclusion Set of Accounts - Percent 2 (JVA) SETNAME
JntVntrCapitalExclsnSet Set of Accounts to Exclude from Capital Overhead Calc. SETNAME
JntVntrOvhdRecurringDoc Recurring Document Number - JV overheads BELNR
JntOpgAgrmtCreatedByUser User who Created UNAME
JntOpgAgrmtLastChangedByUser User who Last Changed UNAME
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_JNTOPGAGRMT.COMPANYCODE == T001.BUKRS
  • I_JNTOPGAGRMT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_JNTOPGAGRMT.MANDT == TCURC.MANDT
  • I_JNTOPGAGRMT.COMPANYCODECURRENCY == TCURC.WAERS
JOA Class
  • Company Code
  • Joint Operating Agreement Class
  • Client
  • I_JNTOPGAGRMT.COMPANYCODE == T8J9F.BUKRS
  • I_JNTOPGAGRMT.JNTOPGAGRMTCLASS == T8J9F.ACLASS
  • I_JNTOPGAGRMT.MANDT == T8J9F.MANDT
Catastrophe Rule
  • Company Code
  • Catastrophe Overhead Rule
  • Client
  • I_JNTOPGAGRMT.COMPANYCODE == T8J8B.BUKRS
  • I_JNTOPGAGRMT.JNTVNTRCATASTROPHEOVHDRULE == T8J8B.STEPRULE
  • I_JNTOPGAGRMT.MANDT == T8J8B.MANDT
Construction Rule
  • Company Code
  • Client
  • Construction Overhead Rule
  • I_JNTOPGAGRMT.COMPANYCODE == T8J8B.BUKRS
  • I_JNTOPGAGRMT.MANDT == T8J8B.MANDT
  • I_JNTOPGAGRMT.JNTVNTRCONSTRUCTIONOVHDRULE == T8J8B.STEPRULE
Drilling Rule
  • Company Code
  • Client
  • Drilling Overhead Rule
  • I_JNTOPGAGRMT.COMPANYCODE == T8J8B.BUKRS
  • I_JNTOPGAGRMT.MANDT == T8J8B.MANDT
  • I_JNTOPGAGRMT.JNTVNTRDRILLINGOVHDRULE == T8J8B.STEPRULE
Exploration Rule
  • Company Code
  • Exploration Overhead Rule
  • Client
  • I_JNTOPGAGRMT.COMPANYCODE == T8J8B.BUKRS
  • I_JNTOPGAGRMT.JNTVNTREXPLORATIONOVHDRULE == T8J8B.STEPRULE
  • I_JNTOPGAGRMT.MANDT == T8J8B.MANDT
Offset Cost Centre
  • Overhead Offset Cost Centre - JV
  • ?
  • ?
  • Client
  • I_JNTOPGAGRMT.JNTVNTROVHDOFFSETCOSTCTR == CSKS.KOSTL
  • I_JNTOPGAGRMT.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_JNTOPGAGRMT.[column in domain "DATBI"] == CSKS.DATBI
  • I_JNTOPGAGRMT.MANDT == CSKS.MANDT