AC660_EN_Col51_FV_Part_A4 (第11页)

第 378 页 / 共 429 页

Unit7: InformationSystem AC660

examplecharacteristics: organizationalunits,FSitem;keyfigures: valueingroup

currency). Inthedrilldownlist,youreceiveatwolinecolumnheader,wherethe

keyfiguresareinthefirstlineandunderneathit, eachselectedcharacteristicis

listed in the form. The values of the drilldown characteristics are in the lines.

In the detail list the characteristics, which are selected in the form, are in the

columns, whilethekey figures arelisted inthelines. Thedetail list shows the

results of a selected characteristic value.

Inaoneaxiswithkeyfigureform,youspecifythekeyfigureswhichyoucanlink

withtheselectedcharacteristics,inthelinesoftheform. Youcancreatefurther

keyfigureswithinaformwithaformula. Theninthereportdefinitionyouonly

select the drilldown characteristics.

Inthedualaxisformyoudefinethelinesaswellasthecolumns. Inthiswayyou

canincludethekeyfiguresinthelinesorthecolumnsoftheformasdesired. Then

inthereportdefinitionyouonlyselectthedrilldowncharacteristics.

• Global and local variables

Allvariablesaredefinedeitherasglobalorlocal

– A global variable:

– Begins with &

– Is valid for all reports or forms

– Isdefined centrally (in Customizing)

– Example: Dimension

– A local variable:

– Begins with $

– Isvalidfor onereport or oneformonly

– Isdefined in the report or the form

– Example: Assets

Variablesallowyoutodefineyourformsorreportsflexibly. Theyareparameters

in your report or form that you set when you define or execute your report.

Whetheryoucreateaglobalorlocalvariabledependsonhowoftenitwillbe

used.

If you want to create a variable that will be used only in one specific form or

report,youshouldcreatealocalvariable. Thiswillonlybevalidinthatformor

report. Ifyoudefinealocalvariableinaform,itwillbevalidineachreportthat

usesthatform. Ifyoudefinealocalvariableinthereportitself,itwillbevalid

only in that particular report.

370

第 379 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Ifyouwanttousevariablesfrequently,youshouldcreateglobalvariables. This

means that you can use them in all forms and reports. Global variables are

maintainedinCustomizing. Whenyouhavemaintainedthem,youcanuseglobal

variablesinaformorreportbyselectingthemusingthePossibleentriesfunction.

Note: Remember that if you change a variable, this will affect all the

reports and forms that use it.

1. Create form

• General selections

• Layout (incl. key figures, if applicable)

2. Define report

• Choose key figures, if applicable

• Choose characteristics for

navigation/restriction

• Restrict characteristicsor defineasvariables

• Predefine variables with values

• Definecharacteristicswithexternal hierarchies

for example: cons unit, FS item

3. Execute report

• Make adjustments as appropriate

(report header, number formats,

characteristicdisplay, formatdisplay, andsoon)

Report Execution

• Drilldown list

• Detail list

• Navigation

Detail list → Drilldown list

Drilldown list → Detail list

• Drilldown

– To analyze/explode totals

Detail list:

Itcontainsthekeyfiguresinrows,thelayoutcorrespondstothatoftheform.

Drilldown list:

371

第 380 页 / 共 429 页

Unit7: InformationSystem AC660

Itcontainsthepresentationthatcorrespondstotheselectedcharacteristics,such

asaconsolidatedbalancesheetwithbreakdownbyassetsandliabilities,andthe

owner’sequity. Thekeyfiguresarein thecolumns.

Inthedrilldownlistyoucancarryoutadrilldowntoanalyzeindividualvalues.

Forexample,youcanexpandtheassetitemstotheitemfixturesandfittings.

Afterthat,youcanselectadifferentpresentationforthisitembyselectinganother

characteristic for the drilldown list. For example, the presentation of the item

fixturesandfittingsforanindividualconsolidationgroup.

