AC612_EN_Col92_FV_Part_A4 (第6页) | ERP软件技术分享

第 202 页 / 共 243 页

Unit5: InformationSystem AC612

4. Display the hierarchy again.

5. You want to change the sequence of the navigation characteristics. You

wantthefollowingcharacteristicstoappearatthetopofthelist: Bal/P&L

- Item/Account, ProfitCenter, andPartner Profit Center. Youcanarrange

theother characteristicsin anyorder youwish.

6. You want toswitch theviewof thefinancial statement structurewith the

view of profit center group GROUP##.

7. YouwanttoseethebalancesheetandP&Lstructureforprofitcenter612##.

8. Analyze sales on account 800000. You then want to display the

correspondinglineitemsinFinancialAccountingandnavigatedowntothe

sourcedocument. Thenreturntotheoriginalreport.

9. You only want to seethe balance sheet changes(3020000) as part of the

hierarchy. Restrictthehierarchyviewaccordingly.

10. You want to analyzethe account for consumption of unfinished products

(890000)inmoredetail-itwaspostedtoduringthegoodsissuechargedto

theproductionorder. Whichisthepartnerprofitcenter?

Task 2:

Youwanttoexaminethefunctionsingraphicaldrilldownreporting.

1. Go to the information system for the new general ledger and call the

report Profit Center Group: Plan/Actual/Variance with the following

parameters:

Currency Type 10

Company Code 1000

Ledger 0L

Controlling Area 1000

FISAnnual Rep.Struc INT

Plan Version 1

Fiscal Year Current fiscal year

From Period 1

To Period 12

Profit Center GROUP00

Output Type Graphical Report Output

You see the FIS annual reporting structure INT for profit center group

GROUP00.

Continued on next page

186

Currency Type	10
Company Code	1000
Ledger	0L
Controlling Area	1000
FISAnnual Rep.Struc	INT
Plan Version	1
Fiscal Year	Current fiscal year
From Period	1
To Period	12
Profit Center	GROUP00
Output Type	Graphical Report Output

第 203 页 / 共 243 页

AC612 Lesson: Overview

2. NavigateintheprofitandlossstatementdowntoaccountDomesticRevenues

from Production. You want to see both the names and the keys of the

accounts. Displaythekeysandnamesforthehierarchy.

3. Youfindittoocomplicatedtonavigatewithinthehierarchyofthefinancial

statements. You want to see a flat list of account numbers instead of the

hierarchy.

4. Display the hierarchy again.

5. Youwant toswitch theview of thefinancial statement structurewiththe

view of profit center group GROUP00.

6. YouwanttoseethebalancesheetandP&Lstructureforprofitcenter612##.

7. Analyze sales on account 800000. You then want to display the

correspondinglineitemsinFinancialAccountingandnavigatedowntothe

originaldocument. Thenreturntotheoriginalreport.

8. You only want to see the balancesheet changes (3020000) as part of the

hierarchy. Restrictthehierarchyviewaccordingly.

9. You want to analyze the account for consumption of unfinished products

(890000)inmoredetail-itwaspostedtoduringthegoodsissuechargedto

theproductionorder. Whichisthepartnerprofitcenter?

Task 3:

Youwanttoanalyzeaccountsreceivablepostingsattheprofitcenterlevel.

1. CalltheReceivables: ProfitCenterreportwiththefollowingdata:

Customer Account T-CSD00 toT-CSD18

Company Code 1000

Open on Key Date Today’s date

ControllArea 1000

Hier. Profit Center: AC612

Output Type Classic Drilldown Report

You see all the receivables on the screen.

2. DrilldownthisamountwiththeProfitCentercharacteristic.

3. Display thecustomer for profit center 612##.

4. DisplaythedocumentnumbersforcustomerT-CSD##.

Continued on next page

187

Customer Account	T-CSD00 toT-CSD18
Company Code	1000
Open on Key Date	Today’s date
ControllArea	1000
Hier. Profit Center:	AC612
Output Type	Classic Drilldown Report

第 204 页 / 共 243 页

Unit5: InformationSystem AC612

Task 4:

Youwanttoanalyzeaccountspayablepostingsattheprofitcenterlevel.

1. CallthePayables: ProfitCenterreportwiththefollowingdata:

Vendor Account T-K500A00toT-K500A18and

1000

Company Code 1000

Open on Key Date Today’s date

ControllArea 1000

Hier. Profit Center: AC612

Output Type Classic Drilldown Report

You see all the payables on the screen.

2. DrilldownthisamountwiththeProfitCentercharacteristic.

3. Display thevendors for profit center 611##.

4. DisplaythedocumentnumbersforvendorT-K500A##.

5. Fromthisview,displaythedocumentnumbersforvendor1000.

188

Vendor Account	T-K500A00toT-K500A18and 1000
Company Code	1000
Open on Key Date	Today’s date
ControllArea	1000
Hier. Profit Center:	AC612
Output Type	Classic Drilldown Report

第 205 页 / 共 243 页

AC612 Lesson: Overview

Solution 11: Overview

Task 1:

Youwanttoexaminethefunctionsinclassicdrilldownreporting.

