AC610_EN_Col52_FV_Inst_A4 (第9页) | ERP软件技术分享

第 308 页 / 共 355 页

Unit7: InformationSystem AC610

Figure 96: Basic Report

ThereportdefinitionfunctionscanbeaccessedinCustomizingaswellasviathe

application menu. From the selection screen, you can access all the steps for

processingin thereport definitionin anysequence.

The initial screen offersthevariables Period(from/to), Plan/Actual indicator,

Version, and Fiscal Year for basic reports.

The characteristicselectiondisplaysa list with all characteristics. Here, you

canselectthecharacteristicsthatyourequireforyouranalysis. Thisdefinesthe

dimensionsofthedatacubethatyouwanttoanalyze.

TheKeyFigureSelectionscreenshowsthecosts,revenues,andstocksinthethree

currencies, statistical keyfigures, andaquantityfield.

If you want to delete a report you can do this from the change transaction.

Howeverifyouwanttodeleteanentiregroupofreports,itissimplertodothisin

the Customizing via Reports.

298

第 309 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Figure 97: Variables: Overview

Variablesallowyoumoreflexibilityindefiningyourformsandreports. Variables

arereportorformparameterswhichyoudonotwanttospecifyuntilyoudefine

or execute a report. You can use different methods for replacing variables.

Depending on how often you want to use them, you can defineyour variables

globally or locally.

Ifyouwanttocreateavariablethatyouonlyneedinoneparticularformorreport,

youcancreatealocalvariable. Localvariablesareonlyknownwithintherelevant

formorreport. Ifyoudefinealocalvariableinaform,itisalsovalidforevery

report which uses that form.

Ontheotherhand,ifyoudefineavariableinthereportdefinition,itisonlyvalid

for thatonereport. Ifyouuseavariablefrequently, youcandefineitglobally.

Thismakesitpossibletouseglobalvariablesinallyourformsandreports. Global

variables are maintained in the Customizing. If you then want to use global

variablesinaformorinareport,thesearedisplayedforselectionintheinputhelp.

Hint: Notethatwhenyouchangeanexistingglobalvariable, thismay

affectanumberofreportsandformswhichalreadyuseit.

299

第 310 页 / 共 355 页

Unit7: InformationSystem AC610

Figure 98: Architecture of Drilldown Reporting

Youcanusecharacteristics,keyfigures,andformstodefineareport. Theresult

whenyoudisplay thereport is anumber of listsand graphics that youcan call

up and analyze interactively.

Aformdeterminesthecontentandtheformalstructureofareportlist. Aform

can be thought of as a semifinished report, which you complete by specifying

characteristicsandkey figureswhenyoudefinetheindividual report. You can

specifycharacteristicsbothintheformandinthereport. Keyfigures,however,

canonlybecontainedineithertheformorthereport.

DrilldownreportinginProfitCenterAccountingprovideseasy-to-usefunctions

fornavigatingthroughthedataset. Forexample,youcanmovefromonesegment

tothenext levelorthenextsegmentatthesamelevel, deactivatealevelofthe

drilldownhierarchy,andswitchbetweendetaillistsandoverviewlists. Youalso

haveanumberofotherfunctionsavailableforeditingonlinereports(conditions,

sort orders, ranking lists, and so on). And you can send report lists by fax or

electronicmail,ordownloadthemtoMicrosoftWordorMicrosoftExcel.

Inadditiontothevariousinteractivefunctionsforonlinelists,drilldownreporting

alsoprovidesspecial functionsfor definingthereport layout for printing(page

breaks, headersandfooters, underscores, andmore).

300

第 311 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

There are specifically three form types:

• Form with one axis(without key figure)

– Intheform withoneaxis(without keyfigure) you defineeither the

rowsor columnsof theform with characteristics. The Basicscreen

functionbringsyoufirsttoanemptylistwithcolumns.

• Form with one axis (with key figure)

– Intheformwithoneaxis(withkeyfigure)youdefineeithertherows

orcolumnsoftheformwithkeyfiguresandcharacteristics. TheBasic

screenfunctionbringsyoufirsttoanemptylistwithrows.

• Form with two axes (with key figure)

– Intheformwithtwoaxes(withkeyfigure)youdefineboththerows

and the columns of the form with key figures and characteristics.

