SAP General Ledger Migration: From FI to New GL Tables
Jan 18, 2025

SAP General Ledger Migration: From FI to New GL Tables

SAP General Ledger Migration: From FI to New GL Tables

Understanding the evolution, architecture, and migration path from Classic GL to New GL in SAP Finance

If you've been working with SAP Finance for more than a decade, you've likely witnessed one of the most significant transformations in enterprise accounting systems: the migration from Classic General Ledger to New GL. This isn't just a table swap or a cosmetic upgrade—it's a fundamental reimagining of how financial data flows through SAP systems.

I remember the first time I opened up transaction code SE16 and looked at the GLT0 table in a classic SAP R/3 system. Simple, straightforward, but ultimately limited. Fast forward to today's S/4HANA landscape, and we're working with FAGLFLEXT, FAGLFLEXA, and an entirely new paradigm of real-time financial integration. The journey between these two worlds is what we'll explore in depth today.

The Foundation: Understanding Classic General Ledger

Before we dive into the new world, let's establish where we came from. The Classic General Ledger in SAP was built around a relatively simple concept: aggregate financial data at the G/L account level with basic dimensions like cost center, profit center, and business area.

Classic GL Core Tables:

  • GLT0 - G/L Account Master Data (for all company codes)
  • SKA1 - G/L Account Master (Chart of Accounts)
  • SKB1 - G/L Account Master (Company Code)
  • FAGLFLEXT - General Ledger: Actual Line Items (already present as compatibility view)

The Classic GL operated on a period-based totals table concept. When you posted a transaction, the system updated summary records in GLT0 for the respective posting period. If you needed to see actual line items, you'd reference accounting documents in BKPF (document header) and BSEG (document segment).

This architecture was efficient for its time—aggregated data meant faster reporting for balance sheets and P&L statements. But it had significant limitations:

  • Limited dimensionality: You couldn't easily analyze data beyond the standard account assignments without custom development
  • Reconciliation challenges: CO (Controlling) and FI (Financial Accounting) lived in separate worlds, leading to reconciliation nightmares
  • Inflexibility: Adding new characteristics required significant configuration and potentially custom tables
  • Performance issues: Line item reporting meant querying massive BSEG tables with millions of records

Enter New GL: A Paradigm Shift

The New General Ledger (available since ERP 6.0 and mandatory in S/4HANA) represents a fundamental architectural change. Instead of just modernizing the old tables, SAP reimagined the entire data model around a concept called the "Universal Journal."

Core New GL Tables:

Primary Tables:

  • FAGLFLEXT - Totals Table
  • FAGLFLEXA - Actual Line Items
  • FAGLFLEXD - Planning Data
  • FAGLBSIS - Index Table for Entry Views

Supporting Tables:

  • FAGL_SPLINFO - Document Splitting Info
  • FAGL_SPLINFO_VAL - Split Char Values
  • FINS_ACDOC_EXTRACT - ACDOCA Extraction (S/4)

FAGLFLEXT: The Totals Powerhouse

FAGLFLEXT is your totals table in New GL, but don't let the familiar name fool you—it's far more sophisticated than GLT0 ever was. This table stores summarized financial data with significantly enhanced dimensionality.

Key Fields in FAGLFLEXT:
├── RYEAR          (Fiscal Year)
├── DOCNR          (Document Number)
├── RLDNR          (Ledger)
├── RBUKRS         (Company Code)
├── RACCT          (G/L Account)
├── RCNTR          (Cost Center)
├── PRCTR          (Profit Center)
├── SEGMENT        (Segment for Segmental Reporting)
├── SCNTR          (Sender Cost Center)
├── PPRCTR         (Partner Profit Center)
├── RFAREA         (Financial Management Area)
├── RBUSA          (Business Area)
├── RZZSPREG       (EPA Region)
├── RZZLSTAR       (EPA Subregion)
├── HSL01-HSL16    (Local Currency Amounts per Period)
├── KSL01-KSL16    (Transaction Currency Amounts)
├── TSL01-TSL16    (Company Code Currency Amounts)
└── [Custom Fields] (Up to 10 customer-defined characteristics)

