new gl benefit

General Ledger

in mySAP ERP

Requirements and Architecture

Benefits of the General Ledger

Positioning and Availability

Customers

Summary

SAP AG 2006 / General Ledger in mySAP ERP, 3

The New General Ledger – Motivation

Extensibility

Balanced booksin any dimension

Parallelaccounting

Fast closeTotal cost of ownership reduction

Transparency

Compliance

Legal entityreporting

Segmentreporting

Management reporting

New GL in

mySAP ERP


General Ledger in mySAP ERP – Architecture

Legal, Segment, and Management Reporting

. . .

General Ledger in mySAP ERP

Company Segment Partner Co Ledger Func. Area Partner Seg

Accounting Interface (IMG)

Logistics / HR Financial Supply Chain Acctng Subledgers

SAP Consolidation

(Consolidated)


GL in mySAP ERP – Standard structure

General

Ledger

Org Units

Company

Segment

Profit Center

Partner Company

Partner Segment

Partner Profit Center

Account + Subaccnts

Account

Transaction Type

Functional Area

Value in TC

Value in LC

Value in GC

Industry Templates

+ Grant

+ Fund

+ Title

+ …

Customer Extension

+ …

+ …

Despite its flexibility, General Ledger is no substitute for SAP

Profitability Analysis or SAP Business Information Warehouse.

Reasons: Data volume, performance, functionality.

Customers


Benefits of the New General Ledger


Summary


Multi-dimensional balancing

Debit

60

40

Accnt / SEG

---------- A

---------- B

---------- A

---------- B

Credit

60

40

Local GAAP

US GAAP

xxx xxx xxx

New General Ledger – Benefits and Concepts

Document entry

Debit

100

Accnt / SEG

----------

---------- A

---------- B

Credit

60

40 Online

Split

IFRS

xxx xxx xxx xxx xxx xxx

Multi-dimensional

Benefits of the New GL:

- Unified Financial & Management Acctg( by one common data str.and processing)

- Extensibility &Flexibility for customer dimensions (ind. Industry)

- Support of multiple reporting rqmnts(balanced books by any dimension)

- Support of Parallel Accounting (Parallel Ledger or Parallel Accounts)

- Fast Close (Deducing Period-end Activities)

- Increased transparency (SupportingCorporate Governance)

- Reduced TCO

Multi-ledger update Mu

ltiple

valu

atio

n


General Ledger in mySAP ERP – Benefits (1)

Unified Financial and Management Accounting

One version of the truth – stored in the General Ledger

Same valuation

No inconsistency

No reconciliation

Supports different reporting purposes

Legal entity reporting

Segment reporting

Management reporting

Multi-dimensional analysis

Account Analysis, Drilldown reporting

BI Remote reporting – slide and dice for all dimensions

Pre-defined reports delivered as SAP content


Cons.

Preparation

EC-PCA

GL in mySAP

ERP

Online Split:

Balanced Book

for any dimension

FI-SL CO-OM

CO-PA

Profit Center

Determination

CoGS Ledger

Currency

TranslationZero balanceDerivation

Accounting Interface

Persistency layer

GL in mySAP ERP – The unified approach

Reconc.Ledger


Data Structures of the new GL II

BSEG

BKPF

Fields like BSEG Documents that are not

relevant for the leading ledgerBSEG_ADD

BSEG_ADD is only filled, if additional ledgers are used for parallel

reporting!

Documents without valuation differences are posted to all ledgers.

They are also relevant for the leading ledger and are written to BSEG.

Documents that are only posted in one or more additional ledgers are

only written to BSEG_ADD.


Data Structures of the new GL III

Document header.

Un-split line item.

Un-split line item (only for

additional ledger).

Split line item.

Split totals.

Replaces GLT0.

BSEG

BKPF

BSEG_ADD

FAGLFLEXA

FAGLFLEXT

* New GL의 계획 table : FAGLFLEXP


Persistency of the General Ledger in mySAP ERP

BSEG_ADD

BSEG

BSEG

BKPF BKPF

FAGLFLEXA

(dynamic)

FAGLFLEXT

(dynamic)GLT0

Entry view part of the document

(if the leading ledger is affected)