1. Go to the information system for the new general ledger and call the

report Profit Center Group: Plan/Actual/Variance with the following

parameters:

Currency Type 10

Company Code 1000

Ledger 0L

Controlling Area 1000

FIS Annual Rep.Struc INT

Plan Version 0

Fiscal Year Current fiscal year

From Period 1

To Period 12

Profit Center Group GROUP##

Output Type Classic drilldown report

You see the FIS annual reporting structure INT for profit center group

GROUP##.

a) Accounting→FinancialAccounting→GeneralLedger→Information

System→GeneralLedgerReports(New)→ReportsforProfitCenter

Accounting→ProfitCenterGroup: Plan/Actual/Variance.

2. Navigate in the profit and loss statement down to account “Domestic

RevenuesfromProduction”. Youwanttoseeboththenamesandthekeysof

theaccounts. Displaythekeysandnamesforthehierarchy.

a) ChooseSettings→CharacteristicDisplayandsetthekeysandnames.

Younow also see account number800000.

3. Youfindittoocomplicatedtonavigatewithinthehierarchyofthefinancial

statements. You want to see a flat list of account numbers instead of the

hierarchy.

a) Choose Edit→HierarchySelectionandchooseNoHierarchy. You

nowseealistofaccountnumbers,withoutahierarchy.

Continued on next page

189

Currency Type	10
Company Code	1000
Ledger	0L
Controlling Area	1000
FIS Annual Rep.Struc	INT
Plan Version	0
Fiscal Year	Current fiscal year
From Period	1
To Period	12
Profit Center Group	GROUP##
Output Type	Classic drilldown report

第 206 页 / 共 243 页

Unit5: InformationSystem AC612

4. Display the hierarchy again.

a) ChooseEdit→Hierarchy→SelectandchoosetheINThierarchy. The

hierarchy appears again.

5. You want to change the sequence of the navigation characteristics. You

wantthefollowingcharacteristicstoappearatthetopofthelist: Bal/P&L

- Item/Account, ProfitCenter, andPartner Profit Center. Youcanarrange

theother characteristicsin anyorder youwish.

a) Choose Navigate → Sort Characteristics. Enter the sequence of

numbers accordingly.

6. You want toswitch theviewof thefinancial statement structurewith the

view of profit center group GROUP##.

a) Single-click the Profit Center field and then the Bal/P&L –

Item/Accountfield. Youseetheadministrationandproductionprofit

centers in GROUP##.

7. YouwanttoseethebalancesheetandP&Lstructureforprofitcenter612##.

a) Single-clicktheBal/P&L-Item/Accountandselectthelinewithprofit

center612##. Youseethefinancialstatementforprofitcenter612##.

8. Analyze sales on account 800000. You then want to display the

correspondinglineitemsinFinancialAccountingandnavigatedowntothe

sourcedocument. Thenreturntotheoriginalreport.

a) Drill down the hierarchy to account 800000. Position the cursor

on actual sales and choose Goto →Call Report.... Choose the G/L

Account Line Item Display report. From the line item list, choose

Environment → Display Document. Choose Goto → Document

Overviewtodisplaythefulldocument. Fromhere,chooseEnvironment

→DocumentEnvironment→SourceDocumenttodisplaythebilling

document from R-F1##.

Then return to the original report.

9. You only want to seethe balance sheet changes(3020000) as part of the

hierarchy. Restrictthehierarchyviewaccordingly.

a) Clickthenodeforbalancesheetchanges(3020000). ChooseNavigate

→ Hierarchy → Set Focus.

Continued on next page

190

第 207 页 / 共 243 页

AC612 Lesson: Overview

10. You want to analyze the account for consumption of unfinished products

(890000)inmoredetail-itwaspostedtoduringthegoodsissuechargedto

theproductionorder. Whichisthepartnerprofitcenter?

a) Single-clickthePartnerProfitCenternavigationcharacteristic. Select

thelinewith theaccountConsumption UnfinishedGoods(890000).

The partner profit center is 1010.

Hint: Thepartnerprofitcentercomesfromthematerialmaster

ofsemifinishedgoodsforpumpR-F1##. Thematerialnumbers

areR-B1##,R-B2##,R-B3##,andR-B4##.

Task 2:

Youwanttoexaminethefunctionsingraphicaldrilldownreporting.

1. Go to the information system for the new general ledger and call the

report Profit Center Group: Plan/Actual/Variance with the following

parameters:

Currency Type 10

Company Code 1000

Ledger 0L

Controlling Area 1000

FIS Annual Rep.Struc INT

Plan Version 1

Fiscal Year Current fiscal year

From Period 1

To Period 12

Profit Center GROUP00

Output Type Graphical Report Output

You see the FIS annual reporting structure INT for profit center group

GROUP00.

a) Accounting→FinancialAccounting→GeneralLedger→Information

System→GeneralLedgerReports(New)→ReportsforProfitCenter

Accounting→ProfitCenterGroup: Plan/Actual/Variance.

Continued on next page

191

