I_CashFlowRecnclnDataBasic

DDL: I_CASHFLOWRECNCLNDATABASIC SQL: IFQMFLOWBAS Type: view BASIC
11 Fields 1 Data Sources

Cash Flow With Reconciliation Data

I_CashFlowRecnclnDataBasic is a Basic CDS View that provides data about "Cash Flow With Reconciliation Data" in SAP S/4HANA. It reads from 1 data source (P_FqmflowCASH) and exposes 11 fields with key fields CashFlowID, ValidFrom.

Data Sources (1)

SourceAliasJoin Type
P_FqmflowCASH P_FqmflowCASH from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFQMFLOWBAS view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private false view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cash Flow With Reconciliation Data view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CashFlowID flow_id Flow ID
KEY ValidFrom ValidFrom Vers.Valid From
ValidTo ValidTo Vers.Valid To
CertaintyLevel CertaintyLevel Certainty Level
MemoRecordStatus cmm_state State
CashFlowCategory
IsValid IsValid Truth Value
ExpirationDate fi_due_date Due Date
LastChangeDateTime LastChangeDateTime Timestamp
CompanyCode CompanyCode Receiver Company Code
BankAccountInternalID BankAccountId Technical ID

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 I_CashFlowRecnclnDataBasic.
-- 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: IFQMFLOWBAS

CREATE VIEW I_CashFlowRecnclnDataBasic AS
SELECT
  flow_id AS CashFlowID,
  ValidFrom,
  ValidTo,
  CertaintyLevel,
  cmm_state AS MemoRecordStatus,
  cast(''as fqm_flow_cat) AS CashFlowCategory,
  IsValid,
  fi_due_date AS ExpirationDate,
  LastChangeDateTime,
  CompanyCode,
  BankAccountId AS BankAccountInternalID
FROM P_FqmflowCASH
;

Learn More