C_JointVentureAuditQuery

Joint Venture Audit Report Query | view: CJVAUDITQ | 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
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
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
JntVntrRcvryCodeIsBillable Indicator: recovery indicator is billable Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_JOINTVENTUREAUDITQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_JOINTVENTUREAUDITQUERY.MANDT == T003.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_JOINTVENTUREAUDITQUERY.MANDT == TABW.MANDT
  • C_JOINTVENTUREAUDITQUERY.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Business Area
  • Business Area
  • Client
  • C_JOINTVENTUREAUDITQUERY.BUSINESSAREA == TGSB.GSBER
  • C_JOINTVENTUREAUDITQUERY.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • C_JOINTVENTUREAUDITQUERY.COMPANYCODE == T001.BUKRS
  • C_JOINTVENTUREAUDITQUERY.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_JOINTVENTUREAUDITQUERY.MANDT == TKA01.MANDT
  • C_JOINTVENTUREAUDITQUERY.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • C_JOINTVENTUREAUDITQUERY.[column in domain "DATBI"] == CSKS.DATBI
  • C_JOINTVENTUREAUDITQUERY.MANDT == CSKS.MANDT
  • C_JOINTVENTUREAUDITQUERY.CONTROLLINGAREA == CSKS.KOKRS
  • C_JOINTVENTUREAUDITQUERY.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • C_JOINTVENTUREAUDITQUERY.CUSTOMER == KNA1.KUNNR
  • C_JOINTVENTUREAUDITQUERY.MANDT == KNA1.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • Client
  • ?
  • C_JOINTVENTUREAUDITQUERY.MASTERFIXEDASSET == ANLA.ANLN1
  • C_JOINTVENTUREAUDITQUERY.FIXEDASSET == ANLA.ANLN2
  • C_JOINTVENTUREAUDITQUERY.MANDT == ANLA.MANDT
  • C_JOINTVENTUREAUDITQUERY.[column in domain "BUKRS"] == ANLA.BUKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_JOINTVENTUREAUDITQUERY.COMPANYCODE == SKB1.BUKRS
  • C_JOINTVENTUREAUDITQUERY.GLACCOUNT == SKB1.SAKNR
  • C_JOINTVENTUREAUDITQUERY.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • Client
  • ?
  • Joint venture
  • C_JOINTVENTUREAUDITQUERY.MANDT == T8JV.MANDT
  • C_JOINTVENTUREAUDITQUERY.[column in domain "BUKRS"] == T8JV.BUKRS
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTURE == T8JV.VNAME
Joint Venture Billing Type
  • Client
  • Joint Venture Billing Type
  • C_JOINTVENTUREAUDITQUERY.MANDT == T8JA.MANDT
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
Joint Venture Cost Recovery Code
  • Client
  • ?
  • Joint Venture Cost Recovery Code
  • C_JOINTVENTUREAUDITQUERY.MANDT == T8JJ.MANDT
  • C_JOINTVENTUREAUDITQUERY.[column in domain "BUKRS"] == T8JJ.BUKRS
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Equity group
  • Equity group
  • Client
  • ?
  • Joint venture
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_JOINTVENTUREAUDITQUERY.MANDT == T8JF.MANDT
  • C_JOINTVENTUREAUDITQUERY.[column in domain "BUKRS"] == T8JF.BUKRS
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTURE == T8JF.VNAME
Equity type
  • Client
  • ?
  • Equity type
  • C_JOINTVENTUREAUDITQUERY.MANDT == T8JE.MANDT
  • C_JOINTVENTUREAUDITQUERY.[column in domain "BUKRS"] == T8JE.BUKRS
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • C_JOINTVENTUREAUDITQUERY.MANDT == KNA1.MANDT
  • C_JOINTVENTUREAUDITQUERY.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Client
  • Order ID
  • C_JOINTVENTUREAUDITQUERY.MANDT == AUFK.MANDT
  • C_JOINTVENTUREAUDITQUERY.ORDERID == AUFK.AUFNR
Plant
  • Client
  • Plant
  • C_JOINTVENTUREAUDITQUERY.MANDT == T001W.MANDT
  • C_JOINTVENTUREAUDITQUERY.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • C_JOINTVENTUREAUDITQUERY.MANDT == MARA.MANDT
  • C_JOINTVENTUREAUDITQUERY.PRODUCT == MARA.MATNR
Profit Center
  • ?
  • Client
  • Controlling Area
  • Profit Center
  • C_JOINTVENTUREAUDITQUERY.[column in domain "DATBI"] == CEPC.DATBI
  • C_JOINTVENTUREAUDITQUERY.MANDT == CEPC.MANDT
  • C_JOINTVENTUREAUDITQUERY.CONTROLLINGAREA == CEPC.KOKRS
  • C_JOINTVENTUREAUDITQUERY.PROFITCENTER == CEPC.PRCTR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_JOINTVENTUREAUDITQUERY.PROJECTNETWORK == AUFK.AUFNR
  • C_JOINTVENTUREAUDITQUERY.MANDT == AUFK.MANDT
Sales Organization
  • Client
  • Sales Organization
  • C_JOINTVENTUREAUDITQUERY.MANDT == TVKO.MANDT
  • C_JOINTVENTUREAUDITQUERY.SALESORGANIZATION == TVKO.VKORG
Supplier
  • Client
  • Supplier
  • C_JOINTVENTUREAUDITQUERY.MANDT == LFA1.MANDT
  • C_JOINTVENTUREAUDITQUERY.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_JOINTVENTUREAUDITQUERY.MANDT == TCURC.MANDT
  • C_JOINTVENTUREAUDITQUERY.TRANSACTIONCURRENCY == TCURC.WAERS