Currency Type	10
Company Code	1000
Ledger	0L
Controlling Area	1000
FIS Annual Rep.Struc	INT
Plan Version	1
Fiscal Year	Current fiscal year
From Period	1
To Period	12
Profit Center	GROUP00
Output Type	Graphical Report Output

第 208 页 / 共 243 页

Unit5: InformationSystem AC612

2. NavigateintheprofitandlossstatementdowntoaccountDomesticRevenues

from Production. You want to see both the names and the keys of the

accounts. Displaythekeysandnamesforthehierarchy.

a) ChooseSettings→CharacteristicDisplayandsetthekeysandnames.

You nowalso seeaccountnumber 800000.

3. Youfindittoocomplicatedtonavigatewithinthehierarchyofthefinancial

statements. You want to see a flat list of account numbers instead of the

hierarchy.

a) ChooseEdit→HierarchySelectionandchooseNoHierarchy. You

nowseealistofaccountnumbers,withoutahierarchy.

4. Display the hierarchy again.

a) ChooseEdit→HierarchySelectionandchoosetheINThierarchy. The

hierarchy appears again.

5. You want toswitch theviewof thefinancial statement structurewith the

view of profit center group GROUP00.

a) Double-clicktheProfitCenterfield. Youseetheadministrationand

production profit center in GROUP00.

6. YouwanttoseethebalancesheetandP&Lstructureforprofitcenter612##.

a) Drag profit center 612##totheBal/P&L -Item/Account navigation

characteristic. Youseethefinancialstatementforprofitcenter612##.

7. Analyze sales on account 800000. You then want to display the

correspondinglineitemsinFinancialAccountingandnavigatedowntothe

originaldocument. Thenreturntotheoriginalreport.

a) Drill down the hierarchy to account 800000. Position the cursor

on actual sales and choose Goto →Call Report.... Choose the G/L

Account Line Item Display report. From the line item list, choose

Environment → Display Document. Choose Goto → Document

Overviewtodisplaythefulldocument. Fromhere,chooseEnvironment

→DocumentEnvironment→SourceDocumenttodisplaythebilling

document from R-F1##.

Then return to the original report.

8. You only want to seethe balance sheet changes(3020000) as part of the

hierarchy. Restrictthehierarchyviewaccordingly.

a) Click the node for balance sheet changes (3020000). Click the

Hierarchy... iconandthentheSetFocusicon. Younowonlyseethe

balance sheet changes.

Continued on next page

192

第 209 页 / 共 243 页

AC612 Lesson: Overview

9. You want to analyze the account for consumption of unfinished products

(890000)inmoredetail-itwaspostedtoduringthegoodsissuechargedto

theproductionorder. Whichisthepartnerprofitcenter?

a) DragtheStockChangesofUnfinishedProducts(890000)tothePartner

Profit Center navigation characteristic. The partner profit center is

1010.

Hint: Thepartnerprofitcentercomesfromthematerialmaster

ofsemifinishedgoodsforpumpR-F1##. Thematerialnumbers

areR-B1##,R-B2##,R-B3##,andR-B4##.

Task 3:

Youwanttoanalyzeaccountsreceivablepostingsattheprofitcenterlevel.

1. CalltheReceivables: ProfitCenterreportwiththefollowingdata:

Customer Account T-CSD00 toT-CSD18

Company Code 1000

Open on Key Date Today’s date

ControllArea 1000

Hier. Profit Center: AC612

Output Type Classic Drilldown Report

You see all the receivables on the screen.

a) Accounting→FinancialAccounting→GeneralLedger→Information

System→GeneralLedgerReports(New)→LineItems→OpenItems

→ Receivables: Profit Center

2. DrilldownthisamountwiththeProfitCentercharacteristic.

a) Choosethe Profit Centercharacteristicandthen select the linewith

account 140000.

3. Display thecustomer for profit center 612##.

a) ChoosetheCustomercharacteristicandthenselectthelinewithprofit

center 612##.

4. DisplaythedocumentnumbersforcustomerT-CSD##.

a) ChoosetheDocumentNumbercharacteristicandthenselecttheline

with customer T-CSD##.

Continued on next page

193

Customer Account	T-CSD00 toT-CSD18
Company Code	1000
Open on Key Date	Today’s date
ControllArea	1000
Hier. Profit Center:	AC612
Output Type	Classic Drilldown Report

第 210 页 / 共 243 页

Unit5: InformationSystem AC612

Task 4:

Youwanttoanalyzeaccountspayablepostingsattheprofitcenterlevel.

1. CallthePayables: ProfitCenterreportwiththefollowingdata:

Vendor Account T-K500A00toT-K500A18and

1000

Company Code 1000

Open on Key Date Today’s date

ControllArea 1000

Hier. Profit Center: AC612

Output Type Classic Drilldown Report

You see all the payables on the screen.

a) Accounting→FinancialAccounting→GeneralLedger→Information

System→GeneralLedgerReports(New)→LineItems→OpenItems

→ Payables: Profit Center

2. DrilldownthisamountwiththeProfitCentercharacteristic.

a) ChoosetheProfit Centercharacteristicandthen select thelinewith

account 160000.

