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

第 277 页 / 共 483 页

AC605 Lesson: Planning Methods

Exercise 13: Manual Planning Functions

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Create a plan version for CO-PA

• Createaplanninglevel,planningmethod,andplanparameters

• Calculate revenues automatically in costing-based CO-PA using ratio

schemesandinaccount-basedCO-PAusinginverseformulae

• Explore other manual planning features

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.

Task 1:

1. Createa new plan version for CO-PA. Name theversion 5## and enter a

unique description for your group. Set up the version for the operating

concern,IDEA,sothatvaluescanbestoredinProfitabilityAnalysis. Setthe

derivationdateasthebeginningofthecurrentfiscalyear.

Continued on next page

261

第 278 页 / 共 483 页

Unit5: Planning AC605

Name: 5## Name: Plan 5##

Task 2:

YoursalesmanagershaveaskedyoutocreatethefollowingPlanningscreenso

that each sales employee can enter the top products and customers using the

version,5##,thecurrentfiscalyear,andsalestheorganization,1000.

Customer Product Invoicedquantity Sales rev.

insalesunits

1. ReviewPlanningLevel,AC605. Whichcharacteristicshavebeenselected?

2. Create a new planning package under the planning level, AC605, in

costing-basedCO-PAthatcanbeusedforplanningtheinformationrequested

by your sales managers.

Namethepackage,Plan##,andenteranappropriatedescription.

Theplanningpackageistobeusedfortheperiod,1–12XXXX,foryour

version,5##,recordtype,F,inthesalesorganization,1000.

Saveyourplanningpackage. Theplanningpackageshouldappearunderthe

planning level, AC605, ontheleft ofthescreen.

3. CreateaparametersetfortheplanmethodEnteringandDisplayingPlanning

Data for your planning package.

ChoosetheEnterPlanningDataplanning methodandright-click. Select

CreateParameterSet. Nametheparameterset,Plan##.

SelectCreateLayouttocreatethedataentryscreenandcreateyourplanning

layout dynamically.

Namethelayout, Plan##. Indicatetheappropriatelevelfor thedisplayed

characteristics. TheCustomerandProductshouldappearintheleadcolumn

andalltheothercharacteristicsshouldbedisplayedintheheader.

Next,definetheappropriatevaluefieldsfromthelistofvaluefields,based

on the above requirement.

Change the distribution key for the currency and the quantities to Equal

distribution(1)and save your parameter set.

Task 3:

1. CreateanotherparametersetfortheDisplayplanningmethod.

Continued on next page

262

Customer	Product	Invoicedquantity insalesunits	Sales rev.

第 279 页 / 共 483 页

AC605 Lesson: Planning Methods

Followthesamestepsasabove. Youdonotneedtodefineanotherplanning

layout. UsetheLayout, Plan##, createdin1-2-3.

Task 4:

1. Plan values for the customer, XXXX.

Enter the following planning data:

Customer Product Invoiced SalesRev.

quantityinsales

units

T-CO05A## P-100 100 100,000

T-CO05A## P-101 50 75,000

T-CO05A## P-102 120 13,0000

SaveyourplanningdatabutremaininthePlanningscreen.

2. Increasealltheplannedquantityandrevenuevaluesby5%. Whatarethe

two optionsthat you could use to do this?

DONOTSAVETHEREVALUATEDDATA

Hint: TousetheChangevaluesoption,youmustenterafixedvalue

orpercentage. TousetheRevaluatefeature,youmustselectoneor

morelines(andrevaluationfactorsmusthavebeenpredefined).

3. Findtheadditionalcharacteristicvaluesforanyoftheprofitabilitysegments

beingplannedthatarenotdisplayedontheLayoutscreen(Forexample,the

onesdeterminedbehindthescenesbyderivation). Whatplanningprinciple

does this show?

Exit thePlanning screen without saving.

Continued on next page

263

Customer	Product	Invoiced quantityinsales units	SalesRev.
T-CO05A##	P-100	100	100,000
T-CO05A##	P-101	50	75,000
T-CO05A##	P-102	120	13,0000

第 280 页 / 共 483 页

Unit5: Planning AC605

Task 5:

YoursalesmanagersarequitepleasedwiththePlanningscreenyouhavedesigned

forthembuttheywouldliketoaddafieldforPrice. Theywanttobeabletoplan

theinvoicequantityandtheproductprice andthenhavethesystemcalculate

revenue. Becausetheyalsoknowthattheirrevenuegoalsareoftenchanged,they

wouldliketobeabletochangetherevenuefigurewithoutimpactingontheprice,

toestablishhowmanyunitsofaproductneedtobesold.

Theyhaveaskedyoutoaddaunitofmeasurebecauseproductsareoftenstored

in various units.

Sort all the columnsin thefollowingsequence:

Cus- Product Invoiced Unit Price Salesrev.

tomer quantity in

salesunits

1. ToaddtheratioforthePricecolumn,changeyourlayoutaccordingly. You

canaccessthelayoutbychangingthePlan##parameter set. Insert anew

