C_JntVntrGrssNonOprtdQ

Gross Non-Operated by Cost Object | view: CJVGRSNOPRQ | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, KNA1, SKA1, T8J9B, T8J9A, T8JS, T8JV, FINSC_LEDGER, PROJ, LFA1, PRPS, SKAT, T004, 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
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Master Data Relations Join Conditions
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TABW.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T006.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TGSB.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T001.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TKA01.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • Controlling Area
  • ?
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == CSKS.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.COSTCENTER == CSKS.KOSTL
  • C_JNTVNTRGRSSNONOPRTDQ.CONTROLLINGAREA == CSKS.KOKRS
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "DATBI"] == CSKS.DATBI
Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • Asset Subnumber
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == ANLA.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.MASTERFIXEDASSET == ANLA.ANLN1
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_JNTVNTRGRSSNONOPRTDQ.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == SKB1.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.GLACCOUNT == SKB1.SAKNR
  • C_JNTVNTRGRSSNONOPRTDQ.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • Client
  • ?
  • Joint venture
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T8JV.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "BUKRS"] == T8JV.BUKRS
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTURE == T8JV.VNAME
Joint Venture Billing Type
  • Joint Venture Billing Type
  • Client
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T8JA.MANDT
Joint Venture Cost Recovery Code
  • Client
  • Joint Venture Cost Recovery Code
  • ?
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T8JJ.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "BUKRS"] == T8JJ.BUKRS
Joint Venture Equity Group
  • Joint Venture Equity Group
  • Client
  • ?
  • Joint venture
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T8JF.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "BUKRS"] == T8JF.BUKRS
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTURE == T8JF.VNAME
Joint Venture Equity Type
  • Joint Venture Equity Type
  • Client
  • ?
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == T8JE.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "BUKRS"] == T8JE.BUKRS
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == KNA1.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.JOINTVENTUREPARTNER == KNA1.KUNNR
Order ID
  • Client
  • Order ID
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == AUFK.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.ORDERID == AUFK.AUFNR
Profit Center
  • Profit Center
  • Client
  • Controlling Area
  • ?
  • C_JNTVNTRGRSSNONOPRTDQ.PROFITCENTER == CEPC.PRCTR
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == CEPC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.CONTROLLINGAREA == CEPC.KOKRS
  • C_JNTVNTRGRSSNONOPRTDQ.[column in domain "DATBI"] == CEPC.DATBI
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • C_JNTVNTRGRSSNONOPRTDQ.PROJECTNETWORK == AUFK.AUFNR
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == AUFK.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • C_JNTVNTRGRSSNONOPRTDQ.MANDT == TCURC.MANDT
  • C_JNTVNTRGRSSNONOPRTDQ.TRANSACTIONCURRENCY == TCURC.WAERS