TheBasicscreenfunctionbringsyoutoanemptylistwithrowsand

columns. Whethertherowsorthecolumnscontainthekeyfiguresis

optionalanddependsonwhatyouwanttoreporton. Thecharacteristics

can be bothin thecolumnsand intherows.

When you create a form, specify the name and the type of the form that you

want to edit.

Youcananalyzeanumberofkeyfiguresforasinglecombinationofcharacteristic

valuesaswellassinglekeyfiguresforanumberofcombinationsofcharacteristic

values. A combination of characteristic values is generally referred to as an

“object”(example: profitcenterX,revenue/costelement400000inperiod6).

Inaddition,youcancomparedifferentsetsofdata(suchasplan/actual,different

planversionsorfiscalyears,andsoon)toexaminethedifferences.

DrilldownreportingletsyouusethesamegraphicaluserinterfaceastheReport

Painterfordefiningthebasicstructureof yourreports. Youcanthenapplythis

structure, or"form", toanynumberofdrilldownreports.

Drilldownreporting providesyou withanumber of user-friendlyfunctionsfor

navigatingthroughyourreports,forexample,youcanswitchbetweendifferent

listtypes(drilldownlist/detaillist),limityouranalysistoasinglecharacteristic

value, or summarizethedata for all valuesof a characteristic. It also provides

additionalfunctionsforprocessingthereportlistinteractively(displayconditions,

exceptionrules,sortingfunctions,"topn"lists,andmore). Youcanalsodisplay

graphics, send report pages using SAPmail, and download reports to the SAP

XXL List Viewer andMicrosoft WordforWindows.

301

第 312 页 / 共 355 页

Unit7: InformationSystem AC610

302

第 313 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Exercise 15: Reporting with Drilldown

289

Reporting

Exercise Duration: 20 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• define basic reports

• define form reports

Business Example

Thoseresponsiblefortheprofitcenteroftenwantinformationoncertainpostings

to be provided by telephone. You define a basic report which allows you to

navigate via the required characteristics. At period-end closing reporting, the

managers request a printed plan/actual/comparison. You define a form report

in order to control the output format.

Task 1:

You define a basic report.

1. DefinethebasicreportAC610##BasicReportGroup##whichallowsyouto

navigate with the following characteristics:

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Company Code No entry

Accountnumber No entry

Origin object No entry

Costsandrevenuesshouldonlybedisplayedinprofitcenterlocalcurrency.

Itshouldbepossibletoenterallvariablesonexecutionofthereport. Forthe

graphicaloutput,thescreenshouldbedividedintoaninformationwindow,a

navigation windowanda drilldown window.

SavereportAC610##. DonotenterahierarchyforthecharacteristicsProfit

Center and Account Number.

Continued on next page

303

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry
Company Code	No entry
Accountnumber	No entry
Origin object	No entry

第 314 页 / 共 355 页

Unit7: InformationSystem AC610

2. ExecutereportAC610##withthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

3. Whichcharacteristicsaredisplayedintheinformationoutputarea?

4. Break down the report by account number. Has an amount been posted

to account 800000?

5. Whichoriginobjectscanyouidentifyforaccount800000?

Task 2:

The profit center managers often also want to know the source document for

certain postings.

1. ChangethebasicreportAC610##. AddTransactionKE5Z“ProfitCenter:

Actual LineItems”tothereport/reportinterface.

Save the document.

2. ExecutereportAC610##withthefollowingparameters:

Continued on next page

304

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 315 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Break down the report by account number.

3. Display the line items for account 430000. Go to the original document

of any line item.

Task 3:

Create a form report for plan/actual/comparisons. Management requires two

management-orientatedcostamountstolaydowntheperformance-relatedbonus

payments for the profit center managers.

1. Definetheformonwhichthereportisbased. Firstthesystemdisplaysthe

following overview:

Lead column Actual PLAN VARABS

Sales Account Account ACTUAL -

800000 800000 PLAN

COGS Account Account Actual-Plan

893015 893015

Contributionmargin Sales+COGS Sales+COGS Actual-Plan

I

Personnel SET SET Actual-Plan

3060000.INT 3060000.INT

Contributionmargin Contribution Contribution ACTUAL -

II margin I + margin I + PLAN

Personnel Personnel