column and select Price/unit – product.

You also want to adjust thesettingsfor the quantity column to display 0

decimal places.

Makesureyousaveyoursettingsafterthechangesaremade.

Click the Plan## planning package one time to select it. In the planning

methods, select the arrow next to Enter Planning. Then highlight the

parametersetPlan##. Right-clicktochangetheparameterset.

2. Test your changed planning layout by entering another product, P-103,

for your customer. Enter the price (1500). You can see how the price is

calculated.

Customer Product Invoiced quantity in Sales rev.

sales units

T-CO05A## P-103 100 1,500

Next,changetheplannedpricefortheproduct,P-100,to1,500andselect

Enter. Isthecorrespondingrevenueorthequantityrecalculated? Why?

Next,changetherevenuevalueforP-101to50,000andselectEnter. Isthe

correspondingpriceorthequantityrecalculated? Why?

Continued on next page

264

Cus- tomer	Product	Invoiced quantity in salesunits	Unit	Price	Salesrev.

Customer	Product	Invoiced quantity in sales units	Sales rev.
T-CO05A##	P-103	100	1,500

第 281 页 / 共 483 页

AC605 Lesson: Planning Methods

3. Yoursalesmanagerinformsyouthatnormallyacertainrevenuetargetisset

for acustomerorproduct. Theassumedrevenuetargetforproduct P-100

is200,000whenthepriceisconstant. Thesalesmanagerrequeststhatthe

systemcalculateshowmanyunitshavetobesoldtoreachthistarget. Show

him the Goal Seek feature.

SAVE YOUR PLANNING DATA.

265

第 282 页 / 共 483 页

Unit5: Planning AC605

Solution 13: Manual Planning Functions

Task 1:

1. Createa new planversionfor CO-PA. Name theversion 5## and enter a

unique description for your group. Set up the version for the operating

concern,IDEA,sothatvaluescanbestoredinProfitabilityAnalysis. Setthe

derivationdateasthebeginningofthecurrentfiscalyear.

Name: 5## Name: Plan 5##

a) IMG: Controlling→ ProfitabilityAnalysis→Planning→ Initial

Steps → Maintain Versions

Choose New Entries.

Name: 5## Description: Plan 5##

HighlightthePlanfieldforthenewversion. Chooseenter.

SelectPlan5##fromthelistandchoose“Settings”intheoperating

concern. Confirmthe‘Confirmtransferfromversion’dialogbox

bychoosingYes. Enterthecurrencytype,B0. ChooseSave.

Task 2:

YoursalesmanagershaveaskedyoutocreatethefollowingPlanningscreenso

that each sales employee can enter the top products and customers using the

version,5##,thecurrentfiscalyear,andsalestheorganization,1000.

Customer Product Invoicedquantity Sales rev.

insalesunits

1. ReviewPlanningLevel,AC605. Whichcharacteristicshavebeenselected?

a) Controlling→ProfitabilityAnalysis→Planning→EditPlanning

Data: Double-clicktheAC605node. “Characteristics”tab

Customer, Product, Period/Year, Record Type, Sales Organization,

Version

2. Create a new planning package under the planning level, AC605, in

costing-basedCO-PAthatcanbeusedforplanningtheinformationrequested

by your sales managers.

Namethepackage,Plan##,andenteranappropriatedescription.

Theplanningpackageistobeusedfortheperiod,1–12XXXX,foryour

version,5##,recordtype,F,inthesalesorganization,1000.

Continued on next page

266

Customer	Product	Invoicedquantity insalesunits	Sales rev.

第 283 页 / 共 483 页

AC605 Lesson: Planning Methods

Saveyourplanningpackage. Theplanningpackageshouldappearunderthe

planninglevel, AC605, on theleftofthescreen.

a) Right-clicktheplanninglevel, AC605, and chooseCreatePlanning

Package.

Namethepackage,Plan##,andenteranappropriatedescription.

Enter the following data:

FieldNameorDataType Values

Version 5##

Record Type F

SalesOrganization 1000

Save your planning package. The planning package should appear

undertheplanninglevel,AC605,ontheleftofthescreen.

3. CreateaparametersetfortheplanmethodEnteringandDisplayingPlanning

Data for your planning package.

ChoosetheEnterPlanningData planningmethodand right-click. Select

CreateParameterSet. Nametheparameterset,Plan##.

SelectCreateLayouttocreatethedataentryscreenandcreateyourplanning

layout dynamically.

Namethelayout, Plan##. Indicatetheappropriatelevel for thedisplayed

characteristics. TheCustomerandProductshouldappearintheleadcolumn

andalltheothercharacteristicsshouldbedisplayedintheheader.

Next,definetheappropriatevaluefieldsfromthelistofvaluefields,based

on the above requirement.

Continued on next page

267

FieldNameorDataType	Values
Version	5##
Record Type	F
SalesOrganization	1000

第 284 页 / 共 483 页

Unit5: Planning AC605

Change the distribution key for the currency and the quantities to Equal

distribution(1)and save your parameter set.

