I_GrossBillByVntrC

Gross Bill By Venture Cube | view: IGRSSBILLJVC | TRAN | Extraction: Not supported | Component: Joint Venture und Production Sharing Accounting
Tables used: SCAL_TT_DATE, ACDOCA, T004, T001, TKA02, KNA1, SKA1, T8JS, T8JV, FINSC_LEDGER, PROJ, LFA1, PRPS, SKAT, T004, T8JZ, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
CurPerdAmtInTC Current period amount in Transaction Currency
YrToDteAmtInTransacCrcy Current period amount in Transaction Currency
ITDAmtInTC ITD amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
CurPerdAmtInCCrcy Current period amount in Transaction Currency
YearToDateAmountInCoCodeCrcy Current period amount in Transaction Currency
ITDAmtInCCrcy ITD amount in Company Currency
💲 Global Currency (GlobalCurrency):
CurPerdAmtInGCrcy Current period amount in Transaction Currency
YearToDateAmountInGlobalCrcy Current period amount in Transaction Currency
ITDAmtInGCrcy ITD amount in Global Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
CurPerdAmtInBlTCrcy Current period amount in Transaction Currency
YearToDateAmountInBalTransCrcy Current period amount in Transaction Currency
ITDAmtInBlTCrcy ITD amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
CurPerdAmtInFDCrcy1 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy1 Current period amount in Transaction Currency
ITDAmtInFDCrcy1 ITD amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
CurPerdAmtInFDCrcy2 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy2 Current period amount in Transaction Currency
ITDAmtInFDCrcy2 ITD amount in Free Defined Currency 2
YearToDateAmountInFDCrcy4 Current period amount in Transaction Currency
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
CurPerdAmtInFDCrcy3 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy3 Current period amount in Transaction Currency
ITDAmtInFDCrcy3 ITD amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
CurPerdAmtInFDCrcy4 Current period amount in Transaction Currency
ITDAmtInFDCrcy4 ITD amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
CurPerdAmtInFDCrcy5 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy5 Current period amount in Transaction Currency
ITDAmtInFDCrcy5 ITD amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
CurPerdAmtInFDCrcy6 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy6 Current period amount in Transaction Currency
ITDAmtInFDCrcy6 ITD amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
CurPerdAmtInFDCrcy7 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy7 Current period amount in Transaction Currency
ITDAmtInFDCrcy7 ITD amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
CurPerdAmtInFDCrcy8 Current period amount in Transaction Currency
YearToDateAmountInFDCrcy8 Current period amount in Transaction Currency
ITDAmtInFDCrcy8 ITD amount in Free Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
Column Name Description
Column Name Description
GLRecordType Record Type Show values
DebitCreditCode Debit/Credit Code Show values
JointVentureType Venture Type Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
LedgerFiscalYear Ledger Fiscal Year GJAHR
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
JointVenturePartner Joint Venture Partner KUNNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_GROSSBILLBYVNTRC.MANDT == T003.MANDT
  • I_GROSSBILLBYVNTRC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Asset Class
  • Client
  • I_GROSSBILLBYVNTRC.ASSETCLASS == ANKA.ANLKL
  • I_GROSSBILLBYVNTRC.MANDT == ANKA.MANDT
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • I_GROSSBILLBYVNTRC.MANDT == TABW.MANDT
  • I_GROSSBILLBYVNTRC.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_GROSSBILLBYVNTRC.MANDT == T006.MANDT
  • I_GROSSBILLBYVNTRC.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • I_GROSSBILLBYVNTRC.MANDT == TGSB.MANDT
  • I_GROSSBILLBYVNTRC.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_GROSSBILLBYVNTRC.MANDT == T004.MANDT
  • I_GROSSBILLBYVNTRC.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_GROSSBILLBYVNTRC.MANDT == T001.MANDT
  • I_GROSSBILLBYVNTRC.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_GROSSBILLBYVNTRC.MANDT == TKA01.MANDT
  • I_GROSSBILLBYVNTRC.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • I_GROSSBILLBYVNTRC.MANDT == CSKS.MANDT
  • I_GROSSBILLBYVNTRC.COSTCENTER == CSKS.KOSTL
  • I_GROSSBILLBYVNTRC.[column in domain "DATBI"] == CSKS.DATBI
  • I_GROSSBILLBYVNTRC.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Customer Number
  • Client
  • I_GROSSBILLBYVNTRC.CUSTOMER == KNA1.KUNNR
  • I_GROSSBILLBYVNTRC.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_GROSSBILLBYVNTRC.MANDT == TVTW.MANDT
  • I_GROSSBILLBYVNTRC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_GROSSBILLBYVNTRC.MANDT == T009.MANDT
  • I_GROSSBILLBYVNTRC.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • I_GROSSBILLBYVNTRC.FIXEDASSET == ANLA.ANLN2
  • I_GROSSBILLBYVNTRC.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_GROSSBILLBYVNTRC.MANDT == ANLA.MANDT
  • I_GROSSBILLBYVNTRC.MASTERFIXEDASSET == ANLA.ANLN1
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_GROSSBILLBYVNTRC.MANDT == SKB1.MANDT
  • I_GROSSBILLBYVNTRC.GLACCOUNT == SKB1.SAKNR
  • I_GROSSBILLBYVNTRC.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • ?
  • Client
  • Joint venture
  • I_GROSSBILLBYVNTRC.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_GROSSBILLBYVNTRC.MANDT == T8JV.MANDT
  • I_GROSSBILLBYVNTRC.JOINTVENTURE == T8JV.VNAME
