1. Home
  2. Resources
  3. SAP Tables
  4. FMLA - Layout Variant

SAP Table FMLA

Layout Variant

FMLA (Layout Variant) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FMLA to other SAP tables.

FMLA table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
LAYOUTVAR Layout variant - Layout management in budgeting FMLA_LAYOUTVAR CHAR 6 0
FUNDPOS Position of Fund FMLA_FUNDPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
FUNDSCTRPOS Position of Funds Center FMLA_FUNDSCTRPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
CMMTITEMPOS Position of Commitment Item FMLA_CMMTITEMPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
FUNCAREAPOS Position of Functional Area FMLA_FUNCAREAPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
CEFFYEARPOS Position of Year of Cash Effectivity FMLA_CEFFYEARPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
BUDTYPEPOS Position for Budget Type FMLA_BUDTYPEPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
MEASUREPOS Position or Funded Program FMLA_MEASUREPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
GRANT_NBRPOS Position for Grant FMLA_GRANT_NBRPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
USERDIMPOS Customer Field Position FMLA_USERDIMPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
FLG_CTEM_CAT Display Commitment Item Category FMBW_CTEM_CATEGORY CHAR 1 0
X Yes
NULL No
DISTKEY Distribution Key SPRED T821S CHAR 4 0
FUNDCOL Column position in entry document line FMLA_COLPOS INT1 3 0
FUNDSCTRCOL Column position in entry document line FMLA_COLPOS INT1 3 0
CMMTITEMCOL Column position in entry document line FMLA_COLPOS INT1 3 0
FUNCAREACOL Column position in entry document line FMLA_COLPOS INT1 3 0
CEFFYEARCOL Column position in entry document line FMLA_COLPOS INT1 3 0
BUDTYPECOL Column position in entry document line FMLA_COLPOS INT1 3 0
MEASURECOL Column position in entry document line FMLA_COLPOS INT1 3 0
GRANT_NBRCOL Column position in entry document line FMLA_COLPOS INT1 3 0
USERDIMCOL Column position in entry document line FMLA_COLPOS INT1 3 0
FUNDCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
FUNDSCTRCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
CMMTITEMCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
FUNCAREACOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
CEFFYEARCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
BUDTYPECOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
MEASURECOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
GRANT_NBRCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
USERDIMCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0
PERIODPOS Position of Period FMLA_PERIODPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
FLG_AUTO_LINES Automatic Line Generation in BWB FLBW_AUTO_LINES CHAR 1 0
X Yes
NULL No
BUDCATPOS Combination Payment and commmitment FMLA_BUDCATPOS CHAR 2 0
NULL Default
1 Payment Budget
2 Commitment Budget
3 Financial Budget
4 Payment Budget and Commitment Budget
5 Commitment Budget and Payment Budget
6 Financial Budget and Payment Budget
7 Payment Budget and Financial Budget
8 Financial Budget and Commitment Budget
9 Commitment Budget and Financial Budget
10 Payment Budget / Commitment Budget and Financial Budget
11 Payment Budget / Financial Budget and Commitment Budget
12 Financial Budget / Payment Budget and Commitment Budget
13 Financial Budget / Commitment Budget and Payment Budget
14 Commitment Budget / Payment Budget and Financial Budget
15 Commitment Budget / Financial Budget and Payment Budget
BUDGET_PDPOS Position for Budget Period FMLA_BUDGET_PDPOS CHAR 1 0
0 Not displayed
1 Header
2 Column
BUDGET_PDCOL Column position in entry document line FMLA_COLPOS INT1 3 0
BUDGET_PDCOLABS Column position in entry document line FMLA_COLPOS INT1 3 0

FMLA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMLA DISTKEY FMLA CLIENT T821S Distribution keys MANDT
FMLA DISTKEY FMLA DISTKEY T821S Distribution keys SPRED