AC210_EN_Col92_FV_Part_A4 (第8页) | ERP软件技术分享

第 276 页 / 共 337 页

Unit6: ParallelAccounting AC210

5. Nowrepeatsubtask2andtrytolinkyournewnon-leadingledgerN#with

your company code AA##.

a) Customizing→FinancialAccounting(New)→FinancialAccounting

GlobalSettings(New)→Ledgers →Ledger→DefineandActivate

Non-Leading Ledgers.

b) In the Determine Work Area: Entry dialog box, enter your new

non-leadingledger N#andcopy the data.

c) Choose Edit → New Entries.

d) Enter your company code AA## in the Company Code column and

confirm your entry.

e) After confirmingyour data, answer the questionin theConsistency

Check with No.

f) Save.

6. Inthenewnon-leadingledgerN#,youwanttomapSegmentReportinganda

profitandlossstatementbasedonCostofSalesAccounting. Assignthese

twoscenariostoyourledgerN#andsavethedata.

a) Customizing→FinancialAccounting(New)→FinancialAccounting

Global Settings (New) → Ledgers → Ledger → Assign Scenarios

and Customer Fields to Ledgers.

b) Select ledgerN# and double-click the Scenarios entry in thedialog

structure.

c) Choose Edit → New Entries.

d) Select the Segmentation entry in the Scenario for General Ledger

Accounting column and Cost-of-Sales Accounting for the second

column.

e) Save your data.

7. NowpostaG/LaccountdocumenttoyourcompanycodeAA##: Enterthis

purchaseofofficesupplieswithcash. Todoso,useaccounts:

405200 (=> consumption office supplies)

100000 (=> petty cash)

Continued on next page

258

第 277 页 / 共 337 页

AC210 Lesson: Parallel Accounting

Thegrossamountof€66istobeenteredwithtoday'sdate,currencyEuro

and10% VAT.Choosecost centerT–F05A##astheCO-relevantaccount

assignment.

a) SAPEasyAccess→Accounting→FinancialAccounting→General

Ledger→Posting→EnterG/LAccountDocument.

Entertheremainingdataasdescribedintheexercisetext.

b) Beforeyoupost, gototheDetailtabpageandsettheCalculateTax

checkbox.

c) Simulate and save the document.

8. Display the document. You should now be able to call ledger N#, in

additiontotheleadingledger0L,inthegeneralledgerview.

a) SAPEasyAccess→Accounting→FinancialAccounting→General

Ledger→Posting→EnterG/LAccountDocument.

b) ChooseDocument→Displayfromthemenu.

c) Choose Other Ledger.

9. Whatdoyounoticeabout the documentin ledgerN#, for example, when

you view the posting documents or (on the other side) the CO account

assignment (=> cost center)?

Answer: Thepostingamountsarethesameasintheleadingledger,because

itemsarepostedtoallledgersbydefault. Thecostcentercharacteristicis

not displayed(or updated) in ledgerN#, because theCost CenterUpdate

scenario hasnot been defined for ledgerN#.

Continued on next page

259

第 278 页 / 共 337 页

Unit6: ParallelAccounting AC210

Task 2:

ForeignCurrencyValuationinTheLedgerApproach(NewGeneralLedger)

Hint: Enterdifferentamountsinthedifferentledgers(duetovaluation

differences). Todoso,usetheforeigncurrencyvaluationagainforyour

twoopencustomeritems(fromtheexerciseinunit5).

Since the ledger solution in the new general ledger posts different

valuation accounts to the different ledgers, but to the same accounts,

the account determination as you maintained it in the exercise in unit

5 will suffice.

You must create an additional valuation area (in FI) and an additional

valuationmethod. Tocarryouttheforeigncurrencyvaluation,youalso

need accounting principles.

1. CreateanadditionalvaluationareainFICustomizing. TheIDofthenew

valuationareashouldhavetwoletters. Thefirst letterofeverygroupis

"I". The“I”standsfor“International”inthisexample. Selectthesecond

letter for your groupfromthefollowingtable:

Group 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18

Letter Z B C D E F G H I J K L M N O P Q R

Examples:

Group1receivestheletterZ:=>TheledgerwouldthereforebecalledIZ.

Group5receivestheletterE:=>TheledgerwouldthereforebecalledIE.

Alsoenterthefollowingdataforthenewledger:

ValuationArea: I# (=> # stands for the second letter from the

above table)

Valuationmethod: Leave blank for now

CurrencyType: Company code currency

Continued on next page

260

Group	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18
Letter	Z	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R

第 279 页 / 共 337 页

AC210 Lesson: Parallel Accounting

Additionalcurrency: Leave blank

FS Version: Leave blank or enter INT

Long Text: Internationalvaluationareagr. ##

a) Customizing → Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Define

Valuation Areas.

b) Choose Edit → New Entries.

c) Entertheremainingdataasdescribedintheexercisetext.

2. AlsocreateavaluationmethodinCustomizing. Nameyournewvaluation

method I## and define it as follows:

Description: International valuation for averagerate, group

ValuationProcedure: Always valuate

DocumentType: SA

Exch.Rate Type for

Debit/CreditBalance: M

a) Customizing → Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Define

Valuation Methods.

b) Choose Edit → New Entries.

c) Youdonotneedtofillinanyotherfieldsforthisexercise.

3. Define your new valuation method I## (subsequently) in your new

valuation areaI#fromthelasttaskstepbut one.

a) Customizing → Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Define

Valuation Areas.

4. Touniquelydefinewhichvaluationareawillposttowhichledger,younow

havetodefinetheaccountingprinciples(AP).Createthetwofollowing

accounting principles:

=>LO##withthedescriptionLocal APGroup##

and

Continued on next page

261

第 280 页 / 共 337 页

Unit6: ParallelAccounting AC210

=>IA##withthedescriptionInternationalAPGroup##

Note: Hereagain,thehashcharactersstandforyourgroup/computer

number.

a) Customizing→FinancialAccounting(new)→FinancialAccounting

GlobalSettings(new) →Ledgers→ParallelAccounting→Define

Accounting Principles.

b) Choose menu path Edit → New Entries and define the two new

accountingprinciplesasdescribedintheexercise.

c) Save your data.

5. You needtwo(types of)links/assignments:

First you combine the accounting principles with the corresponding

ledgers:

APLO## <=> Ledger 0L

APIA## <=> Ledger N#

Then thevaluation areas(from FI)must be linked with theaccounting

principles:

Continued on next page

262

第 281 页 / 共 337 页

AC210 Lesson: Parallel Accounting

(Local) valuation area L# <=> AP LO##

(fromex. inchapter5)

(International)valuationarea <=> AP IA##

I#

Hint: Youhavenowclearlydefinedwhichvaluationapproachwill

bepostedtowhichledgerinthenewgeneralledger.

a) Combine of accounting principles with ledgers: Customizing →

FinancialAccounting(New)→FinancialAccountingGlobalSettings

(New) → Ledgers → Parallel Accounting → Assign Accounting

Principle to Ledger Groups.

ChoosemenupathEdit→NewEntriesandlinkthetwonewaccounting

principleswiththeledgersasdescribedintheexercise. Saveyourdata.

b) Link valuation areas (from FI) with accounting principles:

Customizing → Financial Accounting (New) → General Ledger

Accounting (New) → Periodic Processing → Valuate → Assign

ValuationAreasandAccounting Principles.

Choose menu path Edit → New Entries and link the two new

accounting principles with the valuation areas as described in the

exercise. Save your data.

6. To carry out the international valuation, you must also make a system

setting:

Since a run for the international valuation posts exclusively to the

non-leading ledger N#, you must assign a number range interval to the

relevantdocumenttype(=>accordingtothevaluationmethod,thedocument

typeSA)fortheentryviewofthenon-leadingledgerN#.

Hint: However,youcannotdefinethesameinterval(=>interval

01)that isalreadydefinedindocumenttypeSA.Thisistoensure

thattherearenogapsin theleadingledger.

In light of this, create a newnumber range interval for your company

codeAA## using the following values:

Continued on next page

263

第 282 页 / 共 337 页

Unit6: ParallelAccounting AC210

No. Year From ToNumber Current Ext

Number Number

30 9999 3000000000 3900000000

a) Customizing→FinancialAccounting(New)→FinancialAccounting

Global Settings (New) →Document → Document Number Ranges

→ Documents in Entry View → Define Document Number Ranges

for Entry View.

=> Company code: AA##

=> Pushbutton Change Intervals

=> Pushbutton Add Intervals

b) Createthenewintervalasdescribedintheexercise.

7. AssignthenewintervaltodocumenttypeSAfortheentryviewinledger

N#.

a) Customizing→FinancialAccounting(New)→FinancialAccounting

Global Settings (New) → Document→ Document Types → Define

Document TypesforEntryViewinaLedger.

b) In the Determine Work Area: Entry dialog box, enter your new

non-leadingledger N#andcopy the data.

c) ChoosemenupathEdit→NewEntriesandassignnumberrange30to

document type SA.

d) Save your entry.

8. Youcannowstarttheforeigncurrencyvaluationrun. Firstremindyourself

ofthestepsfromthepreviousunitandthespecifiedprerequisites:

=> You have two open customer invoices that were entered in USD. If

youcannot remember thepostings, call acustomer line itemlist for your

customer 210##.

=>ThecurrentUSD->Euroexchangerateis=1.

=> You already ran the local/book valuation run on the last day of the

previous month in the preceding exercise. You can start it again, but no

result will be posted.

=>Duetothelowestvalueprinciple,yourvaluationrunonlyvaluatedone

of the two customer items.

Calltheforeigncurrencyvaluationprograminaccountsreceivableand

enter the following data:

Continued on next page

264

No.	Year	From Number	ToNumber	Current Number	Ext
30	9999	3000000000	3900000000

第 283 页 / 共 337 页

AC210 Lesson: Parallel Accounting

CompanyCode: AA##

Valuation Key Last day of previous month

Date:

Caution: IfyourAC210trainingcoursetakesplaceinJanuary,use

January31ofthecurrent yearasthekeydate.

ValuationArea: I#

IndicatorCreate Donotsetuntilafteratestrun,whenyoustartthe

Postings: update run.

Hint: You do not need to specify afolder name, as you will not

use a folder.

Theprogramalsoneedstoknowwhich"objects"aretobeprocessed.

=> Open tab page Open Items: Set the Valuate Customer Open Items

checkbox.

Now start the program.

Since you ran this program with an international approach, note that

both open itemswere valuated – once, (asin thelocal valuation), with a

devaluation/expense(ofEUR1,000)andoncewitharevaluation/revenue!

a) SAP EasyAccessmenu →Accounting →Financial Accounting→

AccountsReceivable→PeriodicProcessing→Closing→Valuate→

ForeignCurrencyValuationofOpenItems(New).

b) Takeall otherinformationfromtheexercise.

9. Call the posted valuation document(s).

a) Press the Postings button in the results list after the update run.

Positionthecursoronthedocumentnumberofthepostingdocument

and choose Display Document.

10. Ifyoucanseethepostingamount€0,thedisplayisinUSD.Todisplaythe

euro-denominatedvalues, clickChangeDisplayCurrency. You can see

intheentryviewthatthesegments(andprofitcenter)weretakenfromthe

original customer invoices.

Whenyougotothegeneralledgerview,thesystemimmediatelyshowsthe

documentonly(andcorrectly)inthenon-leadingledgerN#.

Look at the two document numbers.

a) Press the Display Currency button.

Continued on next page

265

第 284 页 / 共 337 页

Unit6: ParallelAccounting AC210

11. There may be two questions:

Why is the characteristic Profit Center also saved and displayed in the

non-leading ledger?

Answer: You see the Profit Center characteristic because you assigned

theSegment Reportingscenario toyournon-leadingledgerN#. Sincethe

Segmentcharacteristic isderived from the Profit Centercharacteristicby

default,thisisautomaticallysavedwhentheSegmentReportingscenario

is assigned.

You canalsoseethisintheSAP system, namelyinthefieldsassignedto

a scenario: Financial Accounting(New)→Financial AccountingGlobal

Settings (New) → Ledgers → Fields → Display Scenarios for General

Ledger Accounting.

Confirmthetwoinformationmessagesandselectthesegmentationscenario.

YouseethattheG/LfieldPRCTRisalsoupdated.

12. Why isthereautomaticallya reset document?

Answer: Thereisautomaticallyaresetdocumentbecauseyouhavenot(yet)

definedthe(new) international valuationareaI#asa valuation areawith

delta posting logic.

266

第 285 页 / 共 337 页

AC210 Lesson: Parallel Accounting

Lesson Summary

You should now be able to:

• ... Understandtheledgerapproach(inthenewgeneralledger)andhowto

model parallel accounting principles

• ... Define, configureandusenon-leadingledgers

• ... Explainwhenand howtouse ledgergroups

• ... Understandthepurposeofaledger(group-)specificperiodcheck

• ... Understand the option of ledger group specific clearing and assess

whetherusingthisoptionmakessenseinyour case

• ... DescribethenewvalidationoptionsthathavebecomeavailablewithEhP4

• ... Understandtheintegrationoftheledgerapproach(innewGeneralLedger

Accounting) with asset accounting

267

第 286 页 / 共 337 页

UnitSummary AC210

Unit Summary

You should now be able to:

• ... Understandtheledgerapproach(inthenewgeneralledger)andhowto

model parallel accounting principles

• ... Define, configureandusenon-leadingledgers

• ... Explainwhen andhowtouseledger groups

• ... Understandthepurposeofaledger(group-)specificperiodcheck

• ... Understand the option of ledger group specific clearing and assess

whetherusingthisoptionmakessenseinyourcase

• ... DescribethenewvalidationoptionsthathavebecomeavailablewithEhP4

• ... Understandtheintegrationoftheledgerapproach(innewGeneralLedger

Accounting) with asset accounting

268

第 287 页 / 共 337 页

第 288 页 / 共 337 页

第 289 页 / 共 337 页

Unit 7

Reporting

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• ... UsethevariousnewG/Ldrilldownreportsasthestandardanalysistool

in new General Ledger Accounting

• ... Use the program RFBILA00 for different ledgers and for new

characteristics

• ... Understand the concept of the origin object type and the associated

(new) functions

Unit Contents

Lesson: Reporting ..............................................................270

Exercise 9: Data Evaluation in New General Ledger Accounting....285

269

第 290 页 / 共 337 页

Unit7: Reporting AC210

Lesson: Reporting

Lesson Overview

• Comparison of data in the classic and the new general ledger, though

in AC210 this is merely for informational purposes. In practice, such a

comparisonwouldonlybedoneaspartofamigrationprocess(=>migration

from classictonewgeneral ledgeraccounting).

• Useof the(standard)drilldownreportsinnewG/L

• ThelineitemdisplayandthebalancedisplayinthenewG/L

• New reporting options with EhP3 and EhP4.

Lesson Objectives

After completingthislesson, you will beable to:

• ... UsethevariousnewG/Ldrilldownreportsasthestandardanalysistool

in new General Ledger Accounting

• ... Use the program RFBILA00 for different ledgers and for new

characteristics

• ... Understand the concept of the origin object type and the associated

(new) functions

Business Example

Softwaremust alwaysbemeasuredbythedegreeto whichentereddatacanbe

analyzedandreportedonusingstandardresources. Nowfamiliarizeyourselfwith

thereportingoptionsofferedbynewGeneralLedgerAccounting.

270

第 291 页 / 共 337 页

AC210 Lesson: Reporting

Figure 119: Reporting: Data Source

Customizingpath: FinancialAccounting(New)→FinancialAccountingGlobal

Settings(New)→Tools→DeactivateUpdateofClassicGeneralLedger(GLT0).

AdditionalinformationabouttheindicatorWriteClassicGeneralLedger: Any

updateoftheclassicgeneralledgertablesshouldbedeactivatedafteracertain

time,forexample,afteryourunandverifythefirstend-of-periodclosing.

Ifyouupdatethetablesofboththeconventionalandthenewgeneralledger,you

willgeneratetoomanyunneededandredundantdatarecords.

Caution: TheCustomizing activityshouldalwaysbeexecutedaspart

of an implementation ormigrationproject.

271

第 292 页 / 共 337 页

Unit7: Reporting AC210

Figure 120: Comparing Different Ledgers

Customizingpath: FinancialAccounting(New)→FinancialAccountingGlobal

Settings(New) →Tools →CompareLedgers.

IncontrasttoCO,actualdatainFIisoftenwrittentoVersion1.

Youcanalsousethistransactiontocompareleadingandnon-leadingledgers.

Figure 121: Financial Statement

Werecommendsavingfrequently-usedprogramvariantstosavetime.

272

第 293 页 / 共 337 页

AC210 Lesson: Reporting

Figure 122: Financial Statements – An Alternative

Definingsuitableprogrammingvariantscansaveyoulotsoftimeinthedrilldown

reports.

Figure 123: Fin. Statement Actual/ActualComparison (1)

273

第 294 页 / 共 337 页

Unit7: Reporting AC210

Youcanchooseintheselectionscreenforthedrilldownreportwhetheryouwant

tocallthereportintheconventionalorgraphicallayout.

Figure 124: Fin. Statement Actual/Actual Comparison (2)

Theresultis,ofcourse,identicalwhentheselectionisthesame.

Figure 125: Navigation in Drilldown Reporting

274

第 295 页 / 共 337 页

AC210 Lesson: Reporting

The program's flexibility also lets you “drill down” to an individual financial

accounting document: Press the button for the existing RRI (report-report

interface)ontheresultsscreen=>ChooseLineItems.

Figure 126: Call of all New G/L Drilldowns

TransactionFGI0displaysalistofdefinedprogramvariants,whichyoucanrun

instantly.

But drilldown reporting has not been used in financial accounting only since

SAP ERP or new general ledger accounting. To display an overview of FI

drilldownreportsthatyoucanalsousewiththeconventionalgeneralledger,call

transaction FSI0.

275

第 296 页 / 共 337 页

Unit7: Reporting AC210

Figure 127: New Drilldown Reports (=> EhP3) for Profit Centers and

Segments

Note: If, after you import Enhancement Package 3 in report type002

(=> reporting for table FAGLFLEXT), only five drilldown reports are

displayed, you must first import thenew drilldownreportsfrom client

000: Call transaction FCI0 and follow the menupath Environment ->

Importreports->Execute. Inthedialogboxthatisthendisplayed,select

thereporttypeReportingforTableFAGLFLEXT.Thesystemdisplaysthe

newobjects: Selectthemallandexecutethem(inthebackground).

AfteryouactivatethebusinessfunctionFIN_GL_CI_1,youcanalsofindthenew

drilldownreportsforEnhancementPackage3intheSAPEasyAccessMenuin

thegeneralledgerinformationsysteminthefolderGeneralLedgerReports(New).

There you will also find a new report/program (=> program name

FAGL_PLAN_ITEMS_GL)tooutputtheplanlineitems: GeneralLedgerReports

(New) ->LineItems-> DisplayPlan Line Items

TCode for the plan line item report: FAGLP03.

Hint: Inaddition, EhP 3providesa migration tooltotransfer Report

Writerand/orReportPainterreportsthatyouusedbasedonthetable

GLPCT (=> totals table for classic profit center accounting) to new

general ledger accounting so that youcan alsouse these reportsbased

on the tableFAGLFLEXT.

Customizingpath: FinancialAccounting(New)→GeneralLedgerAccounting

(New) → Information System → Report Writer/Report Painter Reports →

TransferofReportsfromProfitCenterAccounting→TransferReports.

276

第 297 页 / 共 337 页

AC210 Lesson: Reporting

TCode: FAGL_RMIGR

Figure128: FIDrilldownTransactionFigures-AccountBalance

Werecommendusingconventional drill-down reporting todisplaytheG/L

account balances.

Youcanalsobranchfromheretotheoriginallyposteddocuments.

TheactualG/LaccountbalancedisplayhasalsobeenredesignedinSAPERP–

transaction FAGLB03 - see next graphic.

277

第 298 页 / 共 337 页

Unit7: Reporting AC210

Figure129: G/LAccountBalanceDisplay(New)–TCodeFAGLB03

Customizing path for maintaining the characteristics that can be selected

dynamically: FinancialAccounting(New)→GeneralLedgerAccounting(New)

→ InformationSystem→Define BalanceDisplay.

ApplicationpathforcallingtheG/Laccountbalancedisplay: Accounting→

FinancialAccounting→GeneralLedger→Account→DisplayBalances(New).

Caution: IfyouhavenotassignedthenewG/Lscenariobusinessarea,

youwillautomaticallybe“redirected”tothenewtransactionFAGLB03

whenyoucalltheclassicbalancedisplaytransactionFS10N.

If you use the business area scenario, you can still call the classic

transactionaswellasthenewone. IfyouusetransactionFS10N,thedata

is still readby theclassictotalstableGLT0.

第 299 页 / 共 337 页

AC210 Lesson: Reporting

Figure 130: Line Item Display (New) – TCode FAGLL03

You find the G/L account line item display in the SAP Easy Access menu

under: Accounting→FinancialAccounting→General Ledger→Account→

Display/Change Items (New).

Figure131: ReportTypesPayables/ReceivablebyGeneralLedgerAccount

Assignment

279

第 300 页 / 共 337 页

Unit7: Reporting AC210

The standard general ledger account assignments for this drilldown report are

the Profit Center and Segment.

Theledgerisselectedinthedrilldownselectionscreen.

Hint: Therequirementfor suchadrilldown originatesfrom(classic)

profit centeraccounting, whereit ispossibletousethereportgroups

8A99 (=> Profit Center: Receivables) and 8A98 (=> Profit Center:

Payables) to structure the receivables or payables account by profit

centeroncethevalueshavebeentransferredsuccessfullytoprofitcenter

accounting.

You find these drilldown options in the SAP Easy Access menu under:

Accounting→FinancialAccounting→GeneralLedger→InformationSystem

→GeneralLedgerReports(New)→LineItems→OpenItems.

Figure132: DrilldownExamples-PayablesbyG/LAccountAssignment

Ofcourse, youcanalsoselectasinglevendorandtodrilldownbyprofitcenter

at any time.

The screenshots show theclassic display.

Note: What's missing is the display of the documents/document

numbers that make up the individual amounts. You can do so, for

example,usingtheoutputtypeobjectlist: Seenextgraphic.

280

第 301 页 / 共 337 页

AC210 Lesson: Reporting

Figure 133: Object List Output Type

Note: You couldalsousetheobjectlist toprocesstheresultsfromthe

lasttwographics(suchas“payablessortedbyprofitcenter”or“payables

per vendor”).

281

第 302 页 / 共 337 页

Unit7: Reporting AC210

Figure 134: Navigation Characteristic Origin Object

Caution: Toworkwiththecharacteristicoriginobject(type),youmust

firstadd(standard) field OriginObjectType(EC-PCA)(=>fieldname

ZZHOART)FAGLFLEXTandassignthefieldtoatleastoneledger.

The described enhancement functions in the standard as of Enhancement

Package3(=>BusinessFunctionFIN_GL_CI_1).

Hint: Inthedeliveredstandarddrilldownreportsinwhichyouwantto

evaluatethecharacteristicoriginobject,youneedto"makeitavailable

as the characteristic to be selected".

* If you want the entry Select CO Reports for Origin Object to appear

as a possible branch from the report-report interface (=> RRI), ABAP

programFAGL_RRI_RECON_COmustbeassignedinthedrilldownreport/in

the report assignment (=> for example using TCodeFGI0 → Options tab →

Report Assignment button).

Caution: TheaforementionedprogramFAGL_RRI_RECON_COisonly

availableasofEHP4(=>BusinessFunctionFIN_GL_CI_2).

“RRI”stands for “Report Report Interface”.

282

第 303 页 / 共 337 页

AC210 Lesson: Reporting

Figure 135: Report Report Interface for CO reconciliation - (CO) Receiver

Reports

Thedisplayedreceiverreportsaretheassociatedstandardreportsforoverhead

costs orders.

Hint: To be able to call these receiver reports for the overhead cost

orderobject(andalsofortheotherstandardCOobjects)fromtheRRI,

you must load/activate them once.

You can load/activate them by executing the Customizing activity Financial

Accounting(New)→GeneralLedgerAccounting(New)→InformationSystem

→ Drilldown Reports (G/L Accounts) → Report Report Interface for CO

Reconciliation → Change Report Report Interface for Reconciliation with

Controlling.

Caution: This path is only available as ofEHP4 / Business Function

FIN_GL_CI_2.

283

第 304 页 / 共 337 页

Unit7: Reporting AC210

284

第 305 页 / 共 337 页

AC210 Lesson: Reporting

Exercise 9: Data Evaluation in New

General Ledger Accounting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Callupfinancialstatementsforcompanycodes,segments,orprofitcenters.

YouwillnotonlybeabletoconfiguretheprogramRFBILA00properly;you

willalsobeabletousethenewFIdrilldownreports.

Business Example

Softwaremustalwaysbemeasuredbythedegreetowhichentereddatacanbe

analyzedandreportedonusingstandardresources. Firstacquaintyourselfwith

how data is evaluated in New General Ledger Accounting, for example using

the drilldown technique.

Task 1:

ExercisesforevaluatingdatainNewGeneralLedgerAccounting–the"classic":

program RFBILA00

1. Callthebalancesheet/profitandlossreportRFBILA00anddisplaythe

financialstatementsforyourcompanycodeAA##andledger0L.

Enterthefollowingdataontheselectionscreen:

Chart of INT

accounts:

Companycode: AA##

Ledger: 0L or leave blank

Financial INT

statement

version:

Reportingyear: Current fiscal year

Reporting 1 to 16

periods:

Comparison Previous year

year:

Comparison 1 to 16

periods:

Listoutput: For example, ALV TreeControl

Continued on next page

285

第 306 页 / 共 337 页

Unit7: Reporting AC210

2. Optional:Ifyouwant,youcansaveyourselectiondataintheRFBILA00

mask as a report variant. Save it as variant VAR## with the meaning

(description) Variant forcompany code AA##.

3. StartRFBILA00againwiththesameparameters,butnowtryto(only)create

financial statementsforyoursegmentSEG##.

4. RemaininyoursegmentfinancialstatementforsegmentSEG##andwrite

downtheamountontheSparePartsaccount(404000)asanexample.

Note: Inoneofthenextexercises,youwillcheckwhetherthenew

FI drilldown report returnsthesameresult.

AmountonSparePartsaccount: ____________________________

5. Note: Thefollowingthreetaskstepsonlymakesenseifyouhavealready

conductedtheexercisetasksfromUnit6(ParallelAccounting).

Start RFBILA00 again with the same parameters, but without dynamic

selectionand for yournon-leadingledgerN#.

You should now only see the EUR 60 that result from the G/L account

posting(purchaseofofficesupplies)fromanexerciseinUnit6.

6. Why don’t you see the expense / revenue from the foreign currency

valuation?

7. SelectthefollowingvaluesintheselectionscreenforRFBILA00:

Chart of INT

accounts:

Companycode: AA##

Ledger: N#

Financial INT

statement

version:

Reportingyear: Current fiscal year

Reporting PreviousMonthtoPreviousMonth

periods:

Continued on next page

286

第 307 页 / 共 337 页

AC210 Lesson: Reporting

Caution: If the exchange rate is defined in January of a year,

choose“FromJanuarytoJanuary”forthereportingperiodsofthe

current year.

Comparison Previous year

year:

Comparison PreviousMonthtoPreviousMonth

periods:

Listoutput: For example, ALV TreeControl

Task 2:

ExercisesforEvaluatingDatafromNewGeneralLedgerAccounting–theNew

Standard Drilldowns

1. NowcallthefinancialstatementforyourcompanycodeAA##andledger

0L,withtheFIdrilldownFinancialStatement: Actual/ActualComparison.

YoucanstartthisreportfromtheSAPEasyAccessmenuorwithtransaction

code FGI0.

Hint: It is up to you whether you want to use the conventional

drilldown report or thegraphical output.

Ofcourse,tocomparethetwo,youcanalsotrybothoutputtypesin

successionandthendecidewhichoneyouprefer.

2. Optional: As you already know, you can use program variants to

considerablysimplifydataentryforthedrilldownreports...

3. Now try to create a segment financial statement from the displayed

companycodefinancialstatement(therefore,donotgobackandselect

again).

Display a financial statement for segment SEGA and then for segment

SEG##.

4. What is the amount in the spare parts account (404000) in the segment

financial statement for segmentSEG##?

AmountonSparePartsaccount: ____________________________

Continued on next page

287

第 308 页 / 共 337 页

Unit7: Reporting AC210

5. Doestheamountcorrespondwiththeamountfromthepreviousexercise?

6. Take alook at all of the other standard drilldowns supplied by SAP in

transaction FGI0 and for example, start the drilldown entitledSegment:

Plan/Actual/Varianceand/orthedrilldownwiththedescriptionPayables:

ProfitCenterforyourcompanycodeAA##andusethesuitablenavigation

stepstoobtaindetailedinformationonthedatasetof yourcompanycode

AA## and other FI characteristics.

Note: You can test which output type (graphicalor classic) you

prefer.

288

第 309 页 / 共 337 页

AC210 Lesson: Reporting

Solution 9: Data Evaluation in New

General Ledger Accounting

Task 1:

ExercisesforevaluatingdatainNewGeneralLedgerAccounting–the"classic":

program RFBILA00

1. Callthebalancesheet/profitandlossreportRFBILA00anddisplaythe

financialstatementsforyourcompanycodeAA##andledger0L.

Enterthefollowingdataontheselectionscreen:

Chart of INT

accounts:

Companycode: AA##

Ledger: 0L or leave blank

Financial INT

statement

version:

Reportingyear: Current fiscal year

Reporting 1 to 16

periods:

Comparison Previous year

year:

Comparison 1 to 16

periods:

Listoutput: For example, ALV TreeControl

a) SAP Easy Access menu: Accounting → Financial Accounting →

General Ledger → Information System →General Ledger Reports

(New)→FinancialStatement/CashFlow→General→Actual/Actual

Comparisons → Financial Statement

b) Enter the dataas specifiedin theexercise.

2. Optional:Ifyouwant,youcansaveyourselectiondataintheRFBILA00

mask as a report variant. Save it as variant VAR## with the meaning

(description) Variant forcompanycodeAA##.

a) Gofromthebalancesheetcalledinstep1backtotheselectionscreen

oftheprogramandchooseGoto→Variants→SaveasVariant…

b) Enterthemissingdataasspecifiedintheexercise.

Continued on next page

289

第 310 页 / 共 337 页

Unit7: Reporting AC210

3. StartRFBILA00againwiththesameparameters,butnowtryto(only)create

financial statementsforyoursegmentSEG##.

a) On the selection screen for program RFBILA00, choose Edit →

Dynamic Selections.

Additionalinputoptionsappear. Scrolldowntothebottomrightarea

ofthescreenthatappears. EnteryoursegmentSEG##intheSegment

field.

b) Start the report again.

4. RemaininyoursegmentfinancialstatementforsegmentSEG##andwrite

downtheamountontheSparePartsaccount(404000)asanexample.

Note: Inoneofthenextexercises,youwillcheckwhetherthenew

FI drilldown report returnsthesameresult.

AmountonSparePartsaccount: ____________________________

a) IfyoustartedthefinancialstatementwiththeALVtreecontrol, you

will have to expand the structure down to the Spare Parts account:

nodeProfitandlossstatement→Rawmaterialsandconsumables→

INT3051000→Expiredcostofrawmaterials→404000SpareParts

5. Note: Thefollowingthreetaskstepsonlymakesenseifyouhavealready

conductedtheexercisetasksfromUnit6(ParallelAccounting).

Start RFBILA00 again with the same parameters, but without dynamic

selectionand for yournon-leadingledgerN#.