CreateformAC610FORM##FormGroup##asamatrix.

Continued on next page

305

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Lead column	Actual	PLAN	VARABS
Sales	Account 800000	Account 800000	ACTUAL - PLAN
COGS	Account 893015	Account 893015	Actual-Plan
Contributionmargin I	Sales+COGS	Sales+COGS	Actual-Plan
Personnel	SET 3060000.INT	SET 3060000.INT	Actual-Plan
Contributionmargin II	Contribution margin I + Personnel	Contribution margin I + Personnel	ACTUAL - PLAN

第 316 页 / 共 355 页

Unit7: InformationSystem AC610

2. Definethegeneralselectionsoftheformbeforetheactuallayout:

Field Name Values

From Period LocalvariableFROMPER

To Period LocalvariableTOPER

Fiscal Year LocalvariableYEAR

Controlling Area 1000

Confirm the general selections.

3. Gotothevariabledefinitionandnamethevariablesasfollows:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currencyrestrictedto thecharacteristicplan/actualindicator 1(plan

values) and version 0.

DefinetheVARABScolumnastheformulaACTUAL–PLAN.

Delete column 4.

Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

Save the form.

Continued on next page

306

Field Name	Values
From Period	LocalvariableFROMPER
To Period	LocalvariableTOPER
Fiscal Year	LocalvariableYEAR
Controlling Area	1000

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 317 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

4. Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

5. DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

6. DefinetheVARABScolumnastheformulaACTUAL–PLAN.

7. Delete column 4.

8. Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

9. Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

10. DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

11. DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

12. DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should becontribution margin II.

13. Save the form.

Task 4:

1. Create the report AC610FORM## Coverage Group ## with form

AC610FORM##.

2. Define ledger and profit center as the navigation characteristics. Do not

make any further entries.

3. Fillthevariableswiththedataofthecurrentperiodofthecurrentfiscalyear.

Makesurethatallthevariablescanbeenteredatexecution. Fortheoutput

choosethegraphicaloutputwiththeoutputareasinformation,navigation,

drilldown and detail.

4. Save the report.

5. ExecutereportAC610FORM##forthecurrentperiodofthecurrentfiscal

year.

Continued on next page

307

第 318 页 / 共 355 页

Unit7: InformationSystem AC610

6. Wheredoyouseethelayoutdefinitionfromtheform?

308

第 319 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Solution 15: Reporting with Drilldown

Reporting

Task 1:

You define a basic report.

1. DefinethebasicreportAC610##BasicReportGroup##whichallowsyouto

navigate with the following characteristics:

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Company Code No entry

Accountnumber No entry

Origin object No entry

Costsandrevenuesshouldonlybedisplayedinprofitcenterlocalcurrency.

Itshouldbepossibletoenterallvariablesonexecutionofthereport. Forthe

graphicaloutput,thescreenshouldbedividedintoaninformationwindow,a

navigation windowanda drilldown window.

SavereportAC610##. DonotenterahierarchyforthecharacteristicsProfit

Center and Account Number.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Report

Enter AC610## Basic Report Group 01

Click Basic Report as the report type.

Choose the Create pushbutton.

Field Name Values

ControllingArea 1000

Profit Center CanbeselectedwithlocalvariablePRCTR

Ledger No entry

Continued on next page

309

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry
Company Code	No entry
Accountnumber	No entry
Origin object	No entry

Field Name	Values
ControllingArea	1000
Profit Center	CanbeselectedwithlocalvariablePRCTR
Ledger	No entry

第 320 页 / 共 355 页

Unit7: InformationSystem AC610

Field Name Values

CompanyCode No entry

Accountnumber No entry

Origin object No entry

Enterthevalue1000forthecharacteristicControllingArea.

ClicktheVariableon/offindicatorforthecharacteristicProfitCenter.

ThesystemdisplaystheVariableselectionwindow.

EnterPRCTR asthelocal variableandconfirm. VariablePRCTRis

thus only known in report AC610##.

Select the characteristics Company Code, Account Number, and

OriginObject in thelist ofavailablecharacteristics. Click theAdd

characteristic icon.

Costs and revenues should only be displayed in profit center local

currency.

Click the Key figures tab page.

SelectthekeyfigureCosts/revsin PCLCinthelistofavailablekey