Ledger and split parts of the document

Totals table

Document Header

Entry view part of the document

(if the leading ledger is not affected)

R/3 mySAP ERP

...

...


New G/L Reporting – Option 1

Standard ABAP reports (logical databases SDF, BRF)

Additional selection field “Ledger” (US GAAP, IAS, local GAAP)

Dynamic selections: Additional standard and user-defined fields

e.g., RFBILA00 can report a balance sheet and/or income statement for

profit center, segment, etc.

Balance Display

Selection according to new dimensions (if contained in the ledger)

Display: A maximum of five dimensions can be defined in

Customizing; these dimensions can be used to restrict the display

Drilldown according to the respective characteristic with

accumulated period values

Some standard reports are restricted to reporting at the Company Code

level. This is e.g. true for tax reports (VAT, etc.).Note



Drill-down reporting

Multi-dimensional financial reporting supporting multiple ledgers,

and delivered and user-defined characteristics


EC-CS

FI

CO

. . .

Periodic Extractor

Remote Extractor

SAP BIGeneral

Ledger

mySAP ERP is based on SAP NetWeaver which includes BW reporting.

Therefore, there is only 1 system required.


Company, Segment, Profit Center, …

Functional Area, Transaction Type, …

Company, Segment, PC, …

SAP BI Reporting


Leveraging SAP NetWeaver BI for New G/L Reporting

mySAP ERP 2005 provides several key capabilities in SAP NetWeaver BI

that drive down TCO and make third-party analytics tools for reporting

and planning obsolete

New Excel integration features to quickly analyze a situation in user‟s

normal working environment

Formatted reporting, both in Excel and on the Web, lets you easily

create tailored periodic management reports

Easy PDF-based printing from Web reports

Easy broadcasting of information/reports to users

SAP Netweaver Visual Composer to provide actionable, focused

analytics to “occasional users”

BI Accelerator to reduce BI query runtime by magnitudes, while

reducing overall system TCO


Example: Formatted Reporting for GL data

Cash Flow Cons./Planning Treasury/Risk Work.CapBalance Sheet

Balance Sheet

Multi Year Comparison

Transaction Figures

Profit Center Report

Back to Overview

CPM

Income Statement

Cash Flow - indirect



Extensibility for customer dimensions

Option to expand standard accounting with

Industry specific fields

Customer-defined fields

Meets international expectations

Integration of management dimensions in the GL

Supports allocation on additional dimensions in the GL

Important for industry solutions

Possibility to adjust to own requirements and terminology



Balanced Books for any dimension

Essential for segment reporting and management reporting

Balance sheet for segments

KPI including B/S accounts

Important for various industries

Public sector, Insurance, Media, …

Often legal requirements

Dimensions can be defined in the configuration.

There is a new standard field segment in mySAP ERP.

Segment is derived from a profit center (PC).

It can be filled manually or defaulted.

Option to determine it via a BAdI (Business AddIn)

Recommended for segment reporting (in case there are too many PC)


Balanced Books for any Dimension – Entry View

Data entry: Expenses for two profit centers

Expenses are entered for two cost centers from which profit centers

and segments are derived. Payables are entered as one total amount.

The total tax amount is derived accordingly.


Balanced Books for any Dimension – GL View

In the GL view, payables and taxes are split online by profit centers

and segments. The ratio is picked from the expense items.


Online Split for Process Chains – Invoice

Totals

Enrichment

Entry View GL View

Posting

Single

Items

Doc 4711

Split

Info

Table

Vendor Invoice

PK Account PrCtr CCtr Amount

40 Expense PC01 CC01 400


31 Payables 1000-

Vendor Invoice




31 Payables PC01 400-

31 Payables PC02 600-Document 4711

Posting

The split info (PC01 40%, PC02

60%) is stored for usage in

subsequent processes.


Online Split for Process Chains – Payment (1)

Payment


25 Payables 1000

50 Bank 970-

50 Discount 30-

Payment


25 Payables 1000

50 Bank 970-

50 Discount PC01 CC01 12-


In a first automatic step, additional cost are broken down according to the split info.

Entry View Enriched Document

Split

Info

Table

Split of the discount

The split info (PC01 40%,

PC02 60%) is applied on the

discount of the payment.


Online Split for Process Chains – Payment (2)

Enrichment

Posting

Cleared Document

Enriched Document

Payment


25 Payables 1000

50 Bank 970-



GL View


25 Payables PC01 400

25 Payables PC02 600

50 Bank PC01 388-

50 Bank PC02 582-



Totals Split

Info

Table

Single

Items

Doc 4712

Posting

The split info (PC01 40%,

PC02 60%) is also applied on

payables and bank account.



Parallel Accounting

The New General Ledger supports Parallel Accounting by using either parallel accounts or parallel ledgers.

In New GL, both approaches are considered equally powerful.The choice will depend on the specific customer situation.

However, for some industry solutions (e.g., Joint Venture Accounting) or countries parallel accounts are the better (sometimes only) choice.

The parallel accounts approach in the New GL is as powerful as in classic GL in R/3.

The parallel ledgers approach in the New GL is much better than the SAP R/3 approach of using classic GL plus the special ledger application.


Parallel Accounting by using Parallel Ledgers

Parallel Accounting – Details

Any number of parallel ledgers

For parallel valuation – local GAAP, group GAAP, tax purposes

For different fiscal year variants

Same UI for all ledgers (data entry, functions, reporting)

Almost the same functionality for all ledgers

Standard reporting for multiple ledgers

Postings into multiple ledgers

Postings per specific ledger

Closing activities are run separately in parallel ledgers.


Parallel Accounting – The Leading Ledger

In GL, one ledger is assigned the role of the „leading‟ ledger. Group valuation is usually mapped in this ledger.

All company codes are automatically assigned to the leading ledger (cannot be deactivated).

If parallel reporting is done by parallel accounts, then there is exactly one ledger in the New GL, the leading ledger.

For parallel reporting via parallel ledgers, the customer can add additional non-leading ledgers to the New GL.

Non-leading ledgers can be activated by company code, as required.

Option of different fiscal year variants per company code

Option of different dimensions or additional currencies per ledger.

The leading area of asset accounting (area 01) must be postedto the leading ledger.

Controlling must also be integrated to the leading ledger.


Parallel Ledgers – Posting to all Ledgers

If ledger is not specified at time of document entry: Posting to all defined GL ledgers

Typical transactions: Ingoing invoice, outgoing invoice, payment

Ledger A

(IAS)

(leading

ledger)

Ledger C

(HGB)

Ledger B

(US GAAP)


Parallel Ledgers – Posting to one Ledger

If ledger is specified at time of document entry: Posting to the specified ledger only

Transactions: valuation postings, period end postings

Ledger A

(IAS)

(leading

ledger)

Ledger C

(HGB)

Ledger B

(US GAAP)

B


Parallel Accounting for Primary Processes

Ledger L1 Ledger L2

Primary Processes

Invoices, Payments, …


Online split, substitution, …

Creation of one document

for all parallel ledgers

Fiscal year variant and subset

of dimensions may differ per

ledger.


Parallel Accounting for Secondary Processes

Ledger L1

Secondary Processes, e.g. IFRS

Allocation, Currency Valuation,

Carry Forward, …



Creation of parallel documents,

separate documents per ledger

Full parallel accounting: different

settings for valuation, fiscal year

variant, selected dimensions,

Ledger L2

Secondary Processes, Local GAAP



Allocation, Currency Valuation,

Carry Forward, …



Fast Close

Many period-end activities are no longer required:

Online split substitutes batch split at period end

Real-time posting from CO into FI - no longer at period end

Legal and management data are in one uniform database.

Closing activities are run just once and not multiple times.

One uniform database instead of multiple related databases

saves a lot of reconciliation time.

There is more time for analysis and better decision support.



Corporate Governance

Perfect support of transparency

Legal entity, segment and management reporting as unified whole

Same procedures and same quality for all valuations

Document principle, Entry view linked to each ledger

Less manual processing less risk of non-compliance

Less double processing less risk of non-compliance



TCO Reduction

Configuration time

Best fit – no discussions about which component to choose

Reduction of implementation costs – just one component

Reduction of costs for end user training