3. Display thevendors for profit center 611##.

a) ChoosetheVendorcharacteristicandthen select thelinewithprofit

center 611##.

Vendors1000andT-K500A##havebeenpostedto.

4. DisplaythedocumentnumbersforvendorT-K500A##.

a) ChoosetheDocumentNumbercharacteristicandthenselecttheline

with customer T-K500A##.

5. Fromthisview,displaythedocumentnumbersforvendor1000.

a) Clickthe iconandchoosevendor1000fromtheselectionlist.

194

Vendor Account	T-K500A00toT-K500A18and 1000
Company Code	1000
Open on Key Date	Today’s date
ControllArea	1000
Hier. Profit Center:	AC612
Output Type	Classic Drilldown Report

第 211 页 / 共 243 页

AC612 Lesson: Overview

Lesson Summary

You should now be able to:

• Use a drilldown report

• Define a drilldown report yourself

195

第 212 页 / 共 243 页

Unit5: InformationSystem AC612

Lesson: Reporting with Drilldown Reporting

Lesson Overview

Youwanttodefineaform-baseddrilldownreportforprofitcenterevaluations.

Lesson Objectives

After completingthislesson, you will beable to:

• Defineyour ownform-baseddrilldown reports

Business Example

Yourcompany'smanagementwantstoknowabouttheoptionsforwritingcustom

reports.

Figure 82: Interactive Reporting: Drilldown Reporting

Drilldown reporting allows you to analyze your data according to different

characteristics and key figures.

• Characteristicsarenon-numericfields. Theyrepresentthecriteriaaccording

to whichyoucanselectdatarecords. Examplesofcharacteristicsinclude

controllingarea,fiscalyear,andprofitcenter. Characteristicvaluesarethe

instancesofthesecharacteristics,suchasfiscalyear2008,2009,andsoon.

• Key figures are numerical fields that you can analyze in your reports.

Examplesofkeyfiguresareexpensesandrevenuesorbalancesheetbalances

in a certain currency.

196

第 213 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Youcananalyzeanumberofkeyfiguresforasinglecombinationofcharacteristic

valuesaswellassinglekeyfiguresforanumberofcombinationsofcharacteristic

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

"object"(example: profitcenterX,revenue/costelement400000inperiod6).

Figure 83: The Concept of Drilldown Reporting

DrilldownreportingletsyouusethesamegraphicaluserinterfaceastheReport

Painterfordefiningthebasicstructureof yourreports. Youcanthenapplythis

structure, orform, toanynumber ofdrilldownreports.

Drilldownreporting providesyou withanumber of user-friendlyfunctionsfor

navigating through your reports, limit your analysis to a single characteristic

value,orsummarizethedataforallvaluesofacharacteristic.

IfthereportreferstotableFAGLFLEXT,thecharacteristicsinthattabledetermine

how your data can be classified. Examples of characteristics include the SAP

organizationalunitscompanycodeandbusinessarea. Thetimereference(fiscal

year, period) is also a characteristic.

Your application contains a number of key figures that may be relevant for

analysis purposes. Key figures include not only stored values and quantities,

butalsovaluesthatarecalculatedfromthem,basedonformulaswhichyoucan

define. Examples of key figures:

• Value: Expenses, sales, sales deductions

• Calculation: Salesperemployee,returnoninvestment,cashflow

197

第 214 页 / 共 243 页

Unit5: InformationSystem AC612

Figure 84: Functions in Drilldown Reporting

Thefunctionsofdrilldownreportingaredividedintothreelevelssothatyoucan

giveeachuseronlythosefunctionsthatheorsherequires.

Level1containsthebasicfunctionsofdrilldownreporting,plusitletsyousend

reportsbySAPmail. Thislevelisdesignedforuserswhodonotrequirethefull

functionality of drilldown reporting.

Level 2 contains the rest of the drilldown functions, plus it lets you display

graphicsand download reportsto MicrosoftExcel.

All functions offers you all the functions in drilldown reporting, including

the print setup function and the functions for saving report data and defining

exceptions. Thislevelisdesignedforuserswhoneedtoprintandmodifyreports

in additiontoalltheinteractivedrilldown functions.

YoucandefinethedesiredlevelforeachuserbyenteringtheparameterRLV(0=

Allfunctions,1=Level1,2=Level2)inhisorheruserparameters.

Theindividualfunctionlevelsaresubjectedtoanauthorizationcheck.

198

第 215 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Figure 85: Formatting Options

Youcanconfiguremanysettingsfromwithinthedisplayedreport,todisplayand

printoutdata. Youcanusethesesettingstochangethecurrency,characteristics

displayed,totalsrow,sortfunctions(suchas'SortColumns'),layout(forexample,

cumulateddisplayon/off), andvariousprintsettings.

Currency: Youcanusethisfunction totranslatethe currency displayedforthe

selected currency column(s) to a different currency. The currency translation

key is used to automatically find the exchange rate. You define the currency

translation keys in Customizing.

Sort: Youcanusethisfunction to sorttherowsinyourreport listinascending

or descending order (based on the values in the selected row(s)). You always

