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

第 179 页 / 共 319 页

AC280 Lesson: Form and Report Definition

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:

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:

Variance between thecurrent fiscal yearand thepreviousfiscal year

(usingformula). EnterVarianceastheshort,medium,andlongtext.

Check your form.

Save your form.

a) Procedure:

Form for financial statement analysis:

In your user menu, click transaction FGI4 - Create form in the

Drilldownreporting: Maintain formsfolder.

Usermenu→ AC280 Drilldown Activities →Drilldown Reporting:

Maintain Forms → Create Form

Continued on next page

165

第 180 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

EntertheformtypeReportingforTableFAGLFLEXT,

Form: G##-BALPL-02(##=groupnumber) and

Description: G## Act/act year var.

Structure: One axis with key figure

In the general selections, add the Record Type 0 for actual and

Ledger 0L.

Edit→Generaldataselection→Generaldataselection

ClickRecordtypeintheAvailablecharacteristicslistandthenclick

the arrow pointing left to add this characteristic to the Selected

characteristicslist.Enter0astheFromvalue. ClickLedgerinthelist

of available characteristics and then click the arrowpointing left to

addthischaracteristictothelistofselectedcharacteristics. Enter0L

as the From value.

Choose Confirm.

Confirm

Choosethecolumndisplayforyourentriesintheform.

Goto → Column display

First column:

Placethecursoronthefirstcolumn(Element1)and

chooseEdit→Element→Change(ordouble-clickelement1).

ChooseKeyfigurewithcharacteristics(selectionbutton).

ChooseBILWERT(BalanceSheetvalue)forthekeyfigureandadd

thecharacteristicFiscalyear. PlacethecursoronFiscalyearinthe

Availablecharacteristicslistandchoosethearrowpointinglefttoadd

thischaracteristictotheSelectedcharacteristicslist.

Choose the global variable 1FY (fiscal year) as a Variable (select

Variablecheckbox)byselecting1FYandchooseEnter.

Enterthetextsfortheelement definition:

ChooseChangeshort, mediumandlongtexts.

Enterthetext: Short: FY&1FYandchooseCopyshorttext.

Acceptyour entryandthen chooseConfirm.

Second column:

Placethecursoronthesecondcolumn(Element2)and

chooseEdit→Element→Change(ordouble-clickelement2).

Continued on next page

166

第 181 页 / 共 319 页

AC280 Lesson: Form and Report Definition

ChooseKeyfigurewithcharacteristics(selectionbutton).

ChooseBILWERT(BalanceSheetvalue) for the keyfigureandadd

thecharacteristicFiscalyear. PlacethecursoronFiscalyearinthe

Availablecharacteristicslistandchoosethearrowpointinglefttoadd

thischaracteristictotheSelectedcharacteristicslist.

Choose the global variable 1FY (fiscal year) as a Variable (select

Variable checkbox) by selecting 1FY.

Also enter a hyphen (–) in the As operator field and 1 (one) in the

As Offset field. Choose Enter.

Enter the textsforthe element definition:

ChooseChangeshort, mediumandlongtexts.

Enterthetext: Short: FY&1FYandchooseCopyshorttext.

Acceptyour entryand thenchooseConfirm.

Third column:

Placethecursoronthethirdcolumn(Element3)and

chooseEdit→Element→Change(ordouble-clickelement3).

Choose Formula (selection button).

Enter your formula.

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

your entries.

Enter the textsforthe element definition:

Entertheshorttext: Variance,andthenchooseCopyshorttext.

Acceptyour entryand thenchooseConfirm.

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)

Continued on next page

167

第 182 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

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)

Continued on next page

168

第 183 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Save your report.

a) Procedure:

Create report G##-BALPL-02:

On the maintenance screen for theform:

Environment→Report→Create(orReportbutton)

Fortheformyouhavejustcreated,createthereportG##-BALPL-02