Daily Business

No data redundancy less data volume

No reconciliation effort

Less effort for enhancing / changing the system




Customers

Summary


New General Ledger – Availability

New Installations

New GL is the default setting for all new installations.

Upgrade Installations

Customers are not required to change and may continue using Classic GL.

Customers may run a separate migration project at a later point of time.

New GL in ERP 2004

Unrestricted availability since the end of February 2005.

New GL in ERP 2005

Ramp-up started in October 2005

Unrestricted availability since Q2 / 2006

Scenario-based Migration Service

Availability (for certain scenarios) planned for Q1 2007

Migration training (for certain scenarios) planned for Q1 2007


mySAP ERP 2005 – Enhancements of New GL

Statistical Key Figures

Enhancements in Document Online Split

Simulation Tool for Document Online Split

Transfer Prices in New GL

Template for Using New GL at Public Sector customers

Improved Interface to HCM


Positioning for New Customers

The New General Ledger of mySAP ERP provides all benefits listed

before to new customers.

The New General Ledger is ready to use and strongly recommended for

customer projects.

It is the default for new installations.

It is based on proven functionality and technology of the classic GL in

R/3 which is currently used at more than 10.000 customers.

The classic GL remains available in mySAP ERP

for upgrade customers

for new customers with specific industry requirements (e.g. JVA).


Positioning for Upgrade Customers

The classic GL from SAP R/3 is still included in mySAP ERP.

Upgrade installations will continue to use their current applications per

default. Customers who are satisfied with their current installation will

not be required to change anything and will not be affected at all.

SAP offers a New GL migration service which combines a migration

cockpit and service sessions to ensure a safe migration.

Even with the availability of this migration service, there is no push-

button solution. Customers are strongly advised to set up a separate

project for changing from the classic GL to the New GL.

For further information about the New GL migration service please

refer to http://service.sap.com/GLMIG

http://service.sap.com/GLMIG


mySAP ERP: A Unified WorldMultiple Applications

Profit Center Ledger

Management and

Segment reporting

Special Ledger

Multi-dimensional,

Customer-defined

Industry Specific

Ledgers

B/S by Grant, Fund, Title …

CoGS

Ledger

Classic GL

Legal

Requirements

GL in SAP R/3 Enterprise and mySAP ERP

General Ledger in SAP R/3 Enterprise General Ledger in mySAP ERP

General Ledger supports

Legal Requirements

Mgmt. and Segment reporting

Extensibility by Industries

Extensibility by Customers

Balanced book by any dimension

Parallel sets of books

Fast Close

TCO reduction

Intl. Accounting Standards

Compliance & Transparency


Cons.

Preparation

EC-PCA

GL in mySAP

ERP

Online Split:

Balanced Book

for any dimension

FI-SL CO-OM

CO-PA

Profit Center

Determination

CoGS Ledger

Currency

TranslationZero balanceDerivation


GL in mySAP ERP – The unified approach

Reconc.Ledger




Customers

Summary

SAP AG 2006, Conf Call with Gartner on New GL, Stefan Karl, 45

METRO – New GL Customer

“We generate a balance sheet and profit and loss statement at the profit

center/store level. The function for online document splitting enables a very

high degree of automation.”

“The elimination of manual postings and other processes at the end of the

period significantly reduces the number of errors and thus greatly contributes

to ensuring compliance.”

“Overall, we have attained an unprecedented level of data quality and

increased transparency by 30%-40% .”

“New General Ledger Accounting provides optimum support for parallel

accounting.”

Ms. Byner-Bendig, Common Template Accounting FI/CO, Metro Group

Live with the New GL in several countries since 2006

SAP AG 2006, Conf Call with Gartner on New GL, Stefan Karl, 46

HDI – New GL Customer

“With the New GL in mySAP ERP we are able to master all

requirements for parallel valuation (Local GAAP and US-GAAP).

We have achieved a significant TCO reduction during

implementation and good acceptance from our end users.”

Dieter Bankosegger ,

Head of the Financial Accounting Department

Live with New GL for Austrian subsidiary

since January 2005




Customers

Summary


Benefits of the General Ledger in mySAP ERP

1. The General Ledger supports a Unified Financial and Management

Accounting.

2. It provides Extensibility and Flexibility to add industry or customer

specific dimensions to standard accounting.

3. There is powerful functionality for Balanced Books by Any Dimension

which is important for segment and management reporting, and in

many industries.

4. The General Ledger supports Parallel Accounting by Using Parallel

Ledgers or Parallel Accounts.

5. There is a strong support of Fast Close since many period-end

activities are no longer required.

6. The General Ledger provides perfect transparency and reduces the

risk of non-compliance – thus supporting Corporate Governance.

7. Low TCO for implementing and running the General Ledger.

기타 : 중요 Notes 정보


중요 notes

Which are important OSS notes concerning New General Ledger (NewGL) in

mySAP ERP?

741821 Release limitations concerning SAP ERP 2004

756146 mySAP ERP NewGL: General information

779251 mySAP ERP NewGL : Parallel accounting

862523 mySAP ERP NewGL : new functions as of SP 10

890237 New GL with document splitting: Legacy data transfer

891144 New GL/document splitting: Risks of subsequent changes

918675 Basic architecture of the NewGL accounting

812919 mySAP ERP NewGL : migration

826357 Profit Center Acc. and NewGL in mySAPERP

852971 SEM-BCS: Integration with the NewGL

820495 mySAP ERP New GL: Data volume and parallel ledgers

Project Assessment / Workshop Service

Overview of the Migration from Classic GL to New GL in mySAP ERP 2004/2005

Positioning SAPC New GL

Migration Services


Key Customer Points – New General Ledger

When will the New G/L be available?

Comes as default in new installations

Is it still possible to use the old “classic” G/L?

Yes – in both mySAP ERP 2004 and 2005

Can we use both?

During configuration, you can run both in parallel for a short time

Does everything look different in the New G/L?

Not really, from the end-user point of view

How can we migrate from the old G/L to the New G/L?

mySAP ERP 2004 – Must apply for Development Assistance

mySAP ERP 2005 – Must apply for Development Assistance


Timeline

Schedule for the implementation of New GL

Complete Upgrade from R/3 to mySAP ERP

New GL Implementation Project

• Blueprint of New GL (determination of business requirements)

• Customizing New GL

• Customizing of Migration

• Migration Execution

Upgrade

Project

R/3 ERP

Separate projects for ERP Upgrade and New GL implementation

Project Timeline ERP Upgrade and New GL

Implementation

Migration

to NewGL

Blueprint

NewGL

New GL Implementation Project

Customizing

NewGL


New GL Migration Principles

Migration principles Date of migration is at the beginning of a fiscal year (current or future)

Year-end closing of old fiscal year must be completed prior to migration and activation of New GL

After successful data migration, New GL will be activated

Source ledger of migration can be determined by company code and account

Old Fiscal Year

Date of migration =

Fiscal Year Change Date of activation

New Fiscal Year

Run New GLRun Classic GL

Close fiscal year

Run Classic GL

Phase 0 Phase 1 Phase 2


New G/L Migration Project Steps

Old Fiscal Year

Date of migration =

Fiscal Year Change Date of activation

New Fiscal Year

Run New GLRun Classic GL

Close old fiscal year

Run Classic GL

Phase 0 Phase 1 Phase 2

New GL is live

De-activation of classic

general ledger after

transitional period

Blueprint of NewGL

Customizing of NewGL

Planning and conception of

migration

Customizing of document

splitting, if applicable

Planning &

ConfigurationMigration Testing

Customizing of Migration

Testing and Validation of New

GL and migrated test system

Go Live

Perform migration of

production system

Activation of New General

Ledger after successful migration


Migration Points

Several features delivered with mySAP ERP 2005 are

downgraded to mySAP ERP 2004 as of support package 10

For further details on ERP 2004 SP 10 refer to OSS Note 862523

ERP2004 Migration Candidates see OSS Note 812919

Also, please note:

The functions of document-splitting validation are not available in

mySAP ERP 2004!

Be sure to consider this when deciding whether to upgrade

If you intend to migrate to New G/L on mySAP ERP 2004

(ECC 5.0), make sure you review its functional limitations

