FQM_FLOW_KEYFIGURE_CDS

DDL: FQM_FLOW_KEYFIGURE_CDS SQL: FQMV_FLOW_KEYFIG Type: view
56 Fields 1 Data Sources

FQM_FLOW_KEYFIGURE_CDS is a CDS View in SAP S/4HANA. It reads from 1 data source (fqm_flow) and exposes 56 fields.

Data Sources (1)

SourceAliasJoin Type
fqm_flow fqm_flow from

Annotations (6)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;

Learn More