SAP FLQITEMPR_FC Liquidity Calc. Forecast - Line Items, Purchase Requisitions Table data and field list

FLQITEMPR_FC is a standard SAP Table which is used to store Liquidity Calc. Forecast - Line Items, Purchase Requisitions data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FLQITEMPR_FC table consists of various fields, each holding specific information or linking keys about Liquidity Calc. Forecast - Line Items, Purchase Requisitions data available in SAP. These include BANFN (Purchase Requisition Number), BNFPO (Item Number of Purchase Requisition), ZEBKN (Serial number for PReq account assignment segment), GUID (GUID in 'CHAR' Format in Uppercase)... 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. .

FLQITEMPR_FC table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FLQITEMPR_FC table 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 FLQITEMPR_FC 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
ZEBKNSerial number for PReq account assignment segment DZEBKNNUMC2ZEBKN
GUIDGUID in 'CHAR' Format in Uppercase GUID_32CHAR32SYSUUID_C
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
LQPOSLiquidity Item FLQPOSCHAR16ALPHAFLQPOSFLQPOSFLQLQPOS
LQDAYPlanning date FDTAGDATS8DATUMFDT
TWAERTransaction Currency TWAERCUKY5Assigned to domainWAERSFWS
WRBTRLiquidity Calculation: Amount in Transaction Currency FLQWRITCURR15(2) WERTV8
DMBTRLiquidity Calculation: Amount in Local Currency FLQDMITCURR15(2) WERTV8
CPUDTDate DATUMDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
UNAMEUser Name UNAMECHAR12UNAME
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
LIFNRVendor Account Number ELIFNCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY

Key field Non-key field



How do I retrieve data from SAP table FLQITEMPR_FC using ABAP code

The following ABAP code Example will allow you to do a basic selection on FLQITEMPR_FC to SELECT all data from the table
DATA: WA_FLQITEMPR_FC TYPE FLQITEMPR_FC.

SELECT SINGLE *
FROM FLQITEMPR_FC
INTO CORRESPONDING FIELDS OF WA_FLQITEMPR_FC
WHERE...

How to access SAP table FLQITEMPR_FC

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

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