(## = group number) for report type Reporting for Table

FAGLFLEXTwiththedescriptionG##Actyearvar.

SelectthedrilldowncharacteristicsFinancialstatementitem,Company

code, Profit center, and Account number.

EnterINT forthefinancialstatementversion:

Double-clickthecharacteristicFinancialstatementitemandchoose

financial statement version INT.

Change the orderof theuser-defined characteristicsby choosing

Sort user-defined characteristics.

By FS Item (3)

by Company code (4),

Account number (5), and

Profit Center (6).

OntheVariablestabpage,definethecurrentfiscalyearasthevariable

value.

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

drilldown)and Availableonselectionscreen.

Save

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

Continued on next page

169

第 184 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Whenyoudisplaythereport,navigateusingthecharacteristicsProfitcenter,

Account number, andFinancial statement item.

a) Procedure:

Execute the report

Exitthemaintenancescreenforthereport. Startthereportfromyour

user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

PlacethecursoronthereportG##-BALPL-02(##=groupnumber)

that you created.

Drilldown report → Execute

(ordouble-clickthereportG##-BALPL-02). Ontheselectionscreen:

Current fiscal year

Company code: 1000

Currency type 10

Execute.

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

financialstatementversionINTaredisplayedintherows. Thecolumns

containthecurrentfiscalyear,thepreviousyear,andthevariance.

Whenyoudisplaythereport,navigateusingthecharacteristicsProfit

Center,AccountnumberandFinancialstatementitem.

3. Executethisreportagain. Ontheselectionscreen,enterthepreviousyearas

the fiscal year.

a) Ontheselectionscreen,enterthePREVIOUSfiscalyear.

Execute.

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

financialstatementversionINTaredisplayedintherows. Thecolumns

containthepreviousyear,theyearbeforelast,andthevariance.

Task 6:

Key figures report

1. Create form:

Onceyouhavecompletedtheform,itshouldlookasfollows:

Continued on next page

170

第 185 页 / 共 319 页

AC280 Lesson: Form and Report Definition

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.

EnterG## Asset proportion asthedescription.

Choose the structure 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: Keyfigureswith characteristics

Keyfigure: BILWERT(Balancesheet value)

Characteristic: Fiscal year

Local variable FY

(thisensuresthatyoucansubsequentlyenterthefiscalyearontheselection

screen)

Continued on next page

171

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

第 186 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

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

Changeshort, medium, and long textsbutton

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

year ; $FY

You now have tochange yourthird column:

Edit → Element → Change

Double-click the variable FY

LocalvariableFY withOperator–andOffset 2

ChooseChange short, medium, andlong texts

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

year ; $FY

YoucannowchangetheTexttypefor allcolumns:

Formatting →All columns→ Text lengths

Select Two-line long text.

Thevaluesinallcolumnsshouldhave2decimalplaces.

Placethecursoron each column andchoose:

Formatting→Numberformat(ortheNumberformatbutton)

Continued on next page

172

第 187 页 / 共 319 页

AC280 Lesson: Form and Report Definition

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.

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?, chooseNo

4. Financialstatementitems1010000,1020000,and1030000,whichare

tobeinsertedindividuallyasrows. Thetotalforallthreewillthenbecreated

inaformulaandthenthethreeindividualrowshidden.

Continued on next page

173

第 188 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

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.

5. Financial statement item1000000ASSETSfor the Financialstatement

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.

Inthe following dialog box containingthe query: Should theunderscore

appearonlyin the valuecolumns?, chooseNo

Formulaforthe%financialstatementtotalrow(Y001%AY002):

Edit→Element→Insertelement(ordouble-clickthisrow)

Continued on next page

174

第 189 页 / 共 319 页

AC280 Lesson: Form and Report Definition

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.

a) Procedure:

Create form:

Onceyouhavecompletedtheform,itshouldlookasfollows:

Fiscal year Fiscal year Fiscal year

2009 2008 1999

Assets

Fixedassets 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

Example: Thecurrentfiscalyearintheabovereportis2001.

Usermenu→AC280DrilldownActivities→DrilldownReporting:

Maintain Forms → Create Form

Create a form G##-BILKENN1 (## = your group number) for the

Reporting fortable FAGLFLEXTformtype.

EnterG##Assetproportionasthedescription.

Choose the structureTwo axes(matrix).

Choose Create

