I_GrossPartNetByCostCtrC

Gross Partner Net By Cost Center | view: IGRSSNETCOC | TRAN | 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, T8JJ, T8JV, FINSC_LEDGER, PROJ, LFA1, PRPS, SKAT, T004, T8JO, 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 YTD amount in Transaction Currency
ITDAmtInTC ITD amount in Transaction Currency
CurPerdNetAmtInTC Current period net amount in Transaction Currency
YTDNetAmtInTC YTD net amount in Transaction Currency
ITDNetAmtInTC ITD net amount in Transaction Currency
SuspShrAmtInTC Suspense share amount in Transaction Currency
NetProfitIntrstShrAmtInTC NPI share 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
CurPerdNetAmtInCCrcy Current period net amount in Company Currency
YTDNetAmtInCCrcy YTD net amount in Company Currency
ITDNetAmtInCCrcy ITD net amount in Company Currency
SuspShrAmtInCCrcy Suspense share amount in Company Currency
NetProfitIntrstShrAmtInCCrcy NPI share 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
CurPerdNetAmtInGCrcy Current period net amount in Global Currency
YTDNetAmtInGCrcy YTD net amount in Global Currency
ITDNetAmtInGCrcy ITD net amount in Global Currency
SuspShrAmtInGCrcy Suspense share amount in Global Currency
NetProfitIntrstShrAmtInGCrcy NPI share 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
CurPerdNetAmtInBlTCrcy Current period net amount in Balance Transaction Currency
YTDNetAmtInBlTCrcy YTD net amount in Balance Transaction Currency
ITDNetAmtInBlTCrcy ITD net amount in Balance Transaction Currency
SuspShrAmtInBlTCrcy Suspense share amount in Balance Transaction Currency
NetProfitIntrstShrAmtInBlTCrcy NPI share 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
CurPerdNetAmtInFDCrcy1 Current period net amount in Free Defined Currency 1
YTDNetAmtInFDCrcy1 YTD net amount in Free Defined Currency 1
ITDNetAmtInFDCrcy1 ITD net amount in Free Defined Currency 1
SuspShrAmtInFDCrcy1 Suspense share amount in Free Defined Currency 1
NetProfitIntrstShrAmtInFDCrcy1 NPI share amount in Free Defined Currency 1
CurPerdNetAmtInFDCrcy2 Current period net amount in Free Defined Currency 2
💲 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
YTDNetAmtInFDCrcy2 YTD net amount in Free Defined Currency 2
ITDNetAmtInFDCrcy2 ITD net amount in Free Defined Currency 2
SuspShrAmtInFDCrcy2 Suspense share amount in Free Defined Currency 2
NetProfitIntrstShrAmtInFDCrcy2 NPI share amount in Free Defined Currency 2
YearToDateAmountInFDCrcy4 YTD amount in Free Defined Currency 4
💲 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
CurPerdNetAmtInFDCrcy3 Current period net amount in Free Defined Currency 3
YTDNetAmtInFDCrcy3 YTD net amount in Free Defined Currency 3
ITDNetAmtInFDCrcy3 ITD net amount in Free Defined Currency 3
SuspShrAmtInFDCrcy3 Suspense share amount in Free Defined Currency 3
NetProfitIntrstShrAmtInFDCrcy3 NPI share amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
CurPerdAmtInFDCrcy4 Current period amount in Free Defined Currency 4
ITDAmtInFDCrcy4 ITD amount in Free Defined Currency 4
CurPerdNetAmtInFDCrcy4 Current period net amount in Free Defined Currency 4
YTDNetAmtInFDCrcy4 YTD net amount in Free Defined Currency 4
ITDNetAmtInFDCrcy4 ITD net amount in Free Defined Currency 4
SuspShrAmtInFDCrcy4 Suspense share amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
NetProfitIntrstShrAmtInFDCrcy4 NPI share amount in Free Defined Currency 4
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
CurPerdNetAmtInFDCrcy5 Current period net amount in Free Defined Currency 5
YTDNetAmtInFDCrcy5 YTD net amount in Free Defined Currency 5
ITDNetAmtInFDCrcy5 ITD net amount in Free Defined Currency 5
SuspShrAmtInFDCrcy5 Suspense share amount in Free Defined Currency 5
NetProfitIntrstShrAmtInFDCrcy5 NPI share 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
CurPerdNetAmtInFDCrcy6 Current period net amount in Free Defined Currency 6
YTDNetAmtInFDCrcy6 YTD net amount in Free Defined Currency 6
ITDNetAmtInFDCrcy6 ITD net amount in Free Defined Currency 6
SuspShrAmtInFDCrcy6 Suspense share amount in Free Defined Currency 6
NetProfitIntrstShrAmtInFDCrcy6 NPI share 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
CurPerdNetAmtInFDCrcy7 Current period net amount in Free Defined Currency 7
YTDNetAmtInFDCrcy7 YTD net amount in Free Defined Currency 7
ITDNetAmtInFDCrcy7 ITD net amount in Free Defined Currency 7
SuspShrAmtInFDCrcy7 Suspense share amount in Free Defined Currency 7
NetProfitIntrstShrAmtInFDCrcy7 NPI share 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
CurPerdNetAmtInFDCrcy8 Current period net amount in Free Defined Currency 8
YTDNetAmtInFDCrcy8 YTD net amount in Free Defined Currency 8
ITDNetAmtInFDCrcy8 ITD net amount in Free Defined Currency 8
SuspShrAmtInFDCrcy8 Suspense share amount in Free Defined Currency 8
NetProfitIntrstShrAmtInFDCrcy8 NPI share 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
JntVntrInterestType Interest 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
JntVntrOperatedShare Operated Share JV_SHARE
JntVntrEquityShare Equity Share JV_SHARE
JointVenturePartner Joint Venture Partner KUNNR
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T003.MANDT
Asset Class
  • Asset Class
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.ASSETCLASS == ANKA.ANLKL
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == ANKA.MANDT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.ASSETTRANSACTIONTYPE == TABW.BWASL
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TABW.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.BASEUNIT == T006.MSEHI
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.BUSINESSAREA == TGSB.GSBER
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.CHARTOFACCOUNTS == T004.KTOPL
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T001.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.COMPANYCODECURRENCY == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TKA01.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "DATBI"] == CSKS.DATBI
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == CSKS.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.CONTROLLINGAREA == CSKS.KOKRS
  • I_GROSSPARTNETBYCOSTCTRC.COSTCENTER == CSKS.KOSTL
