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

第 1 页 / 共 319 页

AC280

Analytics & Reporting in Financial

Accounting

SAP Financials

Date

Training Center

Instructors

Education Website

Participant Handbook

Course Version: 92

Course Duration: 3 Day(s)

Material Number: 50093769

An SAP course - use it to learn, reference it for work

第 2 页 / 共 319 页

Nopartofthispublicationmaybereproducedortransmittedinanyformorforanypurpose

withouttheexpresspermissionofSAPAG.Theinformationcontainedhereinmaybechanged

withoutpriornotice.

SomesoftwareproductsmarketedbySAPAGanditsdistributorscontainproprietarysoftware

componentsofothersoftwarevendors.

Trademarks

• Microsoft®,WINDOWS®,NT®,EXCEL®,Word®,PowerPoint®andSQLServer®are

registeredtrademarksofMicrosoftCorporation.

• IBM®,DB2®,OS/2®,DB2/6000®,ParallelSysplex®,MVS/ESA®,RS/6000®,AIX®,

S/390®,AS/400®,OS/390®,andOS/400®areregisteredtrademarksofIBMCorporation.

• ORACLE®isaregisteredtrademarkofORACLECorporation.

• INFORMIX®-OnLineforSAPandINFORMIX®DynamicServerTMareregistered

trademarksofInformixSoftwareIncorporated.

• UNIX®,X/Open®,OSF/1®,andMotif®areregisteredtrademarksoftheOpenGroup.

• Citrix®,theCitrixlogo,ICA®,ProgramNeighborhood®,MetaFrame®,WinFrame®,

VideoFrame®,MultiWin®andotherCitrixproductnamesreferencedhereinaretrademarks

ofCitrixSystems,Inc.

• HTML,DHTML,XML,XHTMLaretrademarksorregisteredtrademarksofW3C®,World

WideWebConsortium,MassachusettsInstituteofTechnology.

• JAVA®isaregisteredtrademarkofSunMicrosystems,Inc.

• JAVASCRIPT®isaregisteredtrademarkofSunMicrosystems,Inc.,usedunderlicensefor

technologyinventedandimplementedbyNetscape.

• SAP,SAPLogo,R/2,RIVA,R/3,SAPArchiveLink,SAPBusinessWorkflow,WebFlow,SAP

EarlyWatch,BAPI,SAPPHIRE,ManagementCockpit,mySAP.comLogoandmySAP.com

aretrademarksorregisteredtrademarksofSAPAGinGermanyandinseveralothercountries

allovertheworld. Allotherproductsmentionedaretrademarksorregisteredtrademarksof

theirrespectivecompanies.

Disclaimer

THESEMATERIALSAREPROVIDEDBYSAPONAN"ASIS"BASIS,ANDSAPEXPRESSLY

DISCLAIMSANYANDALLWARRANTIES,EXPRESSORAPPLIED,INCLUDING

WITHOUTLIMITATIONWARRANTIESOFMERCHANTABILITYANDFITNESSFORA

PARTICULARPURPOSE,WITHRESPECTTOTHESEMATERIALSANDTHESERVICE,

INFORMATION,TEXT,GRAPHICS,LINKS,ORANYOTHERMATERIALSANDPRODUCTS

CONTAINEDHEREIN.INNOEVENTSHALLSAPBELIABLEFORANYDIRECT,

INDIRECT,SPECIAL,INCIDENTAL,CONSEQUENTIAL,ORPUNITIVEDAMAGESOFANY

KINDWHATSOEVER,INCLUDINGWITHOUTLIMITATIONLOSTREVENUESORLOST

PROFITS,WHICHMAYRESULTFROMTHEUSEOFTHESEMATERIALSORINCLUDED

SOFTWARECOMPONENTS.

g200952925129

第 3 页 / 共 319 页

About This Handbook

Thishandbookisintendedtocomplementtheinstructor-ledpresentationofthis

course,andserveasasourceofreference. Itisnotsuitableforself-study.

Typographic Conventions

American English is the standard used in this handbook. The following

typographic conventions are also used.

Type Style Description

Example text Wordsorcharactersthatappearonthescreen. These

includefieldnames,screentitles,pushbuttonsaswell

asmenunames, paths, andoptions.

Alsousedforcross-referencestootherdocumentation

both internal and external.

Example text Emphasizedwords or phrases in bodytext, titlesof

graphics, and tables

EXAMPLETEXT Names of elements in the system. These include

reportnames,programnames,transactioncodes,table

names, andindividualkey wordsof aprogramming

language,whensurroundedbybodytext,forexample

SELECT and INCLUDE.

Example text Screenoutput. Thisincludesfileanddirectorynames

and their paths, messages, names of variables and

parameters, and passages of the source text of a

program.

Example text Exactuserentry. Thesearewordsandcharactersthat

youenterinthesystemexactlyastheyappearinthe

documentation.

<Example text> Variableuserentry. Pointedbracketsindicatethatyou

replacethesewordsandcharacterswithappropriate

entries.

iii

Type Style	Description
Example text	Wordsorcharactersthatappearonthescreen. These includefieldnames,screentitles,pushbuttonsaswell asmenunames, paths, andoptions. Alsousedforcross-referencestootherdocumentation both internal and external.
Example text	Emphasizedwords or phrases in bodytext, titlesof graphics, and tables
EXAMPLETEXT	Names of elements in the system. These include reportnames,programnames,transactioncodes,table names, andindividualkey wordsof aprogramming language,whensurroundedbybodytext,forexample SELECT and INCLUDE.
Example text	Screenoutput. Thisincludesfileanddirectorynames and their paths, messages, names of variables and parameters, and passages of the source text of a program.
Example text	Exactuserentry. Thesearewordsandcharactersthat youenterinthesystemexactlyastheyappearinthe documentation.
<Example text>	Variableuserentry. Pointedbracketsindicatethatyou replacethesewordsandcharacterswithappropriate entries.

第 4 页 / 共 319 页

AboutThisHandbook AC280

Icons in Body Text

The following iconsareused in thishandbook.

Icon Meaning

Formoreinformation,tips,orbackground

Noteorfurtherexplanationofpreviouspoint

Exception or caution

Procedures

Indicatesthattheitemisdisplayedintheinstructor's

presentation.

Icon	Meaning
	Formoreinformation,tips,orbackground
	Noteorfurtherexplanationofpreviouspoint
	Exception or caution
	Procedures
	Indicatesthattheitemisdisplayedintheinstructor's presentation.

第 5 页 / 共 319 页

Contents

Course Overview......................................................... vii

Course Goals...........................................................vii

Course Objectives .....................................................vii

Unit 1: Standard Reports in General Ledger Accounting,

Accounts Receivable Accounting, and Accounts Payable

Accounting ..................................................................1

Information Systems....................................................2

Report Variants and Variables.........................................8

Unit 2: List Viewer ....................................................... 25

SAP List Viewer Design..............................................26

Selections..............................................................33

Changing the Screen Layout........................................47

Unit 3: AR/AP Information System................................... 59

The AR/AP Information System.....................................60

Customizing the AR/AP Information System......................67

Creating and Displaying Evaluations...............................81

Unit 4: Drilldown Reporting in Financial Accounting ..........105

Architecture of Drilldown Reporting................................107

Characteristics and Key Figures...................................112

Form Types...........................................................116

Navigation in Reports ...............................................122

Form and Report Definition.........................................131

Displaying Reports...................................................192

Report/Report Interface and Report Assignment................207

Unit 5: Insight into BW for Financial Accounting Queries ....215

SAP BW Architecture and InfoArea for Financials...............216

InfoCube for Financials..............................................225

Queries................................................................228

Exceptions, Conditions, and Other Query Properties...........262

Unit 6: Appendices .....................................................279

Appendix..............................................................280

第 6 页 / 共 319 页

Contents AC280

第 7 页 / 共 319 页

Course Overview

WhenyouareworkingintheSAPsystem,youdisplayandevaluateinformation

thatiscontainedinthedatabase. Youexportthisdatafromthedatabaseandedit

it using reports. In this course you will familiarize yourself with and execute

these reports.

Target Audience

Thiscourseisintendedforthefollowing audiences:

• Project team

• ITemployeeswhousetheevaluationoptionsinFI-GL,FI-AP,andFI-AR

• Consultants

Course Prerequisites

Required Knowledge

• AC010

• AC200

• Knowledge of Financial Accounting

Course Goals

This course will prepare you to:

• UseanumberofreportingtoolsinadditiontothestandardreportsthatSAP

provides. Inthiscourse, youwill not onlylearnhowtorunthesereports,

you will also use them.

Course Objectives

After completingthiscourse, youwillbeable to:

• Explain why reports are necessary

• Explain the significance of reporting tools

• Differentiate between:

• Standard reports provided by SAP, and

• Reports that you create yourself

vii

第 8 页 / 共 319 页

CourseOverview AC280

viii

第 9 页 / 共 319 页

Unit 1

Standard Reports in General Ledger

Accounting, Accounts Receivable

Accounting, and Accounts Payable

Accounting

Unit Overview

Which standard reports are provided in the SAP system in General Ledger

Accounting (FI-GL),AccountsReceivableAccounting(FI-AR),andAccounts

PayableAccounting(FI-AP)?Wheredousersfindthesereportsandhowdothey

start them with their own selection criteria? Howdo they save these selection

criteria? Userswanttobeabletodisplaystandardlistswithminimumeffort.

Unit Objectives

After completing thisunit, you will beableto:

• DemonstratewheretofindthereportsrequiredinGeneralLedger,Accounts

Receivable, andAccountsPayableAccounting

• Explain the importanceof informationsystems

• Execute reports

• Create report variants

• Use report variables

Unit Contents

Lesson: Information Systems ....................................................2

Lesson: Report Variants and Variables.........................................8

Exercise 1: Report Variants and Variables...............................13

第 10 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Lesson: Information Systems

Lesson Overview

In this lesson, you will learn about the different selection criteria available

to search for reports in General Ledger Accounting, Accounts Receivable

Accounting, and AccountsPayable Accounting.

Lesson Objectives

After completingthislesson, you will beable to:

• DemonstratewheretofindthereportsrequiredinGeneralLedger,Accounts

Receivable, andAccountsPayable Accounting

• Explain theimportanceofinformation systems

