C_InventoryGLAcctBalQuery

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
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
  • Client
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • C_INVENTORYGLACCTBALQUERY.MANDT == SKA1.MANDT
  • C_INVENTORYGLACCTBALQUERY.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • C_INVENTORYGLACCTBALQUERY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
Business Area
  • Business Area
  • Client
  • C_INVENTORYGLACCTBALQUERY.BUSINESSAREA == TGSB.GSBER
  • C_INVENTORYGLACCTBALQUERY.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • C_INVENTORYGLACCTBALQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALQUERY.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALQUERY.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • C_INVENTORYGLACCTBALQUERY.MANDT == T001.MANDT
  • C_INVENTORYGLACCTBALQUERY.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_INVENTORYGLACCTBALQUERY.MANDT == TCURC.MANDT
  • C_INVENTORYGLACCTBALQUERY.COMPANYCODECURRENCY == TCURC.WAERS
Chart of Accounts
  • Chart of Accounts
  • Chart of Accounts
  • Client
  • C_INVENTORYGLACCTBALQUERY.CHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALQUERY.CORPORATEGROUPCHARTOFACCOUNTS == T004.KTOPL
  • C_INVENTORYGLACCTBALQUERY.MANDT == T004.MANDT
Alternative Chart of Accounts for Country/Region
  • Client
  • Alternative Chart of Accounts for Country/Region
  • C_INVENTORYGLACCTBALQUERY.MANDT == T004.MANDT
  • C_INVENTORYGLACCTBALQUERY.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
Customer Number
  • Client
  • Customer Number
  • C_INVENTORYGLACCTBALQUERY.MANDT == KNA1.MANDT
  • C_INVENTORYGLACCTBALQUERY.CUSTOMER == KNA1.KUNNR
Asset Subnumber
  • ?
  • Client
  • Fixed Asset
  • Asset Subnumber
  • C_INVENTORYGLACCTBALQUERY.[column in domain "BUKRS"] == ANLA.BUKRS
  • C_INVENTORYGLACCTBALQUERY.MANDT == ANLA.MANDT
  • C_INVENTORYGLACCTBALQUERY.MASTERFIXEDASSET == ANLA.ANLN1
  • C_INVENTORYGLACCTBALQUERY.FIXEDASSET == ANLA.ANLN2
G/L Account
  • Client
  • Company Code
  • G/L Account
  • C_INVENTORYGLACCTBALQUERY.MANDT == SKB1.MANDT
  • C_INVENTORYGLACCTBALQUERY.COMPANYCODE == SKB1.BUKRS
  • C_INVENTORYGLACCTBALQUERY.GLACCOUNT == SKB1.SAKNR
G/L Account Group
  • Chart of Accounts
  • Chart of Accounts
  • G/L Account Group
  • Client
  • C_INVENTORYGLACCTBALQUERY.CHARTOFACCOUNTS == T077S.KTOPL
  • C_INVENTORYGLACCTBALQUERY.CORPORATEGROUPCHARTOFACCOUNTS == T077S.KTOPL
  • C_INVENTORYGLACCTBALQUERY.GLACCOUNTGROUP == T077S.KTOKS
  • C_INVENTORYGLACCTBALQUERY.MANDT == T077S.MANDT
Ledger
  • Client
  • Ledger
  • Source Ledger
Product (Deprecated)
  • Product (Deprecated)
  • Client
  • C_INVENTORYGLACCTBALQUERY.MATERIAL == MARA.MATNR
  • C_INVENTORYGLACCTBALQUERY.MANDT == MARA.MANDT
Source Ledger
  • Client
  • Ledger
  • Source Ledger
Reporting Entity
  • Client
  • Reporting Entity
  • C_INVENTORYGLACCTBALQUERY.MANDT == SRF_RPG_ENT.MANDT
  • C_INVENTORYGLACCTBALQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Supplier
  • Client
  • Supplier
  • C_INVENTORYGLACCTBALQUERY.MANDT == LFA1.MANDT
  • C_INVENTORYGLACCTBALQUERY.SUPPLIER == LFA1.LIFNR
Valuation area
  • Client
  • Valuation area
  • C_INVENTORYGLACCTBALQUERY.MANDT == T001K.MANDT
  • C_INVENTORYGLACCTBALQUERY.VALUATIONAREA == T001K.BWKEY