Edit→Generaldataselection→Generaldataselection

The general selections should contain the characteristic Financial

statementversionwiththevalueINT,thecharacteristicRecordtype0

(actual) and Ledger 0L.

Continued on next page

175

Assets	Fiscal year 2009	Fiscal year 2008	Fiscal year 1999
Fixedassets Financial statements total	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

第 190 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Click Financial statement version, Record type 0 (actual)

and Ledger 0L. Then click the arrow pointing left to add these

characteristicstotheSelectedcharacteristicslist. For thefinancial

statementversion, enterINTastheFrom value, 0fortheRecord

type and 0L for the Ledger.

Choose Confirm.

YouwanttodeterminethevaluesforthecharacteristicFiscalyearand

thetextsinwhichthefiscalyearsaredisplayedusinglocalvariables.

In the form, define the characteristic variable FY and the text

variable FY.

ChooseFinancialstatementvalueasthekeyfigure.

Thevaluesinallcolumnsshouldhave2decimalplaces.

Columns

Column 1:

Create the first column (column 1):

Place the cursor on Column 1,

Edit → Element → Change

Elementtype: Keyfigureswithcharacteristics

Enter

Keyfigure: BILWERT (Balancesheetvalue)

Characteristic: Choose Fiscal year from the list of available

characteristics(youmayneedtoscrollinthelist).

Arrow: Selected to left

Select from

Local variable: FY

Enter

Changeshort, medium, andlongtextsbutton

Text:

for column 1: Short: FY1 $FY Medium: FsclYear $FY Long:

Fiscal year; $FY

Enter

Confirm

The width of thiscolumnshould be19:

Continued on next page

176

第 191 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Placethecursor onthecolumn andchoose:

Formatting →Column → Column width

Tocopytheformatting, andthecontent of thefirstcolumn tothe

secondcolumn, placethecursoronthefirstcolumnandclick .

Placethecursoronthesecondcolumnandclick .

Copytheformatting,andthecontentofthefirstcolumntothethird

column the same way.

Younowhavetochangethesecond column:

Double-click the second column.

Edit → Element → Change

Place thecursor on theFrom value FY.

LocalvariableFYwithOperatorhyphen(–)andOffset1

Enter

Changeshort, medium, andlongtextsbutton

Textforcolumn2: ShortFY2$FYMediumFiscYr$FYLongFiscal

year ; $FY

Enter

Confirm

Younowhaveto changeyourthird column:

Double-click the third column.

Edit → Element → Change

Place thecursor on theFrom value FY.

LocalvariableFYwithOperator–andOffset2

Enter

Changeshort, medium, andlongtextsbutton

Textforcolumn3: ShortFY3$FYMediumFiscYr$FYLongFiscal

year ; $FY

Enter

Confirm

Change Texttype(textlengths)for allcolumns:

Formatting→Allcolumns→Text lengths

Enter Two-line long text.

Continued on next page

177

第 192 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Thevaluesinallcolumnsshouldhave2decimalplaces.

Placethecursoroneach column andchoose:

Formatting→Numberformat(ortheNumberformatbutton)

Choosetheformat 0.00fordecimalplaces.

YounowhavetodefineFYasacharacteristicvariableandasatext

variable:

Extras→ Variables→ Variabledefinition

Descriptionofyourvariableforthecharacteristicvalue: Fiscalyear

EnterFiscalyeartextasadescriptionforyourtextvariable

Double-clickyourtextvariableFYandenterthefollowing:

Replace selected field: Automatically

Selected characteristic: FYEAR

Replace selected field with: From field

Replaceselectedcharacteristicvalue/textwith: Characteristicvalue

Selected field: Offset 1, length 4

Enter

Increase the key column width:

Place the cursor on the key column: Formatting → Column →

Column width; 30 as column width

Rows

1. Configure long text for all rows:

Formatting→Allrows→Textlengths: One-linelongtext

ChooseOne-linelongtextasthetext type.

2. Enter the textAssets as the first row.

Place the cursor on the first row

Edit→Rows→Insertrow;thenEdit→Rows→Inserttext

Edit →Element →Changetext: Assets

Copy short text button

Enter

3. Separator

Continued on next page

178

第 193 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Place the cursor on the row beneath the empty row with the

text Assets.

Edit →Rows →Insert dividing line

Enterthecharacter--asanunderscorefortheseparator.

Enter

Inthefollowingdialogboxwiththequery: Shouldtheseparator

appearonlyinthevaluecolumns? ChooseNo.

Enter

4. Financial statement items1010000, 1020000, and 1030000,

which are to be inserted individually as rows. The total for

all three will then be created in a formula and then the three

individual rows hidden. :

Placethecursorontherowbeneaththeseparator.

Edit→Element→Insertelement(ordouble-clickthisrow).

Elementtype: Characteristicoverview(selectionbutton).

FSItemasacharacteristicintheSelectedcharacteristicslist.

Enter the FS Items 1010000, 1020000 and 1030000 each

individually oneafter the other asrows and keep the texts for

themasoffered. TobeabletoentertheseItemsyouhaveto,each

time,choosetheHierarchyiconbelowChangehierarchynode

entry'andthenentertheFSItemnumberorusethematchcode

buttontonavigatedownandchoosetheItemnumberthatway.

Finally, chooseConfirm to bring the Item with its description

into the formula row.

Afterthesethreerows,insertaFormularowwiththeadditionof

these three rows.

Texts for the Formula row:

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

You should then HIDE the 3 rows containing the FS Items

1010000, 1020000 and 1030000.

Todothisplacethecursoroneachoftheserowsandthenchoose

Edit → Rows → Hide.

Enter

Confirm

Continued on next page

179

第 194 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

5. Financialstatementitem1000000ASSETSfortherowFinancial

statementtotal: PlacethecursorontherowbeneathFixedassets.

Edit→Element→Insertelement(ordouble-clickthisrow)

Elementtype: Characteristicoverview(selectionbutton).

ClickFSitemintheAvailablecharacteristicslistandthenclick

thearrowpointinglefttoaddthischaracteristictotheSelected

characteristics list.

ChoosetheHierarchyiconbelowChangehierarchynodeentry

and then enter the value 1000000.

Enterthetextsfor theelementdefinition:

Changeshort,medium,andlongtextsbuttonEnterthetext:

Short: FSTotal; Medium: FS Total; Long: Financial

Statement total

Enter

Confirm

6. Separator:

Place the cursor on the row beneath the row containing the

text Financial statement total.

Edit →Rows →Insert dividing line

Enterthecharacter--asanunderscorefortheseparator.

Enter

Inthefollowing dialog box containing thequery: Should the

underscoreappearonlyinthevaluecolumns?,chooseNo

Enter

7. Formulaforthe%financialstatementtotalrow(Y001%AY002):

Placethecursorontherowbeneaththeseparator.

Edit→Element→Insertelement(ordouble-clickthisrow)

Elementtype: Formula(selectionbutton)

Formula: Y001 %A Y002

Enter

Texts: short: %portion;Medium%financialstatementtotal;

Long: %portionfinancial statement.

Enter

Continued on next page

180

第 195 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Thisrowshouldbedisplayedinadifferentcolortotheotherrows.

Place the cursor on the row.

Formatting→Colorsetting: Colorfortotals

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)

ChooseCompanycodeandProfitcenterasdrilldowncharacteristics.

OntheOutputtypetabpage,chooseClassicdrilldownreporting(Basiclist:

Detail) and Available on selection screen.

Save your report.

a) Procedure:

Report G##-BILKENN1 for keyfigures:

Forthisform,createthereportG##-BILKENN1(##=groupnumber)

for Reporting for Table FAGLFLEXT with the description G##

Asset proportion.

Environment→Report→Create(orReportpushbutton)

ReporttypeReportingforTableFAGLFLEXTwiththedescription

G## Asset proportion

Create button

ChooseCompanycodeandProfitcenterasdrilldowncharacteristics.

OntheOutputtypetabpage,chooseClassicdrilldownreporting(Basic

list: Detail) andAvailableonselectionscreen.

Save your report.

Task 8:

1. Execute the report:

Continued on next page

181

第 196 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

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.

a) Refer to the task description.

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:

Fiscal year Fiscalyear Fiscal year Fiscal year

2009 2008 2007 2006

Assets

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

Continued on next page

182

第 197 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Fiscal year Fiscal year Fiscal year Fiscal year

2009 2008 2007 2006

Assets

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.

New rows:

Continued on next page

183

Assets	Fiscal year 2009	Fiscal year 2008	Fiscal year 2007
Financial statements total	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

第 198 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

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

Fixed assets row, Column FY2 $FY;

Continued on next page

184

	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

第 199 页 / 共 319 页

AC280 Lesson: Form and Report Definition

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.

a) Procedure:

Create a form G##-BILKENN2(## = your group number) for the

formtypeReportingforTableFAGLFLEXT,withthedescription

G## Change AV:

Usermenu→AC280DrilldownActivities→DrilldownReporting:

Maintain Forms → Create Form

Use form G##-BILKENN1asatemplate.

Copyfromform: G##-BILKENN1. Createpushbutton.

The form should bestructured as follows:

Fiscalyear Fiscalyear Fiscal Fiscal

2009 2008 year2007 year2006

Assets

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

Continued on next page

185

第 200 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Fiscalyear Fiscalyear Fiscal Fiscal

2009 2008 year2007 year2006

Assets

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

statements

total

% financial xx.xx xx.xx xx.xx

statement

total<Empty

row>

Change to xx.xx xx.xx xx.xx

fixedassets

Example: Thecurrentfiscalyearintheabovereportis2009.

Procedure: Column

Tocopythisformattingandthecontentofthefirstcolumntothefourth

column,placethecursoronthefourthcolumnandchoose .

Double-click the fourth column.

Edit → Element → Change

Place the cursor on the From value FY.

LocalvariableFYwithOperator-andOffset3

Enter

Changeshort, medium, andlongtextsbutton

Text for column 2: Short FY4 $FY Medium FsclYear $FY Long

Fiscal year; $FY

Enter

Confirm

Thefourthcolumnshouldnowonlyshowthefixedassetsvalue.

Double-click the corresponding cells:

Cellintherow: Financialstatementstotal;inthelastcolumn(FY4

$FY).

Define the cell type as Inactive.

Continued on next page

186

Assets	Fiscalyear 2009	Fiscalyear 2008	Fiscal year2007
Financial statements total	xx,xxx.xx	xx,xxx.xx	xx,xxx.xx
% financial statement total<Empty row> <Emptyrow>	xx.xx	xx.xx	xx.xx
Change to fixedassets	xx.xx	xx.xx	xx.xx

第 201 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Cellintherow: %financialstatementtotal,inthelastcolumn(FY4

$FY).

Define the cell type as Inactive.

Procedure: Rows

After the% financial statementstotalrow, youwant to displaytwo

empty rows and then a separator.

Thenextrowshouldshowthechangetofixedassets,butonlyforthe

currentyear,thepreviousyear,andtheyearbeforelast.

To enable you to recognize the corresponding columns in your cell

names,youshouldchangethetexttypeforallcolumns:

Formatting→Allcolumns→Text lengths

Enter the text type Short text.

Place the cursor threerowsbeneaththeentry%financial statement

total, and add a separator.

Edit → Rows → Insert dividing line

Separator characters: – –.

Shouldtheunderscoreappearonlyinthevaluecolumns? NO

Placethecursorontherowbeneaththeseparator.

Edit→Element→Insertelement(ordouble-clickthisrow)

Elementtype: Formula;formulacomponent(forexample,Y001).

Texts: Short: Change. Medium: FA change; Long: Change to

fixed assets

Todeterminethechangetofixedassets,youhavetoentertheformula:

FY1 $FY FY2 $FY FY3 $FY

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

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

assets /FY2$FY /FY3 $FY

Text: ChangeFYX ChangeFYX ChangeFYX

Short,

medium,

long

First,selectthecellsintheFixedassetsrow. Thesearethecells:

Fixed assets row, Column FY1 SFY;

Continued on next page

187

	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	ChangeFYX	ChangeFYX	ChangeFYX

第 202 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Edit →Element → Change: Selected

Fixed assetsrow, Column FY2 $FY;

Edit →Element → Change: Selected

Fixed assetsrow, Column FY3 $FY;

Edit →Element → Change: Selected

Fixed assetsrow, Column FY4 $FY;

Edit →Element → Change: Selected

Thechangeto fixedassetsshouldonlybefor thecurrentyear, the

previous year, and the yearbefore last.

Editthecorrespondingcellsbyenteringtheformulaforcalculating

fixed assets.

Placecursoroncell: Changetofixedassetsrow,ColumnFY1$FY;

Edit →Element→Change: Select Formula

Formulacomponents(meaning): Assets/FY1$FY–Assets/FY2

$FY

Text: Short: ChangeFY1,Copyshorttextbutton

Enter

Placecursoroncell: Changetofixedassetsrow,ColumnFY2$FY;

Edit →Element→Change: Select Formula

Formulacomponents(meaning): Assets/FY2$FY–Assets/FY3

$FY

Text: Short: ChangeFY2,Copyshorttextbutton

Enter

Placecursoroncell: Changetofixedassetsrow,ColumnFY3$FY;

ChooseEdit→Element→Change: Formula

Formulacomponents(meaning): Assets/FY3$FY–Assets/FY4

$FY

Text: Short: ChangeFY3,Copyshorttextpushbutton

Enter

Placecursoroncell: Changetofixedassetsrow,ColumnFY4$FY;

Edit → Element →Change: Inactive

Enter

Continued on next page

188

第 203 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Tohavetwo-lineheadingsforyourcolumns,youhavetochangethe

text type for all columns:

Formatting→Allcolumns→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.

a) Report G##-BILKENN2forkey figures:

For this form, create the report G##-BILKENN2 (## = group

number)forreporttypeReportingforTableFAGLFLEXTwiththe

description G## Change: fixed assets.

Environment→Report→Create(orReportpushbutton)

ReporttypeReportingforTableFAGLFLEXTwiththedescription

G## Change: fixed assets

Create button

ChooseCompanycodeandProfitcenterasdrilldowncharacteristics.

OntheOutputtypetabpage,chooseClassicdrilldownreporting(Basic

list: Detail) andAvailableonselectionscreen.

Save your report.

Task 11:

1. Executeyourreport. Exitthemaintenancescreenforthereportbychoosing

Exit. Start the report from your user menu.

Continued on next page

189

第 204 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Choose Drilldown: Maintain and execute reports → Execute

reports.ChoosereportG##-BILKENN2. Youwanttodisplaythefinancial

statementvaluesforthecurrencytype10andcompanycode1000forthe

current fiscal year

a) Execute the report:

Exit themaintenancescreenfor thereport.

Exitthemaintenancescreenfortheform. Startthereport fromyour

user menu.

ChooseDrilldown: Maintainandexecutereports→Executereports.

G##-BILKENN2

EntertheCurrency type10 andCompany code1000and Current

fiscal year on the selection screen.

AndselectClassicdrilldownreportinthereporttype

Execute

190

第 205 页 / 共 319 页

AC280 Lesson: Form and Report Definition

Lesson Summary

You should now be able to:

• Define forms

• Define and execute reports

• Defineformsandreportsmoreflexiblyusingcharacteristicandtextvariables

191

第 206 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Lesson: Displaying Reports

Lesson Overview

In this lesson, you will learn about output types and the functions provided in

drilldown reports.

Lesson Objectives

After completingthislesson, you will beable to:

• Use different types of report outputs

• Create graphics

• Export data to Microsoft Excel

• Havethesystemperform currency translation

Business Example

EmployeesinFinancialAccountingwanttousevarioustypesofreportoutput.

Theyalsowanttolearnaboutadditionalfunctionswithindrilldownreporting.

Figure 88: Different Output Types for Reports

Theoutputtypethatyouchooseinthereportdefinitionisonlyadefaultsetting.

When you run the report, the output type that you define is already selected.

However, you can choose an alternative output type, graphic report output,

