AC280_EN_Col92_FV_Part_A4 (第4页) | ERP软件技术分享

第 145 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Lesson: Form and Report Definition

Lesson Overview

Inthislesson, youwilllearntousesingle-axisanddual-axisforms(matrix)for

drilldown reporting in FI.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Define forms

• Define and execute reports

• Defineformsandreportsmoreflexiblyusingcharacteristicandtextvariables

Business Example

EmployeesinFinancialAccountingwanttodefineformsandreportsfordrilldown

reporting in FI.

Figure73: FormDefinition: ExampleofFinancialStatementAnalysis

SAP delivers standard forms, which you can use as templates to create your

ownforms. The namesfor thesestandardformsare0SAPBLNCE-01through

0SAPBLNCE-NN,andyoucannotusethesenamesforyourownforms.

Definingcharacteristicsforallcolumns(generalselections)

First,definethecharacteristicsthatapplytoallthecolumnsinyourform. Since

youwanttoenteractualdatainallthecolumnsofyourform,youcandefinethis

generalcharacteristicbychoosingEdit→Generalselections.

131

第 146 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Adialogboxappearsforyoutoselectthecharacteristicsforthegeneralselections.

In the dialog box, add the characteristic Record type to the table of selected

characteristicsanddefinethevalue0for actualdata.

Figure74: FormDefinition(2): ExampleofFinancialStatementAnalysis

Once you have defined the general characteristics, you can then define the

characteristics of the individual columns.

Adialogboxappears,inwhichyoucanselectKeyfigurewithcharacteristics. A

seconddialogboxappears. ChooseBalancesheetvalue(BILWERT)fromthelist

of available key figures. In this case, the key figure reflects the values of the

balancesheetthat youwanttoevaluateforyourreport.

Tocarryout anactual/actualyearcomparison, youalsorequiretheFiscal year

characteristic.

Thendefinethecharacteristicvaluesforthecharacteristicsthatyouhaveselected.

Forexample,forthefiscalyear,youcanentereitherfixedvaluesorvariables. If

youwanttoenterfixedvalues,specifythespecificvalue(forexample,2001).

Figure79showstheentryfortwocolumns,inwhichyouselectedthefixedvalues

2001 and 2000 for the Balance sheet value.

Youcanenterthreedifferentlengthsoftext. Thesearethenusedasthecolumn

headingsfortheelements. Youcanenterashort,medium,orlongtext. Usingthe

texttype,youcanlaterdeterminewhichtextisusedforeachcolumn. Ifyouwant

toenteratwo-lineheading,notethatwhenyouenteralongtextyouseparatethe

twolinesusingasemicolon(;). YoucanchangethetexttypebychoosingFormat

→ All columns → Text type.

132

第 147 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure75: FormDefinition(3): ExampleofFinancialStatementAnalysis

In the third column, you define the variance between the first and the second

column.

Todothis,placethecursoronthethirdcolumnandchooseEdit→Element→

Define element.

Onthefollowingscreen,chooseFormula. Theformulaeditorappears,inwhich

you define the formula that is to be used to calculate the variance. Using the

formulaeditor, you canperformstandardarithmeticoperations(+, -, *, /)with

any elements.

UnderID,double-clickthefirstvalue,selecttheminussign,andthendouble-click

the second value under ID.

Onthefollowingscreen,maintainthetexttypesfortheVariancecolumn.

Save the form.

133

第 148 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Figure76: ReportDefinition: ExampleofFinancialStatementAnalysis

Enterthenameofanewreportorchoosethenameofthereportwhosedefinition

youwanttochange. Youhavetochooseanappropriateformforthereporttype

(financialstatementanalysis,financialstatementkeyfigures,orbalancedisplay).

You can choosea reference report if necessary.

On the Characteristics tab page, the system displays a list containing all the

availablecharacteristics. Inthecharacteristiclist, selectthecharacteristicsthat

youwant touse for your evaluation in the report, and usethearrow buttons to

addthemtothereport. Thesecharacteristicsarethedrilldowncharacteristics

that you use to navigate in the report.

Using the Sort characteristics function, you can determine the order of the

characteristicsinthenavigationblockofthereportlist for theexecutedreport.

Theorderofthecharacteristicsdeterminesthelayoutofthestandarddrilldown.

Thecharacteristicsthatyoudefinedforacharacteristicvaluewhenyoudefined

the report are above the navigation block and you cannot re-sort them. To

improveperformance,youshouldnotselectcharacteristicsthatyoudonotneed

in the drilldown report. Even if you are printing, you should only retain the

characteristicsthatyouactuallyrequire,otherwisethesystemoutputssuperfluous

subtotals. Thenumberofcharacteristicsofferedforselectionisresrictedbythe

selectioncriteriadefinedintheform. Ifyouhavealreadyspecifiedacharacteristic

in theform, it isnolonger offered for selection.

134

第 149 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure77: ReportDefinition(2): ExampleofFinancialStatementAnalysis

Onceyouhaveselectedacharacteristic, allthevaluesforthischaracteristicare

includedinthereport. Therearevariouswaysofrestrictingthevaluequantityofa

characteristic for output in the report.

OntheCharacteristicstabpage,youcanrestrictthecharacteristicvaluesforeach

drilldowncharacteristicchosen. Therearevariousoptionsdependentonthereport

definition and the characteristic selected.

1. Youdonotmakeanentry. Ifyoudonotmakeanyoftherestrictionsdescribed

below, the system selectsall thecharacteristic valueswhen you run thereport.

