SAP table FEBCL (Clearing data for an electronic bank statement line item)

SAP table FEBCL has 4 primary key fields being MANDT,KUKEY,ESNUM,CSNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KUKEY Short Key for Bank Statement (Surrogate Key) NUMC 8 0 KUKEY_EB
ESNUM Memo Record Number (Line Item Number in Bank Statement) NUMC 5 0 ESNUM_EB
CSNUM Clearing Record Number NUMC 3 0 CSNUM_EB
AGBUK Company Code CHAR 4 0 BUKRS
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
AGKON Account Number or Key of a Worklist CHAR 16 0 AGKON
AGUMS Special G/L Indicators for Selection CHAR 100 0 AGUMS
XFIFO Indicator: Distribute Automatically by Due Date CHAR 1 0 XFIFO_F05A
SELFD Field Name from the Document Index CHAR 5 0 FELDN_F05A
SELVON Input Field for Search Criterion for Selecting Open Items CHAR 25 0 SEL01_F05A_C25
SELBIS Input Field for Search Criterion for Selecting Open Items CHAR 25 0 SEL01_F05A_C25

FEBCL foreign key relationships

Table Field Check Table Check Field
0 FEBCL MANDT T000 Clients MANDT