figures.

Click the Add key figure icon.

Itshouldbepossibletoenterallvariablesonexecutionofthereport.

ClicktheVariablestabpage. MakesurethattheEntryatExecution

indicator is set for all variables.

Alternatively, you can specify default values at execution for every

variable.

For the graphical output, the screen should be divided into an

informationwindow,anavigationwindowandadrilldownwindow.

Click the Output Type tab page.

Click Graphical report-output.

Choosethecombination Infocontrol, navigation control, drilldown

control under output areas.

SavereportAC610##. Donotenterahierarchyforthecharacteristics

Profit Center and Account Number.

Click Save.

Continued on next page

310

Field Name	Values
CompanyCode	No entry
Accountnumber	No entry
Origin object	No entry

第 321 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Confirmthehierarchyselection. Makesurethatnohierarchyisentered

forthecharacteristicsProfitCenterandAccountNumber.

2. ExecutereportAC610##withthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Select report AC610##.

Run the report.

Enter the following parameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Run the report.

3. Whichcharacteristicsaredisplayedintheinformationoutputarea?

Answer: The characteristic values for controlling area 1000 and profit

center 91## are fixed characteristic values. This is the reason why they

aredisplayedintheinformationoutputarea. Nonavigationispossiblevia

these characteristics.

4. Break down the report by account number. Has an amount been posted

to account 800000?

Answer: Double-click on the characteristic Account Number in the

navigation output area.

Account 800000 has been posted to.

Continued on next page

311

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 322 页 / 共 355 页

Unit7: InformationSystem AC610

5. Whichoriginobjectscanyouidentifyforaccount800000?

Answer: Moveaccount800000usingdragand drop tothe characteristic

OriginObjectinthenavigationoutputarea. Profitcenter91##waspostedin

account800000withtheoriginobjectsProfitCenter,BillingDocumentand

Accounting Profitability Segment.

Task 2:

The profit center managers often also want to know the source document for

certain postings.

1. ChangethebasicreportAC610##. AddTransactionKE5Z“ProfitCenter:

Actual LineItems”tothereport/reportinterface.

Save the document.

a) PCA: Information System → Tools → Drilldown Reporting →

Change Report

Double-click report AC610##.

Select the Options tab page.

Click theReport assignmentpushbutton.

ThesystemdisplaystheAssignReportswindow.

Click the Insert row icon. The system displays the Add Drilldown

Report window.

Click theOtherreport type pushbutton.

Select TR Transaction.

Entertransaction codeKE5Z andconfirm.

Save the report assignment.

Save report AC610##.

2. ExecutereportAC610##withthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Continued on next page

312

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

第 323 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Break down the report by account number.

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Select report AC610##.

Runthereport. Enterthefollowingparameters:

Field Name Values

Profit Center 91##

Period 1 – 12

Fiscal Year Current fiscal year

Plan/ActualIndicator 0

Version 0

Breakdownthereport byaccount number.

Double-clickonthecharacteristicAccountNumberinthenavigation

output area.

3. Display the line items for account 430000. Go to the original document

of any line item.

Answer: Clicktheactualcostswiththeaccount430000.

ClicktheCallupreporticon. Theassigneditemreportisstartedimmediately.

Double-click on the line items.

ThesystemdisplaystheoriginalG/Laccountdocument.

Task 3:

Create a form report for plan/actual/comparisons. Management requires two

management-orientatedcostamountstolaydowntheperformance-relatedbonus

payments for the profit center managers.

1. Definetheformonwhichthereportisbased. Firstthesystemdisplaysthe

following overview:

Lead column Actual PLAN VARABS

Sales Account Account ACTUAL -

800000 800000 PLAN

COGS Account Account Actual-Plan

893015 893015

Continued on next page

313

Field Name	Values
Profit Center	91##
Period	1 – 12
Fiscal Year	Current fiscal year
Plan/ActualIndicator	0
Version	0

Lead column	Actual	PLAN	VARABS
Sales	Account 800000	Account 800000	ACTUAL - PLAN
COGS	Account 893015	Account 893015	Actual-Plan

第 324 页 / 共 355 页

Unit7: InformationSystem AC610

Leadcolumn Actual PLAN VARABS

Contribution margin Sales+COGS Sales+COGS Actual-Plan

I

Personnel SET SET Actual-Plan

3060000.INT 3060000.INT

Contribution margin Contribution Contribution ACTUAL -

II margin I + margin I + PLAN

Personnel Personnel

CreateformAC610FORM##FormGroup##asamatrix.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Form

EnterAC610FORM##DescriptionFormGroup##.

Choose "Two axes (matrix)".

Click the Create pushbutton.

ThesystemdisplaystheReportPainterinterfacefordefiningforms.

2. Definethegeneralselectionsoftheformbeforetheactuallayout:

Field Name Values

From Period LocalvariableFROMPER

To Period LocalvariableTOPER

Fiscal Year LocalvariableYEAR

Controlling Area 1000

Continued on next page

314

Leadcolumn	Actual	PLAN	VARABS
Contribution margin I	Sales+COGS	Sales+COGS	Actual-Plan
Personnel	SET 3060000.INT	SET 3060000.INT	Actual-Plan
Contribution margin II	Contribution margin I + Personnel	Contribution margin I + Personnel	ACTUAL - PLAN

Field Name	Values
From Period	LocalvariableFROMPER
To Period	LocalvariableTOPER
Fiscal Year	LocalvariableYEAR
Controlling Area	1000

第 325 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

Confirm the general selections.

a) ChooseEdit→Gen. dataselection→Gen. dataselection

SelectthecharacteristicsFiscalYear,Period,andCOAreainthelistof

available characteristics.

Click the Move Selected to Left icon.

ClicktheVariableon/offindicatorfortheFiscalYearcharacteristic.

EnterYEARintheLocalvariablefieldandconfirm.

ClicktheVariableon/offindicatorforcharacteristicPeriod.

EnterFROMPERintheLocalVariablefieldandconfirm.

ClicktheVariableon/offindicatorforcharacteristicPeriodintheTo

column.

EnterTOPERintheLocalVariablefieldandconfirm.

Enterthevalue1000forthecharacteristicControllingArea.

Confirm the general selections.

Click the Confirm pushbutton.

3. Gotothevariabledefinitionandnamethevariablesasfollows:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

DefinetheVARABScolumnastheformulaACTUAL–PLAN.

Delete column 4.

Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

Continued on next page

315

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 326 页 / 共 355 页

Unit7: InformationSystem AC610

DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

Save the form.

a) Choose Extras → Variables → Variables Definition and enter the

following descriptions for thevariables:

Name Description

FROMPER From Period

YEAR Fiscal Year

TOPER To Period

Confirm.

4. Define the ACTUAL column as the key figure costs/revenues in profit

centerlocalcurrencyrestrictedtothecharacteristicplan/actualindicator0

(actual values).

a) Double-click column 1.

Choose Characteristics.

Ifnotalreadyselected,selectthecharacteristicplan/actual/indicatorin

the list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue0foractualvaluesfortheselectedplan/actualindicator.

ClicktheChangeshort,middleandlongtextsicon.

Enter ACTUAL as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttontocompletethecolumndefinition.

Continued on next page

316

Name	Description
FROMPER	From Period
YEAR	Fiscal Year
TOPER	To Period

第 327 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

5. DefinethePLANcolumnasthekeyfigurecosts/revenuesinprofitcenter

local currency restrictedto thecharacteristicplan/actual indicator 1(plan

values) and version 0.

a) Double-click column 2.

Choose Characteristics.

Ifnotalreadyselected,selectthecharacteristicplan/actual/indicatorin

the list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue1forplanvaluesfortheselectedplan/actualindicator.

Selectthecharacteristicversioninthelistofavailablecharacteristics.

Click the Move Selected to Left icon.

Enterthevalue0fortheselectedcharacteristicVersion.

ClicktheChangeshort,middleandlongtextsicon.

Enter PLAN as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttontocompletethecolumndefinition.

6. DefinetheVARABScolumnastheformulaACTUAL–PLAN.

a) Double-click on column 3.

Select Formula.

ClicktheX001pushbuttontoselecttheactualcolumn.

Click thepushbuttonfor the minus sign.

ClicktheX002pushbuttontoselecttheplancolumn.

Confirm the formula.

EnterVARABSastheshorttextforthecolumn.

Click the Copy short text pushbutton.

