FMGLFLEXT SAP table for – General Ledger Public Sector: Total

Here we would like to draw your attention to FMGLFLEXT table in SAP. As we know it is being mainly used with the SAP PSM-FA (Fund Accounting in PSM) component which is coming under PSM module (Public Sector Management). FMGLFLEXT is a SAP standard transp table used for storing General Ledger Public Sector: Total related data in SAP. It comes under the package FMGL.

SAP FMGLFLEXT table

Table FMGLFLEXT technical data

TableFMGLFLEXT
Data storingGeneral Ledger Public Sector: Total
ModulePSM
Sub ModulePSM-FA
SAP PackageFMGL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMGLFLEXT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMGLFLEXT table.

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RYEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OBJNR00 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR01 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR02 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR03 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR04 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR05 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR06 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR07 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • OBJNR08 : Object number for table group
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • DRCRK : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • RPMAX : Period
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : General ledger: Transaction attributes
  • ACTIV : FI-SL Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • RMVCT : Transaction type
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : RTCUR + RUNIT
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • RUNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • .INCLUDE : General ledger: Technical fields
  • .INCLUDE : General Ledger: Technical Fields in Key of Line Items
  • RLDNR : Ledger in General Ledger Accounting
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : General Ledger: Technical Fields in Data Part of Line Items
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General ledger: Main account assignment
  • RACCT : Account Number
    Its data type is CHAR (Character String) with field length 10
  • COST_ELEM : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General ledger: SAP additional account assignment
  • .INCLUDE : General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : General Ledger: Additional Acct Assignmt in Data Part of LIs
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : General Ledger: Sender Additional Acct Assgmt Public Sector
  • SFAREA : Partner Functional Area
    Its data type is CHAR (Character String) with field length 16
  • SBUSA : Trading partner’s business area
    Its data type is CHAR (Character String) with field length 4
  • RASSC : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • SFUND : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • SGRANT_NBR : Partner Grant
    Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : General Ledger PS: Fund, Grant and Functional Area
  • RFUND : Fund
    Its data type is CHAR (Character String) with field length 10
  • RGRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • .INCLUDE : Data Fields of a GL Totals Table
  • .INCLUDE : Field Group TSL
  • TSLVT : Balance carried forward in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL01 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL02 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL03 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL04 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL05 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL06 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL07 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL08 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL09 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL10 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL11 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL12 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL13 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL14 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL15 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • TSL16 : Total of transactions of the period in transaction currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group HSL
  • HSLVT : Balance carried forward in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL01 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL02 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL03 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL04 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL05 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL06 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL07 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL08 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL09 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL10 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL11 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL12 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL13 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL14 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL15 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL16 : Total of transactions of the period in local currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group KSL
  • KSLVT : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL01 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL02 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL03 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL04 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL05 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL06 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL07 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL08 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL09 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL10 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL11 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL12 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL13 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL14 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL15 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL16 : Total of transactions of the period in group currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group OSL
  • OSLVT : Balance carried forward in fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL01 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL02 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL03 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL04 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL05 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL06 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL07 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL08 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL09 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL10 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL11 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL12 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL13 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL14 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL15 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL16 : Total transactions for the period in the fourth currency
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Field Group MSL
  • MSLVT : Balance carried forward of quantity
    Its data type is QUAN (Quantity field) with field length 23
  • MSL01 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL02 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL03 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL04 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL05 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL06 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL07 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL08 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL09 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL10 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL11 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL12 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL13 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL14 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL15 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • MSL16 : Total of the transactions of period in units of measure
    Its data type is QUAN (Quantity field) with field length 23
  • .INCLUDE : Additional Data Fields of a G/L Totals Table
  • TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15