C_GLAcctFlowByDateFuncKPIQ

GL Account Flow by Date Function | view: CFIGLFLOWDFKPI | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
InvertedAmountInGlobalCurrency Inverted Amount in Global Currency
WorkingCapitalAmtInGlobCrcy Working Capital Amount in Global Currency
CurrentAssetAmtInGlobCrcy Current Asset Amount In Global Currency
CurrentLiabilityAmtInGlobCrcy Current Liability Amount in Global Currency
ShEquityAmtInGlobCrcy Shareholder Equity Amount In Global Currency
AssetAmtInGlobCrcy Asset Amount in Global Currency
LiabilityEquityAmtInGlobCrcy Liability and Equity Amount In Global Currency
OpgActyCashAmtInGlobCrcy Operating Cash Flow Amount in Global Currency
GrossProfitAmtInGlobCrcy Gross Profit Amount in Global Currency
OpgProfitAmtInGlobCrcy Operating Profit Amount in Global Currency
CostOfGoodsSoldAmtInGlobCrcy Cost Of Goods Sold Amount In Global Currency
GrossRevenueAmtInGlobCrcy Gross Revenue Amount in Global Currency
RecognizedRevnAmtInGlobCrcy Recognized Revenue Amount In Global Currency
EBTAmountInGlobCrcy EBT Amount in Global Currency
EBITAmountInGlobCrcy EBIT Amount in Global Currency
EBITDAAmountInGlobCrcy EBITDA Amount in Global Currency
NetIncomeAmtInGlobCrcy Net Income Amount in Global Currency
TotalOpgExpnInGlobCrcy Total Operating Expense Amount in Global Currency
OpgExpnInGlobCrcy Operating Expense Amount in Global Currency
OthOpgExpnInGlobCrcy Other Operating Expense Amount in Global Currency
StrtgInventoryAmtInGlobCrcy Starting Inventory Amount in Global Currency
ChgsInventoryAmtInGlobCrcy Changes of Inventory Amount in Global Currency
InventoryAmtInGlobCrcy Inventory Amount in Global Currency
IncomeTaxAmtInGlobCrcy Income Tax Amount in Global Currency
InterestAmtInGlobCrcy Interest Amount in Global Currency
TngblAstDeprAmtInGlobCrcy Tangible Asset Depreciation Amount in Global Currency
IntngblAssetAmtznAmtInGlobCrcy Intangible Asset Amortization Amount in Global Currency
FxdAssetRtrmtAmtInGlobCrcy Fixed Asset Retirement Amount in Global Currency
ChgsProvisionAmtInGlobCrcy Changes Provision Amount in Global Currency
ProvisionAmtInGlobCrcy Provisions Amount in Global Currency
ChgsAcctsRblAmtInGlobCrcy Changes of Accounts Receivable Amount in Global Currency
AcctsRblAmtInGlobCrcy Accounts Receivable Amount in Global Currency
ChgsAcctsOthRblAmtInGlobCrcy Changes of Accounts Other Receivable Amount in Global Crcy
AcctsOthRblAmtInGlobCrcy Accounts Other Receivables Amount in Global Currency
ChgsAcctsPyblAmtInGlobCrcy Changes of Accounts Payable Amount in Global Currency
AcctsPyblAmtInGlobCrcy Accounts Payable Amount in Global Currency
ChgsAcctsOthPyblAmtInGlobCrcy Changes of Accounts Other Payable Amount in Global Crcy
AcctsOthPyblAmtInGlobCrcy Accounts Other Payable Amount in Global Currency
OpgIncomeAmtInGlobCrcy Operating Income Amount In Global Currency
Column Name Description
Column Name Description
Column Name Description
GLAccountFlowType G/L Account Flow Type Show values
GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
ActualPlanCode Actual Plan Code Show values
Column Name Description Domain name
DateFunction Relative Date Function ID DATEFUNCTIONID
PlanningCategory Plan Category FCOM_CATEGORY
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
WorkingCapitalGlobCrcyPercent Working Capital Global Currency Percent
GrossMarginGlobCrcyPct Gross Margin Global Currency Percent FISD_PERCENT_2
OpgMargGlobCrcyPercent Operating Margin Global Currency Percent FISD_PERCENT_2
ProfitMarginGlobCrcyPercent Profit Margin Global Currency Percent FISD_PERCENT_2
ReturnOnEquityGlobCrcyPct Return on Equity Global Currency Percent FISD_PERCENT_2
ReturnOnAssetGlobCrcyPercent Return on Asset Global Currency Percent FISD_PERCENT_2
RetOnInvestmentGlobCrcyPct Return on Investment Global Currency Percent FISD_PERCENT_2
AssetTurnoverGlobCrcyPercent Asset Turnover Global Currency Percent FISD_PERCENT_2
InvtryTurnoverGlobCrcyPct Inventory Turnover Global Currency Percent FISD_PERCENT_2
EBITDAMarginGlobCrcyPercent EBITDA Margin Global Currency Percent FISD_PERCENT_2
EBITMarginGlobCrcyPercent EBIT Margin Global Currency Percent FISD_PERCENT_2
RetOnCptlEmployedGlobCrcyPct Return on Capital Employed Global Currency Percent FISD_PERCENT_2
DebtToEquityGlobCrcyPercent Debt to Equity Global Currency Percent FISD_PERCENT_2
DebtToAssetGlobCrcyPercent Debt to Asset Global Currency Percent FISD_PERCENT_2
InterestCoverageGlobCrcyPct Interest Coverage Global Currency Percent FISD_PERCENT_2
DegOfFinLeverageGlobCrcyRatio Degree of Financial Leverage Global Currency Ratio
LedgerFiscalYear Ledger Fiscal Year GJAHR
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == T004.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == T001.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == TKA01.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • C_GLACCTFLOWBYDATEFUNCKPIQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == CSKS.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.COSTCENTER == CSKS.KOSTL
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CONTROLLINGAREA == CSKS.KOKRS
Customer Number
  • Client
  • Customer Number
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == KNA1.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CUSTOMER == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == T151.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CUSTOMERGROUP == T151.KDGRP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_GLACCTFLOWBYDATEFUNCKPIQ.FISCALYEARVARIANT == T009.PERIV
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == TFKB.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == SKB1.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.GLACCOUNT == SKB1.SAKNR
  • C_GLACCTFLOWBYDATEFUNCKPIQ.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == TCURC.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • ?
  • Profit Center
  • Client
  • Controlling Area
  • C_GLACCTFLOWBYDATEFUNCKPIQ.[column in domain "DATBI"] == CEPC.DATBI
  • C_GLACCTFLOWBYDATEFUNCKPIQ.PROFITCENTER == CEPC.PRCTR
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == CEPC.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.CONTROLLINGAREA == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == FAGL_SEGM.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Product Sold
  • Client
  • Product Sold
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == MARA.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • C_GLACCTFLOWBYDATEFUNCKPIQ.SOLDPRODUCTGROUP == T023.MATKL
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == T023.MANDT
Supplier
  • Client
  • Supplier
  • C_GLACCTFLOWBYDATEFUNCKPIQ.MANDT == LFA1.MANDT
  • C_GLACCTFLOWBYDATEFUNCKPIQ.SUPPLIER == LFA1.LIFNR