C_JointVentureAcctgDtlHierQry

Joint Venture Acctg Dtl Hierarchy Query | view: CPVJVADTLHIERQRY | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: JVSO1, T004, T001, TKA02, T005, SKA1, FINSC_LD_CMP
Column Name Description
JointVentureLineItem Joint Venture Record Number
Column Name Description
💲 Currency Key (Currency):
AmountInTransactionCurrency Amount in Transaction Currency
AmountInCompanyCodeCurrency Value in local currency
AmountInGlobalCurrency Value in group currency
Column Name Description
📏 Base Unit of Measure (UnitOfMeasure):
QuantityInBaseUnit Quantity in Base Unit
Column Name Description
PostingDate Posting Date in the Document
ValDateForCurrencyTranslation Value Date for Currency Translation
ValueDate Value date
DocumentDate Document Date in Document
TimeEntry Time of Entry
BillingMonth Billing Month
StartDate Start Date
ProductionMonth Production Month (Date to find period and year)
Column Name Description
RecordType Record Type Show values
DebitCreditCode Debit/Credit Code Show values
DocumentType Document Category Show values
GLAccountType Type of a General Ledger Account Show values
ReferenceDocumentType Reference Doc Type Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
LedgerFiscalPeriod Posting period POPER
AccountingDocument Accounting Document BELNR
AccountingDocumentItem Line Item in Joint Venture Document BUZEI
ProfitCenter Profit Center PRCTR
NetworkActivity Operation/Activity Number VORNR
DocumentItemText Description of Line Item TEXT50
IsAutomaticallyPosted Automatic Posting TEXT1
BusinessTransactionType Business Transaction Type CHAR4
RefAccountingDocument Ref Accounting Document BELNR
ReferenceDocumentFiscalYear Reference Doc Year GJAHR
RefJntVentureDocumentLineItem Ref JV Document Item NUMC5
BusinessTransactionDocItem Business Transaction CHAR4
RefAccountingDocumentItem Ref Accounting Document Line Item BUZEI
AccountingDocCreatedByUser Created By XUBNAME
TransactionTypeDetermination Transaction Key CHAR3
AllocationFrequency Allocation/cycle CYCLE
ReferenceDocument Reference Document Number AWREF
ReferenceBillingDocument Ref Billing Document BELNR
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
PaymentTerms Terms of payment key ZTERM
Master Data Relations Join Conditions
Document type
  • Accounting Document Type
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T003.MANDT
Activity Type
  • Controlling Area
  • Posting Date in the Document
  • Activity Type
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.CONTROLLINGAREA == CSLA.KOKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.POSTINGDATE == CSLA.DATBI
  • C_JOINTVENTUREACCTGDTLHIERQRY.ACTIVITYTYPE == CSLA.LSTAR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == CSLA.MANDT
Additional unit of measure
  • Additional unit of measure
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.ADDITIONALQUANTITY1UNIT == T006.MSEHI
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T006.MANDT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.ASSETTRANSACTIONTYPE == TABW.BWASL
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == TABW.MANDT
Business area
  • Business Area
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.BUSINESSAREA == TGSB.GSBER
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.CHARTOFACCOUNTS == T004.KTOPL
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.COMPANYCODE == T001.BUKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.CONTROLLINGAREA == TKA01.KOKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • Posting Date in the Document
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.COSTCENTER == CSKS.KOSTL
  • C_JOINTVENTUREACCTGDTLHIERQRY.CONTROLLINGAREA == CSKS.KOKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.POSTINGDATE == CSKS.DATBI
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == CSKS.MANDT
Currency Key
  • Currency Key
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.CURRENCY == TCURC.WAERS
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == TCURC.MANDT
Asset Subnumber
  • Main Asset Number
  • Asset Subnumber
  • Company Code
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.MASTERFIXEDASSET == ANLA.ANLN1
  • C_JOINTVENTUREACCTGDTLHIERQRY.FIXEDASSET == ANLA.ANLN2
  • C_JOINTVENTUREACCTGDTLHIERQRY.COMPANYCODE == ANLA.BUKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == ANLA.MANDT
G/L account number
  • Account Number
  • ?
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.GLACCOUNT == SKA1.SAKNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == SKA1.MANDT
Internal Order
  • Internal Order
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.INTERNALORDER == AUFK.AUFNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == AUFK.MANDT
Joint venture
  • Company Code
  • Joint venture
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.COMPANYCODE == T8JV.BUKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.JOINTVENTURE == T8JV.VNAME
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T8JV.MANDT
Equity group
  • Equity group
  • Company Code
  • Joint venture
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_JOINTVENTUREACCTGDTLHIERQRY.COMPANYCODE == T8JF.BUKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.JOINTVENTURE == T8JF.VNAME
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T8JF.MANDT
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.JOINTVENTURERECOVERYCODE == T8JJ.RECID
  • C_JOINTVENTUREACCTGDTLHIERQRY.COMPANYCODE == T8JJ.BUKRS
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T8JJ.MANDT
Ledger
  • Ledger
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.LEDGER == T881.RLDNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T881.MANDT
Material Number
  • Material Number
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.MATERIAL == MARA.MATNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == MARA.MANDT
Order Number
  • Order Number
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.ORIGINORDER == AUFK.AUFNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == AUFK.MANDT
Partner account number
  • Partner account number
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.PARTNER == KNA1.KUNNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == KNA1.MANDT
Billing indicator
  • Payroll Type
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.PAYROLLTYPE == T8JA.BILIND
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T8JA.MANDT
Version
  • Ledger
  • Client
  • Version
  • C_JOINTVENTUREACCTGDTLHIERQRY.LEDGER == T894.RLDNR
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T894.MANDT
  • C_JOINTVENTUREACCTGDTLHIERQRY.SPECIALLEDGERVERSION == T894.RVERS
Tax code
  • Tax on sales/purchases code
  • ?
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.TAXCODE == T007A.MWSKZ
  • C_JOINTVENTUREACCTGDTLHIERQRY.[column in domain "KALSM_D"] == T007A.KALSM
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T007A.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_JOINTVENTUREACCTGDTLHIERQRY.UNITOFMEASURE == T006.MSEHI
  • C_JOINTVENTUREACCTGDTLHIERQRY.MANDT == T006.MANDT