For example, the system displays all business areas for the Business area

characteristic. Inallothercases,thesystemreadsonlythecharacteristicvaluethat

youentered,forexample,onlyAssetsunderconstructionfortheBusinessarea.

SAPrecommendsthatyouchoosecharacteristicscarefullytolimitthequantityof

dataselected. Thisimprovessystemresponsetimes.

1. Youdefineacharacteristicvalueforacharacteristic. If,forexample,youare

onlyinterestedinthevalue1100fortheCompanycode,youcanrestrictthereport

accordingly. Thecharacteristicandthecharacteristicvaluethenappearabovethe

navigationblockonthereportlistandhavebeendefined(thatis,youcannotuse

the characteristicasa drilldown characteristic).

1. Youuseavariableforcharacteristicvalues(seefigure83).

135

第 150 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Figure 78: Variables: Overview

Therearetwotypesofvariables: globalvariablesandlocalvariables.

Ifyouuseavariableonlyinaspecialformorreport,youcreatealocalvariable.

This is then only recognized within the form or report. If you define a local

variableinaform,thisvariableappliesineachreportthatusestheform. Alocal

variablethatyoudefineinthereportitselfonlyappliestothisreport.

Ifyouusecertainvariablesfrequently, you candefinethemglobally. Youcan

thenusethesevariablesinallformsandreports. Youmaintainglobalvariablesin

Customizing. Ifyouthenwanttouseglobalvariablesforcharacteristicsinaform

orreport, thesystemprovidesthemaspossibleentries.

Hint: Ifyouchangeaglobalvariable,allreportsandformsthatusethis

variable are affected.

SAP deliversvariablesthat start with a number.

Ifyouusecertainvariablesfrequently,youshoulddefinethemgloballyinsteadof

inareportorform. Youcanthenusethesevariablesinallformsandreports. This

isparticularlyusefulforcharacteristicsthatfrequentlyformpartofgeneralreport

selections(forexample, period, fiscalyear, andsoon).

136

第 151 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure 79: Variables for Form Definition

Certainvariablesforcharacteristicvaluesaredelivered,forexample1FY(fiscal

year).

Variablesareuniquelyidentifiedbytheirnameandtheiruse(text/characteristic,

and so on) and variables for characteristic values are identified by the field to

which they refer.

One of the things that you have to specify when you define variables is a

replacementtype. Thereplacementtypespecifieshowavariableisreplacedbya

value. Youcanreplaceavariablewithavalueeitherautomaticallyormanually.

Figure 80: Variables Example: Fiscal Year Column

137

第 152 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Youcanenterthenameofthevariableinthedialogboxthatisdisplayedwhen

you select the Variable checkbox.

Letussay,forexample,youwanttocreateaforminwhichtheyearisenteredin

thefirstcolumnusingavariable. Thesecondcolumnshoulddisplaytheprevious

year.

Inthefirstcolumn,choosethecharacteristicfiscalyearandassignthevariable

1FYasavalue. Youpreviouslydefined1FYasaglobalvariablewithobligatory

entry.

Figure 81: Variables Example: Previous Year

Youcanlinkvariablesforcharacteristicvaluesthatrefertoanumericinputfield

(forexample,1FYforcurrentfiscalyear2001)sequentiallywithconstants(for

example: 1FY-1forthepreviousyear2000). Thisfunctionissupportedforglobal

and local variables for characteristic values.

Youwanttocreateaforminwhichtheyearisenteredinthefirstcolumnusinga

variable. Youwanttodisplaythepreviousyearinthesecondcolumn.

Inthefirstcolumn,choosethecharacteristicfiscalyearandassignthevariable

1FYasavalue. Youpreviouslydefined1FYasaglobalvariablewithobligatory

entry. This display is shown in figure 86.

In the second column (as shown in figure 85), also selectfiscal year and then

specifythevariablename1FY.Enteraminussign(-)intheOperatorfield,and1

intheOffsetfield. WhenyouusetheCreatereportorExecutereportfunctions,the

systemrequestsonlythefiscalyearforvariable1FY;itautomaticallydetermines

the previous year.

138

第 153 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure 82: Variables: Texts

Youcanenterashort,medium,orlongtextforthecolumnheadings. Usingthe

texttype,youcanlaterdeterminewhichtextisusedforeachcolumn. Ifyouwant

toenteratwo-lineheading,youmustseparatethetwolinesusingasemicolon(;).

If you want texts inthe rowsor columns to bedefined by variablesand not to

be fixed, you have to use a text variable. Text variables are used only in form

reports(intheformitself). TheyarereplacedwhenyouchoosetheExecutereport

function. YouhavetomaintainglobalvariablesinCustomizingbeforeyoucan

entertheminthetextfieldoftheform. Forlocalvariables,youhavetoenterthe

dollar sign ($) and an appropriate name.

Fortextvariables, thereplacementtypedeterminestheadditionalentries. You

usually define an automatic replacement path and thetext is taken from the

master data. Notethattextvariablescanonlybeautomaticallyreplacedifthey

refertocharacteristicsandyouchosethecorrespondingcharacteristicwhenyou

definedtheelement. Forexample,youdefinethefollowingforalocalvariable

$FYT(textforfiscalyear): AutomaticreplacementusingthevalueintheFrom

fieldofthecharacteristicFiscalyear(fromcharacter1,length4). Youspecifythe

textlengthwhenyoudefinethevariables. Themaximumlengthofthenameofa

