C_GLAcctFlowByDateFuncKPIQ

DDL: C_GLACCTFLOWBYDATEFUNCKPIQ SQL: CFIGLFLOWDFKPI Type: view CONSUMPTION
85 Fields 1 Data Sources

GL Account Flow by Date Function

C_GLAcctFlowByDateFuncKPIQ (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

C_GLAcctFlowByDateFuncKPIQ is a Consumption CDS View that provides data about "GL Account Flow by Date Function" in SAP S/4HANA. It reads from 1 data source (I_GLAcctFlowSemTagByDateFuncC) and exposes 85 fields.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryQuery
StatusReleased
Corresponding DataSource2CCFIGLFLOWDFKPI
Purpose
This CDS view provides you with access to a variety of financial statement-based measures that can be analyzed by the most important dimensions of a journal entry. This view combines actual and plan data enriched with semantic tags. The measures are used to calculate financial statement based KPIs (Key Performance Indicators). The calculation of these KPIs is purely based on the aggregation of line items that are enriched by semantic tags. all line items except year-end closing postings are considered. This CDS view provides you with the information that you need to answer the following business questions: What is my Return on Investment per Profit Center for the fiscal year 2020? What is the opening balance of my Cost of Goods ? What are the changing balances of my Operating Income for the fiscal periods of the fiscal year 2020?

Structure
Object types This view relates to the following SAP object types: Journal Entry Item Financial Planning Entry Item Main CDS parameters and filters of the CDS view The mandatory input parameters are: Financial statement version Ledger Plan category Relative Date Function Setting Up an Alternative Fiscal Year Variant As the filter for company code is not mandatory, but the fiscal year variant is mandatory, you get as a result data, you can easily compare, for example data for company codes with the same fiscal year variant. If you have different date functions, then you have to use the date function as dimension. Other important parameters are: Company code Measures and attributes All relevant dimensions are included in this CDS view along with associations to interface views for some of these dimensions. The most important attributes are: Company code Profit center Cost center Segment Customer

G/L Account Flow Type (Opening, Change, Ending)
This CDS view retrieves for each combination of dimensions and KPIs per desired time interval an amount for the opening balance, an amount for the change and an amount for the ending balance in global currency. Opening All postings from the beginning of the lowest given fiscal year to the start date of the selected time interval Change All postings in the selected time interval Ending Opening plus change balance

Plan/Actual
By specifying a plan category additionally to the plan category ACT01 (stands for actual values) actual values can be compared with planned values.

Time Periods (Special Periods, Selection of Several Years, Year-to-Date, Periods)
You use the date functions to set the desired time interval. If you are using a date function which includes several fiscal years or which exceeds fiscal year boundaries, then only the balance carried forward from the first year is shown. Special periods are assigned to the last period of a fiscal year. Balances carried forward are not shown in period 000. If the selection is performed with the beginning of the fiscal year, the balances carried forward are shown as opening balance of period 1.

Comparison to App/Query/ViewC_FinancialStatementKPI
With the CDS view Financial Statement-based KPIs ( C_FinancialStatementKPI ), special periods have to be selected separately. With the CDS view C_FinancialStatementKPI , balances carried forward are shown in period 000. With the CDS view C_FinancialStatementKPI , only year-to-date balances can be retrieved.

Key Performance Indicators (KPIs)
The following table shows the relationship between the financial statement-based KPIs and the semantic tags that are assigned: Formula of KPIs and Assignment to Semantic Tags KPI Technical Field Name Based on Semantic Tag As Aggregated Based on Formula Working Capital Amount in Global Currency (Working Capital Amount in Global Crcy) WorkingCapitalAmtInGlobCrcy CurrentAssetAmtInGlobCrcy - CurrentLiabilityAmtInGlobCrcy Working Capital in Global Currency as a Percentage (Working Capital Glob Crcy Percent) WorkingCapitalGlobCrcyPercent ( CurrentAssetAmtInGlobCrcy / CurrentLiabilityAmtInGlobCrcy) * 100 Current Asset Amount in

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-FIO-GL
CapabilitiesAnalytical Query
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GLAcctFlowSemTagByDateFuncC I_GLAcctFlowSemTagByDateFuncC from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFIGLFLOWDFKPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
EndUserText.label GL Account Flow by Date Function view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view

Fields (85)

KeyFieldSource TableSource FieldDescription
GLAccountHierarchy GLAccountHierarchy Financial Statement Version
DateFunction DateFunction Relative Date Function ID
PlanningCategory PlanningCategory Plan Category
Ledger Ledger Ledger in General Ledger Accounting
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
GLAccountFlowType GLAccountFlowType G/L Account Flow Type
GLAccountTypeFlowType GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type
ProfitCenter ProfitCenter Profit Center
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
FiscalYearPeriod FiscalYearPeriod Fiscal Year Period
FiscalPeriod FiscalPeriod Fiscal Period
FiscalQuarter FiscalQuarter Fiscal Quarter
FiscalYearQuarter FiscalYearQuarter Fiscal Year + Fiscal Quarter
ChartOfAccounts ChartOfAccounts Chart of Accounts
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
FunctionalArea FunctionalArea Sendr Fctl Area
Segment Segment Segment for Segmental Reporting
SemanticTag SemanticTag Semantic Tag of a Hierarchy Node
Customer Customer Customer Number
CustomerGroup CustomerGroup Customer Group
Supplier Supplier Supplier
SoldProduct SoldProduct Product Sold
SoldProductGroup SoldProductGroup Product Sold Group
IsBalanceSheetAccount IsBalanceSheetAccount Indicator: Account is a balance sheet account?
ActualPlanCode ActualPlanCode Actual Plan Code
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
InvertedAmountInGlobalCurrency InvertedAmountInGlobalCurrency Inverted Amount in Global Currency
WorkingCapitalAmtInGlobCrcy Working Capital Amount in Global Currency
WorkingCapitalGlobCrcyPercent Working Capital Global Currency Percent
CurrentAssetAmtInGlobCrcy CurrentAssetAmtInGlobCrcy Current Asset Amount In Global Currency
CurrentLiabilityAmtInGlobCrcy CurrentLiabilityAmtInGlobCrcy Current Liability Amount in Global Currency
ShEquityAmtInGlobCrcy Shareholder Equity Amount In Global Currency
AssetAmtInGlobCrcy AssetAmtInGlobCrcy Asset Amount in Global Currency
LiabilityEquityAmtInGlobCrcy LiabilityEquityAmtInGlobCrcy Liability and Equity Amount In Global Currency
OpgActyCashAmtInGlobCrcy Operating Cash Flow Amount in Global Currency
GrossMarginGlobCrcyPct Gross Margin Global Currency Percent
OpgMargGlobCrcyPercent Operating Margin Global Currency Percent
ProfitMarginGlobCrcyPercent Profit Margin Global Currency Percent
ReturnOnEquityGlobCrcyPct Return on Equity Global Currency Percent
ReturnOnAssetGlobCrcyPercent Return on Asset Global Currency Percent
RetOnInvestmentGlobCrcyPct Return on Investment Global Currency Percent
GrossProfitAmtInGlobCrcy Gross Profit Amount in Global Currency
OpgProfitAmtInGlobCrcy Operating Profit Amount in Global Currency
CostOfGoodsSoldAmtInGlobCrcy CostOfGoodsSoldAmtInGlobCrcy Cost Of Goods Sold Amount In Global Currency
GrossRevenueAmtInGlobCrcy GrossRevenueAmtInGlobCrcy Gross Revenue Amount in Global Currency
RecognizedRevnAmtInGlobCrcy RecognizedRevnAmtInGlobCrcy Recognized Revenue Amount In Global Currency
AssetTurnoverGlobCrcyPercent Asset Turnover Global Currency Percent
InvtryTurnoverGlobCrcyPct Inventory Turnover Global Currency Percent
EBTAmountInGlobCrcy EBT Amount in Global Currency
EBITAmountInGlobCrcy EBIT Amount in Global Currency
EBITDAAmountInGlobCrcy EBITDA Amount in Global Currency
NetIncomeAmtInGlobCrcy NetIncomeAmtInGlobCrcy Net Income Amount in Global Currency
TotalOpgExpnInGlobCrcy Total Operating Expense Amount in Global Currency
OpgExpnInGlobCrcy OpgExpnInGlobCrcy Operating Expense Amount in Global Currency
OthOpgExpnInGlobCrcy OthOpgExpnInGlobCrcy Other Operating Expense Amount in Global Currency
StrtgInventoryAmtInGlobCrcy StrtgInventoryAmtInGlobCrcy Starting Inventory Amount in Global Currency
ChgsInventoryAmtInGlobCrcy ChgsInventoryAmtInGlobCrcy Changes of Inventory Amount in Global Currency
InventoryAmtInGlobCrcy InventoryAmtInGlobCrcy Inventory Amount in Global Currency
IncomeTaxAmtInGlobCrcy IncomeTaxAmtInGlobCrcy Income Tax Amount in Global Currency
InterestAmtInGlobCrcy InterestAmtInGlobCrcy Interest Amount in Global Currency
TngblAstDeprAmtInGlobCrcy TngblAstDeprAmtInGlobCrcy Tangible Asset Depreciation Amount in Global Currency
IntngblAssetAmtznAmtInGlobCrcy IntngblAssetAmtznAmtInGlobCrcy Intangible Asset Amortization Amount in Global Currency
FxdAssetRtrmtAmtInGlobCrcy FxdAssetRtrmtAmtInGlobCrcy Fixed Asset Retirement Amount in Global Currency
ChgsProvisionAmtInGlobCrcy ChgsProvisionAmtInGlobCrcy Changes Provision Amount in Global Currency
ProvisionAmtInGlobCrcy ProvisionAmtInGlobCrcy Provisions Amount in Global Currency
ChgsAcctsRblAmtInGlobCrcy ChgsAcctsRblAmtInGlobCrcy Changes of Accounts Receivable Amount in Global Currency
AcctsRblAmtInGlobCrcy AcctsRblAmtInGlobCrcy Accounts Receivable Amount in Global Currency
ChgsAcctsOthRblAmtInGlobCrcy ChgsAcctsOthRblAmtInGlobCrcy Changes of Accounts Other Receivable Amount in Global Crcy
AcctsOthRblAmtInGlobCrcy AcctsOthRblAmtInGlobCrcy Accounts Other Receivables Amount in Global Currency
ChgsAcctsPyblAmtInGlobCrcy ChgsAcctsPyblAmtInGlobCrcy Changes of Accounts Payable Amount in Global Currency
AcctsPyblAmtInGlobCrcy AcctsPyblAmtInGlobCrcy Accounts Payable Amount in Global Currency
ChgsAcctsOthPyblAmtInGlobCrcy ChgsAcctsOthPyblAmtInGlobCrcy Changes of Accounts Other Payable Amount in Global Crcy
AcctsOthPyblAmtInGlobCrcy AcctsOthPyblAmtInGlobCrcy Accounts Other Payable Amount in Global Currency
EBITDAMarginGlobCrcyPercent EBITDA Margin Global Currency Percent
EBITMarginGlobCrcyPercent EBIT Margin Global Currency Percent
RetOnCptlEmployedGlobCrcyPct Return on Capital Employed Global Currency Percent
DebtToEquityGlobCrcyPercent Debt to Equity Global Currency Percent
DebtToAssetGlobCrcyPercent Debt to Asset Global Currency Percent
InterestCoverageGlobCrcyPct Interest Coverage Global Currency Percent
DegOfFinLeverageGlobCrcyRatio Degree of Financial Leverage Global Currency Ratio
OpgIncomeAmtInGlobCrcy Operating Income Amount In Global Currency
LedgerFiscalYear LedgerFiscalYear Fiscal Year of Ledger

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_GLAcctFlowByDateFuncKPIQ.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CFIGLFLOWDFKPI

CREATE VIEW C_GLAcctFlowByDateFuncKPIQ AS
SELECT
  GLAccountHierarchy,
  DateFunction,
  PlanningCategory,
  Ledger,
  FiscalYearVariant,
  CompanyCode,
  GLAccount,
  GLAccountFlowType,
  GLAccountTypeFlowType,
  ProfitCenter,
  GlobalCurrency,
  FiscalYearPeriod,
  FiscalPeriod,
  FiscalQuarter,
  FiscalYearQuarter,
  ChartOfAccounts,
  ControllingArea,
  CostCenter,
  FunctionalArea,
  Segment,
  SemanticTag,
  Customer,
  CustomerGroup,
  Supplier,
  SoldProduct,
  SoldProductGroup,
  IsBalanceSheetAccount,
  ActualPlanCode,
  AmountInGlobalCurrency,
  InvertedAmountInGlobalCurrency,
  cast(0 as fis_wrkcptlamt_ksl) AS WorkingCapitalAmtInGlobCrcy,
  cast(0 as fis_wrkcptlratio_ksl) AS WorkingCapitalGlobCrcyPercent,
  CurrentAssetAmtInGlobCrcy,
  CurrentLiabilityAmtInGlobCrcy,
  cast(0 as fis_sheqtyamt_ksl) AS ShEquityAmtInGlobCrcy,
  AssetAmtInGlobCrcy,
  LiabilityEquityAmtInGlobCrcy,
  cast (0 as fis_cashopg_ksl) AS OpgActyCashAmtInGlobCrcy,
  cast (0 as fis_grossmargin_ksl) AS GrossMarginGlobCrcyPct,
  cast (0 as fis_operatingmargin_ksl) AS OpgMargGlobCrcyPercent,
  cast (0 as fis_profitmargin_ksl) AS ProfitMarginGlobCrcyPercent,
  cast (0 as fis_returnonequity_ksl) AS ReturnOnEquityGlobCrcyPct,
  cast (0 as fis_returnonasset_ksl) AS ReturnOnAssetGlobCrcyPercent,
  cast (0 as fis_returnoninvest_ksl) AS RetOnInvestmentGlobCrcyPct,
  cast (0 as fis_grossprofit_ksl) AS GrossProfitAmtInGlobCrcy,
  cast (0 as fis_opgprofit_ksl) AS OpgProfitAmtInGlobCrcy,
  CostOfGoodsSoldAmtInGlobCrcy,
  GrossRevenueAmtInGlobCrcy,
  RecognizedRevnAmtInGlobCrcy,
  cast (0 as fis_assetturnover_ksl) AS AssetTurnoverGlobCrcyPercent,
  cast (0 as fis_invtryturnover_ksl) AS InvtryTurnoverGlobCrcyPct,
  cast (0 as fis_ebt_ksl) AS EBTAmountInGlobCrcy,
  cast (0 as fis_ebit_ksl) AS EBITAmountInGlobCrcy,
  cast (0 as fis_ebitda_ksl) AS EBITDAAmountInGlobCrcy,
  NetIncomeAmtInGlobCrcy,
  cast (0 as fis_toperexp_ksl) AS TotalOpgExpnInGlobCrcy,
  OpgExpnInGlobCrcy,
  OthOpgExpnInGlobCrcy,
  StrtgInventoryAmtInGlobCrcy,
  ChgsInventoryAmtInGlobCrcy,
  InventoryAmtInGlobCrcy,
  IncomeTaxAmtInGlobCrcy,
  InterestAmtInGlobCrcy,
  TngblAstDeprAmtInGlobCrcy,
  IntngblAssetAmtznAmtInGlobCrcy,
  FxdAssetRtrmtAmtInGlobCrcy,
  ChgsProvisionAmtInGlobCrcy,
  ProvisionAmtInGlobCrcy,
  ChgsAcctsRblAmtInGlobCrcy,
  AcctsRblAmtInGlobCrcy,
  ChgsAcctsOthRblAmtInGlobCrcy,
  AcctsOthRblAmtInGlobCrcy,
  ChgsAcctsPyblAmtInGlobCrcy,
  AcctsPyblAmtInGlobCrcy,
  ChgsAcctsOthPyblAmtInGlobCrcy,
  AcctsOthPyblAmtInGlobCrcy,
  cast (0 as fis_ebitda_pct_ksl) AS EBITDAMarginGlobCrcyPercent,
  cast (0 as fis_ebit_pct_ksl) AS EBITMarginGlobCrcyPercent,
  cast (0 as fis_returnoncapempl_ksl) AS RetOnCptlEmployedGlobCrcyPct,
  cast (0 as fis_debttoequity_ksl) AS DebtToEquityGlobCrcyPercent,
  cast (0 as fis_debttoasset_ksl) AS DebtToAssetGlobCrcyPercent,
  cast (0 as fis_interestcov_ksl) AS InterestCoverageGlobCrcyPct,
  cast(0 as fis_degoffinlevratio_ksl) AS DegOfFinLeverageGlobCrcyRatio,
  cast(0 as fis_opgincome_ksl) AS OpgIncomeAmtInGlobCrcy,
  LedgerFiscalYear
FROM I_GLAcctFlowSemTagByDateFuncC
;

Learn More