Confirm.

7. Delete column 4.

a) Position your cursor on column 4.

Click the Delete Element icon.

Continued on next page

317

第 328 页 / 共 355 页

Unit7: InformationSystem AC610

8. Definethefirstrowasthecharacteristiclinewithaccountnumber800000

domesticrevenues. Therowtext shouldbesales.

a) Double-click row 1.

Choose Keyfigure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue800000fortheselectedcharacteristicAccountNumber.

ClicktheChangeshort,middleandlongtextsicon.

Enter Sales as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

9. Definethesecondrowasthecharacteristicrowwithaccountnumber893015

Costofgoodssold. TherowtextshouldbeCOGS.

a) Double-click row 2.

Choose Keyfigure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Enterthevalue893015fortheselectedcharacteristicAccountNumber.

ClicktheChangeshort,middleandlongtextsicon.

Enter COGS astheshort text for the row.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

Continued on next page

318

第 329 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

10. DefinethethirdrowastheformulaSales+COGS.Thisisnecessarybecause

salesarepostedwithanegativesigninProfitCenterAccounting. Therow

text should be contribution margin I.

a) Double-click row 3.

Choose Formula.

Click the Y001 pushbuttonto select row1.

Click the pushbutton for the plus sign.

Click the Y002 pushbuttonto select row2.

Confirm the formula.

EnterContributionmarginIastheshorttextfortherow.

Click the Copy short text pushbutton.

Confirm.

11. DefinethefourthrowasthecharacteristicrowwiththeSET3060000.INT

personnelexpense. Therowtextshouldbepersonnel.

a) Double-click row 4.

Choose Key figure with characteristics.

SelectCosts/revsinprofitcenterlocalcurr. intheKeyFigurefield.

Ifnotalreadyselected,selectthecharacteristicAccountNumberinthe

list of available characteristics.

Click the Move Selected to Left icon.

Click the SET on/off indicator.

Enter the value 3060000. INT Personnel expense as the SET and

confirm.

ClicktheChangeshort,middleandlongtextsicon.

Enter Personnel as the short text.

ClicktheCopyshorttextpushbuttonandconfirm.

ClicktheConfirmpushbuttoninordertocompletetherowdefinition.

Continued on next page

319

第 330 页 / 共 355 页

Unit7: InformationSystem AC610

12. DefinethefifthrowastheformulacontributionmarginI+personnel. The

row text should be contribution margin II.

a) Double-click the fifth row.

Select Formula.

ClicktheY003pushbuttontoselectcontributionmarginI.

Click the pushbutton for the plus sign.

ClickontheY004pushbuttontoselectPersonal.

Confirm the formula.

EnterContributionmarginIIastheshorttextfortherow.

Click the Copy short text pushbutton.

Confirm.

13. Save the form.

a) Click Save.

Task 4:

1. Create the report AC610FORM## Coverage Group ## with form

AC610FORM##.

a) PCA: Information System → Tools → Drilldown Reporting →

Create Report

EnterAC610FORM## CoverageGroup ##.

ClickReportwithformandenterAC610FORM##.

Choose the Create pushbutton.

2. Define ledger and profit center as the navigation characteristics. Do not

make any further entries.

a) ThecharacteristicsLedgerandProfitCenterarepreassigned.

Continued on next page

320

第 331 页 / 共 355 页

AC610 Lesson: Reporting with Drilldown Reporting

3. Fillthevariableswiththedataofthecurrentperiodofthecurrentfiscalyear.

Makesurethatallthevariablescanbeenteredatexecution. Fortheoutput

choosethegraphicaloutputwiththeoutputareasinformation,navigation,

drilldown and detail.

a) Click the Variables tab page.

Enter the following data:

Name Description

From Period Current Period

To Period Current Period

Fiscal Year Current fiscal year

MakesurethattheEntryatExecutionindicatorisset.

Click the Output Type tab page.

Click Graphical report-output.

Choose the combinationInfo control, navigation control, drilldown

control, detail controlunder Output areas.

4. Save the report.

a) DonotenterahierarchyforthecharacteristicsProfitCenter.

5. ExecutereportAC610FORM##forthecurrentperiodofthecurrentfiscal

year.

a) PCA: Information System → Tools → Drilldown Reporting →

Execute Report

