1. Home
  2. Resources
  3. SAP Tables
  4. FMGLFLEXA - General Ledger: Actual Line Items

SAP Table FMGLFLEXA

General Ledger: Actual Line Items

FMGLFLEXA (General Ledger: Actual Line Items) 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 FMGLFLEXA to other SAP tables.

FMGLFLEXA table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
DOCNR Accounting Document Number BELNR_D CHAR 10 0
RLDNR Ledger in General Ledger Accounting FAGL_RLDNR V_FAGL_T881_DBAL CHAR 2 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
DOCLN Six-Character Posting Item for Ledger DOCLN6 CHAR 6 0
ACTIV FI-SL Business Transaction ACTI1 T022 CHAR 4 0
RMVCT Transaction Type RMVCT T856 CHAR 3 0
RTCUR Currency Key RTCUR CUKY 5 0
RUNIT Base Unit of Measure MEINS UNIT 3 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS CHAR 3 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
RACCT Account Number RACCT SKB1 CHAR 10 0
COST_ELEM Cost Element KSTAR CSKB CHAR 10 0
RBUSA Business Area GSBER TGSB CHAR 4 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
FIKRS Financial Management Area FIKRS CHAR 4 0
SFAREA Partner Functional Area SFKBER TFKB CHAR 16 0
SBUSA Trading partner's business area PARGB TGSB CHAR 4 0
RASSC Company ID of trading partner RASSC T880 CHAR 6 0
SFUND Partner Fund BP_P_GEBER CHAR 10 0
SGRANT_NBR Partner Grant GM_GRANT_PARTNER GMGR CHAR 20 0
RFUND Fund BP_GEBER CHAR 10 0
RGRANT_NBR Grant GM_GRANT_NBR GMGR CHAR 20 0
RFAREA Functional Area FKBER TFKB CHAR 16 0
TSL Value in Transaction Currency VTCUR12 CURR 23 2
HSL Value in Local Currency VLCUR12 CURR 23 2
KSL Value in Group Currency VGCUR12 CURR 23 2
OSL Value in Another Currency VOCUR12 CURR 23 2
MSL Quantity QUAN1_12 QUAN 23 3
WSL Value in Original Transaction Currency (Document Currency) VWCUR12 CURR 23 2
DRCRK Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
POPER Posting period POPER NUMC 3 0
RWCUR Currency key of the original transaction currency RWCUR TCURC CUKY 5 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
BSCHL Posting Key BSCHL TBSL CHAR 2 0
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
LINETYPE Item category LINETYPE T8G02 CHAR 5 0
XSPLITMOD Item changed by document splitting XSPLITMOD CHAR 1 0
X Yes
NULL No
USNAM User name USNAM USR02 CHAR 12 0
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0

FMGLFLEXA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMGLFLEXA ACTIV FMGLFLEXA ACTIV T022 FI-SL Activity: Fixed Data ACTIVITY
FMGLFLEXA AWTYP FMGLFLEXA AWTYP TTYP Object Types for Accounting AWTYP
FMGLFLEXA BSCHL SYST MANDT TBSL Posting Key MANDT
FMGLFLEXA BSCHL FMGLFLEXA BSCHL TBSL Posting Key BSCHL
FMGLFLEXA COST_ELEM SYST MANDT CSKB Cost Elements (Data Dependent on Controlling Area) MANDT
FMGLFLEXA COST_ELEM FAGLFLEX03_DATA KOKRS CSKB Cost Elements (Data Dependent on Controlling Area) KOKRS
FMGLFLEXA COST_ELEM FMGLFLEXA COST_ELEM CSKB Cost Elements (Data Dependent on Controlling Area) KSTAR
FMGLFLEXA COST_ELEM * CSKB Cost Elements (Data Dependent on Controlling Area) DATBI
FMGLFLEXA KOKRS SYST MANDT TKA01 Controlling Areas MANDT
FMGLFLEXA KOKRS FMGLFLEXA KOKRS TKA01 Controlling Areas KOKRS
FMGLFLEXA LINETYPE FMGLFLEXA LINETYPE T8G02 Item categories LINETYPE
FMGLFLEXA LOGSYS FMGLFLEXA LOGSYS TBDLS Logical system LOGSYS
FMGLFLEXA RACCT FMGLFLEXA RACCT SKB1 G/L account master (company code) SAKNR
FMGLFLEXA RACCT SYST MANDT SKB1 G/L account master (company code) MANDT
FMGLFLEXA RACCT FAGLFLEX03_KEY RBUKRS SKB1 G/L account master (company code) BUKRS
FMGLFLEXA RASSC SYST MANDT T880 Global Company Data (for KONS Ledger) MANDT
FMGLFLEXA RASSC FMGLFLEXA RASSC T880 Global Company Data (for KONS Ledger) RCOMP
FMGLFLEXA RBUKRS SYST MANDT T001 Company Codes MANDT
FMGLFLEXA RBUKRS FMGLFLEXA RBUKRS T001 Company Codes BUKRS
FMGLFLEXA RBUSA SYST MANDT TGSB Business Areas MANDT
FMGLFLEXA RBUSA FMGLFLEXA RBUSA TGSB Business Areas GSBER
FMGLFLEXA RCLNT FMGLFLEXA RCLNT T000 Clients MANDT
FMGLFLEXA RFAREA FMGLFLEXA RFAREA TFKB Functional areas FKBER
FMGLFLEXA RFAREA SYST MANDT TFKB Functional areas MANDT
FMGLFLEXA RGRANT_NBR SYST MANDT GMGR Grant Master CLIENT
FMGLFLEXA RGRANT_NBR FMGLFLEXA RGRANT_NBR GMGR Grant Master GRANT_NBR
FMGLFLEXA RLDNR SYST MANDT V_FAGL_T881_DBAL Generated Table for View MANDT
FMGLFLEXA RLDNR FMGLFLEXA RLDNR V_FAGL_T881_DBAL Generated Table for View RLDNR
FMGLFLEXA RMVCT SYST MANDT T856 Transaction Types MANDT
FMGLFLEXA RMVCT FMGLFLEXA RMVCT T856 Transaction Types TRTYP
FMGLFLEXA RWCUR SYST MANDT TCURC Currency Codes MANDT
FMGLFLEXA RWCUR FMGLFLEXA RWCUR TCURC Currency Codes WAERS
FMGLFLEXA SBUSA SYST MANDT TGSB Business Areas MANDT
FMGLFLEXA SBUSA FMGLFLEXA SBUSA TGSB Business Areas GSBER
FMGLFLEXA SFAREA SYST MANDT TFKB Functional areas MANDT
FMGLFLEXA SFAREA FMGLFLEXA SFAREA TFKB Functional areas FKBER
FMGLFLEXA SGRANT_NBR SYST MANDT GMGR Grant Master CLIENT
FMGLFLEXA SGRANT_NBR FMGLFLEXA SGRANT_NBR GMGR Grant Master GRANT_NBR
FMGLFLEXA USNAM SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
FMGLFLEXA USNAM FMGLFLEXA USNAM USR02 Logon Data (Kernel-Side Use) BNAME