Youcannavigatebetweentheindividualdrilldownlists. Ineverydrilldownlist,

youcangotothecorrespondingdetaillist. Youcanalsogobacktotheoriginal

drilldownlistagain,thebasiclistwhichisdisplayedwhenyoucallupthereport.

Then, you can start a new drilldown.

Inthereportdefinition,yousetwhetheryoudisplaythedetaillistorthedrilldown

list when you call up the report.

Hierarchies

Figure 129: External Cons Group Hierarchies

Please note the following prerequisites with the report definition in SAP

Consolidation.

Reportswith an analysis by consolidation group

• Version must be unambiguousfor each cell

• If you do not execute any special accrual,

FYM = (Fiscal Year) Maximum and

PM=(Period16)Maximumarecalculatedforeachcell

• Theconsolidationgroupisbrokendownintoconsunitforeachcombination

of version, FYM, and PM.

Report without consolidation group

• Theconsunitsspecifiedintheselectioncriteriaareselected.

372

第 381 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Hierarchies serve to project the dataset in a certain hierarchical form. The

hierarchiescaneitherconsistoftheConsolidationorganizationalunitsorofitems

of a consolidation chart of accounts.

Inthisway,youcandesignthedrilldownreportinahierarchydisplayaccording

to your own evaluation aims.

Figure 130: Special Features of Drilldown Reporting

In SAP Consolidation, when you want to generate a report using one or more

consolidation groups, you always have to differentiate by the characteristics

dimension,consolidationgroup,version,yearandperiod. Whenyoudefineand

call up the report, you canpropose the required recurringaccrualsina display

hierarchy, as standard.

Forthepresentationofthevaluesofaconsgroup,youdefineaFSitemhierarchy.

It containsthe consolidation chart of accounts and a defined quantity of totals

item and value items.

Using hierarchies for consolidation groups and FS items, you make the

maintenance and execution of a report easier.

373

第 382 页 / 共 429 页

Unit7: InformationSystem AC660

In every hierarchy you define

• Thelayoutthehierarchydisplayshouldhave. Forexample,presentationof

a FSitem hierarchy withlinesand empty rows.

• Whether you want a top-down presentation or a bottom-up hierarchy of

your hierarchy.

• Howfarthehierarchyisexpandedwhenyoucallupthereportforthefirst

time.

For the forwarding of drilldown reports to EIS and the formatting of data by

meansofthegraphicuserinterfaceinSight(companyArcplan),youhavetocreate

hierarchynamesfor organizational unitsandFSitems.

Figure 131: Report Call: External Hierarchies

You can structure the Consolidation master data (characteristics FS items and

consgroups)usingtotalsitemsandtotalsconsolidationgroupsaccordingtoyour

ownhierarchyrequirements. Theconsolidationgroupsarecontainedinthetotals

consolidationgroupthroughwhichyouwanttoprojectthevaluesinthereport.

Thetotalsconsolidationgroupisautomaticallyformedfromthetop-consolidation

group.

TheConsolidationmasterdataisversion/yearandperiod-dependent. Theentered

accrualsmustbeidenticalwiththeparametersforwhichthetotalsconsolidation

groupisvalid. Thismeansthatwhenyouhaveenteredyourgroupstructureinthe

version100,youcannotselectthereportfortheversion200. Thesamerestrictions

also apply to the items.

374

第 383 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

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

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

375

第 384 页 / 共 429 页

Unit7: InformationSystem AC660

376

第 385 页 / 共 429 页

AC660 Lesson: Drilldown Reporting

Exercise 18: Drilldown Reporting

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.

2. Navigating in drilldown reports:

Continued on next page

377

第 386 页 / 共 429 页

Unit7: InformationSystem AC660

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

378

第 387 页 / 共 429 页

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

379

第 388 页 / 共 429 页

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?

380

第 389 页 / 共 429 页

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

381

第 390 页 / 共 429 页

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

382

第 391 页 / 共 429 页

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

383

第 392 页 / 共 429 页

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

