C_JVAJntInterestBillingCube

JVA Joint Interest Billing Report | view: CJVAJIB | 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
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
CompanyCodeName Name of Company Code or Company TEXT25
JointVentureName null
JntIntrstBillgSubClass4 null
JntIntrstBillgSubClass3 null
JntIntrstBillgCostObjectType JIB Cost Objects
CostCenterName Cost Center Name TEXT20
GLAccountName G/L Account Short Text TEXT20
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSDescription WBS Element Name TEXT40
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
JVAProjIsAuthzdForCptlExpndtr Indicator: Capital
JntVntrAuthznForExpndtrObject AFE Object
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == TABW.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T004.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T001.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == TCURC.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == TKA01.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • Controlling Area
  • ?
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == CSKS.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.COSTCENTER == CSKS.KOSTL
  • C_JVAJNTINTERESTBILLINGCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • C_JVAJNTINTERESTBILLINGCUBE.[column in domain "DATBI"] == CSKS.DATBI
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_JVAJNTINTERESTBILLINGCUBE.GLACCOUNT == SKB1.SAKNR
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == SKB1.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == SKB1.BUKRS
JIB/JIBE Class
  • JIB/JIBE Class
  • Client
  • Company Code
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6A.CLASS
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6A.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6A.BUKRS
JIB/JIBE Subclass A
  • JIB/JIBE Class
  • Client
  • JIB/JIBE Subclass A
  • Company Code
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6C.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6C.BUKRS
JV Subclass B
  • JIB/JIBE Class
  • Client
  • JIB/JIBE Subclass A
  • Company Code
  • JV Subclass B
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGCLASS == T8J6E.JIBCL
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8J6E.CLIENT
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS == T8J6E.JIBSA
  • C_JVAJNTINTERESTBILLINGCUBE.COMPANYCODE == T8J6E.COMPANY
  • C_JVAJNTINTERESTBILLINGCUBE.JNTINTRSTBILLGSUBCLASS2 == T8J6E.JIBSB
Joint venture
  • Client
  • Joint venture
  • ?
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JV.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURE == T8JV.VNAME
  • C_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JV.BUKRS
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JJ.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • C_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JJ.BUKRS
Joint Venture Equity Group
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • ?
  • C_JVAJNTINTERESTBILLINGCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == T8JF.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.JOINTVENTURE == T8JF.VNAME
  • C_JVAJNTINTERESTBILLINGCUBE.[column in domain "BUKRS"] == T8JF.BUKRS
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == KNA1.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Client
  • Order ID
  • C_JVAJNTINTERESTBILLINGCUBE.MANDT == AUFK.MANDT
  • C_JVAJNTINTERESTBILLINGCUBE.ORDERID == AUFK.AUFNR