I_JVAJntInterestBillingCube

JVA Joint Interest Billing Report | view: IJVAJIB | TRAN | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: SCAL_TT_DATE, ACDOCA, T001, TKA02, CSKS, CSKT, T8JJ, T8JVT, FINSC_LEDGER, PRPS, SKAT, T004, T8JIX, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
Column Name Description
Column Name Description
JVAProjIsAuthzdForCptlExpndtr Indicator: Capital Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
CompanyCodeName Name of Company Code or Company TEXT25
JointVentureName null
JntVntrAuthznForExpndtrObject AFE Object JV_AFENUM_CDS
CostCenterName Cost Center Name TEXT20
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSDescription WBS Element Name TEXT40
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
GLAccountName G/L Account Short Text TEXT20
JntVntrCostTypeText JIB Cost Objects CHAR28
JntIntrstBillgCostObjectType JIB Cost Objects CHAR28
JntIntrstBillgSubClass4 null
JntIntrstBillgSubClass3 null
JntOpgAgrmtEquityGrpText null
JntVntrSuspenseStatusText null
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == TABW.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_JVAJNTINTERESTBILLINGCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T001.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == TCURC.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_JVAJNTINTERESTBILLINGCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • I_JVAJNTINTERESTBILLINGCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == CSKS.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.COSTCENTER == CSKS.KOSTL
  • I_JVAJNTINTERESTBILLINGCUBE.[column in domain "DATBI"] == CSKS.DATBI
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == SKB1.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.GLACCOUNT == SKB1.SAKNR
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == SKB1.BUKRS
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • Company Code
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6A.CLASS
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6A.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6A.BUKRS
JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • JIB/JIBE Subclass A
  • Company Code
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6C.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6C.BUKRS
JV Subclass B
  • JIB/JIBE Class
  • Client
  • JIB/JIBE Subclass A
  • Company Code
  • JV Subclass B
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6E.JIBCL
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6E.CLIENT
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS == T8J6E.JIBSA
  • I_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6E.COMPANY
  • I_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS2 == T8J6E.JIBSB
Joint venture
  • Client
  • ?
  • Joint venture
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JV.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JJ.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JJ.BUKRS
Joint Venture Equity Group
  • Joint Venture Equity Group
  • Client
  • ?
  • Joint venture
  • I_JVAJNTINTERESTBILLINGCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JF.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURE == T8JF.VNAME
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == KNA1.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Order ID
  • Client
  • I_JVAJNTINTERESTBILLINGCUBE.ORDERID == AUFK.AUFNR
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == AUFK.MANDT
Number of Superior Order
  • Client
  • Number of Superior Order
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == AUFK.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.SUPERIORORDER == AUFK.AUFNR
Transaction Currency
  • Client
  • Transaction Currency
  • I_JVAJNTINTERESTBILLINGCUBE.MANDT == TCURC.MANDT
  • I_JVAJNTINTERESTBILLINGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS