FEBCL

Transparent Table Application Table

Clearing data for an electronic bank statement line item

FEBCL is an SAP database table in S/4HANA. Clearing data for an electronic bank statement line item. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
farvd_febcl_with_ext view from FEBCL with extended fields of FEBCL_EXT
I_ARBankStmntItmClearing view from BASIC Clearing Data of a Bank Statement Item
I_CshMgmtBkStmntItmClrg view from BASIC Clearing Data of a Bank Statement Item
P_ARBSITMCLRSUGGEST view from BASIC
P_FEBCL view from BASIC
P_FEBCL_BELNR_VALID view from BASIC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY kukey KUKEY_EB Short Key
KEY esnum ESNUM_EB Memo Record No.
KEY csnum CSNUM_EB Clearing Rec No
agbuk BUKRS Company Code
koart KOART Account type
agkon AGKON Account
agums AGUMS Special G/L Ind
xfifo XFIFO_F05A Distrib.by Age
selfd FELDN_F05A Field
selvon SEL01_F05A_C25 Input Field for Search Criterion for Selecting Open Items
selbis SEL01_F05A_C25 Input Field for Search Criterion for Selecting Open Items

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.

-- Clearing data for an electronic bank statement line item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FEBCL (
    MANDT,   -- Client [MANDT]
    KUKEY,   -- Short Key [KUKEY_EB]
    ESNUM,   -- Memo Record No. [ESNUM_EB]
    CSNUM,   -- Clearing Rec No [CSNUM_EB]
    AGBUK,   -- Company Code [BUKRS]
    KOART,   -- Account type [KOART]
    AGKON,   -- Account [AGKON]
    AGUMS,   -- Special G/L Ind [AGUMS]
    XFIFO,   -- Distrib.by Age [XFIFO_F05A]
    SELFD,   -- Field [FELDN_F05A]
    SELVON,  -- Input Field for Search Criterion for Selecting Open Items [SEL01_F05A_C25]
    SELBIS,  -- Input Field for Search Criterion for Selecting Open Items [SEL01_F05A_C25]
    PRIMARY KEY (MANDT, KUKEY, ESNUM, CSNUM)
);