Continued on next page

290

第 311 页 / 共 337 页

AC210 Lesson: Reporting

You should now only see the EUR 60 that result from the G/L account

posting(purchaseofofficesupplies)fromanexerciseinUnit6.

a) SAP Easy Access menu: Accounting → Financial Accounting →

General Ledger → Information System →General Ledger Reports

(New)→FinancialStatement/CashFlow→General→Actual/Actual

Comparisons → Financial Statement

b) Enterthefollowingdataontheselectionscreen:

Chart of INT

accounts:

Companycode: AA##

Ledger: N#

Financial INT

statement

version:

Reportingyear: Current fiscal year

Reporting 1 to 16

periods:

Comparison Previous year

year:

Comparison 1 to 16

periods:

Listoutput: For example, ALVTreeControl

6. Why don’t you see the expense / revenue from the foreign currency

valuation?

Answer: This is because your selection is for the whole year and the

foreign currency valuationiscancelledagain on thefirstofthefollowing

month. Therefore, thebalanceisEUR0 for theselectedreportingperiod

and is not displayed.

7. SelectthefollowingvaluesintheselectionscreenforRFBILA00:

Chart of INT

accounts:

Companycode: AA##

Ledger: N#

Continued on next page

291

第 312 页 / 共 337 页

Unit7: Reporting AC210

Financial INT

statement

version:

Reportingyear: Current fiscal year

Reporting PreviousMonthtoPreviousMonth

periods:

Caution: If the exchange rate is defined in January of a year,

choose“FromJanuarytoJanuary”forthereportingperiodsofthe

current year.

Comparison Previous year

year:

Comparison PreviousMonthtoPreviousMonth

periods:

Listoutput: For example, ALVTreeControl

a) SAP Easy Access menu: Accounting → Financial Accounting →

General Ledger →InformationSystem →General Ledger Reports

(New)→FinancialStatement/CashFlow→General→Actual/Actual

Comparisons → Financial Statement

b) Pleaseenter therequired data inaccordance with thedescription in

the exercise.

Continued on next page

292

第 313 页 / 共 337 页

AC210 Lesson: Reporting

Task 2:

ExercisesforEvaluatingDatafromNewGeneralLedgerAccounting–theNew

Standard Drilldowns

1. NowcallthefinancialstatementforyourcompanycodeAA##andledger

0L,withtheFIdrilldownFinancialStatement: Actual/ActualComparison.

YoucanstartthisreportfromtheSAPEasyAccessmenuorwithtransaction

code FGI0.

Hint: It is up to you whether you want to use the conventional

drilldown report or thegraphical output.

Ofcourse,tocomparethetwo,youcanalsotrybothoutputtypesin

successionandthendecidewhichoneyouprefer.

a) SAP Easy Access menu: Accounting → Financial Accounting →

General Ledger → Information System →General Ledger Reports

(New)→FinancialStatement/CashFlow→General→Actual/Actual

Comparisons→FinancialStatement: Actual/ActualComparison.

Enterthefollowingdataontheselectionscreen:

CurrencyType: 10 (company codecurrency)

Companycode: AA##

Ledger: 0L

FIS Annual INT

Rep.Struc:

ReportingYear: Current fiscal year

Reporting 1

Periodfrm:

Reporting 16

Period to:

Comparison Previous year

Year:

Comparison 1

Per. from:

Comparison 16

Period to:

Continued on next page

293

第 314 页 / 共 337 页

Unit7: Reporting AC210

2. Optional: As you already know, you can use program variants to

considerablysimplifydataentryforthedrilldownreports...

a) Ontheselectionscreenforthedrilldown,chooseGoto→Variants→

Save as Variant…

b) Enterashortdescriptionandnameofyourchoice.

3. Now try to create a segment financial statement from the displayed

companycodefinancialstatement(therefore, donot gobackandselect

again).

Display a financial statement for segment SEGA and then for segment

SEG##.

a) Solutionintheconventionaldrilldownreport:

SelectthecharacteristicFSItem/Account. YoucanchooseEntertoskip

the initial documentation for hotspots.

b) Then click the navigation characteristic Segment. The two

characteristicsFSItem/AccountandSegmenthavechangedplaces.

c) Click the hash mark next to row Segment A. The navigation

characteristicsarehighlighted inorange.

d) NowselectthenavigationcharacteristicFSItem/Account(again). The

resultisthesegmentfinancialstatementforSegmentA.

e) Youcanclickthemagnifyingglassnexttothenavigationcharacteristic

Segment to select the other segments.

4. What is the amount in the spare parts account (404000) in the segment

financial statement for segment SEG##?

AmountonSparePartsaccount: ____________________________

a) SAP Easy Access menu: Accounting → Financial Accounting →

General Ledger →InformationSystem →General Ledger Reports

(New)→FinancialStatement/CashFlow→General→Actual/Actual

Comparisons→FinancialStatement: Actual/ActualComparison

5. Doestheamountcorrespondwiththeamountfromthepreviousexercise?

Answer: Thismustbethecaseifyouhaveconductedallexercisestepsin

the manner specified.

6. Take alook at all of the other standard drilldowns supplied by SAP in

transaction FGI0 and for example, start the drilldown entitledSegment:

Plan/Actual/Varianceand/orthedrilldownwiththedescriptionPayables:

Continued on next page

294

第 315 页 / 共 337 页

AC210 Lesson: Reporting

ProfitCenterforyourcompanycodeAA##andusethesuitablenavigation

