AC605_EN_Col92_FV_Part_A4 (第11页)

第 375 页 / 共 483 页

AC605 Lesson: Creating Reports

Solution 19: Form Report

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.

Double-clickthefirstelementandchooseCharacteristics. ChoosePeriod

and then enter the values, 001 to 003.

Enter Quarter 1 in the text fields.

Definethecolumnsforthequarters,2,3,and4,inasimilarway,changing

theperiodvaluestocorrespondwiththequarters.

Use a formula to create the Total column.

In“Generaldataselection”,selectthecharacteristicsPlan/actualindicator,

Recordtype,Fiscalyear,andCompanycode. Specifythevaluesorvariables

for these characteristics.

Continued on next page

357

	Quarter1	Quarter2	Quarter3	Quarter4	Total

第 376 页 / 共 483 页

Unit6: InformationSystem AC605

FieldNameorDataType Values

Company Code 1000

Record Type F

Plan/ActualIndicator 0

Fiscal Year Variable √

Dialogwindow: LocalVariableYear

Save the form definition.

a) Incosting-basedCO-PA,createaoneaxisformwithoutkeyfiguresto

beusedforaspecificfiscalyear. Theformshouldhavethecompany

code,1000,actualdata,therecordtype,F,andthefollowinglayout:

Quarter Quarter2 Quarter3 Quarter4 Total

ProfitabilityAnalysis→ Environment → Set OperatingConcern.

Choosecosting-basedCO-PAfortheIDEAoperatingconcern.

ProfitabilityAnalysis→InformationSystem→CurrentSettings→

DefineFormsforProfitabilityAnalysisorinCO-PACustomizing→

Information System → Report Components → Define Forms →

Define FormsforProfitabilityReports.

Name the form, FR1##.

Description: Sales Quarter Report

SelecttheOneaxiswithoutkeyfigureoption. SelectCreatetoconstruct

theform. Select OperatingConcernCurrency.

Double-click the first element and chooseCharacteristics. Choose

Period and enter the values, 001 to 003.

ClicktheChangeShort,Middle,LongTextsiconandenterQuarter1

in the text fields. Select Confirm.

Define the columns for the quarters, 2, 3, and 4, in a similar way,

changingtheperiodvaluestocorrespondwiththequarters.

Use aformulato create the Total column.

Double-click the empty spaces adjacent to the fourth column.

ChooseFormulafortheTotalcolumn. Definetheformulaasthe

sum of the first four columns. Enter “Total” as the text for the

columns.

Continued on next page

358

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

	Quarter 1	Quarter2	Quarter3	Quarter4	Total

第 377 页 / 共 483 页

AC605 Lesson: Creating Reports

In “General data selection”, select the characteristics Plan/actual

indicator, Recordtype, Fiscal year, and Companycode. Specifythe

valuesorvariablesforthesecharacteristics.

Edit→Gen. DataSelection→Gen. DataSelection.

SelectCharacteristicsinthetableontherightandselectthesingle

arrow that points to the left to copy characteristics to General

Data Selection.

FieldNameorDataType Values

Company Code 1000

Record Type F

Plan/ActualIndicator 0

Fiscal Year Variable √Dialog window: Local

Variable Year

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.

Continued on next page

359

FieldNameorDataType	Values
Company Code	1000
Record Type	F
Plan/ActualIndicator	0
Fiscal Year	Variable √Dialog window: Local Variable Year

第 378 页 / 共 483 页

Unit6: InformationSystem AC605

Savetheformreportdefinitionwithoutselectinganyhierarchies.

a) Next,usetheformyouhavejustcreatedtodefineanewreport. You

candothisdirectlyfromtheformbyselectingCreateReport.

ProfitabilityAnalysis→Information System →DefineReport→

Create Profitability Report.

SelectReportwithformandenterthenameofyourformintheForm

field andthe Reportfield. SelectCreate.

Note: Thereportandformnamesdonothavetobethesame.

Selectthecharacteristics,CustomerandProduct,forthereport. Select

allthekeyfiguresfromtheSalesControlkeyfigurescheme.

Tab→characteristics: Selecttheappropriatecharacteristicsfromthe

tableon therightandcopythemto theleft.

Tab→KeyFigures: SelecttheSalesControlkeyfigurescheme.

Click“ValueFieldson/off”onetimetodeactivatevaluefields. Use

thedoublearrowthatpointstothelefttocopyallkeyfigures.

Inaddition,indicatethecurrentfiscalyearasthedefaultyearforthe

report. Ensurethatboththecompanycodeandthecurrentfiscalyear

appear in the header of the report list.

Tab →Variables: Current fiscal year

SelectClassicDrill-downastheoutputtype-andusesummarization

data.

Tab → Output Type

Tab → Options

Savetheformreportdefinitionwithoutselectinganyhierarchies.