prior to commencing

Refer to OSS Notes 741821 and 862523


Migration Points (cont.)

Ensure that prior to the Date of Migration (year end) you have a

well-defined and validated blueprint design for migration

Don‟t wait until near year end to commence the migration project

Plan on 6 month project window minimum

Where document splitting will be used, configuration and testing

of all document splitting MUST be completed prior to the date of

migration in order to support validation (simulation)

prior to activation

Currently any customer looking at migration must obtain

approval from SAP Development in order to be supported

This applies to both mySAP ERP 2004 and mySAP ERP 2005

If interested, please contact Gary Fullmer


Scenarios Supported by New GL Migration

Service

Scenario 1: Merge of FI ledger (9,500 Euro)

Merging of classic GL ledger, consolidation preparation ledger and cost-

of-sales ledger, customer-specific fields in summary reporting

Benefits:

Reduced data redundancy

Reduced effort for period end closing

Harmonized reporting

Scenario 2: Merge of FI, PCA and/or SL ledger (14,500 Euro)

Scenario 1 and additional merging of Profit Center Accounting and

Special Ledger, customer-specific fields in summary reporting

Benefits:

Replacement of Special Ledger Accounting by NewGL

Enhanced auditability

Better integrated reporting


Scenarios Supported by New GL Migration Service

Scenario 3: Scenario 2 + Document split (e.g. for profit center, segment or business area reporting) (19,500 Euro) Document split allows balance sheet on additional dimensions such as profit

center, segments or business areas

Benefit: Flexible reporting on entities other than company code

Scenario 4: Scenario 2 + Change to ledger solution for parallel accounting (?) Switch from parallel accounting by parallel accounts to parallel ledger

Benefits: more transparent chart of accounts, reporting, auditability

Scenario 5: Scenario 3 + Change to ledger solution for parallel accounting (?) See descriptions of scenarios 2,3,4

Any scenarios that differ from the above standard scenarios aremigrated project-by-project based on scenario 5

Project Assessment / Workshop Service

Overview of the Migration from Classic GL to New GL in mySAP ERP 2004/2005

Positioning SAPC New GL

Migration Services


Project Assessment:

Service Offering: Customer Migration Workshop

Customers considering migration to New GL are strongly

recommended to engage SAPC Services for 2-Day Migration

Assessment Workshop

Benefits:

Explanation of Migration Concepts and Procedures

Scope, Complexity, and Risk Analysis

Resource Estimation

Develop Business Case Justification for Migration

Develop High Level Project Plan and Timeline


Project Assessment:

Scope:

Number of Company Codes – How many? Complexity of footprint

Use of Document Splitting – Are all transactions split? Effects of Intercompany processing on Splitting