Double-click report AC610FORM01.

Enter the following data:

Name Description

From Period Current Period

To Period Current Period

Fiscal Year Current fiscal year

Run the report.

6. Wheredoyouseethelayoutdefinitionfromtheform?

Answer: ThedetailoutputareashowstheReportPainterformwiththetotal

of thevalues displayedin thedrilldown area.

321

Name	Description
From Period	Current Period
To Period	Current Period
Fiscal Year	Current fiscal year

Name	Description
From Period	Current Period
To Period	Current Period
Fiscal Year	Current fiscal year

第 332 页 / 共 355 页

Unit7: InformationSystem AC610

Lesson Summary

You should now be able to:

• defineyourownbasicandform-baseddrilldownreports

322

第 333 页 / 共 355 页

AC610 Unit Summary

Unit Summary

You should now be able to:

• usethestandardreportsanddefineyourownbasicandform-basedreports

• use a drilldown report

• defineyourownbasicandform-baseddrilldownreports

323

第 334 页 / 共 355 页

UnitSummary AC610

324

第 335 页 / 共 355 页

AC610 Test Your Knowledge

Test Your Knowledge

311

1. Profitability Analysisusesdrilldown reports as a reporting tool. For this

reason,profitcenterdataisanalyzedusingdrilldownreportsonly.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Profit Center Accounting features both basic drilldown reports and

form-based drilldown reports.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

325

第 336 页 / 共 355 页

TestYourKnowledge AC610

Answers

312

1. Profitability Analysis uses drilldown reports as a reporting tool. For this

reason,profitcenterdataisanalyzedusingdrilldownreportsonly.

Answer: False

In Profit Center Accounting, you can use Report Painter reports, Report

Writerreports, ALVreports, anddrilldownreports.

2. Profit Center Accounting features both basic drilldown reports and

form-based drilldown reports.

Answer: True

326

第 337 页 / 共 355 页

AC610 Course Summary

Course Summary

You should now be able to:

• DescribethebusinesspurposesofProfitabilityAnalysisandProfitCenter

Accounting in the SAP system

• identify information which can be obtained in Profitability Analysisand

Profit Center Accounting

• ClarifytheaspectandscopeofprofitabilitymanagementintheSAPsystem

Related Information

Recommended Follow-up Activities

• GothroughtheexercisesusingIDESdataoryourowndata

• Read on-line documentation

• Read IMG documentation

• Read release notes

327

第 338 页 / 共 355 页

CourseSummary AC610

328

第 339 页 / 共 355 页

Appendix 1

Figure 99: MM Goods movement

Thegraphicillustrateshowthesystemdeterminestheprofit center for an MM

goods movement. The data in the MM document is posted in Profit Center

Accountingtotheprofitcenterdeterminedbythesystem.

Asyoucanseefromthegraphic, theprofitcenter foranMMgoodsmovement

canbedeterminedeitherdynamicallyorindirectlyviatheprecedingdocument.

Figure 100: Invoice receipt

329

第 340 页 / 共 355 页

Appendix 1: AC610

Thegraphicillustrateshowthesystem determinestheprofit centerfor an MM

goodsreceiptposting. ThedataintheMMdocumentispostedinProfitCenter

Accountingtotheprofitcenterdeterminedbythesystem.

When a goods receipt posting is made, the profit center is always determined

indirectly via the preceding document.

Figure 101: Posting in FI and in FI-AA

The graphic illustrates how the system determines the profit center for FI and

FI-AA postings. In Profit Center Accounting, the data in the FI or FI-AA

documentispostedtotheprofitcenterdeterminedbythesystem.

The profit center is always determined dynamically from the FI or FI-AA

document.

Figure 102: SD billing document

Thegraphicillustrateshowthesystemdeterminestheprofitcenterforabilling

document. InProfitCenterAccounting,thedatainthebillingdocumentisposted

to the profit center determined by the system.

For a billing document, the profit center is - with one exception - always

determinedindirectly viathepreceding document.

330

第 341 页 / 共 355 页

AC610 Appendix 1:

Theexceptiontothisruleisabillingdocumentwithvaluatedprojectstock. With

thistypeofbillingdocument,theprofitcenterisdetermineddynamicallyfromthe

WBSelementcontainedintheactualbillingdocument.