localvariableiseightcharacters. Forreplacementwithentry,thetextlengthis

identical to the length of the variable name.

139

第 154 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Figure 83: Layout Options in Forms

Youcanuseseveralfunctionstodefinethelayoutofaform:

• Colorsetting: Youcanusethisfunctiontodisplayaselectedelementina

different color.

• Numberformat: Youusethisfunctiontodefinethescalingandthenumber

ofdecimalplaces. Notethatthedefinitionthatyoumakeherealwaysrefers

to specific rows or columns. Once you have executed a report, you can

refinethisdefinition(thatis,youcanmakeothersettingsforspecificrows

or columns).

• Texttype: Thisdefineswhichtext(short,medium,orlong)isdisplayedin

the rows or columns.

• Columnwidth: Youusethisfunctiontochangethecolumnwidth. First,

selectthecolumn(s)thatyouwanttoeditandthenchangethecolumnwidth.

• Youcanalsoaddseparators,emptylines,andtextsforemphasis.

140

第 155 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure 84: Layout Options in Forms (2)

Additional settings are listed below:

• Zerosuppression: Ifyouusethisfunction,cellswiththevaluezeroremain

emptyinthereport. Intheform,thisformattingisshownby“xxx.xxx.xxx.”

• Indentation: Youcanusethisfunctiontoindentthetextofindividualrows,

for example, to reflect a graphic sorting.

• Hidecolumnsorrows: Thisfunctionhidestherow/columnonwhichyou

place thecursor. The content of the row/column that you have hidden is

retainedandyoucanstilluseitinformulas. Youcanedittherowsthatyou

havehiddenbychoosingHiddenrows→Change. Youcanalsodeleteor

display these rows/columns.

• Reverse the +/- sign: This function reverses the +/- signs in the report.

Negativevaluesaredisplayedpositivelyandpositivevaluesaredisplayed

withaminussign. Intheform,thisisshownbytheminussign(-).

141

第 156 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Figure 85: Cell Calculation in Forms

Youcandefinepercentagesoftotalsforrowsandcolumnsintheform. Youdo

this using thePercentage of total function when you definetheformula in the

formula editor.

Thecontentofacellisusuallydeterminedbytherowandcolumnforwhichitis

thepointofintersection. Ifthisisnotsufficienttodeterminethecontent,youalso

havetodefinethecell. Todothis,placethecursoronacellandchooseEdit→

Element →Defineelement, or double-clickthecell.

Ifyouarenotactuallyeditingthecell,butitistobeincludedinformulas,choose

Selected. Ifyouthengototheformuladefinitionintheformulaeditor,thesystem

provides the selected cells for selection.

ChooseInactiveifyouwanttodeactivateacellincaseswherethevalueisofno

use. Thecellisthenempty,andappearsas0(zero)intheform.

142

第 157 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Figure 86: Cell Calculation in Forms (2)

Celltype: Formula: TheFormulacelltypeisprovidedwhenyouhavedefined

atleastonecellthatcanbeincludedintheformula. Ifyouselectthiscelltype,

theformulaeditorappearsautomatically. Intheformulaeditor,youcandefinea

formulabasedonexistingcells. Youuseaspecialcelltexttodescribethecell.

Notethatthisspecialcelldoesnothavetocontainthevaluethatwouldresultfrom

the intersection of the row andcolumnselection.

Exampleofcellprocessing: Changingfixedassetsoverseveralyears.

Theresultoffixedassetsisretainedasacellforeachfiscalyear.

For the Change to fixed assets row, the relevant cells are linked to each other

mathematicallyasaformulaateachrow/columnintersectionpoint. Forexample,

Z002-Z003(infigure91)correspondstothesubtractionofthefixedassetsvalue

for 1999 from the fixed assets valuefor 2000.

143

第 158 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Figure 87: Cell Calculation in Forms (3)

Additionalexampleofcellprocessing: Increaseordecreaseinfixedassets.

Formulasforincrease: MX0(Z001-Z002);MX0(Z002-Z003);MX0(Z003-Z004)

→ Maximum of operand and zero

Formulas for decrease: : MN0 (Z001-Z002); MN0 (Z002-Z003); MN0

(Z003-Z004) →Minimum of operandand zero

144

第 159 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Exercise 8: Drilldown Reporting in

Financial Accounting

Exercise Objectives

After completingthisexercise, youwillbeableto:

• DefineandexecutedifferenttypesofformsandreportsinFI-GL

• Explainandusenavigationoptionswhenyouaredisplayingareport

• Defineformsandreportsmoreflexiblyusingcharacteristicandtextvariables

• Try variouslayoutsettingsfor thereport output

• Explainthedifferenttypesofcellsandusecellsinformulas

• Usedifferentoutputtypesforreportsandtestthefunctionsduringoutput

Business Example

EmployeesinFinancialAccounting want tolearnabouttheevaluationoptions

providedbydrilldownreportingandusethevariousnavigationoptions.

Task 1:

1. CreateaformG##-BALPL-01(##=yourgroupnumber)fortheReporting

for Table FAGLFLEXT form type. Enter G## Act/act year as the

description. ChooseOneaxiswithkeyfigureasthestructure

User menu → AC280 Drilldown Activities →Drilldown Reporting:

Maintain Forms → Create Form

Inthegeneralselections,addtheRecordtype0foractualandLedger0L.

Edit→Generaldataselection→Generaldataselection

Choosethecolumndisplayforyourentriesintheform.

Goto → Column display

Define 3 columns:

Column 1:

KeyfigureBILWERT(BalanceSheetvalue)withthecharacteristicFiscal

year. EnterthecurrentfiscalyearforthecharacteristicFiscalyear(fixed

value). EnterFYXXXX(XXXX=currentyear)asashort, medium,and

long text.

Column 2:

Continued on next page

145

第 160 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

KeyfigureBILWERT(BalanceSheetvalue)withthecharacteristicFiscal

year. EnterthepreviousfiscalyearforthecharacteristicFiscalyear(fixed

value). EnterFYXXXX(XXXX=previousyear)asashort,medium,and

long text.

Column 3:

Variancebetween thecurrent fiscalyearand thepreviousfiscal year

(usingformula). EnterVarianceastheshort,medium,andlongtext.

Check your form

Save your form.

Task 2:

1. Forthisform,createthereportG##-BALPL-01(##=groupnumber)for

thereporttypeReportingforTableFAGLFLEXTwiththedescriptionG##

Act/act year.

Environment→Report→Create(orReportbutton)

From the drilldown characteristics, choose financial statement item,

companycode, profitcenter,andaccountnumber. Youshouldbeable

to enter thehierarchy selection (financial statement version)using the

characteristicFinancialstatementitemwhenyourunthereport. Enterthe

fixedvalue1000forthecharacteristicCompanycode.

Changetheorderoftheuser-definedcharacteristics.

Sort user-definedcharacteristicsbutton, after

Currency(1),Currencytype(2)andCompanyCode(3)sortby:

FS Item (4),

Account number (5), and

Profit center (6).

OntheOutputtypetabpage,chooseClassicdrilldown(Basiclist: D-down)

and Available on selection screen.

Save your report.

Task 3:

1. Execute the report:

Exit the screen for maintaining the report.

Continued on next page

146

第 161 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Start the report from your user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

PlacethecursoronreportG##-BALPL-01andchoose

Drilldownreport→Execute(ordouble-clickyourreport)G##-BALPL-01.

Currency type: 10

The FIS Annual Rep.Structure: INT:

Output type: Classic drilldown report

Execute

Navigate within the report until you find the account number for office

supplies. MakeanoteofthefinancialstatementvaluefortheProfitcenter

Motorcycles(1000)for the currentfiscalyear.

_______________________________________________________________

Task 4:

1. Create a form G##-BALPL-02 (## = your group number) for the form

typeReportingforTableFAGLFLEXT.EnterG##Act/actyearvar. asthe

description. ChooseOneaxiswithkeyfigureCreateasthestructure.

Usermenu→AC280DrilldownActivities→DrilldownReporting: Maintain

Forms → Create Form

Inthegeneralselections,addtheRecordtype0foractualandLedger0L.

Edit→Generaldataselection→Generaldataselection

Choosethecolumndisplayforyourentriesintheform.

Goto → Column display

Theformshouldhavethesamestructureasyourfirstform.

Column 1:

KeyfigureBILWERT(balancesheetvalue)withthecharacteristicFiscal

year. Entertheglobalvariable1FYforthecharacteristicFiscalyear.

Enter the text:

Short: FY&1FY and click Copy short text.

Column 2:

Continued on next page

147

第 162 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

KeyfigureBILWERT(BalanceSheetvalue)withthecharacteristicFiscal

year. For the fiscal year, enter the global variables 1FY and in the As

operatorfield,enterahyphen(–)andOffset1. Enterthetext:

Short: FY &1FY andchooseCopyshort text.

Column 3:

Variancebetween thecurrent fiscalyearand thepreviousfiscal year

(usingformula). EnterVarianceastheshort,medium,andlongtext.

Check your form.

Save your form.

Task 5:

1. Create report G##-BALPL-02:

On the maintenance screen for the form:

Environment→Report→Create(orReportbutton)

Fortheformyouhavejustcreated,createthereportG##-BALPL-02(##=

groupnumber)forthereporttypeReportingforTableFAGLFLEXTwith

the description G## Act year var.

SelectthedrilldowncharacteristicsFSItem,Companycode,ProfitCenter

and Account number.

EnterINTfor the financial statement version.

(Double-clickthecharacteristicFinancialstatementitem).

Change the order of the user-defined characteristics by choosing Sort

user-defined characteristics.

After Currency (1) and Currencytype (2)

Sort by FS Item (3)

Company code (4)

Account number (5), and

Profit center (6).

Choose Classic drilldown (Basiclist: drilldown)astheoutput type and

Available on selection screen.

Enter the Current fiscal year as the default value for the fiscal year.

(Variables tab page)

Save your report.

Continued on next page

148

第 163 页 / 共 319 页

AC280 Lesson: Form and Report Definition

2. Execute the report:

Exit the maintenance screen for the report.

Start the report from your user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

Double-click report G##-BALPL-02.

Acceptthecurrentfiscalyear. Youwanttodisplaythefinancialstatement

valuesforcurrencytype10andcompanycode1000.

Execute

Whenyoudisplaythereport,navigateusingthecharacteristicsProfitcenter,

Account number, andFinancial statement item.

3. Executethisreportagain. Ontheselectionscreen,enterthepreviousyearas

the fiscal year.

Task 6:

Key figures report

1. Create form:

Onceyouhavecompletedtheform,itshouldlookasfollows:

Fiscalyear2009 Fiscalyear2008 Fiscalyear1999

Assets

Fixedassets xx,xxx.xx xx,xxx.xx xx,xxx.xx

Financial xx,xxx.xx xx,xxx.xx xx,xxx.xx