Use of Parallel Accounting – Current situation (Accounts Approach v. Ledger Approach

Foreign Currency Revaluation and Postings

Planning and Allocations

Integration with other Modules – Use of EC-PCA, FI-SL, CO-OM, Fixed Assets

Current Reporting Environment and Report Delivery


Project Assessment:

Organizational Structures:

Chart of Accounts – structure of accounts, open item

managed v. balance forward

Controlling Areas – Single v. Multiple, Use of EC-PCA

Fiscal Year Variants – Are we dealing with multiple

migration plans?

Characteristic and Key Figure Definition

Current Configuration Considerations:

Current Use of Document Types (Splitting Relevant)

Intercompany Processing

Validations and Substitutions, Other areas derived

assignments (3KEH)


Project Assessment:

Volumes:

How many open item accounts, how many open items?

What are the document volumes by month?

How many balance forward accounts x number of

company codes?

Data Sources:

Current use of FI-SL or EC-PCA as source ledger

How to establish beginning balances

Use of default values for unassigned or unidentified

characteristics


Project Assessment:

Interfaces:

Inbound – field status settings, use of document types,

processing of large entries with splitting

Outbound – Use of GLT0? GLPCA? FI-SL line items

are now split…..

Approach to be used for testing

Data Validation:

Who will validate data?

How will data be validated? Reconciliation of

migrated data and how to document results.

Sign-Off and Post-Audit Considerations

Planning -- Project Phase 1

Data Migration – Project Phase 2

End the Project – Phase 3

Migration Project Phases


Project Planning – Phase 1 1/2

Project Planning and Blueprinting

The project plan should include:

The Final Design of new General Ledger

Reporting Requirements

Legal Issues

Initial Configuration Structure

Migration Planning – Complex vs. Simple

Many features can be added later

Switch from Account Based to Parallel Ledger Accounting

On-Line Document Splitting

Real Time Data Update from Controlling

Segment and Profit Center Reporting

Project Schedule

Fiscal Year Close

Start Configuration of General Ledger

Switch off old General Ledger


Demo Configure New General Ledger -- Overview


Project Planning -- Phase 1 2/2

Project Planning and Blueprinting Cont‟d – More Considerations

How to use of Profit Center and Segment Accounting ?

Implementation of Cost of Sales Accounting ?

Continued use of Special Purpose Ledgers?

Current Use?

operational system or in consolidation

Online update or by rollup?

Account Splitting

Impact on other mySAP ERP Modules

How many interfaces to external systems exits

Note: If document splitting is going to be introduced

configuration of document splitting must occur during phase 0

in order to support simulation during phase I.


Project Planning – Phase 1

Migration Plan Considerations

Open Item Migration from old Fiscal Year

Migration with or without Document Splitting

Number of open items

Items posted to earlier releases prior to R/3 4.5

Number of Company Codes and Cross-Company-Code Clearings

Use of different fiscal year variants

Effects the number of Migration Plans Required

Use of additional currencies in special purpose ledger

Parallel valuation

Special feature of migration from account approach to ledger approach


Project Planning Phase 1 -- Summary

Basic Requirements that should be completed prior to Phase 2

Project Blueprint

Desired Outcome

Initial Configuration of New General Ledger

Parallel Accounting

Real time updates for Controlling

Configuration of Migration Plan or Plans

How Many and what Company Codes

Will Document Splitting be Used initially

Will open items from old fiscal year be split and posted

Configure Document Splitting

Use Delivered Method or customized


Demo Build Migration Plan



End the Project – Phase 3



Begin the GL Data Migration & Testing – Phase 2

Step 1 – Must be Completed Prior to Data Migration Start:

Date of Migration Established

Must be Fiscal Year End

Old/Prior Fiscal Year End Closing closed & locked against further

posting

Configuration of new General Ledger Completed

Document Splitting Configured if required

Migration Plan or Plans Configured

Company Codes Selected for each Migration Plan

Parallel Ledgers Configured & Assigned to Company Codes

Additional Currency selected for Company Codes

Multi-Fiscal Year Variants assigned to Company Codes

Step 1 – Must be Completed Prior to Data Migration Start:


Realization:

Migration Tasks can be divided into 4 categories:

Open Item Migration

Current Document Transfer

Balance Carry-Forward

Beginning Balance Adjustments*

* Required if document splitting is activated


Update Documents to

Ledgers

Update Documents to

Ledgers

Update Items to

Ledgers

Update Items to

Ledgers

Migration Project Data Flow – Phase 2

Create Worklists

Open

Items

Prior

Fiscal

Year

Documents.

from

Current

Fiscal

Year

Build Document

Splitting Information

Build Document

Splitting Information

Update Items to

Ledgers

Update Documents to

Ledgers

BADI

Document Splitting

Customizing

Alternative

Customizing for

Document Splitting

Phase 2

Phase 2

Update new G/L Data Tables

+

Build Balance Carryforward

Build new G/L Data Tables

Closing

Balance

of Non-

OI-

Managed

Accounts

Update Balance

Carryforward to

Ledgers


GL Data Migration & Testing – Phase 2

For:

The Data to be Migrated to New General Ledger Data Tables

Worklists are assigned to each Migration Plan

Each Migration Plan requires two worklists minimum

Prior Year Open Items

Current Year New Documents

Worklists can be created 2 ways

In Cockpit Environment (All at Once)

Individually (One at a time)

Step 2 – Create Migration Worklists

Open Items from closed/old fiscal year

Documents posted in current/new fiscal year


Build Worklists



For Both Types of Migration Data:

Open Items from Prior/Old Fiscal Year

Requires the use of a BADI

New Documents posted in current Fiscal Year

Will use configured Splitting Rules

Configured during Phase One of the Migration Project

SAP Delivered

Customized Splitting Rules

Test Splitting Results or both Data Records

GL Accounts used for Splitting

Document Types Selected for Splitting

Etc.

Step 2 – Build & Test Document Split Data

BADI



Migrate the Data:

Update New General Ledger Totals Tables

FAGLFLEXA - ERP

FAGLFLEMA – Public Sector

Totals Tables Assigned During General Ledger Configuration Project Phase 1

If Document Splitting is Configured additional data tables will be

updated with Split Data Results

Based on BADI or Splitting Rules

Step 3 – Migrate the Data to the New Data Tables


Data Migration



Old Fiscal Year Balance Sheet Accounts

For Open item managed accounts initial balances are populated in period 00

as open items at date of migration are migrated.

Data (balances) not transferred via Open Item Migration Process populated in

period 00 from appropriate defined source.

Cost of Sales Ledger 0F

Profit Center Accounting Ledger 8A

User Defined FL-SL‟s

Parallel Currency Ledgers used in Classic General Ledger

Others ?

Configuration Requires

ID of Data Source Ledgers

Assignment of Target Ledgers

Manual Adjustments (FBCB) can be made in period 00, where required, after

initial balances populated to establish correct opening position.

Note: Data values are added to any existing values in target ledgers

Control how many time this process is activated

Can reverse process and start over

Step 4 – Balance Carry Forward


Balance Carry Forward


Evaluation of Migration Results – Phase 2

Check and Certify Migration Results:

Analyze Migration Status -- IMG Tool

By Migration Plan or Plans

Open Items & Documents

Company Codes

Document Numbers

Processing Status

Compare Ledgers

By Company Code or Account

Example compare GLT0 to FAGLFLEXA

During parallel processing phase 2

By Cost Center

Others

These tools can also be used to check on data migration progress

not just at the end

Also, a document splitting simulation tool is available


Summary Evaluation Tools Available – Phase 2

Evaluation of migration status

Statistics, error overview, object lists

Log of balance origin

Ledger to ledger comparison

Log of migration-specific adjustments

Ledger-independent display of document splitting information

Simulation of document splitting


Evaluation of Migration Results


Start Over -- Resetting the Migration Plan

Phase Two Option Only:

IMG Menu Option

FAGL_MIG_RESTORE_ALL

Complete reset -> to ensure data consistencyWarning: Not possible when New G/L Accounting is active!

NOTE: The following two reset options can only be achieved using the transaction codes:

FAGL_MIG_RESTORE_OP

Removing individual open items from new tables; Warning: May cause inconsistencies in the balances if the data is not build correctly with the repeat migration.

FAGL_MIG_RESTORE_RP

Removing individual documents from new tables; Warning: May cause inconsistencies in the balances if the data is not build correctly with the repeat migration.


Re-Set Migration Plan


Realization:

Cut-Over

Recommended to be done during „quiet period‟ (e.g. no

transaction processing taking place).

Performance benchmarks compiled during testing will give a

good estimation of anticipated down-time.

Only the worklist processes (open items and documents) need

to be processed during the quiet period. Carry forward and

FBCB adjustments can be processed after the system has

been returned to the users.


GL Data Migration & Testing Phase Two -- Summary

Basic Requirements that should be completed prior to Phase 3

Old Fiscal Year End Closing Completed and Locked

Migration Plans Activated

Worklists created for both Open Items and new Documents

Simulation of Document Splitting

Migrate the Data to the new data tables

Test and certify the migration results

Re-set the Migration Plans as required

Re-peat the data migration as required

Re-test and certify the data as required

Move to Phase 3 of Project and set the switch to close the project



End the Data Migration – Project Phase 3



End the Migration Project – Phase 3

IMG Menu Option:

All data must be checked and certified prior to this activity

Final Step and no Return

Effects

All Migration Plan are de-activated

Other migration functions used during the migration process are also de-

activated

Manual Adjustments to Balance Carry Forward items (FBCB)

Note: Once this step is complete the migration plans are

de-activated