sorttherowsin the columnor columnblock on whichyour cursor iscurrently

positioned. Thesystemdisplaysadialogboxinwhichyoucandecidewhether

youwanttosortthecolumnorcolumnblockalphabeticallyaccordingtothekey

ortextofthecharacteristicvalues,thekeyfigureor,whereapplicable,ahierarchy

or hierarchy display.

Number Format: Enables you to change the number format and the sign for

individualcolumns. Theavailablesettingsdependonthereportandtypeoflist

displayed.

Youcancreatecustomlayoutsforreportforms. Theselayoutsareoftenusedfor

officialreportsandareespeciallysuitedfor printing.

Drilldownreportsarebasedonforms,whichareseparateobjectsthatcanbeused

foranumberofreports. Therearedifferenttypesofforms,whichdifferinterms

of what elements are defined intheir structures.

If you want to deletea report you can do thisfromthe change transaction. If

you want to delete an entire group of reports, however, it is easier to do so in

Customizing.

199

第 216 页 / 共 243 页

Unit5: InformationSystem AC612

Figure 86: Variables: Overview

Variablesallowyoumoreflexibilitytodefineyourformsandreports. Variables

are report or form parametersthat you do not want to specify until you define

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

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

globally or locally.

Ifyouwanttocreateavariablethatyouonlyneedinoneparticularformorreport,

youcancreatealocalvariable. Localvariablesareonlyknownwithintherelevant

formorreport. Ifyoudefinealocalvariableinaform,itisalsovalidforevery

report that uses the form.

Incontrast,ifyoudefineavariableinthereportdefinition,itisonlyvalidforthat

onereport. Ifyouuseavariablefrequently,youcandefineitglobally. Thismakes

itpossibletouseglobalvariablesinallyourformsandreports. Globalvariables

aremaintainedinCustomizing. Ifyouthenwanttouseglobalvariablesinaform

orinareport,thesearedisplayedforselectionintheinputhelp.

Hint: Ifyouchangeaglobalvariablethatisalreadybeingusedinforms

orreports,thisaffectseveryformandeveryreportthatusesthatvariable.

200

第 217 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Figure 87: Architecture of Drilldown Report

Youcanusecharacteristics,keyfigures,andformstodefineareport. Theresult

whenyoudisplaythereportisanumberoflistsandgraphicsthatyoucandisplay

and analyze interactively.

Aformdeterminesthecontentandtheformalstructureofareportlist. Aform

usasemifinishedreport, whichyoucompletebyspecifyingcharacteristicsand

keyfigureswhenyoudefinetheindividualreport. Youcanspecifycharacteristics

bothintheformandinthereport. Keyfigures,however,canonlybecontainedin

either the form or the report.

DrilldownreportinginProfitCenterAccountingprovideseasy-to-usefunctions

fornavigatingthroughthedataset. Forexample,youcanmovefromonesegment

tothenext levelorthenextsegment atthesamelevel, 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 definingthereportlayout forprinting(page

breaks, headersandfooters, underscores, andmore).

201

第 218 页 / 共 243 页

Unit5: InformationSystem AC612

Figure 88: Different Types of Forms

There are three types of forms:

• One axis without key figure.

– Inaformwithoneaxisandwithoutthekeyfigure,youdefineeither

therowsorthecolumnsusingcharacteristics. WhenyoupressBasic

list,thesystemdisplaysablanklistwithcolumns.

• One axis with key figure.

– Inaformwithoneaxisandwiththekeyfigure,youdefineeitherthe

rowsorthecolumnsusingcharacteristicsandkeyfigures. Whenyou

chooseBasiclist,thesystemdisplaysablanklistwithrows.

• Two axes with key figure.

– Inaformwithtwoaxesandwiththekeyfigure, youdefineboththe

rows and the columns using characteristics and key figures. When

youpressBasiclist, thesystem displaysablanklist with both rows

andcolumns. Youcandecidewhetherthekeyfiguresshouldappear

in the rows or the columns, depending on what you want to report.

Characteristicscanbedisplayedinboththerowsandthecolumns.

Tocreateaform,enteranameandtherequiredtypeofform.

202

第 219 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Figure 89: Drill-Down Reporting

Theabovediagramshowsagraphicaldrilldownreportwiththefollowingoutput

areas: Info, Navigation, Drilldown, and Detail.

Another output area is the Business Graphics, which isnot shown here. You

can usetheHTMLtemplatesprovided by SAPfor theInfooutputarea, oryou

can define your own HTML templates.

203

第 220 页 / 共 243 页

Unit5: InformationSystem AC612

204

第 221 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Exercise 12: Reporting with Drilldown

Reporting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Define form reports

Business Example

You need a management report based on profit centers to calculate

performance-basedbonuspayments. Youcreate areport thatdisplaystheplan

and actual data.

Task 1:

Bonuspaymentsfortheprofitcentermanageraredependentontwocontribution

marginlevels. Thefirstcontributionmarginleveliscalculatedassalesminusthe

costsofgoodsmanufacturedfor thosesales(COSG=costofgoodssold). For

thesecondcontributionmarginlevel,youalsodeducttheallocatedadministration