statementstotal

% financial xx.xx xx.xx xx.xx

statementtotal

Example: Thecurrentfiscalyearintheabovereportis2009.

Note:

YouwanttodeterminethevaluesforthecharacteristicFiscalyearandthe

textsinwhichthefiscalyearsaredisplayedusinglocalvariables.

Intheform,definethecharacteristicvariableFYandthetextvariableFY.

Usermenu→DrilldownReporting: MaintainForms→Createform

CreateaformG##-BILKENN1(##=yourgroupnumber)fortheReporting

for Table FAGLFLEXT form type.

Continued on next page

149

Assets	Fiscalyear2009	Fiscalyear2008	Fiscalyear1999
Fixedassets Financial statementstotal	xx,xxx.xx xx,xxx.xx	xx,xxx.xx xx,xxx.xx	xx,xxx.xx xx,xxx.xx
% financial statementtotal	xx.xx	xx.xx	xx.xx

第 164 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

EnterG##Assetproportion asthedescription.

Choose thestructure Two axes (matrix).

Edit→Generaldataselection→Generaldataselection

ThegeneralselectionsshouldcontainthecharacteristicFinancialstatement

versionwiththevalueINT,thecharacteristicRecordType0(actual)and

Ledger 0L.

Columns

Youwanttodeterminethevaluesforthefiscalyearandthetextsinwhich

fiscal years are displayed, using local variables. In the form, define the

characteristicvariableFYandthetextvariableFY.

Create the first column (column 1):

Element type: Keyfigureswithcharacteristics

Keyfigure: BILWERT(Balancesheetvalue)

Characteristic: Fiscal year

Local variable FY

(thisensuresthatyoucansubsequentlyenterthefiscalyearontheselection

screen)

Textforcolumn1: Short,FY1$FY;Medium,FiscYr$FY;Long,Fiscal

year ; $FY

Enter

Confirm

The width of this column should be 19.

Place the cursor on the column and choose:

Formatting → Column → Column width

Enter

Tocopytheformatting,andthecontentofthefirstcolumntothesecond

column,placethecursoronthefirstcolumnandclickontheiconselect.

Placethecursoronthesecondcolumnandclick . Copytheformatting,

andthecontentofthefirstcolumntothethirdcolumnthesameway.

You now have tochangethesecond column:

Edit → Element → Change

Double-click the variable FY

LocalvariableFY withOperator–and Offset1

Continued on next page

150

第 165 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Changeshort, medium, and long textsbutton

Textforcolumn2: Short,FY2$FY;Medium,FiscYr$FY;Long,Fiscal

year ; $FY

Younowhaveto change yourthird column:

Edit → Element → Change

Double-click the variable FY

LocalvariableFYwithOperator–and Offset2

Choose Change short, medium, andlongtexts

Textforcolumn3: Short,FY3$FY;Medium,FiscYr$FY;Long,Fiscal

year ; $FY

YoucannowchangetheTexttypeforall columns:

Formatting →All columns→ Text lengths

Select Two-line long text.

Thevaluesinallcolumnsshouldhave2decimalplaces.

Place the cursor on eachcolumnandchoose:

Formatting→Numberformat(ortheNumberformatbutton)

Choose the format 0.00 fordecimal places.

You now have to define the variables you used; FY as a characteristic

variable and FY as a text variable:

Extras →Variables →Variable definition

EnterFiscalyearasthedescriptionforyourvariableforthecharacteristic

value(thisisthetextthatsubsequentlyappearsontheselectionscreen).

EnterFiscalyeartextasadescriptionforyourtextvariable

Double-clicktextvariableFYandenterthefollowing:

Replace selected field: Automatically

Selected characteristic: RYEAR

Replace selected field: From field

Replaceselectedcharacteristicvalue/textwith: Characteristicvalue

Selected field: Offset 1 Length 4

Thisensuresthat thefiscalyear (e.g., 2001)isactuallydisplayedas2001

in the column heading of your list.

Toincreasethekeycolumnwidth,placethecursoronthekeycolumn.

Continued on next page

151

第 166 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Formatting → Column→ Column width

Enter 30 as the column width.

Rows

1. Configure long text for all rows:

Formatting → All rows → Text lengths

Choose One-line long text as thetext type.

2. Enter the text Assets in the first row.

Edit→Rows→Insertrow;thenEdit→Rows→Inserttext: Assets

3. Separator

Edit → Rows → Insert dividing line

Enterthecharacter--asanunderscorefortheseparator.

Inthefollowingdialogboxcontainingthequery: Shouldtheunderscore

appearonlyin thevaluecolumns?, choose No

4. Financialstatementitems1010000,1020000,and1030000,whichare

tobeinsertedindividuallyasrows. Thetotalforallthreewillthenbecreated

inaformulaandthenthethreeindividualrowshidden.

Placethecursor ontherowbeneaththeseparator.

Edit→Element→Insertelement(ordouble-clickthisrow)

Elementtype: Characteristicoverview(selectionbutton)

FSItemasacharacteristicintheSelectedcharacteristicslist

Enter the FS Items 1010000, 1020000, and 1030000 each individually

one after theother as rows and keep the texts for them as offered. To be

abletoentertheseItemsyouhaveto,eachtime,choosetheHierarchyicon

below“Changehierarchy nodeentry”andthenentertheFS Itemnumber

orusethematchcodebuttontonavigatedownandchoosetheItemnumber

that way. Finally, choose Confirm to bring the Item with its description

into the formula row.

