1. SAP Tutorial
  2. SAP PSM

FMGLFLEXA SAP table for – General Ledger: Actual Line Items

Here we would like to draw your attention to FMGLFLEXA 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). FMGLFLEXA is a SAP standard transp table used for storing General Ledger: Actual Line Items related data in SAP. It comes under the package FMGL.

SAP FMGLFLEXA table

Table FMGLFLEXA technical data

TableFMGLFLEXA
Data storingGeneral Ledger: Actual Line Items
ModulePSM
Sub ModulePSM-FA
SAP PackageFMGL
Delivery ClassA – Application table (master and transaction data)
ComponentEA-PS
Table CategoryTRANSP

SAP FMGLFLEXA 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 FMGLFLEXA 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
  • DOCNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : General Ledger: Technical Fields in Key of Line Items
    Its a key field.
  • RLDNR : Ledger in General Ledger Accounting
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : General Ledger: Additional Acct Assignmt (SAP) in Key of LIs
    Its a key field.
  • RBUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • DOCLN : Six-Character Posting Item for Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • .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 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: 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 : Value Fields of GL Line Items Table
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 23
  • HSL : Value in Local Currency
    Its data type is CURR (Currency Field) with field length 23
  • KSL : Value in Group Currency
    Its data type is CURR (Currency Field) with field length 23
  • OSL : Value in Another Currency
    Its data type is CURR (Currency Field) with field length 23
  • MSL : Quantity
    Its data type is QUAN (Quantity field) with field length 23
  • WSL : Value in Original Transaction Currency (Document Currency)
    Its data type is CURR (Currency Field) with field length 23
  • .INCLUDE : Mandatory Fields of a GL Actual Line Item Table
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • POPER : Posting period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RWCUR : Currency key of the original transaction currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • GJAHR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • LINETYPE : Item category
    Its data type is CHAR (Character String) with field length 5
  • XSPLITMOD : Item changed by document splitting
    Its data type is CHAR (Character String) with field length 1
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • 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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes

    • FMGLFLEXA related tables

    • FMGLFLEX00 : General ledger: Transaction attributes
    • FMGLFLEX08 : General Ledger: Reserve Table 2
    • FMGLFLEX05 : General Ledger: Additional Acct Assignment: Customer 2
    • FMGLFLEXA : General Ledger: Actual Line Items
    • FMGLFLEX04 : General ledger: Customer additional account assignment
    • FMGLFLEX02 : General ledger: Main account assignment
    • FMGLFLEX03 : General ledger: SAP additional account assignment
    • FMGLFLEX06 : General ledger: Sender SAP additional account assignment
    • FMGLFLEX01 : General ledger: Technical fields
    • FMGLFLEXT : General Ledger Public Sector: Total
    • FMGLFLEX07 : General Ledger: Reserve Table 1
    • FMGLFLEXP : General Ledger: Plan Line Items

    Related References

    Related Tutorials

    FMGLFLEXP SAP table for – General Ledger: Plan Line Items

    FMGLFLEXP table in SAP PSM (Fund Accounting in PSM) module. This table is used for storing data of General Ledger:...

    FAGLFLEXA SAP table for – General Ledger: Actual Line Items

    FAGLFLEXA table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of General...

    GLFLEXA SAP table for – Flexible general ledger: Actual line items

    GLFLEXA table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Flexible...

    /CCIS/PROFTAXA SAP table for – Actual Line Items Table for General Ledger

    /CCIS/PROFTAXA table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Actual...

    FAGLFLEXP SAP table for – General Ledger: Plan Line Items

    FAGLFLEXP table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of General...

    /CCIS/PROFTAXP SAP table for – Plan Line Items Table for General Ledger

    /CCIS/PROFTAXP table in SAP FI (Special Purpose Ledger in FI) module. This table is used for storing data of Plan...

    FMGLFLEX00 SAP table for – General ledger: Transaction attributes

    FMGLFLEX00 table in SAP PSM (Fund Accounting in PSM) module. This table is used for storing data of General ledger:...

    «
    »