costs.

You define a form that maps these two contribution margins and allows a

plan/actual comparison. Youseean overviewfirst.

LeadColumn ACT. PLAN VAR ABS

SalesVolumes

COGS

Contribution

Margin 1

Administration

costs

Contribution

Margin 2

1. Define form AC612## with the name Contribution Margin in the

ImplementationGuide. Todoso,useformtypeFAGLFLEXS(reporting

fortableFAGLFLEXT).UseTwoCoordinates(Matrix)asthestructure.

2. Define the first row of the form.

Double-clickRow1andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Continued on next page

205

LeadColumn	ACT.	PLAN	VAR ABS
SalesVolumes
COGS
Contribution Margin 1
Administration costs
Contribution Margin 2

第 222 页 / 共 243 页

Unit5: InformationSystem AC612

Chart of Accounts INT

Account Number 800000

Enter Sales as the short, medium, and long texts and confirm the row

definition.

3. Next, define the second row of the form.

Double-clickRow2andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Chart of Accounts INT

Account Number 893015

Enter COGS as the short, medium, and long texts and confirm the row

definition.

4. Next, define the third row of the form.

Double-clickRow3andchooseFormula. Youwanttheformulatobalance

saleswiththecostofgoodssold. Notethat salesarepostedwithaminus

EnterContribution Margin 1astheshort,medium,andlongtexts

and confirm the row definition.

5. Next, define the fourth row of the form.

Double-clickRow4andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Chart of Accounts INT

Account Number 4990##

EnterAdministrationastheshort,medium,andlongtextsandconfirm

the row definition.

6. Next, define the fifth row of the form.

Double-clickRow4andchooseFormula. Youwanttheformulatobalance

contributionmargin1andtheadministrationcosts.

EnterContribution Margin 2astheshort,medium,andlongtexts

and confirm the row definition.

7. Next, define thefirst column of theform.

Double-clickColumn1andchooseKeyFigurewithCharacteristics. Press

F4andselecttheUMPER(PeriodBalance)keyfigure.

Continued on next page

206

Chart of Accounts	INT
Account Number	800000

Chart of Accounts	INT
Account Number	893015

Chart of Accounts	INT
Account Number	4990##

第 223 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

TodisplaythiscolumnintheActualDatacolumn,selectLedgerandRecord

Typefromthelistofavailablecharacteristicsandenterthefollowingdata:

Ledger 0L

Record Type 0 and 2

EnterACTUALastheshort,medium,andlongtextsandconfirmthecolumn

definition.

8. Next, definethesecond column of the form.

Double-clickColumn2andchooseKeyFigurewithCharacteristics. Press

F4andselecttheUMPER(PeriodBalance)keyfigure.

To display this column in the Plan Data column, select Ledger, Record

Type, and Version from the list of available characteristics and enter the

following data:

Ledger 0L

Record Type 1 and 3

Version Global Variable 1PV

EnterPLANastheshort, medium, andlongtextsandconfirmthecolumn

definition.

9. Next, define thethird column of the form.

Double-click Column 3 and choose Formula. You want this formula to

balance the plan and actual data.

Enter VAR SLS as the short, medium, and long texts and confirm the

column definition.

10. Deletethefourth column andsavetheform.

Task 2:

Youwanttodefineadrilldownreportthatisbasedonthedatafromtheform.

1. Definea drilldown reportcalledAC612##(Profit Center Contribution

Margin)thatisbasedonformAC612##,whichyoudefinedintheprevious

step. ThereporttypeisReportingforTableFAGLFLEXT.

2. Define the report characteristics.

Currency and Currency Type are already selected on the Characteristics

tab. Enter currency type 10 as a fixed value. Add the Profit Center and

ControllingAreacharacteristicstothelistofselectedcharacteristics.

Continued on next page

207

Ledger	0L
Record Type	0 and 2

Ledger	0L
Record Type	1 and 3
Version	Global Variable 1PV

第 224 页 / 共 243 页

Unit5: InformationSystem AC612

Entercontrollingarea1000asafixedvalue. Definetheprofitcenter asa

local variable called PRCTR.

3. Define the variable instance.

The Variables tab already has thePlan Version preselected. Adrilldown

reportalreadyknowsallthevariablesthatoriginateintheform. Enter0as

thedefaultvalue. Enter612##asthedefaultvaluefortheProfitCenterfield.

Theuseristobeabletochangeboththesedefaultvalueswhencallingthe

report.

4. Specify the output type.

Youwanttosettheoutputtypetoclassicdrilldownreportstartingwiththe

detaillist. Usersaretobeabletoselecttheoutputtypesthemselves.

5. Maintain the report-report interface.

You want to enablethefollowingnavigation:

Segment: Plan/Actual/Variance(reporttype: drilldownreport)

G/L Account Line Item List (report type: ABAP report,

FAGL_ACCOUNT_ITEMS_GL)

Task 3:

Call up the report you just created.

1. UsetransactioncodeFGI0tocallupthereport. Enterthefollowingdataon

the selection screen:

Fiscal Year Current fiscal year

From Period 1

To Period 12

