1. SAP Tutorial
  2. FI Module

FAGLFLEXP SAP table for – General Ledger: Plan Line Items

Here we would like to draw your attention to FAGLFLEXP table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGLFLEXP is a SAP standard transp table used for storing General Ledger: Plan Line Items related data in SAP. It comes under the package FAGL_DB_PERSISTENCY.

SAP FAGLFLEXP table

Table FAGLFLEXP technical data

TableFAGLFLEXP
Data storingGeneral Ledger: Plan Line Items
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_DB_PERSISTENCY
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FAGLFLEXP 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 FAGLFLEXP 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
  • DOCCT : Document Type
    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 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
  • RCNTR : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • 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
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : General ledger: Sender SAP additional account assignment
  • SCNTR : Sender cost center
    Its data type is CHAR (Character String) with field length 10
  • PPRCTR : Partner Profit Center
    Its data type is CHAR (Character String) with field length 10
  • 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
  • PSEGMENT : Partner Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • .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 : Mandatory Fields of a GL Plan Line Item Table
  • DRCRK : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • DOCTY : Document Type for Plan Documents in General Ledger
    Its data type is CHAR (Character String) with field length 2
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Reference document number of an accounting document
    Its data type is CHAR (Character String) with field length 10
  • REFDOCLN : Six-digit number of the reference posting line
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFDOCCT : Reference document category
    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

    • FAGLFLEXP related tables

    • FAGLFLEX00 : General ledger: Transaction attributes
    • FAGLFLEXT : General Ledger: Totals
    • BKPF_ADD : Accounting Document Header
    • FAGLFLEXP : General Ledger: Plan Line Items
    • FAGLFLEXT_DIF : Delta Table: G/L Totals
    • FAGLFLEX04 : General ledger: Customer additional account assignment
    • FAGLFLEX06 : General ledger: Sender SAP additional account assignment
    • FAGLFLEX03 : General ledger: SAP additional account assignment
    • FAGLFLEXA : General Ledger: Actual Line Items
    • FAGL_MIG_BUKRS : Activation of New General Ledger Accounting for Company Code
    • FAGLFLEX01 : General ledger: Technical fields
    • FAGLFLEX05 : General Ledger: Additional Acct Assignment: Customer 2
    • FAGLFLEXT_BAK : General Ledger: Totals
    • FAGLFLEX07 : General Ledger: Reserve Table 1
    • FAGLFLEX02 : General ledger: Main account assignment
    • BSEG_ADD : Entry View of Accounting Document for Additional Ledgers
    • FAGLFLEX08 : General Ledger: Reserve Table 2

    Related References

    Related Tutorials

    /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...

    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...

    GLFLEXP SAP table for – Flexible G/L: Plan line items

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

    FAGLFLEXT SAP table for – General Ledger: Totals

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

    FAGLFLEXT_BAK SAP table for – General Ledger: Totals

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

    PCRRETAILP SAP table for – Plan line items table

    PCRRETAILP table in SAP FI (Retail Ledger in FI) module. This table is used for storing data of Plan line...

    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...

    «
    »