AC605_EN_Col92_FV_Part_A4 (第10页)

第 348 页 / 共 483 页

Unit6: InformationSystem AC605

Callthenewbasicreport,BRXX,whereXXisyourgroupnumber,and

enter anappropriatedescription. Createthereportdefinition sothat

thesalesorganization, division, customer, and product are sortedin

this order.

Select all the values from the Sales Control key figure scheme for

your report.

Setthedefaultvaluesforthemonthsfrom1to12ofthecurrentfiscal

year,selecttheplan/actualindicator,0,andtherecordtype,F.Setthe

report sothat it isexecutedin theoperatingconcerncurrency using

summarized and current data.

ProfitabilityAnalysis→Information System →DefineReport→

Create Profitability Report.

Name: BRXX

Description: (forexample)Salesand Profit1

Select Basic report and then Create.

SelectOperatingConcernCurrency. Fromthetableontheright,select

theappropriatecharacteristicsandcopythemtothetableontheleft

usingthesinglearrowicon. Remembertosortyourcharacteristics.

FieldNameorDataType Values

SalesOrganization 1000

Division --

Customer --

Product --

Select Sort UserDefined Characteristics, and makethe necessary

changes.

SelecttherequiredkeyfiguresontheKeyFiguresscreen. All value

fieldsaredisplayed by default on theright.

SelectInvoicedQuantityandRevenues. Copythekeyfigurestothe

tableon the left using the single arrow.

SelecttheVariabletabandmaketheappropriatesettings. Allvariables

should be changeable at execution.

Continued on next page

330

FieldNameorDataType	Values
SalesOrganization	1000
Division	--
Customer	--
Product	--

第 349 页 / 共 483 页

AC605 Lesson: Creating Reports

FieldNameorDataType Values

From period 001/CurrentfiscalyearEnterat

Execution

To period 012/CurrentfiscalyearEnterat

execution

Plan/ActualIndicator 0Donotenteratexecution

Version BlankDonotenteratExecution

Record Type FDonotenteratExecution

For thereportoutput, youhavedecidedto usetheGraphical report

output option, with the Info Control, Navigation Control, and

Drill-down control output area.

SelecttheOptionstab. InthePerformancedialogbox,selectDisplay

Current Data. You want to read summarization levels and, if no

summarizationisavailable,youwantthereporttobeexecutedwithout

any warning or error messages being issued. These performance

settingswill bediscussed at alater point.

Savethebasicreportdefinition. ConfirmtheChooseHierarchyDialog

box.

2. Execute your report using the default settings you have made. You may

receive a system warning message that no summarization data exists.

Confirm this message.

Howdoesthisreportlayoutdifferfromthereportyoucarriedoutinexercise

1-1?

a) Executeyourreportusingthedefaultsettingsyouhavemade. Youmay

receiveasystemwarningmessagethatnosummarizationdataexists.

Confirm this message.

Report → Execute

Howdoesthisreportlayoutdifferfromthereportyoucarriedoutin

exercise 1-1?

Thereportshowsbothadrill-downlistandthedetailedlistbutno

graphical display of the report data.

331

FieldNameorDataType	Values
From period	001/CurrentfiscalyearEnterat Execution
To period	012/CurrentfiscalyearEnterat execution
Plan/ActualIndicator	0Donotenteratexecution
Version	BlankDonotenteratExecution
Record Type	FDonotenteratExecution

第 350 页 / 共 483 页

Unit6: InformationSystem AC605

332

第 351 页 / 共 483 页

AC605 Lesson: Creating Reports

Exercise 18: Report Components

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Evaluate the existing key figure schemes

• Create a key figure scheme

• Create a master data hierarchy

Business Example

Your controllingmanagerwantstoseean initialdraftof acontribution margin

report. Themanagerhasgivenyouanoutlineofthelineitemsthatthemanager

wants to see in the report.

Your sales manager wants to group customers in different ways to evaluate

customer performance shares.

TheCEOwantsthefollowingitemstohaveconsistentdefinitionswheneverthey

are used in cost-based CO-PA reports: Net Revenue, Contribution Margin I,

ContributionMarginIIandOperatingProfit. Whenoneoftheseitemsisusedina

report, it should have a specific meaning.

Task 1:

To createa samplecontribution margin report, displaytheSalesControl Sales

ControlkeyfigureschemeintheCO-PACustomizingsettingsReportComponents.

Hint: Akeyfigureschemeconsistsofagroupofformulaeusedtodefine

keyfigures. Theindividualformulaeareknownaselementsof thekey

figurescheme. Theyarebasedonpreviouselementsandvaluefields. The

elementsofthekeyfigureschemecanbebasedonexistingelementsof

thesameschemeanddatabasefields. Youcandefinethetextandspecial

displayparametersforeachelement. Aswithvaluefields,youcanusethe

elementsofthekeyfigureschemeintheformorthereportitself.

1. Whataretheelementsofthiskeyfigurescheme? Indicatewhichelements

are formulae:

DisplaythebasicformulafortheNetRevenuekeyfigurecomponent. What

istheformula associated with thiscomponent?

2. Modify the report you created in exercise 1-1, to include this key figure

scheme. Makesureyoudeletetheexistingvaluefieldsinyourreportbefore

youaddthekeyfigurescheme. Executethereportandwritedownthekey

figuresthatappearinthedrill-downanddetaillists.

Continued on next page

333

第 352 页 / 共 483 页

Unit6: InformationSystem AC605

