AC410_EN_Col52_FV_Part_A4 (第10页)

第 339 页 / 共 403 页

AC410 Lesson: Planning Process

2. Execute the periodic reposting as an Update Run so that the results are

actually posted.

a) Returntotheinitialscreenforplanperiodrepostings.

Deselect Test Run.

Period. Repostings → Execute

Task 9: Optional

Check the results of the automatic plan.

1. Callthecostcenters: Actual/PlanVariancereportforthecurrentperiod,

planversion0,andconsultingcostcentergroupB##.

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

Plan/ActualComparison→Costcenters: Actual/Plan/Variance

FieldNameorDataClass Values

Controlling Area 1000

Fiscal Year current

From period 1

To period 12

Version 0

Cost Center Group B##

Program → Execute

2. Usethevariationfunctiontocheckthecostcenterplanningforcostcenter

101##(Telephone)andforoneofthereceivercostcenters.

Answer: Click ontheNavigationon/officon

Go to the Variation: Cost centerwindow.

Double-clickonacostcentertocallupthecorrespondingreportandcheck

the results of the automatic planning.

Continued on next page

331

FieldNameorDataClass	Values
Controlling Area	1000
Fiscal Year	current
From period	1
To period	12
Version	0
Cost Center Group	B##

第 340 页 / 共 403 页

Unit5: Planning AC410

Task 10:

Createanassessmentcyclewithwhichtoallocatethecostsofthe“Organization”,

“IT Services”, and “Motor Pool” cost centers.

1. CreateaplancyclePA##fortheplanassessmentoftheabove-mentioned

costcenters. UsetheactualassessmentcycleASSE## asasourcetocopy

from. Startthecycleonthefirstdayofthecurrentfiscalyear.

a) CCA:Planning→Allocations→Assessment→Extras→Cycle→

Create

FieldNameorDataClass Values

Cycle PASSE##

Start date 01/01Current fiscalyear

Template

Cycle ASSE##

Enter

2. Displaythesegmentsinthesegmentoverviewscreen.

a) Goto → Overview Segments

3. Becausethe“ITServices”and“MotorPool”costcentersusethePortionsof

actualstatisticalkeyfiguresoptionasabasisforallocationincycleA##and

thisfigureisvariable,youneedtochangethesettingsintheplanassessment

cycle. In segment IT Service##, change the field variable portions type

on planned statistical key figures.

a) Select the IT-SERV## segment.

Click on the Choose icon.

Changetheentry inthe Variableportionsonplannedstatisticalkey

figures.

VariabletypePortions Statist. Planned statistical key

figures.

Save your data!

Confirm the pop-upcustomizing order.

4. Change the field variable portion type on planned statistical key figures

in segmentMOTO##(if youdidtheoptionalexecisetocreateaclearing

template, use segment MOTO##new.

Continued on next page

332

FieldNameorDataClass	Values
Cycle	PASSE##
Start date	01/01Current fiscalyear
Template
Cycle	ASSE##

第 341 页 / 共 403 页

AC410 Lesson: Planning Process

Save your data.

a) Goto → Segments Overview

SelecttheVEHIC##orVEHIC##NEWsegment.

Click on the Choose icon.

Changetheentry intheVariableportionsonplanned statistical key

figures.

VariabletypePortions Statist. Planned statistical key

figures.

Save your data!

Task 11: Optional

Execute your plan assessment.

1. RuntheplanassessmentintheTestrunforyourcycle(PA##)forperiods1

through12ofthecurrentfiscalyear. ChooseDetailList.

a) Goto → Back

FieldNameorDataClass Values

Period 1 to 12

Fiscal Year current

Select test run and Detail lists.

Cycle PASSE##

Assessment → Execute

2. NowruntheassessmentasanUpdateRunsothattheallocationsareactually

posted.

a) Returntotheinitialscreenforplanassessment.

Deselect Test run.

Assessment ? Execute

Continued on next page

333

FieldNameorDataClass	Values
Period	1 to 12
Fiscal Year	current

第 342 页 / 共 403 页

Unit5: Planning AC410

Task 12: Optional

Check the results of the automatic planning.

1. Call thereportcost centers: Actual/Plan Variance report for the current

period,planversion0,andconsultingcostcentergroupB##.

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

Plan/ActualComparison→Costcenters: Actual/Plan/Variance

FieldNameorDataClass Values

Controlling Area 1000

Fiscal Year current

From period current

To period Today's date

Version 0

Cost Center Group B##

Program → Execute

2. Checkwhethercostcenters201##(Organization),202##(ITServices),and

203## (Motor Pool) havebeen credited infull.

a) Click on the Navigation On/Off icon

Goto theVariation: Costcenterwindow.

Double-clickoneachcostcenterintheconsultingcostcentergroupto

callupthecorrespondingreport,andcheckthecredits.

Allcostcentersarecompletelycreditedbytheplanassessment.

3. Whataretheactualbalances(over-absorptionor under-absorption) of the

consulting cost centers?

301##(ConsultantFI/CO) -138,084,75

302## (Consultant LO) -117,915,25

Whatconclusionscanbedrawnfromtheresultswithregardtotheactivity

type price?