Company Code 1000

Theprofitcenter, planversion, and output type (classicdrilldown report)

havedefault settingsfromthereportdefinition.

Analyzethedataandcheckthereport-reportinterface.

208

Segment: Plan/Actual/Variance(reporttype: drilldownreport)
G/L Account Line Item List (report type: ABAP report, FAGL_ACCOUNT_ITEMS_GL)

Fiscal Year	Current fiscal year
From Period	1
To Period	12
Company Code	1000

第 225 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Solution 12: Reporting with Drilldown

Reporting

Task 1:

Bonuspaymentsfortheprofitcentermanageraredependentontwocontribution

marginlevels. Thefirstcontributionmarginleveliscalculatedassalesminusthe

costsofgoodsmanufacturedfor thosesales(COSG=costofgoodssold). For

thesecondcontributionmarginlevel,youalsodeducttheallocatedadministration

costs.

You define a form that maps these two contribution margins and allows a

plan/actual comparison. Youseean overviewfirst.

LeadColumn ACT. PLAN VAR ABS

SalesVolumes

COGS

Contribution

Margin 1

Administration

costs

Contribution

Margin 2

1. Define form AC612## with the name Contribution Margin in the

ImplementationGuide. Todoso,useformtypeFAGLFLEXS(reporting

fortableFAGLFLEXT).UseTwoCoordinates(Matrix)asthestructure.

a) Implementation Guide: Financial Accounting (New) → General

LedgerAccounting(New)→InformationSystem→DrilldownReports

(G/LAccounts)→Form→SpecifyForm. ThenchooseCreateForm.

2. Define the first row of the form.

Double-clickRow1andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Chart of Accounts INT

Account Number 800000

Continued on next page

209

LeadColumn	ACT.	PLAN	VAR ABS
SalesVolumes
COGS
Contribution Margin 1
Administration costs
Contribution Margin 2

Chart of Accounts	INT
Account Number	800000

第 226 页 / 共 243 页

Unit5: InformationSystem AC612

Enter Sales as the short, medium, and long texts and confirm the row

definition.

a) Select the first row. Choose the icon to add an available

characteristic to the form.

To edit the texts, choose the icon.

3. Next, define the second row of the form.

Double-clickRow2andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Chart of Accounts INT

Account Number 893015

Enter COGS as the short, medium, and long texts and confirm the row

definition.

a) Double-clickthesecondrow. Choosethe icontoaddanavailable

characteristic to the form.

To edit the texts, choose the icon.

4. Next, define the third row of the form.

Double-clickRow3andchooseFormula. Youwanttheformulatobalance

saleswiththecostofgoodssold. Notethat salesarepostedwithaminus

EnterContribution Margin 1astheshort,medium,andlongtexts

and confirm the row definition.

a) Double-clickthethirdrow. Youcanincludeanyrowsandcolumnsthat

youhavealreadydefinedintheformulaeditor. TheformulaisSales+

COGS(Y001+Y002). Theadditionisneededduetotheminussign.

When you confirm the formula, you can enter short, medium, and

long texts.

5. Next, define the fourth row of the form.

Double-clickRow4andchooseCharacteristicsOverview. ChooseAccount

Numberfromthelistofavailablecharacteristicsandenterthefollowingdata:

Chart of Accounts INT

Account Number 4990##

Continued on next page

210

Chart of Accounts	INT
Account Number	893015

Chart of Accounts	INT
Account Number	4990##

第 227 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

EnterAdministrationastheshort,medium,andlongtextsandconfirm

the row definition.

a) Double-clickthefourthrow. Choosethe icontoaddanavailable

characteristic to the form.

To edit the texts, choose the icon.

6. Next, define the fifth row of the form.

Double-clickRow4andchooseFormula. Youwanttheformulatobalance

contributionmargin1andtheadministrationcosts.

EnterContribution Margin 2astheshort,medium,andlongtexts

and confirm the row definition.

a) Double-click the fifth row. You can include any rows and columns

that you havealready defined in theformula editor. The formulais

Contribution Margin 1 + Administration (Y003 + Y004). The

addition isneededdueto the minussign.

When you confirm the formula, you can enter short, medium, and

long texts.

7. Next, define the first column of the form.

Double-clickColumn1andchooseKeyFigurewithCharacteristics. Press

F4andselecttheUMPER(PeriodBalance)keyfigure.

TodisplaythiscolumnintheActualDatacolumn,selectLedgerandRecord

Typefromthelistofavailablecharacteristicsandenterthefollowingdata:

Ledger 0L

Record Type 0 and 2

EnterACTUALastheshort,medium,andlongtextsandconfirmthecolumn

definition.

a) Double-clickthefirstcolumn. Choosethe icontoaddanavailable

characteristic to the form.

Tousemultipleselectionforacharacteristic,choosethe icon.

To edit the texts, choose the icon.

8. Next, definethesecond column of the form.

Double-clickColumn2andchooseKeyFigurewithCharacteristics. Press

F4andselecttheUMPER(PeriodBalance)keyfigure.

Continued on next page

211

Ledger	0L
Record Type	0 and 2