Customer Number
  • Customer Number
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.CUSTOMER == KNA1.KUNNR
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TVTW.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FISCALYEARVARIANT == T009.PERIV
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • ?
  • Client
  • Asset Subnumber
  • I_GROSSPARTNETBYCOSTCTRC.MASTERFIXEDASSET == ANLA.ANLN1
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == ANLA.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_GROSSPARTNETBYCOSTCTRC.GLACCOUNT == SKB1.SAKNR
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == SKB1.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.GLOBALCURRENCY == TCURC.WAERS
Joint venture
  • Joint venture
  • ?
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTURE == T8JV.VNAME
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T8JV.MANDT
Joint Venture Billing Type
  • Joint Venture Billing Type
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T8JA.MANDT
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • Joint venture
  • ?
  • Joint Venture Equity Group
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTURE == T8JF.VNAME
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T8JF.MANDT
Joint Venture Equity Type
  • Joint Venture Equity Type
  • ?
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == T8JE.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T8JE.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Operator
  • ?
  • Client
  • Operator
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "BUKRS"] == KNB1.BUKRS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == KNB1.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.OPERATOR == KNB1.KUNNR
Order ID
  • Order ID
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.ORDERID == AUFK.AUFNR
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TSPA.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T001W.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.PLANT == T001W.WERKS
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "DATBI"] == CEPC.DATBI
  • I_GROSSPARTNETBYCOSTCTRC.PROFITCENTER == CEPC.PRCTR
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == CEPC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.CONTROLLINGAREA == CEPC.KOKRS
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.PROJECTNETWORK == AUFK.AUFNR
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == AUFK.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.SALESORGANIZATION == TVKO.VKORG
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == FAGL_SEGM.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • ?
  • Service Document Type
  • Service Document ID
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == FCO_SRVDOC.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GROSSPARTNETBYCOSTCTRC.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GROSSPARTNETBYCOSTCTRC.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Client
  • Service Document Type
Supplier
  • Client
  • Supplier
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == LFA1.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • I_GROSSPARTNETBYCOSTCTRC.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == TCURC.MANDT
Valuation area
  • Client
  • Valuation area
  • I_GROSSPARTNETBYCOSTCTRC.MANDT == T001K.MANDT
  • I_GROSSPARTNETBYCOSTCTRC.VALUATIONAREA == T001K.BWKEY