AC660_EN_Col51_FV_Inst_A4 (第15页)

第 480 页 / 共 529 页

Unit7: InformationSystem AC660

TheConsolidationmasterdataisversion/yearandperiod-dependent. Theentered

accrualsmustbeidenticalwiththeparametersforwhichthetotalsconsolidation

groupisvalid. Thismeansthatwhenyouhaveenteredyourgroupstructureinthe

version100,youcannotselectthereportfortheversion200. Thesamerestrictions

also apply to the items.

Item hierarchies can only be displayed for the characteristic item. You use

the characteristic consolidation group if you want to show the drilldowns of

consolidation groups in a hierarchy display.

Reporting Interface

Thereportinginterfaceallowsyoutocallotherreports,whichdonotnecessarily

havetoexistinSAPConsolidation,fromdrilldownreport. Thismeansyoucan

exitSAPConsolidationandcallreportsfromotherapplicationsfromwithinan

ECCS report.

• Inordertoreportonavarietyofcharacteristicsoronchangingcombinations

ofcharacteristics,youwouldhavetodefineacomplexreportthatyoumight

notbeabletostructureonlineduetothelargevolumeofdatainvolved.

• With the reporting interface, youcan link together individual reportsthat

eachusealimitednumberofcharacteristicsandenableflexibledataanalyses

online.

• Forexample, thereportinginterfaceallowsyouto

– Link reports that contain differentcharacteristics of an application.

Thisallowsyoutoreportonagreaternumberofcharacteristicsthan

wouldbepossiblewiththeindividualreports.

– Linkreportsthatwerecreatedindifferentapplicationclasses.

– Split reports

Reporting Interface: Drilldown to Drilldown

470

第 481 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Thisisanexampleoftwodrilldownreportsthatyoucanlinkwithoneanother.

• Youcanusethereportinginterfacetolinkseveral reportstogether. Todo

this, you definesender and receiver reports.

• Variables(eitherglobalorlocalvariables)areusedtopassontheinformation

from a sender report to a receiver report.

• Sequence:

– Define the receiver report with variables.

– Define and save the sender report.

– Assign the reports(assignthesender report to oneor more receiver

reports).

• Thevariablesusedinthereceiverreportaresuppliedwithdataautomatically

whenthereport isexecuted. If thereport cannotautomaticallysupply all

thevariables,adialogwindowappearspromptingyoutoenterthemissing

variables.

Becauseasenderreportcangeneratelargevolumesofdata,werecommendusing

areport thatis definedfor asummarization level.

Figure 132: Reporting Interface

Youcancall other reportsfromadrilldown report:

• Other drilldown reportsandother applications

• Report Writer reports

• Transactions (such as master data)

• Other ABAP reports

• ABAP queries

471

第 482 页 / 共 529 页

Unit7: InformationSystem AC660

472

第 483 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Exercise 18: Drilldown Reporting

377

Exercise Duration: 20 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• State the principles of drilldown reporting

• Describethe architectureof drilldownreporting

Business Example

Task 1:

Defining an ad report:

1. Definethead-hocreportRXY-00001calledAnalysis

(XY = 50 + your group number).

a)Thefollowingvariablesshouldbeavailablewhenthereportisstarted:

-View, totalsconsolidationgroup, versionandyear

Check andadjustthedefault valuesifnecessary.

b)Thevaluesshouldbedisplayedingroupcurrency(→keyfigure). .

c) Thereport shouldprovidea drilldownby the characteristicsFSitem,

consolidationunit,subitem,postinglevel,anddocumenttype.

d)Sortyourcharacteristicsintheordershownabove.

Hint: ThefunctionislocatedintheExtrasmenu.

e) Confine the ledger to the value “US”.

f) Select the entire consolidation chart of accounts as the hierarchy for

characteristic FS item.

g)Specifyyourtopconsolidationgroupasthehierarchyforcharacteristic

consolidation unit.

Hint: Thefunction islocated in the Extrasmenu; or you will be

prompted when you saveyour entries.

h) Save and execute the report.

Continued on next page

473

第 484 页 / 共 529 页

Unit7: InformationSystem AC660

2. Navigating in drilldown reports:

a)AnalyzetheitemProperty,Plant&Equipmentbyconsolidationunits

andthenbysubitems. WhatistheamountoftheincreaseinProperty,Plant

& Equipment for consolidation unit C?

b)WhatamountwaseliminatedfromtheitemCommonStockduringthe

consolidation of investments?

c)Showthecharacteristicswith/withoutname/ID.

d)DisplaytheconsolidationunitsandFSitemswith/withoutthehierarchy.

e) Select theitemAnnual NetIncomeand sorttheconsolidation unitsby

their proportiontothetotalconsolidationvalue.

Whichconsolidationunithasthesmallest value?

f) Change the scaling of value columns.

g) Finally, show and hide the display of the currency key in the column

heading.

Task 2:

Defining a form report:

You need a report called RXY-00002 Valuation Changes from Local to

Consolidated:

1. a)First,definetheformRXY-00002usingacoordinateandakeyfigure.

b)Choosethecharacteristicsledgeranddimensionandassigntothemthe

value “US” and/or assign a variable ($1).

c)Theformshouldcontainthefollowingcolumns(elements):

-reportedfinancialdata,standardization,payables,dividend,equity,total

d) For all elements select “Key figure with characteristics” in group

currency, andspecifytheappropriate headings.

e)Restrictthefirstcolumntothecharacteristicpostinglevel.

f)Restrictthenextfourcolumnstothecharacteristicdocumenttype(with

the values 10, 21, 23, and 51).

Note: You can copy the elements.

g)Thelastcolumnshoulddisplaytheconsolidatedtotalvalue. Hence,no

selection is required.

2. Now, define the report:

Continued on next page

474

第 485 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

a) Available characteristics are totals consolidation group, consolidation

group,consolidationunit,partnerunit,investeeunit,version,year,andFS

item.

b)Restrictthecharacteristicstotalsconsolidationgroup,version,andyearto

avariable(always$1)andthen,assignyourdefaultvaluestothevariables.

c)Definethehierarchyselectionforeachcharacteristicandsavethereport.

d) Assign journal entry reporting to the report using the report-report

interface. The application class is ECMC, the report type is RT (ABAP

report), andtheprogramname isFICJER00.

e) Start the report and analyze the items Investment (170100), Goodwill

(180000), IC Receivables (130100) and Retained earnings, current year

(251200).

f)ObservingtheitemICReceivables,familiarizeyourselfwiththedifference

betweendrilldownsbyconsolidationunitsanddrilldownsbyconsolidation

groups.

Task 3:

Defining a further form report:

1. Asinthelastexercise,definethereportRXY-00003PriorYearComparison,

whichusestheone-dimensionalformRXY-00003.

a) Values are displayed in group currency.

b)Theformcontainsthefollowinggeneralselections:

- Ledger (“US”) and dimension (variable$1)

c) The columns contain:

-currentyear,prioryear,absolutedifference,relativedifference

Hint: Specify$FYRforthecurrentyear,and$FYR-1fortheprior

year.

d)Thereportshouldcontainthefurthervariablestotalsconsolidationgroup

and version.

e)EnabledrilldownsbyconsolidationunitandFSitem.

f)AssigntheValuationChangesfromLocaltoConsolidatedtothereport

using the report-report interface.

g)WhatistheamountofICReceivablesfromconsolidationunitA?

Continued on next page

475

第 486 页 / 共 529 页

Unit7: InformationSystem AC660

h) Lookfor thisVALUEinthevaluationchangesreport, drilleddownby

partners.

Task 4:

1. Define the report RXY-00004Asset History Sheet, which uses the form

RXY-00004 with 2 coordinates.

a) The form uses the following variables:

- View, totalsconsolidationgroup, versionandyear

Specify the consolidation chart of accounts and your ledger under the

general selections.

Values are displayed in group currency.

b) The columns contain:

- Beginning balance (100, 200), acquisition (120, 220), retirement (140,

240),transfer(170,270)andendingbalance(asarowtotal).

c) The rows contain:

-Items191500,195500,separatorline,andtotalofbothrows

d) Choose the characteristic consolidation unit and appropriately fill the

variables.

e)WhatistheamountofthenetendingbalanceforconsolidationunitA?

476

第 487 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Solution 18: Drilldown Reporting

Task 1:

Defining an ad report:

1. Definethead-hocreportRXY-00001calledAnalysis

(XY = 50 + your group number).

a)Thefollowingvariablesshouldbeavailablewhenthereportisstarted:

-View, totalsconsolidationgroup, versionandyear

Check andadjustthedefault valuesifnecessary.

b)Thevaluesshouldbedisplayedingroupcurrency(→keyfigure). .

c) Thereport shouldprovidea drilldownby the characteristicsFSitem,

consolidationunit,subitem,postinglevel,anddocumenttype.

d)Sortyourcharacteristicsintheordershownabove.

Hint: ThefunctionislocatedintheExtrasmenu.

e) Confine the ledger to the value “US”.

f) Select the entire consolidation chart of accounts as the hierarchy for

characteristic FS item.

g)Specifyyourtopconsolidationgroupasthehierarchyforcharacteristic

consolidation unit.

Hint: Thefunction islocated in the Extrasmenu; or you will be

prompted when you saveyour entries.

h) Save and execute the report.

a) Defining an ad hoc report

Definethead-hocreportRXY-00001calledAnalysis

(XY = 50 + your group number).

SAPMenu→Tools→Customizing→IMG→ExecuteProject→

SAP Reference IMG → Enterprise Controlling→ Consolidation

→InformationSystem→DrilldownReports→DefineReports→

Create Drilldown Report

EnterreportnameanddescriptionandReporttypeBasic.

Select Create.

Continued on next page

477

第 488 页 / 共 529 页

Unit7: InformationSystem AC660

Select Variables tab:

a) The following variables should be available when the report is

started:

-Dimenson,totalsconsolidationgroup,versionandyear

Checkandadjustthedefaultvaluesifnecessary.

Dimension: XY

Totals CG: G1

Fiscal Year: Current Year

Cons Version: 100

Entryatexecution shouldbeselectedforall.

Select Key Figures tab:

b)Thevaluesshouldbedisplayedingroupcurrency(→keyfigure).

SelectGroupCurrencyandusetheleftarrowicontomoveit.

Select Characteristics tab:

c) Thereport shouldprovide adrilldown by the characteristicsFS

item,consolidationunit,subitem,postinglevel,anddocumenttype.

Selecttheseitemsandusetheleftarrowicontomovethem

d) Confinetheledgerto the value“US”.

e)Sortyourcharacteristicsintheordershownabove.

Hint: The function is located by pressing Sort Free

Characteristics icon at bottom.

f)Select theentireconsolidationchart of accountsasthe hierarchy

for characteristic FS item.

Clickinthehierarchycolumn. ChooseitemhierarchyandconsChart

of Accounts XY.

Specifyyourtopconsolidationgroupasthehierarchyforcharacteristic

consolidation unit.

Click in the hierarchy column.

Select consolidation group hierarchy and

Continued on next page

478

第 489 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Dimension: XY

Cons Group: G1

Cons Version: 100

Fiscal Year: Current Year

Period: 12

Hint: ThefunctionislocatedbypressingtheHierarchyiconat

bottom;oryouwillbepromptedwhenyousaveyourentries.

g) Save and execute the report.

2. Navigating in drilldown reports:

a)AnalyzetheitemProperty,Plant&Equipmentbyconsolidationunits

andthenbysubitems. WhatistheamountoftheincreaseinProperty,Plant

& Equipment for consolidation unit C?

b)WhatamountwaseliminatedfromtheitemCommonStockduringthe

consolidation of investments?

c)Showthecharacteristicswith/withoutname/ID.

d)DisplaytheconsolidationunitsandFSitemswith/withoutthehierarchy.

e) Select the itemAnnual Net Incomeand sorttheconsolidationunits by

theirproportiontothetotalconsolidationvalue.

Whichconsolidationunithasthesmallestvalue?

f) Change the scaling of value columns.

Continued on next page

479

第 490 页 / 共 529 页

Unit7: InformationSystem AC660

g) Finally, show and hide the display of the currency key in the column

heading.

a) Navigating in drilldown reports:

a)AnalyzetheitemProperty,Plant&Equipmentbyconsolidation

units and then by subitems.

Navigatewithin thehierarchy byclicking on the arrowheads. Drag

Propert,Plant&EquiptoConsUnitonthelefthandsideofthescreen.

Double click on subitem.

What isthe amount of the increase in Property, Plant & Equipment

for consolidation unit C?

DoubleclickontheProperty,Plant&Equipmentonthelefthandside

ofthescreenandthendouble-clickontheFSitemonthelefthandside

ofthescreeninordertoreturntotheoriginaldisplay.

b)WhatamountwaseliminatedfromtheitemCommonStockduring

the consolidation of investments?

Navigate to common stock and drag it to Posting Level on the left

hand side of the screen.

c)Showthecharacteristicswith/withoutname/ID.

MenuPath: Settings→CharacteristicDisplay

Select the options in turn

d) Display the consolidation units and FS items with/without the

hierarchy

SelectFSItemsandthenConsolidationUnits. Clickonthehierarchy

icon. Choosehierarchyselectionnohierarchy.

e)SelecttheitemAnnualNetIncomeandsorttheconsolidationunits

bytheirproportiontothetotalconsolidationvalue.

Whichconsolidationunithasthesmallestvalue?

Navigate to IS Retained Earnings. Drag to ConsUnit. Select Gcry

Column. ClickonABCicon. SelectTotalGCrcy. SelectTotallist.

f) Change the scaling of value columns.

Click on the number format icon.

Changethefactorto100anddecimalplacesto2.

Continued on next page

480

第 491 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Task 2:

Defining a form report:

You need a report called RXY-00002 Valuation Changes from Local to

Consolidated:

1. a)First,definetheformRXY-00002usingacoordinateandakeyfigure.

b)Choosethecharacteristicsledgeranddimensionandassigntothemthe

value “US” and/or assign avariable($1).

c)Theformshouldcontainthefollowingcolumns(elements):

-reportedfinancialdata,standardization,payables,dividend,equity,total

d) For all elements select “Key figure with characteristics” in group

currency, andspecifytheappropriateheadings.

e)Restrictthefirstcolumntothecharacteristicpostinglevel.

f)Restrictthenextfourcolumnstothecharacteristicdocumenttype(with

the values 10, 21, 23, and 51).

Note: You can copy the elements.

g)Thelastcolumnshoulddisplaytheconsolidatedtotalvalue. Hence, no

selection is required.

a) Defining a form report:

YouneedareportcalledRXY-00002ValuationChangesfromLocalto

Consolidated.

SAPMenu→Tools→Customizing→IMG→ExecuteProject→

SAP Reference IMG → Enterprise Controlling→ Consolidation

→Information System→Drilldown Reports→DefineForms→

Form for Creating Reports

a) First, definetheformRXY-00002usingacoordinateanda key

figure.

Create.

Edit→GenDataSelection→GenDataSelection

Choosethecharacteristicsledgeranddimensionandassigntothem

thevalue“US”and/orassignalocalvariable($1). Confirm.

Check and Confirm.

b)Theformshouldcontainthefollowingcolumn(element)texts:

-reportedfinancialdata, standardization,payables,dividend, equity,

total

Continued on next page

481

第 492 页 / 共 529 页

Unit7: InformationSystem AC660

c)Doubleclickeachelementandselectkeyfigurewithcharacteristics.

d)Restrictthefirstcolumntothecharacteristicpostinglevel.

Element1(Column 1)shouldhavepostinglevelwithvalues from 0

to 00.

Clickthetext icon. AddthetextReportedFinancialDataCheckand

confirm.

e) Restrict the next four columntothecharacteristicdocument type

(with the values 10, 21, 23, and 51).

Note: Youcancopytheelements. TextsareStandardization,

Payables, Dividend and Equity

f)Thelastcolumnshoulddisplaytheconsolidatedtotalvalue. Hence,

noselectionisrequired. Double-clicklastcolumnandselectformula.

The Formular should be:

Y001+Y002+Y003+Y004+Y005

Text is Total.

Save your form

2. Now, define the report:

a) Available characteristics are totals consolidation group, consolidation

group,consolidationunit,partnerunit,investeeunit,version,year,andFS

item.

b)Restrictthecharacteristicstotalsconsolidationgroup,version,andyearto

avariable(always$1)andthen,assignyourdefaultvaluestothevariables.

c)Definethehierarchyselectionforeachcharacteristicandsavethereport.

d) Assign journal entry reporting to the report using the report-report

interface. The application class is ECMC, the report type is RT (ABAP

report), and theprogramnameis FICJER00.

e) Start the report and analyze the items Investment (170100), Goodwill

(180000), IC Receivables (130100) and Retained earnings, current year

(251200).

f)ObservingtheitemICReceivables,familiarizeyourselfwiththedifference

betweendrilldownsbyconsolidationunitsanddrilldownsbyconsolidation

groups.

a) Now, define the report:

Continued on next page

482

第 493 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

SAPMenu→Tools→Customizing→IMG→ExecuteProject→

SAP Reference IMG → Enterprise Controlling→ Consolidation

→InformationSystem→DrilldownReports→DefineReports→

Create Drilldown Report

Enter Report name RXY-00002 and description Valuation changes

fromlocalgroup. SelectReportwithformandenterformjustcreated.

Press Create.

On Characteristics tab:

a) Available characteristics are totals consolidation group,

consolidation group, consolidation unit, partner unit, investee unit,

version, year, and FS item.

Selecttheitemsandusetheleftarrowicontomovethem

Restrictthecharacteristicstotalsconsolidationgroup,version,andyear

to a local variable (always $1) by clicking in the variables column

andentering$1inthepopupandthen,assignyourdefaultvaluesto

the variables.

Variables tab:

Fiscal Year = Current Year

ConsVersion = 100

Totals CG = G1

Dimension = XY

Press Hierarchy icon

b) Define the hierarchy selection for each characteristic and save

the report.

Clickonhierarchycolumnandselectasfollows:

Cons Unit: Hierarchy Cons Unit

Partner Unit: Hierarchy Partner Unit

FSItem: ItemHierarchyConsChartofAccountsXY

Cons Group: Cons Group Hierarchy

c)Assignjournalentryreportingtothereportusingthereport-report

interface. TheapplicationclassisECMC,thereporttypeisRT(ABAP

report),andtheprogramnameisFICJER00. SelectExtras→Report

assignment. Selectinsertrowicon,thenOtherreporttypeicon,enter

RT and then program name. Save.

Continued on next page

483

第 494 页 / 共 529 页

Unit7: InformationSystem AC660

Execute the report and analyze the items Investment (170100),

Goodwill(180000),ICReceivables(130100)andRetainedearnings,

current year (251200).

Observing the item IC Receivables, familiarize yourself with the

differencebetweendrilldownsbyconsolidationunitsanddrilldowns

by consolidation groups.

Task 3:

Defining a further form report:

1. Asinthelastexercise,definethereportRXY-00003PriorYearComparison,

whichusestheone-dimensionalformRXY-00003.

a) Values are displayed in group currency.

b)Theformcontainsthefollowinggeneralselections:

- Ledger (“US”) and dimension (variable$1)

c) The columns contain:

-currentyear,prioryear,absolutedifference,relativedifference

Hint: Specify$FYRforthecurrentyear,and$FYR-1fortheprior

year.

d)Thereportshouldcontainthefurthervariablestotalsconsolidationgroup

and version.

e)EnabledrilldownsbyconsolidationunitandFSitem.

f)AssigntheValuationChangesfromLocaltoConsolidatedtothereport

using the report-report interface.

g)WhatistheamountofICReceivablesfromconsolidationunitA?

h) Lookfor thisVALUEinthevaluationchangesreport, drilleddownby

partners.

a) Defining a further form report:

As in the last exercise, define the report RXY-00003 Prior Year

Comparison, which uses the one-axis with key figure form

RXY-00003.

Define Form:

Continued on next page

484

第 495 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

SAP Menu: Tools→Customizing → IMG→ Execute Project →

SAP Reference IMG → Enterprise Controlling→ Consolidation

→Information System→Drilldown Reports→DefineForms→

Form for Creating Reports

a) Values aredisplayed in group currency.

b)Theformcontainsthefollowinggeneralselections:

-Ledger (“US”) anddimension(variable$1)

Edit→GenDataSelection→GenDataSelection

Choosethecharacteristicsledgeranddimensionandassigntothemthe

valueUSand/orassignalocalvariable($1). Confirm.

Check and Confirm

c) The columns contain:

-currentyear,prioryear,absolutedifference,relativedifference

Doubleclickeachelementandselectkeyfigurewithcharacteristics.

Restrictthefirst columntothecharacteristicFiscalYear. Checkthe

variable box and enter variable $FYR

ClickinthetextboxandaddthetextCurrentYr. CheckandConfirm.

Restrict the second column to thecharacteristic Fiscal Year. Check

thevariableboxandenter$FYR-1. Clickinthetextboxandaddthe

text Prior Yr. Check and Confirm.

The last two columns are formulae.

DoubleclickElement3. Selectformula. TheformulashouldbeY001

– Y002. The text is Abs. Diff.

Double click Element 4. Select formula. The formula should be

Y003/Y002*100 with thetext % Diff.

Hint: Specify $FYR for the current year, and $FYR-1 for

the prior year.

Now define the report RXY-00003:

d)Thereportshouldcontainthefurthervariablestotalsconsolidation

group and version.

SAP Menu: Tools→Customizing → IMG→ Execute Project →

SAP Reference IMG → Enterprise Controlling→ Consolidation

→InformationSystem→DrilldownReports→DefineReports→

Create Drilldown Report

Continued on next page

485

第 496 页 / 共 529 页

Unit7: InformationSystem AC660

EnterreportnameRXY-00003anddescriptionPriorYearComparison.

SelectReportwithFormandentertheformjustcreated. Presscreate.

Availablecharacteristicsaretotalsconsolidationgroup,consolidation

group,consolidationunit,partnerunit,investeeunit,consversionand

FSitem.

SelecttheitemsandusetheleftarrowicontomovethemRestrictthe

characteristicstotalsconsolidationgroupandtoalocalvariable(always

$1)byclickinginthevariablescolumnandentering$1inthepopup.

andthen,assignyourdefaultvaluestothevariables.

Variables tab:

Fiscal Year = Current Year

Cons Version = 100

Totals CG = G1

Dimension = XY

e)EnabledrilldownsbyconsolidationunitandFSitem.

Clickonhierarchycolumn andselectasfollows:

Cons Group: No hierarchy

ConsUnit: Consolidation Group Hierarchy

Partner Unit: Hierarchy Partner Unit

FSItem: ItemHierarchyConsChartofAccountsXY

f) Assign the Valuation Changesfrom Local to Consolidatedto the

report using the report-report interface.

SelectExtras → Report assignment.

Selectinsertrowicon,thenOtherreporttypeicon,enterRE(Drilldown

reporting,ApplicationclassECMCandthenreportRXY-00002. Save.

Save the Report.

Execute the Report

g) What istheamount of ICReceivables from consolidation unit A

in the year 2002?

h) Lookfor this value inthevaluation changesreport, drilleddown

by partners.

Continued on next page

486

第 497 页 / 共 529 页

AC660 Lesson: Drilldown Reporting

Task 4:

1. Define the report RXY-00004Asset History Sheet, which uses the form

RXY-00004 with 2 coordinates.

a) The form uses the following variables:

-View, totalsconsolidationgroup, versionandyear

Specify the consolidation chart of accounts and your ledger under the

general selections.

Values are displayed in group currency.

b) The columns contain:

- Beginning balance (100, 200), acquisition (120, 220), retirement (140,

240),transfer(170,270)andendingbalance(asarowtotal).

c) The rows contain:

-Items191500,195500,separatorline,andtotalofbothrows

d) Choose the characteristic consolidation unit and appropriately fill the

variables.

e)WhatistheamountofthenetendingbalanceforconsolidationunitA?

a) DefinethereportRXY-00004AssetHistorySheet,whichusestheform

RXY-00004 with 2 coordinates.

Define the form RXY-00004:

a) Theformusesthefollowing variables:

-View,totalsconsolidationgroup,versionandyear

Specifytheconsolidationchartofaccountsandyourledgerunderthe

general selections.

b) Valuesaredisplayed ingroupcurrency.

c) The columns contain:

-Beginningbalance(100,200),acquisition(120,220),retirement(140,

240),transfer(170,270)andendingbalance(asarowtotal).

d) The rows contain:

-Items191500,195500,separatorline,andtotalofbothrows

Define the report RXY-00004:

Choose the characteristic consolidation unit and appropriately fill

the variables.

WhatistheamountofthenetendingbalanceforconsolidationunitA?

487

第 498 页 / 共 529 页

Unit7: InformationSystem AC660

Lesson Summary

You should now be able to:

• State the principlesof drilldown reporting

• Describethearchitectureof drilldownreporting

• Identify the types of drilldown reports

• Describehow report execution iscarried out

• Design drilldownreportsina hierarchydisplay

488

第 499 页 / 共 529 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Call upandevaluatereportsfromtheSAP system

• Usejournalentrylayoutsforjournalentryreporting

• State the principles of drilldown reporting

• Describethe architectureof drilldownreporting

• Identify the types of drilldown reports

• Describehowreport execution iscarried out

• Design drilldownreportsin ahierarchy display

489

第 500 页 / 共 529 页

UnitSummary AC660

490

第 501 页 / 共 529 页

AC660 Test Your Knowledge

Test Your Knowledge

395

1. What is thefunctionof Interactivedrilldowns?

2. Howcanyouspecifythestructureofthereportinthejournalentrylayout?

3. Whatdeterminestheclassificationofthedatasetindrilldownreporting?

4. Howcanyounavigatethroughthedatasetindrilldownreporting?

5. A basic report requires forms.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

6. Youcanspecifywhethertodisplaythedetaillistorthedrilldownlistwhen

youcallupthereportinthe definition.

Fillintheblankstocompletethesentence.

491

第 502 页 / 共 529 页

TestYourKnowledge AC660

7. What are hierarchies?

492

第 503 页 / 共 529 页

AC660 Test Your Knowledge

Answers

397

1. What is thefunctionof Interactivedrilldowns?

Answer: Interactivedrilldownsprovideinteractivenavigationwithin the

Consolidation data cube.

2. Howcanyouspecifythestructureofthereportinthejournalentrylayout?

Answer: You can specify the structure of the report in the journal entry

layout as follows:

• Determinethecharacteristicsofthereport,(suchasthedocumenttype,

financialstatementitem, andsubitem), accordingtohowthejournal

entriesshouldbeevaluated,andthesequenceinwhichtheyaretobe

listed.

• Enter the currencies or quantity that are to be listed in the value

columns of the report.

3. Whatdeterminestheclassificationofthedatasetindrilldownreporting?

Answer: Characteristicssuchasconsolidationunit,itemandpostinglevel

determinehowthedatasetisclassifiedindrilldownreporting.

4. Howcanyounavigatethroughthedatasetindrilldownreporting?

Answer: Drilldownreportingcontainsfunctionslikethenextstep,thenext

objectwithinastep,drilldownlistanddetaillistfornavigatingthroughthe

dataset. Inaddition,drilldownreportingalsocontainsanumberofinteractive

reporteditingfunctionslikesortingdata,rankinglistsordefiningconditions.

5. A basic report requires forms.

Answer: False

Abasicreportisdefinedspontaneouslyanddoesnotrequireaform.

6. Youcanspecifywhethertodisplaythedetaillistorthedrilldownlistwhen

you call up the report in thereport definition.

Answer: report

493

第 504 页 / 共 529 页

TestYourKnowledge AC660

7. What are hierarchies?

Answer: Hierarchiesportraythedatasetinacertainhierarchicalformand

caneitherconsistoftheSAPConsolidationorganizationalunitsorofitems

of a consolidation chart of accounts.

494

第 505 页 / 共 529 页

Unit 8

Versions

399

Thisunitisdiscussed at theendof the coursebecausethe specialversionscan

onlybesensiblyexplainedafteryouhavecoveredtheentryandconsolidationof

reportdata. Provideanoverviewofversionsasageneralmethodforalternative

consolidations. Explainhowversionscanbelinkedwithoneanotherandreused.

Examinehowseveralofthealternativeconsolidationscanalsobeprocessedin

reporting.

Unit Overview

The unit provides an overview of versions as a general method for alternative

consolidations. Youwilllearnhowversionscanbelinkedwithoneanotherand

reused. Further,youwilllearnthatseveralofthealternativeconsolidationscanbe

processed in reporting.

Unit Objectives

After completing thisunit, you will beableto:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-onversionsandspecialversions

• Preparerestatementsthroughreportinganddrilldownreporting

Unit Contents

Lesson: Version Concept......................................................496

495

第 506 页 / 共 529 页

Unit8: Versions AC660

Lesson: Version Concept

Lesson Duration: 40 Minutes

400

Lesson Overview

This lesson will give you an overview of versions as a general method for

alternative consolidations. It will also cover add-on versions and the special

versionsinSAPConsolidation. Youwilllearnhowtopreparerestatementsusing

versionsbyapplyingthecurrent “settings”tothedataofapreviousperiodand

using drilldown reporting.

Lesson Objectives

After completingthislesson, you will beable to:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-on versionsandspecial versions

• Preparerestatementsthroughreportinganddrilldownreporting

Explainthattheversionidentifiesaseparateareaintheconsolidationdatabase.

Bring out that add-on versions can contain additional report data and/or

manual/automaticpostings. PointoutthespecialversionsinSAPConsolidation.

Discusstheroleof versionsincreatingrestatements.

Business Example

ThegroupG1planstointroducetheSAPConsolidationbytheendofthisyear.

Youhavetoprojectdifferentdatasetsseparatelyfromoneanotherinyourbusiness

scenario. To do this, you need to define different versions that have the same

configurationcharacteristics. Usingtherestatementasanexample,demonstrate

other ways to project datasets differently.

Application and Functionality

Version Concept:

ApplicationsBecauseSAPConsolidationdataisanexcellentsourceforfurther

analyses, different data versions are made available to format and consolidate

thereport data by different criteriaor valuation premises (such assimulations,

restatements,orkeyfigurereports). Theversionidentifiesaseparateareainthe

consolidationdatabase. Versionsareusedtoperformalternativeconsolidations.

Reportdataisentered,consolidated,andreportedonintheconsolidationversion.

496

第 507 页 / 共 529 页

AC660 Lesson: Version Concept

Alternative group financial statements are modeled in different consolidation

versions. The version is not dependent on any data but the client. Many

configurations are dependent on the version.

Version Concept – Terms, Functionality:

Provide an overview of the versions and version concepts shown in the

demonstration.

• Data categories

– Actual,budget,forecast,multi-yearplanning,andsoon

• Simulation

– The effect of different exchange rates

– Theeffectofstepacquisitions,divestitures,andsoon

• Restatement

– Applyingthecurrent““settings”topriorperioddata

• Multiple GAAPs

– ParallelconsolidatedstatementsaccordingtoIASandHGB

• Value Based Management (VBM)

– Adjustmentstothe“regular”statementpriortocalculatingperformance

ratios

• Base version (or simply “version”)

– Disjointsubset oftheconsolidationdatabase

– Optionofcopyingall/partofdatabetweenversions

• Add-on version

– Referencesabaseversion(oranotheradd-onversion)

– Availableforthetotalsdatabaseandforhierarchies

• Special Version

– Foradditionalfinancialdata(forexample,investment,equitydata)

– Formethodassignments(forexample,consolidationofinvestments)

– Reduces redundancy

• Reporting

– Use of reporting (without a new version) for restatements, if no

group-dependent postings exist

Youcancarryoutconsolidationsindifferentconsolidationversions. Thisenables

you to carry out alternative consolidations, such as simulations, plannings,

restatements,andsoonparalleltotheconsolidationoftheactualdata.

497

第 508 页 / 共 529 页

Unit8: Versions AC660

Youcan,forexample,usedifferentversionstomanage,consolidateandcompare

differentreportingdataforcomparisonsandsimulations.

You can open new versions at any time.

Add on Version

Add-On Versions in the Totals Database:

Add-on versions can contain additional report data and/or manual/automatic

postings that arerequired for a specific country. They contain a reference toa

normal version. When combined with the normal version (US-GAAP in this

case),thisresultsinthecompleteversionforJapan. Therearedifferentoptionsfor

defining relationships between versions:

1. Referringtoaversion(thisallowsbothtobeobservedatthesametime)

2. Copying a version toperform a different calculation3. Not defining any

relationship,butinsteadcopyingthedataagain(forbudgeting,forexample)

Figure 133: Add-On Versions in the Totals Database

Add-onversionscancontainadditionalreportingdataand/ormanual/automatic

postingsrequiredforaspecificcountry. Theyincludeareferencetoabaseversion.

498

第 509 页 / 共 529 页

AC660 Lesson: Version Concept

Example of the use of add-on versions

• Version1consistsoftheconsolidatedstatementsaccordingtoUSGAAP.

• Version2consistsofadditionalfinancialdataand/ormanualorautomatic

postings.

Version2reflectsJapaneseGAAPinconjunctionwithversion1.

Drilldown Reporting and the Report Writer:

• Whenthereportingfunctionsuseanadd-onversion,thedataofallreferenced

versions are automatically used, as well.

ConsolidationfunctionsandtherestoftheInformationSystem:

• Always workwiththedataof “their” version.

• Havenorelationshiptothereferenceddataofotherversions.

Special Version

Special Versions in SAP Consolidation:

Makesuretopointoutthespecialversionsindetail. Theywerementionedatthe

start of the course(such as the ledger version).

Thetotalsdataismanagedintheconsolidationversion. Eachconsolidationtaskis

configuredseparately. Thisinformationismanagedinthespecialversionstogether

withthemasterdataandanyadditionalfinancialdata. Specialversionsexistfor·

Consolidation tasks (data recording, translation, reclassification) · Additional

financialdataforconsolidationofinvestments·Masterdata(consolidationgroup

hierarchies and ledger assignments)

This breakdown means that control data that is identical in the different

consolidationversionsonlyhastobemaintainedonceinthespecialversions,and

canthenbeassignedtoalltheconsolidationversions.

SpecialVersionsinSAP Consolidation(Procedure):

When you start a consolidation task in a version, the system reads the special

versions(andtheircustomizingdata)assignedtotheversion,aswellasanymaster

dataoradditionalfinancialdatasavedinthespecialversions.

SpecialVersions–ACurrencyTranslationExample:

499

第 510 页 / 共 529 页

Unit8: Versions AC660

The example shows three versions:

1. Thereporteddataisactualdata(suchasrevenues100)andistranslatedinto

thegroupcurrency(GC)ataUSDexchangerateof1.5.

2. Thespecialversionisassignedtoadifferentexchangerate(1.8).

3. Version3containsplandata(revenues150), whichhasbeentranslatedat

the plan exchange rate (1.8) – 270.

Figure 134: Special Versions in SAP Consolidation

Aconsolidationversioniscomposedofspecialversions. Thesecoverthedifferent

consolidation areas.

Forexample, therearethespecialversions“dataentry”,“taxrate”,“translation

methods”. Thisenablesyoutodefinevariousconsolidationversionsthatdiffer

onlyinoneorafewareas,butotherwiserefertothesamespecialversion(thatis,

data is not redundant).

500

第 511 页 / 共 529 页

AC660 Lesson: Version Concept

Figure135: SpecialVersionsinSAPConsolidation(Procedure)

Controlparameters, whichareidenticalinvariousconsolidationversions, need

only be maintained once in special versions.

All the special versions you require to consolidate your datayou assign to the

consolidation version in Customizing.

Figure136: SpecialVersions-ACurrencyTranslationExample

501

第 512 页 / 共 529 页

Unit8: Versions AC660

Youcancarryoutsimulationstoanalyzethedifferenteffectsof:

• Different valuation options