a) Double-clickthePlan## planningpackage

ChoosetheEnterPlanDataplanningmethodandright-click. Select

CreateParameterSet. Nametheparameterset,Plan##.

Togeneratetheplanninglayoutfordataentry,namethelayout,Plan##,

andchooseCreateLayout. Addanappropriatedescription.

TheCustomerandProductshouldappearintheleadcolumnwiththe

characteristicSalesorganizationintheheaderselection.

FieldNameorDataType Values

Customer Lead Column

Product Lead Column

SalesOrganization Header

Definetheappropriatevaluefieldsfromthelistofvaluefields.

FieldNameorDataType Values

Invoicedquantityinsalesunits Select

Revenue Select

Click the create icon.

ChangethedistributionkeyforthecurrencyandthequantitiestoEqual

distribution(1)and saveyour parameterset.

Task 3:

1. CreateanotherparametersetfortheDisplayplanningmethod.

Followthesamestepsasabove. Youdonotneedtodefineanotherplanning

layout. UsetheLayout, Plan##, created in 1-2-3.

a) CreateanotherparametersetfortheDisplayplanningmethod.

Followthesamestepsasabove. Youdo not need to define another

planninglayout. UsetheLayout,Plan##,createdin1-2-3.

Task 4:

1. Plan values for the customer, XXXX.

Enter the following planning data:

Continued on next page

268

FieldNameorDataType	Values
Customer	Lead Column
Product	Lead Column
SalesOrganization	Header

FieldNameorDataType	Values
Invoicedquantityinsalesunits	Select
Revenue	Select

第 285 页 / 共 483 页

AC605 Lesson: Planning Methods

Customer Product Invoiced SalesRev.

quantityinsales

units

T-CO05A## P-100 100 100,000

T-CO05A## P-101 50 75,000

T-CO05A## P-102 120 13,0000

SaveyourplanningdatabutremaininthePlanningscreen.

a) Planvaluesfor thecustomer, T-CO05A##.

Double-click the planning level, AC605, and select the planning

package, Plan##.

From thePlanning Methods, double-click the node to select your

planning method, Plan##.

Enter the following plan data:

Customer Product Invoiced quantity in Salesrev.

sales units

T-CO05A## P-100 100 100,000

T-CO05A## P-101 50 75,000

T-CO05A## P-102 120 130,000

SaveyourplanningdatabutremainonthePlanningscreen.

2. Increasealltheplannedquantityandrevenuevaluesby5%. Whatarethe

two optionsthat you could use to do this?

DONOTSAVETHEREVALUATEDDATA

Hint: TousetheChangevaluesoption,youmustenterafixedvalue

orpercentage. TousetheRevaluatefeature,youmustselectoneor

morelines(andrevaluationfactorsmusthavebeenpredefined).

a) Useaplanningfeaturetoincreasealltheplannedquantityandrevenue

valuesby5%. Whataretwooptionsthatyoucouldusetodothis?

DONOTSAVETHEREVALUATEDDATA

Edit→PlanningMethod →ChangeValues

Edit→PlanningMethod→Revaluate(forlines)usingrevaluation

key ID2

Continued on next page

269

Customer	Product	Invoiced quantityinsales units	SalesRev.
T-CO05A##	P-100	100	100,000
T-CO05A##	P-101	50	75,000
T-CO05A##	P-102	120	13,0000

Customer	Product	Invoiced quantity in sales units	Salesrev.
T-CO05A##	P-100	100	100,000
T-CO05A##	P-101	50	75,000
T-CO05A##	P-102	120	130,000

第 286 页 / 共 483 页

Unit5: Planning AC605

3. Findtheadditionalcharacteristicvaluesforanyoftheprofitabilitysegments

beingplannedthatarenotdisplayedontheLayoutscreen(Forexample,the

onesdeterminedbehindthescenesbyderivation). Whatplanningprinciple

does this show?

Exit the Planning screen without saving.

a) Selectalineandclickthe“Characteristicsinformation”icon. This

showsautomaticbottomupplanningbythesystembasedonthe

principleofconductingderivationonalltheplannedcharacteristic

values.

Exit thePlanning screen without saving.

Task 5:

YoursalesmanagersarequitepleasedwiththePlanningscreenyouhavedesigned

forthembuttheywouldliketoaddafieldforPrice. Theywanttobeabletoplan

theinvoicequantityandtheproductprice andthenhavethesystemcalculate

revenue. Becausetheyalsoknowthattheirrevenuegoalsareoftenchanged,they

wouldliketobeabletochangetherevenuefigurewithoutimpactingontheprice,

toestablishhowmanyunitsofaproductneedtobesold.

Theyhaveaskedyoutoaddaunitofmeasurebecauseproductsareoftenstored

in various units.

Sort all the columnsin thefollowingsequence:

Cus- Product Invoiced Unit Price Salesrev.

tomer quantity in

salesunits

1. ToaddtheratioforthePricecolumn,changeyourlayoutaccordingly. You

canaccessthelayoutbychangingthePlan##parameter set. Insert anew

