第 274 页 / 共 355 页
Unit6: ProfitCenterPlanning AC610
____________________________________________________________
a) PCA:InformationSystem→ReportsforProfitCenterAccounting→
List-OrientatedReports→ProfitCenter: StatisticalKeyFigures
Enter the following data:
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version 0
Profit CenterValue 91##
StatisticalKeyFigureValue 9100
Execute.
Howmanyteammembersareassignedintheplantoprofitcenter91##?
100 employees
4. Repeatthereportcallforthereportfromtask3-1-3forprofitcenter92##.
Howmanyteammembersareassignedintheplantoprofitcenter92##?
Answer: 25 employees
Task 2:
Thecostsofgoodssoldareplanneddirectlymanuallyatthelevelofprofitcenter
sales 91##.
1. Enterthecostsofgoodssoldundercostelement893015manuallyincost
planning. Uselayout8A-101withthefollowingparameters.
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Company Code 1000
Profit Center 91##
Account number 893015
Enter the costs of goods sold
Continued on next page
264
©2005SAPAG.Allrightsreserved. 2005/Q2
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version | 0 |
| Profit CenterValue | 91## |
| StatisticalKeyFigureValue | 9100 |
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit Center | 91## |
| Account number | 893015 |
第 275 页 / 共 355 页
AC610 Lesson: Planning Process
Profit Center InProfitCenterCurrency
91## 4.800.000,-
SavethedatabychoosingtheUpdateRun icon.
a) PCA: Planning→Costs/revenues →Change
2. In the information system for Profit Center Accounting, call the report
Profit Center Group: Plan/Actual/Variance by Origin with the following
parameters.
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version 0
Profit CenterValue 91##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
Hint: Each posting in Profit Center Accountingis differentiated
by originobjects(e.g. ProfitCenter, Cost Center andsoon) both
intheactualandalsointheplanattotalsrecordlevel. Thismakes
it possible to display the costs and revenues by origin object in
the information system. The characteristic Origin Object is also
available in the definition of planning layouts. Hence it is also
possible,forexample,toenterplannedrevenuesaccordingtobilling
data (origin object 5).
Whichoriginobjectreturnstheplannedcostsforcostelement893015?
____________________________________________________________
____________________________________________________________
Which origin object returns the planned costs for cost elements 415000
and 430000?
____________________________________________________________
____________________________________________________________
Whywastheplanningdatapostedwhenthereweredifferentoriginobjects?
____________________________________________________________
Continued on next page
265
2005/Q2 © 2005 SAP AG. All rights reserved.
| Profit Center | InProfitCenterCurrency |
|---|---|
| 91## | 4.800.000,- |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version | 0 |
| Profit CenterValue | 91## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
第 276 页 / 共 355 页
Unit6: ProfitCenterPlanning AC610
____________________________________________________________
a) PCA:InformationSystem→ReportsforProfitCenterAccounting→
List-OrientatedReports→ProfitCenterGroup: Plan/Actual/Variance
by Origin
Whichoriginobjectreturnstheplannedcostsforcostelement893015?
ThedatawaspostedwithoriginobjectProfitCenter.
Whichoriginobjectreturnstheplannedcostsforcostelements415000
and 430000?
ThedatawaspostedwithoriginobjectCostCenter.
Why wasthe planningdata postedwhenthere weredifferent origin
objects?
Thecostsofcostelement893015Costsofgoodssoldwereentered
in Profit Center Accounting.
The costs of cost elements 415000 and 430000 were transferred
from the cost center planning.
Task 3:
Revenueplanninginthecompanyisnotonlycarriedoutmanually,butistobe
automated using formula planning. The planning/organization manager wants
onlyanaveragerevenueperteammembertobeenteredmanuallyonareference
profit center, which is then updated to the individual profit centers with the
formula planning.
1. SetplannerprofileSAP801inProfitCenterAccounting.
Answer: PCA: Planning→SetPlannerProfile
Enter SAP801 and confirm.
2. Management expects a revenue of 120,000 per team member in order to
meetthebusinesstargets. Enterthisvalueonprofitcenter93##Planning.
Uselayout 8A-111withthefollowingparameters:
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Company Code 1000
Profit Center 93## Planning
Account number 800000
Continued on next page
266
©2005SAPAG.Allrightsreserved. 2005/Q2
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit Center | 93## Planning |
| Account number | 800000 |
第 277 页 / 共 355 页
AC610 Lesson: Planning Process
Entertheplannedaveragerevenueperteammember.
Hint: Notethatrevenuesmustbeenteredwithanegativesign.
Account number InProfitCenterCurrency
800000 -120.000,-
Save the data
a) PCA: Planning®Costs/Revenues®Change
Click the Overview screen icon.
3. Define template SALES## in the PCA template environment in order to
calculatetheplannedrevenuesonprofitcenters91##and92##.
Hint: Thenumberofteammembersintheplanhasbeensavedwith
thestatisticalkeyfigure9100forprofitcenter91##and92##. The
plannedaveragerevenuecanbefoundonprofitcenter93##under
cost element 800000. The planned revenue for 91## or 92## is
calculated by multiplying the average revenue from 93## by the
number of team members for 91## or 92##. This relationship is
definedinatemplate,whichmustbedefinedinthemasterrecordof
theprofitcentertobeplannedbeforeformulaplanningisexecuted.
Afteryouhaveaccessedthetemplatedefinition,enter“RevenuePlanning”as
thenameofthetemplate. Enteraformulalinewiththefollowingparameters:
Field Name Values
Type P&L account
Object 800000
Continued on next page
267
2005/Q2 © 2005 SAP AG. All rights reserved.
| Account number | InProfitCenterCurrency |
|---|---|
| 800000 | -120.000,- |
| Field Name | Values |
|---|---|
| Type | P&L account |
| Object | 800000 |
第 278 页 / 共 355 页
Unit6: ProfitCenterPlanning AC610
Gototheformulaeditorbydouble-clickingonthePlanAmountPerPeriod
field.
Hint: Intheformulaeditoryoucanentermathematicalrelationships
freely. TomakeaccessingSAPdatasimpler,youcanusefunctions
which map predefined accesses that only require parameters to
specify the access data.
To define the revenue formula, you need the two functions
“CostsRevenuesInventories”and“QtyStatKeyFigure”.
“CostsRevenuesInventories”deliverstheplanningdataofaprofit
center.
“QtyStatKeyFigure”deliversthequantityofastatisticalkeyfigure
of a profit center.
CallCostsRevenuesInventoriesfunctionandassignthefollowingparameters:
Field Name Values
Company Code 1000
Plan_Actual_Indicator 1
Profit_Center 93##
Account number 800000
Version 0
Fiscal Year Current fiscal year
Check thefunctionandconfirm withEnter.
In the formula editor you can then see the expression for the
“CostsRevenuesInventories” function which returns the averagerevenue
of profit center 93##.
Thenaddthemultiplicationsign. Don'tforgettheblankcharacter.
Afterwards, insertthe„“QtySTATKeyFigure”functionwiththefollowing
parameters:
Field Name Values
Company Code 1000
1
1. PeriodicCalc. ofValues,
2. Total Fisc Year
Continued on next page
268
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
第 279 页 / 共 355 页
AC610 Lesson: Planning Process
Field Name Values
0: Actual, 1: Planned 1
Profit Center Profit Center
Statistical key fig. 9100
Version 0
Fiscal Year Current fiscal year
Check thefunction and confirm with Enter.
Hint: Intheformulaeditoryoucannowseethecompleteformula
whichmultipliestwofunctionvalues. Thefirstfunctionreturnsthe
plannedrevenuesofprofitcenter93##,whereasthesecondfunction
returnsthequantityofthestatisticalkeyfigure9100. Thefunction
takesthequantityof thestatisticalkeyfigurefrom therespective
profitcenterinwhosemasterrecordthetemplateisdefined.
Confirm the formula in the editor.
Save the SALES## template.
a) Define template SALES## in the PCA environment in order to
calculatetheplannedrevenuesonprofitcenters91##and92##.
Hint: Thenumberofteammembersintheplanhasbeensaved
withthestatisticalkeyfigure9100forprofitcenter91##and
92##. The planned average revenue can be found on profit
center93##undercostelement800000. Theplannedrevenue
for 91## or 92## is calculated by multiplying the average
revenuefrom93##bythenumberofteammembersfor91##
or 92##. This relationship is defined in a template, which
mustbedefinedinthemasterrecordoftheprofitcentertobe
plannedbeforeformulaplanningisexecuted.
ORK2: ProfitCenterAccounting→Planning→FormulaPlanning
→ Maintain Templates.
Choose Create Template.
Enter the following data:
Continued on next page
269
2005/Q2 © 2005 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| 0: Actual, 1: Planned | 1 |
| Profit Center | Profit Center |
| Statistical key fig. | 9100 |
| Version | 0 |
| Fiscal Year | Current fiscal year |
第 280 页 / 共 355 页
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
270
©2005SAPAG.Allrightsreserved. 2005/Q2
| Field Name | Values |
|---|---|
| Template | SALES## |
| Environment | PCA |
| Field Name | Values |
|---|---|
| Type | P&L account |
| Object | 800000 |
第 281 页 / 共 355 页
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
271
2005/Q2 © 2005 SAP AG. All rights reserved.
| 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 |
第 282 页 / 共 355 页
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
272
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
第 283 页 / 共 355 页
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
273
2005/Q2 © 2005 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Company Code | 1000 |
| Profit CenterGroup | PLAN## |
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| TestRunnotactivated | |
| Detail Lists | Activate |
第 284 页 / 共 355 页
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
274
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
第 285 页 / 共 355 页
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
275
2005/Q2 © 2005 SAP AG. All rights reserved.
| 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 |
第 286 页 / 共 355 页
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
276
©2005SAPAG.Allrightsreserved. 2005/Q2
| 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 |
第 287 页 / 共 355 页
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.
277
2005/Q2 © 2005 SAP AG. All rights reserved.
第 288 页 / 共 355 页
Unit6: ProfitCenterPlanning AC610
Lesson Summary
You should now be able to:
• modelaplanningprocessinProfitCenterAccountingusingmanualplanning
and formula planning
278
©2005SAPAG.Allrightsreserved. 2005/Q2
第 289 页 / 共 355 页
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
279
2005/Q2 © 2005 SAP AG. All rights reserved.
第 290 页 / 共 355 页
UnitSummary AC610
280
©2005SAPAG.Allrightsreserved. 2005/Q2
第 291 页 / 共 355 页
AC610 Test Your Knowledge
Test Your Knowledge
267
1. Therearenorestrictionswithregard tocopyingplanninglayoutsinProfit
Center Accounting.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
2. Planningdatacannotbetransferredfromcostingbasedprofitabilityanalysis
toProfitCenterAccountingbecausetherearenovaluefieldsinProfitCenter
Accounting.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
3. Youcannotuploadplanning datatoProfit CenterAccountingfromExcel
becauseplanningdatacanbecopiedfromCostCenterAccounting.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
281
2005/Q2 © 2005 SAP AG. All rights reserved.
第 292 页 / 共 355 页
TestYourKnowledge AC610
Answers
268
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.
282
©2005SAPAG.Allrightsreserved. 2005/Q2
第 293 页 / 共 355 页
Unit 7
Information System
269
ThisunitprovidesanoverviewofthereportingtoolsthatareusedinProfitCenter
Accounting. Italsoexplainshowtodefinedrilldownreports.
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...............................................................284
Exercise 14: Overview.....................................................287
Lesson: Reporting with Drilldown Reporting ................................293
Exercise 15: Reporting with Drilldown Reporting ......................303
283
2005/Q2 © 2005 SAP AG. All rights reserved.
第 294 页 / 共 355 页
Unit7: InformationSystem AC610
Lesson: Overview
Lesson Duration: 30 Minutes
270
Lesson Overview
YoutestthereportingtoolsinProfitCenterAccounting.
Lesson Objectives
After completingthislesson, you will beable to:
• usethestandardreportsanddefineyourownbasicandform-basedreports
• use a drilldown report
Explainthecontentfromabusinessperspectiveusingthetechnicalsettingsinthe
system.
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.
284
©2005SAPAG.Allrightsreserved. 2005/Q2
第 295 页 / 共 355 页
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.
285
2005/Q2 © 2005 SAP AG. All rights reserved.
第 296 页 / 共 355 页
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.
286
©2005SAPAG.Allrightsreserved. 2005/Q2
第 297 页 / 共 355 页
AC610 Lesson: Overview
Exercise 14: Overview
273
Exercise Duration: 20 Minutes
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
287
2005/Q2 © 2005 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Period | 1 – 12 |
| Fiscal Year | Current fiscal year |
| Plan Version | 0 |
| ProfitCenter Group | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
第 298 页 / 共 355 页
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?
288
©2005SAPAG.Allrightsreserved. 2005/Q2
第 299 页 / 共 355 页
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
289
2005/Q2 © 2005 SAP AG. All rights reserved.
| 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 |
第 300 页 / 共 355 页
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
290
©2005SAPAG.Allrightsreserved. 2005/Q2
第 301 页 / 共 355 页
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##.
291
2005/Q2 © 2005 SAP AG. All rights reserved.
第 302 页 / 共 355 页
Unit7: InformationSystem AC610
Lesson Summary
You should now be able to:
• usethestandardreportsanddefineyourownbasicandform-basedreports
• use a drilldown report
292
©2005SAPAG.Allrightsreserved. 2005/Q2
第 303 页 / 共 355 页
AC610 Lesson: Reporting with Drilldown Reporting
Lesson: Reporting with Drilldown Reporting
Lesson Duration: 55 Minutes
279
Lesson Overview
Youdefinebasicandform-baseddrilldownreports.
Lesson Objectives
After completingthislesson, youwillbeable to:
• defineyourownbasicandform-baseddrilldownreports
Explainthecontentfromabusinessperspectiveusingthetechnicalsettingsinthe
system.
Business Example
Managementwouldliketoknowabouttheoptionsthatareavailableforselecting
data with drilldown reports.
Figure 92: Interactive Reporting: Drilldown Reporting
293
2005/Q2 © 2005 SAP AG. All rights reserved.
第 304 页 / 共 355 页
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.
294
©2005SAPAG.Allrightsreserved. 2005/Q2
第 305 页 / 共 355 页
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.
295
2005/Q2 © 2005 SAP AG. All rights reserved.
第 306 页 / 共 355 页
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).
296
©2005SAPAG.Allrightsreserved. 2005/Q2
第 307 页 / 共 355 页
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.
297
2005/Q2 © 2005 SAP AG. All rights reserved.