I_JointVentureAcctgExtDetail

Joint Venture Accounting Extended Detail | view: IPVJVACCTGEXTDTL | TRAN | Extraction: Full only | 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
💲 Currency Key (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Value in local currency
💲 Currency Key (GlobalCurrency):
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
  • I_JOINTVENTUREACCTGEXTDETAIL.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T003.MANDT
Activity Type
  • Client
  • Posting Date in the Document
  • Activity Type
  • Controlling Area
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == CSLA.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.POSTINGDATE == CSLA.DATBI
  • I_JOINTVENTUREACCTGEXTDETAIL.ACTIVITYTYPE == CSLA.LSTAR
  • I_JOINTVENTUREACCTGEXTDETAIL.CONTROLLINGAREA == CSLA.KOKRS
Additional unit of measure
  • Client
  • Additional unit of measure
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T006.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.ADDITIONALQUANTITY1UNIT == T006.MSEHI
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == TABW.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.ASSETTRANSACTIONTYPE == TABW.BWASL
Business area
  • Client
  • Business Area
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == TGSB.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_JOINTVENTUREACCTGEXTDETAIL.CHARTOFACCOUNTS == T004.KTOPL
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T001.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == TKA01.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Posting Date in the Document
  • Cost Center
  • Controlling Area
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == CSKS.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.POSTINGDATE == CSKS.DATBI
  • I_JOINTVENTUREACCTGEXTDETAIL.COSTCENTER == CSKS.KOSTL
  • I_JOINTVENTUREACCTGEXTDETAIL.CONTROLLINGAREA == CSKS.KOKRS
Currency Key
  • Client
  • Currency Key
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == TCURC.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.CURRENCY == TCURC.WAERS
Asset Subnumber
  • Asset Subnumber
  • Client
  • Main Asset Number
  • Company Code
  • I_JOINTVENTUREACCTGEXTDETAIL.FIXEDASSET == ANLA.ANLN2
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == ANLA.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.MASTERFIXEDASSET == ANLA.ANLN1
  • I_JOINTVENTUREACCTGEXTDETAIL.COMPANYCODE == ANLA.BUKRS
G/L account number
  • Client
  • Account Number
  • ?
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == SKA1.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.GLACCOUNT == SKA1.SAKNR
  • I_JOINTVENTUREACCTGEXTDETAIL.[column in domain "KTOPL"] == SKA1.KTOPL
Internal Order
  • Internal Order
  • Client
  • I_JOINTVENTUREACCTGEXTDETAIL.INTERNALORDER == AUFK.AUFNR
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == AUFK.MANDT
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T8JV.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.JOINTVENTURE == T8JV.VNAME
  • I_JOINTVENTUREACCTGEXTDETAIL.COMPANYCODE == T8JV.BUKRS
Equity group
  • Client
  • Equity group
  • Joint venture
  • Company Code
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T8JF.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_JOINTVENTUREACCTGEXTDETAIL.JOINTVENTURE == T8JF.VNAME
  • I_JOINTVENTUREACCTGEXTDETAIL.COMPANYCODE == T8JF.BUKRS
Recovery Indicator
  • Client
  • Recovery Indicator
  • Company Code
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T8JJ.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.JOINTVENTURERECOVERYCODE == T8JJ.RECID
  • I_JOINTVENTUREACCTGEXTDETAIL.COMPANYCODE == T8JJ.BUKRS
Ledger
  • Client
  • Ledger
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T881.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.LEDGER == T881.RLDNR
Material Number
  • Client
  • Material Number
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == MARA.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.MATERIAL == MARA.MATNR
Order Number
  • Client
  • Order Number
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == AUFK.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.ORIGINORDER == AUFK.AUFNR
Partner account number
  • Client
  • Partner account number
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == KNA1.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.PARTNER == KNA1.KUNNR
Billing indicator
  • Client
  • Payroll Type
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T8JA.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.PAYROLLTYPE == T8JA.BILIND
Version
  • Client
  • Ledger
  • Version
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T894.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.LEDGER == T894.RLDNR
  • I_JOINTVENTUREACCTGEXTDETAIL.SPECIALLEDGERVERSION == T894.RVERS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • I_JOINTVENTUREACCTGEXTDETAIL.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_JOINTVENTUREACCTGEXTDETAIL.[column in domain "KVEWE"] == T683.KVEWE
  • I_JOINTVENTUREACCTGEXTDETAIL.[column in domain "KAPPL"] == T683.KAPPL
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T683.MANDT
Tax code
  • Client
  • Tax on sales/purchases code
  • ?
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T007A.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.TAXCODE == T007A.MWSKZ
  • I_JOINTVENTUREACCTGEXTDETAIL.[column in domain "KALSM_D"] == T007A.KALSM
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_JOINTVENTUREACCTGEXTDETAIL.MANDT == T006.MANDT
  • I_JOINTVENTUREACCTGEXTDETAIL.UNITOFMEASURE == T006.MSEHI