when you run the report.

192

第 207 页 / 共 319 页

AC280 Lesson: Displaying Reports

Youusethegraphicreportoutputifyouwanttodisplaythereportdataattractively

onthescreen,orifyouneedseveralviewsofthereportdatasimultaneously(for

example,drilldownlistanddetaillist). Forthegraphicreportoutput,youcan

define the required output areasand determine which HTML templateis tobe

usedforthereportheader(informationarea). Forexample,youcanincludeyour

companylogointhereport. Theheaderandfooterwillalsoappear ifyouhave

definedthemandpreparedtheHTMLtemplateaccordingly.

Classicdrilldownreport: Forclassicdrilldownreports,youcandefinewhich

listtype(drilldown/detail)istobeusedasthebasiclistandwhetherheadersand

footersaretobeprinted. Forspecialpurposes,youcandefinethattheobjectlists

areoutputusingtheSAPListViewer. Thisgivesyoutheoptionofcreatingreports

thathaveseveralcharacteristicvaluesintheleadingcolumn. Youcanalsousethe

additional optionsprovided bytheSAP List Viewer, such asflexiblefilter and

sortoptions,definitionofdisplayvariants,andsoon. ReportoutputtoXXL.The

systemcontinuesprocessingthereportdatausingaspreadsheet.

Figure 89: Function Levels for Different Users

Drilldownreportingfunctionsarecomposedofthreegroups:

Level1containsthebasicdrilldownreportingfunctions. Youcannavigatewithin

the characteristic hierarchy of a predefined report using these functions. You

can usethe functions of the detail list to carry out aspecific analysis of larger

volumesof data. Certain functions are not available at this function level (for

example,functionsformaintainingreports,forchangingsettingsinthereportlist,

orforconnectionstoadditionalproductssuchastheMicrosoftExcellistviewer).

Thislevelisintendedforuserswhooccasionallywanttousecertainformreports

indrilldownreportingforfurther analyses, withoutrequiringall thenavigation

functions.

193

第 208 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

Level 2 covers the complete functions of drilldown reporting (all navigation

functions), and provides a connection to the Excel list viewer, PC download,

graphic functions, functionsfor changing the display, and all functions within

hierarchies. Youcandisplayexceptions. Certainfunctionsarenotavailableatthis

functionlevel(forexample,functionsformaintainingreportsandfunctionsfor

settingupacustomizedprintlayout). Thislevelisintendedforuserswhorequire

alltheanalysisfunctionsindrilldownreportingandtheconnectionsstatedabove.

Allfunctionsalsocoversprintpreparation,savingreports,definingexceptions,

and report maintenance direct from drilldown reporting, thus all the functions

providedbydrilldownreporting. Thislevelisdesignedforuserswhomaintain

reportsorsetupprintpreparationinadditiontothefunctionsforlevel2. Youcan

changethelevelbychoosingExtras→Additionalfunctions.

Figure 90: Frozen Data

Youcanfreezedataforeachreportandvariablecombination. Thisenablesyouto

fulfilbusinessrequestsfordefinedstatusesofareport.

Youcancreatefrozendataforareportonlineorinthebackground.

Whenusingthismethod,youdonothavetowaitforthetransactiondatarecords

tobereadandyouautomaticallyreceivethelastdatasaved.

Thedatabaseserverisnotgreatlyaffected. SAPthereforerecommendsthatyou

workwithfrozendataforcomplexreportsinvolvinglargevolumesofdata.

194

第 209 页 / 共 319 页

AC280 Lesson: Displaying Reports

Figure 91: Background Processing

You can save report data at specified times in the background (transaction

FS(K/D)IB).Bysavingreportdata,youdonothavetoselectmoredatafromthe

database when you run a report. The data isalready availablein aformat that

reduces the report runtime dramatically.

Usingselectionvariants,youcansavethevariableentriesandadditionalsettings

as variants for a report.

Youcanchoosethefollowinglisttypes: drilldownlist,detaillist,andSAPList

Viewer.

195

第 210 页 / 共 319 页

Unit4: DrilldownReportinginFinancialAccounting AC280

196