column and select Price/unit – product.

You also want to adjust thesettingsfor the quantity column to display 0

decimal places.

Makesureyousaveyoursettingsafterthechangesaremade.

Continued on next page

270

Cus- tomer	Product	Invoiced quantity in salesunits	Unit	Price	Salesrev.

第 287 页 / 共 483 页

AC605 Lesson: Planning Methods

Click the Plan## planning package onetime to select it. In theplanning

methods, select the arrow next to Enter Planning. Then highlight the

parametersetPlan##. Right-clicktochangetheparameterset.

a) ToaddtheratioforthePricecolumn,changeyourlayoutaccordingly.

YoucanaccessthelayoutbychangingthePlan##parameterset. Insert

anewcolumnandselectPrice/unit–product.

Youalsowanttoadjustthesettingsforthequantitycolumntodisplay0

decimal places.

Controlling→ProfitabilityAnalysis→Planning→EditPlanning

Data: Double-click the AC605 node.

Selectyourplanningpackage,Plan##,anddouble-clickit. Expand

fromtheplanningmethodsoutof thenodesnextto“EnterPlan

Data”. Thenselectyourplanparameterset(Plan##). Right-click

to change the parameter set.

Clickthe“Display”icon(nexttoLayoutPlan##),HighlightLayout

Plan##inthelistanddouble-clickit. Clickthe“Display/Change”

icon in the toolbar.

Double-clickbetweentheInvoicedQuantityandRevenuecolumn.

In the dialog box that appears, select the Value field with the

Characteristicoption. Fromthelistofvaluefields,selectthefield,

Price/unit–product. Confirmthedialogbox.

To add the unit of measure, double-click between the Invoiced

Quantity and Revenue column. In the dialog box that appears,

selectAttributeandthenUnit. Fromthelistofvaluefields,select

theInvoicedquantityandchangetheShortTexttoUM.Clickthe

CopyShortTexticon. Confirmthedialogbox.

UsingtheSelectandMoveicons,placethecolumnsintheappropriate

order.

Selectthecolumnforwhichyouwouldliketochangethenumber

format.

Formatting→NumberFormat: 0decimalplaces

Choose Save.

Makesureyousaveyoursettingsafterthechangesaremade.

2. Test your changed planning layout by entering another product, P-103,

for your customer. Enter the price (1500). You can see how the price is

calculated.

Continued on next page

271

第 288 页 / 共 483 页

Unit5: Planning AC605

Customer Product Invoiced quantity in Sales rev.

sales units

T-CO05A## P-103 100 1,500

Next,changetheplannedpricefortheproduct,P-100,to1,500andselect

Enter. Isthecorrespondingrevenueorthequantityrecalculated? Why?

Next,changetherevenuevalueforP-101to50,000andselectEnter. Isthe

correspondingpriceorthequantityrecalculated? Why?

a) Testyourchangedplanninglayoutbyenteringanotherproduct,P-103,

foryourcustomer. Entertheprice(1500). Youcanseehowtheprice

is calculated.

Customer Product Invoiced quantity Salesrev.

insalesunits

T-CO05A## P-103 100 1,500

Next,changetheplannedpricefortheproduct,P-100, to1,500and

selectEnter. Isthecorrespondingrevenueorthequantityrecalculated?

Why?

IMG:Controlling→ProfitabilityAnalysis→Planning→Planning

Aids →Define RatiosandRatio Schemes

Therevenueisrecalculatedbecausethesystemhasbeenprogrammed

withfixedrulestorecalculatethenumeratorof theformulaifthis

value is not blocked against changes.

Next,changetherevenuevalueforP-101to50,000andselectEnter.

Isthecorrespondingpriceorthequantityrecalculated? Why?

The quantity is recalculated because the calculation type in the

definition of the ratio is set to “recalculate base value” instead

of to “recalculate ratio”.

3. Yoursalesmanagerinformsyouthatnormallyacertainrevenuetargetisset

for acustomer orproduct. Theassumedrevenuetargetforproduct P-100

is200,000whenthepriceisconstant. Thesalesmanagerrequeststhatthe

systemcalculateshowmanyunitshavetobesoldtoreachthistarget. Show

him the Goal Seek feature.

Continued on next page

272

Customer	Product	Invoiced quantity in sales units	Sales rev.
T-CO05A##	P-103	100	1,500

Customer	Product	Invoiced quantity insalesunits	Salesrev.
T-CO05A##	P-103	100	1,500

第 289 页 / 共 483 页

AC605 Lesson: Planning Methods

SAVE YOUR PLANNING DATA.

a) Yoursalesmanagerinformsyouthatnormallyacertainrevenuetarget

is set for a customer or product. The assumed revenue target for

productP-100is200,000whenthepriceisconstant. Thesalesmanager

requeststhatthesystemcalculateshowmanyunitshavetobesoldto

reachthistarget. ShowhimtheGoalSeekfeature.

In theplan, select thecells“Invoiced Quantity”and “Revenue”

usingtheSelecticonforeachcell,forproductP-100. Executethe