Select the KeyFigurestab and removetheselected valuefields fromthe

table on the left.

Addall thekeyfiguresfromtheSalesControl keyfigureschemeto your

report. Todothis,selectthedoublearrowthatpointstotheleft.

Saveyourreportandexecuteitforthesameparametersasabove.

Task 2:

Create a new key figure scheme in costing-based CO-PA reports, which will

containthedefinitionsforthemarketingkeyfiguresthatyourCEOwantstoview

in the profitability report.

Name the scheme, ##, where ## is your group number, and enter a clear

description. Define the following four elements inthekeyfigurescheme: Net

Revenue,ContributionMarginI,ContributionMarginIIandOperatingProfit.

TheCEOhasstipulatedthatthesekeyfiguresbedefinedasfollows:

Component Meaning

Net revenue Revenue minus discounts and

rebates(incl. cost-accountingvalue)

ContributionmarginI Netrevenueminusstandardcostof

goods sold

ContributionmarginII Contribution margin I minus

production variances

Operating profit ContributionmarginIIminusperiod

costs (Sales and administrative

overheads)

Name: ##

Description: (forexampleGroup## Scheme)

1. Saveandthendefinetheinformationaboutthescheme. SelectDetailsand

thenchooseNewEntriestodefinethefirstelement. Forexample:

ElementofKFScheme 010

Short Text Net Revenue

Medium-Length Text Net Revenue

Long Text Net Revenue

ChooseBasicFormula. SelectChooseEntriesandthefollowingvaluefields:

Continued on next page

334

Component	Meaning
Net revenue	Revenue minus discounts and rebates(incl. cost-accountingvalue)
ContributionmarginI	Netrevenueminusstandardcostof goods sold
ContributionmarginII	Contribution margin I minus production variances
Operating profit	ContributionmarginIIminusperiod costs (Sales and administrative overheads)

ElementofKFScheme	010
Short Text	Net Revenue
Medium-Length Text	Net Revenue
Long Text	Net Revenue

第 353 页 / 共 483 页

AC605 Lesson: Creating Reports

Element Description

9005 Sales Rev.

9006 Quantity Discount

9007 Customer Discount

9008 Material Discount

9010 Other Discount

9011 Cash Discount

Afteryouhaveconfirmedtheselecteditems,changethe+signsto-signsin

frontofthesalesdeductions,exceptRevenue. Savethedefinition.

Iftimeallows,createanewbasicreportusingyourkeyfigurescheme.

Task 3:

Your sales manager wants to group customers in the sales organization into

segmentsbasedonrevenueperformance. Createacharacteristicshierarchyfor

customers. Namethishierarchyvariant,##1,where##isyourgroupnumber,and

enter an appropriate description that also contains your group number. Next,

maintainthehierarchysothatcustomersarebrokendownintothefollowingfour

categories:

SegmentA SegmentB SegmentC New

Customer 1174, 1300, 1901, 2140, 1171, 2141, T-CO05A##

no. 1900, 1175, 1001, 1321, 1034, 2300,

1032,2004 2200, 1033, 2000

2007, 2130,

1460

1. For nodes in the hierarchy with no direct posting, create the following

values, where ## is your group number. Enter the customers under each

node, as indicated in the table above.

Selectthecharacteristic,Customer,fromthelistofcharacteristicsontheleft.

EnterthevariantnumberforyourgroupandselectCreate.

Enter a description and select Hierarchy.

Startingwiththetopnode, enterthenumber,999999##, where##isyour

groupnumber,directlyinthenodeandselectENTER.Enteradescription,

CustomerHierGr##, inthetextbox for thenode.

Continued on next page

335

Element	Description
9005	Sales Rev.
9006	Quantity Discount
9007	Customer Discount
9008	Material Discount
9010	Other Discount
9011	Cash Discount

	SegmentA	SegmentB	SegmentC	New
Customer no.	1174, 1300, 1900, 1175, 1032,2004	1901, 2140, 1001, 1321, 2200, 1033, 2007, 2130, 1460	1171, 2141, 1034, 2300, 2000	T-CO05A##

第 354 页 / 共 483 页

Unit6: InformationSystem AC605

Createothernodesinthesameway, followingtheinstructionsbelowand

fill in the characteristic values for each node. To enter node text, select

ENTER once you have added a node key.

99999## Customer Hierarchy Gr.## | ----

99991## Segment A

|__1174

|__1300

|__…..

---- 99992## Segment B

|__1901

|__2140

|__…

---- 99993## Segment C

|__1171

|__…

---- 99994## New

T-CO05A##

|__….

Save the hierarchy.

2. Next, add the characteristic hierarchy to the basic report you created in

exercise1-1. Notethatoneoftheoptionswhenaddingacharacteristicto

areportistoaddamasterdatahierarchy. Enterthehierarchyvariant,##1,

save,andexecutethereportforthesameparametersasabove.

Select the Hierarchy option next to the customer characteristic. At the

prompt,selectyourhierarchyfromthelistdisplayed. Executethereport.

3. Usethemasterdatahierarchytomovethroughthereport.

Expand and collapse the branches of the hierarchy using the hierarchy

navigationfeaturesinthereportlist. Howwouldyouremovethehierarchy

from the report data displayed?

Continued on next page

336

第 355 页 / 共 483 页

AC605 Lesson: Creating Reports

Task 4:

Yourmanagerrequiresprofitabilityreportsatthemonth-endalongthestrategic

businessunitsofthecompanybytheincomestatementaccountintwocurrencies.

Themanagerrequiresoneparticularreportwherethemanagercanselectonlythe

transactionsthat took place for a given company code inaspecifictransaction

currency. Thisenablesthemanagertoanalyzeandreportthebusinessvolumethat

eachSBUgeneratesinthelocalandforeigncurrencies.

1. Togeneratethesereports,createabasicreportforthecontrollingarea,1000,

in account-based CO-PA and name it BRXX, where XX is your group

number. Enter a suitable description.

Createthereportdefinitionsothatthecostelement,SBU,customergroup,

andmaterialgroup aresortedinthisorder. Select keyfiguressothat itis

possibletoreportontheselectedtransactionsinthreecurrencies(totalonly;

do not include quantities or fixed portions).

2. Setupavariablesothatyoucanenterthecompanycodeandthetransaction

currencywhenyouexecutethereport. Enterthefollowingstandardvalues:

Company code, 1000, the currency, EURO, the current fiscal year, the

plan/actualindicator,0(actualdata),andnoplanversion. Inaddition,setthe

reporttoexecutewithoutwarningsagainstsummarizationlevels.

Save the basic report definition. In the Performance dialog box, choose

DisplayCurrentData. Youwanttouseasummarizationlevel. Youdonot

wantanymessagestoappearifthereisnolevel(Executereport).

3. Whenyoucreatethereportdefinition, werethecharacteristics, Customer

andProduct,available? Whyisitnotpossibletoanalyzethecostelements

bycustomerandproductintheIDEAoperatingconcerninaccount-based

CO-PA?

Whenyoucreatedthereportdefinition,wastheRecordtypecharacteristic

availableaseitheracharacteristicchoiceoravariable? Whenyoucreated

the report definition, was the Record type characteristic available as a

drill-downcharacteristicorvariable? Whatisthepurposeoftherecordtype

incosting-based CO-PA,andwhy isthisobject missing inaccount-based

CO-PA?

4. Execute the report you just created for the actual data in the company

code, 1000, and for the current fiscal year. When using basic reports in

account-basedCO-PA,placethecostelementatthetopofthecharacteristic

sortorderbecausethevaluesinthecolumnsareonlyusefuliftheyarelinked

toacostelement. Drillingdowntotheothercharacteristicsinacostelement

makes sense, but the opposite is not true.

337

第 356 页 / 共 483 页

Unit6: InformationSystem AC605

Solution 18: Report Components

Task 1:

To createa samplecontributionmargin report, display theSalesControl Sales

ControlkeyfigureschemeintheCO-PACustomizingsettingsReportComponents.

Hint: Akeyfigureschemeconsistsofagroupofformulaeusedtodefine

keyfigures. Theindividualformulaeareknownaselementsofthekey

figurescheme. Theyarebasedonpreviouselementsandvaluefields. The

elementsofthekeyfigureschemecanbebasedonexistingelementsof

thesameschemeanddatabasefields. Youcandefinethetextandspecial

displayparametersforeachelement. Aswithvaluefields,youcanusethe

elementsofthekeyfigureschemeintheformorthereportitself.

1. Whataretheelementsofthiskeyfigurescheme? Indicatewhichelements

are formulae:

DisplaythebasicformulafortheNetRevenuekeyfigurecomponent. What

is theformulaassociated withthiscomponent?

a) To create a sample contribution margin report, display the Sales