Notice the difference? You've got profit center, segment, functional area, partner objects—all in one table. This is what we call "real-time integration" with Controlling. When you post in FI, the CO assignments happen simultaneously, and everything lands in FAGLFLEXT with full dimensionality.

FAGLFLEXA: Line Items with Intelligence

While FAGLFLEXT gives you period totals, FAGLFLEXA stores actual line items with the same rich dimensional structure. Think of it as BSEG's sophisticated cousin—every line item carries the full context of account assignments, document splitting information, and custom characteristics.

In S/4HANA, FAGLFLEXA gets replaced by the Universal Journal table ACDOCA, but the concept remains the same: comprehensive line-item storage with all the dimensional attributes you need for modern financial analytics.

FAGLFLEXA Structure Highlights:
├── Document Identifiers (RLDNR, RBUKRS, GJAHR, BELNR, BUZEI)
├── Account Assignments (RACCT, RCNTR, PRCTR, SEGMENT, etc.)
├── Amount Fields (HSL, KSL, TSL, DMBE)
├── Document Splitting Info (Split characteristics and rules)
├── Posting Keys and Transaction Types
├── Partner Information (Partner objects for transfer pricing)
└── Custom Dimensions (User-defined characteristics)

Document Splitting: The Game Changer

One of the most powerful features that came with New GL is document splitting. If you've ever tried to create a balance sheet by segment or profit center in Classic GL, you know the pain—unassigned line items, clearing accounts that don't balance, manual adjustments galore.

Document splitting solves this by automatically distributing characteristics across all line items in a document, ensuring that your balance sheet balances at any dimensional level you choose.

How Document Splitting Works:

Consider a vendor invoice posting:

Original Posting (without splitting):
DR Expense Account    1000 USD   [Profit Center A]
DR Expense Account    500 USD    [Profit Center B]
CR Vendor Account     1500 USD   [No profit center]

After Document Splitting:
DR Expense Account    1000 USD   [Profit Center A]
DR Expense Account    500 USD    [Profit Center B]
CR Vendor Account     1000 USD   [Profit Center A] (auto-split)
CR Vendor Account     500 USD    [Profit Center B] (auto-split)

The system automatically splits the vendor line item based on the proportional distribution of the expense accounts, ensuring your balance sheet by profit center always balances.

Document splitting rules are stored in FAGL_SPLINFO and FAGL_SPLINFO_VAL. You can configure:

  • Zero balance characteristics: Which dimensions must balance (segment, profit center, etc.)
  • Splitting methods: Proportional, item category-based, or custom rules
  • Document types: Which document types require splitting
  • Inheritance rules: How characteristics flow from document headers to line items

Real-Time Integration: FI-CO Convergence

Perhaps the most significant benefit of New GL is the dissolution of the FI-CO divide. In Classic GL, Financial Accounting and Controlling were separate universes that needed periodic reconciliation. Cost center postings went to CO tables (COEP, COSS), while FI postings went to BSEG and GLT0.

With New GL, we achieve real-time integration:

Integration Architecture:

Classic GL Flow:
FI Posting → BSEG/BKPF → GLT0 (aggregated)
           ↓
      CO Posting → COEP (line items) → COSS/COSP (totals)
           ↓
    Reconciliation Ledger (periodic)

New GL Flow:
Single Posting → FAGLFLEXA (line items)
              → FAGLFLEXT (totals with CO attributes)
              → CO tables updated simultaneously
              → Real-time reconciliation

The ledger concept in New GL enables parallel accounting. You can maintain multiple ledgers (RLDNR field):

  • 0L (Leading Ledger): Your primary GAAP ledger
  • Additional Ledgers: IFRS, tax ledgers, management reporting ledgers
  • Ledger Groups: Combinations of ledgers for consolidated reporting

Each posting can simultaneously update multiple ledgers with different valuation approaches, eliminating the need for separate adjustment postings.

Migration Considerations: The Journey from Classic to New