• Exchange rates

• Restatements

• Different reporting data (actual/plan)

Usingtheversionconceptyoucan,forexample,combineyourversionsforactual

andplandatawithalternativecurrencytranslationmethods.

Restatement

Restatement via Reporting:

Versions allow you to create restatements, which means applying current

“settings” to the data from a previous period. For example, if you change the

consolidationgrouphierarchy,youcanreportonthedatafromthepreviousfiscal

year in the new hierarchy as a restatement.

Thefollowingexampleinvolvesdatafrom1997and1998.Ontherighthandside,

you see the reclassification of BA3 into SEG1, which did not take place until

1998. Therefore,thereportcontainsthevalue0forSEG2/BA3. Thereportwith

restatementtransformsthedatafromthepreviousfiscalyeartothenewhierarchy

and reports on it.

Rememberthatsuchrestatementscanbeimplementedwiththereportingfunctions

in simplecases, without havingtouseanewversion.

Restatement via Drilldown Reporting:

You can implement restatement via drilldown reporting if the report does not

containany consolidationgroup-specificpostings.

The BA3 values from1997 and 1998 are added in an invisible column. In the

process, BA3isassignedtothehierarchyofthecurrent(later)year. Therefore,

BA3appearsinthecurrenthierarchy,andthe1997column(differencebetween

thetotalandthevaluefrom1998)containsthevaluefrom1997.

502

第 513 页 / 共 529 页

AC660 Lesson: Version Concept

Figure 137: Restatement via Reporting

Usingversionsyoucanpreparerestatements,thatis,applythecurrent“settings”

to data of a previous period.

Forexample,ifyouchangedtheconsolidationhierarchy,youcouldreportthedata

ofthepreviousfiscalyearinthenewhierarchyasarestatement.

Inthisexampleyou seedatafrom2001 and 2002

Ontheright-handsideyouseethatBA3hasbeenregroupedtoSEG1,although

thisdidnotoccuruntil2002. Thereportthereforecontainsvalue0forSEG2/BA3.

Ontheright-handsideofthereportthedatafromthepreviousfiscalyearhasbeen

included in the newhierarchy andalso reported.

In simple cases, you can perform such restatements using the functions of

reporting without using a new version.

503

第 514 页 / 共 529 页

Unit8: Versions AC660

Figure 138: Restatement via Drilldown Reporting

You couldeffecttherestatementusingadrilldownreport ifthereportdoesnot

includepostingsthataredependentontheconsolidationgroup.

InacolumnthatisnotdisplayedthevaluesofBA3from2001and2002areadded

togetherandBA3isassignedtothehierarchyofthecurrent(mostrecent)year.

BA3 therefore appears in the current hierarchy, the 2001 column (difference

betweenthetoalandthevaluefrom2002)containsthevaluefrom2001.

504

第 515 页 / 共 529 页

AC660 Lesson: Version Concept

Facilitated Discussion

Discussion Questions

Usethefollowingquestionstoengagetheparticipantsinthediscussion.Feelfree

to use your own additional questions.

Discusstheapplicationsofversionconceptinfinancialdatareporting.

505

第 516 页 / 共 529 页

Unit8: Versions AC660

Lesson Summary

You should now be able to:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-on versionsandspecial versions

• Preparerestatementsthroughreportinganddrilldownreporting

506

第 517 页 / 共 529 页

AC660 Unit Summary

Unit Summary

You should now be able to:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-onversionsandspecialversions

• Preparerestatementsthroughreportinganddrilldownreporting

507

第 518 页 / 共 529 页

CourseSummary AC660

Course Summary

You should now be able to:

• Define consolidation groups and units

• Createanduseaconsolidationchartof accounts

• Collect individual financial statement data in SAP Consolidation and

translate it into group currency asrequired

• Customizeandexecutevariousconsolidationfunctions

508

第 519 页 / 共 529 页

Appendix 1

Appendix

Consolidation of Investments: Mutual Stock Method

Figure 139: Mutual Stock Method: FirstConsolidation

The mutual stock method may only be used for managerial consolidations -

internalpurposes. Itisanalternativetotheequitymethodwhenthegroupshareis

lessthan50%. Thus, ’G2’ maynotbealegalentity.

This accounting technique is typically applied when a consolidation unit is

included intheupper hierarchy level using thepurchase method, andthesame

unitalsobelongstoanotherconsolidationgroupinalowerhierarchylevel,where

theunitisincludedusingthemutual stock method.

Thereportingoffinancialdataissimilartotheequitymethod,thatis,thefinancial

data is not included.

509

第 520 页 / 共 529 页

Appendix1: Appendix AC660

Theadjustingentrycomplementsthatofthepurchasemethodatthesamehierarchy

level. Hence,nofurtherentryisneededinthetopconsolidationgroup’GT’.

Figure140: MutualStockMethod: SubsequentConsolidation

Figure 141: Mutual Stock versus Equity Method

Oneadvantageofthemutualstockmethodisthatitshowstheannualnetincome

attheaffiliate,whereasintheequitymethod,theannualnetincomebecomespart

of the parent’s earnings from the affiliate.

One disadvantage of the mutual stock method is its obstinate logic in posting

minorityinterest. However, minorityinterestusuallyplaysaninsignificantrole

in managerial consolidation.

510