Answer: The plan prices that were set manually have been set too high

in relation totheactualcosts. Thismeansthatthecost centershavebeen

over-credited.

Continued on next page

334

FieldNameorDataClass	Values
Controlling Area	1000
Fiscal Year	current
From period	current
To period	Today's date
Version	0
Cost Center Group	B##

第 343 页 / 共 403 页

AC410 Lesson: Planning Process

4. The actual credits to both consulting cost centersarelower than the plan

credits.

What is the reason for this?

Answer: Theactualactivityofthejuniorconsultantis200hourslessthan

planned.

5. The actual costs for cost center 301## (FI/CO Consulting) are lower

than the plan costs, whereas the actual costs for cost center 302## (LO

Consulting) are greater than the plan costs.

Analyzethereasonsfor thisforboth costcenters.

301## (FI/CO Consulting)

302## (LO Consulting)

Answer: Normally,thecauseofanactual/planvarianceisalowerorhigher

debit of actual costs than originally planned.

Costcenter301##actualcosts(debits)werelowerthanplannedduemainly

to salary, training, and vehicles costs.

Costcenter302##wasalsoduemainlytosalary,training,andvehiclescosts,

as well as use of IT services.

335

第 344 页 / 共 403 页

Unit5: Planning AC410

Lesson Summary

You should now be able to:

• Execute a manual planning process.

• Listtheoptionsavailableunderautomaticplanning

• Describe final planning activities

336

第 345 页 / 共 403 页

AC410 Lesson: Planning Aids

Lesson: Planning Aids

Lesson Overview

Youcanuseseveralplaningaidstospeeduptheentryofplandata.

Lesson Objectives

After completingthislesson, youwillbeable to:

• ExplaintheplanningaidsprovidedbytheSAPsystem

Business Example

Youwishtouseseveralplanningaidstosimplifyandspeeduptheentryofplan

data.

Copy Plan Data or Actual Data to Plan

Figure 110: Copy Plan Data or Actual Data to Plan

Tospeedupplanningdataentry,youcanobtaintheplanvaluesbycopyingplan

or actual data.

If you want to reuse large parts of your manual planning from the previous

yearforyourcurrentfiscalyear,ortotransferplanvalueswithinafiscalyearto

adifferent period, or togeneratealternateversions, you canusethetoolCopy

planning.

337

第 346 页 / 共 403 页

Unit5: Planning AC410

Byusing the Copyplanningfunction, you canselect areferenceversion anda

targetversiontocopyvaluesfromoneversiontoanother.

You can copy:

• Within fiscal years, versions, and cost centers

• Betweendifferentfiscalyears, periods,andversions

To assist your manual planning, you can select and copy posted actual data

from cost centers. You can only use this funtion to copy transactionsthat you

can plan manually.

Selectioncriteriafor(actual)dataare: Costcenters(allcostcenters,costcenter

group,orindividual),fiscalyear,andfrom/toperiods. Youcanalsospecifywhich

actual data is to be copied.

Itispossibletoselectanyvaluegroupsinthecopyfunction. Forexample, you

canrestricttheselectiontothedataofacertaincostcenter,oruseallofthedata.

Youmayalsoexplicitlydefinethetransactionswhichyouwishtocopy.

Revaluation

Figure 111: Revaluation

338

第 347 页 / 共 403 页

AC410 Lesson: Planning Aids

Using the plan revaluation function, you can increase or decrease planning

data on a percentage basis. This means you can combine the Copy Planning

andRevaluationfunctionstocreateseveraldifferentplanversions. Thismaybe

usefulifyouhavecopiedtheplandatafromthepreviousyearorifyouwantto

draftscenariosfor differentcaseswithinafiscal year.

Youcanrevaluatecostsandconsumption. Youcanrevaluateallcostelements

used in the primary cost element and revenue planning. You cannot revaluate

assessment cost elements, imputed cost elements, and cost elements used in

indirect activity allocation.

You can execute as many revaluations of cost center or cost element plans as

required.

Planlineitems areenteredwhenrevaluationisexecuted.

Thepercentagesusedduringrevaluationcanbechangedasoftenasyouwant. If

yourepeatarevaluationusingmodifiedpercentages,theoldplanlineitemsare

deleted. Therevaluationalwaysusestheoriginalinitialvalue.

Ifyoudore-runarevaluationbutyoudonotwanttooverwritetheexistingresults,

you must define a new revaluation

Transferring Plan Values

Figure 112: Transferring Plan Values

Integrated planning enables you to transfer data from one of the pre-stored

systemsinCostCenterAccountingtocostcenterplanning.

If thisdata wasplannedin thepre-stored systems, and istransferred tocost

center planning, thenthecorrespondingdatainCost Center Accountingcanbe

removed.

339

第 348 页 / 共 403 页

Unit5: Planning AC410

To use integrated planning, certain requirements need to be fulfilled in Cost

Center Accounting and in the pre-stored systems. Therefore, before you can

transferplannedpersonnelcostsfromHRtoprimarycostplanninginCostCenter

Accounting,forexample,CostCenterAccountingmustcontainvalidcostcenters

thatareassignedtothecorrespondingmasterdataforpersonnel.

340