Goal Seek function:

Edit→PlanningMethods→GoalSeek: Revenue200,000

SAVE YOUR PLANNING DATA.

273

第 290 页 / 共 483 页

Unit5: Planning AC605

274

第 291 页 / 共 483 页

AC605 Lesson: Planning Methods

Exercise 14: Automatic Planning

Functions

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Conduct a top down planning run

• Change aplanusingvaluation andrevaluation

Business Example

Task:

Youwant toplan miscellaneoussales quantities andrevenuesforthematerial

group,003,intheversion,5##. Youthenwanttodistributetheseplannedvalues

topdownbasedontheactual2002salesquantitiesandrevenues.

1. Entertheplanningfiguresforyourplanningversion,5##,usingtheplanning

level,IDES125. Theplannedvaluesareforthecurrentyear.

Undertheplanninglevel,IDES125,createanewplanningpackage,Top##,

for your plan version.

Right-clickonetimeandselectCreatePlanningPackage.

Addthefollowingdatatoyour planningpackage.

FieldNameorDataType Values

Period/Year 1-12, XXXX

Unit Inv. Qty CAR

Version 5##

Save your planning package.

2. Entertheplanningdatafortheplanningpackageyoujustcreated:

At the bottom left of the screen, double-click the node to select the plan

parameter,IDES125. Planyourvaluesforthematerialgroup,003.

FieldNameorDataType Values

Material group 003 (should default)

Plan Quantity 100,000

Revenue 200,000,000.00

Continued on next page

275

FieldNameorDataType	Values
Period/Year	1-12, XXXX
Unit Inv. Qty	CAR
Version	5##

FieldNameorDataType	Values
Material group	003 (should default)
Plan Quantity	100,000
Revenue	200,000,000.00

第 292 页 / 共 483 页

Unit5: Planning AC605

3. Displayyourplanpostingsusingthereport,IDES-125,for:

Field NameorDataType Values

Period From-To 1-12, XXXX

Plan/actual indicator 1

Version 5##

Rec type F

Drill down to the individual product level and double-click

Product. Why are there values in the unassigned category?

______________________________________________________________________________

4. Using the same report, displaytheactual postings for January through

December2002. UsetheActualindicatorandtherecordtype,F.Drilldown

to theproduct levelforthematerial group, 003.

Ifyouwantedtoperformatopdowndistributionfortheplannedquantity

andtheplannedrevenueintheversion,5##,andusetheactualquantityasa

distributionfactor,whatwouldtheweightingfactorsbe?

MaterialGroup: Product: Planquantity:

003 L-40C

003 L-40F

003 L-40R

5. Verifytheresultsbycarryingoutthistopdowndistribution.

Returntotheplanningframeworkandselectyourplanningpackagewithin

theplanninglevel,IDES125. Whichparametersettingshavebeenmadefor

the parameter set, IDES125?

Executetheparameterset,IDES125,inaproductionmode.

6. Afterexecutingdistribution,howmanypostingsdoesthesystemmake?

Reviewthereport,IDES-125,forthecurrentyear,version,5##,toexamine

the results for the current fiscal year.

Drill down to the individual product level. Are there any values at the

product level?

276

Field NameorDataType	Values
Period From-To	1-12, XXXX
Plan/actual indicator	1
Version	5##
Rec type	F

MaterialGroup:	Product:	Planquantity:
003	L-40C
003	L-40F
003	L-40R

第 293 页 / 共 483 页

AC605 Lesson: Planning Methods

Solution 14: Automatic Planning

Functions

Task:

Youwant toplan miscellaneoussales quantities andrevenuesforthematerial

group,003,intheversion,5##. Youthenwanttodistributetheseplannedvalues

topdownbasedontheactual2002salesquantitiesandrevenues.

1. Entertheplanningfiguresforyourplanningversion,5##,usingtheplanning

level,IDES125. Theplannedvaluesareforthecurrentyear.

Undertheplanninglevel,IDES125,createanewplanningpackage,Top##,

for your plan version.

Right-clickonetimeandselectCreatePlanningPackage.

Addthefollowingdatatoyour planningpackage.

FieldNameorDataType Values

Period/Year 1-12, XXXX

Unit Inv. Qty CAR

Version 5##

Save your planning package.

a) Entertheplanningtimeframe,1/XXXX,through12/XXXXandyour

version number.

Controlling→ProfitabilityAnalysis→Planning→Create/Display

Plan Data: Select planninglevel IDES125.

Right-clickonetimeandselectCreatePlanningPackage.

EnterthePackage,TOP##,andanappropriatedescription.

Addthefollowingdatatoyourplanningpackage:

FieldNameorDataType Values

Period/Year 1 - 12,.XXXX

Unit Inv. Qty CAR

Version 5##

Save your planning package.

2. Entertheplanningdatafortheplanningpackageyoujustcreated:

Continued on next page

277

FieldNameorDataType	Values
Period/Year	1-12, XXXX
Unit Inv. Qty	CAR
Version	5##

