1. Home
  2. Resources
  3. SAP Tables
  4. FLQITEMBS - Liquidity Calculation - Line Items for Bank Statement Docs

SAP Table FLQITEMBS

Liquidity Calculation - Line Items for Bank Statement Docs

FLQITEMBS (Liquidity Calculation - Line Items for Bank Statement Docs) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FLQITEMBS to other SAP tables.

FLQITEMBS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ZBUKR Liquidity Calculation: Paying Company Code FLQBUKRS T001 CHAR 4 0
BELNR Accounting Document Number BELNR_D BKPF CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
LQPOS Liquidity Item FLQPOS FLQLPOS CHAR 16 0
LQORIG Liquidity Calculation: Origin of Item FLQORIG CHAR 1 0
NULL Initial Value When Generating Item
A From G/L Account
B From Bank Statement Text Information
C From Clearing Information
M Manual Change
D From Invoices
E From Global Exit
R Reversal
S Stop
T From Treasury Deal
W From Security Planned Record
F From Uni-Directional Document Chains
L From Loan
GUID GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
KUKEY Short key (surrogate) KUKEY_EB FEBEP NUMC 8 0
ESNUM Memo record number (line item number in bank statement) ESNUM_EB FEBEP NUMC 5 0
HKONT General Ledger Account HKONT CHAR 10 0
LQDAY Liquidity Calculation: Payment Date FLQDAY DATS 8 0
TWAER Transaction Currency TWAER CUKY 5 0
WRBTR Liquidity Calculation: Amount in Transaction Currency FLQWRIT CURR 15 2
DMBTR Liquidity Calculation: Amount in Local Currency FLQDMIT CURR 15 2
XDELETE Liquidity Calculation: Historical Line Item FLQXDEL CHAR 1 0
X Yes
NULL No
CPUDT Date DATUM DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
UNAME User Name UNAME CHAR 12 0
PKOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
PARTNER Liquidity Calculation: Counterparty for Payment FLQPARTNER CHAR 10 0
KWBTR Liquidity Calculation: Amount in Third Currency FLQKWIT CURR 15 2
VBUND Company ID of trading partner RASSC CHAR 6 0
PRCTR Profit Center PRCTR CHAR 10 0

FLQITEMBS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FLQITEMBS BELNR FLQITEMBS BELNR BKPF Accounting Document Header BELNR
FLQITEMBS BELNR FLQITEMBS GJAHR BKPF Accounting Document Header GJAHR
FLQITEMBS BELNR FLQITEMBS MANDT BKPF Accounting Document Header MANDT
FLQITEMBS BELNR FLQITEMBS ZBUKR BKPF Accounting Document Header BUKRS
FLQITEMBS BUKRS FLQITEMBS MANDT T001 Company Codes MANDT
FLQITEMBS BUKRS FLQITEMBS BUKRS T001 Company Codes BUKRS
FLQITEMBS ESNUM FLQITEMBS MANDT FEBEP Electronic Bank Statement Line Items MANDT
FLQITEMBS ESNUM FLQITEMBS KUKEY FEBEP Electronic Bank Statement Line Items KUKEY
FLQITEMBS ESNUM FLQITEMBS ESNUM FEBEP Electronic Bank Statement Line Items ESNUM
FLQITEMBS KUKEY FLQITEMBS MANDT FEBEP Electronic Bank Statement Line Items MANDT
FLQITEMBS KUKEY FLQITEMBS KUKEY FEBEP Electronic Bank Statement Line Items KUKEY
FLQITEMBS KUKEY FLQITEMBS ESNUM FEBEP Electronic Bank Statement Line Items ESNUM
FLQITEMBS LQPOS FLQITEMBS MANDT FLQLPOS Liquidity Items MANDT
FLQITEMBS LQPOS FLQITEMBS LQPOS FLQLPOS Liquidity Items LQPOS
FLQITEMBS MANDT FLQITEMBS MANDT T000 Clients MANDT
FLQITEMBS ZBUKR FLQITEMBS MANDT T001 Company Codes MANDT
FLQITEMBS ZBUKR FLQITEMBS ZBUKR T001 Company Codes BUKRS