I_JointVentureAuditCube

Joint Venture Audit Report Cube | view: IJVAUDITC | TRAN | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, KNA1, SKA1, T8JJ, T8JG, T8JV, PROJ, LFA1, PRPS, SKAT, T004, T8JIX, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
SourceLedger FK Source Ledger
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Code Show values
JointVentureType Venture Type Show values
JntVntrRcvryCodeIsBillable Indicator: recovery indicator is billable Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
LedgerFiscalYear Ledger Fiscal Year GJAHR
WBSElementInternalID WBS Element Internal ID
JntVntrBillgCode JV Billing code CHAR3
JntVntrAuthznForExpndtrObject AFE Object JV_AFENUM_CDS
ClearingAccountingDocument Clearing Journal Entry BELNR
ReferenceDocument Reference document number AWREF
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_JOINTVENTUREAUDITCUBE.MANDT == T003.MANDT
  • I_JOINTVENTUREAUDITCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Client
  • Asset Class
  • I_JOINTVENTUREAUDITCUBE.MANDT == ANKA.MANDT
  • I_JOINTVENTUREAUDITCUBE.ASSETCLASS == ANKA.ANLKL
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_JOINTVENTUREAUDITCUBE.MANDT == TABW.MANDT
  • I_JOINTVENTUREAUDITCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_JOINTVENTUREAUDITCUBE.MANDT == T006.MANDT
  • I_JOINTVENTUREAUDITCUBE.BASEUNIT == T006.MSEHI
Business Area
  • Business Area
  • Client
  • I_JOINTVENTUREAUDITCUBE.BUSINESSAREA == TGSB.GSBER
  • I_JOINTVENTUREAUDITCUBE.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_JOINTVENTUREAUDITCUBE.MANDT == T004.MANDT
  • I_JOINTVENTUREAUDITCUBE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_JOINTVENTUREAUDITCUBE.MANDT == T001.MANDT
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_JOINTVENTUREAUDITCUBE.MANDT == TKA01.MANDT
  • I_JOINTVENTUREAUDITCUBE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Controlling Area
  • Cost Center
  • I_JOINTVENTUREAUDITCUBE.MANDT == CSKS.MANDT
  • I_JOINTVENTUREAUDITCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_JOINTVENTUREAUDITCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_JOINTVENTUREAUDITCUBE.COSTCENTER == CSKS.KOSTL
Customer Number
  • Client
  • Customer Number
  • I_JOINTVENTUREAUDITCUBE.MANDT == KNA1.MANDT
  • I_JOINTVENTUREAUDITCUBE.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • I_JOINTVENTUREAUDITCUBE.MANDT == TVTW.MANDT
  • I_JOINTVENTUREAUDITCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_JOINTVENTUREAUDITCUBE.MANDT == T009.MANDT
  • I_JOINTVENTUREAUDITCUBE.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Fixed Asset
  • Asset Subnumber
  • ?
  • I_JOINTVENTUREAUDITCUBE.MANDT == ANLA.MANDT
  • I_JOINTVENTUREAUDITCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_JOINTVENTUREAUDITCUBE.FIXEDASSET == ANLA.ANLN2
  • I_JOINTVENTUREAUDITCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • Company Code
  • G/L Account
  • I_JOINTVENTUREAUDITCUBE.MANDT == SKB1.MANDT
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODE == SKB1.BUKRS
  • I_JOINTVENTUREAUDITCUBE.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.GLOBALCURRENCY == TCURC.WAERS
