第 232 页 / 共 483 页
Unit4: ActualData AC605
For the nonvaluated sales order stock, you always need to use a cost bearing
andrevenuebearingsalesorderitem. Consequently, incomplexmake-to-order
manufacturing,youarealwayscontrollingatthesalesorderitemlevel.
SAPrecommendsthatyouworkwiththevaluatedsalesorderstocks.
Figure 88: Top Down Distribution
In Profitability Analysis, sales revenues, sales deductions, and costs of goods
manufacturedarenormallystoredat thecustomerorproductlevel. Noticethat
many business transactions, such as freight invoices, insurance expenses, or
advertisingcannoteasilybeassignedtosuchanextensivelevelinCO-PAAsa
result,theseneedtobepostedatasummarizedlevel,suchasthedivision,sales
organization, or company-code level.
Top down distribution of actual datais a periodic function that enablesyou to
distributethisaggregateddatatoextensivelevels,suchasthedivisionlevelorthe
customerlevelinCO-PA,basedonreferenceinformation,suchasthedatafrom
thepreviousyear. Thisfunctionworksinthesamewayastopdowndistribution
of plan data.
218
©2009SAPAG.Allrightsreserved. 2009
第 233 页 / 共 483 页
AC605 Lesson: Value Flow from Cost Object CO
Youcanselectthevaluespostedtoanyprofitabilitysegmentsandvaluefieldsand
thendistributethisdatatoapredefineddistributionlevel. Youcanusetheexisting
actualorplandataasthebasisforthisdistribution. Youcanalsodistributeperiod
byperiodoraggregatetheperiodvaluestosmoothoutvariances.
Note: Top-down distribution in Actual can only be executed in the
cost-basedCO-PA.Incomparison tothetop-downdistributionof plan
data,hereonlythe“notassigned”methodisavailable.
Figure 89: Periodic Valuation
If you use parallel valuation, which means the legal valuation together with
profit-centervaluation, youcanvaluatethevaluationviewsagainseparatelyin
periodic valuation. If you want to valuate only one valuation view again, you
canconsiderablyreducetherun-timeofthenewvaluationandthedatavolume
by making this setting.
Thenewselectioncriteria,Documentnumber,andReferencedocumentnumber,
allowyoutovaluateagainselecteddocuments,referencedocuments,orintervals
between these. You can also exclude documents or intervals from the new
valuation.
219
2009 © 2009 SAP AG. All rights reserved.
第 234 页 / 共 483 页
Unit4: ActualData AC605
Schedule Manager
Figure 90: Scope of the Schedule Manager
Anumberofperiodictasksareexecutedonaregularbasis,whichmeansdaily,
weekly, or monthly in the SAP System. One example of this kind of task is
period-endclosing,asthisrequirestheprocessingofalargenumberofindividual
objectsatparticularpointsintime. Thisprocessissupportedbytheindividual
components of the schedule manager.
Benefits include:
• Theclosingprocessismoretransparentandeasytohandle.
• Event-drivenprocessingmeansthattheSAPsystemautomaticallyperforms
the necessary steps.
• Monitoringthecompleteprocessisuser-friendly.
• Worklist-driven error analysis and integrated error-handling procedures
reducethetime needed for error correction.
• Totalprocessingtimeisminimizedbyoptimizedworklistprocessing.
220
©2009SAPAG.Allrightsreserved. 2009
第 235 页 / 共 483 页
AC605 Lesson: Value Flow from Cost Object CO
Figure 91: Schedule Manager: Components
Features
Flow Definition: In a flow definition you can link thetasksto oneanother if
theyarerelatedoriftheyshouldbeprocessedinaworklist. Youcan,asaresult,
scheduleaflowdefinition asataskinthescheduler.
Scheduler: Inthescheduler,youcanscheduletasksinastructuretree. Youcan
usedrag-and-dropinadailyoverviewtoenablethesystemtoexecutethetasks
at a certain time.
Monitor: Providesanoverviewofthescheduledtasksduringandafterprocessing.
You can correct faulty objects in a worklist.
Worklist: Objects that are to be processed in a processing step sequence are
managed in the worklist. The worklist monitor presents information, such as
theobjectsthatwereprocessedwithouterrorsandtheobjectsthat couldnot be
processed. You can displayinformation on the causeof errors andin thisway
controlthewayinwhichtheobjectisprocessedfurther. Theworklistensuresthat
whenaprocessingstepsequenceisprocessedagain,thesystemonlyprocessesthe
objectsthathaderrorsorwhichyoumanuallyinstructedthesystemtoreprocess.
Definetheprocessingstepsequenceintheflowdefinition.
221
2009 © 2009 SAP AG. All rights reserved.
第 236 页 / 共 483 页
Unit4: ActualData AC605
Figure 92: Schedule Manager - Process
Task Schedule: A structured group of tasks that are executed periodically and
possiblybymorethanoneusertocompleteacertainprocess,suchasperiod-end
closing.
Scheduler: To enable the system to start tasks at certain times, you need to
schedulethetasksfromthetasklistinthedailyoverviewusingdraganddrop.
• Usedraganddroptoscheduleataskfromthetasklistinthedailyoverview.
• Transactionsandprogramscanonlybestarteddirectlybytheuser.
TheMonitor: Tool todisplayalltheinformationonanactiveorcompletedjob
that was scheduled in Scheduler.
FlowstepsincludeschedulingprogramswithvariantsinthejobcontroloftheSAP
systemandinteractionwiththeusersintheformofane-mailwithinformation.
Aflowdefinition(combinationofflowsteps)isattachedtothetaskscheduleof
the scheduler. Then, the execution of the flow steps is scheduled in the daily
overview of the flow steps.
222
©2009SAPAG.Allrightsreserved. 2009
第 237 页 / 共 483 页
AC605 Lesson: Value Flow from Cost Object CO
Lesson Summary
You should now be able to:
• Explain variance calculation
• Work with the schedule manager
223
2009 © 2009 SAP AG. All rights reserved.
第 238 页 / 共 483 页
UnitSummary AC605
Unit Summary
You should now be able to:
• Explain the flowof actual data in CO-PA
• List the sources of value fields
• UnderstandthedataflowfromsalesordermanagementtoCO-PA
• Outline the concept of a condition type
• Explain thetransfer and allocation of costs
• Explain the settlement of orders
• Explain direct postings
• Make automatic posting to CO-PA
• Explain variance calculation
• Work with the schedule manager
224
©2009SAPAG.Allrightsreserved. 2009
第 239 页 / 共 483 页
AC605 Test Your Knowledge
Test Your Knowledge
1. anddiscountsaretransferredtoprofitabilitysegmentsin
ProfitabilityAnalysisatthepointofbillinginSalesOrderManagement.
Fillintheblankstocompletethesentence.
2. Howare production variances calculated?
3. OneoftheimportanttasksinCustomizingforthecosting-basedCO-PAisto
assignyourcostsandrevenuestotherequiredvaluefields.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
4. inthecosting-basedCO-PAcontaintheamounts
and quantities on whichyou want to report.
Fillintheblankstocompletethesentence.
5. ThecentraldocumentinSDisthe .
Fillintheblankstocompletethesentence.
6. What is a condition type?
7. Abusinesstransaction isnormallyconcluded in salesorder management
with the .
Fillintheblankstocompletethesentence.
8. Theconditiontype, transferstheCOGSpostedatthetimeof
goods issue to CO-PA.
Fillintheblankstocompletethesentence.
225
2009 © 2009 SAP AG. All rights reserved.
第 240 页 / 共 483 页
TestYourKnowledge AC605
9. YoucantransfertheoverheadcostsfromCostCenterAccountingeitheron
anactivity-allocationor a basis.
Fillintheblankstocompletethesentence.
10. What all can you settle in SAP R/3?
11. The applicationcomponent
providesanalternativeformofoverhead control.
Fillintheblankstocompletethesentence.
12. In , costs are settled to the
settlementcostelementspecifiedinthesettlementstructure.
Fillintheblankstocompletethesentence.
13. Directpostingenablesyoutopostdirectcosts,revenue,andsalesdeductions
to .
Fillintheblankstocompletethesentence.
14. Automatic postings, such as the ones generated in Materials
Management, can be passed on to Profitability Analysis using the
function(s).
Fillintheblankstocompletethesentence.
15. FordirectpostingsinFinancialAccounting, alltheassignmentsofvalues
and the quantities to the value fields in the
CO-PAaredefinedinthePAtransferstructure, FI.
Fillintheblankstocompletethesentence.
16. Revenueelementsthatreceiveautomaticpostingsareassignedtothevalue
fieldsintheaccount-basedCO-PAinthePAtransferstructure,FI.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
226
©2009SAPAG.Allrightsreserved. 2009
第 241 页 / 共 483 页
AC605 Test Your Knowledge
17. Youcansettleortransfer
calculatedinProductCost Controlling for bothfinalproductionordersas
wellasrunscheduleheaders,settledperiodicallytoCO-PA.
Fillintheblankstocompletethesentence.
18. Inthescheduler,youcanschedulethetasksina .
Fillintheblankstocompletethesentence.
19. EveryvariancecategorymustberepresentedinthePAtransferstructure.
Determinewhetherthisstatementistrueorfalse.
□ True
□ False
20. Whenyouperformtheschedulingprocess,youwillbe:
Choosethecorrectanswer(s).
□ A Creating task lists
□ B Scheduling tasks in daily overview
□ C Monitoring the execution of tasks
□ D Displaying results
227
2009 © 2009 SAP AG. All rights reserved.
第 242 页 / 共 483 页
TestYourKnowledge AC605
Answers
1. Revenues and discounts are transferred to profitability segments in
ProfitabilityAnalysisatthepointofbillinginSalesOrderManagement.
Answer: Revenues
2. Howare production variances calculated?
Answer: Theproductionvariancesarecalculatedasthedifferencebetween
theactualcostsofgoodsmanufacturedandstandardcosts.
3. OneoftheimportanttasksinCustomizingforthecosting-basedCO-PAisto
assignyourcostsandrevenuestotherequiredvaluefields.
Answer: True
OneoftheimportanttasksinCustomizingforthecosting-basedCO-PAisto
assignyourcostsandrevenuestotherequiredvaluefields.
4. Valuefieldsinthecosting-basedCO-PAcontaintheamountsandquantities
on which you want to report.
Answer: Value fields
5. Thecentral document inSD isthesalesorder.
Answer: sales order
6. What is a condition type?
Answer: Aconditiontypeisarepresentationinthesystemofsomeaspectof
yourdailypricingactivities,suchasdiscountorsurcharge,whichoccursin
your business transactions.
7. A businesstransaction isnormally concluded insales order management
with the billing document.
Answer: billing document
8. Theconditiontype,VPRS,transferstheCOGSpostedatthetimeofgoods
issue to CO-PA.
Answer: VPRS,
228
©2009SAPAG.Allrightsreserved. 2009
第 243 页 / 共 483 页
AC605 Test Your Knowledge
9. YoucantransfertheoverheadcostsfromCostCenterAccountingeitheron
an activity-allocation or a periodic basis.
Answer: periodic
10. What all can you settle in SAP R/3?
Answer: InSAPsystem,yousettleinternalorders(CO),salesorders(SD),
projects(PS), aswell asproduction orders.
11. TheActivity-BasedCostingapplicationcomponentprovidesanalternative
form of overhead control.
Answer: Activity-Based Costing
12. In account-based CO-PA, costsaresettled to the settlement cost element
specified in the settlement structure.
Answer: account-based CO-PA
13. Directpostingenablesyoutopostdirectcosts,revenue,andsalesdeductions
to profitability segments.
Answer: profitability segments
14. Automaticpostings, suchastheonesgeneratedinMaterialsManagement,
canbepassedontoProfitabilityAnalysisusingtheautomaticPAassignment
function (s).
Answer: automatic PA assignment
15. FordirectpostingsinFinancialAccounting, all theassignmentsofvalues
andthequantitiestothevaluefieldsinthecosting-basedCO-PAaredefined
in the PA transfer structure, FI.
Answer: costing-based
16. Revenueelementsthatreceiveautomaticpostingsareassignedtothevalue
fieldsintheaccount-basedCO-PAinthePAtransferstructure,FI.
Answer: False
Thecostorrevenueelementsthatreceiveautomaticpostingsareassignedto
thevaluefieldsinthecosting-basedCO-PAinthePAtransferstructureFI,
which you maintain in Customizing.
229
2009 © 2009 SAP AG. All rights reserved.
第 244 页 / 共 483 页
TestYourKnowledge AC605
17. YoucansettleortransfertheproductionvariancescalculatedinProductCost
Controllingforbothfinalproductionordersaswellasrunscheduleheaders,
settled periodically to CO-PA.
Answer: the production variances
18. Inthescheduler,youcanschedulethetasksinastructuretree.
Answer: structure tree
19. EveryvariancecategorymustberepresentedinthePAtransferstructure.
Answer: True
Each variance category must be represented in the PA transfer structure.
Thevariancecategoriesarespecifiedbythesystemandenteredunderthe
source section.
20. Whenyouperformtheschedulingprocess,youwillbe:
Answer: A, B, C
Whenyouperformtheschedulingprocess,youperformactivities,suchas
createtasklists,scheduletasksindailyoverview,monitortheexecutionof
tasks, and analyze results.
230
©2009SAPAG.Allrightsreserved. 2009
第 245 页 / 共 483 页
第 246 页 / 共 483 页
第 247 页 / 共 483 页
Unit 5
Planning
Unit Overview
ThisunithelpsyoutounderstandtheconceptsofplanninginCO-PAandcreatea
salesplanusingaplanninglevelandplanningpackages. Theunitexplainshow
todefineaplanninglayoutandenterdata. Inaddition,thisunitdescribeshowto
executeautomaticplanningfunctions,integratetheplandatawithinManagement
Accounting,anddefinetheplanningaidstoenableplanning.
Unit Objectives
After completing thisunit, you will beableto:
• Outlinetheoverall processflowofprofitplanning
• Work with planning layouts
• Plan target values
• Performtopdowndistributionof planningdata
• Changeand deleteplandataandcreateforecasts
• Explain the integrated transfer of plan data
Unit Contents
Lesson: The Profit Planning Process ........................................232
Lesson: Planning Methods ....................................................241
Exercise 13: Manual Planning Functions ...............................261
Exercise 14: Automatic Planning Functions ............................275
Exercise 15: Integrated Planning Functions............................283
231
2009 © 2009 SAP AG. All rights reserved.
第 248 页 / 共 483 页
Unit5: Planning AC605
Lesson: The Profit Planning Process
Lesson Overview
This lesson explains how to design the overall process of profit planning.
Furthermore,thebasicterminologyofCO-PAplanningaswellastheprocedure
forcreatingaplanninglevelandworkingwithplanninglayoutswillbeintroduced.
Lesson Objectives
After completingthislesson, you will beable to:
• Outlinetheoverall processflowofprofit planning
• Work with planning layouts
Business Example
The management of your company would like to implement a profitability
accountingapplicationintheSAPsystem. Asamemberofyourtheprojectteam,
youaresupposedtoadviseonthequestionof whether toimplementCO-PAor
EC-PCAintheSAPsystem. Youthenwillberesponsibleforimplementingthe
selected applications.
SamSalesandRandyRevenuewouldliketousetheCO-PAmoduletoplanthe
salesof the two mainproduct lines of thecompany, bicyclesand motorcycles.
Samwantstoplanhissalesbycustomerandproduct. Hewouldliketoplanthe
salesquantitiesandsellingpricesforeachcustomer/productcombinationandhe
expectsthesystemtocalculatetheplannedrevenuefromtheresults. Randywants
to plan his salesby product group and then he would liketo use thesystem to
automaticallydistributetheplannedvaluestotheproductlevelusingareasonable
allocationbasis. Mr. Millerisonlyinterestedintheplanningquantityandtheplan
revenues. Theproductmanagerwouldliketoperform“What-if”analysesonthe
planningdataforvariousscenariosinordertoanalyzepossibleeffectsofstrategic
decisionsonrevenues. For example, theymightwanttoanalyzetheeffectthat
price increases might have on revenue. Peter Plant wants to use the projected
sales quantities from CO-PA to plan his production and material procurement
schedules. HewouldliketohaveaccesstotheCO-PAplanvaluesinSalesand
OperationsPlanning. For thisreason, planning quantities, prices, and revenue
at the product/customer level is required. Planning at the product group level
is required with systematic distribution of values to the product level. Mass
changestoplanvaluesarerequiredforanalyzingthedifferentbusinessscenarios.
TransferringtheCO-PAplandatatoSalesandOperationsPlanningisrequired
to aid production scheduling. For this purpose, you need to know the overall
process of profit planning.
232
©2009SAPAG.Allrightsreserved. 2009
第 249 页 / 共 483 页
AC605 Lesson: The Profit Planning Process
Process Flow of Profit Planning
Figure 93: Planning Functions in a Process View
Salesandprofitplanningisnormallyperceivedasanintegratedprocessinvolving
differentroleswithinprofitabilityand salesaccounting, suchassalesmanager,
regionalmanager,andsalesemployee. Distinctionsareoftenmadebetweenthe
differentapproachesused, suchascentral top downplanningand local bottom
up planning.
TheplanningtoolinProfitabilityAnalysisoffersall thepeopleinvolvedinthe
planningprocessauniform, graphicalplanninginterfacethatisstraightforward
andmodern. Thisinterfaceensuresthatthepoweruser,suchasthecentralplanner
whomodelsandmonitorstheplanningprocess,andoccasional userswhoonly
occasionallyconfirmplanningvaluescanworkinunison.
Because thecontents and the level of information of the individual plans vary
dependingontheroleandtheareaofresponsibility, thePlanningscreenallows
you to structureplanning selectively according to specific planning levels and
planningcontents, and toassign thatplanningstructureto theindividualusers.
Your planning structure is represented in a tree hierarchy. From the initial
Planning screen, you can execute almost all theplanning functions, right from
modelingtheplanningprocessandmonitoringtheplanningtaskstomanualentry
of the planning data.
233
2009 © 2009 SAP AG. All rights reserved.
第 250 页 / 共 483 页
Unit5: Planning AC605
Figure 94: Planning on Different Levels
Figure 95: Overview of Planning Framework
234
©2009SAPAG.Allrightsreserved. 2009
第 251 页 / 共 483 页
AC605 Lesson: The Profit Planning Process
Taking into account a typical salesand profit planning process, a professional
planning tool has to:
• Support theindividualplanning tasksbyguidingtheuserto the planning
levelstheuserneedstoplan. Forexample,akeyaccountmanagerneedsto
planonthekeycustomer,salesorganization,andproductlevel.
• Support the individual planners by providing personalized access to the
required plan datausing planningpackages.
• Provide a set of relevant planning functions, such as valuations and
simulations,toapplytherequiredplanningpackagesusingplanningmethods
and parameters.
Figure96: Manualplanning: Accesstothe OverviewScreen
235
2009 © 2009 SAP AG. All rights reserved.
第 252 页 / 共 483 页
Unit5: Planning AC605
Figure 97: Elements in Planning
PlanninginCO-PAcanbeexecutedonmanydifferent levels. Inthisway, for
example,youcanplanonproductgroupandproductlevel,oncustomer/product
level or simply on customer level. In fact, you can plan on any profitability
segment in CO-PA.
Bydesign,thesystemensuresthatthedataremainsconsistentacrossallthelevels
throughouttheplanningprocess. Becauseallthesubtotalsofthedifferentlevels
add up to totals, the values from the different levels can always be reconciled
althoughchangesarebeingmadeonthedifferentlevelsduringtheprocess.
Forexample,youfirstenterplannedquantitiesatthecustomer/productlevelfor
twocustomersandthreeproducts. Then,bydefinition,thetotalsbyproductwill
coincide with the customer/product information. If additions are made at the
productlevel, theadditionsaredisplayedat thecustomer/productlevelwithan
unassigned customer.
Derivationisautomaticallycarriedout inthebackgroundwhentheplandatais
saved. Thismeansthatthevaluesplannedunderoneormorecharacteristicvalues
arealsoautomaticallysummarizedunderotherhigher-levelcharacteristics.
For example, you haveadded theproductgroup characteristicto the operating
concern. Whenyouplanattheproductlevel,thevaluesareautomaticallyrolled
upundertheappropriateproductgroupsalthoughyoudidnotspecifyaproduct
groupwhenenteringtheplandata. Again,thisroll-uphappensautomaticallyat
every location where the derivation occurs.
236
©2009SAPAG.Allrightsreserved. 2009
第 253 页 / 共 483 页
AC605 Lesson: The Profit Planning Process
Planning Layout
Figure 98: Defining a Planning Layout (1)
Planninglayoutsarecustomizedscreensforenteringplandata. Thedefinitionofa
planninglayoutcontrolsnotonlytheappearanceofthePlanningscreenbutalso
some of the functions. This allows for complete flexibility in controlling the
planning entry process.
Aplanning layout definitionconsistsof threeparts, the general dataselection,
the lead columns, and the value columns. The general data selection is where
the characteristic values are specified that are valid for the entire layout. The
leadcolumnsarewhereadditionalcharacteristicsthataretobeplannedmaybe
specified. Thevaluecolumnscontaincharacteristic/valuefieldcombinations.
The valid values for the special characteristics version, record type (for
costing-based CO-PA), and the plan/actual indicator are required for each
row/column intersection in a planning layout definition. By employing these
properlyinthelayoutdesign,thelayoutscanbecreatedinwhichthevaluescan
beplannedformorethanoneversionatatimeandinwhichactualhistorydata
may be displayed for reference.
Variablesmaybeusedwhendefiningplanning layoutstogivethem maximum
flexibility. Variablescanbeusedforanycharacteristicandtheycanbeinstalled
anywherenecessary,suchasrows,columns,orthegeneraldataselection. Users
willbepromptedtoenterthevaluesforthesevariableswhenplanning.
237
2009 © 2009 SAP AG. All rights reserved.
第 254 页 / 共 483 页
Unit5: Planning AC605
Separateplanninglayoutsarerequiredforcosting-basedCO-PAandaccount-based
CO-PA becauseplanning figureson thetwo sidesof CO-PAare not related or
linkedinanyway. Whendefininglayoutsincosting-basedCO-PA,youneedthe
characteristicrecordtype. Whendefininglayoutsinaccount-basedCO-PA,you
need the characteristic cost element.
Figure 99: Defining a Planning Layout (2)
Ageneralplanninglayoutthatcorrespondstotheselectionsmadeintheplanlevel
and the package can be created automatically. Specific layout features can be
maintained manually.
Therearetwobasicoptionsfordefiningtheleadcolumn(s):
• Each row in the lead column can be defined separately and consists of
a combination of characteristic values (in this case, the columns are
value columns) or each row isa value row (in this case, the columns are
characteristic values).
• The entire lead column can be selected to represent a characteristic (the
columnsarevaluecolumns). Withthisoption,youcanobtainmultiplelead
columns but you cannot hard-code any rows.
Value columns are defined using characteristics, value fields, attributes, or
formulas. Iftheleadcolumncontainsonlycharacteristics,theneachvaluecolumn
must contain at the minimum a value field. The column can also contain the
characteristic valuesthatpertainto the valuefield.
238
©2009SAPAG.Allrightsreserved. 2009
第 255 页 / 共 483 页
AC605 Lesson: The Profit Planning Process
Thefollowingattributescanbetaggedtoeachvaluecolumn:
• Adistributionkeyfordistributingthesummarizedvaluestoperiods.
• Aunitforthevaluefield(eitheracurrencyoraunit).
• Alongtextindicator(indicatingsomelongtextcanexist).
• All characteristics.
Figure 100: Planning Variables
You can define the variables for your planning levels and planning packages.
For example, you use a variable instead of a planning package to specify the
planning period.
Youcanusealltheplanningpackagesforplanningrunsinsubsequentfiscalyears
withouttheneedtochangeeachplanningpackage. Instead,youjustchangethe
variable's characteristic centrally.
YoumaintainvariablesdirectlyfromthePlanningscreenusingEdit→Variable.
239
2009 © 2009 SAP AG. All rights reserved.
第 256 页 / 共 483 页
Unit5: Planning AC605
Lesson Summary
You should now be able to:
• Outlinetheoverall processflowofprofit planning
• Work with planning layouts
240
©2009SAPAG.Allrightsreserved. 2009
第 257 页 / 共 483 页
AC605 Lesson: Planning Methods
Lesson: Planning Methods
Lesson Overview
Thislessonoutlineshowtocreatemanualplandatausingvariousplanningaids.
It also explains how to create forecasts and perform top down distribution of
planningdata. Inaddition,itshowshowtochangeanddeleteplandata.
Lesson Objectives
After completingthislesson, youwillbeable to:
• Plan target values
• Performtopdowndistributionof planningdata
• Changeand deleteplandataandcreateforecasts
• Explain the integrated transfer of plan data
Business Example
The management of your company would like to implement a profitability
accounting application in the SAP system. As a member of the project team,
youaresupposedtoadviseonthequestionofwhether toimplementCO-PAor
EC-PCA in the SAP system. You then will be responsible to implement the
selectedapplications. SamSalesandRandyRevenuewouldliketousetheCO-PA
moduletoplanthesalesofthetwomainproductlinesofthecompany,bicycles
and motorcycles. Sam wants to plan his sales by customer and product. He
wants toplanthe salesquantities and selling prices for each customer/product
combination, and heexpectsthesystemto calculate the planned revenuefrom
the results. Randy wantsto plan his sales by product group and then he wants
to usethesystem to automatically distribute theplanned values tothe product
level using a reasonable allocation basis. Mr. Miller is only interested in the
planquantityandtheplanrevenues. Theproductmanagerwouldliketoperform
what-ifanalysesontheplandataforvariousscenariosinordertoanalyzepossible
effectsofstrategicdecisionsonsales. Forexample,theymightwanttoanalyze
theaffectthatpricingincreasesmighthaveonrevenue. PeterPlantwantstouse
the projected salesquantities from CO-PA to plan his production and material
procurementschedules. HewouldliketohaveaccesstotheCO-PAplanvaluesin
SalesandOperationsPlanning. Forthisreason,planningquantities,prices,and
revenueattheproduct/customerlevelisrequired. Planningattheproductgroup
level isrequiredwiththesystematicdistributionof valuestotheproduct level.
Masschangestoplanvaluesarerequiredtoanalyzedifferentbusinessscenarios.
TransferringCO-PAplandatatoSalesandOperationsPlanningisrequiredtoaid
production scheduling. For thispurpose, youneed toknowtheprofit planning
process and the phases in sales planning.
241
2009 © 2009 SAP AG. All rights reserved.
第 258 页 / 共 483 页
Unit5: Planning AC605
Phases in Sales Planning
Figure 101: Typical Phases in Sales Planning
Thefigureaboveshowsanexampleofonepossibleintegratedplanningprocess
for sales and profit planning.
The process begins with the planning of target values, such as at the material
grouplevel. Averagepricesandcostofgoodsmanufacturedcanbedetermined
at this stage.
In the next planning phase, plan data is distributed top down. The plan data
for material groupsis broken downinto combinations of customer groupsand
products.
In bottom up planning, the plan data can be entered manually for each sales
representativeandthenbroughttogetherinasingleplanversion.
Inthe fourth planning step, theadditional plan datacan betransferredto sales
andprofitplanningfromotherbusinessareas,suchascostcenteraccountingor
incoming orders.
Afterplanninghasbeenfinalized,theplandatacanbetransferredtoproduction
planning,allowingproductionplandatatobereconciledwithsalesplanning.
242
©2009SAPAG.Allrightsreserved. 2009
第 259 页 / 共 483 页
AC605 Lesson: Planning Methods
Planning Target Values
Figure 102: Planning Target Values
At the start of the first planning phase, in which you plan target values, you
define average prices and the cost of goods manufactured. Introducing ratios
helps simplify planning prices manually.
WiththeGoalSeekfunction,youcanenteratargetrevenueandhavethesystem
calculatethe planned price required to attain it.
Figure 103: Planning with Ratios
243
2009 © 2009 SAP AG. All rights reserved.
第 260 页 / 共 483 页
Unit5: Planning AC605
Aratioisaquotientinvolvingtwovaluefields,suchasprice=sales/quantity,and
itcanbeusedasabasisforsimulatingcorrespondingadjustmentsandalterations
of quantities and prices in the planning layout.
YoudefineratioscentrallyinCustomizing. Theycanbeselectedinthesameway
asnormalvaluefieldswhenyoudefinetheplanninglayout.
Ratios or prices are not saved on the database. Instead, they are calculated
dynamicallyfromthequantitiesandvaluesateachplanninglevel. Thisavoidsthe
build-upofredundantdataandensuresaconsistentdataset.
Figure 104: Planning with a Ratio Scheme
Youcansummarizeratiosinaratioscheme. Ratioscanbecombinedintoratio
schemes,whichcanthenbeappliedagainstTheexistingplandataforthepurpose
of valuing the existing plan base values with ratio values or the rates that are
calculatedbasedonspecificreferencedata. Thereferencedatacanbetheactual
dataor thedata fromanother planning version.
Forexample, ifaratioschemecontainsaratioforper-unitprice, youcanusea
ratio scheme to valuate a sales quantity plan and determine the price for each
piece from the actual data.
Youcanuseratioschemesinbothmanualplanningandinautomaticplanning. In
bothcases,youindicatetheratioschemeandthereferencedata(plan/actualdata,
planversion, record type, and referencetimeinterval). In automaticplanning,
ratioschemescanbeappliedusingtheCopyandChangefunctions.
244
©2009SAPAG.Allrightsreserved. 2009
第 261 页 / 共 483 页
AC605 Lesson: Planning Methods
Figure 105: Reaching Objectives Using Goal Seek
YoucanperformdatasimulationsinplanningusingtheGoalSeekfunction. This
functionallowsyoutoenteratargetcontributionmargininmanualplanningand
tohavethesystemcalculatethecorrespondingquantitysold.
Tousethegoalseekfunction, bothsidesmustbemathematicallyrelatedeither
in a formula or a ratio. In the above example, ratios, which are hidden in the
layout,createtherelationshipbetweenthecontributionmarginandthequantity
sold. Tocarryoutthisfunction,firstselectthetworelevantdatacellsandchoose
Edit→GoalSeek. Inthedialogboxthatappears,enterthetargetvalue,suchas
a contribution margin of 120,000. The system then calculates the appropriate
quantity, which is 6000 items in this case.
245
2009 © 2009 SAP AG. All rights reserved.
第 262 页 / 共 483 页
Unit5: Planning AC605
Breakdown of Target Values
Figure 106: Breakdown of Objectives
Youcanuseanextensivetopdowndistributionfunctionavailableinbothmanual
andautomatic planningfor the second planning phase, whichinvolves the top
downdistributionofthetargetvaluestoanextensiveplanninglevel.
Figure 107: Top Down Distribution in Planning
246
©2009SAPAG.Allrightsreserved. 2009
第 263 页 / 共 483 页
AC605 Lesson: Planning Methods
Topdowndistributionisaprocessfordistributingdatathathasbeenplannedat
onelevelinCO-PAtotheadditionallevelsbasedonsomereferencedata,which
canbeplanoractualCO-PAdata. Itcanonlybedoneinautomaticplanning.
Oneexampleofthismightbeplanningvaluesattheproductgrouplevelandthen
distributingthesevaluestotheindividualproductsinagroup. Anotherexample
mightbeplanningvaluesattheproductlevelandthendistributingthevaluesto
the plants from which the products are sold.
Planvaluescanbedistributedstrictlyaccordingtothereferencedatabyperiodor
basedonthereferencedataaggregatedacrosstheperiods. Thelatterhastheeffect
ofequalizingthedistributionpercentagesacrossperiodsforthereceivers.
When performing a top down distribution, you need to specify the field(s) in
the reference data, the values of which should be used as the reference base.
The options are:
• Fixedvaluefield: Thedataofallvaluefieldsisdistributedaccordingtothe
distribution of values of this value field.
• Allvaluefields: Thedataofeachvaluefieldisdistributedaccordingtothe
relativereferencedataforeachprofitabilitysegmentforthesamevaluefield.
Figure 108: Method: Distributing non-assigned values
Topdowndistributionenablesyoutodistributethedatafromahigherplanning
level tolower levels. For example, youcan performplanning first of allat the
productgrouplevelandthendistributethevaluestotheproductlevel.
247
2009 © 2009 SAP AG. All rights reserved.
第 264 页 / 共 483 页
Unit5: Planning AC605
Theplandataisdistributedinthesamewayastheexistingreferencedata. For
this distribution, you can use either plan or actual data. You can distributethe
dataseparatelybyperiodoryoucanaggregatethevaluesoverseveralperiodsto
level out fluctuations.
Intheabove example, thenonassigned plan data(value1000) at theproduct
grouplevelisdistributedtotheindividualproductsinthesamewayasthebase
values(theactual quantities sold) aredistributed. This meansat a ratio of 1:2.
Theproduct groupiscredited with1000andtheproductsaredebitedwith333
(product, P1) and 666 (product, P2).
Figure 109: Method: Distributing total values
Intheaboveexample,theoverallsumoftheplandatafortheproductgroupisthe
individualvaluesoftheproducts(eachpriorvalue)andthenonassignedvalues
(value#)atproductgrouplevel. Theoverallsumisdistributedtotheindividual
productsinthesamewayasthebasevalues(actualquantitiessold),whichmeans
ataratioof1:2. Theproductgroupiscreditedandtheproductsaredebited.
248
©2009SAPAG.Allrightsreserved. 2009
第 265 页 / 共 483 页
AC605 Lesson: Planning Methods
Figure 110: Automaticplanning: Top-down distribution(1)
Intheparameterset, youcanspecifythefollowing:
Youhavethechoicebetweentwotop-downproceduresthatdefineexactlywhat
valuesaretobedistributed: Youcaneitheronlydistributevaluesthatareposted
directlyatthehigher level withthemethod,Onlydistribute"non-assigned”or
youcandistributeallthevalueslocatedatthehigherlevel,regardlessofwhether
theywerepostedtheredirectlyorrolledupfrommoreextensivelevels,usingthe
Distributetotalvaluemethod. Whenyouusethismethod,thevaluestakenfrom
theextensivelevelareoverwrittenbythenew,distributedvalue.
You specify the receiver characteristic for the distribution under Receiver
characteristic. You can select several characteristics from the characteristics
specified in the planning level.
UnderReferencevaluefield,youcanenterasthebasisfordistribution,aspecific
value field for the reference data or a key figure calculated from value fields.
Alternatively,youcanspecifythatthedistributionoccursbyvaluefields. Inthis
way,eachvaluefieldistakenasthebasisforitsdistribution.
Tosmoothoutincidental differencesthat occurredfromperiodtoperiodinthe
referencedata,youcanselecttheAggregateperiodsindicator.
Youspecifythetimeframeforthereferencedatathatistobeusedasthebasis
for executing the planning method.
249
2009 © 2009 SAP AG. All rights reserved.
第 266 页 / 共 483 页
Unit5: Planning AC605
Figure 111: Automaticplanning: Top-down distribution (3)
Inaddition,youcanmakethefollowingsettingsintheparameterset:
Youspecifywhetherthedatatobeusedasthereferencedataistheactualdata
orthedatafromtheplanversionfortheplanningpackageorfromadifferent
plan version that is yet to be specified.
Youcanspecifyforasendercharacteristicthatadifferentcharacteristicvalue
in the reference dataformsthe basis for distribution. This meansthat you can
determinethatthedistributionoftheproductgroupsfortheproductofcountry1is
executedbasedontheproductdataofcountry2. Todothis,youshouldusethe
function “Transform characteristic values”.
Bymakingtheappropriatesetting,youspecifywhethertheplanningmethodisto
beexecutedinatestrunorinanupdaterun,orwhetherthisdecisionistobe
postponeduntilthepointofexecutionoftheparameterset.
You can jumpto abackground processingscreen.
IntheValuefieldstab page, youspecifythespecificvaluefieldsthat aretobe
distributed.
250
©2009SAPAG.Allrightsreserved. 2009
第 267 页 / 共 483 页
AC605 Lesson: Planning Methods
Analytical Bottom Up Planning
Figure 112: Bottom Up Planning
Thethirdplanningphaseinwhichplanvaluesareplannedbottomupandmerged
could occur in several steps. For example, the default plan values could be
createdautomatically(copiedorrevaluated)andthenusedasaplanbasisforthe
individual sales representatives.
IntegratedMicrosoftExcelallowsindividualsalesrepresentativestocreatetheir
sales plan data locally.
Finally,theindividualplanscanbemergedintoasingleversionandvaluatedwith
theoperativepricesandcostsofgoodsmanufactured.
251
2009 © 2009 SAP AG. All rights reserved.
第 268 页 / 共 483 页
Unit5: Planning AC605
Figure 113: Example: Bottom-Up Planning
Inbottomupplanning,plandataiscreatedatthecustomerandproductgrouplevel
andaggregatedtothecorresponding higher levels.
Figure 114: Data Entry with Excel Integration
Theintegrationof MicrosoftExcelintoprofitplanningmeansthatyoucanuse
Excelfunctionssuchastheonesforadditionalcalculations,graphicsandprinting,
andtheSAPsystemensurestheconsistencyofthedatacentrally,providingcentral
functions such as derivation and valuation.
252
©2009SAPAG.Allrightsreserved. 2009
第 269 页 / 共 483 页
AC605 Lesson: Planning Methods
Toperformlocalplanning,youcansaveExcelsheetsthathavebeencreatedinthe
SAPsystemlocallyonapersonalComputerorlaptopandthenworkonthemin
ExceloutsidetheSAPenvironment. Thedatacanthenbeloadedbackintothe
SAP system later using theupload functions.
Figure 115: Automatic Planning
AutomaticPlanningFunctionsThesefunctionscanbeusedtosimultaneously
process a large number of profitability segments for planning. They can be
executed either online or in the background. You must have the appropriate
authorizations to use these functions.
Whenyouuseautomaticplanning,youmustspecifythecharacteristicsandvalue
fieldsthatyouwanttoprocess. Thisallowsyoutosettheplanningscopeineach
case.
Automatic planning functions have beenincluded in the concept of planning
levels and planning packages. There are12 planning methods: You select the
characteristicstobeplannedat theplanninglevelandintheplanningpackage.
Youenterallothersettingsandselectthevaluefieldsinaparametersetforthe
correspondingplanningmethod,suchasCopy. PlanningManagementYouuse
thisfunctiontotrackwhichautomaticplanningfunctionswereexecutedandby
whom. Itprovidesacompletelogofthemasschangesmadetoplandata,thelog
informationwhencertainfunctionswerecarriedout,whocarriedthemout,and
what profitability segments were changed.
253
2009 © 2009 SAP AG. All rights reserved.
第 270 页 / 共 483 页
Unit5: Planning AC605
Figure 116: Copying plan data
Copying Plan Data (1)
In the target fields, specify the following:
• Thepostingperiodstobeupdatedwiththecopieddata.
• The plan version to be updated.
• Therecordtypeunderwhichtheplandataistobesaved.
In the source fields, specify the following:
• Thepostingperiodsfromwhichdataistobecopied.
• Theplanversionfromwhichthedataistobecopied(ifcopyingplandata).
• Therecordtypeoftheplandatayouwanttocopy.
• The plan/actual indicator.
Specifyadistributionkeyifyouwanttosummarizethesourcedataforallthe
periodsandthendistributethemacrossthetargetperiods. Ifyouleavethisfield
blank,thevaluesarecopiedstraightfromthesourceperiodstothetargetperiods.
Select the Valuate radio button box if you want the system to automatically
perform valuation during the copy process. Then, target value fields may be
populatedwithvaluesfromcostingsheets,productcosting,anduser-exits.
Specify whether thesource data should overwrite, add to, or subtract fromthe
existing data in the target plan version.
254
©2009SAPAG.Allrightsreserved. 2009
第 271 页 / 共 483 页
AC605 Lesson: Planning Methods
Figure117: Copyingplandata: Transformationofcharacteristics
Theoptions,AddandPost,havebeenaddedtocharacteristictransformation.
IfyouusetheAddfunction,thecopiedvaluesareaddedtotheexistingrecipient
characteristics.
IfyoudonotselectAdd,thecopiedvaluesoverwritetheexistingplandatainthe
recipient characteristic.
If you select the Clear indicator, the values in the original characteristic are
removed.
Figure 118: Forecasting
255
2009 © 2009 SAP AG. All rights reserved.
第 272 页 / 共 483 页
Unit5: Planning AC605
You can use the forecasting function to automatically calculate new plan
data using the existing data and customizable forecast profiles. You can use
forecastinginmanualplanningandinautomaticplanning.
AforecastprofileisacombinationofaforecastmodeldeliveredbySAPanda
set of user-definedparameters. Youcancreateforecast profilesintheCO-PA
usermenu. TheSAP systemsupportsanumberofpredefinedforecastmodels,
including trend models, seasonal models, and exponential models. For more
informationonforecast models, seethedocumentationonSalesandOperating
Planning.
Weightinggroupsaresometimesrequiredasaparameterfortheforecastprofile,
dependingonthemodelyouhaveselected. Youcanalsocreateweightinggroups
in the CO-PA application menu.
InManualPlanning,youmakeaforecastbyselectingavalueoracolumnand
then clicking the Forecast function. In the dialog window, enter the required
parameters,suchastheforecastperiodandthereferencedatatobeused.
Toforecast inAutomaticPlanning, select AutomaticPlanning→Forecast in
theapplicationmenuandenteraforecastprofileandtherequiredparameterson
the Initial screen.
Figure 119: Planning Sequences
Youcanuseplanningsequencestocombineseveralautomaticplanningmethods,
sortthem, andexecutetheminonerun. Forexample,youcanstartbycopying
theplanvalues, distributethemusingthetopdownmethod, andthenrevaluate
these values.
256
©2009SAPAG.Allrightsreserved. 2009
第 273 页 / 共 483 页
AC605 Lesson: Planning Methods
Integrated Transfer of Plan Data
Figure 120: Integrated Transfers of Plan Data
Inthefifthplanningphase,youcancompleteyoursalesandprofitplanningdata
withtheadditionalplandatafromotherapplicationcomponents.
Figure 121: Integration of Planning
257
2009 © 2009 SAP AG. All rights reserved.
第 274 页 / 共 483 页
Unit5: Planning AC605
By design, the SAP system supports integrated planning in controlling, where
planningisconductedseparatelyformultiplebusinessactivitiesbutthedifferent
plans are linked to ensure consistency and to drive realistic corporate-wide
planning. Asaresult,theseparateplanningresultsforsales,service,production,
procurement,general,andadministrationactivitiescoincidetoformonecorporate
operational plan.
ThisintegrationisaccomplishedintheSAPsystemthroughbothreal-timeand
periodic synchronization of the data in the plan versions across modules. For
example,thesalesquantitiesplannedinSISmaybetransferredinbatchtoSOP,
whichthenusestheinformationtogeneratethenecessaryplannedproductionand
procurementactivities. ThiscanbeintegratedwiththeoverheadplansinCCA,
andtheendresultsfor everythingcanbepassedtoCO-PA,wheretheresulting
overall profitability plan may reside.
Thisexampleflowofplanningdataisoneexampleofthemanypossibleplanning
strategiesthatcanbeusedintheSAPsystem. Theflowthatshouldbeusedfora
givencompanydependsonmanyfactors,suchasthemodulesbeingimplemented,
the planning functions in those modules, the integration functions between
modules,andthenecessarymaintenancestepstoachieveintegration.
Figure 122: CO Plan Integration
ToreflectPlancostsfromCostCenterAccountinginProfitabilityAnalysis,you
need to transfer those costs into the CO-PA portion of a plan version through
a cost center assessment. With this tool, planned costs can beallocatedacross
profitabilitysegmentsinthesamewaythatactualcostscanbeallocatedacross
profitability segments.
258
©2009SAPAG.Allrightsreserved. 2009
第 275 页 / 共 483 页
AC605 Lesson: Planning Methods
ToassessCostCentercostsinCO-PA,anassessmentcyclefirsthastobedefined.
Theassessment cycleconsistsof aseriesof segments, eachofwhichdefinesa
uniquerelationshipbetweensenders,receivers,andassessmentrules. Thesecan
be defined on the user side of CO-PA.
Whenassessmentcyclesaredefined,youneedtospecifythecontrollingareafrom
whichtheassessmentwilltakeplace. ThisisbecauseallocationsinManagement
Accounting can only take place within a single controlling area through the
restrictionsof SAPcost accountingrules. WhenallocatinginCO-PA,itisalso
notpossibletoexceedcontrollingareas. Thecontrollingareaisonepartofthe
definition of thereceiver's operating concern.
YoualsoneedtospecifythesideofCO-PAfromwhichthetracingfactorsshould
be drawn for any 'variable portions' assessment rules that are defined. This
settingcontrolswhethervalueswillbedistributedbasedonaccountbalancesfor
profitabilitysegmentsorkeyfiguresamountsforprofitabilitysegments.
Assessmentsaffectbothcosting-basedCO-PAandaccount-basedCO-PA,ifboth
areactive. ThisisnecessaryfromanSAPcostingperspectivebecausecostsare
technicallybeingmovedofffromtheoriginatingaccountassignmentobjectsand
costcenters, andplacedontothereceivingobjectsandProfitabilitySegments,
what are shared between the twosidesofCO-PA.
259
2009 © 2009 SAP AG. All rights reserved.
第 276 页 / 共 483 页
Unit5: Planning AC605
260
©2009SAPAG.Allrightsreserved. 2009