3. Createaheadertoenterthecompanycodeandthefiscalyear.

Continued on next page

360

第 379 页 / 共 483 页

AC605 Lesson: Creating Reports

Savetheheaderdefinitionandthereportdefinition.

a) Createaheadertoenterthecompanycodeandthefiscalyear.

Report→Change→Change: OutputTypetab

Note: Toeditthereportheaderlayout, makesureyouarein

thechangemodeandnotthecreatemode.

ChooseMaintain(pencilicon)toaddanewheader.→Create

Clickthe“Characteristics”icon. Fromthevariablesdisplayedin

thewindow,selectCompanyCode. Changethetexttypesettings

toDescriptionand changethewidthto20. ChooseEnter. Place

yourcursorintheemptyspacenexttothe‘CompanyCode’text

thatappearsintheheader. ClicktheCharacteristicsicon. Select

CompanyCodefromthelistofvariablesdisplayedinthewindow.

Changethetexttypesettingsto“Value”andchangethewidthto

4. Next, gotothenext lineandrepeatthesestepsforthe“Fiscal

Year” field.

Savetheheaderdefinitionandthereportdefinition.

4. Executethereportforthecurrentfiscalyear. Movetoallthecolumnsinthe

reportusingthePageleft/Pagerightarrows. Noticehowthecolumnsinthe

formappearbelowthekeyfigurethatyouselectedinthereportdefinition.

Next,movefromthisoverviewtothedetailviewforaprofitabilitysegment.

Noticethattheresultisacontributionmarginschemeforeachquarter,which

presentsaneasywaytoviewthedataforasinglemarketsegment.

a) Executethereportforthecurrentfiscalyear. Movetoallthecolumns

in the report using the Page left/Page right arrows. Notice how the

columns in the form appear below the key figure that you selected

inthereportdefinition. Next, movefromthisoverviewtothedetail

viewforaprofitabilitysegment. Noticethattheresultisacontribution

marginschemeforeachquarter,whichpresentsaneasywaytoview

the data for a single market segment.

ProfitabilityAnalysis→InformationSystem→ExecuteReport.

Specify thereport name and continue.

Use the navigation functionsto movefromside to side to view all

the key figure columns.

Clickthe“Detail”hotspotonceandclickthehighlightedareathat

appearsalongsideanyoftherowsofthereport.

Toreturntothedrill-downlist,clickthe“Overview”hotspotonce

andclickanyofthehighlightedcharacteristics.

Continued on next page

361

第 380 页 / 共 483 页

Unit6: InformationSystem AC605

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 forActual valuesand 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

MaterialOH

Contribution

margin II

1. Nameyour report, FR2XX, and enter adescription such as: Plan/actual

form

FortheVariancecolumn,chooseFormulainsteadofCharacteristic. Define

the formulaastheActual column minusthePlan column. Enter the text,

Variance.

Continued on next page

362

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

第 381 页 / 共 483 页

AC605 Lesson: Creating Reports

SelectFormulaasthescreenelementfortheVariance%column. Definethe

formulaasVariancex100/Plancolumn. Enterthetext: Variance

a) Nameyourreport,FR2XX,andenteradescriptionsuchas: Plan/actual

form.

ProfitabilityAnalysis→Environment→SetOperatingConcern.

Choosecosting-basedCO-PAfortheIDEAoperatingconcern.

ProfitabilityAnalysis→InformationSystem→CurrentSettings→

DefinetheFormsforProfitabilityReports.

Selectthetwoaxisoptionand “Continue”.

Select Operating concern currency.

Double-click the first column and choose Characteristics.

Choose “Characteristics”. In the next dialog window, select

the characteristic “Plan/Actual Indicator”. Enter 0 as the

characteristicvalueandusethegiventext.

Double-clickthecolumn,2,andchoose“Characteristics”. Inthe

nextdialogwindow,select“Plan/ActualIndicator”and“Version”.

Then enter “1” and “5##” as values respectively. Enter “Plan”

for the texts.

FortheVariancecolumn,chooseFormulainsteadofCharacteristic.

DefinetheformulaastheActualcolumnminusthePlancolumn. Enter

the text, Variance.

Double-clickthenextcolumn,whichmayberepresentedbyadot,

andselect“Formula”. UsetheFormulaEditorasdirected.

Select Formula as the screen element for the Variance % column.

DefinetheformulaasVariancex100/Plancolumn. Enterthetext:

Variance

Continued on next page

363

第 382 页 / 共 483 页

Unit6: InformationSystem AC605

2. Forthefirstrow,usethekeyfigureelement,IDESDETCM,byselecting

KeyFigureSchemewhendefiningtherow. Selecttheappropriatekeyfigure.

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

Proceedinthesamewayfortheremainingsixrows.