第 349 页 / 共 403 页

AC410 Lesson: Planning Aids

Exercise 19: Planning Aids

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Enterplandataforthenextfiscalyearusingthecopyfunction.

• Revaluatethecopiedplandatatobringitinlinewithprojectedcosts.

Business Example

Youwanttoenterplanningdataforthecomingfiscalyearmoreeasilyandquickly.

Youdecidetocopyyourpreviousplanningdatabecauseithasprovedsoreliable.

The newsalary scale takeseffect from Januaryof thecomingyear, entailinga

2% increase in personnel costs. You thereforeneed toadjust your salary costs

for the new year.

Task 1:

Copytheplanningdataofallconsultingcostcenterstothenextfiscalyear.

1. All plan data of cost center group B## of periods1 to 12 in the current

fiscal yeariscopied tothecorrespondingperiodsof thefollowing fiscal

yearinversion0. Shouldplandataalreadyexistfortheseperiods,itshall

notbeoverwritten. RunthecopyfunctionsasaTestRunwithDetailsLists.

2. What type of planning data was copied?

3. LeavethelistanddisplaytheNotes(underExtras)onthecopyfunction. Can

youalsocopyplanningdatafromperiodicrepostingsorassessments?

4. Nowrunthecopyfunctionasan UpdateRun.

Continued on next page

341

第 350 页 / 共 403 页

Unit5: Planning AC410

Task 2:

Solve the following task:

1. Checkwhetherthevalueshavebeenpostedtothecostcenters. Callthecost

centers: Planningoverviewforcostcenter“ConsultantFI/CO”(301#)forthe

next fiscal year andperiods1to12inversion0.

Task 3:

Usetherevaluationfunctiontoadjustyourcopiedplanningdatatoanyprojected

changes.

1. CreatearevaluationcalledSalary##. Thisisvalidforthenextfiscalyear

in version 0.

2. Enter Salary Increases of 2% as a short text. The increase affects cost

element430000andappliestoallconsultingcostcenters(B##).

3. Defineacostincreaseof2%. Savetherevaluation.

4. CarryouttherevaluationSalary##forallperiodsofthenextfiscalyearin

version 0. Chose Test run.

5. Next, execute your revaluationasanUpdateRunsothat your revaluated

planning data is posted.

Task 4:

Check the results of the revaluation.

1. Call the cost centers: planning overview report for a cost center of your

choiceforthenextfiscalyearinversion0. (Notcostcenter“Telephone”,as

it does not carry salary costs.)

2. Displaythelineitemsforsalarycosts(costelement430000).

342

第 351 页 / 共 403 页

AC410 Lesson: Planning Aids

Solution 19: Planning Aids

Task 1:

Copytheplanningdataofallconsultingcostcenterstothenextfiscalyear.

1. All plan data of cost center group B## of periods1 to 12 in the current

fiscal yeariscopied tothecorrespondingperiodsof thefollowing fiscal

yearinversion0. Shouldplandataalreadyexistfortheseperiods,itshall

notbeoverwritten. RunthecopyfunctionsasaTestRunwithDetailsLists.

a) CCA:Planning→PlanningAids→Copy→PlantoPlan

FieldNameorDataClass Values

Cost Center Group B##

Template

Version 0

Period 1 to 12

Fiscal Year Current

Target

Version 0

Period 1 to 12

Fiscal Year Next year

Existingplanningdata Do not change

Select Test run and Detail list.

Copy → Execute

2. What type of planning data was copied?

Answer: Primarycosts,activities,statisticalkeyfigures

3. LeavethelistanddisplaytheNotes(underExtras)onthecopyfunction. Can

youalsocopyplanningdatafromperiodicrepostingsorassessments?

Answer: On the Copy Planning:

Extras → Note

Youcancopyonlythosebusinesstransactionsthatcanbeplannedmanually.

Continued on next page

343

FieldNameorDataClass	Values
Cost Center Group	B##
Template
Version	0
Period	1 to 12
Fiscal Year	Current
Target
Version	0
Period	1 to 12
Fiscal Year	Next year
Existingplanningdata	Do not change

第 352 页 / 共 403 页

Unit5: Planning AC410

4. Nowrun thecopyfunctionas an UpdateRun.

a) Deselect Test run.

Copy → Execute

Task 2:

Solve the following task:

1. Checkwhetherthevalueshavebeenpostedtothecostcenters. Callthecost

centers: Planningoverviewforcostcenter“ConsultantFI/CO”(301#)forthe

next fiscal year andperiods1to12inversion0.

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

PlanningReport→Costcenters: PlanningOverview

FieldNameorDataClass Values

Cost Center 301##

Fiscal Year Next year

Period 1 to 12

Version 0

Planning Overview → Execute

Task 3:

Usetherevaluationfunctiontoadjustyourcopiedplanningdatatoanyprojected

changes.

1. CreatearevaluationcalledSalary##. Thisisvalidforthenextfiscalyear

in version 0.

a) CCA: Planning → Planning Aids →Revaluate →Costs → Extras

→ Revaluation → Create

FieldNameorDataClass Values

Revaluation Salary##

Fiscal Year Next year

Version 0

Enter

Continued on next page

344

FieldNameorDataClass	Values
Cost Center	301##
Fiscal Year	Next year
Period	1 to 12
Version	0

FieldNameorDataClass	Values
Revaluation	Salary##
Fiscal Year	Next year
Version	0

第 353 页 / 共 403 页

AC410 Lesson: Planning Aids

2. Enter Salary Increases of 2% as a short text. The increase affects cost

element430000andappliestoallconsultingcostcenters(B##).

Text 2% salary increase

Cost CenterGroup B##

Cost element 430000

3. Defineacostincreaseof2%. Savetherevaluation.

a) Goto → Definition

FieldNameorDataClass Values

From 1

To 12

Costs 2

Save your data.

4. CarryouttherevaluationSalary##forallperiodsofthenextfiscalyearin

version 0. Chose Test run.

a) On thePlan Revaluation: Initial Screen.

FieldNameorDataClass Values

Version 0

Period 1 to 12

Fiscal Year Next year

Select Test Run and Detail Lists.

Revaluation Salary##

Revaluation → Execute

5. Next, execute your revaluation asanUpdateRunsothat your revaluated

planning data is posted.

a) Deselect Test run.

Revaluation → Execute

Continued on next page

345

Text	2% salary increase
Cost CenterGroup	B##
Cost element	430000

FieldNameorDataClass	Values
From	1
To	12
Costs	2

FieldNameorDataClass	Values
Version	0
Period	1 to 12
Fiscal Year	Next year

第 354 页 / 共 403 页

Unit5: Planning AC410

Task 4:

Check the results of the revaluation.

1. Call the cost centers: planning overview report for a cost center of your

choiceforthenextfiscalyearinversion0. (Notcostcenter“Telephone”,as

it does not carry salary costs.)

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

PlanningReport→Costcenters: PlanningOverview

FieldNameorDataClass Values

Cost Center 301##

Fiscal Year Next year

Period 1 to 12

Version 0

Planning Overview → Execute

2. Displaythelineitemsforsalarycosts(costelement430000).

a) Positionyourcursoronthereportrowcostelement430000.

Display line items icon

346

FieldNameorDataClass	Values
Cost Center	301##
Fiscal Year	Next year
Period	1 to 12
Version	0

第 355 页 / 共 403 页

AC410 Lesson: Planning Aids

Lesson Summary

You should now be able to:

• ExplaintheplanningaidsprovidedbytheSAPsystem

347

第 356 页 / 共 403 页

UnitSummary AC410

Unit Summary

You should now be able to:

• Describethepurposeofcostcenterplanningandthefunctionofversions

• Explaintheuseofplanninglayoutsandplannerprofiles

• Set up aplanning layout and aplanner profile

• Execute a manual planning process.

• Listtheoptionsavailableunderautomaticplanning

• Describe final planning activities

• ExplaintheplanningaidsprovidedbytheSAPsystem

348

第 357 页 / 共 403 页

AC410 Test Your Knowledge

Test Your Knowledge

1. Intheversiondefinitionitispossibletodisplayseveralplanscenarios.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. TheSAPSystemalwaysusesversion0whenreferencingactualpostings.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. TheSAP systemspecifiestheplanningsequence.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

4. TheSAPsystemusesa forperiod-related

distribution of the totals.

Fillintheblankstocompletethesentence.

5. Assessmentanddistrinutioncanalsobecarriedoutintheplan.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

6. NametheplanningaidsprovidedbytheSAPsystem.

349

第 358 页 / 共 403 页

TestYourKnowledge AC410

Answers

1. Intheversiondefinitionitispossibletodisplayseveralplanscenarios.

Answer: True

Youcanplanseveralversions: e.g. anoptimisticandapessimisticscenario.

2. TheSAPSystemalwaysusesversion0whenreferencingactualpostings.

Answer: True

Version0isalwaysusedwhenreferencingactualpostings.

3. TheSAP systemspecifiestheplanningsequence.

Answer: False

Costcenterplanningisuseddifferentlyinalmosteveryorganization.

4. TheSAP system usesa distributionkey for period-related distributionof

the totals.

Answer: distribution key

5. Assessmentanddistrinutioncanalsobecarriedoutintheplan.

Answer: True

Periodic reposting, distribution, assessment and accrual can be executed

as actual or planned.

6. NametheplanningaidsprovidedbytheSAPsystem.

Answer:

• Copy Plan Data or Actual Data to Plan

• Revaluation

• Transferring Plan Values

350

第 359 页 / 共 403 页

Unit 6

Information system

Unit Overview

YoulearnhowReportPainterworksandtodescribethedifferentoptionsinthe

Report Painter report.

We describe the possible uses of summarization

Unit Objectives

After completing thisunit, you will beableto:

• Explain thewaytheReport Painter functions.

• DescribedifferentoptionsintheReportPainterreport.

• Select from different data sources

• Explainareportingscenarioforperiod-endclosing.

• Describethepossibleusesof summarization.

Unit Contents

Lesson: Report Painter.........................................................352

Exercise 20: Additional Functions........................................357

Lesson: Data Source...........................................................364

Lesson: Period-End Closing Reporting and Analytics .....................367

351

第 360 页 / 共 403 页

Unit6: Informationsystem AC410

Lesson: Report Painter

Lesson Overview

Thislessonillustrateshowthereport painterworks.

Lesson Objectives

After completingthislesson, you will beable to:

• Explain the way theReport Painter functions.

• DescribedifferentoptionsintheReportPainterreport.

Business Example

TheSAPsystemdeterminesthesenderactivitybasedontheruleyouspecify.

You also explain the different additional functions to the other project team

members. Thesefunctionsfacilitateandspeedupreportprocessing.

Report Painter

Figure 113: Report Painter

ThecentraltoolfordefiningreportswithintheinformationsystemistheReport

Painter. You can define reports that correspond to your specific reporting

requirements. SAPofferscourseCA705specificallyforthistool.

352

第 361 页 / 共 403 页

AC410 Lesson: Report Painter

ReportPainter reportsaredefinedusingagraphicreportingstructure, inwhich

therowsandcolumnsofthereportaredisplayedastheyarelatershowninthe

report(WYSIWYG-“Whatyouseeiswhatyouget”).

TheReport Painter providesaselectionof functionsthatyoucanusetodefine

reports quickly and easily. The Report Writer (provided for complex report

definition)ismoredemanding,butenablesyoutocreateahighlydetailedreport

layout with its additional functions.

NumerousreportsareincludedinthestandardSAPsystem.

The SAP system contains special cost element reports for evaluating the

reconciliationledger. Ifyouwanttocreateuser-definedreports,youcancopythe

standardreportsandchangetherequirementsaccordingly. ExamplesofReport

Painter reports are:

• Area: Cost Elements

• Cost Centers: Drilldown by Partner

• Area: Statistical Key Figures

• Cost Centers: Splitting

• Cost Centers: Actual/Plan/Variance

• Area: Cost Centers

• Cost Centers: Variances

The following not Report Painter reports:

• Planning Overview

• Line Item Report

• Master Data Index

• Prices

• Document Display

353

第 362 页 / 共 403 页

Unit6: Informationsystem AC410

Report Painter: Defining a Report

Figure 114: Report Painter: Defining a Report

You define the report columns using the characteristics, key figures, and

predefined columns you selected for the library. Alternatively, you can use a

column model for columndefinition. You can also define formula columnsto

show avariancebetween columns, for example.

You define the report rows by using thecharacteristicsyouselected for your

reportlibrary. Alternatively,youcanusearowmodelforyourrowdefinition. In

addition, youcandefineformularowstocalculatesuchthingsasasub-totalof

several rows.

Usethegeneralselectionstodefinethecharacteristicsyouwanttousetoselect

thedatafortheentirereport. However,youcanonlyusecharacteristicsthatare

notusedinindividualcolumnsorrowsinthegeneralselections.

Theintersectionsofrowsandcolumnsarecells. InReportPainter,youcanwork

withrows,columns,andindividualcells. Toworkwithacell,youfirstneedto

select it. Then you can use that cell in formulas throughout the entire report.

Forexample,youcanuseindividualcellstodefineacolumn“Percentageshare

of revenue.”

354

第 363 页 / 共 403 页

AC410 Lesson: Report Painter

Figure 115: Report Painter: Defining a Report

Characteristicsare fieldswhich represent thecriteriaaccording to which you

can select data. Examples of characteristicsincludeCost center, Cost element

and Fiscal year.

Keyfiguresarenumericfieldsthatyoucanevaluateinareport. Examplesare

Costs, activity quantity, planned activity quantity, or Costs in company code

currency.

Predefinedcolumnsconsistofakeyfigureandoneormorecharacteristics. They

faciliatethedefinitionoffrequently-usedcolumns. ExamplesareActualcostsin

controllingareacurrencyorPlancostsincontrollingareacurrency.

All of the reports are kept in system libraries. The transfer structure for the

ReportPainterandtheReportWriterisareporttablewhichispre-definedbySAP

and cannot be changed. In Cost Center Accounting, this istheCCSS table. A

librarycontainsthecharacteristics,keyfigures,andpredefinedcolumnsfromthe

reporttable,whichyoucanuseforyourReportPainterorReportWriterreports.

Thecorrespondingtablenamesareintheheaderofeachlibrary.

ThestandardreportsforCostCenterAccountingforthefullcostsmethodarein

the1VKlibrary,andthereportsforthemarginalcostingmethodareinthe1GK

library. Use the 1AB library for variances, and the 1RU library for summary

reports. The1CT library, whichformsthebaseof the RWCOOM reporttable,

was created especiallyfor cost accountingreports.

Onceyouhavedefinedareport,youneedtoassignittoareportgroup. Areport

groupshouldcontainallofthereportsfromalibrarythatusethesameorsimilar

data,butdisplayitdifferently. Allreportsinareportgrouparerunsimultaneously,

enabling you to movebetween different reportsin thereport display. You can

transferthereportgroupstothereportmenuofanactivitygroup.

355

第 364 页 / 共 403 页

Unit6: Informationsystem AC410

Figure 116: Options within a Report PainterReport

In the Report Painter report, you can navigate through the data in several

differentways,orbychangingthereportingstructure. Youcanmodifythereport

online, sothat itmeetsyour specific requirements.

Themostimportantadditionalfunctionsareonbuttonswithtextcommandsor

icon commands. For example:

• You can download the report to your PC (for example, formatted data

transfer in MS Excel).

• You cansetthresholdvaluesto select or ignorecertain rowsinthereport

that was run.

• The sender function enables you to mail reports. You no longer need to

createanextractforthis. ThereportisalwayssentinHTMLformatasan

attachmenttoamail,whichmeansthatitcanbesentoutsideofthesystem

without any problem.

• Other functions: Sorting report rows, hiding or showing rows, changing

thenumberformat,enteringasummationlevelforadisplayofsummaries

only, and so on.

356

第 365 页 / 共 403 页

AC410 Lesson: Report Painter

Exercise 20: Additional Functions

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Create and call up an extract for a report.

• Define user settingsfor extract management.

• Send a report to another user.

Business Example

Atperiodend, eachcostcentermanagerwantstoanalyzethedatafortheircost

center. Asarule,theyallusethesamereports. Reportcreationtakesagreatdeal

of time if data volumesarelarge and your project team istryingto find away

aroundthisproblem. Yousuggestrunningthereportsatconsultingdepartment

level, andthen savingthem asextracts. Ifthecostcenter managers call upthe

reportsforyourdepartment,youcancallupthereportextractsalreadycreated.

Task 1:

Execute your reporting using extracts.

1. SetuptheexpertmodeforyourReportWriterreports.

2. CalltheCostCenters: Actual/Plan/Variancereportforthecurrentperiod,

andfortheentireconsultingdepartment(B##0)inversion0.

3. Exitthereportand,onthedialogboxthatisdisplayed,confirmthatyouwant

tocreateanextract. EnterExtract## as the nameand set the expiration

date to tomorrow.

Save your entries.

4. Tobeabletoaccessthisextract,specifyunderDatasourcethatyouwantthe

extracts displayed.

5. Asmanagerofcostcenter301(FI/COconsulting)youwanttocallupthe

data for your cost center for the current period, in version 0 in the Cost

Centers: actual/plan/variancereportforthecurrentperiodinversion0.

Call up the extract you created earlier.

6. In the report, you want to becertain that the data displayed isindeed the

extractdata. Todoso, accesstheselection log.

Continued on next page

357

第 366 页 / 共 403 页

Unit6: Informationsystem AC410

7. After the extract was created, a posting was made to cost center 301##

(FI/CO consulting).

Does this information appear in the report when you call up the extract

a second time?

8. TheexpirationdateofyourextractExtract##appearstobedatedtooearly.

Extend the expiration date by four days.

Youalsodecidetoassignapasswordtoyourextract.

9. Youwanttoensurethatthesystemalwaysdisplaysthemostrecentextract

forareport. InCustomizing,enterthisinformationintheusersettingsfor

extract management.

Task 2:

Themanager ofcostcenter 301##(LOconsulting) wantsareportto besentto

theirdeputy,asthedeputyisnotauthorizedtorunreports.

1. Call the Cost Centers: Actual/Plan/Variance for the current period in

version0andforcostcenter301##(FI/COconsulting).

2. Sendthereporttothedeputyforthiscostcenter. Writeashortnotetothe

recipientandentertheiruserIDastheaddress. (Inthisexercise, useyour

own user ID or that of your neighbor.)

3. Checkwhetherthemessagearrivedatyourworkcenter. Callupthenotice.

Choose "Continue" and display the report.

358

第 367 页 / 共 403 页

AC410 Lesson: Report Painter

Solution 20: Additional Functions

Task 1:

Execute your reporting using extracts.

1. SetuptheexpertmodeforyourReportWriterreports.

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

Plan/ActualComparison→Costcenters: Actual/Plan/Variance→

Environment → Options

FieldNameorDataClass Values

Expert mode Select

2. CalltheCostCenters: Actual/Plan/Variancereportforthecurrentperiod,

andfortheentireconsultingdepartment(B##0)inversion0.

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

Plan/ActualComparison→Costcenters: Actual/Plan/Variance

FieldNameorDataClass Values

Controlling Area 1000

Fiscal Year Current

From period Current

To period Current

Plan version 0

Cost center group B##

Program → Execute

3. Exitthereportand,onthedialogboxthatisdisplayed,confirmthatyouwant

tocreateanextract. EnterExtract## as the nameand set the expiration

date to tomorrow.

Continued on next page

359

FieldNameorDataClass	Values
Expert mode	Select

FieldNameorDataClass	Values
Controlling Area	1000
Fiscal Year	Current
From period	Current
To period	Current
Plan version	0
Cost center group	B##

第 368 页 / 共 403 页

Unit6: Informationsystem AC410

Save your entries.

a) Report → Exit

b) Select Create extract.

Exit the report:

FieldNameorDataClass Values

Description Extract##

Expires on Tomorrow's date

Enter

Confirm dialog box by choosingEnter

4. Tobeabletoaccessthisextract,specifyunderDatasourcethatyouwantthe

extracts displayed.

a) Onthereportselectionscreen,chooseDatasource.

Select the Display Extract.

Enter