FieldNameorDataType	Values
Period/Year	1 - 12,.XXXX
Unit Inv. Qty	CAR
Version	5##

第 294 页 / 共 483 页

Unit5: Planning AC605

At the bottom left of the screen, double-click the node to select the plan

parameter,IDES125. Planyourvaluesforthematerialgroup,003.

FieldNameorDataType Values

Material group 003 (should default)

Plan Quantity 100,000

Revenue 200,000,000.00

a) Enter the planning data for the planning package and the plan

parameter, IDES125.

Choosetheplanparameter,IDES125,atthebottomleftofthescreen.

Planyour valuesfor thematerial group, 003.

FieldNameorDataType Values

Material group 003 (should default)

Plan Quantity 100,000

Revenue 200,000,000.00

Choose Save.

3. Displayyourplanpostingsusingthereport,IDES-125,for:

Field NameorDataType Values

Period From-To 1-12, XXXX

Plan/actual indicator 1

Version 5##

Rec type F

Continued on next page

278

FieldNameorDataType	Values
Material group	003 (should default)
Plan Quantity	100,000
Revenue	200,000,000.00

FieldNameorDataType	Values
Material group	003 (should default)
Plan Quantity	100,000
Revenue	200,000,000.00

Field NameorDataType	Values
Period From-To	1-12, XXXX
Plan/actual indicator	1
Version	5##
Rec type	F

第 295 页 / 共 483 页

AC605 Lesson: Planning Methods

Drill down to the individual product level and double-click

Product. Why are there values in the unassigned category?

___________________________________________________________________________

a) Displayyourplanpostingsusingthereport,IDES-125for:

Controlling → Profitability Analysis → Information System →

Execute Report→Execute→IDES-125

Field NameorDataType Values

Period From-To 1-12, XXXX

Plan/actual indicator 1

Version 5##

Rec type F

Drill down to the individual product level by double-clicking

Product. Why are there values in the unassigned category?

______________________________________________________________________

In the report, the individual products as well as material types are

selected. Theplan valuesfor the product group are not assigned to

the Product characteristic.

4. Using the same report, displaythe actual postings for January through

December2002. UsetheActualindicatorandtherecordtype,F.Drilldown

totheproduct level for thematerial group, 003.

Ifyouwantedtoperformatopdowndistributionfortheplannedquantity

andtheplannedrevenueintheversion,5##,andusetheactualquantityasa

distributionfactor,whatwouldtheweightingfactorsbe?

Continued on next page

279

Field NameorDataType	Values
Period From-To	1-12, XXXX
Plan/actual indicator	1
Version	5##
Rec type	F

第 296 页 / 共 483 页

Unit5: Planning AC605

MaterialGroup: Product: Planquantity:

003 L-40C

003 L-40F

003 L-40R

a) Using the same report, show the actual postings for January to

December 2002. Use the actual indicator and the record type F.

Navigatetotheproductlevelformaterialgroup03.

Controlling → Profitability Analysis → Information System →

Execute Report→Execute →IDES-25

FieldNameorDataType Values

Period From-To 1-12, 2002

Plan/Actual Indicator 0

Version Blank

Record Type F

If you wanted to perform a top down distribution for the planned

quantityandtheplannedrevenueintheversion,5##,andusetheactual

quantityasadistributionfactor,whatwouldtheweightingfactorsbe?

MaterialGroup: Product: Plan

quantity:

003 L-40C 6858

003 L-40F 3062

003 L-40R 1886

5. Verifytheresultsbycarryingoutthistopdowndistribution.

Returntotheplanningframeworkandselectyourplanningpackagewithin

theplanninglevel,IDES125. Whichparametersettingshavebeenmadefor

the parameter set, IDES125?

Executetheparameterset,IDES125,inaproductionmode.

6. Afterexecutingdistribution,howmanypostingsdoesthesystemmake?

Continued on next page

280

MaterialGroup:	Product:	Planquantity:
003	L-40C
003	L-40F
003	L-40R

FieldNameorDataType	Values
Period From-To	1-12, 2002
Plan/Actual Indicator	0
Version	Blank
Record Type	F

MaterialGroup:	Product:	Plan quantity:
003	L-40C	6858
003	L-40F	3062
003	L-40R	1886

第 297 页 / 共 483 页

AC605 Lesson: Planning Methods

Reviewthereport,IDES-125,forthecurrentyear,version,5##,toexamine

the results for the current fiscal year.

Drill down to the individual product level. Are there any values at the

product level?

a) Yes, the unassigned portion of the plan has been distributed to the

individualproductlevel,basedonthe2002actualinvoicedquantities.

281

第 298 页 / 共 483 页

Unit5: Planning AC605

282

第 299 页 / 共 483 页

AC605 Lesson: Planning Methods

Exercise 15: Integrated Planning

Functions

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Transfer the planned quantities to SOP

Business Example

Task:

Readtheonlinedocumentationtohelpyouanswerthefollowingquestions.

Open the SAP library and select the submenu Accounting: SelectControlling

andthenProfitabilityAnalysis. UnderthePlanningsubmenu,chooseIntegrated