Joint Venture Billing Type
  • Client
  • Joint Venture Billing Type
  • I_GROSSBILLBYVNTRC.MANDT == T8JA.MANDT
  • I_GROSSBILLBYVNTRC.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
Joint Venture Cost Recovery Code
  • ?
  • Client
  • Joint Venture Cost Recovery Code
  • I_GROSSBILLBYVNTRC.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_GROSSBILLBYVNTRC.MANDT == T8JJ.MANDT
  • I_GROSSBILLBYVNTRC.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Joint Venture Equity Group
  • ?
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • I_GROSSBILLBYVNTRC.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_GROSSBILLBYVNTRC.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_GROSSBILLBYVNTRC.MANDT == T8JF.MANDT
  • I_GROSSBILLBYVNTRC.JOINTVENTURE == T8JF.VNAME
Joint Venture Equity Type
  • ?
  • Client
  • Joint Venture Equity Type
  • I_GROSSBILLBYVNTRC.[column in domain "BUKRS"] == T8JE.BUKRS
  • I_GROSSBILLBYVNTRC.MANDT == T8JE.MANDT
  • I_GROSSBILLBYVNTRC.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Order ID
  • Client
  • Order ID
  • I_GROSSBILLBYVNTRC.MANDT == AUFK.MANDT
  • I_GROSSBILLBYVNTRC.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_GROSSBILLBYVNTRC.MANDT == TSPA.MANDT
  • I_GROSSBILLBYVNTRC.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • I_GROSSBILLBYVNTRC.MANDT == T001W.MANDT
  • I_GROSSBILLBYVNTRC.PLANT == T001W.WERKS
Profit Center
  • Client
  • Profit Center
  • ?
  • Controlling Area
  • I_GROSSBILLBYVNTRC.MANDT == CEPC.MANDT
  • I_GROSSBILLBYVNTRC.PROFITCENTER == CEPC.PRCTR
  • I_GROSSBILLBYVNTRC.[column in domain "DATBI"] == CEPC.DATBI
  • I_GROSSBILLBYVNTRC.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Client
  • Network Number for Account Assignment
  • I_GROSSBILLBYVNTRC.MANDT == AUFK.MANDT
  • I_GROSSBILLBYVNTRC.PROJECTNETWORK == AUFK.AUFNR
Sales Organization
  • Client
  • Sales Organization
  • I_GROSSBILLBYVNTRC.MANDT == TVKO.MANDT
  • I_GROSSBILLBYVNTRC.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GROSSBILLBYVNTRC.MANDT == FAGL_SEGM.MANDT
  • I_GROSSBILLBYVNTRC.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • Service Document ID
  • Service Document Type
  • ?
  • I_GROSSBILLBYVNTRC.MANDT == FCO_SRVDOC.MANDT
  • I_GROSSBILLBYVNTRC.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_GROSSBILLBYVNTRC.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GROSSBILLBYVNTRC.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
Service Document Type
  • Client
  • Service Document Type
Supplier
  • Client
  • Supplier
  • I_GROSSBILLBYVNTRC.MANDT == LFA1.MANDT
  • I_GROSSBILLBYVNTRC.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Client
  • Transaction Currency
  • I_GROSSBILLBYVNTRC.MANDT == TCURC.MANDT
  • I_GROSSBILLBYVNTRC.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • I_GROSSBILLBYVNTRC.MANDT == T001K.MANDT
  • I_GROSSBILLBYVNTRC.VALUATIONAREA == T001K.BWKEY