a) For the first row, use the key figure element, IDES DET CM, by

selecting Key Figure Scheme when defining the row. Select the

appropriatekeyfigure. Donotselectanycharacteristics,andadoptthe

textforthekeyfigure. Proceedinthesamewayfortheremainingsix

rows.

Double-click the first row and choose “Key Figure Scheme

Element”. Selecttherespectivekeyfigurescheme(IDESDETCM).

Selecttheappropriatevaluefields. Donotselectanycharacteristics

andacceptthedefaultvaluesbychoosing“Confirm”.

Define theother rows in a similar way.

3. Next, definethe general data for thereport:

FieldNameorDataType Values

Record Type F

Period/Year From Variable√Identifier: PF

Period Year To Variable√Identifier: PT

Company Code 1000

a) Next, definethegeneraldata for thereport:

FieldNameorDataType Values

Record Type F

Period/Year From Variable√Identifier: PF

Period Year To Variable√Identifier: PT

Company Code 1000

Choose Edit → Gen. Data Selection → Gen. Data Selection.

Selection Select Record Type, Period/Year, and Company Code.

Continue and specify values, and create local variables as

appropriate. Thismeansthevariablesforperiod/yearfromandto.

Continued on next page

364

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

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

第 383 页 / 共 483 页

AC605 Lesson: Creating Reports

4. Tomakeiteasytoreadthedrill-downlist,youhavedecidedtoshowonly

certainkeyfiguresinthereportcolumns. Selectbothplanandactualvalues

for Revenue and CM II.

a) Tomakeiteasytoreadthe-list,youhavedecidedtoshowonlycertain

keyfiguresinthereportcolumns. Selectbothplanandactualvalues

for Revenue and CM II.

Extras→DrilldownDisplay→SelectRows/Columns.

Select “Revenue” and “Contribution Margin” from the row

selection. SelectActualandPlanfromthecolumnsdisplayedby

placing the cursor on the column or row and choosing Select.

Noticehoweachselectionchangescolor. Select“Saveselections”.

Hint: Withformreports,thecreatorofthereportcandesign

the report layout with an unlimited number of key figures.

However,thiscanmakereadingthereportmoredifficultwhen

you access the drilldown list of the report. You can define

whichkeyfiguresinthedrilldownlistshouldbedisplayedfor

comparison. Theuser can displayall of thehighlightedkey

figures in the detailed list.

5. Toenhancetheappearanceof thereport, youdecideto highlight someof

the key rows.

Save the form definition.

a) Toenhancetheappearanceofthereport,youdecidetohighlightsome

of the key rows in the report.

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.

Continued on next page

365

第 384 页 / 共 483 页

Unit6: InformationSystem AC605

Savethereportandexecuteitforatimeintervalthatproducesresults. Then

switchbetweenthedrilldownandthedetaileddisplay.

a) Next,usetheformyouhavejustcreatedtodefineanewreport. Name

thereport, FR2XX,and enter anappropriatedescription. Select the

following drill-down characteristics:

SalesOrganization, Division, andCustomer.

Noticethatyoucannotselectanykeyfiguresbecauseyouhavealready

createdtheminyourformdefinition. Saveandexecutethereportfora

timeintervalthatproducesresultsandmovebetweentheDrill-down

and Detail screens.

SelectProfitabilityAnalysis→InformationSystem→DefineReport

→ Create Profitability Report.

Name: FR2XX;Description: Plan/ActualReports

SelecttheReportwiththeformoptionandentertheformname,

FR2XX,in the“Form”field. SelectCreate.

Note: Thereportandformnamesdonothavetobethesame.

Enteranyvaluesonthe“Variables”screen. Forexample,youcan

choosethecurrentfiscalyearasthePeriod/Year.

Choose any combination of characteristics from the

“Characteristics” screen. You can access this screen using a

navigationfunctionorchoosingGoto→Characteristics.

Savetheformreport definition. InthePerformancedialogbox,

chooseDisplay CurrentData. Youwanttousea summarization

levelanddonotwantanymessagestoappearif thereisnolevel

(Executereport). Donotspecifyanycharacteristichierarchies.

ProfitabilityAnalysis→InformationSystem→ExecuteReport.

Specify thereport nameand continue.

Toreturntothedrill-downlist,clickthe“Overview”hotspotonce

andclickanyofthehighlightedcharacteristics.

Click the “Detail” hotspot once and click the highlighted area that

appearsadjacenttoanyoftherowsofthereport.

Continued on next page

366

第 385 页 / 共 483 页

AC605 Lesson: Creating Reports

Task 3:

1. Whatisthedifferencebetweenlocalandglobalvariables?

a) Global variablesarevariablesthat havethesamemeaningacross

manyformsandreports. Ifvariablesareusedfrequently,it makes

sense to define them globally. Global variables have a more

