EPIC_EBR_FEB
Additional Data on Bank Statement Line Item for Bank Receipt
EPIC_EBR_FEB is an SAP database table in S/4HANA. Additional Data on Bank Statement Line Item for Bank Receipt. It contains 34 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_CN_BANKRECEIPT | view_entity | from | BASIC | Bank Receipt Information for China |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | ebr_id | epic_ebr_id | Bnk Receipt ID | |||
| kukey | kukey_eb | Short Key | ||||
| esnum | esnum_eb | Memo Record No. | ||||
| ebr_no | epic_ebr_no | Bnk Receipt No. | ||||
| part_bank_ctry | epic_ebr_part_bank_ctry | PartBnkCtry | ||||
| part_bank_key | epic_ebr_part_bank_key | PartBankKey | ||||
| part_bank_name | epic_ebr_part_bank_name | PartnerBankName | ||||
| bank_time | epic_ebr_bank_time | Trnsctn Time | ||||
| srl_no | epic_ebr_srl_no | Serial Number | ||||
| verificat_key | epic_ebr_verificat_key | Verif. Key | ||||
| bank_timestamp | epic_ebr_bank_timestamp | Time Stamp | ||||
| bank_branch | epic_ebr_bank_branch | Bank Branch | ||||
| bank_teller | epic_ebr_bank_teller | Bank Teller | ||||
| print_times | epic_ebr_print_times | Printing No. | ||||
| status | epic_ebr_status | Receipt Status | ||||
| ebr_date | epic_ebr_date | Bnk Rt Entrd On | ||||
| source | epic_ebr_source | Bnk Rct Entry | ||||
| reference | epic_ebr_ref_key | Reference Key | ||||
| fake_ebr_no | epic_ebr_no_type | Rcpt No. Type | ||||
| flowscode | epic_flowscode | Cash Flow Cat. | ||||
| vbund | rassc | Trading Partner | ||||
| local_amt | dmbtr | Amount in LC | ||||
| balance | epic_ebr_acct_bal | Balance | ||||
| cb_litems | epic_ccb_consumed_litems | Liquidity Item | ||||
| fdflg | epic_ebr_finddoc_flg | Finded document | ||||
| reconcile_flag | copc_reconcile_flag | Reconciled | ||||
| reconcile_date | copc_reconcile_date | Reconc. Date | ||||
| summary | epic_ebr_summary | Summary | ||||
| ebr_use | epic_ebr_use | Usage | ||||
| bank_remark | epic_ebr_bank_remark | Bank's Remark | ||||
| keyno | prq_keyno | Key Number | ||||
| xreversal | epic_ebr_reversal | Reversal Transaction | ||||
| blart | blart | Document Type |
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.
-- Additional Data on Bank Statement Line Item for Bank Receipt
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EPIC_EBR_FEB (
MANDT, -- Client [mandt]
EBR_ID, -- Bnk Receipt ID [epic_ebr_id]
KUKEY, -- Short Key [kukey_eb]
ESNUM, -- Memo Record No. [esnum_eb]
EBR_NO, -- Bnk Receipt No. [epic_ebr_no]
PART_BANK_CTRY, -- PartBnkCtry [epic_ebr_part_bank_ctry]
PART_BANK_KEY, -- PartBankKey [epic_ebr_part_bank_key]
PART_BANK_NAME, -- PartnerBankName [epic_ebr_part_bank_name]
BANK_TIME, -- Trnsctn Time [epic_ebr_bank_time]
SRL_NO, -- Serial Number [epic_ebr_srl_no]
VERIFICAT_KEY, -- Verif. Key [epic_ebr_verificat_key]
BANK_TIMESTAMP, -- Time Stamp [epic_ebr_bank_timestamp]
BANK_BRANCH, -- Bank Branch [epic_ebr_bank_branch]
BANK_TELLER, -- Bank Teller [epic_ebr_bank_teller]
PRINT_TIMES, -- Printing No. [epic_ebr_print_times]
STATUS, -- Receipt Status [epic_ebr_status]
EBR_DATE, -- Bnk Rt Entrd On [epic_ebr_date]
SOURCE, -- Bnk Rct Entry [epic_ebr_source]
REFERENCE, -- Reference Key [epic_ebr_ref_key]
FAKE_EBR_NO, -- Rcpt No. Type [epic_ebr_no_type]
FLOWSCODE, -- Cash Flow Cat. [epic_flowscode]
VBUND, -- Trading Partner [rassc]
LOCAL_AMT, -- Amount in LC [dmbtr]
BALANCE, -- Balance [epic_ebr_acct_bal]
CB_LITEMS, -- Liquidity Item [epic_ccb_consumed_litems]
FDFLG, -- Finded document [epic_ebr_finddoc_flg]
RECONCILE_FLAG, -- Reconciled [copc_reconcile_flag]
RECONCILE_DATE, -- Reconc. Date [copc_reconcile_date]
SUMMARY, -- Summary [epic_ebr_summary]
EBR_USE, -- Usage [epic_ebr_use]
BANK_REMARK, -- Bank's Remark [epic_ebr_bank_remark]
KEYNO, -- Key Number [prq_keyno]
XREVERSAL, -- Reversal Transaction [epic_ebr_reversal]
BLART, -- Document Type [blart]
PRIMARY KEY (MANDT, EBR_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA