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

第 264 页 / 共 339 页

Unit6: ProfitCenterPlanning AC610

Field Name Values

Template SALES##

Environment PCA

Confirm by pressing Enter.

After you have accessed the template definition, enter “Revenue

Planning” asthe name of the template.

Enteraformulalinewiththefollowingparameters:

Field Name Values

Type P&L account

Object 800000

Confirm by pressing Enter.

Gototheformulaeditorbydouble-clickingtheplanamountperperiod

field.

Hint: In the formula editor you can enter mathematical

relationshipsfreely. TomakeaccessingSAPdatasimpler,you

can use functions which map predefined accessesthat only

requireparameterstospecifytheaccessdata.

To define the revenue formula, you need the two functions

“CostsRevenuesInventories”and“QtyStatKeyFigure”.

“CostsRevenuesInventories”deliverstheplanningdataof a

profit center.

“QtyStatKeyFigure”deliversthequantityofastatisticalkey

figure of a profit center.

CalltheCostsRevenuesInventoriesfunctionandassignthefollowing

parameters:

Double-click the CostsRevenuesInventories function in the screen

sectionFunctionsforTypeP&LAccount. Thesystemdisplaysthenew

windowCreate Template PCA / Sales##.

Enter the following parameters:

Continued on next page

256

Field Name	Values
Template	SALES##
Environment	PCA

Field Name	Values
Type	P&L account
Object	800000

第 265 页 / 共 339 页

AC610 Lesson: Planning Process

Field Name Values

Company Code 1000

Plan_Actual_Indicator 1

Profit_Center 93##

Account number 800000

Version 0

Fiscal Year Current fiscal year

Check thefunctionand confirm withEnter.

In the formula editor you can then see the expression for the

“CostsRevenuesInventories” function which returns the average

revenue of profit center 93##.

Thenaddthemultiplicationsign. Don'tforgettheblankcharacter.

Positionthecursoraftertheformulaintheformulaeditor.

Insertablankcharacterbychoosingspacebar. ClicktheInsert*icon.

Insertablankcharacter bychoosingspacebar.

Afterwards,insertthe“QtyStatKeyFigure”functionwiththefollowing

parameters:

Double-clickonthe QtyStatKeyFigurefunctioninthescreensection

Functions for Type P&L Account.

ThesystemdisplaysthenewwindowCreateTemplatePCA/Sales##.

Enter the following parameters:

Field Name Values

Company Code 1000

1. PeriodicCalc. ofValues, 1

2. Total Fisc Year

0: Actual, 1: Planned 1

Profit Center Profit Center

Statistical key fig. 9100

Version 0

Fiscal Year Current fiscal year

Continued on next page

257

Field Name	Values
Company Code	1000
Plan_Actual_Indicator	1
Profit_Center	93##
Account number	800000
Version	0
Fiscal Year	Current fiscal year

Field Name	Values
Company Code	1000
1. PeriodicCalc. ofValues, 2. Total Fisc Year	1
0: Actual, 1: Planned	1
Profit Center	Profit Center
Statistical key fig.	9100
Version	0
Fiscal Year	Current fiscal year

第 266 页 / 共 339 页

Unit6: ProfitCenterPlanning AC610

Check thefunctionandconfirm withEnter.

Hint: In the formula editor you can now see the complete

formula which multiplies two function values. The first

functionreturnstheplanned revenuesofprofitcenter 93##,

whereas the second function returns the quantity of the

statisticalkeyfigure9100. Thefunctiontakesthequantityof

thestatistical keyfigurefrom the respective profit centerin

whosemasterrecordthetemplateisdefined.

Confirm the formula in the editor.

Clickthe ConfirmPlanAmountperPeriodicon.

Save the SALES## template.

4. AssigntemplateSALES##tothemasterrecordsofprofitcenter91##and

92##.

Answer: PCA: Master Data → Profit Center → Individual Processing

→ Change

Enter 91## and confirm.

Click the Indicators tab page.

Enter template SALES## in the Form. Planning Temp. field. Save the

master record. Activate the master record.

Enter 92## and confirm.

Click the Indicators tab page.

EntertemplateSALES##intheForm. PlanningTemp. field.

Save the master record.

Activate the master record.

5. IntheinformationsystemforProfitCenterAccounting,callthereportProfit

CenterGroup: Plan/Actual/Variancewiththefollowingparameters:

Field Name Values

Controlling Area 1000

Fiscal Year Current fiscal year

Period 1 - 12

Plan Version 0

Profit Center PLAN##

ProfitandLossAccountsGroup 3000000.INT

BalanceSheetAccountGroup 1000000.INT

Continued on next page

258

Field Name	Values
Controlling Area	1000
Fiscal Year	Current fiscal year
Period	1 - 12
Plan Version	0
Profit Center	PLAN##
ProfitandLossAccountsGroup	3000000.INT
BalanceSheetAccountGroup	1000000.INT

第 267 页 / 共 339 页

AC610 Lesson: Planning Process

Displaycostelement800000. Whichplanningdatahasbeenpostedtoprofit

center 91## and profit center 92##?

____________________________________________________________

a) PCA:InformationSystem→ReportsforProfitCenterAccounting→

List-OrientatedReports→ProfitCenterGroup: Plan/ActualVariance

Norevenueshavebeenpostedyettoprofitcenters91##and92##.

6. Executetheformulaplanningin companycode1000fortheprofit center

groupPLAN## inall theperiodsof thecurrentfiscal yearinversion 0in

update mode.

a) PCA: Planning→ExecuteFormulaPlanning

Enter the following data:

Field Name Values

Company Code 1000

Profit CenterGroup PLAN##

Version 0

Period 1 - 12

Fiscal Year Current fiscal year

TestRunnotactivated

Detail Lists Activate

Execute.

7. Call the report from task 3-3-5 again and check cost element 800000 for

profit centers 91## and 92##.

Which values were posted?

91##: _______________________________________________________

92##: _______________________________________________________

Explain howeach of these valuescomesabout.

Answer: 91##: 12,000,000

92##: 3,000,000

Explain howeach of these valuescomesabout.

91##: 100teammembersintheplanx120,000revenue

92##: 25teammembersintheplanx120,000revenue

Continued on next page

259

Field Name	Values
Company Code	1000
Profit CenterGroup	PLAN##
Version	0
Period	1 - 12
Fiscal Year	Current fiscal year
TestRunnotactivated
Detail Lists	Activate

第 268 页 / 共 339 页

Unit6: ProfitCenterPlanning AC610

Task 4:

Theplanningdataofprofitcenter91##shouldbeusedasatemplateforplanning

in version 610.

1. Firstcallthelist-orientatedreportProfitCenterGroup: Plan/Plan/Variance

with the following parameters:

Field Name Values

Controlling Area 1000

Fiscal Year Current fiscal year

Period 1 - 12

Plan Version (1) 0

Plan Version (2) 610

Profit Center Value 91##

ProfitandLossAccountsGroup 3000000.INT

BalanceSheetAccountGroup 1000000.INT

Howmuch is the plan total in version 0?

____________________________________________________________

Howmuch istheplantotal inversion610?

Continued on next page

260

Field Name	Values
Controlling Area	1000
Fiscal Year	Current fiscal year
Period	1 - 12
Plan Version (1)	0
Plan Version (2)	610
Profit Center Value	91##
ProfitandLossAccountsGroup	3000000.INT
BalanceSheetAccountGroup	1000000.INT

第 269 页 / 共 339 页

AC610 Lesson: Planning Process

____________________________________________________________

a) PCA:InformationSystem→ReportsforProfitCenterAccounting→

List-OrientatedReports→ProfitCenterGroup: Plan/Plan/Variance

Enter the following data:

Field Name Values

Controlling Area 1000

Fiscal Year Current fiscal year

Period 1 - 12

Plan Version (1) 0

Plan Version (2) 610

Profit Center Value 91##

ProfitandLossAccountsGroup 3000000.INT

BalanceSheetAccountGroup 1000000.INT

Run the report.

Howmuch istheplan total in version 0?

It variesdepending on the postings.

Howmuchistheplantotal inversion 610?

It must be zero.

Continued on next page

261

Field Name	Values
Controlling Area	1000
Fiscal Year	Current fiscal year
Period	1 - 12
Plan Version (1)	0
Plan Version (2)	610
Profit Center Value	91##
ProfitandLossAccountsGroup	3000000.INT
BalanceSheetAccountGroup	1000000.INT

第 270 页 / 共 339 页

Unit6: ProfitCenterPlanning AC610

2. Copytheplannedcostsandrevenuesofprofitcenter91##fromversion0to

version610. Restricttheselectiontoallperiodsofthecurrentfiscalyearin

companycode1000. Thecopieddatashouldreplaceexistingdataandbe

increasedby2%. Intheselectioncriteria,restricttheaccountstobecopied

to account group 3000000.INT.

a) PCA: Planning → Copy Data to Plan

Enter the following data:

Field Name Values

Planning Area Cost/revenues

CopyFromRecordType Planned

Copy From Version 0

CopyFromCompanyCode 1000

CopyFromFiscalYear Current fiscal year

Copy To Version 610

CopyToCompanyCode 1000

Copy ToFiscalYear Current fiscal year

Periods 1 - 12

RevaluationFactorsCurrencies 1,02

Document type R0

ChoosetheSelectionCriteriapushbutton.

Enter the following data:

Field Name Values

Profit Center 91##

Account group 3000000.INT

Click the Copy Data to Plan icon.

Skip the warning message stating that planning data already exists

for ledger 8A.

Continued on next page

262

Field Name	Values
Planning Area	Cost/revenues
CopyFromRecordType	Planned
Copy From Version	0
CopyFromCompanyCode	1000
CopyFromFiscalYear	Current fiscal year
Copy To Version	610
CopyToCompanyCode	1000
Copy ToFiscalYear	Current fiscal year
Periods	1 - 12
RevaluationFactorsCurrencies	1,02
Document type	R0

Field Name	Values
Profit Center	91##
Account group	3000000.INT

第 271 页 / 共 339 页

AC610 Lesson: Planning Process

3. Callthereportfromtask4-1againandchecktheplantotalforprofitcenter

91## in version 0 and version 610.

How much is the plan total in version 0?

Howmuch isthe plan total in version 610?

Answer: For execution, see task 4-1.

How much is the plan total in version 0?

Theamountcanvarydependingonthepostings.

Howmuch isthe plan total in version 610?

Itmustbe2%higherthaninversion0. YoucancheckthatintheVar.

(%) column.

263

第 272 页 / 共 339 页

Unit6: ProfitCenterPlanning AC610

Lesson Summary

You should now be able to:

• modelaplanningprocessinProfitCenterAccountingusingmanualplanning

and formula planning

264

第 273 页 / 共 339 页

AC610 Unit Summary

Unit Summary

You should now be able to:

• set up profit center planning and carry out both manual and automatic

planning

• explain how profit center planning is integrated with overall business

planning in SAP

• set up profit center planning

• usetheintegrated function for transferring planningdata toProfit Center

Accounting

• modelaplanningprocessinProfitCenterAccountingusingmanualplanning

and formula planning

265

第 274 页 / 共 339 页

UnitSummary AC610

266

第 275 页 / 共 339 页

AC610 Test Your Knowledge

Test Your Knowledge

1. Therearenorestrictionswithregard tocopyingplanninglayoutsinProfit

Center Accounting.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Planningdatacannotbetransferredfromcostingbasedprofitabilityanalysis

toProfitCenterAccountingbecausetherearenovaluefieldsinProfitCenter

Accounting.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Youcannotuploadplanning datatoProfit CenterAccountingfromExcel

becauseplanningdatacanbecopiedfromCostCenterAccounting.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

267

第 276 页 / 共 339 页

TestYourKnowledge AC610

Answers

1. TherearenorestrictionswithregardtocopyingplanninglayoutsinProfit

Center Accounting.

Answer: False

Planninglayoutsareassignedtoafixedplanningarea. Theycanbeusedas

templatesonlyintheplanningareas: costs/revenues,stocks,andstatistical

key values.

2. Planningdatacannotbetransferredfromcostingbasedprofitabilityanalysis

toProfitCenterAccountingbecausetherearenovaluefieldsinProfitCenter

Accounting.

Answer: False

PlanningdatacanbetransferredfromprofitabilityanalysistoProfitCenter

Accounting.

3. You cannot uploadplanningdatato Profit Center AccountingfromExcel

becauseplanningdatacanbecopiedfromCostCenterAccounting.

Answer: False

YoucanuploadplanningdatafromExcelinbothcostcenterplanningand

profit center planning.

268

第 277 页 / 共 339 页

Unit 7

Information System

Unit Overview

Profit Center Accounting uses Report Painter reports and drilldown reports.

Drilldownreportscanbedefinedasbasicreportsandform-basedreports.

Unit Objectives

After completing thisunit, you will beableto:

• usethestandardreportsanddefineyourownbasicandform-basedreports

• use a drilldown report

• defineyourownbasicandform-baseddrilldownreports

Unit Contents

Lesson: Overview...............................................................270

Exercise 14: Overview.....................................................273

Lesson: Reporting with Drilldown Reporting ................................279

Exercise 15: Reporting with Drilldown Reporting ......................289

269

第 278 页 / 共 339 页

Unit7: InformationSystem AC610

Lesson: Overview

Lesson Overview

YoutestthereportingtoolsinProfitCenterAccounting.

Lesson Objectives

After completingthislesson, you will beable to:

• usethestandardreportsanddefineyourownbasicandform-basedreports

• use a drilldown report

Business Example

Outlinetheoptionsavailableforreportingprofitcenterdata.

ReportonfinancialkeyfiguressuchasReturnonInvestment,orReturnonNet

Assets.

Explore the standard reports.

Analyzeplan/actualcomparisonsofprofitcenters.

Access the original documents.

Yourprojectteamnowhasaclearunderstandingoftheactualandplandataflow

inProfitCenterAccounting. Younowoutlinetheoptionsavailableforreporting

PCAdata. YouknowthatanumberofstandardreportsareshippedwiththeSAP

system. Your team membersare especially interested in analyzing plan/actual

comparisonsoftheprofitcenterstheyareresponsiblefor. Inadditiontheywould

liketo‘drilldown’totheoriginatingdocuments. Youexplaintheoptionsavailable

with standard reports.

YourVPofFinanceisinterestedincertainfinancialkeyfigures,suchasReturn

onInvestment. Afterlookingatthestandardreportsyoudecidethatonlyslight

modificationsareneededinordertoreceivethekeyfiguresyourequire.

270

第 279 页 / 共 339 页

AC610 Lesson: Overview

Figure 90: Information System: Overview

Youcananalyzeallthetransactiondatastoredintheprofitcentertablesusingthe

standardreportsoryourowndrilldownreportsandReportPainterreports. (You

do this by accessing the totals record table GLPCT). If you store line items in

Profit Center Accounting, youcancall up alineitemreportfromthesummary

reportandthenaccesstheoriginaldocumentsfromtheiroriginalapplications.

ThemasterdataindexprovidesyouwithanoverviewofthemasterdatainProfit

Center Accounting postingsfor each revenue or cost element broken down by

profit center.

271

第 280 页 / 共 339 页

Unit7: InformationSystem AC610

Figure 91: Standard Reports

Thestandardreportsandreportgroupsarefoundinthelibraries8A2, 8A3and

8A4. Theycanroughlybedividedintothefollowinggroups:

Theareaprofitabilityreportsdisplaytheprofitsfortheselectedprofitcenter(s).

Thesearenotbrokendownintorevenueandcostselements. Typicalreportsof

this type are the plan/actual comparisons, a period breakdown or profit center

ReturnonInvestment. Thesereportsaremeanttogivetheuseraquickoverview

andserveasaspringboardtotheother reporttypes.

The group reports display the profits of a profit center group broken down

accordingtotheselectedrevenueandcostelements. Thesereportsaremeantto

providethepersonsinchargeof profit centerswithamoredetailedanalysisof

theirareaofresponsibility. ThesereportsalsoletyouusethefunctionVariation.

Inaddition,someofthereportsalsodisplayselectedbalancesheetitems(fixed

assets,currentassets,payables)andthereturnoninvestmentcalculatedfromthat,

brokendownaccordingtotheselectedrevenueandcostelements.

Theprofit centerreportscontaintheindividualprofitcentersbrokendownand

summarized according to aprofit center group.

Anothertypeofreportistheplan/actualaccordingtoaccountsreportsforProfit

CenterAccounting. Thesereportscontainthepostingsforeachaccountbroken

down by profit center.

Alternativereportcurrencyreportscontainanumberoftheabovereportswhich

you can execute in any currency.

272

第 281 页 / 共 339 页

AC610 Lesson: Overview

Exercise 14: Overview

Exercise Objectives

After completingthisexercise, youwillbeableto:

• usestandardreportsandchecktheinformationtheycontain.

Business Example

Thedepartmentmanagerswanttobeinformedaboutwhichreportingrequirements

are covered by standard reports.

Task 1:

Checktheusabilityofdrilldownreportsofinteractivereporting.

1. CallthereportProfitCenterGroup: Plan/Actual/Variancewiththefollowing

parameters:

Field Name Values

Period 1 – 12

Fiscal Year Current fiscal year

Plan Version 0

ProfitCenter Group GR##

ProfitandLossAccountsGroup 3000000.INT

2. The system displays the report layout. The breakdown is sorted by the

accountnumbersofaccount group3000000.INT.

Changethebreakdownofthevaluesbydouble-clickingonthecharacteristic

Profit Center in the “Navigation” window.

3. Youcannowseeahierarchydisplayoftheprofitcenterstowhichpostings

have been made.

ExpandhierarchyGR##andbreakdowntheviewbyaccountnumberfor

profitcenter91##bymovingprofitcenter91##tothecharacteristicAccount

Number using drag and drop.

Youcannowseetheprofitandlossstatementofprofitcenter91##.

Toseetheaccountswithingroup3000000.INT,expandthesubtreeusingthe

right mouse button.

Continued on next page

273

Field Name	Values
Period	1 – 12
Fiscal Year	Current fiscal year
Plan Version	0
ProfitCenter Group	GR##
ProfitandLossAccountsGroup	3000000.INT

第 282 页 / 共 339 页

Unit7: InformationSystem AC610

4. You find this display confusing and only want to have just the accounts

withouthierarchycharacteristicsdisplayed. Deactivatethehierarchydisplay

for the characteristic Account Number.

5. Thedisplayedresultonlydisplaysthecostsandrevenuesforprofitcenter

91##. Youwanttoseethetotalvaluesagain. Canceltheselectionforcost

center 91##.

6. YoucannowseetheaccountbreakdownforprofitcentergroupGR##.

Youwanttobreakdownthetotalvaluesbyfunctionalarea. Double-clickon

the characteristic Functional Area.

7. Youcannowseetheoverallresultbrokendownbyfunctionalarea.

Some postings were not assigned.

Findoutwhichaccountnumberswerenotassignedtoanyfunctionalarea

bymovingtheNotAssignedValuestothecharacteristicAccountNumber

using drag and drop.

8. Whichaccountswerenotassignedtoanyfunctionalareaintheactual?

Task 2:

Youwanttocheckmasterdataentriesintheinformationsystem.

1. Call the special report Profit Center: Master Data Index for profit center

group GR##.

2. Change the layout by including the “PrCtr Formula Planning Template”

column.

3. TowhichprofitcentershastemplateSALES##beenassignedinthemaster

record?

274

第 283 页 / 共 339 页

AC610 Lesson: Overview

Solution 14: Overview

Task 1:

Checktheusabilityofdrilldownreportsofinteractivereporting.

1. CallthereportProfitCenterGroup: Plan/Actual/Variancewiththefollowing

parameters:

Field Name Values

Period 1 – 12

Fiscal Year Current fiscal year

Plan Version 0

ProfitCenter Group GR##

ProfitandLossAccountsGroup 3000000.INT

a) PCA:InformationSystem→ReportsforProfitCenterAccounting

→InteractiveReports→ProfitCenterGroup: Plan/ActualVariance

Field Name Values

Period 1 – 12

Fiscal Year Current fiscal year

Plan Version 0

ProfitCenterGroup GR##

Profit and Loss Accounts 3000000.INT

Group

Run the report.

2. The system displays the report layout. The breakdown is sorted by the

accountnumbersofaccount group3000000.INT.

Changethebreakdownofthevaluesbydouble-clickingonthecharacteristic

Profit Center in the “Navigation” window.

a) Double-clickonthecharacteristicProfitCenterinthelistofnavigation

characteristics.

3. Youcannowseeahierarchydisplayoftheprofitcenterstowhichpostings

have been made.

Continued on next page

275

Field Name	Values
Period	1 – 12
Fiscal Year	Current fiscal year
Plan Version	0
ProfitCenter Group	GR##
ProfitandLossAccountsGroup	3000000.INT

Field Name	Values
Period	1 – 12
Fiscal Year	Current fiscal year
Plan Version	0
ProfitCenterGroup	GR##
Profit and Loss Accounts Group	3000000.INT

第 284 页 / 共 339 页

Unit7: InformationSystem AC610

ExpandhierarchyGR##andbreakdowntheviewbyaccountnumberfor

profitcenter91##bymovingprofitcenter91##tothecharacteristicAccount

Number using drag and drop.

Youcannowseetheprofitandlossstatementofprofitcenter91##.

Toseetheaccountswithingroup3000000.INT,expandthesubtreeusingthe

right mouse button.

a) Click using the3000000.INT withthesecondary mousebutton and

choose Expand subtree.

4. You find this display confusing and only want to have just the accounts

withouthierarchycharacteristicsdisplayed. Deactivatethehierarchydisplay

for the characteristic Account Number.

a) Click the Hierarchy... icon. .

Click the HierarchySelectionpushbutton.

ChoseNoHierarchyandconfirmbypressingEnter.

5. Thedisplayedresultonlydisplaysthecostsandrevenuesforprofitcenter

91##. Youwanttoseethetotalvaluesagain. Canceltheselectionforcost

center 91##.

a) Clickusingtherightmousebuttonontheprofitcentercharacteristic

91## inthelistof navigationcharacteristics.

Choose Cancel Selection.

6. YoucannowseetheaccountbreakdownforprofitcentergroupGR##.

Youwanttobreakdownthetotalvaluesbyfunctionalarea. Double-clickon

the characteristic Functional Area.

a) Double-click on the characteristic Functional Area in the list of

navigation characteristics.

7. Youcannowseetheoverallresultbrokendownbyfunctionalarea.

Some postings were not assigned.

Findoutwhichaccountnumberswerenotassignedtoanyfunctionalarea

bymovingtheNotAssignedValuestothecharacteristicAccountNumber

using drag and drop.

a) MovenotassignedtotheAccountNumbercharacteristicusingdrag

and drop.

8. Whichaccountswerenotassignedtoanyfunctionalareaintheactual?

Answer: Account800000and893015donothaveanyassignedfunctional

areas.

Continued on next page

276

第 285 页 / 共 339 页

AC610 Lesson: Overview

Task 2:

Youwanttocheckmasterdataentriesintheinformationsystem.

1. Call the special report Profit Center: Master DataIndex for profit center

group GR##.

a) PCA:InformationSystem→ReportsforProfitCenterAccounting

→SpecialFunctions→ProfitCenter: MasterDataIndex

Enter GR## as the profit center group.

Run the report.

2. Change the layout by including the “PrCtr Formula Planning Template”

column.

a) Choose Settings / Layout / Change

Select thePrCtr Formula Planning Template columns in thelist of

columns on the right.

Click the ShowSelected Fieldspushbutton. Confirm your selection

by pressing Enter.

3. TowhichprofitcentershastemplateSALES##beenassignedinthemaster

record?

Answer: Template SALES## is assigned to the master records of profit

center 91## and 92##.

277

第 286 页 / 共 339 页

Unit7: InformationSystem AC610

Lesson Summary

You should now be able to:

• usethestandardreportsanddefineyourownbasicandform-basedreports

• use a drilldown report

278

第 287 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Lesson: Reporting with Drilldown Reporting

Lesson Overview

Youdefinebasicandform-baseddrilldownreports.

Lesson Objectives

After completingthislesson, youwillbeable to:

• defineyourownbasicandform-baseddrilldownreports

Business Example

Managementwouldliketoknowabouttheoptionsthatareavailableforselecting

data with drilldown reports.

Figure 92: Interactive Reporting: Drilldown Reporting

279

第 288 页 / 共 339 页

Unit7: InformationSystem AC610

Drilldown reporting allows you to analyze your data according to different

characteristicsandkeyfigures. AswiththeReportPainter,drilldownreportingis

basedontheconceptsof“characteristics”and“keyfigures”.

• Characteristicsarenon-numericfields. Theyrepresentthecriteriaaccording

to which you can select data records. Examples of characteristics are

"Controllingarea","Fiscalyear"and"Profitcenter". Characteristicvalues

are the instances of these characteristics, such asfiscal year 2003, 2004,

and so on.

• Key figures are numerical fields that you can analyze in your reports.

Examplesofkeyfiguresarecostsandrevenuesorbalancesheetbalancesin

a certain currency or activity quantities.

Youcananalyzeanumberofkeyfiguresforasinglecombinationofcharacteristic

valuesaswellassinglekeyfiguresforanumberofcombinationsofcharacteristic

values. A combination of characteristic values is generally referred to as an

"object"(example: profitcenterX,revenue/costelement400000inperiod6).

Figure 93: The Concept of Drilldown Reporting

DrilldownreportingletsyouusethesamegraphicaluserinterfaceastheReport

Painterfordefiningthebasicstructureofyour reports. Youcanthenapplythis

structure, or“form”, toanynumberofdrilldownreports.

Drilldownreporting providesyouwithanumber ofuser-friendlyfunctionsfor

navigatingthroughyourreports, forexample, youcanswitchbetweendifferent

listtypes(drilldownlist/detaillist),limityouranalysistoasinglecharacteristic

value,orsummarizethedataforallvaluesofacharacteristic.

280

第 289 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Characteristicsdeterminehowyourdatacanbeclassified. TheSAPorganizational

units Controlling area, Company code, Business area, are examples of

characteristics. Thetimereference(fiscalyear,period)isalsoacharacteristic.

Your application contains a number of key figures which may be relevant for

analysis purposes. Key figures include not only stored values and quantities,

but also values which are calculated from these based on formulas which you

can define. Examples of key figures:

• Value: Costs, sales, sales deductions

• Quantity: Number of employees, salesquantity

• Calculatedvalue: Salesperemployeeandcontributionmargin

Figure 94: Functions in Drilldown Reporting

Thefunctionsofdrilldownreportingaredividedintothreelevelssothatyoucan

giveeachuseronlythosefunctionsthatheorsherequires.

Level1containsthebasicfunctionsofdrilldownreporting,plusitletsyousend

reportsbySAPmail. Thislevelisdesignedforuserswhodonotrequirethefull

functionality of drilldown reporting.

Level 2 contains the rest of the drilldown functions, plus it lets you display

graphics anddownload reportstoMicrosoft Excel.

All functions offers you all the functions in drilldown reporting, including

the print setup function and the functions for saving report data and defining

exceptions. Thislevelisdesignedforuserswhoneedtoprintandmodifyreports

inadditiontoalltheinteractivedrilldownfunctions.

281

第 290 页 / 共 339 页

Unit7: InformationSystem AC610

YoucandefinethedesiredlevelforeachuserbyenteringtheparameterRLV(0=

Allfunctions,1=Level1,2=Level2)inhisorheruserparameters.

Remember: Theindividualfunctionlevelsaresubjectedtoanauthorizationcheck.

Figure 95: Formatting Options

Youcanconfiguremanysettingsfromwithinthedisplayedreport,todisplayand

printoutdata. Youcanusethesesettingstochangethecurrency,characteristics

displayed,totalsrow,sortfunctions(suchas’SortColumns’),layout(forexample,

cumulateddisplayon/off), andvariousprintsettings.

Currency: You canusethisfunctionto translate thecurrencydisplayed forthe

selectedcurrencycolumn(s)toadifferentcurrency. Thecurrencytranslationtype

isusedtoautomaticallyfindtheexchangerate. Youdefinecurrencytranslation

types in Customizing.

Sort: You can usethisfunctiontosorttherowsin yourreportlistinascending

or descending order (based on the values in the selected row(s)). You always

sorttherowsin thecolumnor columnblockonwhichyour cursor iscurrently

positioned. Thesystemdisplaysadialogboxinwhichyoucandecidewhether

youwanttosortthecolumnorcolumnblockalphabeticallyaccordingtothekey

ortextofthecharacteristicvalues,thekeyfigureor,whereapplicable,ahierarchy

or hierarchy display.

Number Format: Insomecolumns, youcanchangethenumber format and+/-

sign. The available settings depend on the report and type of list displayed

(drilldown or detailed list).

282

第 291 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Report Types in Drilldown Reporting

• Basic Report

Quick, Easy to Define

– Select variables

– Select characteristics

– Select key figures

• Form Report

Specially formatted reports with

– Layout based on astandardized “form”

– Specialformattingoptions(color,dividinglines,etc.)

– Use of variables

Thedrilldownreportingtoolwasdesignedtoprovideyouwithasimplemeansfor

definingstraightforwardreportswhilestill offeringallthefunctionsnecessary

foryoutocreatemorecomplex,formattedreports. Consequently,adistinctionis

made between two different types of report.

Basicreportsareoftenusedtorunaquick,adhocanalysistolookforaspecific

effect. These structures have predefined basic structures that can be used

generically.

Formreports,ontheotherhand,aremorecomplexandcanbedesignedaccording

totheirspecificpurpose. Thesereportsareoftenusedforofficialreportsandare

especially suited for printing.

Formreportsaredefinedonthebasisofforms,whichareseparateobjectsthatcan

beusedforanumberofreports. Therearedifferenttypesofform,whichdifferin

termsofwhatelementsaredefinedwhereintheirstructure.

Basicreportsdonotrequiretheuseofaform. Whenyoudefineabasicreport,

yousimplyneedtoselectthecharacteristics,characteristicvalues,andkeyfigures

that you want to analyze.

283

第 292 页 / 共 339 页

Unit7: InformationSystem AC610

Figure 96: Basic Report

ThereportdefinitionfunctionscanbeaccessedinCustomizingaswellasviathe

application menu. From the selection screen, you can access all the steps for

processingin thereport definitionin anysequence.

The initial screen offersthevariables Period(from/to), Plan/Actual indicator,

Version, and Fiscal Year for basic reports.

The characteristicselectiondisplaysa list with all characteristics. Here, you

canselectthecharacteristicsthatyourequireforyouranalysis. Thisdefinesthe

dimensionsofthedatacubethatyouwanttoanalyze.

TheKeyFigureSelectionscreenshowsthecosts,revenues,andstocksinthethree

currencies, statistical keyfigures, andaquantityfield.

If you want to delete a report you can do this from the change transaction.

Howeverifyouwanttodeleteanentiregroupofreports,itissimplertodothisin

the Customizing via Reports.

284

第 293 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Figure 97: Variables: Overview

Variablesallowyoumoreflexibilityindefiningyourformsandreports. Variables

arereportorformparameterswhichyoudonotwanttospecifyuntilyoudefine

or execute a report. You can use different methods for replacing variables.

Depending on how often you want to use them, you can defineyour variables

globally or locally.

Ifyouwanttocreateavariablethatyouonlyneedinoneparticularformorreport,

youcancreatealocalvariable. Localvariablesareonlyknownwithintherelevant

formorreport. Ifyoudefinealocalvariableinaform,itisalsovalidforevery

report which uses that form.

Ontheotherhand,ifyoudefineavariableinthereportdefinition,itisonlyvalid

for thatonereport. Ifyouuseavariablefrequently, youcandefineitglobally.

Thismakesitpossibletouseglobalvariablesinallyourformsandreports. Global

variables are maintained in the Customizing. If you then want to use global

variablesinaformorinareport,thesearedisplayedforselectionintheinputhelp.

Hint: Notethatwhenyouchangeanexistingglobalvariable, thismay

affectanumberofreportsandformswhichalreadyuseit.

285

第 294 页 / 共 339 页

Unit7: InformationSystem AC610

Figure 98: Architecture of Drilldown Reporting

Youcanusecharacteristics,keyfigures,andformstodefineareport. Theresult

whenyoudisplay thereport is anumber of listsand graphics that youcan call

up and analyze interactively.

Aformdeterminesthecontentandtheformalstructureofareportlist. Aform

can be thought of as a semifinished report, which you complete by specifying

characteristicsandkey figureswhenyoudefinetheindividual report. You can

specifycharacteristicsbothintheformandinthereport. Keyfigures,however,

canonlybecontainedineithertheformorthereport.

DrilldownreportinginProfitCenterAccountingprovideseasy-to-usefunctions

fornavigatingthroughthedataset. Forexample,youcanmovefromonesegment

tothenext levelorthenextsegmentatthesamelevel, deactivatealevelofthe

drilldownhierarchy,andswitchbetweendetaillistsandoverviewlists. Youalso

haveanumberofotherfunctionsavailableforeditingonlinereports(conditions,

sort orders, ranking lists, and so on). And you can send report lists by fax or

electronicmail,ordownloadthemtoMicrosoftWordorMicrosoftExcel.

Inadditiontothevariousinteractivefunctionsforonlinelists,drilldownreporting

alsoprovidesspecial functionsfor definingthereport layout for printing(page

breaks, headersandfooters, underscores, andmore).

286

第 295 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Figure 99: Different types of forms

There are specifically three form types:

• Form with one axis(without key figure)

– Intheform withoneaxis(without keyfigure) you defineeither the

rowsor columnsof theform with characteristics. The Basicscreen

functionbringsyoufirsttoanemptylistwithcolumns.

• Form with one axis (with key figure)

– Intheformwithoneaxis(withkeyfigure)youdefineeithertherows

orcolumnsoftheformwithkeyfiguresandcharacteristics. TheBasic

screenfunctionbringsyoufirsttoanemptylistwithrows.

• Form with two axes (with key figure)

– Intheformwithtwoaxes(withkeyfigure)youdefineboththerows

and the columns of the form with key figures and characteristics.

TheBasicscreenfunctionbringsyoutoanemptylistwithrowsand

columns. Whethertherowsorthecolumnscontainthekeyfiguresis

optionalanddependsonwhatyouwanttoreporton. Thecharacteristics

can be bothin thecolumnsand intherows.

When you create a form, specify the name and the type of the form that you

want to edit.

287

第 296 页 / 共 339 页

Unit7: InformationSystem AC610

Figure 100: Drilldown Reporting

Youcananalyzeanumberofkeyfiguresforasinglecombinationofcharacteristic

valuesaswellassinglekeyfiguresforanumberofcombinationsofcharacteristic

values. A combination of characteristic values is generally referred to as an

“object”(example: profitcenterX,revenue/costelement400000inperiod6).

Inaddition,youcancomparedifferentsetsofdata(suchasplan/actual,different

planversionsorfiscalyears,andsoon)toexaminethedifferences.

DrilldownreportingletsyouusethesamegraphicaluserinterfaceastheReport

Painterfordefiningthebasicstructureofyour reports. Youcanthenapplythis

structure, or"form", toanynumberofdrilldownreports.

Drilldownreporting providesyouwithanumber ofuser-friendlyfunctionsfor

navigatingthroughyourreports, forexample, youcanswitchbetweendifferent

listtypes(drilldownlist/detaillist),limityouranalysistoasinglecharacteristic

value, or summarize thedata for all valuesof a characteristic. It also provides

additionalfunctionsforprocessingthereportlistinteractively(displayconditions,

exceptionrules,sortingfunctions,"topn"lists,andmore). Youcanalsodisplay

graphics, send report pages using SAPmail, and download reports to the SAP

XXL ListViewer andMicrosoftWordforWindows.

288

第 297 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Exercise 15: Reporting with Drilldown

Reporting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• define basic reports

• define form reports

Business Example

Thoseresponsiblefortheprofitcenteroftenwantinformationoncertainpostings

to be provided by telephone. You define a basic report which allows you to

navigate via the required characteristics. At period-end closing reporting, the

managers request a printed plan/actual/comparison. You define a form report

in order to control the output format.

Task 1:

You define a basic report.

1. DefinethebasicreportAC610##BasicReportGroup##whichallowsyouto

navigate with the following characteristics:

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Company Code No entry

Accountnumber No entry

Origin object No entry

Costsandrevenuesshouldonlybedisplayedinprofitcenterlocalcurrency.

Itshouldbepossibletoenterallvariablesonexecutionofthereport. Forthe

graphicaloutput,thescreenshouldbedividedintoaninformationwindow,a

navigation windowanda drilldown window.

SavereportAC610##. DonotenterahierarchyforthecharacteristicsProfit

Center and Account Number.

2. ExecutereportAC610##withthefollowingparameters:

Continued on next page

289

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry
Company Code	No entry
Accountnumber	No entry
Origin object	No entry

第 298 页 / 共 339 页

Unit7: InformationSystem AC610

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

3. Whichcharacteristicsaredisplayedintheinformationoutputarea?

4. Break down the report by account number. Has an amount been posted

to account 800000?

5. Whichoriginobjectscanyouidentifyforaccount800000?

Task 2:

The profit center managers often also want to know the source document for

certain postings.

1. ChangethebasicreportAC610##. AddTransactionKE5Z“ProfitCenter:

Actual LineItems”tothereport/reportinterface.

Save the document.

2. ExecutereportAC610##withthefollowingparameters:

Continued on next page

290

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 299 页 / 共 339 页

AC610 Lesson: Reporting with Drilldown Reporting

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Break down the report by account number.

3. Display the line items for account 430000. Go to the original document

of any line item.

Task 3:

Create a form report for plan/actual/comparisons. Management requires two

management-orientatedcostamountstolaydowntheperformance-relatedbonus

payments for the profit center managers.

1. Definetheformonwhichthereportisbased. Firstthesystemdisplaysthe

following overview:

Lead column Actual PLAN VARABS

Sales Account Account ACTUAL -

800000 800000 PLAN

COGS Account Account Actual-Plan

893015 893015

Contributionmargin Sales+COGS Sales+COGS Actual-Plan

I

Personnel SET SET Actual-Plan

3060000.INT 3060000.INT

Contributionmargin Contribution Contribution ACTUAL -

II margin I + margin I + PLAN

Personnel Personnel

CreateformAC610FORM##FormGroup##asamatrix.

Continued on next page

291

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Lead column	Actual	PLAN	VARABS
Sales	Account 800000	Account 800000	ACTUAL - PLAN
COGS	Account 893015	Account 893015	Actual-Plan
Contributionmargin I	Sales+COGS	Sales+COGS	Actual-Plan
Personnel	SET 3060000.INT	SET 3060000.INT	Actual-Plan
Contributionmargin II	Contribution margin I + Personnel	Contribution margin I + Personnel	ACTUAL - PLAN