With cross-company transactions, the sales order item always contains the

supplying profit center.

Thisprofitcenterisusedbothfortheinternalsettlementandthegoodsissue(see

normal case in the graphic).

Theprofitcentermakingthesalemustbedeterminedusingasubstitutionwhen

thecustomerbilling document iscreated (see cross-company transaction in

the graphic).

ALE Scenarios in Profit Center Accounting

• Centralized Profit Center Accounting

• Decentralized Profit Center Accounting

Masterdataismaintainedcentrallyandthendistributed

AprofitcentercanbepostedtoalldecentralizedsystemswherePCA

is activated

SummarizedrecordsaretransferredperiodicallytotheCentralSystem

ApplicationLinkEnabling(ALE)isexplainedindetailinthedocumentationALE

IntroductionandOverview. Thereyouwillalsofindachapterdealingspecifically

withProfitCenter Accounting. Tolearnhowto set updistributionusing ALE,

see Customizing.

Application Link Enabling scenarios have been implemented in Profit Center

AccountingtoallowyoutodecentralizeyourProfitCenterAccounting.

Figure 103: Centralized Profit Center Accounting

331

第 342 页 / 共 355 页

Appendix 1: AC610

Thelineitemsarestoredlocallyinthehomesystemoftherelevantprofitcenter.

Ifapostingismadetoaprofitcenter,whichisnotinthehomesystemoftheprofit

center,thelineitemsarepostedwithreferencetotheoriginatingdocument.

You can analyzethelineitems andtotals recordsof aprofit center initshome

system. Ifyouwanttoexecutereportsforallprofitcenters,youhavetotransfer

the line items and total records from the different local systems to the central

system after period-end closing. The data is stored there in a “rollup ledger”,

ledger 8C. This ledger is generated automatically in the logical system of the

controllingareaifyouselectedtheALEdistributionmethod“2”inCustomizing.

Thisensuresthatnodatafromthelocalsystemsisimportedmorethanonce.

If you transfer planning data from other applications, do this in the system

wherethedatawasgeneratedoriginally. Thedataisthensenttoallthesystems

concerned in the same way as actual data,

Profitcenterscanonlybeplannedmanuallyinyourhomesystem.

Figure 104: Profit Center Reporting in BW

332

第 343 页 / 共 355 页

AC610 Appendix 1:

Figure 105: Business Information WarehouseArchitecture

333

第 344 页 / 共 355 页

Appendix 1: AC610

334

第 345 页 / 共 355 页

Appendix 2

Data Structures for Report Painter and

Report Writer Reports

Figure 106: List-oriented Reports: Report Painter

TheInformationSystemoffersyoutheoptionofevaluatingposteddataaccording

to various criteria. The SAP System contains a range of standard reports. In

additiontostandardreportsyoucanalsousetools,suchasdrilldownreporting,to

define your own reports.

In the information system, you can evaluate posted transaction data online

immediatelyafter processingintheSAPsystemandfollowitsoriginsdownto

the document level.

Formoreextensivedataselectionyoucanexecuteallreportsavailableonlinein

thebackgroundatpredefinedtimesorschedulethemusingtheScheduleManager.

335

第 346 页 / 共 355 页

Appendix2: DataStructuresforReportPainterandReportWriterReports AC610

Figure 107: The Report Painter Concept:

TheReportPainterisbasedonagraphicaluserinterface. Thisinterfaceconsists

of rowsandcolumnsand displaysthereportasit will finallyappearwhenyou

execute it (WYSIWYG).

The library defines which database fields (characteristics, key figures, and

predefinedcolumns)canbeusedinReportPainterandReportWriterreports. All

ReportPainterandReportWriterreportsareassignedtoalibrary. Eachlibraryin

turnisassignedtoonedatabasetableordatastructure.

You define the report using the characteristics, key figures, and predefined

columns that you selected in the library.

Figure 108: Reporting table GLPCT

Threedatabasetables,GLPCT,GLPCAandGLPCP,arehiddenbehindreporting

tableGLPCT.ThisisfixedinthetaxtablesoftheReportWriter.

TableGLPCT containsthetotalsrecordsofProfitCenterAccounting, whereas

GLPCAcomprisestheactuallineitemsandGLPCPtheplanlineitems.

336