ControlkeyfigureschemeintheCO-PACustomizingsettingsReport

Components.

Hint: A keyfigurescheme consistsof agroup of formulae

usedtodefinekeyfigures. Theindividualformulaeareknown

aselementsofthekeyfigureschemeandarebasedonprevious

elements and value fields. The elements of the key figure

scheme can be based on the existing elements of the same

schemeand ondatabasefields. Youcandefine thetext and

special displayparameters for eachelement. Aswith value

fields,youcanusetheelementsofthekeyfigureschemeinthe

form or in the report itself.

What are the elements of this key figure scheme? Indicate which

elements are formulae:

IMG → Profitability Analysis → Information System → Report

Components→DefineKeyFigureSchemes: Selectthekeyfigure

scheme, VC, and select Details → Elements of the Key Figure

Scheme.

Sales quantity

Revenues

Continued on next page

338

第 357 页 / 共 483 页

AC605 Lesson: Creating Reports

Sales deductions

Net revenue

Raw material

Variable production costs

Variable cost of goods manufactured

Contribution margin I

CM I/Quantity

Fixed costs of goods manufactured

Total overhead costs

Contribution margin II

CM II/Quantity

Administration costs

Sales costs

Contribution margin III

CM III/Quantity

DisplaythebasicformulafortheNetRevenuekeyfigurecomponent.

Whatistheformulaassociatedwiththiscomponent?

Select Net Revenue Element and choose “Basic Formula” from

the toolbar.

Revenues – Sales Deductions

2. Modify the report you created in exercise 1-1, to include this key figure

scheme. Makesureyoudeletetheexistingvaluefieldsinyourreportbefore

youaddthekeyfigurescheme. Executethereportandwritedownthekey

figuresthatappearinthedrill-downanddetaillists.

Select theKeyFigurestabandremovethe selected valuefieldsfrom the

table on the left.

Addall thekey figuresfromtheSalesControl keyfigureschemetoyour

report. Todothis,selectthedoublearrowthatpointstotheleft.

Continued on next page

339

第 358 页 / 共 483 页

Unit6: InformationSystem AC605

