FAR_BSM_RESULT

Transparent Table Application Table
61 Fields 1 CDS Views

Bank Statement Monitor Result

FAR_BSM_RESULT is an SAP database table in S/4HANA. Bank Statement Monitor Result. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BankStatementMonitor view_entity from BASIC Bank Statement Monitor

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bkstmntmonitoruuid guid_16 GUID 16
bkstmntkeydate far_bsm_key_date Key Date
company_code bukrs Company Code
housebank_id hbkid House Bank
account_id hktid Account ID
currency waers Currency
cm_account_name diskb CM acct name
country banks Bank Ctry/Reg.
bank_key bankl Bank Number
ext_account_no bankn Bank Account
alt_account_no bnkn2 Altern.Acct No.
gl_account hkont G/L Acct
statement_date farp_azdat Bank Statement Date
statement_no farp_aznum Bank Statement Number
no_items anzes_eb No. of Memo Rec
bankstatementimporttimestamp timestamp Time Stamp
open_bal_statemt farp_ssbtr Opening Balance
total_debits sumso_eb Total Debit
total_credits sumha_eb Total Credit
clos_bal_statemt farp_esbtr Closing Balance
clos_bal_gl esbtr_gl Closing Bal.G/L
diff_stat_gl diff_amt Difference
procstscritltymessagenumber msgnr Message
processstatuscriticality far_bsm_status_criticality Status Criticality
balstscriticalitymessagenumber msgnr Message
balancestatuscriticality far_bsm_status_criticality Status Criticality
srlnmbrstscritltymessagenumber msgnr Message
serialnumberstatuscriticality far_bsm_status_criticality Status Criticality
recnclnstscritltymessagenumber msgnr Message
reconclnstatuscriticality far_bsm_status_criticality Status Criticality
overallstatus far_bsm_status_criticality Status Criticality
bkstmntexpectedarrivaldate datum Date
swift_code swift SWIFT/BIC
contact_name ad_name1 Name
contact_tel ad_tlnmbr1 Telephone
bank_name banka Bank Name
kukey farp_kukey Statement Short Key
euser usnam User Name
bkont bkont Control Key
azpgno farp_azpgno Page Number
iban uiban IBAN House Bank
status fclm_bam_acc_status Account Status
importing_channel fclm_bam_importing_channel Importing Channel
procstat_act procstat_act Process Status
balstat_act balstat_act Difference Sts
serstat_act serstat_act Serial No. Sts
reconstat_act reconstat_act Reconcil. Sts
exp_number exp_number Interval
exp_rhyth exp_rhy Interval Unit
calendar wfcid Factory Cal. ID
amt_diff amt_diff Difference Amt
bs_post_cat fclm_bs_post_cat Post. Category (EoD)
created_at abp_creation_tstmpl Created On
created_by abp_creation_user Created By
acc_id fclm_bam_acc_id Technical ID
acc_type_id fclm_bam_bk_acc_type_id Account Type
bs_forwarding fclm_bs_forwarding File Forwarding
refbyprocessingapplication far_bs_itm_ref_by_proc_app Ref. Proc. App.
bankstmntprocessingapplication far_bs_itm_processing_app Proc. App.
refprocapplmessagenumber msgnr Message

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.