After these three rows, insert a Formula row with the addition of these

three rows.

Texts for the Formula row:

Short: Assets; Medium: Fixedassets;Long: Fixedassets.

YoushouldthenHIDEthe3rowscontainingtheFSItems1010000,1020000

and1030000. To do this place the cursor oneach of these rowsand then

choose Edit → Rows → Hide.

Continued on next page

152

第 167 页 / 共 319 页

AC280 Lesson: Form and Report Definition

5. Financial statement item1000000ASSETSfor theFinancial statement

total row:

Edit→Element→Insertelement(ordouble-clickthisrow)

Elementtype: Characteristicoverview(selectionbutton)

FinancialstatementitemasacharacteristicintheSelectedcharacteristics

list. ChoosetheHierarchyiconbelow"Changehierarchynodeentry"

and then enter the

FS item 1000000

Texts for the element definition:

Short: FSTotal;Medium: FSTotal;Long: FinancialStatementtotal

6. Separator

Edit → Rows → Insert dividing line

Enterthecharacter--asanunderscorefortheseparator.

In the following dialog boxcontaining the query: Shouldthe underscore

appearonlyin the value columns?, chooseNo

Formulaforthe%financialstatementtotalrow(Y001%AY002):

Edit→Element→Insertelement(ordouble-clickthisrow)

Element type: Formula (selection button)

Formula: Y001 %A Y002

Texts: short: %Portion;Medium%financialstatementtotal;Long: %

portion financial statement.

Thisrowshouldbedisplayedinadifferentcolortotheotherrows.

Formatting →Colorsetting: Color fortotals

Check your form.

Save your form.

Task 7:

1. Create report for key figures:

For thisform, createthereportG##-BILKENN1(##=groupnumber) for

reporttypeReportingforTableFAGLFLEXTwiththedescriptionG##Asset

proportion.

Environment→Report→Create(orReportbutton)

Continued on next page

153

第 168 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

ChooseCompanycodeandProfitcenterasdrilldowncharacteristics.

OntheOutputtypetabpage,chooseClassicdrilldownreporting(Basiclist:

Detail) and Available on selection screen.

Save your report.

Task 8:

1. Execute the report:

Exit the maintenance screen for the report.

Exit the maintenance screen for theform.

Start the report from your user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

G##-BILKENN1 drilldown report →Execute