Saveyourreportandexecuteitforthesameparametersasabove.

a) Modifythereportyoucreatedinexercise1-1,toincludethiskeyfigure

scheme. Makesureyoudeletetheexistingvaluefieldsinyourreport

beforeyouaddthekey figurescheme. Execute thereport andwrite

downthekeyfiguresthatappearinthedrill-downanddetaillists.

Accounting→Controlling→ProfitabilityAnalysis→Information

System→DefineReport→ChangeReport.

FieldNameorDataType Values

Report BR##

SelecttheKeyFigurestabandremovetheselectedvaluefieldsfrom

the table on the left.

Choose“ValueFieldOn/Off”andclickitonce. Thiswillremove

the value fields from the selection table on the right. Enter the

SalesControlkeyfigureschemeintheappropriateselectionfield.

AddallthekeyfiguresfromtheSalesControlkeyfigureschemeto

yourreport. Todothis,selectthedoublearrowthatpointstotheleft.

Saveyourreportandexecuteitforthesameparametersasabove.

Continued on next page

340

FieldNameorDataType	Values
Report	BR##

第 359 页 / 共 483 页

AC605 Lesson: Creating Reports

Task 2:

Create a new key figure scheme in costing-based CO-PA reports, which will

containthedefinitionsforthemarketingkeyfiguresthatyourCEOwantstoview

in the profitability report.

Name the scheme, ##, where ## is your group number, and enter a clear

description. Define the following four elementsin the keyfigurescheme: Net

Revenue,ContributionMarginI,ContributionMarginIIandOperatingProfit.

TheCEOhasstipulatedthatthesekeyfiguresbedefinedasfollows:

Component Meaning

Net revenue Revenue minus discounts and

rebates(incl. cost-accountingvalue)

Contribution margin I Netrevenueminusstandardcostof

goods sold

ContributionmarginII Contribution margin I minus

production variances

Operating profit ContributionmarginIIminusperiod

costs (Sales and administrative

overheads)

Name: ##

Description: (for exampleGroup ## Scheme)

1. Saveandthendefinetheinformationaboutthescheme. SelectDetailsand

thenchooseNewEntriestodefinethefirstelement. Forexample:

Elementof KFScheme 010

Short Text Net Revenue

Medium-Length Text Net Revenue

Long Text Net Revenue

ChooseBasicFormula. SelectChooseEntriesandthefollowingvaluefields:

Element Description

9005 Sales Rev.

9006 Quantity Discount

9007 Customer Discount

Continued on next page

341

Component	Meaning
Net revenue	Revenue minus discounts and rebates(incl. cost-accountingvalue)
Contribution margin I	Netrevenueminusstandardcostof goods sold
ContributionmarginII	Contribution margin I minus production variances
Operating profit	ContributionmarginIIminusperiod costs (Sales and administrative overheads)

Elementof KFScheme	010
Short Text	Net Revenue
Medium-Length Text	Net Revenue
Long Text	Net Revenue

Element	Description
9005	Sales Rev.
9006	Quantity Discount
9007	Customer Discount

第 360 页 / 共 483 页

Unit6: InformationSystem AC605

9008 Material Discount

9010 Other Discount

9011 Cash Discount

Afteryouhaveconfirmedtheselecteditems,changethe+signsto-signsin

frontofthesalesdeductions,exceptRevenue. Savethedefinition.

Iftimeallows,createanewbasicreportusingyourkeyfigurescheme.

a) Createanewkeyfigureschemeincosting-basedCO-PAreports,which

willcontainthedefinitionsforthemarketingkeyfiguresthattheCEO

wantsto view in the profitability report.

Name the scheme, ##, where ## is your group number, and enter a

cleardescription. Definethefollowingfourelementsinthekeyfigure

scheme: Net Revenue, Contribution MarginI, ContributionMargin

II and Operating Profit.

TheCEOhasstipulatedthatthesekeyfiguresbedefinedasfollows:

Component Meaning

Net revenue Revenue minus discounts and

rebates (incl. cost-accounting

value)

ContributionmarginI Net revenue minus standard

cost of goods sold

ContributionmarginII Contribution margin I minus

productionvariances

Operating profit Contribution margin II

minus period costs (Sales and

administrativeoverheads)

ProfitabilityAnalysis→ Environment → Set OperatingConcern.

Choosecosting-basedCO-PAfortheIDEAoperatingconcern.

IMG→Controlling→ProfitabilityAnalysis→InformationSystem

→ReportComponents→DefineKeyFigureSchemes. ChooseNew

Entries.

Key Figure Scheme: ##

