C_VntrEquityGrpBillgIndQ

Partner Billing Report | view: CJVBILLGQ | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: SCAL_TT_DATE, ACDOCA, BUT000, T004, T001, TKA02, KNA1, SKA1, T8JS, T8JF, T8JFT, T8JQ, T8JV, FINSC_LEDGER, PROJ, LFA1, PRPS, SKAT, T004, T8JO, T8JZ, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CurPerdAmtInTC Current period amount in Transaction Currency
YrToDteAmtInTransacCrcy YTD amount in Transaction Currency
ITDAmtInTC ITD amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
CurPerdAmtInCCrcy Current period amount in Company Currency
YearToDateAmountInCoCodeCrcy YTD amount in Company Currency
ITDAmtInCCrcy ITD amount in Company Currency
💲 Global Currency (GlobalCurrency):
CurPerdAmtInGCrcy Current period amount in Global Currency
YearToDateAmountInGlobalCrcy YTD amount in Global Currency
ITDAmtInGCrcy ITD amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
CurPerdAmtInBlTCrcy Current period amount in Balance Transaction Currency
YearToDateAmountInBalTransCrcy YTD amount in Balance Transaction Currency
ITDAmtInBlTCrcy ITD amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
CurPerdAmtInFDCrcy1 Current period amount in Free Defined Currency 1
YearToDateAmountInFDCrcy1 YTD amount in Free Defined Currency 1
ITDAmtInFDCrcy1 ITD amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
CurPerdAmtInFDCrcy2 Current period amount in Free Defined Currency 2
YearToDateAmountInFDCrcy2 YTD amount in Free Defined Currency 2
ITDAmtInFDCrcy2 ITD amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
CurPerdAmtInFDCrcy3 Current period amount in Free Defined Currency 3
YearToDateAmountInFDCrcy3 YTD amount in Free Defined Currency 3
ITDAmtInFDCrcy3 ITD amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
CurPerdAmtInFDCrcy4 Current period amount in Free Defined Currency 4
YearToDateAmountInFDCrcy4 YTD amount in Free Defined Currency 4
ITDAmtInFDCrcy4 ITD amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
CurPerdAmtInFDCrcy5 Current period amount in Free Defined Currency 5
YearToDateAmountInFDCrcy5 YTD amount in Free Defined Currency 5
ITDAmtInFDCrcy5 ITD amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
CurPerdAmtInFDCrcy6 Current period amount in Free Defined Currency 6
YearToDateAmountInFDCrcy6 YTD amount in Free Defined Currency 6
ITDAmtInFDCrcy6 ITD amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
CurPerdAmtInFDCrcy7 Current period amount in Free Defined Currency 7
YearToDateAmountInFDCrcy7 YTD amount in Free Defined Currency 7
ITDAmtInFDCrcy7 ITD amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
CurPerdAmtInFDCrcy8 Current period amount in Free Defined Currency 8
YearToDateAmountInFDCrcy8 YTD amount in Free Defined Currency 8
ITDAmtInFDCrcy8 ITD amount in Free Defined Currency 8
Column Name Description
Column Name Description
Column Name Description
JointVentureType Venture Type Show values
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
JointVenturePartner null
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
JntVntrOperatedShare null
JntVntrEquityShare null
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TABW.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T006.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TGSB.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T001.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TKA01.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • ?
  • Cost Center
  • Controlling Area
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == CSKS.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_VNTREQUITYGRPBILLGINDQ.COSTCENTER == CSKS.KOSTL
  • C_VNTREQUITYGRPBILLGINDQ.CONTROLLINGAREA == CSKS.KOKRS
Asset Subnumber
  • Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • C_VNTREQUITYGRPBILLGINDQ.FIXEDASSET == ANLA.ANLN2
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == ANLA.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.MASTERFIXEDASSET == ANLA.ANLN1
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == SKB1.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.GLACCOUNT == SKB1.SAKNR
  • C_VNTREQUITYGRPBILLGINDQ.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • ?
  • Client
  • Joint venture
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "BUKRS"] == T8JV.BUKRS
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T8JV.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTURE == T8JV.VNAME
Joint Venture Billing Type
  • Client
  • Joint Venture Billing Type
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T8JA.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
Joint Venture Cost Recovery Code
  • ?
  • Client
  • Joint Venture Cost Recovery Code
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "BUKRS"] == T8JJ.BUKRS
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T8JJ.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • ?
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "BUKRS"] == T8JF.BUKRS
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T8JF.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTURE == T8JF.VNAME
Joint Venture Equity Type
  • ?
  • Client
  • Joint Venture Equity Type
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "BUKRS"] == T8JE.BUKRS
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == T8JE.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Order ID
  • Client
  • Order ID
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == AUFK.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.ORDERID == AUFK.AUFNR
Profit Center
  • Profit Center
  • Client
  • ?
  • Controlling Area
  • C_VNTREQUITYGRPBILLGINDQ.PROFITCENTER == CEPC.PRCTR
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == CEPC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.[column in domain "DATBI"] == CEPC.DATBI
  • C_VNTREQUITYGRPBILLGINDQ.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == AUFK.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.PROJECTNETWORK == AUFK.AUFNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_VNTREQUITYGRPBILLGINDQ.MANDT == TCURC.MANDT
  • C_VNTREQUITYGRPBILLGINDQ.TRANSACTIONCURRENCY == TCURC.WAERS