JIB/JIBE Class
  • Client
  • JIB/JIBE Class
  • Company Code
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8J6A.MANDT
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGCLASS == T8J6A.CLASS
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODE == T8J6A.BUKRS
JIB/JIBE Subclass A
  • JIB/JIBE Subclass A
  • Client
  • JIB/JIBE Class
  • Company Code
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGSUBCLASS == T8J6C.SUBCLASS
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8J6C.MANDT
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGCLASS == T8J6C.CLASS
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODE == T8J6C.BUKRS
JV Subclass B
  • JIB/JIBE Subclass A
  • Client
  • JIB/JIBE Class
  • Company Code
  • JV Subclass B
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGSUBCLASS == T8J6E.JIBSA
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8J6E.CLIENT
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGCLASS == T8J6E.JIBCL
  • I_JOINTVENTUREAUDITCUBE.COMPANYCODE == T8J6E.COMPANY
  • I_JOINTVENTUREAUDITCUBE.JNTINTRSTBILLGSUBCLASS2 == T8J6E.JIBSB
Joint venture
  • Client
  • Joint venture
  • ?
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8JV.MANDT
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTURE == T8JV.VNAME
  • I_JOINTVENTUREAUDITCUBE.[column in domain "BUKRS"] == T8JV.BUKRS
Joint Venture Billing Type
  • Joint Venture Billing Type
  • Client
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8JA.MANDT
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8JJ.MANDT
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_JOINTVENTUREAUDITCUBE.[column in domain "BUKRS"] == T8JJ.BUKRS
Equity group
  • Client
  • Joint venture
  • ?
  • Equity group
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8JF.MANDT
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTURE == T8JF.VNAME
  • I_JOINTVENTUREAUDITCUBE.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
Equity type
  • Client
  • Equity type
  • ?
  • I_JOINTVENTUREAUDITCUBE.MANDT == T8JE.MANDT
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_JOINTVENTUREAUDITCUBE.[column in domain "BUKRS"] == T8JE.BUKRS
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • I_JOINTVENTUREAUDITCUBE.MANDT == KNA1.MANDT
  • I_JOINTVENTUREAUDITCUBE.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Order ID
  • Client
  • Order ID
  • I_JOINTVENTUREAUDITCUBE.MANDT == AUFK.MANDT
  • I_JOINTVENTUREAUDITCUBE.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_JOINTVENTUREAUDITCUBE.MANDT == TSPA.MANDT
  • I_JOINTVENTUREAUDITCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • I_JOINTVENTUREAUDITCUBE.MANDT == T001W.MANDT
  • I_JOINTVENTUREAUDITCUBE.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • I_JOINTVENTUREAUDITCUBE.MANDT == MARA.MANDT
  • I_JOINTVENTUREAUDITCUBE.PRODUCT == MARA.MATNR
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • I_JOINTVENTUREAUDITCUBE.PROFITCENTER == CEPC.PRCTR
  • I_JOINTVENTUREAUDITCUBE.MANDT == CEPC.MANDT
  • I_JOINTVENTUREAUDITCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_JOINTVENTUREAUDITCUBE.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • I_JOINTVENTUREAUDITCUBE.MANDT == AUFK.MANDT
  • I_JOINTVENTUREAUDITCUBE.PROJECTNETWORK == AUFK.AUFNR
Reference Document Type I_JOINTVENTUREAUDITCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • I_JOINTVENTUREAUDITCUBE.MANDT == TVKO.MANDT
  • I_JOINTVENTUREAUDITCUBE.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_JOINTVENTUREAUDITCUBE.MANDT == FAGL_SEGM.MANDT
  • I_JOINTVENTUREAUDITCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • ?
  • Service Document ID
  • Service Document Type
  • I_JOINTVENTUREAUDITCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_JOINTVENTUREAUDITCUBE.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOINTVENTUREAUDITCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_JOINTVENTUREAUDITCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • I_JOINTVENTUREAUDITCUBE.MANDT == LFA1.MANDT
  • I_JOINTVENTUREAUDITCUBE.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • I_JOINTVENTUREAUDITCUBE.MANDT == TCURC.MANDT
  • I_JOINTVENTUREAUDITCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • I_JOINTVENTUREAUDITCUBE.MANDT == T001K.MANDT
  • I_JOINTVENTUREAUDITCUBE.VALUATIONAREA == T001K.BWKEY