384

第 393 页 / 共 429 页

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

385

第 394 页 / 共 429 页

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

386

第 395 页 / 共 429 页

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

387

第 396 页 / 共 429 页

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

388

第 397 页 / 共 429 页

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

389

第 398 页 / 共 429 页

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

390

第 399 页 / 共 429 页

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?

391

第 400 页 / 共 429 页

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

392

第 401 页 / 共 429 页

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

393

第 402 页 / 共 429 页

UnitSummary AC660

394

第 403 页 / 共 429 页

AC660 Test Your Knowledge

Test Your Knowledge

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.

395

第 404 页 / 共 429 页

TestYourKnowledge AC660

7. What are hierarchies?

396

第 405 页 / 共 429 页

AC660 Test Your Knowledge

Answers

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

397

第 406 页 / 共 429 页

TestYourKnowledge AC660

7. What are hierarchies?

Answer: Hierarchiesportraythedatasetinacertainhierarchicalformand

caneitherconsistoftheSAPConsolidationorganizationalunitsorofitems

of a consolidation chart of accounts.

398

第 407 页 / 共 429 页

Unit 8

Versions

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

399

第 408 页 / 共 429 页

Unit8: Versions AC660

Lesson: Version Concept

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

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.

400

第 409 页 / 共 429 页

AC660 Lesson: Version Concept

Application and Functionality

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

Youcan,forexample,usedifferentversionstomanage,consolidateandcompare

differentreportingdataforcomparisonsandsimulations.

You can open new versions at any time.

401

第 410 页 / 共 429 页

Unit8: Versions AC660

Add on Version

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.

Example of the use of add-on versions

• Version1consistsoftheconsolidatedstatementsaccordingtoUSGAAP.

• Version2consistsofadditionalfinancialdataand/ormanualorautomatic

postings.

Version2reflectsJapaneseGAAPinconjunctionwithversion1.

Drilldown Reporting and theReport Writer:

• Whenthereportingfunctionsuseanadd-onversion,thedataofallreferenced

versions are automatically used, as well.

ConsolidationfunctionsandtherestoftheInformationSystem:

• Alwaysworkwith thedataof “their” version.

• Havenorelationshiptothereferenceddataofotherversions.

402

第 411 页 / 共 429 页

AC660 Lesson: Version Concept

Special Version

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

403

第 412 页 / 共 429 页

Unit8: Versions AC660

Figure135: SpecialVersionsinSAPConsolidation(Procedure)

Controlparameters, whichareidentical invariousconsolidationversions, need

only be maintained oncein special versions.

All the special versions you requireto consolidate your data you assign to the

consolidation version in Customizing.

Figure136: SpecialVersions-ACurrencyTranslationExample

404

第 413 页 / 共 429 页

AC660 Lesson: Version Concept

Youcancarryoutsimulationstoanalyzethedifferenteffectsof:

• Different valuation options

• Exchange rates

• Restatements

• Different reporting data (actual/plan)

Usingtheversionconceptyoucan,forexample,combineyourversionsforactual

andplandatawithalternativecurrencytranslationmethods.

Restatement

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.

405

第 414 页 / 共 429 页

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.

406

第 415 页 / 共 429 页

AC660 Lesson: Version Concept

Lesson Summary

You should now be able to:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-onversionsandspecialversions

• Preparerestatementsthroughreportinganddrilldownreporting

407

第 416 页 / 共 429 页

UnitSummary AC660

Unit Summary

You should now be able to:

• Discusstheapplicationsandfunctionalityofversions

• Describeadd-on versionsandspecial versions

• Preparerestatementsthroughreportinganddrilldownreporting

408

第 417 页 / 共 429 页

AC660 Course Summary

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 as required

• Customizeandexecutevariousconsolidationfunctions

409

第 418 页 / 共 429 页

CourseSummary AC660

410

第 419 页 / 共 429 页

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.

411

第 420 页 / 共 429 页

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.

412