SAP FMLI_S_DRILLDOWN Structure to search line items documents based on line data Table data and field list

FMLI_S_DRILLDOWN 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 "Structure to search line items documents based on line data" 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_FMLI_S_DRILLDOWN TYPE FMLI_S_DRILLDOWN.

The FMLI_S_DRILLDOWN table consists of various fields, each holding specific information or linking keys about Structure to search line items documents based on line data data available in SAP. These include RYEAR (Fiscal Year), DOCNR (Accounting Document Number), DOCLN (Six-Character Posting Item for Ledger), RLDNR (Ledger)... 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. .

FMLI_S_DRILLDOWN structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP FMLI_S_DRILLDOWN 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 FMLI_S_DRILLDOWN 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
RFIKRS	Financial Management Area	FIKRS	CHAR	4	Assigned to domain		FIKRS	FIK
RYEAR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
DOCNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
DOCLN	Six-Character Posting Item for Ledger	DOCLN6	CHAR	6			DOCLN6
RLDNR	Ledger	RLDNR	CHAR	2	Assigned to domain	ALPHA	RLDNR	GLN	H_T881
BUDCATT	Text (15 characters)	TEXT15	CHAR	15			TEXT15
RVERS	Version	VERSN	CHAR	3	Assigned to domain	ALPHA	COVERSI	KVS
RTCUR	Currency Key	RTCUR	CUKY	5	Assigned to domain		WAERS	FWS
VALTYPE_9	BCS Value Type	BUKU_VALTYPE	CHAR	2	Assigned to domain		BUKU_VALTYPE
TECHORG_9	Original Application	BUKU_TECHORG	CHAR	10	Assigned to domain		BUKU_TECHORG
USNAM	User name	USNAM	CHAR	12	Assigned to domain		XUBNAME	USR
CPUDT	Day On Which Accounting Document Was Entered	CPUDT	DATS	8			DATUM
CPUTM	Time of Entry	CPUTM	TIMS	6			UZEIT
REFDOCNR	Reference document number of an accounting document	REFBELNR	CHAR	10		ALPHA	BELNR	BLN
REFDOCLN	Six-digit number of the reference posting line	REFBUZEI6	NUMC	6			BUZEI6	BUZ
REFRYEAR	Reference fiscal year	REFGJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUDAT	Posting Date in the Document	BUDAT	DATS	8			DATUM
RFUND	Fund	FM_FUND	CHAR	10	Assigned to domain		BP_GEBER	FIC
RFUNDSCTR	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS
RCMMTITEM	Commitment Item	FM_FIPEX	CHAR	24	Assigned to domain		FM_FIPEX	FPS
RFUNCAREA	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
R_GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
RMEASURE	Funded Program	FM_MEASURE	CHAR	24	Assigned to domain		FM_MEASURE	FM_MEASURE
BUDGET_PD_9	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
RUSERDIM	Customer Field for FM Actual and Commitment Data	FM_USERDIM	CHAR	10			CHAR10
CEFFYEAR_9	Year of Cash Effectivity	GNJHR	NUMC	4		GJAHR	GJAHR	GNJHR
WFSTATE_9	Workflow Status of a Record in the Budget Totals Table	BUKU_WFSTATE	CHAR	1			BUKU_WFSTATE
PROCESS_9	Internal Budgeting Process	BUKU_PROCESS	CHAR	4	Assigned to domain		BUKU_PROCESS
BUDTYPE_9	Budget Type	BUKU_BUDTYPE	CHAR	4			CHAR4	BUTY
LOGSYS	Logical system	LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
LCURR	Entry currency	LWAER	CUKY	5	Assigned to domain		WAERS
LVALUE	Total of transactions of the period in local currency	HSLXX9	CURR	17(2)			WERTV9
TVALUE	Total of transactions of the period in transaction currency	TSLXX9	CURR	17(2)			WERTV9
AWTYP	Reference Transaction	AWTYP	CHAR	5	Assigned to domain		AWTYP
AWORG	Reference Organizational Units	AWORG	CHAR	10			AWORG
CTEM_CATEGORY_9	Commitment Item Category	FM_POTYP	NUMC	1			FM_POTYP
BUDTYPE_TXT	Text (30 Characters)	TEXT30	CHAR	30			TEXT30
PROCESS_TXT	Text (15 characters)	TEXT15	CHAR	15			TEXT15

Key field

Non-key field

< FMLI_S_DOCID - Line items document identifier FMLI_S_HEADER - Line Items Header Structure >

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

As FMLI_S_DRILLDOWN 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 FMLI_S_DRILLDOWN as there is no data to select.

How to access SAP table FMLI_S_DRILLDOWN

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

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