第 228 页 / 共 243 页

Unit5: InformationSystem AC612

To display this column in the Plan Data column, select Ledger, Record

Type, and Version from the list of available characteristics and enter the

following data:

Ledger 0L

Record Type 1 and 3

Version Global Variable 1PV

EnterPLANastheshort, medium, andlongtextsandconfirmthecolumn

definition.

a) Double-click the second column. Choose the icon to add an

available characteristic to the form.

Tousemultipleselectionforacharacteristic,choosethe icon.

Touseavariableforthecharacteristic,setthecheckmarkinthecolumn

with the icon.

To edit the texts, choose the icon.

9. Next, define the third column of the form.

Double-click Column 3 and choose Formula. You want this formula to

balance the plan and actual data.

Enter VAR SLS as the short, medium, and long texts and confirm the

column definition.

a) Double-clickthethirdcolumn. Youcanincludeanyrowsandcolumns

that you havealready defined in the formula editor. The formulais

PLAN - ACTUAL (X002 - X001).

When you confirm the formula, you can enter short, medium, and

long texts.

10. Deletethefourthcolumnandsavetheform.

a) Select the columnheader of the fourth column and then choose the

icon.

Continued on next page

212

Ledger	0L
Record Type	1 and 3
Version	Global Variable 1PV

第 229 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Task 2:

Youwanttodefineadrilldownreportthatisbasedonthedatafromtheform.

1. Definea drilldown reportcalledAC612##(Profit Center Contribution

Margin)thatisbasedonformAC612##,whichyoudefinedintheprevious

step. ThereporttypeisReportingforTableFAGLFLEXT.

a) Implementation Guide: Financial Accounting (New) → General

LedgerAccounting(New)→InformationSystem→DrilldownReports

(G/L Accounts)→Report→DefineReport

Now choose Create Report.

2. Define the report characteristics.

Currency and Currency Type are already selected on the Characteristics

tab. Enter currency type 10 as a fixed value. Add the Profit Center and

ControllingAreacharacteristicstothelistofselectedcharacteristics.

Entercontrollingarea1000asafixed value. Definetheprofitcenter asa

local variable called PRCTR.

a) Choosethe icontoadoptthecharacteristics.

To define a variable for the characteristic, set the checkmark in the

columnwiththe icon. Inthiscase,youwanttousealocalvariable

insteadofoneofpredefinedglobalvariables, soenterPRCTRinthe

Local Variable field.

3. Define the variable instance.

The Variablestab already hasthe Plan Version preselected. Adrilldown

reportalreadyknowsallthevariablesthatoriginateintheform. Enter0as

thedefaultvalue. Enter612##asthedefaultvaluefortheProfitCenterfield.

Theuseristobeabletochangeboththesedefaultvalueswhencallingthe

report.

a) Enter the values as described.

4. Specify the output type.

Youwanttosettheoutputtypetoclassicdrilldownreportstartingwiththe

detaillist. Usersaretobeabletoselecttheoutputtypesthemselves.

a) GototheOutputTypetab. SelecttheClassicDrilldownReport,Basic

List: Detail,andSelectableonSelectionScreenfields.

5. Maintain the report-report interface.

Youwant toenable the following navigation:

Continued on next page

213

第 230 页 / 共 243 页

Unit5: InformationSystem AC612

Segment: Plan/Actual/Variance(reporttype: drilldownreport)

G/L Account Line Item List (report type: ABAP report,

FAGL_ACCOUNT_ITEMS_GL)

a) GototheOptionstab. ChoosetheReportassignmenticon.

Click toinsert anew receiver report.

Youcanenterdrilldownreportsdirectly. Toincludeotherreporttypes,

choose the Other Report Type icon.

Task 3:

Call up the report you just created.

1. UsetransactioncodeFGI0tocallupthereport. Enterthefollowingdataon

the selection screen:

Fiscal Year Current fiscal year

From Period 1

To Period 12

Company Code 1000

Theprofitcenter, planversion, and output type (classicdrilldown report)

havedefault settingsfromthereportdefinition.

Analyzethedataandcheckthereport-reportinterface.

a) Analyze any data you wish.

214

Segment: Plan/Actual/Variance(reporttype: drilldownreport)
G/L Account Line Item List (report type: ABAP report, FAGL_ACCOUNT_ITEMS_GL)

Fiscal Year	Current fiscal year
From Period	1
To Period	12
Company Code	1000

第 231 页 / 共 243 页

AC612 Lesson: Reporting with Drilldown Reporting

Lesson Summary

You should now be able to:

• Defineyour own form-baseddrilldown reports

215

第 232 页 / 共 243 页

UnitSummary AC612

Unit Summary

You should now be able to:

• Use a drilldown report

• Define a drilldown report yourself

• Defineyour ownform-baseddrilldown reports

216

第 233 页 / 共 243 页

AC612 Test Your Knowledge

Test Your Knowledge

1. The new general ledger only has account-based and profit center-based

standard reports.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. ProfitCenterAccountinghasreportsthatwerecreatedwithReportPainter/

ReportWriter,aswellasform-baseddrilldownreports.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

217