AC220_EN_Col52_FV_Inst_A4 (第8页) | ERP软件技术分享

第 261 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

4. Simulatethesubstitutiontochecktheresult: (Substitutioninitialscreen→

Simulate)

a) Simulatethesubstitutiontochecktheresult: (Substitutioninitialscreen

→ Display → Simulate)

Step Object Value

Field GLU1 RZZREGION N-xx1

Select Execute.

Result:

Step Object Value

001 Prerequisite OK

001 Result NORTH

5. Activatethesubstitutionforyourcompanycodeincalluppoint0002.

ExitSubstitutionandgobacktothescreenChangeView“Substitutionfor

Special PurposeLedger/Co.Code”: Overview.

Select New Entries.

Enter the following:

CompanyCode CallupPoint Substitution ActivationLevel

ACXX 2 GXX-SUB 1

SAPReferenceIMG→FinancialAccounting→SpecialPurposeLedger

→BasicSettings→Substitution→MaintainSubstitution

a) Activatethesubstitutionforyourcompanycodeincalluppoint0002.

ExitSubstitutionandgobacktothescreenChangeView“Substitution

forSpecialPurposeLedger/Co.Code”: Overview.

Select New Entries.

Enter the following:

CoCodeCalluppointSubstitutionActivationLevel

ACXX 2 GXX-SUB 1

Select Save.

6. EnterthefollowingFI-SLdocumentlines. UsethedocumenttypeA0and

user table GXX-UTAB:

The version for this posting is 1.

Account SpecialRegion Amount in USD

Continued on next page

243

第 262 页 / 共 509 页

Unit5: Validations,Substitutions,andRules AC220

810200 N-xx1 5,000.00

810200 S-xx1 6,000.00

810300 W-xx1 1,000.00

810400 E-xx1 2,000.00

a) EntertheFI-SLdocumentasindicatedinyourexercise:

7. Check your postings (and substituted regions) using the FI-SL display

function for actual local documents.

a) Checkyourpostings(andsubstitutedregions)usingtheFI-SLdisplay

function for actual local documents.

244

第 263 页 / 共 509 页

AC220 Lesson: CreationandMaintenanceofValidationsandSubstitutions

Lesson Summary

You should now be able to:

• Describe operands and operators

• Explain field comparisons

• Use rules and user exits

• Describe the formula builder

• Explaintheprocessofmaintenanceofvalidationsandsubstitutions

• Explain the process of activation

245

第 264 页 / 共 509 页

UnitSummary AC220

Unit Summary

You should now be able to:

• Describevalidationand substitutionexamples

• Describe call-up points in validations

• Describe operands and operators

• Explain field comparisons

• Use rules and user exits

• Describe the formula builder

• Explaintheprocessofmaintenanceofvalidationsandsubstitutions

• Explain the process of activation

246

第 265 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

195

1. What is the function of validation?

2. Callup point 2 is used to check the fields in a document line for a

oraFI-SLadjustmentposting.

Fillintheblankstocompletethesentence.

3. Comparison operators include:

Choosethecorrectanswer(s).

□ A Equal to

□ B Implication

□ C Like

□ D Less than or equal to

4. Provideanytwo examplesoffieldcomparison.

5. IfaBooleanstatementisfrequentlyusedorifitcontainscomplexlogic,you

cannot create a rule for it.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

6. Theuseoftechnicalnamesisnotsupportedintheformulabuilder.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

7. Asubstitutionstepconsistsofa andasubstitution.

Fillintheblankstocompletethesentence.

247

第 266 页 / 共 509 页

TestYourKnowledge AC220

8. Avalidationorsubstitutioncanbevalidforseveralcompanycodesorglobal

companies at the same time.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

248

第 267 页 / 共 509 页

AC220 Test Your Knowledge

Answers

197

1. What is the function of validation?

Answer: Validationallowsyoutodefineyourownchecksforspecificfields

whena businesstransaction isbeing processed.

2. Callup point 2 is used to check the fields in a document line for a G/L

account postingor aFI-SLadjustment posting.

Answer: G/L account posting

3. Comparison operators include:

Answer: A, D

Comparisonoperatorsincludethe’Equalto’and’Lessthanorequalto’signs.

4. Provideanytwo examplesoffieldcomparison.

Answer: Fieldconstantcomparisonandsubfieldcomparisonareexamples

of field comparison.

5. IfaBooleanstatementisfrequentlyusedorifitcontainscomplexlogic,you

cannot create a rule for it.

Answer: False

If a Boolean statement is frequently used or if it containscomplex logic,

you can create a rule for it.

6. Theuseoftechnicalnamesisnotsupportedintheformulabuilder.

Answer: False

The use of technical names is supported in the formula builder, but the

optionsyoucanusearedeliveredusingpressbuttonsandtexts.

7. Asubstitutionstepconsistsofaprerequisiteandasubstitution.

Answer: prerequisite

249

第 268 页 / 共 509 页

TestYourKnowledge AC220

8. Avalidationorsubstitutioncanbevalidforseveralcompanycodesorglobal

companies at the same time.

Answer: True

Avalidationorsubstitutioncanbevalidforseveralcompanycodesorglobal

companies at the same time.

250

第 269 页 / 共 509 页

Unit 6

Sets and Basic Feature Of the Report

199

Painter

DescribehowtocreatesetstobeusedintheReportPainter,Planning,Allocation,

and Rollup application areas of FI-SL. One advantage of the new set concept

from 4.0onward isthefact that Sets areclassesand not table dependent. This

meansthatthesetscreatedforonetablecanbeusedforanother,thatisanother

application,onthepremisethattherepresentativedataelementisthesameforthe

field(characteristic)usedintheset. Thisreducestheredundancythatwastherein

thepast. Setsareindependentobjectsandnotconfinedtoanyusageatthetime

of their definition . Before you define a set, it is always necessary to be clear

of itslaterusage. Theparticipantsshouldneverbeforcedtoposethequestion,

“Why are we defining this set?”

Unit Overview

Thisunitwillprovideinformationpertainingtothedifferentsettypes. Youwill

learnhowtocreatesets. Youwillalsolearnhowtodefineandexecuteasimple

report.

Unit Objectives

After completing thisunit, you will beableto:

• Describe how to use sets

• Describethefeaturesof basicsetsandsinglesets

• Selectthereportpaintercomponentsforreportrowsandcolumns

• Select the characteristicsfor theentire report

Unit Contents

Lesson: Sets.....................................................................253

Demonstration: Demonstration of a Basic Set .........................261

Demonstration: Demonstration of a Set ................................262

Exercise 11: Sets/Painter..................................................263

251

第 270 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Lesson: Report Painter Components ........................................270

Demonstration: Demonstration of Report Painter......................275

252

第 271 页 / 共 509 页

AC220 Lesson: Sets

Lesson: Sets

Lesson Duration: 60 Minutes

200

Lesson Overview

Thislessondescribeshowtousesetstocontroldatacallinganddisplaying. Italso

describeshowtousebasicsetsandsinglesetsinreports,planning,andallocation.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Describe how to use sets

• Describethefeaturesof basicsetsandsinglesets

Describetotheparticipantstheuseofsetsandthefeaturesofbasicsetsandsingle

sets.

Business Example

Themanagement requiresanexpenseaccountreport forthecurrent year. This

reportshouldbeorganizedasahierarchyofexpenseaccounts. Asamemberof

theprojectteamthatcreatesreports,youhavebeengiventhetaskofcreatingthis

report. Youneedtousesetstorepresentthishierarchyinthereportyoucreate.

253

第 272 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Overview of Sets

Figure104: SetsandBasicFeaturesoftheReportPainter: Overview

Using Sets

Using Sets: Sets as a tool for “universal” usage in FI-SL. Sets are used in all

areas of FI-SL, such as:

• Formulae (using Boolean logic) for validation, substitution, and ledger

selection

• Reporting (Report Writer and Report Painter)

• Allocation (assessment and distribution)

• Planning

• Rollups

254

第 273 页 / 共 509 页

AC220 Lesson: Sets

Figure 105: Using Sets

Asetisaflexibledatastructureusedtorepresent values, rangesofvalues, and

hierarchies.

Sets are maintained centrally.

Setsare usedin almostallareasof FI-SL, such as:

• Formulae (using Boolean logic) for validation, substitution, and ledger

selection

• Reporting (Report Writer and Report Painter)

• Allocation (assessment and distribution)

• Planning

• Roll-ups

255

第 274 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Figure 106: Using Sets in Logical Rules

Youcanentersetsinaprerequisiteorcheck,insteadofusingfields. Inthiscase,

therulethatis used isTable field INSETNAME

Setscontainvaluesorvalueintervalsforaspecificfield.

The above example uses thefollowing logic:

Iftheuserisdefinedintheset,USERGROUP,checkwhetherornottheuseruses

oneofthefunctionalareascontainedintheset,ADMIN-FAREAS.

Figure 107: Cross-Table Set Usage

Setscanbeusednotonlyforthetablefieldforwhichtheywerecreatedbutfor

every compatible table field.

256

第 275 页 / 共 509 页

AC220 Lesson: Sets

Representativedataelementinaset. Therepresentativedataelementofasetor

variablecontrolsthewayinwhichsetsandvariablescanbeusedfortablefields.

Setsandvariablescanbeusedforaparticulartablefieldifoneofthefollowing

conditions is met:

Setsand variablesare created for the tablefield.

Setsandvariablesarecreatedforatablefieldthathasthesamedataelement.

Setsandvariableswerecreatedforatablefieldthathasadifferentdataelement

but the same representative data element.

Iftwotablefieldshavedifferentdataelementsbutthesametechnicalproperties,a

representativedataelementdefinesthatsetsandvariablescanbeusedforboth

the table fields.

Forexample,dataelements,KSTARandRACCT,havethesamerepresentative

dataelement,SAKNR(thisnameisstoredintable,SETDTEL).

Data element Repr. data element

KSTAR SAKNR

RACCT SAKNR

In a report for table GLFUNCT for the Account characteristic (field

GLFUNCT-RACCTwithdataelementRACCT),youcanuseallthesetscreated

fortablefieldswiththedataelements,KSTAR,RACCT,orSAKNR.

Basic Sets

Explain that a basic set contains several values(single valuesor valueranges)

that use the same characteristic.

257

第 276 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Figure 108: Basic Set

A basic set contains several values (single valuesor valueranges) that use the

same characteristic.

Figure 109: Basic Set

You can add single values or value ranges.

Theintervalsarereleasedif asetisusedasaset lineinareport. Thisdoesnot

apply to column sets.

258

第 277 页 / 共 509 页

AC220 Lesson: Sets

Single Sets

A single-dimension (characteristic) set combines basic sets and other

single-dimensionsets. Allthesetsinasingle-dimension(characteristic)setuse

the same characteristic.

SingleSets: SingleDimension(Characteristic)setsareusedtocreatehierarchies

in the same field (characteristic) and consist of basic and/or single dimension

sets. Especiallyforreporting,thesinglesetsallowforautomatictotalbuildings

forthenodesofthehierarchy. Theorderofthesetsdeterminesalsothesequence

of the totals.

Figure 110: Single Set

A single-dimension (characteristic) set combines basic sets and other

single-dimension sets.

Allthesetsinasingle-dimension(characteristic)setusethesamecharacteristic.

Display the screens to build a basic set.

259

第 278 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Figure 111: Defining Single Sets

Single-dimension(Characteristic)setsareusedtocreatehierarchiesinthesame

field(characteristic)andconsistofbasicand/orsingle-dimensionsets.

Figure 112: Defining Single-Dimension Sets: Example

Two examples of single-dimension sets:

• P andLAccounts: Revenueandexpenseaccounts

• Expenseaccounts: PersonnelaccountsandAdminaccounts

260

第 279 页 / 共 509 页

AC220 Lesson: Sets

Demonstration: Demonstration of a Basic Set

Purpose

To demonstrate the Basic set

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. CreatesetstothetableZSLTABTforsets(seeparticipants’exercises). You

candefineothersetswhiletheparticipantsarebusy.

Account number (Field RACCT)

G00-WAGES “Wages”

420000

421000

G00-SALARY “Salaries”

430000

431000

G00-GEN-EXPENSE “General Expenses”

472000

476000

Functional area (Field RFAREA)

G00-FAREAS “Functional areas”

0300

0400

0500

ThesesetsareusedinPainter,Planning,Allocation,andRollup. Thesetsare

usedasminimum–maximumvaluestoaccessthetablestoretrievethefield

valuesandprovideastructuretoorganizetheseinthoseapplications.

261

第 280 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Demonstration: Demonstration of a Set

Purpose

To create a set to the table ZSLTABT

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1. Createthefollowingsetto thetable ZSLTABT.

Account number (Field RACCT)

G00-OVERHEAD “Overhead Accounts”

001 G00-WAGES

002 G00-SALARY

003 G00-GEN-EXPENSE

262

第 281 页 / 共 509 页

AC220 Lesson: Sets

Exercise 11: Sets/Painter

207

Exercise Duration: 30 Minutes

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Definebasic, single, andmultidimensionsetsthat youcan useinreports,

planning, allocations, and rollups

Business Example

SetsareakeycomponentofFI-SLapplications. Setscontrolhowdataiscalled

from the database and displayed.

Participantsneedtoanalyzetheuseofsetstoorganizeandgroupdata.

Theywill identifythelogicinvolvedinset structuresandusesetsin theFI-SL

components: reporting, allocation, planning,androllup.

Task:

Todefinesets, select thefollowingmenupathitems:

SAPEasyAccess→Accounting→FinancialAccounting→SpecialPurpose

Ledger→Tools→SetMaintenance →Sets→Create

Define all your sets for the table ZSLTABT.

AllofyoursetsshouldstartwiththeprefixGXX(XX=yourgroupnumber).

1. Basic Sets

Account number (field RACCT)

GXX-WAGES Wages

420000

421000

GXX-SALARY Salaries

430000

431000

GXX-GEN-EXPENSE General Expenses

472000

476000

Continued on next page

263

第 282 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Special region (Field RZZREGION

GXX-SPECREG Special regions

N-XX1

S-XX1

E-XX1

W-XX1

(XX = your group number)

GXX-REVENUESRevenues(Ref. set: G99-REVENUES)

810200

810300

810400

Functional area (field RFAREA)

GXX-FAREASRevenues(Ref. set: G99-FAREA)

0300

0400

0500

GXX-ZONES Regions(Ref. set: G99-ZONES)

NORTH

SOUTH

EAST

WEST

Material (field RMATNR)

GXX-PRODUCTSProducts(Ref. set: G99-Products)

T-IC-F1001

T-IC-F1002

T-IC-F1003

T-IC-R2007

T-IC-R2008

T-IC-R2009

Ledger (Field RLDNR)

Continued on next page

264

第 283 页 / 共 509 页

AC220 Lesson: Sets

GXX-LEDGER Ledger AA (or.RR)

AA (or.RR)

Version (Field RVERS)

GXX-VERS1 Version 1

2. SINGLE-SET

Account number (field RACCT)

GXX-OVERHEAD Overhead Accounts

001 GXX-WAGES

002 GXX-SALARY

003 GXX-GEN-EXPENSE

265

第 284 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Solution 11: Sets/Painter

Task:

Todefinesets, selectthefollowingmenupathitems:

SAPEasyAccess→Accounting→FinancialAccounting→SpecialPurpose

Ledger→Tools→SetMaintenance→Sets→Create

Define all your sets for the table ZSLTABT.

AllofyoursetsshouldstartwiththeprefixGXX(XX=yourgroupnumber).

1. Basic Sets

Account number (field RACCT)

GXX-WAGES Wages

420000

421000

GXX-SALARY Salaries

430000

431000

GXX-GEN-EXPENSE General Expenses

472000

476000

Special region (Field RZZREGION

GXX-SPECREG Special regions

N-XX1

S-XX1

E-XX1

W-XX1

(XX = your group number)

GXX-REVENUESRevenues(Ref. set: G99-REVENUES)

810200

810300

810400

Functional area (field RFAREA)

Continued on next page

266

第 285 页 / 共 509 页

AC220 Lesson: Sets

GXX-FAREASRevenues(Ref. set: G99-FAREA)

0300

0400

0500

GXX-ZONESRegions(Ref. set: G99-ZONES)

NORTH

SOUTH

EAST

WEST

Material (field RMATNR)

GXX-PRODUCTSProducts(Ref. set: G99-Products)

T-IC-F1001

T-IC-F1002

T-IC-F1003

T-IC-R2007

T-IC-R2008

T-IC-R2009

Ledger (Field RLDNR)

GXX-LEDGER Ledger AA (or.RR)

AA (or.RR)

Version (Field RVERS)

GXX-VERS1 Version 1

Continued on next page

267

第 286 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

a) Basic Sets

Examplesolution for set GXX-WAGES

Set ID: GXX-WAGES

Table: ZSLTABT

Set type: Basic Set

Select Enter.

Field name: RACCT

Description: Wages

Set lines:

Values:

420000, 421000

Save the set.

2. SINGLE-SET

Account number (field RACCT)

GXX-OVERHEAD Overhead Accounts

001 GXX-WAGES

002 GXX-SALARY

003 GXX-GEN-EXPENSE

a) Single Set

ExamplesolutionforthesetGXX-OVERHEAD

Set ID: GXX-OVERHEAD

Table: ZSLTABT

Set type: Single Set

Select Enter.

Field name: RACCT

Description: Overhead postings

Set lines:

Set ID:

GXX-WAGES,GXX-SALARY,GXX-GEN-EXPENSE

268

第 287 页 / 共 509 页

AC220 Lesson: Sets

Lesson Summary

You should now be able to:

• Describe how to use sets

• Describethefeaturesof basicsetsandsinglesets

269

第 288 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Lesson: Report Painter Components

Lesson Duration: 50 Minutes

214

Lesson Overview

Thislessondescribeshowtoselectthecomponentsthatyouwanttouseinyour

report rowsand columns. Italso explainshowtoselectthecharacteristicsthat

are valid for the entire report.

Lesson Objectives

After completingthislesson, you will beable to:

• Selectthereportpaintercomponentsforreportrowsandcolumns

• Select the characteristicsfor theentire report

Describetotheparticipants howto select reportpaintercomponentsfor report

rowsandcolumns. Explainhowtoselectthecharacteristicsfortheentirereport.

Business Example

The management requires an expense report with quarterly data structured

according to accounts and special regions. The cost element-wise breakup of

functional area should represent rows and a quarterly breakup of actual costs,

plannedcosts, andvariancesshouldrepresentcolumns. Youneedtodefinethe

characteristicsandkeyfigurecomponentsofReportPaintertodesignthelayout

of the report.

Defining Characteristics for Rows and Columns

RowsandColumns: Inputoptionsforrowsandcolumns

270

第 289 页 / 共 509 页

AC220 Lesson: Report Painter Components

Figure 113: Rows and Columns

Youcandefinearowusingacombinationofcharacteristicvaluesoraformula.

Row formulae can only refer to other rows.

Columnscontainacombinationofakeyfigure(numericalvalue)withadditional

optionalcharacteristicvalues. YoucanalsousepredefinedKeyFigurecolumns,

which represent business-related combinations of basic key figures and

characteristics,suchasPlanLocalCurrency,AccumulatedToPeriod,andVersion

XXX.

EnteringReportRows: Selectthecharacteristicsthatyouwanttouseinyour

report rowsand enter the appropriate valuesfor these characteristics. You can

enteravalue,anintervalofvalues,agroup(set),oravaluevariable. Youcanalso

set the variable for each characteristic.

271

第 290 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Figure 114: Entering Report Rows

Youselectthecharacteristicsthatyouwanttouseinyourreportrowsandenter

the appropriate valuesfor thesecharacteristics.

Youcanenteravalue,anintervalofvalues,agroup(set),oravaluevariable. In

addition, youcansetthevariableforeachcharacteristic.

EnteringReportColumnsandFormula: Youneedtoselectthecharacteristics

thatyouwanttouseforthereportcolumnsandaspecifickeyfigure. Alternatively,

youcan select a predefinedcolumn. If required, youcan overwritethedefault

values. You can enter a value, an interval of values, a group (set), or a value

variable. Youcanalsosetvariableforeachcharacteristic. Youcanuseformulae

inareportroworcolumn. Theroworcolumnnumbersareusedastheoperands

intheformula. Youcanusetheformulaeditortodefineformulae. CreateaReport

G00-REP1withonesection,‘Revenues‘. Therowsshouldcontainthreeaccounts:

810200, 810300,and810400withaformulaforthetotal.

272

第 291 页 / 共 509 页

AC220 Lesson: Report Painter Components

Figure 115: Entering Report Columns

Selectakeyfigureorthecharacteristicstobeusedforthereportcolumnsandyour

basickeyfigure. Ifrequired,youcanoverwritethedefaultvalues.

Youcanenteravalue,anintervalofvalues,agroup(set),oravaluevariable. You

can also set the variablefor each characteristic.

Figure 116: Formula

273

第 292 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Defining Characteristics for the Entire Report

GeneralSelection: Selectioncriteriaforvaluesor groupsof values, whichare

applicable for the whole report. After you define the rows and columns, you

definethecharacteristicsandvaluesthatyouwanttouseasgeneraldataselection

criteria. Thesecharacteristicsarevalidfor theentirereport andarenotusedin

the rows or columns.

Figure 117: General Selection:

Afteryoudefinetherowsandcolumns,youdefinethecharacteristicsandvalues

thatyouwanttouseasgeneraldataselectioncriteria. Thesearethecharacteristics

thatarevalidfortheentirereport. Asaresult,thecharacteristicsarenotusedin

the rows or columns.

ExplodingReport Rows: You candefinea rowbyentering acombination of

characteristicvaluesoraformula. Inthefirstcase,whenusinggroupsorseveral

singlevalues, youcanalsodeterminewhether or not:

1. Only one summary row isto be displayed

2. Thecompletegrouphierarchywithallsubtotalsistobeexploded

3. All values in a row are to be displayed

274

第 293 页 / 共 509 页

AC220 Lesson: Report Painter Components

Figure 118: Exploding Report Rows

You can define a row by entering a combination of characteristic values or a

formula.

In the first case, when using groups or several single values, you can also

determine whether or not:

• Only one summary row is to bedisplayed

• Thecompletegrouphierarchywithallsubtotalsistobeexploded

• All values in a row are to be displayed

Demonstration: Demonstration of Report Painter

Purpose

To demonstrate the report painter

System Data

System:

Client:

UserID:

Password:

Setupinstructions:

1.

Note: Ifyouwish,youcoulddemonstrateashortexampleofhow

to set up a report and execute a report group for your new totals

table ZSLTABT.

GenerateaSingleItemsDrill-DownReportforyournewtable.

275

第 294 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Run the report RGRGENSI to create drilldown reports for the actual

and planned item tables corresponding to ZSLTABTABAP-Names (z.B.

ZSLTABEP(Actual)andZSLTABPP(Plan). Then,createaLibraryL00to

ZSLTABTwiththeseelements. IncludetheABAPreport,ZSLTABEP,inthe

headerofthelibraryunderReport/Reportinterface.

Explain that by doing this, all the report groups assigned to this library

will then be able to transfer data to this ABAP for a summary record

representationandforalineitemdisplayalso. TheReport/Reportinterface

can also be added to the header of the report group. If this is done, this

takes priority for the report group.

2. CreateanexamplereportG00-REP1inyourLibraryL00.

General Selection: Ledger ZZ,Version1, Co.CodeAC00, current period

and current year.

Row: Basic-Set: G00-FAREASSingle-SetG00-OVERHEAD

Sequence: RFAREA(1), RACCT(2)bothexploded

Column: Local Currency Actual

Save report.

ProcessingReport Groups: Reportsareincludedinareportgroup, which

groupstogether severalreports. Allthereportsmustusethesamelibrary.

Thereportgroupisthengenerated. Basedonthereportgroup,thesystem

createsABAPreports, whichcanthenbeexecuted.

Dataselection: Thevalueorsetvariablesthatyouhaveusedinyourreports

aredisplayedontheselectionscreen. Preparation(output) of theselected

data. You can save the selected data under a specific name to repeat the

report output. You can enter a password for this data extract to prevent

unauthorized users fromaccessing thedata.

Multipleselection: Ifyouhaveusedvariablesinyourreportdefinition,you

candisplayseveralreportsbyselectingaseriesofinputdata.

3. CreateareportgroupREP1toL00andincludeyourreportG00-REP1.

Save,generate,andexecute. Showadrilldowntotheitems.

Please refer to the courses: CA705-Basics Report Painter and CA710-:

Advanced REPORT WRITER.

276

第 295 页 / 共 509 页

AC220 Lesson: Report Painter Components

Facilitated Discussion

To discuss report painter components

Discussion Questions

Usethefollowingquestionstoengagetheparticipantsinthediscussion. Feelfree

to use your own additional questions.

Discuss the report painter components.

277

第 296 页 / 共 509 页

Unit6: SetsandBasicFeatureOftheReportPainter AC220

Lesson Summary

You should now be able to:

• Selectthereportpaintercomponentsforreportrowsandcolumns

• Select the characteristicsfor theentire report

278

第 297 页 / 共 509 页

AC220 Unit Summary

Unit Summary

You should now be able to:

• Describe how to use sets

• Describethefeaturesof basicsetsandsinglesets

• Selectthereportpaintercomponentsforreportrowsandcolumns

• Select the characteristicsfor theentire report

279

第 298 页 / 共 509 页

UnitSummary AC220

280

第 299 页 / 共 509 页

AC220 Test Your Knowledge

Test Your Knowledge

221

1. Setscontainvaluesor foraspecificfield.

Fillintheblankstocompletethesentence.

2. Whichoftheseareexamplesofsingle-dimensionsets?

Choosethecorrectanswer(s).

□ A P and L accounts

□ B Balance Sheet

□ C Personnel accounts

□ D Admin.accounts

3. You can enter a value, an interval of values, or a group (set), or a value

variableorasetvariableforthe inthereport.

Fillintheblankstocompletethesentence.

4. Generaldataselectioncriteriacharacteristicsarethecharacteristicsthatare

valid for the report rows and columns.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

281

第 300 页 / 共 509 页

TestYourKnowledge AC220

Answers

222

1. Setscontainvaluesorvalueintervalsforaspecificfield.

Answer: value intervals

2. Whichoftheseareexamplesofsingle-dimensionsets?

Answer: A, C

PandLAccounts,Personnelaccounts,andAdmin. accountsareexamples

of single-dimension sets.

3. You can enter a value, an interval of values, or a group (set), or a value

variableorasetvariableforthecharacteristicinthereport.

Answer: characteristic

4. Generaldataselectioncriteriacharacteristicsarethecharacteristicsthatare

valid for the report rows and columns.

Answer: False

Generaldataselectioncriteriacharacteristicsarethecharacteristicsthatare

valid for the entire report.

282

第 301 页 / 共 509 页

Unit 7

Planning

223

Explain how to set up the prerequisites for planning. Demonstrate how to

investigatetheplanninglayoutsandprofiles. Thenexplainhowtoenterplandata

andexecutereportsontheplandataasacomparison totheactualdataalready

stored.

Unit Overview

Thisunitwillhelpyouunderstandhowtosetuptheprerequisitesfor planning.

Youwilllearnhowtoinvestigatetheplanninglayoutsandplanningprofiles. The

unitwillalsoprovideinformationonhowtoenterplandataandexecutereportson

theplandataasacomparisontotheactualdataalreadystored.

Unit Objectives

After completing thisunit, you will beableto:

• UsetheActivateLineItemsfunctiontoupdateplanlineitems

• Usedistributionkeystodistributeplanningtotalstoindividualperiods

• Entertheplanningvaluesusingvariousfunctions

Unit Contents

Lesson: Settings in FI-SL Planning...........................................284

Demonstration: Settings in FI-SL Customizing.........................305

Exercise 12: FI-SL Planning .............................................307

283

第 302 页 / 共 509 页

Unit7: Planning AC220

Lesson: Settings in FI-SL Planning

Lesson Duration: 150 Minutes

224

Lesson Overview

Thislessondescribeshowtousetheactivatelineitemsfunctiontodecidewhether

or not you needto updateplanlineitemsinyour plansummaryrecord. It also

describeshowtousedistributionkeystodistributeplanningtotalstoindividual

periods. Italsoexplainshowtoenterplanningvaluesusingthefunctionsavailable.

Lesson Objectives

After completingthislesson, you will beable to:

• UsetheActivateLineItemsfunctiontoupdateplanlineitems

• Usedistributionkeystodistributeplanningtotalstoindividualperiods

• Entertheplanning valuesusingvariousfunctions

Planning: SettingsApathfindershowingthecompletelistofFI-SLrequirements

before plan data can be entered.

Note: Duetoaprogrammingchangein4.6BintheMaster-Data-Validation

logic, an entry of the account number in the Layout will require the

CompanyCodetobeentered. Toenableyouandtheparticipantstoenter

theaccountnumberalone,removetheentryforsuperiorfieldRBUKRS

for field RACCT, Table ZSLTABT in T800d (Transaction GCS1) and

save. Donotforgettore-enterRBUKRSasthesuperiorfieldtoRACCT

forZSLTABTbecausethisvalidationwillberequiredfortheallocation

chapter and future report writer text.

The other alternative, would be to enter the general selection

characteristicswithcompanycodefirstbeforedemonstratingtheexplicit

layoutentries. Asaresult,youwouldbebypassingtheneedtoenterthe

companycodewiththeaccountdimension. However,theparticipantsin

their exerciseenterthegeneralselectioncriterialast,andthereforewill

always run into the Co.Code message when trying to put the account

dimension in the layout column.

Business Example

Field managers need to present the revenue and expense plans for each

geographical area to the corporate group. Using FI-SL planning, the field

managersmustgeneratedetailedmonthlyplansforvariousrevenueandexpense

categories. Plansaretobeinbothlocalandgroupcurrencyandbaseduponthe

seasonal fluctuationsof their geographical areas.

284

第 303 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Overview of Planning

Figure 119: Planning: Overview

Figure 120: Planning: Default Settings

285

第 304 页 / 共 509 页

Unit7: Planning AC220

Plan Periods

Similartoactualdata,thevariantisappropriateforoneormorecompanycodes

asan argument tofindtheallowed planperiods. You can definetworangesof

valid periods.

Figure 121: Plan Periods Variants

Youmustspecifyvalidplanperiodsforyourcompanycodesorglobalcompanies.

You can define two ranges of valid periods.

Plan Versions

EachledgercanstoreanynumberofVERSIONSofplanningdata. Thisallows

youtocompareparallelplanningbasedondifferentvaluesandquantities. After

decidingonaplanversion,youmustspecifywhetherornotplanningisallowed

foraspecificfiscalyearforthecombinationofledger,version,andcompanycode

(or global company).

286

第 305 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Figure 122: Plan Versions

Eachledgercanstoreanynumberofplanningdataversions.

Thisallowsyoutocompareplanningbasedondifferentvaluesandquantities.

TheplanversionscanbeevaluatedusingtheReportWriterwithorwithoutactual

results.

Figure 123: Version Parameters

PlanninginFI-SLiscarriedoutforlocalledgers(companycode)orgloballedgers

(global company).

287

第 306 页 / 共 509 页

Unit7: Planning AC220

After choosing a plan version, you must specify whether or not planning is

allowed for a specific fiscal year for the combination of ledger, version, and

company code (or global company).

Plan Line Items

Optional“history”ofchangestoplanning. PlanningParameters

Figure 124: Planning: Line Items

UsingtheActivateLineItemsfunction,youcandecidewhetherornotyouwant

toupdateplanlineitemsinyourplansummaryrecords.

The line items document the plan changes.

You need adocument typefor theplanlineitems.

Thedocumenttypecontrolsthedocumentnumberassignment.

Ifyoualreadyhaveaplanningtotalbalancethatwouldbeupdatedwithoutline

items, thisbalancecan betransferredaslineitems.

Distribution Keys

TheStandardDistributionKeysareillustratedwithanexampleforauser-defined

distribution key.

288

第 307 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Figure 125: Standard Distribution Keys

Adistributionkeyisusedtodistributetheplanningtotalstotheindividualperiods.

You can work with the standard distribution keys that are delivered with your

system, for example:

• Equal distribution

• Analog distribution

• Percentage distribution

• Distributionorcopyingofvaluestothenextemptyperiods

• Distributionaccordingtothenumberofdaysinamonth

Figure 126: Individual Distribution Key

289

第 308 页 / 共 509 页

Unit7: Planning AC220

Usingcompany-specificdistributionkeys,youcandefinerelativefactorsforeach

planning period. The system interpretsthe value entered as the total planning

valueand distributesthisvaluetotheindividual planning periodsaccording to

the relative factors.

This allows you to take into account seasonal fluctuations, shift schedules, or

other weighting criteria.

Youcanenterdistributionkeysasdefaultvaluesbeforeplanningoryoucanenter

them during planning.

Exchange Rates and Translation

TCURR specification: Determination of the exchange rates with an exchange

ratetypeforthecurrencyamountsthatarenotenteredmanually. Youcanstore

planningvaluesintransactioncurrency,secondcurrency,andthirdcurrencyfor

thecharacteristicsbeingplanned. Youcanalsostoreplanningvaluesinunitsof

measureandadditionalunitsofmeasure(iftheyarestoredinthecorresponding

ledger). Youcanspecifywhichcurrencyfieldgroupsshouldbeplannedmanually.

Thecurrencyamountsthatarenotplannedmanuallyarecalculatedautomatically

fromthetranslationofthetransactioncurrencytothesecondcurrencyandthen

to thethirdcurrency(TCURR table). In theexample, the transactioncurrency

amount,150,000(GBP,USD),istranslatedusingexchangerate0.40tothesecond

currencyamount,60,000(EUR);thesecondcurrencyamountistranslatedusing

exchangerate0.60tothethirdcurrencyamount,36,000USD(thethirdcurrency

istheledgercurrency). Ifyourledgerstoresquantitybalancesandyouwantto

enter quantities, thesemust be plannedmanually.

Figure 127: Exchange Rates: Exchange Rate Type

290

第 309 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

For currency translation in FI-SL planning (transaction currency → currency

2/currency3)youcanenteryourownexchangeratesinthecurrencytable. You

canthendifferentiatethesefurtherwithanexchangeratetype.

Whileenteringtheentryoftheplanvalue,thecurrencytableisreadinconjunction

with the exchangeratetype. Exchange ratesaredetermined for each planning

period (thestart dateof theperiod isimportant).

Plan Layouts

ManualPlanning: PlanningLayouts: Aplanninglayoutconsistsofaheader

andseveralleadandvaluecolumns. Generalselectioncriteriaareenteredinthe

headerandthecharacteristicsthatwillappear intheheaderareaarechosen. In

theleadcolumn,enterthecharacteristicsforwhichyourequiretoenterplandata.

Youhavethefollowingoptionstodefinethevaluecolumns:

• Youcandefinecolumnswithakeyfigureand characteristicsorwithkey

figures only. Example of key figures: TSL (Transaction currency. HSL

(2.currency), KSL (3.currency), MSL (Quantity) and ASL (Additional

Quantity).

• Inanattributescolumn,theoptionsfortheUnit/CurrencyandDistribution.

PlanninglayoutsaredefinedinFI-SLCustomizing.

Planning Layouts: Header (1)

Youdefinecharacteristicsandcharacteristicvaluesthatarevalidforallrowsand

columnsofthelayoutGeneralselections. Youcandefinecharacteristicvaluesas

follows:

Specification of set characteristic values

Entryof“*”. Allvalidvaluesaredisplayedforacharacteristic.

Parameterizationofthecharacteristicvalueswithvariables. Variablesmakethe

layout flexible. You determine the default values when you define the default

parametersfor your layout in the plantask. You candeterminewhether or not

thesedefaultvaluescanbeoverwrittenwhilecreatingyourplanningdata.

Planning Layouts: Header (2)

Inadditiontotheindividualvaluesforyourcharacteristicsintheheaderarea,you

can also use intervals of values or sets.

Inthiscase,whilecreatingyourplanningvalues,youcaneitherscrollfromone

valuetotheotherordisplayalistofcharacteristicvaluesinyourintervalsorsets

andselectthevaluesforwhichyouwanttoentertheplanningvalues.

Lead columns

Definitionofoneormoreleadcolumnswiththeheader

291

第 310 页 / 共 509 页

Unit7: Planning AC220

Youcandefineexactlyonecharacteristicforeachleadcolumn. Ifyouchooseto

definetheleadcolumnusingelements,thesystemsuggestsallcharacteristicsthat

havenotyetbeenused. Forthischaracteristic,youcanchooseavalue,avariable,

anintervalofvalues(orvariables),aset,or“*”(allvalues).

If,forexample,youselectthecharacteristic,“functionalarea”,inthefirstcolumn

and“Account”inthesecondcolumn,the“functionalarea/account”combinations

for which dataexist aredisplayed duringplanning.

Planning example

Lead column 1 Lead column 2 Value column

Functional area Account Local currency

0100-0500 430000-432000n Each newlead column isinsertedbefore the lead

columnsthathavealreadybeendefined. Toarrangetheleadcolumns,selectEdit

→ Columns →> Sort lead columns.

Figure 128: Manual Planning - Planning Layout

InFI-SL,planningdataisenteredonentryscreens. Youcancustomizetheuser

interfacesofthesescreensusingCustomizingsettings. Theseentryscreensare

called planning layouts.

Planninglayoutscanbestructuredwithagreatdegreeofflexibility. Thisensures

that the entry of the planning datais simple and that ergonomicfactorscan be

considered. TheReportPaintercanbeusedtodefineplanninglayouts.

Aplanninglayoutconsistsofaheaderandseveralleadandvaluecolumns.

You enter the selection criteria in the header and determinethe characteristics

that are displayed in the header.

Intheleadcolumn,youdefinethecharacteristicsthatyouwanttoplan.

292

第 311 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Thefollowingoptionsareavailabletodefinethevaluecolumns:

Youcan enter columnseither with akey figure andcharacteristicsor with key

figures only. The key figures are contained in your tables. These are TSL

(transaction currency), HSL (currency 2), KSL (currency 3), MSL (quantity),

and ASL (additional quantity).

Aformulacolumnisavaluecolumndisplayingthecalculatedresultsfromother

value columns.

Inanattributecolumn,youhavetheoptionsfortheunitandthedistributionkey.

Theunitandthedistributionkeyaredisplayedasadditionalfieldsinacolumn.

YoudefineplanninglayoutsinFI-SL Customizing.

Figure 129: Planning Layout: Header (1)

You define characteristics and characteristic values that are valid for all rows

andcolumnsof thelayoutusingGeneralselections, for example, the valuesof

a version if the layout refers to only oneversion. General selections simplify

definitionandpreventerrorsandhelpprovideclarityinyourlayout.

Acharacteristicselectedfortheheaderareaisnolongeravailableforthedefinition

of rows and columns.

To determine the order in which the characteristics are displayed on the entry

screen in the header area, selectEdit → General selections→ Header layout.

Note that a maximum of nine selected characteristics can be displayed in the

header area for each layout.

Youcan definecharacteristic valuesasfollows:

Specification of set characteristic values

Entryof“*”. Allvalidvaluesaredisplayedforacharacteristic.

293

第 312 页 / 共 509 页

Unit7: Planning AC220

Parameterizationofthecharacteristicvalueswithvariables. Variablesmakethe

layout flexible. You determine thedefault values when you define the default

parameters for your layout in the plantask. You can determinewhether or not

thesedefaultvaluescanbeoverwrittenwhilecreatingyourplanningdata.

Figure 130: Planning Layout: Header (2)

Inadditiontoindividualvaluesforyourcharacteristicsintheheaderarea,youcan

use intervals of values or sets.

Inthiscase,whilecreatingyourplanningvalues,youcaneitherscrollfromone

valuetoanotherordisplayalistofcharacteristicvaluesinyourintervalsorsets

andselectthevaluesforwhichyouwanttoentertheplanningvalues.

Figure 131: Lead Columns

Definitionofoneormoreleadcolumnswiththeheader

294

第 313 页 / 共 509 页

AC220 Lesson: Settings in FI-SL Planning

Youcandefineexactlyonecharacteristicforeachleadcolumn. Ifyouchooseto

definetheleadcolumnusingelements,thesystemsuggestsallcharacteristicsthat

havenotyetbeenused. Forthischaracteristic,youcanchooseavalue,avariable,

anintervalofvalues(orvariables),aset,or“*”(allvalues).

If,forexample,youselectthecharacteristic,“functionalarea”,inthefirstcolumn

and“Account”inthesecondcolumn,the“functionalarea/account”combinations

for whichdataexist are displayedduringplanning.

Planning example

Lead column 1 Lead column 2 Valuecolumn

Functional area Account Local currency

0100-0500 430000-432000

Each new lead column is inserted before the lead columns that have already

beendefined. Toarrangetheleadcolumns,selectEdit→Columns→Sortlead

columns.

Figure 132: Individual Lines

Definitionofexactlyoneleadcolumnthroughtherows

This type of definition involves defining each row separately. You can define

a key figure or formula for each row or characteristic. Definition is the same

as with value columns.

Example for quarter planning (above):

Lead column Value column

Version/Quarter Local currency

Version 1/Quarter 1

Version 2/Quarter 1

295