FQMET_BALANCE

Transparent Table Application Table
18 Fields 5 CDS Views

Manually Entered Balance

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

CDS Views using this table (5)

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

Fields (18)

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_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
available_balance_source fclm_balance_clav_source
available_at fclm_balance_available_at

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_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]
    AVAILABLE_BALANCE_SOURCE,  -- fclm_balance_clav_source
    AVAILABLE_AT,              -- fclm_balance_available_at
    PRIMARY KEY (CLIENT, DB_KEY)
);

Learn More