The FLQITEMBS table in SAP ERP or S/4HANA stores Liquidity Calculation – Line Items for Bank Statement Docs data. There are total 26 fields in FLQITEMBS table. The Liquidity Calculation – Line Items for Bank Statement Docs table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FLQITEMBS table. It is in Liquidity Calculation (FFLQ) ABAP package and is part of the Treasury (TR) module.
SAP FLQITEMBS Table Fields
Following is the list of fields that are available in SAP FLQITEMBS table. The primary key fields of the table are MANDT (Client), ZBUKR (Liquidity Calculation: Paying Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document), BUKRS (Company Code), GSBER (Business Area), LQPOS (Liquidity Item), LQORIG (Liquidity Calculation: Origin of Item), GUID (GUID in ‘CHAR’ Format in Uppercase).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| ZBUKR | Liquidity Calculation: Paying Company Code | FLQBUKRS | T001 | CHAR (4) |
| BELNR | Accounting Document Number | BELNR_D | BKPF | CHAR (10) |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| GSBER | Business Area | GSBER | * | CHAR (4) |
| LQPOS | Liquidity Item | FLQPOS | FLQLPOS | CHAR (16) |
| LQORIG | Liquidity Calculation: Origin of Item | FLQORIG | CHAR (1) | |
| GUID | GUID in ‘CHAR’ Format in Uppercase | GUID_32 | CHAR (32) | |
| KUKEY | Short Key (Surrogate) | KUKEY_EB | FEBEP | NUMC (8) |
| ESNUM | Memo Record Number (Line Item Number in Bank Statement) | ESNUM_EB | FEBEP | NUMC (5) |
| HKONT | General Ledger Account | HKONT | * | CHAR (10) |
| LQDAY | Liquidity Calculation: Payment Date | FLQDAY | DATS (8) | |
| TWAER | Transaction Currency | TWAER | * | CUKY (5) |
| WRBTR | Liquidity Calculation: Amount in Transaction Currency | FLQWRIT | CURR (15) | |
| DMBTR | Liquidity Calculation: Amount in Local Currency | FLQDMIT | CURR (15) | |
| XDELETE | Liquidity Calculation: Historical Line Item | FLQXDEL | CHAR (1) | |
| CPUDT | Date | DATUM | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| UNAME | User Name | UNAME | CHAR (12) | |
| PKOART | Account type | KOART | CHAR (1) | |
| PARTNER | Liquidity Calculation: Counterparty for Payment | FLQPARTNER | CHAR (10) | |
| KWBTR | Liquidity Calculation: Amount in Third Currency | FLQKWIT | CURR (15) | |
| VBUND | Company ID of Trading Partner | RASSC | * | CHAR (6) |
| PRCTR | Profit Center | PRCTR | * | CHAR (10) |