Migrating from Classic GL to New GL isn't a simple switch—it's a transformation that requires careful planning and execution. I've led several of these migrations, and here's what you need to consider:

1. Data Migration Strategy

You have two primary approaches for historical data:

Full Historical Migration

  • ✓ Complete data continuity
  • ✓ Reporting consistency across years
  • ✗ Time-intensive process
  • ✗ Potential data quality issues

Use SAP's migration tools (FAGL_ACTIVATE_OP, FAGL_MIG_OPITEMS) to transfer opening balances and line items.

Opening Balance Migration

  • ✓ Faster implementation
  • ✓ Clean start for new fiscal year
  • ✗ Historical reporting limitations
  • ✗ Archive access needed for old data

Migrate only opening balances; keep Classic GL for historical reporting via compatibility views.

2. Configuration Workstream

New GL activation requires comprehensive configuration:

Configuration Checklist:
│
├── Ledger Definition
│   ├── Define leading ledger and currency type
│   ├── Configure additional ledgers (IFRS, tax, etc.)
│   └── Set up ledger groups
│
├── Document Splitting
│   ├── Activate document splitting
│   ├── Define zero-balance characteristics
│   ├── Configure splitting rules per document type
│   └── Set up inheritance and derivation rules
│
├── Scenarios and Fields
│   ├── Activate New GL scenarios (segmental reporting, etc.)
│   ├── Define custom fields and characteristics
│   └── Configure field movements and derivations
│
└── Integration Setup
    ├── Activate real-time CO integration
    ├── Configure CO-FI reconciliation
    └── Set up parallel currencies if needed

3. Testing and Validation

Your testing strategy must be exhaustive. I recommend this phased approach:

Testing Phases:

  1. Phase 1: Configuration Validation
    • Verify ledger setup and currency configuration
    • Test document splitting rules with sample postings
    • Validate derivation and substitution logic
  2. Phase 2: Migration Testing
    • Execute migration in sandbox with production data subset
    • Reconcile migrated balances against Classic GL
    • Verify line item completeness and accuracy
  3. Phase 3: Integration Testing
    • Test end-to-end business processes (P2P, O2C, R2R)
    • Validate FI-CO real-time integration
    • Verify period-end closing procedures
  4. Phase 4: Reporting Validation
    • Recreate key financial reports from New GL
    • Compare with Classic GL outputs
    • Test segment/profit center balance sheets

Compatibility Views: Bridging Old and New

SAP understood that the transition wouldn't happen overnight. Custom code, reports, and interfaces built on Classic GL tables needed to continue functioning. Enter compatibility views.

Compatibility views are database views that make New GL tables look like Classic GL tables to existing programs:

Key Compatibility Views:

Classic TableCompatibility ViewMaps To
GLT0GLT0 (view)FAGLFLEXT
GLFUNCTGLFUNCT (view)FAGLFLEXT
GLPCTGLPCT (view)FAGLFLEXT
GLPCAGLPCA (view)FAGLFLEXT

However, compatibility views have limitations:

  • Performance: Views can be slower than direct table access, especially with complex selections
  • Functionality gaps: Not all Classic GL fields map cleanly to New GL structures
  • Future-proofing: SAP doesn't guarantee long-term support for compatibility views, especially in S/4HANA

Best practice: Use compatibility views as a temporary bridge, but plan to refactor custom code to use New GL tables directly. Your future self (and performance metrics) will thank you.

The S/4HANA Evolution: Universal Journal (ACDOCA)

New GL was revolutionary in ECC, but S/4HANA takes it to the next level with the Universal Journal concept, centered around the ACDOCA table.

ACDOCA combines what used to be separate tables into a single, massive structure:

Universal Journal Consolidation:
ACDOCA replaces:
├── FAGLFLEXA   (General Ledger Line Items)
├── BSEG        (Accounting Document Segment)
├── BSIS/BSAS   (GL Line Items - Open/Cleared)
├── BSIK/BSAK   (Vendor Line Items)
├── BSID/BSAD   (Customer Line Items)
├── BSIM/BSAM   (Material Line Items)
├── COEP        (CO Line Items)
└── Various other subledger tables