stepstoobtaindetailedinformationonthedataset of yourcompanycode

AA## and other FI characteristics.

Note: You can test which output type (graphicalor classic) you

prefer.

a) CalltransactionFGI0andexpandthefolder002(ReportingforTable

FAGLFLEXT),003(PayablesAccordingtoGeneralLedgerAccount

Assignments) and 004 (Receivables According to General Ledger

Account Assignments).

b) Now start the drilldown 0SAPBSPL-13 , (Segment:

Plan/Actual/Variance)foryourcompanycodeAA##,theledger0Land

thecurrentperiodandnavigatetothevaluesforyoursegmentSEG##.

Hint: Thereisnospecifictasktofulfillhere, simply“play”

with the drilldowns.

295

第 316 页 / 共 337 页

Unit7: Reporting AC210

Lesson Summary

You should now be able to:

• ... UsethevariousnewG/Ldrilldownreportsasthestandardanalysistool

in new General Ledger Accounting

• ... Use the program RFBILA00 for different ledgers and for new

characteristics

• ... Understand the concept of the origin object type and the associated

(new) functions

296

第 317 页 / 共 337 页

AC210 Unit Summary

Unit Summary

You should now be able to:

• ... UsethevariousnewG/Ldrilldownreportsasthestandardanalysistool

in new General Ledger Accounting

• ... Use the program RFBILA00 for different ledgers and for new

characteristics

• ... Understand the concept of the origin object type and the associated

(new) functions

297

第 318 页 / 共 337 页

UnitSummary AC210

298

第 319 页 / 共 337 页

第 320 页 / 共 337 页

第 321 页 / 共 337 页

Unit 8

Migration

Unit Overview

Unit Objectives

After completing thisunit, you will beableto:

• ... Consider the important factors before a migration to the new general

ledgerandmakeinformeddecisionsbasedonthem

• ... OutlinethecomponentsoftheSAPGeneralLedgerMigrationservice

• ... Differentiatebetweendifferentmigrationscenarios

• ... UnderstandthatSAPStandardCourseAC212(=>MigrationtoNew

General Ledger Accounting) is a must, if you want/have to familiarize

yourself with the subject of “Migration”

Unit Contents

Lesson: Migration...............................................................300

299

第 322 页 / 共 337 页

Unit8: Migration AC210

Lesson: Migration

Lesson Overview

• DistinctionbetweenthetermsLegacyDataTransferandMigration

• Important points to consider before you migrate data to the new general

ledger

• The phase model for migration

• The SAP General LedgerMigration service

• Standard migration scenarios

Lesson Objectives

After completingthislesson, you will beable to:

• ... Consider the important factors before a migration to the new general

ledgerandmakeinformeddecisionsbasedonthem

• ... OutlinethecomponentsoftheSAPGeneralLedgerMigrationservice

• ... Differentiatebetweendifferentmigrationscenarios

• ... UnderstandthatSAPStandardCourseAC212(=>MigrationtoNew

General Ledger Accounting) is a must, if you want/have to familiarize

yourself with the subject of “Migration”

Business Example

Anexisting SAP customerhasto keep workingwiththeclassicgeneral ledger

initiallyafterthetechnicalupgradetoSAPERP.Anexistingcustomerwantingto

takeadvantageofthefeaturesofthenewG/LfirsthastomigratetheclassicFI

data to new G/L accounting.

Wewillnowoutlinetheconditionsforsuchamigration...

300

第 323 页 / 共 337 页

AC210 Lesson: Migration

Figure 136: Legacy Data TransferVersus Migration

Inthecaseofbothamigrationandanewsystemimplementationwithsubsequent

legacydatatransfer,youhavetoinitiateaseparateprojectwiththecorresponding

project phases for the procedure.

Hint: This implementation project or new G/L project will have to

addressandresolvebothtechnicalandprocess-relatedaspects. Itisnot

just a table swap.

WithregardtothedefaultconfigurationofanSAPsystemandtheactivationof

the new G/L, read SAP Note 756146.

301

第 324 页 / 共 337 页

Unit8: Migration AC210

Figure 137: Migration is a Project

*Thetermprojectcontentstandsfortheprecisedescriptionoftheinitialsituation.

For example:

• WhichSAPcomponentsdoyoualreadyuse/haveyoubeenusingsofar?

• Areyourequiredtoportrayyouraccountingfiguresaccordingtomorethan

onesetofaccountingprinciples(usingparallelaccounting)?

• ....

• Whatdoesyourtargetconfigurationinnewgeneralledgeraccountinglook

like:

– WhichFIcharacteristicswouldyouliketouseinthenewG/L?

– Doyouwanttoproduceaprofitandlossstatementaccordingtocostof

salesaccounting or period accounting?

– ...

302

第 325 页 / 共 337 页

AC210 Lesson: Migration

Summary – Implementation of the New General Ledger for an existing

customer:

• The technical upgrade to ERP is a separate project that you first need to

finish.

• Thenextprojectisthenthe“implementationoftheNewGeneralLedger”.

Part of this project deals with the migration of data from classic general

ledger accounting .

• Theaimofamigrationprojectshouldnotbetosimultaneouslyimplementa

chartofaccountschangeoveroranyothersimilar,complexsystembehavior.

Thesewouldbeother, separateprojects. Formoreinformationabout this

topiccontactSAP atslo.consulting@sap.com.

Figure 138: Migration =Migration ofall CompanyCodes

303