SAP FLQITEM Liquidity Calculation - Line Items for FI Documents Table data and field list

FLQITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Liquidity Calculation - Line Items for FI Documents" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FLQITEM TYPE FLQITEM.

The FLQITEM table consists of various fields, each holding specific information or linking keys about Liquidity Calculation - Line Items for FI Documents data available in SAP. These include MANDT (Client), ZBUKR (Liquidity Calculation: Paying Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

FLQITEM structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FLQITEM structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FLQITEM table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
LQTYPE	Liquidity Calculation: Line Item Category	FLQTYPE	CHAR	1			FLQTYPE
MANDT	Client	MANDT	CLNT	3	T000		MANDT
ZBUKR	Liquidity Calculation: Paying Company Code	FLQBUKRS	CHAR	4	T001		BUKRS	BUK
BELNR	Accounting Document Number	BELNR_D	CHAR	10	BKPF	ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
LQPOS	Liquidity Item	FLQPOS	CHAR	16	FLQLPOS	ALPHA	FLQPOS	FLQPOS	FLQLQPOS
LQORIG	Liquidity Calculation: Origin of Item	FLQORIG	CHAR	1			FLQORIG	FLQOR
GUID	GUID in 'CHAR' Format in Uppercase	GUID_32	CHAR	32			SYSUUID_C
KUKEY	Short key (surrogate)	KUKEY_EB	NUMC	8	FEBEP		KUKEY_EB
ESNUM	Memo record number (line item number in bank statement)	ESNUM_EB	NUMC	5	FEBEP		NUM5
HKONT	General Ledger Account	HKONT	CHAR	10	Assigned to domain	ALPHA	SAKNR
LQDAY	Liquidity Calculation: Payment Date	FLQDAY	DATS	8			DATUM	FLQDAY
TWAER	Transaction Currency	TWAER	CUKY	5	Assigned to domain		WAERS	FWS
WRBTR	Liquidity Calculation: Amount in Transaction Currency	FLQWRIT	CURR	15(2)			WERTV8
DMBTR	Liquidity Calculation: Amount in Local Currency	FLQDMIT	CURR	15(2)			WERTV8
XDELETE	Liquidity Calculation: Historical Line Item	FLQXDEL	CHAR	1			XFELD
CPUDT	Date	DATUM	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
UNAME	User Name	UNAME	CHAR	12			UNAME
PKOART	Account Type	KOART	CHAR	1			KOART
PARTNER	Liquidity Calculation: Counterparty for Payment	FLQPARTNER	CHAR	10		ALPHA	FLQPARTNER
KWBTR	Liquidity Calculation: Amount in Third Currency	FLQKWIT	CURR	15(2)			WERTV8
VBUND	Company ID of trading partner	RASSC	CHAR	6	Assigned to domain	ALPHA	RCOMP	PGS
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
FDLEV	Planning level	FDLEV	CHAR	2	Assigned to domain		FDLEV	FFE

Key field

Non-key field

< FLQINVEXIT - Liquidity Calculation - Settings for Invoice Exit FLQITEMBS - Liquidity Calculation - Line Items for Bank Statement Docs >

How do I retrieve data from SAP structure FLQITEM using ABAP code?

As FLQITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FLQITEM as there is no data to select.

How to access SAP table FLQITEM

Within an ECC or HANA version of SAP you can also view further information about FLQITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).