What is FQM_FLOW_KEYFIGURE_CDS in SAP S/4HANA?

FQM_FLOW_KEYFIGURE_CDS is a cds CDS view in SAP S/4HANA. FQM Keyfigure View It contains 56 fields.

Which tables does FQM_FLOW_KEYFIGURE_CDS read from?

FQM_FLOW_KEYFIGURE_CDS reads data from: fqm_flow.

FQM_FLOW_KEYFIGURE_CDS

DDL: FQM_FLOW_KEYFIGURE_CDS SQL: FQMV_FLOW_KEYFIG Type: view Package: FQM

56 Fields 1 Data Sources

FQM Keyfigure View

FQM_FLOW_KEYFIGURE_CDS is a CDS View that provides data about "FQM Keyfigure View" in SAP S/4HANA. It reads from 1 data source (fqm_flow) and exposes 56 fields. Part of development package FQM.

Data Sources (1)

Source	Alias	Join Type
fqm_flow	fqm_flow	from

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	FQMV_FLOW_KEYFIG	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

Fields (56)

Field	Source Field	Description
valid_from	valid_from	Validity Start Time
valid_to	valid_to	Validity End Time
create_user	create_user	User Name
owner	owner	Vehicle Owner
flow_type	flow_type	Flow Type
payment_date	payment_date	Pymt Date
days_due	days_due	Days until Due
fi_post_date	fi_post_date	Posting Date
fi_account	fi_account	G/L Acct
fi_item_text	fi_item_text	Text
currency	currency	Valuation Crcy
house_bank	house_bank	House Bank
company_code	company_code	Company Code
partner	partner	With Partner
material	material	Vehicle Model
project	project	WBS Element
cost_center	cost_center	Posted Cost Center
segment	segment	Segment number
assignment	assignment	Assignment
CASH		Cash
CIT		Cash in Transit
FXP		FX Purchase (Variable Price)
FXS		FX Sale (Variable Price)
PACT		Money Market Investments
PPAS		Money Market Borrowings
FEE		Fees (Payable/Receivable)
INTP		Interest Payable
INTR		Interest Receivable
PICP		Capital to be Paid In
POCP		Capital to be Paid Out
FXF		FX Position Fixed Rate
CASH_CNF		Confirmed Cash
CASH_UNC		Unconfirmed Cash
CSHI_UNC		Unconfirmed Incoming Cash
CSHO_UNC		Unconfirmed Outgoing Cash
CSHI_CNF		Confirmed Incoming Cash
CSHO_CNF		Confirmed Outgoing Cash
LPA_CSHI		Allocated Incoming Cash
LPA_CSHO		Allocated Outoing Cash
LPA_CASH		Allocated Cash
CASH_IN		Incoming Cash
CASH_OUT		Outgoing Cash
OL_FXP		Long Option FX Purchase
OL_FXS		Long Option FX Sale
OS_FXP		Short Option FX Purchase
OS_FXS		Short Option FX Sale
OLFX_TOT		Long Option FX Total
OSFX_TOT		Short Option FX Total
APAR_REC		Receivables from Invoices
APAR_PAY		Payables from Invoices
CITI_CNF		Bank confirmed cash in transit in
CITO_CNF		Bank confirmed cash in transit out
NALI_CNF		Not allocated bank confirmed cash in
NALO_CNF		Not allocated bank confirmed cash out
CITT_CNF		Bank confirmed cash in transit total
NALT_CNF		Not allocated bank confirmed cash total

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 FQM_FLOW_KEYFIGURE_CDS.
-- 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: FQMV_FLOW_KEYFIG