-- Bank Statement Monitor Result
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAR_BSM_RESULT (
    MANDT,                           -- Client [mandt]
    BKSTMNTMONITORUUID,              -- GUID 16 [guid_16]
    BKSTMNTKEYDATE,                  -- Key Date [far_bsm_key_date]
    COMPANY_CODE,                    -- Company Code [bukrs]
    HOUSEBANK_ID,                    -- House Bank [hbkid]
    ACCOUNT_ID,                      -- Account ID [hktid]
    CURRENCY,                        -- Currency [waers]
    CM_ACCOUNT_NAME,                 -- CM acct name [diskb]
    COUNTRY,                         -- Bank Ctry/Reg. [banks]
    BANK_KEY,                        -- Bank Number [bankl]
    EXT_ACCOUNT_NO,                  -- Bank Account [bankn]
    ALT_ACCOUNT_NO,                  -- Altern.Acct No. [bnkn2]
    GL_ACCOUNT,                      -- G/L Acct [hkont]
    STATEMENT_DATE,                  -- Bank Statement Date [farp_azdat]
    STATEMENT_NO,                    -- Bank Statement Number [farp_aznum]
    NO_ITEMS,                        -- No. of Memo Rec [anzes_eb]
    BANKSTATEMENTIMPORTTIMESTAMP,    -- Time Stamp [timestamp]
    OPEN_BAL_STATEMT,                -- Opening Balance [farp_ssbtr]
    TOTAL_DEBITS,                    -- Total Debit [sumso_eb]
    TOTAL_CREDITS,                   -- Total Credit [sumha_eb]
    CLOS_BAL_STATEMT,                -- Closing Balance [farp_esbtr]
    CLOS_BAL_GL,                     -- Closing Bal.G/L [esbtr_gl]
    DIFF_STAT_GL,                    -- Difference [diff_amt]
    PROCSTSCRITLTYMESSAGENUMBER,     -- Message [msgnr]
    PROCESSSTATUSCRITICALITY,        -- Status Criticality [far_bsm_status_criticality]
    BALSTSCRITICALITYMESSAGENUMBER,  -- Message [msgnr]
    BALANCESTATUSCRITICALITY,        -- Status Criticality [far_bsm_status_criticality]
    SRLNMBRSTSCRITLTYMESSAGENUMBER,  -- Message [msgnr]
    SERIALNUMBERSTATUSCRITICALITY,   -- Status Criticality [far_bsm_status_criticality]
    RECNCLNSTSCRITLTYMESSAGENUMBER,  -- Message [msgnr]
    RECONCLNSTATUSCRITICALITY,       -- Status Criticality [far_bsm_status_criticality]
    OVERALLSTATUS,                   -- Status Criticality [far_bsm_status_criticality]
    BKSTMNTEXPECTEDARRIVALDATE,      -- Date [datum]
    SWIFT_CODE,                      -- SWIFT/BIC [swift]
    CONTACT_NAME,                    -- Name [ad_name1]
    CONTACT_TEL,                     -- Telephone [ad_tlnmbr1]
    BANK_NAME,                       -- Bank Name [banka]
    KUKEY,                           -- Statement Short Key [farp_kukey]
    EUSER,                           -- User Name [usnam]
    BKONT,                           -- Control Key [bkont]
    AZPGNO,                          -- Page Number [farp_azpgno]
    IBAN,                            -- IBAN House Bank [uiban]
    STATUS,                          -- Account Status [fclm_bam_acc_status]
    IMPORTING_CHANNEL,               -- Importing Channel [fclm_bam_importing_channel]
    PROCSTAT_ACT,                    -- Process Status [procstat_act]
    BALSTAT_ACT,                     -- Difference Sts [balstat_act]
    SERSTAT_ACT,                     -- Serial No. Sts [serstat_act]
    RECONSTAT_ACT,                   -- Reconcil. Sts [reconstat_act]
    EXP_NUMBER,                      -- Interval [exp_number]
    EXP_RHYTH,                       -- Interval Unit [exp_rhy]
    CALENDAR,                        -- Factory Cal. ID [wfcid]
    AMT_DIFF,                        -- Difference Amt [amt_diff]
    BS_POST_CAT,                     -- Post. Category (EoD) [fclm_bs_post_cat]
    CREATED_AT,                      -- Created On [abp_creation_tstmpl]
    CREATED_BY,                      -- Created By [abp_creation_user]
    ACC_ID,                          -- Technical ID [fclm_bam_acc_id]
    ACC_TYPE_ID,                     -- Account Type [fclm_bam_bk_acc_type_id]
    BS_FORWARDING,                   -- File Forwarding [fclm_bs_forwarding]
    REFBYPROCESSINGAPPLICATION,      -- Ref. Proc. App. [far_bs_itm_ref_by_proc_app]
    BANKSTMNTPROCESSINGAPPLICATION,  -- Proc. App. [far_bs_itm_processing_app]
    REFPROCAPPLMESSAGENUMBER,        -- Message [msgnr]
    PRIMARY KEY (MANDT, BKSTMNTMONITORUUID)
);

Learn More