Medium-LengthText: (forexampleGroup##Scheme)

Definetheinformationaboutthescheme. SelectDetailsandchoose

NewEntriestodefinethefirstelement. Forexample:

Continued on next page

342

9008	Material Discount
9010	Other Discount
9011	Cash Discount

Component	Meaning
Net revenue	Revenue minus discounts and rebates (incl. cost-accounting value)
ContributionmarginI	Net revenue minus standard cost of goods sold
ContributionmarginII	Contribution margin I minus productionvariances
Operating profit	Contribution margin II minus period costs (Sales and administrativeoverheads)

第 361 页 / 共 483 页

AC605 Lesson: Creating Reports

Double-click Elements of Key Figure Scheme and choose New

entries:

Element Number: 010

Short Text: Net revenue

Medium-Length Text: Net revenue

Long Text: Net revenue

Choose Basic formula. Select Choose Entries and choose the

following value fields:

Element Description

9008 Sales Rev.

9009 QuantityDiscount

9010 CustomerDiscount

9011 Material discount

9012 Other Discount

9011 Cash Discount

After youhaveconfirmedtheselecteditems, changethe+signsto-

signs infront of the salesdeductions, exceptRevenue. Confirmthe

entries. Save the definition.

Usethenavigationbuttonsor themenupathGoto→NextEntryto

createmoreelementsinthescheme. Eachsubsequentelementcanuse

thepreviouselementasareference. Thismakesitrelativelyeasyto

carry out the definition process.

Afterthelastelementhasbeendefined,savethestructure.

Iftimepermits,createanewbasicreportusingyourkeyfigurescheme.

Continued on next page

343

Element Number:	010
Short Text:	Net revenue
Medium-Length Text:	Net revenue
Long Text:	Net revenue

Element	Description
9008	Sales Rev.
9009	QuantityDiscount
9010	CustomerDiscount
9011	Material discount
9012	Other Discount
9011	Cash Discount

第 362 页 / 共 483 页

Unit6: InformationSystem AC605

Task 3:

Your sales manager wants to group customers in the sales organization into

segmentsbasedonrevenueperformance. Createacharacteristicshierarchyfor

customers. Namethishierarchyvariant,##1,where##isyourgroupnumber,and

enter an appropriate description that also contains your group number. Next,

maintainthehierarchysothatcustomersarebrokendownintothefollowingfour

categories:

SegmentA SegmentB SegmentC New

Customer 1174, 1300, 1901, 2140, 1171, 2141, T-CO05A##

no. 1900, 1175, 1001, 1321, 1034, 2300,

1032,2004 2200, 1033, 2000

2007, 2130,

1460

1. For nodes in the hierarchy with no direct posting, create the following

values, where ## is your group number. Enter the customers under each

node, as indicated in the table above.

Selectthecharacteristic,Customer,fromthelistofcharacteristicsontheleft.

EnterthevariantnumberforyourgroupandselectCreate.

Enter a description and select Hierarchy.

Startingwiththetopnode, enter thenumber,999999##, where##isyour

groupnumber,directlyinthenodeandselectENTER.Enteradescription,

CustomerHierGr##, inthetextboxforthenode.

Createothernodesinthesameway, followingtheinstructionsbelowand

fill in the characteristic values for each node. To enter node text, select

ENTER once you have added a node key.

99999## Customer Hierarchy Gr.## | ----

99991## Segment A

|__1174

|__1300

|__…..

---- 99992## Segment B

|__1901

|__2140

|__…

---- 99993## Segment C

Continued on next page

344

	SegmentA	SegmentB	SegmentC	New
Customer no.	1174, 1300, 1900, 1175, 1032,2004	1901, 2140, 1001, 1321, 2200, 1033, 2007, 2130, 1460	1171, 2141, 1034, 2300, 2000	T-CO05A##

第 363 页 / 共 483 页

AC605 Lesson: Creating Reports

|__1171

|__…

---- 99994## New

T-CO05A##

|__….

Save the hierarchy.

a) Yoursalesmanagerwantstogroupcustomersinthesalesorganization

intosegmentsbasedonrevenueperformance. Createacharacteristics

hierarchyforcustomers. Namethishierarchyvariant,##1, where##

isyourgroupnumber, andenteranappropriatedescriptionthatalso

contains your group number. Next, maintain the hierarchy so that

customersarebrokendownintothefollowingfourcategories:

SegmentA SegmentB SegmentC New

Customer 1174,1300, 1901,2140, 1171,2141, T-CO05A##

no. 1900,1175, 1001,1321, 1034,2300,

1032,2004 2200,1033, 2000

2007,2130,

1460

Fornodesinthehierarchywithnodirectposting,createthefollowing

values,where##isyourgroupnumber. Enterthecustomersundereach

node, as indicated in the table above.

ProfitabilityAnalysis→ Master Data→ CharacteristicValues →

Define Characteristics Hierarchy

Selectthecharacteristic,Customer,fromthelistofcharacteristicson

theleft. EnterthevariantnumberforyourgroupandselectCreate.

Enter adescription and select Hierarchy.

Startingwiththetopnode, enterthenumber,999999##, where##is

yourgroup number, directlyinthenodeand select ENTER.Enter a

description,CustomerHierGr##,inthetextboxforthenode.

Createothernodesinthesameway,followingtheinstructionsbelow,

andfillinthecharacteristicvaluesforeachnode. Toenternodetext,

selectENTERafteryouhaveaddedanodekey.

UsethecorrespondingiconsortheoptionsintheEditmenutoinsert

nodes or levels.

Createanduse999999##forthetopnodewithnodirectposting(call

it Customer Hierarchy).

Continued on next page

345

	SegmentA	SegmentB	SegmentC	New
Customer no.	1174,1300, 1900,1175, 1032,2004	1901,2140, 1001,1321, 2200,1033, 2007,2130, 1460	1171,2141, 1034,2300, 2000	T-CO05A##

第 364 页 / 共 483 页

Unit6: InformationSystem AC605

99999## Customer HierarchyGr.## | ----

99991## Segment A

|__1174

|__1300

|__…..

---- 99992## Segment B

|__1901

|__2140

|__…

---- 99993## Segment C

|__1171

|__…

---- 99994## New

T-CO05A##

|__….

Save the hierarchy.

2. Next, add the characteristic hierarchy to the basic report you created in

