第 235 页 / 共 339 页
AC610 Lesson: Integrated Planning
SavethedatabychoosingtheUpdateRun icon.
a) Accounting→Controlling→CostCenterAccounting→Planning→
Cost and Activity Inputs→ Change
Forthis,uselayout1-101. Accesstheentryscreenwiththefollowing
data:
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Cost center T91##
Cost Element From 410000
Cost Element To 430000
Click the Overview screen icon.
Enterthefollowingprimarycostsinthelayout:
Cost element Fixed PlannedCosts
415000 36,000.00
430000 180,000.00
SavethedatabychoosingtheUpdateRunicon.
3. In the information system for Profit Center Accounting, call the
list-orientated report Profit Center Group: Plan/Plan/Variancewith 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 GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
Continued on next page
227
2005/Q2 © 2006 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Cost center | T91## |
| Cost Element From | 410000 |
| Cost Element To | 430000 |
| Cost element | Fixed PlannedCosts |
|---|---|
| 415000 | 36,000.00 |
| 430000 | 180,000.00 |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version (1) | 0 |
| Plan Version (2) | 610 |
| Profit Center | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
第 236 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
What do you discover?
____________________________________________________________
____________________________________________________________
a) PCA:InformationSystem→ReportsforProfitCenterAccounting→
List-OrientatedReports→ProfitCenterGroup: Plan/Plan/Variance
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version (1) 0
Plan Version (2) 610
Profit Center GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
What do you discover?
ThecostsofcostcenterT91##werepostedonlinetoprofitcenter91##
sincetheonlinetransferofplanningdataissetinversion0.
Task 3:
EnterplanningdatainthecostplanningofCostCenterAccountinginVersion610.
1. Enter primary costs for cost center T92##.
Forthis,uselayout1-101. Accesstheentryscreenwiththefollowingdata:
Field Name Values
Version 610
Period 1 - 12
Fiscal Year Current fiscal year
Cost center T92##
Cost Element From 410000
Cost Element To 430000
Enterthefollowing primary costsinthelayout.
Continued on next page
228
©2006SAPAG.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 | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
| Field Name | Values |
|---|---|
| Version | 610 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Cost center | T92## |
| Cost Element From | 410000 |
| Cost Element To | 430000 |
第 237 页 / 共 339 页
AC610 Lesson: Integrated Planning
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version (1) 0
Plan Version (2) 610
Profit Center GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
What do you discover?
____________________________________________________________
____________________________________________________________
a) Accounting→Controlling→CostCenterAccounting→Planning→
Cost and Activity Inputs → Change
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version (1) 0
Plan Version (2) 610
Profit Center GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
Enterthefollowingprimarycostsinthelayout.
Cost element Fixed PlannedCosts
410000 12.000,-
430000 120.000,-
SavethedatabychoosingtheUpdateRunicon.
Continued on next page
229
2005/Q2 © 2006 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 | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version (1) | 0 |
| Plan Version (2) | 610 |
| Profit Center | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
| Cost element | Fixed PlannedCosts |
|---|---|
| 410000 | 12.000,- |
| 430000 | 120.000,- |
第 238 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
2. In the information system for Profit Center Accounting, call the
list-orientated report Profit Center Group: 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 GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
What do you discover?
__________________________________________________________
a) PCA:InformationSystem→ReportsforProfitCenterAccounting→
List-OrientatedReports→ProfitCenterGroup: Plan/Plan/Variance
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version (1) 0
Plan Version (2) 610
Profit Center GR##
ProfitandLossAccountsGroup 3000000.INT
BalanceSheetAccountGroup 1000000.INT
What do you discover?
Theplannedcostsofversion610werenotpostedonlinetoprofitcenter
92##.
230
©2006SAPAG.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 | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version (1) | 0 |
| Plan Version (2) | 610 |
| Profit Center | GR## |
| ProfitandLossAccountsGroup | 3000000.INT |
| BalanceSheetAccountGroup | 1000000.INT |
第 239 页 / 共 339 页
AC610 Lesson: Integrated Planning
Lesson Summary
You should now be able to:
• usetheintegrated function for transferring planningdata toProfit Center
Accounting
231
2005/Q2 © 2006 SAP AG. All rights reserved.
第 240 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Lesson: Planning Process
Lesson Overview
You plan data in Profit Center Accounting.
Lesson Objectives
After completingthislesson, you will beable to:
• modelaplanningprocessinProfitCenterAccountingusingmanualplanning
and formula planning
Business Example
PlannedoverheadexpensesareallocatedwithinProfitCenterAccounting
Figure 84: Manual Planning - Planning Layouts
Youcanusespecialscreenlayouts-planninglayouts-toentercosts,revenues,
balancesheetvalues,andstatisticalkeyfiguresmanually. Youcanusethestandard
planninglayoutsintheSAPSystemordefineyourownlayouts.
232
©2006SAPAG.Allrightsreserved. 2005/Q2
第 241 页 / 共 339 页
AC610 Lesson: Planning Process
The use of planning layouts for defining planning screens has the following
advantages:
• Youcan definemorethan one lead column.
• Flexible value columns let you:
– Plan more than one column
– Plan quarters, half years, or years
– Centralizeor decentralizeyour planning
– Plan in different currencies
• Youcandefineformulasinindividual columns.
• YoudefineyourplanninglayoutsinCustomizing.
Figure 85: Integration of Microsoft Excel
Theintegrationof MicrosoftExcelintoprofitplanningmeansthatyoucanuse
Excelfunctionssuchasthoseforadditionalcalculations, graphicsandprinting,
while the SAP system ensures the consistency of the data centrally, providing
centralfunctionssuchasderivation andvaluation.
Toperformlocalplanning,youcansaveExcelsheetsthathavebeencreatedinan
SAP system locallyon aPCor laptopand thenwork on themin Excel outside
the SAP environment. The data can then be loaded back into the SAP system
afterwards using the upload function.
IntegratedExcelisbasedontheprinciplethatyoulinkcellsintheSAPplanning
layouts with the cells in the Excel sheet by defining an Excel template in
Customizing.
233
2005/Q2 © 2006 SAP AG. All rights reserved.
第 242 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Thisinvolvesanumber of specialfeatures, whichareexplainedintherelevant
notes in this documentation.
Figure 86: Formula Planning
Theformulaplanningsupportsthemanualplanning. Theformulaplanningallows
youtoutilizemathematicaldependenciestoplancosts/revenues, balancesheet
accounts, and statistical key figures for your profit centers. You can define
the mathematical relationships in the form of formulas in templates that are
independentoftheprofitcenters. Thiswayyoucanusethesameformulasover
and over for different profit centers.
Youcanplancosts/revenues,balancesheetaccounts,andstatisticalkeyfigures.
Youcanusewhateverplanoractualdataavailabletocalculatethese.
You create a templateand assign the required profit centers to it in the master
data maintenance.
Atemplateisevaluatedforaprofitcenter or aprofit center groupbycompany
code.
TheSAP systemappliestheformulasdefinedinthetemplateandusestheseto
calculate the required values. Each individual row in the created template is
calculated for the corresponding profit center. The system creates a planning
record for the cost element/revenue element, the balance sheet item, or the
statisticalkeyfiguresonthecorrespondingprofitcenter.
234
©2006SAPAG.Allrightsreserved. 2005/Q2
第 243 页 / 共 339 页
AC610 Lesson: Planning Process
Figure 87: Formula Planning – Template Definition
Youcancreatetemplatesfor theformulaplanning of profit centersinthePCA
environment.
In the application menu of Profit Center Accounting, chooseMaster Data →
ProfitCenter→IndividualProcessing→Change. Intheinitialscreen,selectthe
profitcentertowhichyouwanttoassignatemplate. Youcanalsousecollective
processingtoassigntemplatesintheprofitcentermasterrecord.
Enter the name of the template you want to use for the planning on the profit
centerintheTemplatefieldoftheIndicatorstabpage. Alltemplatescreatedinthe
PCA template environment can be used.
235
2005/Q2 © 2006 SAP AG. All rights reserved.
第 244 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Figure 88: Copy Plan Template
Thisfunctionletsyoucopyexistingtransactiondataasatemplateforanewplan.
Forexample,itmightbeusefultousetheactualvaluesofthecurrentfiscalyear
asabasisforplanningthecomingyear. Theonlythingsyouneedtospecifyare
the source and target data parameters.
Youcanrevaluatetheselectedsourcedata,bothintermsofamountsandquantities,
whenyoucopyit toyour plan. Todoso, enter revaluation factorsin thefields
provided. Iftheavailableentrypossibilitiesareinsufficient,youcandefineauser
exittorevaluatethedataaccordingtoyourneeds. Ifyouspecifyrevaluation,you
cancorrectthevaluesbyaddingorsubtractingacertainpercentage. Forexample,
youcancreateaplanfor1999bycopyingthe1998actualdataandadding5%. To
dothis,youneedtoenterarevaluationfactorwhichcallsfora5%increase.
Youalsoneedtospecifywhetherthesystemshouldoverwriteexistingdatainthe
targetplan,orwhetheritshouldbeaddedtothedatayoucopy.
Sourceplandata: Hereyouentertherecordtype,companycode,andfiscalyear
you want to plan. When copying planning data, remember to specify the plan
versionfromwhichyouwanttocopythedata. Withthisrecordtype,youspecify
whether youarecopyingplan or actual values.
Target data: Enter therecordtype, companycodeandfiscal year towhichyou
want to copythedata, and specify theplan version.
236
©2006SAPAG.Allrightsreserved. 2005/Q2
第 245 页 / 共 339 页
AC610 Lesson: Planning Process
Figure 89: Plan allocations
Theassessmentandthedistributionfunctionisthesameforactualandplanning
data.
Plan closingconsistsof the following functions:
• plan assessment
• plan distribution.
Youstartplanassessmentorplandistributionwhenyouhavefinishedplanning
completely. ThetransferofallplannedvaluesfromotherCOapplicationswhich
aretobetransferredtoProfitCenterAccountingmustbecomplete,asmustdirect
planning in Profit Center Accounting.
Theallocationfunctions“assessment”and“distribution”letyoutransferplanor
actualtransactions(revenues,costs,balancesheetitems)fromoneprofitcenter
to other profit centers.
In Profit Center Accounting, you can only allocate data within one company
code. Inaddition,eachassessmentordistributioncyclemustbeassignedtoone
company code only.
Transaction dataisalwaysassessed with oneassessment cost element. During
distribution, both credit and debit postingsaremadeto the sameaccount. You
can use other posted values, quantities or statistical key figures as a basis for
allocations in Profit Center Accounting.
237
2005/Q2 © 2006 SAP AG. All rights reserved.
第 246 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
238
©2006SAPAG.Allrightsreserved. 2005/Q2
第 247 页 / 共 339 页
AC610 Lesson: Planning Process
Exercise 13: Planning Process
Exercise Objectives
After completingthisexercise, youwillbeableto:
• enter revenues, costs, andstatistical key figures manually at profit center
level
• defineandexecuteformulaplanninginProfitCenterAccounting
Business Example
Inplanning, thenumber of team membersisentereddirectlyatthelevelofthe
profit center using statistical key figures.
Manuallyenteredplanningdataforthecostandrevenueplanningisalsoincluded
inProfitCenterAccountinginadditiontotheplanningdataalreadytransferred
from Cost Center Accounting.
Revenue planning is automated using formula planning. The revenue should
be posted as an approximate value as the planned revenue per team member
multiplied by the number of team members.
Theresultingplanscenarioshouldalsobeusedintheparallelplanscenario.
Task 1:
Enterthenumberofteammembersatprofitcenterlevel.
1. SettheplannerprofileAC610-##inprofitcenterplanning.
2. Enterthenumberofteammembersforprofitcenters91##and92##. Usethe
followingparametersforaccessinglayoutSTAT##:
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Company Code 1000
Profit Center Group PLAN##
Statistical Key Fig. 9100
Enter thefollowingdata in layout STAT##.
Continued on next page
239
2005/Q2 © 2006 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit Center Group | PLAN## |
| Statistical Key Fig. | 9100 |
第 248 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Profit Center Quantity
91## 100
92## 25
Savethedatabychoosing theUpdateRun icon.
3. IntheinformationsystemforProfitCenterAccounting,callthelist-orientated
reportProfitCenter: StatisticalKeyFigureswiththefollowingparameters.
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version 0
Profit Center Value 91##
StatisticalKeyFigureValue 9100
Howmanyteammembersareassignedintheplantoprofitcenter91##?
____________________________________________________________
4. Repeatthereportcallforthereportfromtask3-1-3forprofitcenter92##.
Howmanyteammembersareassignedintheplantoprofitcenter92##?
Task 2:
Thecostsofgoodssoldareplanneddirectlymanuallyatthelevelofprofitcenter
sales 91##.
1. Enterthecostsofgoodssoldundercostelement893015manuallyincost
planning. Uselayout8A-101withthefollowingparameters.
Field Name Values
Version 0
Period 1 - 12
Continued on next page
240
©2006SAPAG.Allrightsreserved. 2005/Q2
| Profit Center | Quantity |
|---|---|
| 91## | 100 |
| 92## | 25 |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version | 0 |
| Profit Center Value | 91## |
| StatisticalKeyFigureValue | 9100 |
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
第 249 页 / 共 339 页
AC610 Lesson: Planning Process
Field Name Values
Fiscal Year Current fiscal year
Company Code 1000
Profit Center 91##
Account number 893015
Enter the costs of goods sold
Profit Center InProfitCenterCurrency
91## 4.800.000,-
SavethedatabychoosingtheUpdateRun icon.
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?
____________________________________________________________
____________________________________________________________
Continued on next page
241
2005/Q2 © 2006 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit Center | 91## |
| Account number | 893015 |
| 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 |
第 250 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Which origin object returns the planned costs for cost elements 415000
and 430000?
____________________________________________________________
____________________________________________________________
Whywastheplanningdatapostedwhenthereweredifferentoriginobjects?
____________________________________________________________
____________________________________________________________
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.
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
Entertheplannedaveragerevenueperteammember.
Hint: Notethatrevenuesmustbeenteredwithanegativesign.
Continued on next page
242
©2006SAPAG.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 |
第 251 页 / 共 339 页
AC610 Lesson: Planning Process
Account number InProfitCenterCurrency
800000 -120.000,-
Save the data
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
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:
Continued on next page
243
2005/Q2 © 2006 SAP AG. All rights reserved.
| Account number | InProfitCenterCurrency |
|---|---|
| 800000 | -120.000,- |
| Field Name | Values |
|---|---|
| Type | P&L account |
| Object | 800000 |
第 252 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
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, insert the“QtySTATKeyFigure”function with thefollowing
parameters:
Field Name Values
Company Code 1000
1
1. PeriodicCalc. ofValues,
2. Total Fisc Year
0: Actual, 1: Planned 1
Profit Center Profit Center
Statistical key fig. 9100
Version 0
Fiscal Year Current fiscal year
Check thefunctionandconfirm withEnter.
Hint: Intheformulaeditoryoucannowseethecompleteformula
whichmultipliestwofunctionvalues. Thefirstfunctionreturnsthe
plannedrevenuesofprofitcenter93##,whereasthesecondfunction
returnsthequantityofthestatisticalkeyfigure9100. Thefunction
takesthequantityof thestatisticalkeyfigurefrom therespective
profitcenterinwhosemasterrecordthetemplateisdefined.
Confirm the formula in the editor.
Continued on next page
244
©2006SAPAG.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 |
| 0: Actual, 1: Planned | 1 |
| Profit Center | Profit Center |
| Statistical key fig. | 9100 |
| Version | 0 |
| Fiscal Year | Current fiscal year |
第 253 页 / 共 339 页
AC610 Lesson: Planning Process
Save the SALES## template.
4. AssigntemplateSALES##tothemasterrecordsofprofitcenter91##and
92##.
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
Displaycostelement800000. Whichplanningdatahasbeenpostedtoprofit
center 91## and profit center 92##?
____________________________________________________________
____________________________________________________________
6. Executetheformulaplanningin companycode1000fortheprofit center
groupPLAN## inall theperiodsof thecurrentfiscal yearinversion 0in
update mode.
Continued on next page
245
2005/Q2 © 2006 SAP AG. All rights reserved.
| 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 |
第 254 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
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 howeachof thesevaluescomesabout.
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?
____________________________________________________________
2. Copytheplannedcostsandrevenuesofprofitcenter91##fromversion0to
version610. Restricttheselectiontoallperiodsofthecurrentfiscalyearin
companycode1000. Thecopieddatashouldreplaceexistingdataandbe
increasedby2%. Intheselectioncriteria,restricttheaccountstobecopied
to account group 3000000.INT.
Continued on next page
246
©2006SAPAG.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 |
第 255 页 / 共 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?
247
2005/Q2 © 2006 SAP AG. All rights reserved.
第 256 页 / 共 339 页
Unit6: ProfitCenterPlanning AC610
Solution 13: Planning Process
Task 1:
Enterthenumberofteammembersatprofitcenterlevel.
1. SettheplannerprofileAC610-##inprofitcenterplanning.
a) PCA: Planning→ Set Planner Profile
Enter AC610-## and confirm.
2. Enterthenumberofteammembersforprofitcenters91##and92##. Usethe
followingparametersforaccessinglayoutSTAT##:
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Company Code 1000
Profit Center Group PLAN##
Statistical Key Fig. 9100
Enter the following data in layout STAT##.
Profit Center Quantity
91## 100
92## 25
Continued on next page
248
©2006SAPAG.Allrightsreserved. 2005/Q2
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit Center Group | PLAN## |
| Statistical Key Fig. | 9100 |
| Profit Center | Quantity |
|---|---|
| 91## | 100 |
| 92## | 25 |
第 257 页 / 共 339 页
AC610 Lesson: Planning Process
SavethedatabychoosingtheUpdateRun icon.
a) PCA:Planning®StatisticalKeyFigures®Change
Enter the following data:
Field Name Values
Version 0
Period 1 - 12
Fiscal Year Current fiscal year
Company Code 1000
Profit CenterGroup PLAN##
Statistical Key Fig. 9100
Click the Overview screen icon.
Enter thefollowingdatain layout STAT##.
Profit Center Quantity
91## 100
92## 25
SavethedatabychoosingtheUpdateRunicon.
3. IntheinformationsystemforProfitCenterAccounting,callthelist-orientated
reportProfitCenter: StatisticalKeyFigureswiththefollowingparameters.
Field Name Values
Controlling Area 1000
Fiscal Year Current fiscal year
Period 1 - 12
Plan Version 0
Profit CenterValue 91##
StatisticalKeyFigureValue 9100
Howmanyteammembersareassignedintheplantoprofitcenter91##?
Continued on next page
249
2005/Q2 © 2006 SAP AG. All rights reserved.
| Field Name | Values |
|---|---|
| Version | 0 |
| Period | 1 - 12 |
| Fiscal Year | Current fiscal year |
| Company Code | 1000 |
| Profit CenterGroup | PLAN## |
| Statistical Key Fig. | 9100 |
| Profit Center | Quantity |
|---|---|
| 91## | 100 |
| 92## | 25 |
| Field Name | Values |
|---|---|
| Controlling Area | 1000 |
| Fiscal Year | Current fiscal year |
| Period | 1 - 12 |
| Plan Version | 0 |
| Profit CenterValue | 91## |
| StatisticalKeyFigureValue | 9100 |
第 258 页 / 共 339 页
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
250
©2006SAPAG.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 |
第 259 页 / 共 339 页
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
251
2005/Q2 © 2006 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 |
第 260 页 / 共 339 页
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
252
©2006SAPAG.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 |
第 261 页 / 共 339 页
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
253
2005/Q2 © 2006 SAP AG. All rights reserved.
| Account number | InProfitCenterCurrency |
|---|---|
| 800000 | -120.000,- |
| Field Name | Values |
|---|---|
| Type | P&L account |
| Object | 800000 |
第 262 页 / 共 339 页
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, insert the“QtySTATKeyFigure”function with thefollowing
parameters:
Field Name Values
Company Code 1000
1
1. PeriodicCalc. ofValues,
2. Total Fisc Year
Continued on next page
254
©2006SAPAG.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 |
第 263 页 / 共 339 页
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
255
2005/Q2 © 2006 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 |