(or double-click report G##-BILKENN1).

On the selection screen enter:

Currency type: 10

YoucankeepthecurrentFiscalYearwhichisoffered. toyou.

Execute

Drill the report down byprofit center values.

Task 9:

1. CreateaformG##-BILKENN2(##=yourgroupnumber)fortheReporting

for Table FAGLFLEXT form type.

Usermenu→Drilldownreporting: Maintainforms→Createform

UseformG##-BILKENN1asatemplate. EnterG##Change: F.Assetsas

the description.

The form should be structured asfollows:

Continued on next page

154

第 169 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Fiscal year Fiscal year Fiscal year Fiscal year

2009 2008 2007 2006

Assets

Fixedassets xx,xxx.xx xx,xxx.xx xx,xxx.xx xx,xxx.xx

Financial xx,xxx.xx xx,xxx.xx xx,xxx.xx

statements

total

% financial xx.xx xx.xx xx.xx

statementtotal

Change to xx.xx xx.xx xx.xx

fixedassets

Example: Thecurrentfiscalyearintheabovereportis2009.

Note:

New column:

Addthefourthcolumnforthefiscalyear-3. Thevalueandthetextofthe

fiscalyearforthefourth columnareto bederivedinthesamewayasthe

other columns in the previous form.

Tocopythisformattingandthecontentofthethirdcolumnforthisfourth

column,placethecursoronthethirdcolumnandclickontheiconSelect

Placethecursoronthefourthcolumnandclick.

Younow havetochange your fourth column:

Local variableFYwithOperator –and Offset 3

Text for column 2: Short: FY4 $FY

Medium: FsclYear $FY

Long: Fiscal year; $FY

Thefourthcolumn(fiscalyear-3)shouldnowonlyshowthefixedassets.

Deactivate the corresponding cells:

(Row: Financial statement total <> Column: FY4 $FY) Define the cell

type as Inactive.

(Row: %financialstatementtotal <>Column: FY4$FY) Definethecell

type as Inactive.

Continued on next page

155

Assets	Fiscal year 2009	Fiscal year 2008	Fiscal year 2007	Fiscal year 2006
Fixedassets Financial statements total	xx,xxx.xx xx,xxx.xx	xx,xxx.xx xx,xxx.xx	xx,xxx.xx xx,xxx.xx	xx,xxx.xx
% financial statementtotal <Emptyrow> <Emptyrow>	xx.xx	xx.xx	xx.xx
Change to fixedassets	xx.xx	xx.xx	xx.xx

第 170 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

New rows:

Afterthe%financialstatementstotalrow,youwanttodisplaytwoempty

rows and then a separator.

The next row should show the change to fixed assets, but only for the

currentyear,thepreviousyear,andtheyearbeforelast.

Procedure

Toenableyoutorecognizethecorrespondingcolumnsinyourcellnames,

youhavetochangethetexttypefor all columns:

Formatting→Allcolumns→TextlengthsTexttype: Shorttext

Selectthecorrespondingcells: FixedassetsforFY1$FY,

Fixed assets for FY2 $FY,

Fixed assets for FY3 $FY,

Fixed assets for FY4 $FY,

Placethecursorthreerowsbeneaththeentry% financialstatementtotal,

and add a separator.

Edit → Rows → Insert dividing line

Enter - - as the character for the separator. Theseparator shouldappear

across the entire form.

In the rowafterthe separator, choose Formula and enter your formula

component, for example Y001.

Enterthetexts: Short: Change. MediumChange. LongChangefixedassets.

TodeterminetheChangetofixedassets,youhavetoentertheformulas:

FY1 $FY FY2 $FY FY3 $FY

Change Assets /FY1 Assets /FY2 $FY Assets /FY3 $FY–

to fixed $FY– Assets – Assets /FY3 Assets/FY4$FY

assets /FY2 $FY $FY

Text: ChangeFY1 ChangeFY2 ChangeFY3

Short,

medium,

long

FirstselectthecellsintheFixedassetsrow. Thesearethecells:

Fixed assets row, Column FY1 $FY;

Edit → Element → Change: Selected

Continued on next page

156

	FY1 $FY	FY2 $FY	FY3 $FY
Change to fixed assets	Assets /FY1 $FY– Assets /FY2 $FY	Assets /FY2 $FY – Assets /FY3 $FY	Assets /FY3 $FY– Assets/FY4$FY
Text: Short, medium, long	ChangeFY1	ChangeFY2	ChangeFY3

第 171 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Fixed assets row, Column FY2 $FY;

Edit → Element → Change: Selected

Fixed assets row, Column FY3 $FY;

Edit → Element → Change: Selected

Fixed assets row, Column FY4 $FY;

Edit → Element → Change: Selected

Thechangetofixedassetsshouldonlybeforthecurrentyear,theprevious

year,andtheyearbeforelast. Editthecorrespondingcellsbyenteringthe

formulaforcalculatingfixedassets. ChooseChangeFYX(X=year1,2,

3) as texts.

In the cell for the row Change to fixed assets and the column FY4 $FY,

choose Inactive as the cell type.

Tohavetwo-lineheadingsfor yourcolumns, you haveto change thetext

type for all columns:

Formatting →All columns→ Text lengths

Enter Two-line long text.

Check your form.

Save your form.

Task 10:

1. For this form, create the report G##-BILKENN2 (## = group number)

for theReportingfortableFAGLFLEXT formtype withthedescription

G## Change: fixed assets.

Onthemaintenancescreen for theform, choose:

Environment→Report→Create(orReportpushbutton)

ChooseCompany codeandProfit centerasdrilldown characteristics.

OntheOutputtypetabpage,chooseClassicdrilldown(Basiclist: Detail)

and Available on selection screen.

Save your report.

Task 11:

1. Executeyourreport. Exitthemaintenancescreenforthereportbychoosing

Exit. Start the report from your user menu.

Continued on next page

157

第 172 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Choose Drilldown: Maintain and execute reports → Execute

reports.ChoosereportG##-BILKENN2. Youwanttodisplaythefinancial

statementvaluesforthecurrencytype10andcompanycode1000forthe

current fiscal year

158

第 173 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Solution 8: Drilldown Reporting in

Financial Accounting

Task 1:

1. CreateaformG##-BALPL-01(##=yourgroupnumber)fortheReporting

for Table FAGLFLEXT form type. Enter G## Act/act year as the

description. ChooseOneaxiswithkeyfigureasthestructure

User menu → AC280 Drilldown Activities →Drilldown Reporting:

Maintain Forms → Create Form

Inthegeneralselections,addtheRecordtype0foractualandLedger0L.

Edit→Generaldataselection→Generaldataselection

Choosethecolumndisplayforyourentriesintheform.

Goto → Column display

Define 3 columns:

Column 1:

KeyfigureBILWERT(BalanceSheetvalue)withthecharacteristicFiscal

year. EnterthecurrentfiscalyearforthecharacteristicFiscalyear(fixed

value). EnterFYXXXX(XXXX=currentyear)asashort, medium,and

long text.

Column 2:

KeyfigureBILWERT(BalanceSheetvalue)withthecharacteristicFiscal

year. EnterthepreviousfiscalyearforthecharacteristicFiscalyear(fixed

value). EnterFYXXXX(XXXX=previousyear)asashort,medium,and

long text.

Column 3:

Variance between thecurrent fiscal yearand thepreviousfiscal year

(usingformula). EnterVarianceastheshort,medium,andlongtext.

Check your form

Save your form.

a) Procedure:

Inyourusermenu,choosetransactionFGI4-Createforminthefolder

Drilldown reporting: Maintain forms.

Usermenu→Drilldownreporting: Maintainforms→Createform

Continued on next page

159

第 174 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Inthegeneralselections,addtheRecordType0foractualandLedger

0L.

Edit→Generaldataselection→Generaldataselection

ClickRecordtypeinthelistofavailablecharacteristicsandthenclick

thearrowpointinglefttoaddthischaracteristictothelistofselected

characteristics. Enter0astheFromvalue. ClickLedgerinthelistof

availablecharacteristicsandthenclickthearrowpointinglefttoadd

thischaracteristictothelistofselectedcharacteristics. Enter0Lasthe

From Value. Choose Confirm.

Choosethecolumndisplayforyourentriesintheform.

Goto → Column display

First column:

Double-click the first column (element 1) and choose Key figure

withcharacteristics(selectionbutton). ChooseBILWERT(Balance

Sheet Value) as the key figure. Select Fiscal year in the list of

Availablecharacteristicsandchoosethearrowpointinglefttoaddthis

characteristictothelistofSelectedcharacteristics. Enterthecurrent

