FQMET_BALANCE

Transparent Table Application Table
22 Fields 3 CDS Views

Manually Entered Balance

FQMET_BALANCE is an SAP database table in S/4HANA. Manually Entered Balance. It contains 22 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BankCashBalanceHistory view_entity from BASIC Bank Cash Balance History
VFCLM_BAM_DDL_FBAR15 view inner The 15th view for FBAR
VFCLM_BAM_FBAR14 view from The 14th view for FBAR

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY db_key FQM_ID ID
transaction_id FQM_TRANSACTION_ID Transaction ID
origin_system LOGSYS Logical system
origin_application FQM_ORIGIN_APPLICATION Source Application
origin_document_id FQM_ORIGIN_DOC_ID Source Doc. ID
transaction_date FQM_TRANSACTION_DATE Transaction Date
company_code BUKRS Company Code
entry_category FQME_ENTRY_CATEGORY Entry Category
release_status FQME_RELEASE_STATUS Release Status
bank_account_id FQM_BANK_ACCOUNT_ID Technical ID
balance_amount FQME_BALANCE_AMT Balance Amount
balance_currency FQME_BALANCE_CURR Currency
create_user FQM_CREATE_USER Fqm Create User
last_update_user FQM_UPDATE_USER Fqm Last Update User
create_timestamp FQM_CREATE_TIMESTAMP FQM Flow Created At
last_update_timestamp FQM_UPDATE_TIMESTAMP FQM Flow Update Time
balance_category FQME_BALANCE_CATEGORY Balance Category
sequence_number FQME_SEQUENCE_NUMBER Number
balance_channel FCLM_BALANCE_CHANNEL Update Method
balance_type FCLM_BALANCE_TYPE Balance Type
delete_flag ABAP_BOOLEAN Truth Value

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.

-- Manually Entered Balance
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FQMET_BALANCE (
    CLIENT,                 -- Client [MANDT]
    DB_KEY,                 -- ID [FQM_ID]
    TRANSACTION_ID,         -- Transaction ID [FQM_TRANSACTION_ID]
    ORIGIN_SYSTEM,          -- Logical system [LOGSYS]
    ORIGIN_APPLICATION,     -- Source Application [FQM_ORIGIN_APPLICATION]
    ORIGIN_DOCUMENT_ID,     -- Source Doc. ID [FQM_ORIGIN_DOC_ID]
    TRANSACTION_DATE,       -- Transaction Date [FQM_TRANSACTION_DATE]
    COMPANY_CODE,           -- Company Code [BUKRS]
    ENTRY_CATEGORY,         -- Entry Category [FQME_ENTRY_CATEGORY]
    RELEASE_STATUS,         -- Release Status [FQME_RELEASE_STATUS]
    BANK_ACCOUNT_ID,        -- Technical ID [FQM_BANK_ACCOUNT_ID]
    BALANCE_AMOUNT,         -- Balance Amount [FQME_BALANCE_AMT]
    BALANCE_CURRENCY,       -- Currency [FQME_BALANCE_CURR]
    CREATE_USER,            -- Fqm Create User [FQM_CREATE_USER]
    LAST_UPDATE_USER,       -- Fqm Last Update User [FQM_UPDATE_USER]
    CREATE_TIMESTAMP,       -- FQM Flow Created At [FQM_CREATE_TIMESTAMP]
    LAST_UPDATE_TIMESTAMP,  -- FQM Flow Update Time [FQM_UPDATE_TIMESTAMP]
    BALANCE_CATEGORY,       -- Balance Category [FQME_BALANCE_CATEGORY]
    SEQUENCE_NUMBER,        -- Number [FQME_SEQUENCE_NUMBER]
    BALANCE_CHANNEL,        -- Update Method [FCLM_BALANCE_CHANNEL]
    BALANCE_TYPE,           -- Balance Type [FCLM_BALANCE_TYPE]
    DELETE_FLAG,            -- Truth Value [ABAP_BOOLEAN]
    PRIMARY KEY (CLIENT, DB_KEY)
);

Learn More