FQM_FLOW

Transparent Table Application Table
35 Fields 21 CDS Views

FQM Flows

FQM_FLOW is an SAP database table in S/4HANA. FQM Flows. It contains 35 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
E_CashFlow view_entity from EXTENSION Cash Flow - Extension
FQM_FLOW_KEYFIGURE_CDS view from
I_CashFlowDeltaData view from BASIC Delta Extraction Cash FLow
I_MemoRecord view from BASIC Basic View for Memo Record
I_MemoRecordBase view from BASIC the basic view for Memo Record
P_Fa_Flowitem view from BASIC
P_Fqmflow view from BASIC
P_Fqmflow_CSH view from BASIC
P_FQMFLOWACTUALCASH view from BASIC
P_FqmflowCASH view from BASIC
P_FQMFLOWCASHPOS view from BASIC
P_FqmflowDetails view from BASIC
P_FqmflowP view from BASIC
P_FqmFlowScope view from BASIC Cash Flow with Scope
P_FqmflowTRMMM view from BASIC
P_RECNCLN_ACCID view inner BASIC
P_RecnclnRsltComprn view from BASIC
V_CMMRD view from Memo Record with Versioning
VFCP_DDL_FQM_FLOW view from
VFCP_DDL_TRM view from
VFCP_DDL_TRM_BASE view from

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY flow_id fqm_flow_id Flow ID
KEY valid_from fqm_valid_from FQM Flow Valid From
valid_to fqm_valid_to FQM Flow Valid To
software_version fqm_software_version Software Version
flg_actual fqm_flg_actual FQM Flag Actual
transaction_id fqm_transaction_id Transaction ID
parent_transaction_id fqm_parent_transaction_id Par. Trans. ID
parent_flow_id fqm_parent_flow_id Par. Flow ID
root_id fqm_flow_id Flow ID
deleted fqm_deleted Deleted
process_status fqm_process_status Status
cleared fqm_cleared Cleared
clearing_flow_id fqm_flow_id Flow ID
certainty_level fqm_certainty_level Certainty Level
owner fqm_owner Trans. Owner
transaction_date fqm_transaction_date Transaction Date
transaction_category fqm_transaction_category Transaction Category
flow_category fqm_flow_cat Flow Category
flow_type fqm_flow_type Flow Type
rel_status fqm_release_status Release Status
payment_date fqm_payment_date Payment Date
payment_currency fqm_currency Currency
document_date fqm_document_date Document Date
baseline_date fqm_baseline_date Baseline Date
days_due fqm_days_due Days until Due
cash_discount_days1 fqm_cash_discount_days1 Days Term 1
cash_discount_percent1 fqm_cash_discount_percent1 Percent 1st Term
cash_discount_days2 fqm_cash_discount_days2 Days Term 2
cash_discount_percent2 fqm_cash_discount_percent2 Percent 2nd Term
payment_method fqm_payment_method Payment Method
payment_block fqm_payment_block Payment Block
payment_mode fqm_payment_mode Payment Mode
fund bp_geber Fund
grant_nbr gm_grant_nbr Grant

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- FQM Flows
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FQM_FLOW (
    MANDT,                   -- Client [mandt]
    FLOW_ID,                 -- Flow ID [fqm_flow_id]
    VALID_FROM,              -- FQM Flow Valid From [fqm_valid_from]
    VALID_TO,                -- FQM Flow Valid To [fqm_valid_to]
    SOFTWARE_VERSION,        -- Software Version [fqm_software_version]
    FLG_ACTUAL,              -- FQM Flag Actual [fqm_flg_actual]
    TRANSACTION_ID,          -- Transaction ID [fqm_transaction_id]
    PARENT_TRANSACTION_ID,   -- Par. Trans. ID [fqm_parent_transaction_id]
    PARENT_FLOW_ID,          -- Par. Flow ID [fqm_parent_flow_id]
    ROOT_ID,                 -- Flow ID [fqm_flow_id]
    DELETED,                 -- Deleted [fqm_deleted]
    PROCESS_STATUS,          -- Status [fqm_process_status]
    CLEARED,                 -- Cleared [fqm_cleared]
    CLEARING_FLOW_ID,        -- Flow ID [fqm_flow_id]
    CERTAINTY_LEVEL,         -- Certainty Level [fqm_certainty_level]
    OWNER,                   -- Trans. Owner [fqm_owner]
    TRANSACTION_DATE,        -- Transaction Date [fqm_transaction_date]
    TRANSACTION_CATEGORY,    -- Transaction Category [fqm_transaction_category]
    FLOW_CATEGORY,           -- Flow Category [fqm_flow_cat]
    FLOW_TYPE,               -- Flow Type [fqm_flow_type]
    REL_STATUS,              -- Release Status [fqm_release_status]
    PAYMENT_DATE,            -- Payment Date [fqm_payment_date]
    PAYMENT_CURRENCY,        -- Currency [fqm_currency]
    DOCUMENT_DATE,           -- Document Date [fqm_document_date]
    BASELINE_DATE,           -- Baseline Date [fqm_baseline_date]
    DAYS_DUE,                -- Days until Due [fqm_days_due]
    CASH_DISCOUNT_DAYS1,     -- Days Term 1 [fqm_cash_discount_days1]
    CASH_DISCOUNT_PERCENT1,  -- Percent 1st Term [fqm_cash_discount_percent1]
    CASH_DISCOUNT_DAYS2,     -- Days Term 2 [fqm_cash_discount_days2]
    CASH_DISCOUNT_PERCENT2,  -- Percent 2nd Term [fqm_cash_discount_percent2]
    PAYMENT_METHOD,          -- Payment Method [fqm_payment_method]
    PAYMENT_BLOCK,           -- Payment Block [fqm_payment_block]
    PAYMENT_MODE,            -- Payment Mode [fqm_payment_mode]
    FUND,                    -- Fund [bp_geber]
    GRANT_NBR,               -- Grant [gm_grant_nbr]
    PRIMARY KEY (MANDT, FLOW_ID, VALID_FROM)
);

Learn More