SAP table FLQITEMBS (Liquidity Calculation - Line Items for Bank Statement Docs)

SAP table FLQITEMBS has 10 primary key fields being MANDT,ZBUKR,BELNR,GJAHR,BUZEI,BUKRS,GSBER,LQPOS,LQORIG,GUID.

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
ZBUKR Liquidity Calculation: Paying Company Code CHAR 4 0 T001 FLQBUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BKPF BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BUKRS Company Code CHAR 4 0 T001 BUKRS
GSBER Business Area CHAR 4 0 GSBER
LQPOS Liquidity Item CHAR 16 0 FLQLPOS FLQPOS
LQORIG Liquidity Calculation: Origin of Item CHAR 1 0 FLQORIG
Initial Value When Generating Item
A From G/L Account
B From Bank Statement Text Information
C From Clearing Information
D From Invoices
E From Global Exit
F From Uni-Directional Document Chains
L From Loan
M Manual Change
R Reversal
S Stop
T From Treasury Deal
W From Security Planned Record
X One Exposure from Operations Hub
GUID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
KUKEY Short Key for Bank Statement (Surrogate Key) NUMC 8 0 FEBEP KUKEY_EB
ESNUM Memo Record Number (Line Item Number in Bank Statement) NUMC 5 0 FEBEP ESNUM_EB
HKONT General Ledger Account CHAR 10 0 HKONT
LQDAY Liquidity Calculation: Payment Date DATS 8 0 FLQDAY
TWAER Transaction Currency CUKY 5 0 TWAER
WRBTR Liquidity Calculation: Amount in Transaction Currency CURR 15 2 FLQWRIT
DMBTR Liquidity Calculation: Amount in Local Currency CURR 15 2 FLQDMIT
XDELETE Liquidity Calculation: Historical Line Item CHAR 1 0 FLQXDEL
CPUDT Date DATS 8 0 DATUM
CPUTM Time of Entry TIMS 6 0 CPUTM
UNAME User Name CHAR 12 0 UNAME
PKOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
PARTNER Liquidity Calculation: Counterparty for Payment CHAR 10 0 FLQPARTNER
KWBTR Liquidity Calculation: Amount in Third Currency CURR 15 2 FLQKWIT
VBUND Company ID of Trading Partner CHAR 6 0 * RASSC
PRCTR Profit Center CHAR 10 0 PRCTR

FLQITEMBS foreign key relationships

Table Field Check Table Check Field
0 FLQITEMBS BELNR BKPF Accounting Document Header BUKRS
0 FLQITEMBS BELNR BKPF Accounting Document Header BELNR
0 FLQITEMBS BELNR BKPF Accounting Document Header GJAHR
1 FLQITEMBS BUKRS T001 Company Codes BUKRS
0 FLQITEMBS ESNUM FEBEP Electronic Bank Statement Line Items KUKEY
0 FLQITEMBS ESNUM FEBEP Electronic Bank Statement Line Items ESNUM
1 FLQITEMBS KUKEY FEBEP Electronic Bank Statement Line Items KUKEY
1 FLQITEMBS KUKEY FEBEP Electronic Bank Statement Line Items ESNUM
0 FLQITEMBS MANDT T000 Clients MANDT
1 FLQITEMBS ZBUKR T001 Company Codes BUKRS