exercise1-1. Notethatoneoftheoptionswhenaddingacharacteristicto

areportistoaddamasterdatahierarchy. Enterthehierarchyvariant,##1,

save,andexecutethereportforthesameparametersasabove.

Continued on next page

346

第 365 页 / 共 483 页

AC605 Lesson: Creating Reports

Select the Hierarchy option next to the customer characteristic. At the

prompt,selectyourhierarchyfromthelistdisplayed. Executethereport.

a) Next,addthecharacteristichierarchytothebasicreportyoucreatedin

exercises1-1. Notethatoneoftheoptionswhenaddingacharacteristic

toareportistoaddamasterdatahierarchy. Enterthehierarchyvariant,

##1,save,andexecutethereportforthesameparametersasabove.

Accounting→Controlling→ProfitabilityAnalysis→Information

System→DefineReport →ChangeReport.

FieldNameorDataType Values

Report BR##

SelecttheHierarchyoption(secondcheckbox)nexttothecustomer

characteristic. At the prompt, select your hierarchy from the list

displayed. Execute the report.

Report → Execute

3. Usethemasterdatahierarchytomovethroughthereport.

Expand and collapse the branches of the hierarchy using the hierarchy

navigationfeaturesinthereportlist. Howwouldyouremovethehierarchy

from the report data displayed?

a) Usethemasterdatahierarchytomovethroughthereport.

Expandandcollapsethebranchesofthehierarchyusingthehierarchy

navigation featuresin thereportitself. Howwould you removethe

hierarchy fromthereport data displayed?

Edit→HierarchySelection: Nohierarchy

Task 4:

Yourmanagerrequiresprofitabilityreportsatthemonth-endalongthestrategic

businessunitsofthecompanybytheincomestatementaccountintwocurrencies.

Themanagerrequiresoneparticularreportwherethemanagercanselectonlythe

transactionsthat took place for a given company code inaspecifictransaction

currency. Thisenablesthemanagertoanalyzeandreportthebusinessvolumethat

eachSBUgeneratesinthelocalandforeigncurrencies.

1. Togeneratethesereports,createabasicreportforthecontrollingarea,1000,

in account-based CO-PA and name it BRXX, where XX is your group

number. Enter a suitable description.

Continued on next page

347

FieldNameorDataType	Values
Report	BR##

第 366 页 / 共 483 页

Unit6: InformationSystem AC605

Createthereportdefinitionsothatthecostelement,SBU,customergroup,

andmaterialgroup aresorted inthisorder. Selectkey figuressothat itis

possibletoreportontheselectedtransactionsinthreecurrencies(totalonly;

do not includequantities or fixedportions).

a) Your manager requires profitability reports at the month-end along

thestrategicbusinessunitsofthecompanybytheincomestatement

accountintwocurrencies. Themanagerrequiresoneparticularreport

wherethemanagercanselectonlythetransactionsthattookplacefora

givencompanycodeinaspecifictransactioncurrency. Thisenables

themanagertoanalyzeandreportthebusinessvolumethateachSBU

generatesinthelocal andforeigncurrencies.

Togeneratethesereports,createabasicreportforthecontrollingarea,

1000,inaccount-basedCO-PAandnameitBRXX,whereXXisyour

groupnumber. Enter asuitabledescription.

Createthereportdefinitionsothat thecost element, SBU,customer

group, andmaterialgrouparesortedinthisorder. Selectkeyfigures

so that it is possible to report on the selected transactions in three

currencies(totalonly;donotincludequantitiesorfixedportions).

2. Setupavariablesothatyoucanenterthecompanycodeandthetransaction

currencywhenyouexecutethereport. Enterthefollowingstandardvalues:

Company code, 1000, the currency, EURO, the current fiscal year, the

plan/actualindicator,0(actualdata),andnoplanversion. Inaddition,setthe

reporttoexecutewithoutwarningsagainstsummarizationlevels.

Continued on next page

348

第 367 页 / 共 483 页

AC605 Lesson: Creating Reports

Save the basic report definition. In the Performance dialog box, choose

DisplayCurrentData. Youwanttouseasummarizationlevel. Youdonot

wantanymessagestoappearifthereisnolevel(Executereport).

a) Set up a variable so that you can enter the company code and the

transactioncurrencywhenyouexecutethereport. Enterthefollowing

standard values: Company code, 1000, the currency, EURO, the

current fiscal year, the plan/actual indicator, 0 (actual data), and no

planversion. Inaddition, set thereporttoexecutewithoutwarnings

against summarization levels.

ProfitabilityAnalysis→ Environment →Set Operating Concern.

Chooseaccount-basedCO-PAforoperatingconcernIDEA.

SelectEnvironment→SetOperatingConcern. Selecttheoperating

concern IDEA.

ProfitabilityAnalysis→InformationSystem →DefineReport→

Create Profitability Report.

Name: BRXXDescription: BusinessbyTrans. Currency

ChooseBasicreport and then Create.

Select the required six characteristics in the Characteristic

selectionscreen. (Ifnecessary,scrollupordownandrememberto

specifyCompanyCodeandcurrency.) Youcanaccessthisscreen

byselectingGoto → Characteristics. Afteryou havechosen the

characteristics,selectSortUser-definedCharacteristics. Position

Companycode and Currencyat thetop.

Tocreateavariable,positionthecursoronthe“Companycode”

field and select “Variable on/off”.