CREATE VIEW FQM_FLOW_KEYFIGURE_CDS AS
SELECT
  valid_from,
  valid_to,
  create_user,
  owner,
  flow_type,
  payment_date,
  days_due,
  fi_post_date,
  fi_account,
  fi_item_text,
  currency,
  house_bank,
  company_code,
  partner,
  material,
  project,
  cost_center,
  segment,
  assignment,
  case flow_category when '900000' then amount when '900001' then amount when '900002' then amount when '900003' then amount when '900004' then amount when '900005' then amount when '900006' then amount when '900007' then amount when '900008' then amount when '900009' then amount when '900014' then amount when '900015' then amount when '900016' then amount when '900017' then amount when '900100' then amount when '900101' then amount when '900102' then amount when '900103' then amount when '900104' then amount when '900105' then amount when '900106' then amount when '900107' then amount when '900108' then amount when '900109' then amount when '900110' then amount when '900111' then amount when '900140' then amount when '900141' then amount when '900142' then amount when '900143' then amount when '900144' then amount when '900145' then amount else 0 end AS CASH,
  case flow_category when '700000' then amount when '700001' then amount when '800003' then amount when '800004' then amount else 0 end AS CIT,
  case flow_category when '200200' then amount else 0 end AS FXP,
  case flow_category when '200201' then amount else 0 end AS FXS,
  case flow_category when '200100' then amount else 0 end AS PACT,
  case flow_category when '200101' then amount else 0 end AS PPAS,
  case flow_category when '200010' then amount when '200011' then amount else 0 end AS FEE,
  case flow_category when '200021' then amount when '200022' then amount else 0 end AS INTP,
  case flow_category when '200020' then amount when '200023' then amount else 0 end AS INTR,
  case flow_category when '201001' then amount else 0 end AS PICP,
  case flow_category when '201000' then amount else 0 end AS POCP,
  case flow_category when '200202' then amount else 0 end AS FXF,
  case flow_category when '900002' then amount when '900003' then amount when '900004' then amount when '900005' then amount when '900006' then amount when '900007' then amount when '900008' then amount when '900009' then amount when '900102' then amount when '900103' then amount when '900108' then amount when '900109' then amount else 0 end AS CASH_CNF,
  case flow_category when '900000' then amount when '900001' then amount when '900014' then amount when '900015' then amount when '900016' then amount when '900017' then amount when '900100' then amount when '900101' then amount when '900104' then amount when '900105' then amount when '900106' then amount when '900107' then amount when '900110' then amount when '900111' then amount when '900140' then amount when '900141' then amount when '900142' then amount when '900143' then amount when '900144' then amount when '900145' then amount else 0 end AS CASH_UNC,
  case flow_category when '900000' then amount when '900100' then amount when '900104' then amount when '900110' then amount when '900106' then amount when '900140' then amount when '900142' then amount when '900144' then amount when '900014' then amount when '900015' then amount else 0 end AS CSHI_UNC,
  case flow_category when '900001' then amount when '900101' then amount when '900105' then amount when '900111' then amount when '900107' then amount when '900141' then amount when '900143' then amount when '900145' then amount when '900016' then amount when '900017' then amount else 0 end AS CSHO_UNC,
  case flow_category when '900102' then amount when '900108' then amount when '900006' then amount when '900007' then amount when '900002' then amount when '900003' then amount else 0 end AS CSHI_CNF,
  case flow_category when '900103' then amount when '900109' then amount when '900008' then amount when '900009' then amount when '900004' then amount when '900005' then amount else 0 end AS CSHO_CNF,
  case flow_category when '900112' then amount else 0 end AS LPA_CSHI,
  case flow_category when '900113' then amount else 0 end AS LPA_CSHO,
  case flow_category when '900112' then amount when '900113' then amount else 0 end AS LPA_CASH,
  case flow_category when '900000' then amount when '900002' then amount when '900003' then amount when '900006' then amount when '900007' then amount when '900014' then amount when '900015' then amount when '900100' then amount when '900102' then amount when '900104' then amount when '900106' then amount when '900108' then amount when '900110' then amount when '900140' then amount when '900142' then amount when '900144' then amount else 0 end AS CASH_IN,
  case flow_category when '900001' then amount when '900004' then amount when '900005' then amount when '900008' then amount when '900009' then amount when '900016' then amount when '900017' then amount when '900101' then amount when '900103' then amount when '900105' then amount when '900107' then amount when '900109' then amount when '900111' then amount when '900141' then amount when '900143' then amount when '900145' then amount else 0 end AS CASH_OUT,
  case flow_category when '200301' then amount when '200300' then amount else 0 end AS OL_FXP,
  case flow_category when '200302' then amount when '200303' then amount else 0 end AS OL_FXS,
  case flow_category when '200305' then amount when '200304' then amount else 0 end AS OS_FXP,
  case flow_category when '200306' then amount when '200307' then amount else 0 end AS OS_FXS,
  case flow_category when '200300' then amount when '200301' then amount when '200302' then amount when '200303' then amount else 0 end AS OLFX_TOT,
  case flow_category when '200304' then amount when '200305' then amount when '200306' then amount when '200307' then amount else 0 end AS OSFX_TOT,
  case flow_category when '600011' then amount when '600000' then amount else 0 end AS APAR_REC,
  case flow_category when '600010' then amount when '600001' then amount else 0 end AS APAR_PAY,
  case flow_category when '900002' then amount when '900003' then amount else 0 end AS CITI_CNF,
  case flow_category when '900004' then amount when '900005' then amount else 0 end AS CITO_CNF,
  case flow_category when '900010' then amount when '900011' then amount else 0 end AS NALI_CNF,
  case flow_category when '900012' then amount when '900013' then amount else 0 end AS NALO_CNF,
  case flow_category when '900002' then amount when '900003' then amount when '900004' then amount when '900005' then amount else 0 end AS CITT_CNF,
  case flow_category when '900010' then amount when '900011' then amount when '900012' then amount when '900013' then amount else 0 end AS NALT_CNF
FROM fqm_flow
;

Depth:

FQM_FLOW_KEYFIGURE_CDS view

fqm_flow