sophisticatedsubstitutionlogicthanlocalvariables.

Local variables are variables that only have meaning within a

particularformorreport. Whenalocalvariableisusedinaform,it

hasthesamemeaningacrossallthereportsthatsharethatform.

2. CreateaglobalvariableforthePeriod/FiscalYearfield.

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

maintenanceof DefineVariables for Report.

a) SAPMenu→Accounting→Controlling→ProfitabilityAnalysis→

InformationSystem→CurrentSettings→DefineVariablesforReports

Select new entries and create a new variable for the variables type

“CharacteristicValue”andnameitAC605GR##.

Select “Entry” as replacement type.

SelectContinue. Maintainthevariableasfollows:

Asfieldname,assign PERIO (period/year)

Variable name &AC605GR00

Field name PERIO

Replacement Type Input

Default Value ____ (no entry)

Optional entry Required entry

Parameter/selectopt. Parameter

Short text PERFYEAR

Description Period/fiscal year

Text Period/fiscal year

Saveyourglobalvariablesandtestthevariablewithoneoftheareas

you have defined.

Continued on next page

367

第 386 页 / 共 483 页

Unit6: InformationSystem AC605

Task 4:

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

reports? Whichtypeisusedtocustomizetheappearanceofareport? Which

typeisusedtocustomizethemeaningofacolumninareport?

a) Namethefourtypesofvariables. Whichtypeisusedmostfrequently

inreports? Whichtypeisusedtocustomizetheappearanceofareport?

Whichtypeisusedtocustomizethemeaningofacolumninareport?

Characteristic value; Hierarchy and hierarchy node; Text; and

Formula. Characteristicvaluevariablesareusedmostfrequentlyin

reportandformdefinitions. Hierarchyandhierarchynodevariables

are similar to Characteristic values. Text variables are used to

customizetheappearanceofareport. Formulavariablesareusedto

customizethemeaningofacolumnorarowinareport.

368

第 387 页 / 共 483 页

AC605 Lesson: Creating Reports

Exercise 20: Line Item-Based Reports

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Createadrill-downreport basedonlineitems

Business Example

Yoursalesmanagerwantstoobtainadailysalesreportoncustomersalesfigures

andallowdrill-downtothebillingdocumentandbillingdate.

Task:

Hint: You can create reports based on line items. For this purpose,

both basic reports and the reports with forms are available. During

characteristicselection,youcanaccessbothcharacteristicsatthesegment

levelandthecharacteristicsintheoperatingconcern. Forexample,you

canaccessthereferencedocumentnumberortheordernumber.

1. Create a basic line item report, LR##, which displays all the reference

documentnumbersinthecurrentperiodforthecustomer,T-CO05A##. You

wanttoviewonlytherevenueandinvoicedquantity.

Youalsowanttoviewthebillingdate. ChooseActualDataforyourreport

and as the record type.

Characteristics:

FieldNameorDataType Values

Customer T-CO05A##

ReferenceDocumentNumber √

Billing Date √

Sort the characteristics so that the customer appears first, the reference

document second, and thebilling date third.

Execute:

FieldNameorDataType Values

From period Current

To period Current

Continued on next page

369

FieldNameorDataType	Values
Customer	T-CO05A##
ReferenceDocumentNumber	√
Billing Date	√

FieldNameorDataType	Values
From period	Current
To period	Current

第 388 页 / 共 483 页

Unit6: InformationSystem AC605

Plan/actual keyfigure 0

Version -

Record Type F

2. Howmany referencedocumentsaredisplayed?

3. Viewthetotalrevenueatthematerialgrouplevel. Howmuchdoesthetotal

revenue amount to?

370

Plan/actual keyfigure	0
Version	-
Record Type	F

第 389 页 / 共 483 页

AC605 Lesson: Creating Reports

Solution 20: Line Item-Based Reports

Task:

Hint: You can create reports based on line items. For this purpose,

both basic reports and the reports with forms are available. During

characteristicselection,youcanaccessbothcharacteristicsatthesegment

levelandthecharacteristicsintheoperatingconcern. Forexample,you

canaccessthereferencedocumentnumberortheordernumber.

1. Create a basic line item report, LR##, which displays all the reference

documentnumbersinthecurrentperiodforthecustomer,T-CO05A##. You

wanttoviewonlytherevenueandinvoicedquantity.

Youalsowanttoviewthebillingdate. ChooseActualDataforyourreport

and as the record type.

Characteristics:

FieldNameorDataType Values

Customer T-CO05A##

ReferenceDocumentNumber √

Billing Date √

Sort the characteristics so that the customer appears first, the reference

document second, and thebilling date third.

Execute:

FieldNameorDataType Values

From period Current

To period Current

Continued on next page

371

FieldNameorDataType	Values
Customer	T-CO05A##
ReferenceDocumentNumber	√
Billing Date	√

