C_InventoryGLAcctBalCube

Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
SourceLedger FK Source Ledger
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
Column Name Description
📏 Cost Source Unit (BaseUnit):
InventoryQty Inventory Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
Cheque Check Number BOENUM
GLAccountName null
ReconciliationAccountType null
GLAccountLongName G/L Account Long Text TEXT50
SalesDocumentItem Sales Document Item POSNR
InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID FIS_WBSINT_NO_CONV
Master Data Relations Join Conditions
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_INVENTORYGLACCTBALCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • C_INVENTORYGLACCTBALCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_INVENTORYGLACCTBALCUBE.MANDT == SKA1.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • C_INVENTORYGLACCTBALCUBE.BASEUNIT == T006.MSEHI
  • C_INVENTORYGLACCTBALCUBE.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • C_INVENTORYGLACCTBALCUBE.BUSINESSAREA == TGSB.GSBER
  • C_INVENTORYGLACCTBALCUBE.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • C_INVENTORYGLACCTBALCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALCUBE.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_INVENTORYGLACCTBALCUBE.COMPANYCODE == T001.BUKRS
  • C_INVENTORYGLACCTBALCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_INVENTORYGLACCTBALCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_INVENTORYGLACCTBALCUBE.MANDT == TCURC.MANDT
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • C_INVENTORYGLACCTBALCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALCUBE.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALCUBE.MANDT == T004.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • C_INVENTORYGLACCTBALCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALCUBE.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • C_INVENTORYGLACCTBALCUBE.CUSTOMER == KNA1.KUNNR
  • C_INVENTORYGLACCTBALCUBE.MANDT == KNA1.MANDT
Asset Subnumber
  • Asset Subnumber
  • ?
  • Fixed Asset
  • Client
  • C_INVENTORYGLACCTBALCUBE.FIXEDASSET == ANLA.ANLN2
  • C_INVENTORYGLACCTBALCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_INVENTORYGLACCTBALCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • C_INVENTORYGLACCTBALCUBE.MANDT == ANLA.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_INVENTORYGLACCTBALCUBE.GLACCOUNT == SKB1.SAKNR
  • C_INVENTORYGLACCTBALCUBE.COMPANYCODE == SKB1.BUKRS
  • C_INVENTORYGLACCTBALCUBE.MANDT == SKB1.MANDT
G/L Account Group
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • G/L Account Group
  • C_INVENTORYGLACCTBALCUBE.CHARTOFACCOUNTS == T077S.KTOPL
  • C_INVENTORYGLACCTBALCUBE.CORPORATEGROUPCHARTOFACCOUNTS == T077S.KTOPL
  • C_INVENTORYGLACCTBALCUBE.MANDT == T077S.MANDT
  • C_INVENTORYGLACCTBALCUBE.GLACCOUNTGROUP == T077S.KTOKS
Ledger
  • Client
  • Ledger
  • Source Ledger
Product (Deprecated)
  • Product (Deprecated)
  • Client
  • C_INVENTORYGLACCTBALCUBE.MATERIAL == MARA.MATNR
  • C_INVENTORYGLACCTBALCUBE.MANDT == MARA.MANDT
Source Ledger
  • Ledger
  • Source Ledger
  • Client
Reporting Entity
  • Client
  • Reporting Entity
  • C_INVENTORYGLACCTBALCUBE.MANDT == SRF_RPG_ENT.MANDT
  • C_INVENTORYGLACCTBALCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Supplier
  • Client
  • C_INVENTORYGLACCTBALCUBE.SUPPLIER == LFA1.LIFNR
  • C_INVENTORYGLACCTBALCUBE.MANDT == LFA1.MANDT
Valuation area
  • Valuation area
  • Client
  • C_INVENTORYGLACCTBALCUBE.VALUATIONAREA == T001K.BWKEY
  • C_INVENTORYGLACCTBALCUBE.MANDT == T001K.MANDT