Choosetherequiredkeyfiguresonthe“keyfigures”screen(Value

ObjCurr,ValueTranCurr,andValueCOCurr). Selecttherequired

key figures. You can access this screen using the scroll keys or

byselectingGoto→SelectKeyFigures. Selecttherequired key

figuresand choose“Add Key Figures”.

Enterdefault valuesforthefrom/toperiodsand theplan/actual

indicator,suchastheperiodfrom001to012inthecurrentfiscal

year,onthe“variables”screen. Youcanaccessthisscreenusingthe

scrollkeysorbyselectingGoto→Variables.

Save the report definition. In thePerformance dialog box, choose

DisplayCurrentData. Youwanttouseasummarizationlevel. Youdo

notwantanymessagestoappearifthereisnolevel(Executereport).

Continued on next page

349

第 368 页 / 共 483 页

Unit6: InformationSystem AC605

3. Whenyoucreatethereportdefinition, werethecharacteristics,Customer

andProduct,available? Whyisitnotpossibletoanalyzethecostelements

bycustomerandproductintheIDEAoperatingconcerninaccount-based

CO-PA?

Whenyoucreatedthereportdefinition, wastheRecordtypecharacteristic

availableaseitheracharacteristicchoiceoravariable? Whenyoucreated

the report definition, was the Record type characteristic available as a

drill-downcharacteristicorvariable? Whatisthepurposeoftherecordtype

in costing-basedCO-PA,andwhy isthisobjectmissingin account-based

CO-PA?

a) When you create the report definition, were the characteristics,

CustomerandProduct,available? Whyisitnotpossibletoanalyzethe

costelementsbycustomerandproductintheIDEAoperatingconcern

in account-based CO-PA?

Thecustomerandtheproductarenotavailable,astheyarenotobject

levelcharacteristicsfortheACCOUNT-BASEDprofitabilityanalysis

of the IDEA operating concern. This means that separate totals

recordsarenotavailableforthecharacteristicvalues.

When you created the report definition, was the Record type

characteristicavailableaseitheracharacteristicchoiceoravariable?

When you created the report definition, was the Record type

characteristicavailableasadrill-downcharacteristicorvariable? What

isthepurposeoftherecordtypeincosting-basedCO-PA,andwhyis

thisobjectmissingin account-basedCO-PA?

Thepurposeoftherecordtypeincosting-basedCO-PAistoindicate

thesourceofthedatatransferredtoProfitabilityAnalysis, suchas

billing,costcenterassessment,andsettlement. Youcannotstorethe

recordtype foraccount-based CO-PA because itstransaction and

summaryrecordsarestoredingeneralCOtransactiondatatables.

Run the report you have just created.

4. Execute the report you just created for the actual data in the company

code, 1000, and for the current fiscal year. When using basic reports in

account-basedCO-PA,placethecostelementatthetopofthecharacteristic

Continued on next page

350

第 369 页 / 共 483 页

AC605 Lesson: Creating Reports

sortorderbecausethevaluesinthecolumnsareonlyusefuliftheyarelinked

toacostelement. Drillingdowntotheothercharacteristicsinacostelement

makes sense, but the opposite is not true.

a) Executethereportyoujustcreatedfortheactualdatainthecompany

code,1000,andforthecurrentfiscalyear. Whenusingbasicreports

in account-based CO-PA, place the cost element at the top of the

characteristicsort order becausethe valuesin the columnsareonly

usefuliftheyarelinkedtoacostelement. Drillingdowntotheother

characteristicsinacostelementmakessense,buttheoppositeisnot

true.

End of optional exercises

351

第 370 页 / 共 483 页

Unit6: InformationSystem AC605

352

第 371 页 / 共 483 页

AC605 Lesson: Creating Reports

Exercise 19: Form Report

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Createasimpleformreportincosting-basedCO-PA,executeit,andnavigate

through it

• Create a more complex form report in costing-based CO-PA, execute it,

and navigate through it

• Understand how to use variablesin reporting

Business Example

Your sales manager wants to obtain a quarterly trend report with regard to

the customer and the product, using the Sales Control key figure scheme.

Another salesmanagerrequiresasimilarreport butwantstofocusonthesales

divisionsanddistributionchannels. Aheadofdepartmentalsorequiresquarterly

informationsortedbytheproduct andquantitiessold.

Task 1:

Mostcompaniesdrawupquarterlyreports. Themostefficientwayofdoingthisis

to use form reporting in CO-PA.

Hint: Aformisaformalstructureofrowsandcolumnsthatyoucanuse

inanynumberofreportsinthesameoperatingconcern. Aformrepresents

thecontentandtheformalstructureofareport. Itisatypeoftemplate.

Whenyoucreateareport,youcandecidewhetherornotyouwanttouse

aform. Youdonot needaformtodefinesimplereports. Noticethatif

youwanttorunmorecomplexreportsorformatthedisplayforofficial

reports,itisagoodideatodefineaformbeforeyoucreatethereports.

1. Incosting-basedCO-PA, createaoneaxisformwithoutkeyfigurestobe

used for a specific fiscal year. The form should have the company code,

1000,actualdata,therecordtype,F,andthefollowinglayout:

Quarter1 Quarter2 Quarter3 Quarter4 Total

Nametheform,FR1##Description: QuarterlyProfitabilityAnalysis.

Select the One axis without key figure option to create the form. Select

Operating Concern Currency.

Continued on next page

353

	Quarter1	Quarter2	Quarter3	Quarter4	Total

第 372 页 / 共 483 页