PlanningandthenTransferSalesandOperationsPlanning(SOP).

1. CanyoutransfertheplanningdatatoSOPfrombothcosting-basedCO-PA

and account-based CO-PA?

2. CantheplanquantitiesbetransferredtoSOPattheproductgroupleveland

the product level? If so, are there anyspecial Customizing requirements

in CO-PA?

283

第 300 页 / 共 483 页

Unit5: Planning AC605

Solution 15: Integrated Planning

Functions

Task:

Readtheonlinedocumentationtohelpyouanswerthefollowingquestions.

Open the SAP library and select the submenu Accounting: SelectControlling

andthenProfitabilityAnalysis. UnderthePlanningsubmenu,chooseIntegrated

PlanningandthenTransferSalesandOperationsPlanning(SOP).

1. CanyoutransfertheplanningdatatoSOPfrombothcosting-basedCO-PA

and account-based CO-PA?

a) No, you can transfer only the planning data from costing-based

CO-PA.

2. CantheplanquantitiesbetransferredtoSOPattheproductgroupleveland

the product level? If so, are there any special Customizing requirements

in CO-PA?

a) Yes,thequantitiescanbetransferredtotheproductgrouplevel. The

prerequisite is that a characteristic for mapping the SOP product

grouphasbeencreatedintheoperatingconcern.

284

第 301 页 / 共 483 页

AC605 Lesson: Planning Methods

Lesson Summary

You should now be able to:

• Plan target values

• Performtopdowndistributionof planningdata

• Changeand deleteplandataandcreateforecasts

• Explain the integrated transfer of plan data

285

第 302 页 / 共 483 页

UnitSummary AC605

Unit Summary

You should now be able to:

• Outlinetheoverall processflowofprofit planning

• Work with planning layouts

• Plan target values

• Performtopdowndistributionof planningdata

• Changeanddeleteplandataandcreateforecasts

• Explain theintegrated transfer of plan data

286

第 303 页 / 共 483 页

AC605 Test Your Knowledge

Test Your Knowledge

1. Whichofthefollowingisnotapartofaplanninglayout?

Choosethecorrectanswer(s).

□ A General data selection

□ B Lead columns

□ C Value columns

□ D Objectives

2. A professional planning tool has to support the individual planners

by providing personalized access to the required plan data, using

Fillintheblankstocompletethesentence.

3. aredefinedusingcharacteristics,valuefields,

attributes, or formulas.

Fillintheblankstocompletethesentence.

4. Derivationneedstobecarriedoutmanuallyaftersavingtheplandata.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

5. Youcansummarizetheratiosina

Fillintheblankstocompletethesentence.

6. Top down distribution enables you to distribute the data from a lower

planning level to higher levels.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

7. A is a combination of a forecast model

deliveredbySAPandasetofuser-definedparameters.

Fillintheblankstocompletethesentence.

8. IntegrationisaccomplishedinSAPR/3Enterprisethroughbothreal-time

and synchronization of data in theplan versions across

modules.

Fillintheblankstocompletethesentence.

287

第 304 页 / 共 483 页

TestYourKnowledge AC605

9. is a function that allows you to enter a target

contributionmargininmanualplanningandtohavethesystemcalculatethe

corresponding quantity sold.

Fillintheblankstocompletethesentence.

10. Whichofthefollowingrepresentsaprocessfordistributingdata,whichhas

beenplannedatonelevelinCO-PAtotheadditionallevelsbasedonsome

reference data?

Choosethecorrectanswer(s).

□ A Top down distribution

□ B Bottom up planning

□ C Integrated data distribution

□ D Forecasting

11. Howdo you forecast in manual planning?

12. Whenassessmentcyclesaredefined,youneedtospecifythecontrollingarea

from whichthe assessment will take place.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

288

第 305 页 / 共 483 页

AC605 Test Your Knowledge

Answers

1. Whichofthefollowingisnotapartofaplanninglayout?

Answer: D

Objectives arenot apart of a planninglayout.

2. A professional planning tool has to support the individual planners by

providing personalized access to the required plan data, using planning

packages.

Answer: planning packages

3. Value columns are defined using characteristics, value fields, attributes,

or formulas.

Answer: Value columns

4. Derivationneedstobecarriedoutmanuallyaftersavingtheplandata.

Answer: False

Derivation is automatically carriedout in the background when the plan

data is saved.

5. Youcansummarizetheratiosinaratioscheme.

Answer: ratio scheme.

6. Top down distribution enables you to distribute the data from a lower

planning level to higher levels.

Answer: False

Top down distribution enables you to distribute the data from a higher

planning level to lower levels.

7. Aforecast profileisacombination of aforecast model delivered by SAP

and a set of user-defined parameters.

Answer: forecast profile

289

第 306 页 / 共 483 页

TestYourKnowledge AC605

8. IntegrationisaccomplishedinSAPR/3Enterprisethroughbothreal-time

andperiodicsynchronizationofdataintheplanversionsacrossmodules.

Answer: periodic

