EPICT_BRS

Transparent Table Application Table
25 Fields 1 CDS Views

Bank Reconciliation Statement

EPICT_BRS is an SAP database table in S/4HANA. Bank Reconciliation Statement. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CN_BankRecnclnStatement view from BASIC Bank Reconciliation Statement for China

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY hbkid hbkid House Bank
KEY hktid hktid Account ID
KEY reconciliation_date epic_brs_reconciliation_date Reconciliation Date
rldnr fins_ledger Ledger
waers waers Currency
bank_gl_account racct Account Number
bankn bankn Bank Account
refzl refzl Reference info.
bank_end_balance epic_brs_bank_balance_amt Bank Balance Amount
entrps_end_balance epic_brs_gl_balance_amt Closing Balance
bank_adjusted_end_balance epic_brs_adjusted_bk_bal Adj.Closing Balance
entrps_adjusted_end_balance epic_brs_adjusted_gl_bal Adj.Closing Balance
recptinjewobank epic_brs_unmtchd_recpt_je Umtchd Incing. In JE
recptinbankwoje epic_brs_unmtchd_recpt_bk Umtchd Incing. In BK
paymntinjewobank epic_brs_unmtchd_paymnt_je Umtchd Otcing. In JE
paymntinbankwoje epic_brs_unmtchd_paymnt_bk Umtchd Otcing. In BK
reconciliation_date_last epic_brs_reconciliation_date_l Last Reco. Date
epic_br_rcon_status epic_br_rcon_status Bank Recon. Status
created_user epic_brs_created_user Created By
created_timestamp epic_brs_created_timestamp Timestamp (Created)
changed_user epic_brs_changed_user Changed By
changed_timestamp epic_brs_changed_timestamp Timestamp (Changed)
_dataaging data_temperature Data Aging

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 Reconciliation Statement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EPICT_BRS (
    MANDT,                        -- Client [mandt]
    BUKRS,                        -- Company Code [bukrs]
    HBKID,                        -- House Bank [hbkid]
    HKTID,                        -- Account ID [hktid]
    RECONCILIATION_DATE,          -- Reconciliation Date [epic_brs_reconciliation_date]
    RLDNR,                        -- Ledger [fins_ledger]
    WAERS,                        -- Currency [waers]
    BANK_GL_ACCOUNT,              -- Account Number [racct]
    BANKN,                        -- Bank Account [bankn]
    REFZL,                        -- Reference info. [refzl]
    BANK_END_BALANCE,             -- Bank Balance Amount [epic_brs_bank_balance_amt]
    ENTRPS_END_BALANCE,           -- Closing Balance [epic_brs_gl_balance_amt]
    BANK_ADJUSTED_END_BALANCE,    -- Adj.Closing Balance [epic_brs_adjusted_bk_bal]
    ENTRPS_ADJUSTED_END_BALANCE,  -- Adj.Closing Balance [epic_brs_adjusted_gl_bal]
    RECPTINJEWOBANK,              -- Umtchd Incing. In JE [epic_brs_unmtchd_recpt_je]
    RECPTINBANKWOJE,              -- Umtchd Incing. In BK [epic_brs_unmtchd_recpt_bk]
    PAYMNTINJEWOBANK,             -- Umtchd Otcing. In JE [epic_brs_unmtchd_paymnt_je]
    PAYMNTINBANKWOJE,             -- Umtchd Otcing. In BK [epic_brs_unmtchd_paymnt_bk]
    RECONCILIATION_DATE_LAST,     -- Last Reco. Date [epic_brs_reconciliation_date_l]
    EPIC_BR_RCON_STATUS,          -- Bank Recon. Status [epic_br_rcon_status]
    CREATED_USER,                 -- Created By [epic_brs_created_user]
    CREATED_TIMESTAMP,            -- Timestamp (Created) [epic_brs_created_timestamp]
    CHANGED_USER,                 -- Changed By [epic_brs_changed_user]
    CHANGED_TIMESTAMP,            -- Timestamp (Changed) [epic_brs_changed_timestamp]
    _DATAAGING,                   -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS, HBKID, HKTID, RECONCILIATION_DATE)
);

Learn More