Result: One line item table to rule them all

The brilliance of ACDOCA lies in its hybrid design: it's optimized for HANA's columnar database architecture, meaning you can query billions of line items with sub-second response times—something that would have brought Classic GL to its knees.

ACDOCA Key Features:

  • Single source of truth: All financial postings in one table
  • Real-time analytics: No aggregation needed for reporting
  • Column-store optimization: HANA's compression reduces storage by 80-90%
  • Simplified architecture: Fewer tables, less complexity
  • Enhanced dimensions: Additional custom fields and characteristics

If you're migrating from New GL to S/4HANA, the good news is that the conceptual model remains similar. FAGLFLEXT and FAGLFLEXA map relatively cleanly to ACDOCA, but you'll need to adjust your queries and reports to use the new structure.

Practical Migration Roadmap

Based on multiple successful migrations, here's a battle-tested roadmap:

12-Week Migration Timeline:

Weeks 1-2: Assessment & Design

  • • Current state analysis (custom code, reports, interfaces)
  • • Define target architecture (ledgers, splitting rules, scenarios)
  • • Data migration strategy decision
  • • Create detailed design document

Weeks 3-4: Configuration

  • • Set up development system
  • • Configure ledgers and scenarios
  • • Implement document splitting rules
  • • Define custom characteristics and derivations

Weeks 5-6: Data Migration & Unit Testing

  • • Execute migration programs
  • • Reconcile balances
  • • Test posting scenarios
  • • Validate document splitting

Weeks 7-8: Custom Code Adaptation

  • • Identify programs accessing Classic GL tables
  • • Refactor to use New GL tables
  • • Update reports and queries
  • • Modify interfaces as needed

Weeks 9-10: Integration & User Acceptance Testing

  • • End-to-end process testing
  • • Month-end close simulation
  • • User training and validation
  • • Performance testing

Week 11: Cutover Preparation

  • • Final production migration rehearsal
  • • Cutover runbook finalization
  • • Contingency planning
  • • Go-live readiness check

Week 12: Go-Live & Hypercare

  • • Production migration execution
  • • Post go-live validation
  • • Issue resolution
  • • Performance monitoring

Pro tip: Always perform your production cutover at the start of a fiscal year. Trying to migrate mid-year with open periods is asking for trouble—balance transfers become complex, and reconciliation becomes a nightmare.

Common Pitfalls and How to Avoid Them

Every migration has its challenges. Here are the most common issues I've encountered and their solutions:

Pitfall #1: Incomplete Document Splitting Configuration

Problem: Segment or profit center balance sheets don't balance post go-live.

Solution: Define all zero-balance characteristics upfront. Test extensively with various document types (invoices, payments, journal entries, accruals). Use transaction FAGL_CHECK_SPLIT to validate splitting logic.

Pitfall #2: Custom Code Dependencies

Problem: Reports and interfaces break because they're hardcoded to Classic GL tables.

Solution: Conduct thorough code scanning (use tools like ABAP Test Cockpit). Create a remediation backlog early. Don't rely solely on compatibility views—refactor critical programs.

Pitfall #3: Performance Degradation

Problem: Reports that were fast in Classic GL become slow with New GL.

Solution: Leverage FAGLFLEXT totals table instead of always querying line items. Create appropriate indexes. In S/4HANA, use CDS views optimized for ACDOCA. Consider SAP's Embedded Analytics framework.

Pitfall #4: Insufficient Testing of Parallel Ledgers

Problem: IFRS or tax ledgers have incorrect values due to valuation errors.

Solution: Test all ledger combinations, not just the leading ledger. Validate currency translations, different fiscal year variants, and ledger-specific posting rules.

Pitfall #5: Data Quality Issues in Migration

Problem: Historical data has missing characteristics (cost centers, profit centers) that New GL requires.

Solution: Run data quality checks before migration. Use derivation rules to populate missing values. Consider whether opening balance migration is sufficient vs. full history.

Beyond Migration: Leveraging New GL Capabilities

Migration is just the beginning. Once you're on New GL, you unlock capabilities that simply weren't possible before:

1. True Segmental Reporting

With proper segment assignment and document splitting, you can produce legally-compliant segment balance sheets and P&L statements without manual allocations. This is a game-changer for companies with diverse business units.

2. Real-Time Management Reporting

The FI-CO integration means management reports are always current. No more waiting for reconciliation processes or period-end allocations. Query FAGLFLEXT with cost center or profit center dimensions and get instant results.

3. Multi-GAAP Accounting Made Simple

Parallel ledgers enable simultaneous posting to different accounting principles. One posting can update local GAAP, IFRS, and tax ledgers with appropriate valuations—no manual adjustments needed.

4. Enhanced Analytics and Predictive Accounting

The rich dimensional structure of New GL data makes it ideal for analytics. Combine with SAP Analytics Cloud or BW/4HANA for predictive insights, variance analysis, and trend forecasting.

Key Transactions for New GL

Here are the essential transaction codes you'll use throughout configuration and operations:

Configuration Transactions:

  • FINSC_LEDGER - Define Ledgers
  • FAGL_ACTIVATE - Activate New GL
  • FAGLGVTR - Maintain Document Splitting
  • FAGL_FC_VAL - Field Movement Configuration

Migration Transactions:

  • FAGL_ACTIVATE_OP - Migrate Balances
  • FAGL_MIG_OPITEMS - Migrate Line Items
  • FAGL_MIG_FICHAN - Migrate FI Customizing
  • FAGLGVTR_TRANSFER - Transfer Splitting Rules

Monitoring & Validation:

  • FAGL_CHECK_SPLIT - Check Document Splitting
  • FAGLB03 - Display GL Balances
  • FAGLL03 - Display GL Line Items
  • FAGL_CONSISTENCY - Consistency Check

Reporting Transactions:

  • FAGLFLEXT_CONSO - Display Totals Table
  • S_ALR_87012357 - Financial Statement
  • S_PL0_86000028 - Segment Reporting
  • FAGL_ACCOUNT_BALANCES - Account Balances

Final Thoughts: The Future is Universal

The journey from Classic GL to New GL to S/4HANA's Universal Journal represents more than just technical evolution—it's a fundamental shift in how we think about financial data. We've moved from isolated, aggregated silos to a unified, real-time, dimensional model that serves both regulatory compliance and strategic decision-making.

If you're still on Classic GL, the migration to New GL isn't optional—it's inevitable. S/4HANA requires it, and even if you're staying on ECC for now, the business value of real-time integration and dimensional reporting makes the investment worthwhile.

The key to success lies in treating this as a business transformation, not just a technical upgrade. Involve your finance teams early, understand their reporting needs, design your document splitting and ledger strategy around business requirements, and test exhaustively.

Key Takeaways:

  • ✓ New GL provides dimensional flexibility that Classic GL could never achieve
  • ✓ FAGLFLEXT and FAGLFLEXA are your core tables—understand them deeply
  • ✓ Document splitting is powerful but requires careful configuration and testing
  • ✓ Real-time FI-CO integration eliminates reconciliation headaches
  • ✓ Migration requires 12+ weeks with proper planning and resources
  • ✓ Compatibility views are a bridge, not a destination—refactor custom code
  • ✓ S/4HANA's ACDOCA takes New GL concepts to the next level

Having worked with both Classic and New GL extensively, I can tell you that the initial migration effort pays dividends every single day in operational efficiency, reporting accuracy, and analytical capabilities. The question isn't whether to migrate—it's how quickly you can get there.

The General Ledger is the heart of your financial system. Modernizing it with New GL doesn't just upgrade your technology—it transforms how your organization understands and leverages its financial data. And in today's data-driven business environment, that's not just an IT project—it's a competitive advantage.

About the Author: With over 15 years of SAP Finance experience and multiple New GL migration projects across industries, I've seen firsthand the transformation this technology brings. Connect with me for questions about your migration journey.

New GL SAP Migration FAGLFLEXT FAGLFLEXA General Ledger Document Splitting S/4HANA Universal Journal ACDOCA