9. GoalSeekisafunctionthatallowsyoutoenteratargetcontributionmargin

in manual planning and to have the system calculate the corresponding

quantity sold.

Answer: Goal Seek

10. Whichofthefollowingrepresentsaprocessfordistributingdata,whichhas

beenplannedatonelevelinCO-PAtotheadditionallevelsbasedonsome

reference data?

Answer: A

Top down distribution is a process for distributing data, which has been

planned at one level in CO-PA to the additional levels based on some

reference data.

11. Howdo you forecast in manual planning?

Answer: Inmanualplanning,youmakeaforecastbyselectingavalueora

columnandthenclickingthetheForecastfunction. Inthedialogwindow,

entertherequiredparameters,suchastheforecastperiod,thereferencedata

to be used and the forecast profile.

12. Whenassessmentcyclesaredefined,youneedtospecifythecontrollingarea

from whichthe assessment will take place.

Answer: True

Whenassessmentcyclesaredefined,youneedtospecifythecontrollingarea

fromwhichtheassessmentwilltakeplace. ThisisbecauseallocationsinCO

canonlytakeplacewithinasinglecontrollingareathroughtherestrictions

of SAP cost accounting rules.

290

第 307 页 / 共 483 页

第 308 页 / 共 483 页

第 309 页 / 共 483 页

Unit 6

Information System

Unit Overview

Thisunithelpsyoutodefineandexecutevariousreports. Theunitdescribeshow

to create various report forms. In addition, it explains the difference between

reportsandformsandthefunctionsavailableforlineitemreports.

Unit Objectives

After completing thisunit, you will beableto:

• Evaluate the reporting options

• Introduce drill-down reporting

• Create basic reports

• Create form reports

• Create line item reports

• Transfer the report data

• ExplaintheintegrationbetweenCO-PAandSAPBI

• EvaluatethebenefitsofFinancialAnalyticsinSAPBI

Unit Contents

Lesson: Overview of Financial Analytics ....................................292

Exercise 16: Financial Analytics Overview..............................301

Lesson: Creating Reports......................................................310

Exercise 17: Creating Reports............................................327

Exercise 18: Report Components........................................333

Exercise 19: Form Report.................................................353

Exercise 20: Line Item-Based Reports..................................369

Lesson: Financial Analytics in SAP BI.......................................375

291

第 310 页 / 共 483 页

Unit6: InformationSystem AC605

Lesson: Overview of Financial Analytics

Lesson Overview

ThislessonprovidesanintroductiontoFinancialAnalytics. itdescribesdrill-down

reportingand itsfunctions. In addition, it explainstheprinciplesof drill-down

reporting.

Lesson Objectives

After completingthislesson, you will beable to:

• Evaluate the reporting options

• Introduce drill-down reporting

Business Example

Themanagementofyourcompanywantstoimplementaprofitabilityaccounting

applicationintheSAPsystem. Asamemberoftheprojectteamofyourcompany,

you are supposed to e adviseon thequestion of whether to implement CO-PA

or EC-PCAintheSAP system. You thenwillberesponsibletoimplementthe

selected applications.

Youneedtoevaluatedatainprofitabilityanalysis. Todothis, youneedtodrill

down the data to analyze it.

Forthisreason,youneedtoknowthemainfeaturesofmultidimensionalreports.

292

第 311 页 / 共 483 页

AC605 Lesson: Overview of Financial Analytics

Introduction to Reporting and Drill-Down Reporting

Figure 123: Reporting - Introduction

InSAPsystem,drill-downreportingisanonlinereportingtoolthatallowsyouto

interactivelyevaluatethedatainProfitabilityAnalysis. Youcanselecttherequired

datasetusinganycharacteristicinyourCO-PAsystemanddrawonanykeyfigures

using the dynamic drill-down function. You can display several profitability

segmentsforakeyfigureorseveralkeyfiguresforanyprofitabilitysegment. You

canalsoperformvarianceanalyses,suchasplan/actualcomparisons,fiscalyear

comparisons, orcomparisonsofprofitabilitysegments.

Indrill-downreporting,youcandisplaybothreportswithasimple,fixedlayout,

basicreports,andreportswithamorecomplexstructureandformatting, form

reports.

The drill-down functions are divided into three groups, each with a different

scope. Eachusercanchooseorbeassignedthefunctionlevelthatsuitstheuser's

requirements.

Themenusandthefunctionsavailableinthedrill-downreportareuser-friendly.

Drill-downreportingisusedinbothcosting-basedandaccount-basedCO-PA.The

differencesbetweenthetwomethodsareexplainedinalaterfigure. Drill-down

Reporting:

293

第 312 页 / 共 483 页

Unit6: InformationSystem AC605

Figure 124: Drilldown: Overview

Youcansummarizethedataaccordingtothederivedcharacteristicsandthendrill

downinteractivelyinreporting. Ateachlevelofthereport,youcandisplaythe

drill-downlist(overview)orextensiveinformation(marginanalysis).

Principles of Drilldown Reporting

Figure 125: Report Output Types (1)

294