SAP FMLA Layout Variant Table data and field list

FMLA is a standard SAP Table which is used to store Layout Variant data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMLA table consists of various fields, each holding specific information or linking keys about Layout Variant data available in SAP. These include LAYOUTVAR (Layout variant - Layout management in budgeting), FUNDPOS (Position of Fund), FUNDSCTRPOS (Position of Funds Center), CMMTITEMPOS (Position of Commitment Item)... 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. .

FMLA table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = FMLAT


SAP FMLA 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 FMLA 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
LAYOUTVARLayout variant - Layout management in budgeting FMLA_LAYOUTVARCHAR6FMLA_LAYOUTVARLAY
FUNDPOSPosition of Fund FMLA_FUNDPOSCHAR1FMLA_LAYPOS
FUNDSCTRPOSPosition of Funds Center FMLA_FUNDSCTRPOSCHAR1FMLA_LAYPOS
CMMTITEMPOSPosition of Commitment Item FMLA_CMMTITEMPOSCHAR1FMLA_LAYPOS
FUNCAREAPOSPosition of Functional Area FMLA_FUNCAREAPOSCHAR1FMLA_LAYPOS
CEFFYEARPOSPosition of Year of Cash Effectivity FMLA_CEFFYEARPOSCHAR1FMLA_LAYPOS
BUDTYPEPOSPosition for Budget Type FMLA_BUDTYPEPOSCHAR1FMLA_LAYPOS
MEASUREPOSPosition or Funded Program FMLA_MEASUREPOSCHAR1FMLA_LAYPOS
GRANT_NBRPOSPosition for Grant FMLA_GRANT_NBRPOSCHAR1FMLA_LAYPOS
USERDIMPOSCustomer Field Position FMLA_USERDIMPOSCHAR1FMLA_LAYPOS
FLG_CTEM_CATDisplay Commitment Item Category FMBW_CTEM_CATEGORYCHAR1XFELD
DISTKEYDistribution Key SPREDCHAR4T821SSPREDGSP
FUNDCOLColumn position in entry document line FMLA_COLPOSINT13
FUNDSCTRCOLColumn position in entry document line FMLA_COLPOSINT13
CMMTITEMCOLColumn position in entry document line FMLA_COLPOSINT13
FUNCAREACOLColumn position in entry document line FMLA_COLPOSINT13
CEFFYEARCOLColumn position in entry document line FMLA_COLPOSINT13
BUDTYPECOLColumn position in entry document line FMLA_COLPOSINT13
MEASURECOLColumn position in entry document line FMLA_COLPOSINT13
GRANT_NBRCOLColumn position in entry document line FMLA_COLPOSINT13
USERDIMCOLColumn position in entry document line FMLA_COLPOSINT13
FUNDCOLABSColumn position in entry document line FMLA_COLPOSINT13
FUNDSCTRCOLABSColumn position in entry document line FMLA_COLPOSINT13
CMMTITEMCOLABSColumn position in entry document line FMLA_COLPOSINT13
FUNCAREACOLABSColumn position in entry document line FMLA_COLPOSINT13
CEFFYEARCOLABSColumn position in entry document line FMLA_COLPOSINT13
BUDTYPECOLABSColumn position in entry document line FMLA_COLPOSINT13
MEASURECOLABSColumn position in entry document line FMLA_COLPOSINT13
GRANT_NBRCOLABSColumn position in entry document line FMLA_COLPOSINT13
USERDIMCOLABSColumn position in entry document line FMLA_COLPOSINT13
PERIODPOSPosition of Period FMLA_PERIODPOSCHAR1FMLA_LAYPOS
FLG_AUTO_LINESAutomatic Line Generation in BWB FLBW_AUTO_LINESCHAR1XFELD
BUDCATPOSCombination Payment and commmitment FMLA_BUDCATPOSCHAR2FMLA_BUDCATPOS
BUDGET_PDPOSPosition for Budget Period FMLA_BUDGET_PDPOSCHAR1FMLA_LAYPOS
BUDGET_PDCOLColumn position in entry document line FMLA_COLPOSINT13
BUDGET_PDCOLABSColumn position in entry document line FMLA_COLPOSINT13

Key field Non-key field



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

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

SELECT SINGLE *
FROM FMLA
INTO CORRESPONDING FIELDS OF WA_FMLA
WHERE...

How to access SAP table FMLA

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

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