Unit6: InformationSystem AC605

Double-clickthefirstelementandchooseCharacteristics. ChoosePeriod

and then enter the values, 001 to 003.

Enter Quarter 1 in the text fields.

Definethecolumnsforthequarters,2,3,and4,inasimilarway,changing

theperiodvaluestocorrespond withthequarters.

Use a formula to create theTotal column.

In“Generaldataselection”,selectthecharacteristicsPlan/actualindicator,

Recordtype,Fiscalyear,andCompanycode. Specifythevaluesorvariables

for these characteristics.

FieldNameorDataType Values

Company Code 1000

Record Type F

Plan/ActualIndicator 0

Fiscal Year Variable √

Dialogwindow: LocalVariableYear

Save the form definition.

2. Next,usetheformyoujustcreatedtodefineanewreport. Youcandothis

directlyfromtheformbyselecting CreateReport.

SelectReportwithformandenterthenameofyourformintheFormfield.

Select Create.

Note: Thereportandformnamesdonothavetobethesame.

Selectthecharacteristics,CustomerandProduct,forthereport. Select

allthekeyfiguresfromtheSalesControlkeyfigurescheme.

Inaddition,indicatethecurrentfiscalyearasthedefaultyearforthereport.

Ensure that both the company code and the current fiscal year appear in

the header of the report list.

SelectClassicDrill-downastheoutputtypeandusesummarizationdata.

Savetheformreportdefinitionwithoutselectinganyhierarchies.

3. Createaheadertoenterthecompanycodeandthefiscalyear.

Savetheheaderdefinitionandthereportdefinition.

4. Executethereportforthecurrentfiscalyear. Movetoallthecolumnsinthe

reportusingthePageleft/Pagerightarrows. Noticehowthecolumnsinthe

formappearbelowthekeyfigurethatyouselectedinthereportdefinition.

Continued on next page

354

FieldNameorDataType	Values
Company Code	1000
Record Type	F
Plan/ActualIndicator	0
Fiscal Year	Variable √ Dialogwindow: LocalVariableYear

第 373 页 / 共 483 页

AC605 Lesson: Creating Reports

Next,movefromthisoverviewtothedetailviewforaprofitabilitysegment.

Noticethattheresultisacontributionmarginschemeforeachquarter,which

presentsaneasywaytoviewthedataforasinglemarketsegment.

Task 2:

In addition to quarterly reporting, most companies draw up some type of

plan/actual reports.

Youcanuseformreportstodothis. Incosting-basedCO-PA,createatwoaxis

form for a to-be-specified time interval for the company code, 1000 billing

documents. Define a column for Actual values and a column forPlan Values,

Version 5##. In addition, define two formula columns for the absolute and

percentagevariancebetweentheactualandplanfigures. Theformshouldappear

as follows:

Actual Plan Variance Var.%%

Grossrevenue

Salesdeduction

Net revenue after

deductions

Contribution

margin I

FixedCOGM

Material OH

Contribution

margin II

1. Name your report, FR2XX, and enter a descriptionsuch as: Plan/actual

form

FortheVariancecolumn,chooseFormulainsteadofCharacteristic. Define

the formulaasthe Actual column minusthe Plan column. Enter thetext,

Variance.

SelectFormulaasthescreenelementfortheVariance%column. Definethe

formulaasVariancex100/Plancolumn. Enterthetext: Variance

2. Forthefirstrow, usethekeyfigureelement,IDESDETCM,byselecting

KeyFigureSchemewhendefiningtherow. Selecttheappropriatekeyfigure.

Do not select any characteristics, and adopt the text for the key figure.

Proceedinthesamewayfortheremainingsixrows.

3. Next, define the general datafor thereport:

Continued on next page

355

	Actual	Plan	Variance	Var.%%
Grossrevenue
Salesdeduction
Net revenue after deductions
Contribution margin I
FixedCOGM
Material OH
Contribution margin II

第 374 页 / 共 483 页

Unit6: InformationSystem AC605

FieldNameorDataType Values

Record Type F

Period/Year From Variable√Identifier: PF

Period Year To Variable√Identifier: PT

Company Code 1000

4. Tomakeiteasytoreadthedrill-downlist,youhavedecidedtoshowonly

certainkeyfiguresinthereportcolumns. Selectbothplanandactualvalues

for Revenue and CM II.

5. Toenhancetheappearanceof thereport, youdecideto highlightsomeof

the key rows.

Save the form definition.

6. Next,usetheformyoujustcreatedtodefineanewreport. Namethereport,

FR2XX,andenteranappropriatedescription. Selectthefollowingdrilldown

characteristics: SalesOrganization,DivisionandCustomer.

Notice that you cannot select any key figures because you have already

created them in your form definition.

Savethereportandexecuteitforatimeintervalthatproducesresults. Then

switchbetweenthedrilldownandthedetaileddisplay.

Task 3:

1. Whatisthedifferencebetweenlocalandglobalvariables?

2. CreateaglobalvariableforthePeriod/FiscalYearfield.

In the information system of the Profitability Analysis, navigate to the

maintenanceof Define Variablesfor Report.

Task 4:

1. Name the four types of variables. Which typeis used most frequently in

reports? Whichtypeisusedtocustomizetheappearanceofareport? Which

typeisusedtocustomizethemeaningofacolumninareport?

356

FieldNameorDataType	Values
Record Type	F
Period/Year From	Variable√Identifier: PF
Period Year To	Variable√Identifier: PT
Company Code	1000