fiscal year (XXXX) asthe From value.

EnterthetextsbychoosetheChangeshort/medium/longtextsymbol.

Enter the text: Short: GJ XXXX (XXXX = current year) and then

choose the Copyshort textpushbutton. Accept your entry andthen

choose Confirm.

Second column:

Double-clickthesecondcolumn(element2)andchooseKeyfigure

withcharacteristics(selectionbutton). ChooseBILWERT(Balance

Sheet Value) as the key figure. Click Fiscal year in the list of

availablecharacteristicsandthenclickthearrowpointinglefttoadd

this characteristic to the list of selected characteristics. Enter the

previousfiscalyear(YYYY)astheFromvalue.

Enter the textsfor the element definition:

ChoosetheChangeshort, mediumand longtextssymbol. Enter the

text: Short: GJ YYYY (YYYY= previousyear) and then choose

the Copy short text pushbutton.

Acceptyour entryandthen chooseConfirm.

Third column:

Double-click the third column (element 3) and choose Formula

(selectionbutton). Enteryourcalculationformula.

Continued on next page

160

第 175 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Click the ID X001, theminus sign, and then the ID X002. Accept

your entries.

Enter the textsforthe element definition:

Enter the text: Short: Variance, and then choose Copy short text.

Acceptyour entryand thenchooseConfirm.

Check your form: Choose Check.

Save your form.

Task 2:

1. Forthisform,createthereportG##-BALPL-01(##=groupnumber)for

thereporttypeReportingforTableFAGLFLEXTwiththedescriptionG##

Act/act year.

Environment→Report→Create(orReportbutton)

From the drilldown characteristics, choose financial statement item,

companycode, profitcenter, andaccountnumber. Youshouldbeable

toenter the hierarchyselection (financial statement version)using the

characteristicFinancialstatementitemwhenyourunthereport. Enterthe

fixedvalue1000forthecharacteristicCompanycode.

Changetheorderoftheuser-definedcharacteristics.

Sort user-defined characteristics button, after

Currency(1),Currencytype(2)andCompanyCode(3)sortby:

FS Item (4),

Account number (5), and

Profit center (6).

OntheOutputtypetabpage,chooseClassicdrilldown(Basiclist: D-down)

and Available on selection screen.

Continued on next page

161

第 176 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Save your report.

a) Procedure:

CreatereportG##-BALPL-01(##=groupnumber)forthisform. On

the maintenance screenform →change:

Environment→Report→Create(orchooseCreatereport).

ChoosethereporttypeReportingforTableFAGLFLEXT.

ForyourreportG##-BALPL-01,acceptthesameformnameoffered

andenterG##Act/actyearforthereportdescription.

Choose Create.

IntheAvailable characteristicslist , click

Financialstatementitem,companycode,profitcenterandaccount

number continue, and click the arrow pointing left to add these

characteristicstotheSelectedcharacteristicslist.

Double-clickthecharacteristicFinancialstatementitemandchoose

Enter at execution (selection button).

Enterthefixedvalue1000forthecharacteristicCompanycode.

Changetheorderoftheuser-definedcharacteristics:

ClickSortuser-definedcharacteristicsandenter

FS Item (4),

Account number (5), and

Profit center (6).

On the Output typetab page, choose Classic drilldown (Basic list:

drilldown)andselecttheAvailableonselectionscreencheckbox.

Save your report.

Task 3:

1. Execute the report:

Exit the screen for maintaining the report.

Start the report from your user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

PlacethecursoronreportG##-BALPL-01andchoose

Drilldownreport→Execute(ordouble-clickyourreport)G##-BALPL-01.

Continued on next page

162

第 177 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Currency type: 10

The FIS Annual Rep.Structure: INT:

Output type: Classic drilldown report

Execute

Navigate within the report until you find the account number for office

supplies. MakeanoteofthefinancialstatementvaluefortheProfitcenter

Motorcycles(1000)for the currentfiscalyear.

_______________________________________________________________

Continued on next page

163

第 178 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

_______________________________________________________________

a) Procedure:

Execute your report:

ExitthemaintenancescreenforthereportbychoosingExituntilyou

see your user menu on the screen.

Start the report from your user menu.

Drilldown: Maintain and execute reports → Execute reports:

Report:G##-BALPL-01→Drilldownreport→Execute(ordouble-click

your report G##-BALPL-01)

On the selection screen:

Currencytype10andThefinancialstatementversionINTand

Output type: Classic drilldown report

Execute

When you output the report, the financial statement items for the

financialstatementversionINTaredisplayedintherows.

Navigatewithinthereportuntilyoufindtheaccountnumberforoffice

supplies:

In the navigation area, click the drilldown characteristic Account

number.

Choose Financial statement item.

Thisproducesthedrilldownbyaccountnumber.

Scrolldownthelistuntilyoufindtheofficesuppliesaccount476000.

Alternatively,youcanusethebinocularsicontosearchforthetermOff.

Make a note of the financial statement value for the Profit center

Motorcycles(1000)forthecurrent fiscalyear:

SelecttheOfficesuppliesrowbychoosingtheanglebracketsicon

(<>) .

Inthenavigationarea,clicktheProfitcenterdrilldowncharacteristic.

The report values for account number 476000 (Office supplies)

arenowdrilled down by profit center. Makea noteofthe financial

statementvalueforthecombinationAccountnumber476000(Office

supplies) for the Motorcycles Profit center (1000) in the current

fiscal year.

Continued on next page

164