FieldNameorDataType	Values
From period	Current
To period	Current

第 390 页 / 共 483 页

Unit6: InformationSystem AC605

Plan/actual keyfigure 0

Version -

Record Type F

a) Createabasiclineitemreport,LR##,whichdisplaysallthereference

documentnumbersinthecurrentperiodforthecustomer,T-CO05A##.

Youalsowanttoviewthebillingdate. ChooseActualDataforyour

report and selectBilling astherecordtype.

ProfitabilityAnalysis→Information System →DefineReport→

Create Report Based on Line Items.

Choose Operating Concern Currency.

Characteristics:

FieldNameorDataType Values

Customer T-CO05A##

ReferenceDocumentNumber √

Billing Date √

Sortthecharacteristicssothatthecustomerappearsfirst,thereference

documentsecond, andthebillingdatethird.

Key Figures:

FieldNameorDataType Values

Sales Revenue √

InvoicedquantityinSKUn √

Execute:

FieldNameorDataType Values

From period Current

To period Current

Plan/actual keyfigure 0

Version -

Record Type F

Continued on next page

372

Plan/actual keyfigure	0
Version	-
Record Type	F

FieldNameorDataType	Values
Customer	T-CO05A##
ReferenceDocumentNumber	√
Billing Date	√

FieldNameorDataType	Values
Sales Revenue	√
InvoicedquantityinSKUn	√

FieldNameorDataType	Values
From period	Current
To period	Current
Plan/actual keyfigure	0
Version	-
Record Type	F

第 391 页 / 共 483 页

AC605 Lesson: Creating Reports

2. Howmany referencedocumentsaredisplayed?

a) Howmanyreferencedocumentsaredisplayed?

The answers to this question vary.

3. Viewthetotalrevenueatthematerialgrouplevel. Howmuchdoesthetotal

revenue amount to?

a) Viewthetotal revenueat thematerialgroup level. Whatisthetotal

revenue amount?

The answers to this question vary.

373

第 392 页 / 共 483 页

Unit6: InformationSystem AC605

Lesson Summary

You should now be able to:

• Create basic reports

• Create form reports

• Create line item reports

• Transfer the report data

374

第 393 页 / 共 483 页

AC605 Lesson: Financial Analytics in SAP BI

Lesson: Financial Analytics in SAP BI

Lesson Overview

ThislessonprovidesyouwithanoverviewofSAPBIaswellasadescriptionof

theintegrationofCO-PAandSAPBI.Inaddition,itenablesyoutoevaluatethe

benefits of profitability reporting in BI.

Lesson Objectives

After completingthislesson, youwillbeable to:

• ExplaintheintegrationbetweenCO-PAandSAPBI

• EvaluatethebenefitsofFinancialAnalyticsinSAPBI

Business Example

The management of your company would like to implement a profitability

accountingapplicationintheSAPsystem. Asamemberofyourtheprojectteam,

youaresupposedtoadviseonthequestionofwhether toimplementCO-PAor

EC-PCAintheSAPsystem. Youwillthenberesponsibleforimplementingthe

selected applications.

Youneedtoanalyzeyourplanstoensuremaximumprofits. Forthisreason,you

needtounderstandtheconceptofFinancialAnalyticsinSAPBI.

Overview of SAP BW

Figure 148: SAP BW: Business Intelligence

375

第 394 页 / 共 483 页

Unit6: InformationSystem AC605

Supplychainplanningisakeycomponentbecauseyoucanuseittoimprovethe

performanceofthesupplychainofacompanyandcreateshareholdervalue. The

major benefitsareimproved customer service, reduced inventories, cycletime

compression,lowersupplychainvariability,andmaximizedROA.

SAP APO enables a company to implement the best business practices to

achieve outstanding improvements. These include Sales and Operations

Planning(SOP),VendorManagedInventory, SynchronousManufacturing, and

Capable-to-Promise.

Coordinatingthemanydifferenttasks,people,andtechnicalresourcesassociated

withrunningawarehouse,andtransportinggoodshasneverbeeneasy. Despite

this fact, warehouseand transportation processesare avital part of the supply

chainandessentialtocreatingaresponsiveandefficientbusinessorganization. In

thepastyears,theurgencyandcomplexityofthefollowingfactorshasincreased

enormously: Globalization,mergers,fiercelycompetitivemarketsthathighlight

the importance of customer service, and the emergence of new technologies,

such as the Web.

The Logistics Execution System (LES) is a part of the unique Supply Chain

Management Initiative of SAP. It allows you to forge strong yet flexible links

betweentheproduction, procurement, storage, distribution, transportation, and

sales and service processes.

Figure 149: BW and the Business Framework

Therequirementsplacedonamodernsolutionforadatawarehousearecovered

bytheconsiderationsthatSAPhascollectedunderthegenerictermofBusiness

Framework Architecture.

376

第 395 页 / 共 483 页

AC605 Lesson: Financial Analytics in SAP BI

Thoughtsonthetopicsofquickerimplementationofnewfunctions, flexibility,

and openness have formed the background for this strategy. The technical

prerequisitesforthecomponentizationofbusinessstandardsoftwarearefulfilled

bytheavailabilityoftriedandtestedALEandtechniquesintheSAPsystem.

A business component provides self-contained business functions with stable

interfaces. Such a component has its own cycle with regard to development,

implementation, and maintenance. Some components can run on their own,

dedicated database.

Thebusinesscomponentsmakeuseoftheobject-orientedinterfacetechnology

based onBusinessApplicationProgramming Interfaces(BAPIs). ABAPI isa

method of an SAP Business Object and attains a new level of interoperability

betweentheencapsulatedSAPBusinesscomponentsthatcanbenetworked.

SAP uses Application Link Enabling (ALE) and SAP Business Workflow to

ensuretheintegrationofthewholesystem. Thismeansthatbusinessprocesses

can also be formed across components.

Figure 150: Business Content Overview

The Business Information Warehouse is preconfigured with SAP business

know-how or Business Content.

BusinessContentcoversinformationmodels,queries,andextractors,aswellas

external data and company benchmarking.

SAPBIfunctionsalsoincludeanumberofstandardevaluationpossibilitiesfor

key business areas.

377

第 396 页 / 共 483 页

Unit6: InformationSystem AC605

The Business Content strategy allows SAP to:

• MapthecontentofthestandardSAPERPsystem.

• Display the industry-specific models.

• Provide a platform for partners' content.

• Include external data such as:

– Consolidated POS data

– Market research data

– Demographic data

– Company benchmark data

Figure 151: BusinessInformation Warehouse Architecture

ThisfigureprovidesanoverviewoftheSAP BusinessInformation Warehouse

structurein a heterogeneous system landscape.

SAPsystemsandexternalsystemsaredisplayedasOLTPsystemsinthelower

section of the screen.

MetadataandapplicationdataismanagedontheBusinessInformationWarehouse

server.

You use the Business Information Warehouse to manage the various source

systems. YoualsousethecomponentsoftheAdministratorWorkbench,Scheduler

andMonitor, toscheduleand monitor thetransfer ofmetaand transactiondata

from the assigned legacy systems.

TheBusinessExplorer,withitsreportingtools,formsathirdlayer.

Theindividualareaswillbeexplainedextensivelyinthefollowingunits.

378

第 397 页 / 共 483 页

AC605 Lesson: Financial Analytics in SAP BI

As components of the Business Framework, the OLTP applications and the

Business Information Warehouse communicate using Business Application

Programming Interfaces (BAPIs).

SAP delivers Production Data Extractors that prepare SAP ERP data for each

applicationforextractionintotheBusinessInformationWarehouse.

FornonSAPOLTPsystems,theBWBAPIinterfaceallowstheuseofthird-party

extraction tools to prepare and extract data.

Integration Between CO-PA and BW

Figure 152: Extraction ofData from CO-PA to SAPBW

TheAdministratorWorkbenchisthetoolusedtogetdatafromthesourcesystems

into the Business Information Warehouse.

AllthesystemsthatprovidetheSAPBusinessInformationWarehousewithdata

are indicated as source systems.

An InfoSource is asummarized quantity of information that logically belongs

togetherforaunit. InfoSourcescaneitherencompasstransactiondataormaster

data, such as attributes, texts and hierarchies.

AnInfoSourceisalwaysaquantityofanInfoObjectcollection. AnInfoSource

alwayssignifiesonescenariofromanapplication,suchasFinancialAccounting.

Thebusinessevaluationobjects,suchascustomerandsalesrevenue,areknownas

InfoObjectsintheBW.Theyaredividedintocharacteristics,keyfigures,units,

and time characteristics.

379

第 398 页 / 共 483 页

Unit6: InformationSystem AC605

The scheduler is the connecting link between the source systems and the

InfoCubes. Withthistool, youestablishwhatdataisrequestedfromthesource

systemandatwhattimeitisupdatedintheInfoCubeandtheOperationalData

Store(ODS).TheprincipleoftheschedulergoesbacktothefunctionsoftheSAP

ERPbackgroundjobs. Thedatarequestcanbescheduledeitherstraightawayor

withabackgroundjob,andautomaticallyatalaterpointintime.

Figure 153: Profitability Analysis with BW

Reporting with the Business Explorer: The Business Information Warehouse

deliversthe information for theanalysisof all of the factors that influence the

business activitiesof an enterprise. The databasisof theBusinessInformation

Warehouseisstructuredintoself-containedbusinessdataareas(InfoCubes). An