• Execute reports

Business Example

EmployeesinGeneralLedgerAccounting,AccountsReceivableAccounting,and

AccountsPayableAccountingwanttousedifferentreportstoaccesstheirdata.

Figure 1: Where Are the Reports?

第 11 页 / 共 319 页

AC280 Lesson: Information Systems

Youcanfindthereportsyourequireinvariousplacesinthesystem:

• Youcanaccessimportantreportsusingtheinformationsystemforeach

area (General Ledger, Accounts Receivable, Accounts Payable) and on

the general report selection screen.

• Reportsarealsoincludedinrole-basedusermenus.

• UnderSystem, chooseSystemServices→Reporting. ThegeneralABAP

program execution screen appears and you can enter the report name. If

youdonotknowthetechnicalnameofthereport,youcanuseF4helpand

placeholders (for example, RFD*) to obtain an overview of the reports

containedinGeneralLedger,AccountsReceivable,andAccountsPayable

Accounting,inadditiontothereportsintheinformationsystemforeacharea.

Figure 2: Report Names

Youcanoften work out the namesofthestandardreportsfrom thelettersthey

contain. Forexample, thenameofthevendoraccountlistisRFKKVZ00, the

name of the customer account list is RFDKVZ00, and the name of the G/L

account list is RFSKVZ00.

The reportsthat start withRF aredifferentiated by account type. Reportsstart

withRFK_____(forvendors),RFD_____(forcustomers),RFS_____(forG/L

accounts), andRFB_____(for document reports).

To display program documentation, choose I.

第 12 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Figure 3: Accounts Payable Information System: Reports for Accounts

Payable Accounting

TheAccountsPayableinformationsystemissplitintoreportsforvendorbalances,

vendoritems, master data, and payment transactions. Thisinformation system

containsallthekeyreportsthatyouneedasanaccountspayableaccountant.

InDynamicSelections,youhavevariousselectionoptions(forexample,industry,

account group, country, city, and so on).

Ifyouusethesearchhelp, youwillalsoreceivecomplexselectionoptionsthat

you can use for different reports.

第 13 页 / 共 319 页

AC280 Lesson: Information Systems

Figure 4: Accounts ReceivableInformation System: Reports forAccounts

Receivable Accounting

Whenyouusetheselectionsandoutputcontrol,youcanrestrictthedatadisplayed

inthelist. Forexample,forreportRFDUML00,CustomerSales,youcancreate

acurrentorhistoricalcustomerlistthatissortedbythecustomer'ssales. Todo

this,chooseAdditionalSelectionsandenterappropriateintervalsbeforeyourun

the report.

Whenyouenterthesales,youcanusesinglevaluesorrangesbyselectingand/or

excluding single values and ranges.

Figure5: GeneralLedgerInformationSystem: GeneralLedgerReports

第 14 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

The G/L account balance list displays the selected totals figures by reporting

period. Youcanseethecarryforwardbalanceatthestartofthefiscalyear,thetotal

forthecarryforwardperiod,thedebitandcredittotalforthereportingperiod,and

thedebitandcreditbalancesattheendofeachreportingperiod.

Attheendofthelist, youcanseethetotalforeachcompanycodeandthefinal

total forallcompanycodesfor eachlocalcurrency.

Youcanchooseasortingmethodthat alsoallowsyoutosummarizedatausing

summarizationlevels. Forexample,youcansummarizedatabybusinessareaor

G/L account.

第 15 页 / 共 319 页

AC280 Lesson: Information Systems

Lesson Summary

You should now be able to:

• DemonstratewheretofindthereportsrequiredinGeneralLedger,Accounts

Receivable, andAccountsPayableAccounting

• Explain the importanceof informationsystems

• Execute reports

第 16 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Lesson: Report Variants and Variables

Lesson Overview

Inthislesson,youwilllearnhowtocreateandusereportvariables.

Lesson Objectives

After completingthislesson, you will beable to:

• Create report variants

• Use report variables

Business Example

EmployeesinGeneralLedgerAccounting,AccountsReceivableAccounting,and

AccountsPayableAccountingwanttousedifferentselectioncriteriatoaccesstheir

dataset. Employeesneedtobeabletosavetheseselectioncriteria(someofwhich

willnotchangeforalongtime)sothattheycanaccessthedataquicklyandeasily.

Figure 6: Report Variants: Selection Criteria

You can definemultiple report variants for one report. These report variants

contain different selection criteria. A variant is a selection memory for a

specific quantity of saved selection criteria. Instead of entering values for

selectioncriteriaeach timeyoustart the report, you enter thevaluesonly once

andthensavethevariant. Thenexttimeyouexecutethereport,youcanusethe

variant. Theoptionofcreatingvariantswithyourownselectioncriteria,thereby

reducing time and effort later, is particularly useful for reports that are used

frequently or periodically.

第 17 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Areportcanthereforehavedifferentreportvariants,eachofwhichprovidesa

specifictypeofinformationbasedontheselectioncriteriathatyoudefine. For

example,forreportRFKKVZ00(VendorAccountList),youcanuseonevariant

for domesticvendorsandanotherforforeignvendors.

First, enter the required selection criteria on the selection screen. The options

availablefor theselectioncriteriaintheindividualreportsareexplainedin the

following figures.

Choose Goto →Variants →Save asvariant.

Figure 7: Report Variants: Attributes

Enter variant attributes for your variant; first a Variant name, and then the

Description.

IfyouselecttheOnlyforbackground processingfield, thenthevariant isonly

permittedforbackgroundprocessing. Ifyou do notselectthefield, thevariant

ispermittedfor background andonlineprocessing.

IfyouselecttheProtectvariantfield,thenonlyyoucanchangethevariant.

SystemvariantsareonlydisplayedinthecatalogandnotinF4InputHelpifyou

select the relevant indicator.

Youcanassigncertainpropertiestosomefields. Forexample,youcanprotecta

field,hideafield, ormakeafieldarequiredentryfield.

第 18 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Figure 8: Report Variants: Selection Variables

Insteadofenteringvaluesforselectioncriteriaeachtimeyoustartareport,youcan

enterthevaluesonlyonceandthensavetheminavariant. Ifyoucallupthereport

anduseavariant,butstillwanttodisplaycertainvaluesuptothecurrentdate(for

example,openitemsuptoacertainkeydate),youcanuseselectionvariables.

If,forexample,youwanttoseealltheitemsuptoaspecifickeydateinareport,

youcanchoosetheSelectionVariablepushbuttonwhenmaintainingattributes

ormorespecificallywhenmaintainingtheselectionscreenobjectsandthenyou

can choose the type of selection variable.

Currently,thefollowingtwotypesofselectionvariablesaresupported(butnot

for each selection criterion):

• Table variables from TVARV

• Dynamic date calculation

第 19 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Figure 9: Table Variables

TablevariablesfromTVARV:Youusethesevariableswhenyoustorestatistical

informationthatcanbeusedindifferentreports. Thismeansthatwhenyousave

the attributes for the variant, you can maintain parameters in table TVARV

thatcontainyour selectionoptions, single values, and/or intervalsbychoosing

Maintainenvironment→Selectionvariables. Onceyouhavemaintainedthese

selectionvariablesintableTVARV,youcanusetheminanyotherreportvariants

and reports.

Figure 10: Dynamic Date Calculation

第 20 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Dynamic date calculations:

The prerequisite for using these variables is that the corresponding selection

criterionintheprogramistypeD(date). Ifyouchangetheselectionvariablefrom

typeTtotypeD,theNameofVariablesfieldisnolonger readyforinput. You

can only set values using input help.

第 21 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Exercise 1: Report Variants and Variables

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Create report variants

• Use report variables

Business Example

Youwanttoreplicatethesamereportusingthesameselectioncriteria.

Task 1:

CreateavariantforreportRFBELJ00(compactdocumentjournal).

1. Createareportvariantwiththenameanddescription AC280-1-## (##

=yourgroupnumber)forthecompactdocumentjournalRFBELJ00such

thatonlydocuments0100000000to0199999999aredisplayedincompany

code 1000 in the current fiscal year.

Executethisreport withyour report variant.

2. Change yourvariant with name and description AC280-1-## such that

yourvariantisprotected. Thecompanycodemustnotbechangeable.

Thefiscalyearisarequiredentryfieldandthedocumentnumberranges

must not contain just documents 0100000000 to 0199999999, but also

documents1700000000to1799999999and1800000000to1899999999.

Forthepostingdate,chooseadynamicdatecalculation,withtheposting

datefromthebeginningofthemonthtotoday.

Hide all other fields.

Task 2:

Togroupthemanyvendorsinameaningfulway,theaccountshavebeensplitinto

accountgroups. Toobtainanoverviewoftheexistingvendormasterrecords,you

want a list containing specific vendors.

1. UsingreportRFKKVZ00,createareportvariantAC280-2-##(##=your

groupnumber) with alist of allvendorsinaccount group LIEFthat are

located in Berlin.

Onlyvendorsincompanycodes1000,2000,2200,3000,4000,5000,and

6000 are to be included. Since this company code range is also relevant

to other reports and you do not want to maintain these company codes

individuallyineachselectionvariant,useselectionvariables.

Continued on next page

第 22 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Createtheselection variableAC280_GR##.

Task 3:

Optional:

1. To be able to perform a targeted advertising campaign, you are asked to

createalistofcustomersinhightechindustries(HITE)andmechanical

engineering (MBAU) with sales between 2,000,000 and 1,000,000

currency units (an entry that you should protect in the variant) in the

periodsofthecurrent fiscal year incompany codes1000, 2000, 2200,

3000, 4000, 5000, and 6000.

YouwanttodisplaythedataincurrencyUSD,withexchangeratetypeM

fortranslationofexchangeratesatthecurrentkeydate.

CreateavariantwithnameanddescriptionAC280-3-##(##=yourgroup

number).

Task 4:

1. Specifythemenupathforthereportdocumentation.

第 23 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Solution 1: Report Variants and Variables

Task 1:

CreateavariantforreportRFBELJ00(compactdocumentjournal).

1. Createareportvariantwiththenameanddescription AC280-1-## (##

=yourgroupnumber)forthecompactdocumentjournalRFBELJ00such

thatonlydocuments0100000000to0199999999aredisplayedincompany

code 1000 in the current fiscal year.

Executethisreport withyour report variant.

a) Create a report variant:

Menupath: System→Services→Reporting

(or in the SAP Easy Access menu:

Accounting → Financial Accounting → General Ledger →

InformationSystem→GeneralLedgerReports(New)→Document

→General→Compact Document Journal

Fieldnameordatatype Values

Program RFBELJ00

Choose Execute.

Enter your selection criteria:

Fieldnameordatatype Values

Company code 1000

Document no. 0100000000 to

0199999999

Fiscal Year Current Year

Ledger 0L

Menupath: Goto→Variants→Saveasvariant...

Fieldnameordatatype Values

Variant AC280-1-##

Description AC280-1-##

Choose Save.

Continued on next page

Fieldnameordatatype	Values
Program	RFBELJ00

Fieldnameordatatype	Values
Company code	1000
Document no.	0100000000 to 0199999999
Fiscal Year	Current Year
Ledger	0L

Fieldnameordatatype	Values
Variant	AC280-1-##
Description	AC280-1-##

第 24 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Execute the report.

Menupath: System→Services→Reporting

(or in the SAP Easy Access menu:

Accounting → Financial Accounting → General Ledger →

InformationSystem→GeneralLedgerReports(New)→Document

→General→Compact Document Journal

ExecuteRFBELJ00withthenewvariantAC280-1-##.

Program: RFBELJ00

Program→Executewithvariant(orVariantbutton)

Variant: AC280-1-##

Enter

Execute

2. Change yourvariant with name anddescription AC280-1-## such that

your variant isprotected. Thecompanycodemustnotbechangeable.

Thefiscalyearisarequiredentryfieldandthedocumentnumberranges

must not contain just documents 0100000000 to 0199999999, but also

documents1700000000to1799999999and1800000000to1899999999.

Forthepostingdate,chooseadynamicdatecalculation,withtheposting

datefromthebeginningofthemonth totoday.

Hide all other fields.

a) Menupath: System→Services→Reporting

Fieldnameordatatype Values

Program RFBELJ00

Choose Goto → Variants.

Enter AC280-1-##

ChooseVariants→Change→Changevalues.

Afterthedocumentnumber,choosetheMultipleselectionbutton.

Choose the tab page Ranges

Enter0100000000 to 0199999999,

1700000000 to 1799999999,

and 1800000000 to 1899999999.

Choose Execute.

Continued on next page

Fieldnameordatatype	Values
Program	RFBELJ00

第 25 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

ChooseVariant→Attribute(ortheVariantAttributebutton).

Fieldnameordatatype Values

Protect variant Select

Company code Protect field

Fiscal year Required entry field

AllotherfieldsexceptPostingDate Choose Hidefield

Field name: Posting date

Pushbutton: Selectionvariable. Selection(matchcode: Selecticon)

Type of variable:

Select “D” (for dynamic datecalculation).

ChoosetheNamederVariablepushbutton(entriesonlypossibleusing

input help)

Double-click “Frommonth end totoday”.

Save the variant.

When the system displays the message “Do you want to overwrite

variant AC280-1-##?”, choose Yes.

ExecuteRFBELJ00withthechangedvariantAC280-1-##:

Program: RFBELJ00

Program→Executewithvariant(orVariantbutton)

Variant: AC280-1-##

ChooseEnter. Payattentiontotheselectionoptions

Execute

Task 2:

Togroupthemanyvendorsinameaningfulway,theaccountshavebeensplitinto

accountgroups. Toobtainanoverviewoftheexistingvendormasterrecords,you

want a list containing specific vendors.

1. UsingreportRFKKVZ00,createareportvariantAC280-2-##(##=your

groupnumber) with alist of allvendorsinaccount group LIEFthat are

located in Berlin.

Continued on next page

Fieldnameordatatype	Values
Protect variant	Select
Company code	Protect field
Fiscal year	Required entry field
AllotherfieldsexceptPostingDate	Choose Hidefield

第 26 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Onlyvendorsincompanycodes1000,2000,2200,3000,4000,5000,and

6000 are to be included. Since this company code range is also relevant

to other reports and you do not want to maintain these company codes

individuallyineachselectionvariant,useselectionvariables.

Createtheselection variableAC280_GR##.

a) Create a report variant:

Menupath: System→Services→Reporting: RFKKVZ00

(or in the SAP Easy Access menu:

Accounting → Financial Accounting → Accounts Payable →

Information System→ReportsforAccountsPayable Accounting

→ Master Data → Vendor List)

Report: RFKKVZ00

Choose Goto → Variants.

Fieldnameordatatype Values

Variant AC280-2-## (## = group

number)

Choose Variant → Create.

Choose Edit → Dynamic selections.

Select Account group

Pushbutton: ChoosetheCopyselected(arrow)button.

Account group: LIEF

WhenSelectionviasearchhelpappears, enter:

Search help ID: A (Vendors general)

City: Berlin

Enter

Choose Edit → Attributes.

Description AC280_2_##

ChooseEnvironment→Maintainselectionvariables.

Choose Variables → Change.

Youwillreceivethemessage,“Thetableiscross-client.”

Continued on next page

Fieldnameordatatype	Values
Variant	AC280-2-## (## = group number)

第 27 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Choose Enter.

Choose theSelection optionstab page.

Choose Edit → Create.

Name: AC280_GR##(##=yourgroupnumber)

Choosethe Multipleselection button.

Enter company codes 1000, 2000, 2200, 3000, 4000,

5000, and 6000

Choose Execute.

Choose Save.

Choose Back.

Field Name: Company code

Pushbutton: Selection variables

Typeofvariable: T:TablevariablesfromTVARV

Pushbutton: Nameofvariable(entryonlypossibleusinginputhelp)

Select AC280_GR## from the list

Save the variant.

ExecuteRFKKVZ00withthevariantAC280-2-##.

Program: RFKKVZ00

Program→Executewithvariant(orVariantbutton)

Variant: AC280-2-##

ChooseEnter. Payattentiontotheselectionoptions.

Choose Execute.

Task 3:

Optional:

1. To be able to perform a targeted advertising campaign, you are asked to

createalistofcustomersinhightechindustries(HITE)andmechanical

engineering (MBAU) with sales between 2,000,000 and 1,000,000

currency units (an entry that you should protect in the variant) in the

periodsofthe current fiscal year incompany codes1000, 2000, 2200,

3000, 4000, 5000, and 6000.

YouwanttodisplaythedataincurrencyUSD,withexchangeratetypeM

fortranslationofexchangeratesatthecurrentkeydate.

Continued on next page

第 28 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

CreateavariantwithnameanddescriptionAC280-3-##(##=yourgroup

number).

a) Report: RFDUML00

Variant with name and description AC280-3-## (## = your group

number)

Create a report variant

Choose

System→Services→Reporting: RFDUML00

or, in the SAP Easy Access menu, choose

Accounting → Financial Accounting → Accounts Receivable →

InformationSystem→ReportsforAccountsReceivableAccounting→

Customer Balances→ Customer Sales.

Report: RFDUML00

ChooseGoto→Variants→SaveasVariant.

Fieldnameordatatype Values

Variant AC280-3-## (## = group

number)

Choose Variant → Create

Choose Edit → Dynamic selections.

Industry: HITE(High Tech) and MBAU

Reporting periods: 1 to 16

Salesforaccount: 100to1,000,000currencyunits

Fiscal year: Current fiscal year

Translate in output currency: Select

Currency: USD

Exchange rate type: M

Date: Current date

Enter

Choose Edit → Attributes

Description: AC280-03-##

Field Name: Company code

Continued on next page

Fieldnameordatatype	Values
Variant	AC280-3-## (## = group number)

第 29 页 / 共 319 页

AC280 Lesson: Report Variants and Variables

Pushbutton: Selection variables

Asthevariabletype,chooseT:TablevariablesfromTVARV

Pushbutton: Nameofvariable(entryonlypossibleusinginputhelp)

Select AC280_GR## from the list

UnderSalesforaccount, chooseProtectfield.

ER_DATUM (translation date)

Pushbutton: Selectionvariable. Selection(matchcode: Selecticon)

Typeofvariable: Select“D”(fordynamicdatecalculation)andthen

choosetheNamederVariablepushbutton(entriesonlypossibleusing

input help)

Choose Current Date

Save the variant.

ExecuteRFDUML00withthevariantAC280-3-##.

Program: RFDUML00

Program→Executewithvariant(orVariantbutton)

Variant: AC280-3-##

ChooseEnter. Payattentiontotheselectionoptions.

Execute

Task 4:

1. Specifythemenupathforthereportdocumentation.

a) Choose Report documentation.

Onthereportselectionscreen,chooseHelp→Applicationhelp.

Help → Application help

Youhavecreatednewvariantsandworkedwith:

• Dynamic selections

• Selection variables

第 30 页 / 共 319 页

Unit1: StandardReportsinGeneralLedgerAccounting,AccountsReceivable

Accounting,andAccountsPayableAccounting AC280

Lesson Summary

You should now be able to:

• Create report variants

• Use report variables

第 31 页 / 共 319 页

AC280 Unit Summary

Unit Summary

You should now be able to:

• DemonstratewheretofindthereportsrequiredinGeneralLedger,Accounts

Receivable, andAccountsPayableAccounting

• Explain the importanceof informationsystems

• Execute reports

• Create report variants

• Use report variables

第 32 页 / 共 319 页

UnitSummary AC280

第 33 页 / 共 319 页

第 34 页 / 共 319 页

第 35 页 / 共 319 页

Unit 2

List Viewer

Unit Overview

How can users work efficiently with the List Viewer, for example, to display

theiropenitemlists? TheSAPvariantsareuseful,butusershavetheirownideas

about how the list should look.

Unit Objectives

After completing thisunit, you will beableto:

• Explain the concept SAP List Viewer

• Use the functionsof the SAP List Viewer

• Useselectioncriteriaforaccountsinwhichyouwanttofindlineitemsin

specific company codes

• Choose selection criteriausing search help

• Chooselineitemsbasedontheirstatusandcategory

• Changestandardanduser-specificscreenlayouts

Unit Contents

Lesson: SAP List Viewer Design ..............................................26

Lesson: Selections ..............................................................33

Exercise 2: Selections......................................................41

Lesson: Changing the Screen Layout.........................................47

Exercise 3: Changing the Screen Layout ................................51

第 36 页 / 共 319 页

Unit2: ListViewer AC280

Lesson: SAP List Viewer Design

Lesson Overview

IntheSAP List Viewer, you candisplay differentvariationsof documentsand

use different designs.

Lesson Objectives

After completingthislesson, you will beable to:

• Explain the concept SAP List Viewer

• Use thefunctionsof the SAP List Viewer

Business Example

The manager of the accounting department wants to know how to create

standardized lists in the SAP system. He also wants to learn more about the

functions of the SAP List Viewer.

Figure 11: SAP List Viewer: Line Item List

TheSAPListViewerisagenericdisplaytoolthatcreatesastandardergonomic

list from predefined data.

TheListViewerstandardizesandsimplifiestheuseoflistsintheSAPsystemby

providingauniforminterfaceandlistpreparationfunction.

YoucanusetheListViewertodisplaysimpleandhierarchicalsequentiallists.

第 37 页 / 共 319 页

AC280 Lesson: SAP List Viewer Design

TheSAPListViewercontainsanumberofinteractivefunctionssuchassorting,

summation, filters, and so on.

Youcanchangethelayoutoflistswithoutselectingdatafirstandsavethechanged

list layout in variants.

Figure 12: SAPListViewer: Display/Change Documents

The SAP List Viewer provides the following functions for displaying and

changing documents:

Select detail

To get detailed information for an item, you have to select it first. You can

thenusetheeyeglassesicon(ordouble-clicktheitem)todisplaytheindividual

document. Youcanalsocalluptheitemwiththepenciliconifyouwanttomake

changes to the document.

SelectitemsToselect an item, select itontheleft sideof thelineitemlist. To

selectmultipleitems,selectasingleitem,holdCtrl,andselecttheotheritems. To

select all the items, use the appropriateicon.

Onceyouhaveselectedmultipleitems,youcancarryoutamasschange inthe

correspondingdocuments. Toseethechangesinthelineitemlist,chooseRefresh

List. If changes fail, you can see the reasons in the Change errors log using

the corresponding pushbutton.

Youcanchoosewhetheryouwanttobranchtothedocumentitemvieworthe

document overview of the document display. The accountingediting options

contain a corresponding checkbox.

第 38 页 / 共 319 页

Unit2: ListViewer AC280

Figure 13: SAP List Viewer: Generic Functions

Someof thefunctions provided by theSAP List Viewer include the following

generic cross-application functions:

Selectcolumns: Toselectacolumn,youclickthecolumnheadingonce. Toselect

multiplecolumns,selectacolumn,holdCtrl,andselecttherequiredcolumns.

Youcansortthelistinascendingordescendingorder. Sortthelistbyselecting

therequiredcolumnandthenchoosingthecorrespondingfunction.

You can set and delete filters the same way.

Summation: Youcancreatetotalsandsubtotalsforspecificvalues. Createtotals

byselectingtherequiredcolumnandthenchoosingtheappropriateicon.

第 39 页 / 共 319 页

AC280 Lesson: SAP List Viewer Design

Figure 14: List Viewer: Display Variants and Fields

InadditiontothedisplayvariantsprovidedbySAP,youcanalsocreateyourown

displayvariants. Thisallowsyoutodefineyourownspecificviewofalist.

Youselectfieldsthatyouwanttoseefromthefieldsavailableinthecolumnset.

Youcanhidefieldsthatyoudonotrequire. Youcanalsosortfieldsinthecolumn

selection in the order that you require.

Youcanalsoaddspecialfieldstothecolumnsetinadditiontothefieldsthatare

alreadydisplayed. Formoreinformation,refertoSAPNotes215798and420591.

Ifyourequireoffsettingaccountinformation,refertoSAPNote112312. Thisis

notamodificationofthestandardsystem,butabusinesstransactionevent.

第 40 页 / 共 319 页

Unit2: ListViewer AC280

Figure15: ClassicListandGridControlin theLineItemList

Whenyoudisplaythelist,youcanchoosebetweentheALVclassiclistandthe

ALV grid control (grid design).

With some lists, you cannot switch between the two layouts; this is a special

feature of the line item list.

TheALVclassiclist isthelist that isdisplayedwhennospecificsettings have

been made.

TheALVclassiclistisessentiallytheprintscreenandoffersabetteroverviewof

thesortedlistwhentheitemsformultipleaccountsaredisplayed.

The grid control design has proportionate text and is particularly useful when

you display individual accounts online for Internet services offered by SAP

programs.

SinceSAPR/34.6C,usershavebeenabletoselectthegriddesignbychoosing

Settings → Switch List. This list design is entered in the user parameters

(parameter FIT_ALVC) whenyou switchthelist.

第 41 页 / 共 319 页

AC280 Lesson: SAP List Viewer Design

Figure 16: User Parameters for the List

Youcandisplay(andchangeifnecessary)thesettingsusingtransactionFB00,the

accountingeditingoptionsontheLineItemstabpage. Youcanalsodisplayand

change parameters using transaction SU3.

UsingparameterIDs,youcanenteruserdefaultvaluesinfieldswherethevalue

usuallyremainsconstant. If,forexample,youswitchthelisttogridcontrol,the

valuewillbesavedinyouruserparameters. Whenyoucallupthelist,thisvalue

appearsautomaticallyinthecorrespondingdesign. Thismeansthatyoudonot

havetomanuallyswitchthelistagain. Thenexttimeyoulogontothesystem,

you do not have tore-select therequiredlayout.

第 42 页 / 共 319 页

Unit2: ListViewer AC280

Lesson Summary

You should now be able to:

• Explain the concept SAP List Viewer

• Use thefunctionsof the SAP List Viewer

第 43 页 / 共 319 页

AC280 Lesson: Selections

Lesson: Selections

Lesson Overview

Participantscanusespecificselectioncriteriatochooselineitemsthattheywish

toanalyze. Theseselectioncriteria arerelated to:

• Theaccountsforwhichyouwanttoseelineitems;thesearecreatedwithin

specific company codes

• Selectioncriteriathatcanbechosenusingsearchhelpandtheselectionof

thelineitemsthemselves,basedontheirstatusandcategory

Lesson Objectives

After completingthislesson, youwillbeable to:

• Useselectioncriteriaforaccountsinwhichyouwanttofindlineitemsin

specific company codes

• Choose selection criteriausing search help

• Chooselineitemsbasedontheirstatusandcategory

Business Example

EmployeesworkinginAccountingwanttoknowhowtoselectitemsinlistsin

the SAP system.

It also wants to learn more about the selection criteria that can be used in the

SAP List Viewer.

Figure 17: Line Item List

第 44 页 / 共 319 页

Unit2: ListViewer AC280

You can use specific selection criteria to choose line items that you want to

evaluate.

These selection criteria refer to:

• Theaccountsinwhichyouwanttoseelineitemsinspecificcompanycodes

• Selectioncriteriathatyoucanchooseusingsearchhelp

• Theselectionoflineitemsthemselves,basedontheirstatusandcategory

Inaddition,youcanalsochoosethefollowingforthelistoutput:

• Layout

• Maximum number of items

Figure18: SelectionofG/LAccount, Vendor,andCustomer

WhenyoumakeyouraccountselectionforG/Laccounts,customeraccounts,and

vendoraccounts,youcanusesimpleandmultipleselectiontoincludeorexclude

individualaccountsandaccountintervalsfromtheselection.

If you select the Worklists Available field, you can activate and deactivate the

input fieldsforworklistson theselection screen for each lineitemlist. If the

worklistsexist,whenyouselecttheWorklistInputFieldsActivefieldwhenyou

call up the selection screen for the line item display, this selection screen is

displayedwithinputfieldsforworklists. Youcanmaintainthevaluesforworklists

using transaction OB55.

第 45 页 / 共 319 页

AC280 Lesson: Selections

Figure 19: Selection using Search Help

Ifyouselectitemsusingsearchhelp,thesystemprovidesinputhelpfortheG/L

account line item list:

• G/L account number in chart of accounts (also in combination with the

company code specification)

• G/L account name (G/L account long text) in chart of accounts (also in

combinationwiththecompanycodespecification)

• G/L accountswithdeletion andblockindicators

• Keywords

• Alternative account numbers

Whenyou select itemsusingsearchhelp, thesystem offersinputhelpforthe

vendor line item list:

• Generalvendor data(searchterm, postal code, city, name, andnumberof

vendor)

• Vendor country/company code

• Vendor by personnel number

• Vendor bypurchase, material, or plantreference

第 46 页 / 共 319 页

Unit2: ListViewer AC280

Whenyou select itemsusing search help, thesystem offersinput helpforthe

customer line item list:

• General customer data(searchterm, postal code, city, name, andnumber

of customer)

• Customer country/companycode/account group

• Customers with rental agreement

• Customersforeachsalesgrouporwithplantreference

• Head office customers

Figure 20: Item Selection

Youcanselectitemsforthelineitemlistbasedontheirstatusandcategory.

Whenyouselectopenitems,youselectitemsthatareorwereopenataspecific

time. Thecurrent dateis proposed by default.

IfyouchooseClearedItems,thesystemdisplaysitemsthatwereclearedbythe

clearingdatespecifiedandthatwerestillopenonthekeydate. Ifyoudonot

specifytheclearingdateandthekeydate,thesystemdisplaysallthecleareditems.

If you want to see open and cleared items, chooseAll Items. You can restrict

this selection using the posting date.

第 47 页 / 共 319 页

AC280 Lesson: Selections

Figure 21: Head Office/Branch

Insomeindustries,customerssubmitorderslocally--thatis,viathebranch--but

payinvoicescentrallythroughtheheadoffice. SAP differentiates betweenthe

flowofgoodsandtheflowof money. IntheSAP system, youcansetuphead

office and branch accounts.

All items posted to a branch account are automatically forwarded to the head

office account.

If you select the Branch/Head Office indicator, a dialog box appears for each

branchaccount. Inthedialogbox,youcanchoosewhetherthebranchcandisplay

items that are managed at the head office.

Ifyoudeactivatethedialogbox,thesettingmadeintheItemsManagedatHead

Office field applies automatically.