5. Asmanagerofcostcenter301(FI/COconsulting)youwanttocallupthe

data for your cost center for the current period, in version 0 in the Cost

Centers: actual/plan/variancereportforthecurrentperiodinversion0.

Call up the extract you created earlier.

a) Place the cursor on yourExtract.

Enter

Program → Execute

6. Inthe report, you want to be certain that the datadisplayed is indeed the

extract data. To do so, accesstheselection log.

a) Extras → Selection Log

Thenameandtimeofthesaveddataisthesameasthatoftheextract

description Extract##.

Continued on next page

360

FieldNameorDataClass	Values
Description	Extract##
Expires on	Tomorrow's date

第 369 页 / 共 403 页

AC410 Lesson: Report Painter

7. After the extract was created, a posting was made to cost center 301##

(FI/CO consulting).

Does this information appear in the report when you call up the extract

a second time?

Answer: Anextract isasnap-shotof areport at aparticular time. Those

postings that you make after having created the extract are therefore not

includedandcanonlybedisplayedbyreselectingthedata.

8. TheexpirationdateofyourextractExtract##appearstobedatedtooearly.

Extend the expiration date by four days.

Youalsodecidetoassignapasswordtoyourextract.

a) Onthereportselectionscreen,chooseEnvironment? ExtractDirectory

SelectOnlyself-createdextractsandCreatedinthelast10days.

Program → Execute

Select an extract by placing your cursor on the button in the first

column of the extract row.

Extracts→ChangetheExp. DateofSelectedExtract

EnterthenewexpirydateintheExpiresonfield.

Extracts → Password → Change

Enter your new password twice.

Enter

9. Youwanttoensurethatthesystemalwaysdisplaysthemostrecentextract

forareport. InCustomizing,enterthisinformationintheusersettingsfor

extract management.

a) IMG:Controlling→CostCenterAccounting→Informationsystem→

UserSettings→DetermineSettingsforExtractManagement

Enter your user AC410-##.

Program → Execute

Confirm the dialog box.

Select your user.

User Settings → Change

Underextractselection,chooseDisplaycurrentextractautomatically.

Confirm icon.

Save your data.

Continued on next page

361

第 370 页 / 共 403 页

Unit6: Informationsystem AC410

Task 2:

Themanager ofcostcenter 301##(LOconsulting) wantsareportto besentto

theirdeputy,asthedeputyisnotauthorizedtorunreports.

1. Call the Cost Centers: Actual/Plan/Variance for the current period in

version0andforcostcenter301##(FI/COconsulting).

a) CCA:InformationSystem→ReportsforCostCenterAccounting→

Plan/ActualComparison→Costcenters: Actual/Plan/Variance

FieldNameorDataClass Values

Controlling Area 1000

Fiscal Year Current

From period Current

To period Current

Plan version 0

Cost Center 301##

Program → Execute

Enter your password.

Enter

2. Sendthereporttothedeputyforthiscostcenter. Writeashortnotetothe

recipientandentertheiruserIDastheaddress. (Inthisexercise, useyour

own user ID or that of your neighbor.)

a) Report → Send

Enter a note, such as "Pleasecall back"

RecipientAC410-##(youruserorthatofyourneighbor)

Document → Send

3. Checkwhetherthemessagearrivedatyourworkcenter. Callupthenotice.

Choose "Continue" and display the report.

a) Office→Workplace→Inbox→UnreadDocuments

Selectyour document withadouble-click.

Confirm the note by choosingEnter.

Double-click on the document

Enter your password.

362

FieldNameorDataClass	Values
Controlling Area	1000
Fiscal Year	Current
From period	Current
To period	Current
Plan version	0
Cost Center	301##

第 371 页 / 共 403 页

AC410 Lesson: Report Painter

Lesson Summary

You should now be able to:

• Explain thewaytheReport Painter functions.

• DescribedifferentoptionsintheReportPainterreport.

363

第 372 页 / 共 403 页

Unit6: Informationsystem AC410

Lesson: Data Source

Lesson Overview

Ifyousavereportsinextracts,thenyouhavefasteraccesstothedatasaved.

Lesson Objectives

After completingthislesson, you will beable to:

• Select from different data sources

Business Example

Ifyousavereportsinextracts,thenyouhavefasteraccesstothedatasaved. You

can select data from adatabase or an archive.

Data Sources in the Information System

Figure 117: Data Sources in the Information System

If you save reports in extracts, thenyouhave faster accessto the datasaved.

Report extracts for groups support navigation in the group with the Variation

function.

It is possible to select data from the database to create an ad-hoc report with

the most current information.

364

第 373 页 / 共 403 页

AC410 Lesson: Data Source

It is also possible to read from archive data. Reports are used for providing

archived information.

Ifyouwanttocreateextracts,youhavetochangetoextractmode. Thenyoucan

chooseCreateExtractbeforeyourunthereport,oryoucanchooseYesonthe

dialogboxthatappearswhenyouexitthereport. Theselectionparameterandthe

timeofthereportdefinitionautomaticallycharacterizetheextract.

InExtractManagementincustomizing,youspecifytheuser-specificsettingsfor

thedataaccess. Thefollowingoptionsareprovidedforthis:

• New selection

The system reselects the data and does not use existing extracts for the

specified selection criteria.

• Display extract.

Ifexistingextractsmeettheselectioncriteria,thentheSAPsystemdisplays

theminadialogboxforselection. Ifnoneoftheextractsmeetthecriteria,

thentheSAPsystemusesthecurrent datarecords.

• Automatic display of current extract

TheSAPsystemautomaticallydisplaysthemostrecentextract.

You can display all extracts in an overview, print extracts, delete or change

the expiry date.

365

第 374 页 / 共 403 页

Unit6: Informationsystem AC410

Lesson Summary

You should now be able to:

• Select from different data sources

366

第 375 页 / 共 403 页

AC410 Lesson: Period-End Closing Reporting and Analytics

Lesson: Period-End Closing Reporting and Analytics

Lesson Overview

Atperiodend,eachcostcentermanagerwantstohaveacurrentreportonhiscost

center. Thestrainonthesystemshouldbekepttoaminimum.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Explainareportingscenarioforperiod-endclosing.

• Describethepossibleusesof summarization.

Business Example

Attheendofaperiod,youwanttoprovideyourcostcentermanagerwithanup

to-date report on the cost center. However, you want to keep the expense and

system load to a minimum.

Period-End Reporting: Scenario with Extracts

Figure 118: Period-End Reporting: Scenario with Extracts

Exampleofreportingforperiod-endclosing: Attheendofaperiod,youwant

toprovideyourcostcentermanagerwithanupto-datereportonthecostcenter.

However,youwanttokeeptheexpenseandsystemloadtoaminimum.

Proceed as follows:

367

第 376 页 / 共 403 页

Unit6: Informationsystem AC410

Savethereportparametersandthevariationselectioncriteriaforthereportina

variant. Thenyoucanenterthetimethatthereportistoberun,orsetthePeriodic

Executionindicatortorunthereportinthebackground. Thevariantisassigned

to the background job.

Settheuserparametersforthecostcentermanager, sothatthesystemprovides

thereportsforyourareaofresponsibility,andthelatestdataiscalledup.

Duringperiod-endclosing,thebackgroundjobcreatesanextractforthehighest

nodeinyourstandardhierarchy. Ifacentraldepartmentregularlyrunsthereport

forperiod-endclosing,itcanhaveauthorizationforrunningtheprogram,butdoes

notnecessarilyhavetohaveauthorizationtodisplaytheresults.

Each cost center manager can quickly and easily display the relevant reports

required. Cost center managers cannot call up extracts from the areas of

responsibility of other managers.

Period-End Reporting: Summarization

Figure 119: Period-End Reporting: Summarization

Summarizationenablesyoutosummarizetransactiondatainacontrollingarea

at cost center group level. The system saves the summarized datain the totals

table in its own data record.

Using summarizationonly makessenseif you want to run alarge number of

reportsforyourentirecostcenterhierarchyonthedatathatwastotaled.

You can use summarization for the highest node in the standard hierarchy, or

foraanotherhierarchy. Aftersummarization,youcanusethetotalsrecordsfor

the nodes when running reports. The runtimes of the reports are significantly

shorterthanwhentotalsrecordsareusedforlower-levelcostcentersasthedata

has to be read online.

368

第 377 页 / 共 403 页

AC410 Lesson: Period-End Closing Reporting and Analytics

Performancecanbeimprovedifyouignoretheinformationsavedinthetotals

recordsatcostcenterlevel. Youdefinethedetailifyoucarryoutasummarization

for your own cost center hierarchy.

Youneed tocreatearepresentativecost centerfor eachcostcenter groupfor

which you want to create totals. Then you need to assign this cost center to

thecorrespondinggroup. Therepresentativecostcentersareassignedtoreport

information in the maintenance for cost center groups, bychoosing the Extras

function.

SAPprovidesastandardreporttoenableyoutoanalyzethesummarizeddata.

Youcanbaseyourownreportdefinitiononthisreport.

369

第 378 页 / 共 403 页

Unit6: Informationsystem AC410

Lesson Summary

You should now be able to:

• Explainareportingscenariofor period-endclosing.

• Describethepossibleuses of summarization.

370

第 379 页 / 共 403 页

AC410 Unit Summary

Unit Summary

You should now be able to:

• Explain thewaytheReport Painter functions.

• DescribedifferentoptionsintheReportPainterreport.

• Select from different data sources

• Explainareportingscenarioforperiod-endclosing.

• Describethepossibleusesof summarization.

371

第 380 页 / 共 403 页

UnitSummary AC410

372

第 381 页 / 共 403 页

AC410 Test Your Knowledge

Test Your Knowledge

1. YoucanusetheReportPaintertodefineyourownreports.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. If you savereportsin , you havefaster accessto the data

saved.

Fillintheblankstocompletethesentence.

373

第 382 页 / 共 403 页

TestYourKnowledge AC410

Answers

1. YoucanusetheReportPaintertodefineyourownreports.

Answer: True

ReportscanbegeneratedwiththeReportPainterasrequired.

2. Ifyousavereportsinextracts,youhavefasteraccesstothedatasaved.

Answer: extracts

374