InfoCube contains the InfoObjects of the type characteristics and key figures.

It is best to imagine an InfoCube as a data cube with a key figure axis. Each

characteristic stretches along one axis of the cube with all its different values.

Thenumber of characteristicsdeterminesthecomplexity ofthedatacube, and

thenumberofcharacteristicvaluesdeterminesthelengthoftheedgeofthecube

withthisdimension. Theamountof thekeyfiguresintheInfoCubealsoforms

anaxis(+1). ThedatasetoftheInfoCubecanbeevaluatedaccordingtodifferent

380

第 399 页 / 共 483 页

AC605 Lesson: Financial Analytics in SAP BI

characteristics and key figures using the Business Information Warehouse

reportingfunction. Asaresult,youhavethepossibilityofcarryingoutalltypesof

varianceanalyses,suchasplan-actualcomparisonandfiscalyearcomparison.

• Database Considerations

– High Data Volume

– Cross Application Reporting

– Collecting data from different systems

– CombiningLegacySystemDatawithCO-PAData

In a scenario of how SAP BI is used in profitability reporting, you move the

reportingtasksfromSAPERPintoanindependentsystem. Forsuchascenario,

SAPERP operatesasanOnlineTransactionProcessing(OLTP)system, which

runs the operational business, and the SAP BI system serves as an Online

Analytical Processing (OLAP) system.

For environments involving several SAP ERP systems that represent slightly

differentmethodsofprofitabilityanalysisforvariouscountriesorbusinessunits,

you need to gain a cross-system view. In this scenario, the results from the

differentorganizationalsubunitsarecombinedintoasingleInfoCubeinSAPBI

thatcontainsthesamereportinglevelsandcalculationsofcontributionmargins.

CO-PAprovidesthenecessaryfunctionsforpreparingyourdatabasisforgroup

profitability.

Athird scenariofor theimplementationofCO-PAwithan SAP BI installation

iswhentheaffiliatedcompaniesorthepartsofyour companyoperatesystems

otherthanSAPandtheirdatahastobeconsolidatedinyourreportingofgroup

profitability.

381

第 400 页 / 共 483 页

Unit6: InformationSystem AC605

Lesson Summary

You should now be able to:

• ExplaintheintegrationbetweenCO-PAandSAPBI

• EvaluatethebenefitsofFinancialAnalyticsinSAPBI

382

第 401 页 / 共 483 页

AC605 Unit Summary

Unit Summary

You should now be able to:

• 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

383

第 402 页 / 共 483 页

UnitSummary AC605

384

第 403 页 / 共 483 页

AC605 Test Your Knowledge

Test Your Knowledge

1. Name the output types of reports.

2. Level letsyousendreports by SAPmail.

Fillintheblankstocompletethesentence.

3. Identifythemaindifferencebetweenbasicandformreports.

4. ListtheanalysisfunctionsusedtoclassifyandrankCO-PAdata.

5. Basic reports require the use of a form.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

6. Reportsbasedonlineitemsareavailableonlyforcosting-basedProfitability

Analysis.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

7. What is a form?

385

第 404 页 / 共 483 页

TestYourKnowledge AC605

8. Thefunctionusedtotransferdatafromreportstoaspreadsheetapplication

canworkonlyundertheWindows95operatingsystem.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

9. How will you delete a report?

10. What are the three types of forms?

11. What is a line item report?

12. The formatisaspecialformatusedtotransferthedatafroma

report to a spreadsheet application.

Fillintheblankstocompletethesentence.

13. The methodattainsanewlevelofinteroperabilitybetweenthe

encapsulatedSAPBusinesscomponentsthatcanbenetworked.

Fillintheblankstocompletethesentence.

14. SAP uses and

toensuretheintegration

of the whole system.

Fillintheblankstocompletethesentence.

386

第 405 页 / 共 483 页

AC605 Test Your Knowledge

15. WhatarethebenefitsofintegratingCO-PAandBW?

16. The isthetoolusedto

getdatafromthesourcesystemsintotheBusinessInformationWarehouse.

Fillintheblankstocompletethesentence.

17. AllthesystemsthatprovidetheSAPBusinessInformationWarehousewith

dataareindicatedas .

Fillintheblankstocompletethesentence.

18. When you move reporting tasks from SAP R/3 Enterprise into

an independent system, e SAP R/3 Enterprise operates as an

system.

Fillintheblankstocompletethesentence.

387

第 406 页 / 共 483 页

TestYourKnowledge AC605

Answers

1. Name the output types of reports.

Answer: Theoutputtypesofreportsaregraphical,drill-down, andobject

list reports.

2. Level 1 letsyou send reportsby SAPmail.

Answer: 1

3. Identifythemaindifferencebetweenbasicandformreports.

Answer: Reportswithasimple,fixedlayoutarebasicreports,andreports

withamorecomplexstructureandformattingareformreports.

4. ListtheanalysisfunctionsusedtoclassifyandrankCO-PAdata.

Answer: YoucanclassifyandrankyourCO-PAdatausingthefollowing

three analysis functions:

• Cumulative curve

• ABC analysis

• Classification

5. Basic reports require the use of a form.

Answer: False

Basic reportsdo not requiretheuseof aform.

6. Reportsbasedonlineitemsareavailableonlyforcosting-basedProfitability

Analysis.

Answer: True

Reportsbasedonlineitemsareavailableonlyforcosting-basedProfitability

Analysis.

7. What is a form?

Answer: Aformcanberegardedasasemifinishedreportstructure,which

youcompletebyspecifyingadditionalcharacteristicsandkeyfigureswhen

you define the final report.

388

第 407 页 / 共 483 页

AC605 Test Your Knowledge

8. Thefunctionusedtotransferdatafromreportstoaspreadsheetapplication

canworkonlyundertheWindows95operatingsystem.

Answer: False

The function for transferring reports into atablecalculation program can

onlybeusedinthefollowingoperatingsystems: OS/2PresentationManager,

Windows,WindowsNT,Windows32bitorWindows95.

9. How will you delete a report?

Answer: AreportcanbedeletedusingtheChangereportfunction.

10. What are the three types of forms?

Answer: The three types of forms are:

• One axis without key figure.

• One axis with key figure.

• Two axes with key figure.

11. What is a line item report?

Answer: A line item report is a report that allows you to execute a line

itemanalysisandsimultaneouslyuseallnavigationfunctionsindrill-down

reporting.

12. TheXXLformatisaspecialformatusedtotransferthedatafromareportto

a spreadsheet application.

Answer: XXL

13. The BAPI method attains a new level of interoperability between the

encapsulatedSAPBusinesscomponentsthatcanbenetworked.

Answer: BAPI

14. SAPusesApplicationLinkEnablingandSAPBusinessWorkflowtoensure

the integration of the whole system.

Answer: ApplicationLinkEnabling,SAPBusinessWorkflow

389

第 408 页 / 共 483 页

TestYourKnowledge AC605

15. WhatarethebenefitsofintegratingCO-PAandBW?

Answer: The benefits of integrating CO-PA and BW are with regard to

database considerations such as:

• High Data Volume

• Cross Application Reporting

• Collecting data from different systems

• CombiningLegacySystemDatawithCO-PAData

16. TheAdministratorWorkbenchisthetoolusedtogetdatafromthesource

systemsintotheBusinessInformationWarehouse.

Answer: Administrator Workbench

17. AllthesystemsthatprovidetheSAPBusinessInformationWarehousewith

data are indicated as source systems.

Answer: source systems

18. When you move reporting tasks from SAP R/3 Enterprise into an

independentsystem,eSAPR/3EnterpriseoperatesasanOnlineTransaction

Processing system.

Answer: Online Transaction Processing

390

第 409 页 / 共 483 页

第 410 页 / 共 483 页

第 411 页 / 共 483 页

Unit 7

Tools

Unit Overview

This unit explains the various tools in Planning. It defines the summarization

levelsforCO-PAandexplainstheconceptofsummarizeddataandfrozendata. It

also helps execute realignments of data.

Unit Objectives

After completing thisunit, you will beableto:

• Define and activate summarization levels

• Understand summarized dataand frozendata

• Re-organizedataafterorganizationalchangeshaveoccurred

• Analyze the Customizing Settings using the different options of the

Customizing Monitor

Unit Contents

Lesson: Performance Tools ...................................................392

Exercise 21: Performance Tools..........................................399

Exercise 22: Summarization Levels .....................................401

Lesson: Realignment and Customizing Monitors...........................407

Exercise 23: Realignment Concept......................................411

391

第 412 页 / 共 483 页

Unit7: Tools AC605

Lesson: Performance Tools

Lesson Overview

Thislessoncovershowtodefineandactivatesummarizationlevels. Italsohelps

youtounderstandsummarizeddataandfrozendata.

Lesson Objectives

After completingthislesson, you will beable to:

• Define and activate summarization levels

• Understand summarized dataand frozen data

Business Example

The management of your company would like to implement a profitability

accountingapplicationintheSAPsystem. Asamemberofyourtheprojectteam,

youaresupposedtoadviseonthequestionof whether toimplementCO-PAor

EC-PCA in the SAP system. You then will be responsible to implement the

selected applications. To increasedataretrieval speed on someof yourroutine

reports, you have decided to use frozen data. For this purpose, you need an

understandingaboutthesummarizationlevels,summarizeddata,andfrozendata.

Summarization Levels

Figure 154: CO-PA Database Structures

Segment Table and Segment Level

392