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

第 48 页 / 共 319 页

Unit2: ListViewer AC280

Figure 22: Selection by Net Due Date

Whenyoudisplaythelineitems,youcanmakeaselectionbynetduedate.

IfyouselecttheSelectionbyNetDueDatefieldintheeditingoptionsoftheuser

parameters, the system activates theinput fields for the selection by net due

date on the Selection screen.

Figure 23: Key for Icons

In the header of the ALV classic list, you can display the key for the icons

for the item status (open, parked, cleared), as well as the icons for the due

date (overdue, due, not due).

第 49 页 / 共 319 页

AC280 Lesson: Selections

Intheeditingoptionsforthelineitemsdisplay,youcanselectwhetheryouwant

to see these keys when you call up the list.

Comment: Thekeydateisthedeterminingfactorinclassifyingwhetheranitemis

openorcleared. Bybackdatinganitem,youcandisplaythestatusoftheitemona

keydateinthepast. Itemspostedafterthekeydatearenotdisplayed.

Figure 24: The Assignment Field as Sort Field

Inadditiontoselectingcolumns,whenyoucreateorchangethelayout,youcan

alsodefinesortcriteriaforsorting andcreatesubtotals.

Thesystemautomaticallyfillstheassignmentfieldforalineitemaccordingtothe

SortFieldentryinthemasterrecordwhenyoupostitems.

Theassignmentfieldcanbeacombinationofuptofourfieldswithamaximum

of18characters. Forexample, todisplaythedocumentnumber(10characters)

and the posting date (six characters), these field names can be included in the

assignment field definition.

IfyouchosethePurchaseOrderNumbersortkeyinthecustomer/vendormaster

record,theassignmentfieldforthelineitemcontainsthepurchaseordernumber

for customers/vendors.

IfyouselectedthesortkeyfortheCostCenterinageneralledgermasterrecord,

the assignment field in the corresponding G/L account item for the line item

containsthenumberofthecostcenterwhenyouposttothisG/Laccount.

第 50 页 / 共 319 页

Unit2: ListViewer AC280

Thelineitemsinthelineitemdisplayarefrequentlysorted by thevalueinthe

assignment field. A practical example:

• For example, when an invoice is posted in SD, an accounting document

is created in FI. The accounting document has a document number that

is usually not identical to the number of the invoice in SD. Using the

referenceandtheassignment,youcanfindouttheSDdocumentonwhich

theaccountingdocumentisbased. Thereferenceandtheassignmentinthe

FI invoicearecopiedfromthereferenceandassignmentintheSDbilling

document. You can define which numbers (purchase order, sales order,

delivery,billingdocument)arecopiedasareferenceandwhicharecopiedas

anassignmentintheSDdocumentandthencopiedintoFI.Youcanthenuse

these fields as selection criteria in FI.

第 51 页 / 共 319 页

AC280 Lesson: Selections

Exercise 2: Selections

Exercise Objectives

After completingthisexercise, youwillbeableto:

• UsetheSAPListViewer,usingthelineitemlistasanexample

• Findoutwhatselectioncriteriaappearintheselectionforthelineitemlist

Business Example

Theaccountingdepartment wantstoknowhowtoselectitemsfromlistsinthe

SAPsystem, andwhichselectionoptionsareavailable.

Task:

YouhavelearnedabouttheSAPListViewerasatoolforpreparingstandardized

lists,andnowyouwanttoinvestigatetheoptionsthetoolprovidesinyourwork

area. Youthereforelookatthecustomer lineitemlist.

Look at the customer line item list for customer1033 in company code 1000.

Selecttheopenitemsandchoosetoday'sdateasthekeydate.

1. Youwanttosorttheassignmentcolumn. Whatsortoptionsarethere? How

do you proceed?

2. Inaddition, youonlywant todisplay documentsthat containamountsup

to40currencyunits. Howcanyoudothis? Howdoyoudisplayallthe

documents again?

3. For customer 1033 you also want to display a totals line for a subtotal

according to the payment date.

4. Acolleagueinformsyouthatyoucanalsodisplaythelistingriddesign,in

additiontotheALVclassiclistdesign. Younowwanttousegriddesign.

5. YouwanttodisplaythePaymentDateandTermsofPaymentcolumnsnext

totheOpen/Cleared/ParkedItemsicon. Howcanyoumovethecolumn

to the required position?

6. You also want to enter the business area account assignment as an

additionalfieldinthelist. Youwanttodisplaythefieldtotheleftofthe

field for the text.

7. You do not want to have to move the columns or add new columns each

time, and so you want to create a display variant in which the required

fieldsare in the correct position and in which the business area account

assignment is also shown.

Continued on next page

第 52 页 / 共 319 页

Unit2: ListViewer AC280

Create an appropriate user-specific display variant and save it as

AC280-D-##(##=your groupnumber)withoutusingthedefault setting.

Display variant AC280-D-## (## = your group number) is called with

business area.

第 53 页 / 共 319 页

AC280 Lesson: Selections

Solution 2: Selections

Task:

YouhavelearnedabouttheSAPListViewerasatoolforpreparingstandardized

lists,andnowyouwanttoinvestigatetheoptionsthetoolprovidesinyourwork

area. Youthereforelookatthecustomer lineitemlist.

Look at the customer line item list for customer1033 in company code 1000.

Selecttheopenitemsandchoosetoday'sdateasthekeydate.

1. Youwanttosorttheassignmentcolumn. Whatsortoptionsarethere? How

do you proceed?

a) ChooseAccounting→FinancialAccounting→AccountsReceivable

→Account→Display/changelineitems(TransactionFBL5N).

Customer: 1033

Company code: 1000

Open items

Open at key date: Current date

Program → Execute

b) Youcansortthedisplayinascendingordescendingorder.

ChooseEdit→Sortinascendingorder/Sortindescendingorder

(Alternatively, place the cursor on the column and use the

appropriatebuttons(SortinascendingorderorSortindescending

order))

Continued on next page

第 54 页 / 共 319 页

Unit2: ListViewer AC280

2. Inaddition, youonly want todisplay documentsthatcontain amountsup

to40currencyunits. Howcanyoudothis? Howdoyoudisplayallthe

documents again?

a) Set filter/Delete filter:

Edit → Set filter

(or,placethecursoronthecolumnandusetheSetfilterbutton).

Localcurrency: EUR

Amounts: To 40

Enter

Then:

Edit → Delete filter

3. For customer 1033 you also want to display a totals line for a subtotal

according to the payment date.

a) Subtotal for payment date:

First, select another layout:

Settings →Display variant→ Choose

(or Select layout button)

Choose 1SAP-P

Placethecursor onthePaymentDatecolumn.

Edit → Subtotal

(or, choose Subtotals button)

4. Acolleagueinformsyouthatyoucanalsodisplaythelistingriddesign,in

additiontotheALVclassiclistdesign. Younowwanttousegriddesign.

a) Switch list:

Settings → Switch list

Continued on next page

第 55 页 / 共 319 页

AC280 Lesson: Selections

5. YouwanttodisplaythePaymentDateandTermsofPaymentcolumnsnext

totheOpen/Cleared/ParkedItemsicon. Howcanyoumovethecolumn

to the required position?

a) Payment Date and Terms of Payment columns after the

Open/Cleared/Parked Items icon:

Placethecursoronthecolumnanddragthecolumntotheappropriate

position(keepfingerontheleftmousebutton)

(or Settings →Displayvariant →Current:

movetheselectedlinesupwardsordownwardsusingthearrows).

6. You also want to enter the business area account assignment as an

additionalfieldinthelist. Youwanttodisplaythefieldtotheleftofthe

field for the text.

a) Additional field (Business area):

Settings →Display variant →Current:

Inthecolumnset(right): SelectBusinessarea

Move it to the column selection(left) using the arrowAdd selected

fields.

Movetheselectedlinesupwardsordownwardstotherequiredplace

using the arrows.

7. You do not want to have to move the columns or add new columns each

time, and so you want to create a display variant in which the required

fieldsare in the correct position and in which the business area account

assignment is also shown.

Create an appropriate user-specific display variant and save it as

AC280-D-##(##=yourgroupnumber)withoutusingthedefault setting.

Display variant AC280-D-## (## = your group number) is called with

business area.

a) Choose Settings→ Savedisplay variant.

Youcansavethevariantunderyourownname(AC280-D-##).

Save layout: AC280-D-##

Name: With business area

Select User-specific.

Choose Continue.

Thesystemissuesthefollowingmessage: “Layoutwassaved.”.

第 56 页 / 共 319 页

Unit2: ListViewer AC280

Lesson Summary

You should now be able to:

• Useselectioncriteriaforaccountsinwhichyouwant tofindlineitemsin

specific company codes

• Choose selection criteriausing search help

• Chooselineitemsbasedontheirstatusandcategory

第 57 页 / 共 319 页

AC280 Lesson: Changing the Screen Layout

Lesson: Changing the Screen Layout

Lesson Overview

Therearevariousstandardlayoutsthatyoucansupplement. Inthislesson,you

willlearnaboutstandardlayoutsanduser-specificlayouts.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Changestandardanduser-specificscreenlayouts

Business Example

Whendisplayingalist, accountantswanttochoosebetweendifferent(standard

and user-specific) layouts.

Figure 25: Layout

Whenyoudisplayalist,youcanchoosebetweendifferentlayouts.

SAP provides various standard layouts that you can supplement with other

(standard) layouts. Standard layouts start with a slash (/). You can choose a

standardlayoutasyourdefaultlayout. Iftheindicatorforadisplayvariantisset

as the initial variant, this variant is alwaysused for thelist output unlessyou

explicitlyspecify an alternativedisplay variant.

You can also choose a user-specific layout, provided that you can save

user-specific display variants.

第 58 页 / 共 319 页

Unit2: ListViewer AC280

EntertheALVinitiallayoutintheaccountingeditingoptions.

Figure 26: Standard Layout: Default and InitialLayout

Thestandardlayoutisthelayoutthatappliesforallusers.

You can select a layout for thelist output for your line item display. If you so

require,thislayoutisdisplayedagainthenexttimeyoucalluptransactionFBL*N

(*=1forvendors,=3forG/Laccounts,and=5forcustomers). Intheaccounting

editingoptionsinyouruserparameters,youcansavethelastlayoutusedasa

default. If you select the Last layout entered fordefaultfield, every time you

executethelineitemdisplay, thelayout ontheselectionscreenis saved as the

defaultintheuser specifications. Tip: Ifyou wantto prevent thedefault being

accidentallyoverwrittenbytheselectionofanotherlayout,leavethefieldblank.

Ifyouhavenotselectedalayout,thelistlayoutfromthedefaultselectionscreen

is selectedfromyour user parameters. Youcan default the input fieldfor each

account type.

If you do not make an entry, and no default setting is made for the selection

screenintheuserparameters,thesystemusestheALVinitiallayout. Youcannot

define the ALV initial layout in the accounting editing options; you can only

dothisinthelineitemlist itself. You defaulttheALVinitiallayout indisplay

variant management.

Ifyoudonotmakeadefaultsettingindisplayvariantmanagement,thesystem

chooses the 1SAP layout.

第 59 页 / 共 319 页

AC280 Lesson: Changing the Screen Layout

Figure 27: User-Specific Layout

Youcancreateauser-specificlayout,whichonlyyoucanuse.

Ifyouonlywanttoworkwithyouruser-specificlayout,calluptherelevantline

item list with your new, user-specific layout. In theeditingoptionsof theuser

parameters, thedefaultselectionscreenisupdatedwithyournew, user-specific

layout. Ifyoualsowanttobeabletocallupthelineitemlistusinganotherlayout

inyourselectionaswellasyouruser-specificlayout,deselecttheSavelastlayout

for default field.

The following order applies: User-specific initial screen (set as default) has

priorityover general initial variant (set asdefault).

第 60 页 / 共 319 页

Unit2: ListViewer AC280

第 61 页 / 共 319 页

AC280 Lesson: Changing the Screen Layout

Exercise 3: Changing the Screen Layout

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Change and save a screen layout

• Choose a layout

Business Example

When choosing alist, accountants canchoosebetweendifferent (standard and

user-specific)layouts. Theywanttoaddtotheirownlayouts.

Task 1:

Carry out the following task:

1. Calluptheopenitemslistforcustomer1033incompanycode1000again.

FinddisplayvariantAC280-D-##. SelectDefaultsettingforyourdisplay

variantandsaveit again. Whichdisplayvariantdoesthesystem propose

when you call up the open items list again?

2. Intheitemtextsfortheopenitems,youwanttobeabletoseehowthesales

revenuewasachieved. Changealltheitemsusingthemasschangefunction

sothatthetextFlatscreensappearsintheitemtext.

Task 2:

G/L account line item list

1. You are asked to look at all the items in the account sales revenue for

domesticproducts(800000). Howmanyitemsaredisplayed?

2. Tofindthepostingdate,youhavetofirstswitchfromthedocumentitemto

thedocument header. However, youwouldpreferto find theinformation

immediatelywhenyoubranchtothedocument. Whatoptionsdoyouhave?

3. Youhavealsobeenaskedtocreatealistthatshowsonlytotalsfortheprofit

centerspostedtoandthatdisplaystheamountinlocalcurrency. When

youanalyzethesubtotalsforthelineitems,youwanttoseethedocument

dateanddocumentnumber. Youwantalluserstobeabletousethedisplay

variantAC280-PC-##(##=yourgroupnumber),withthedescriptionProfit

center ##. Can you do this?

4. Auserwantstoseethelineitemsforprofitcenter1600.

5. InadditiontotheG/Laccountwithnumber,name,andthecompanycode,

in the header item of the list you also want tosee the account groupto

which the account belongs.

第 62 页 / 共 319 页

Unit2: ListViewer AC280

Solution 3: Changing the Screen Layout

Task 1:

Carry out the following task:

1. Calluptheopenitemslistforcustomer1033incompanycode1000again.

FinddisplayvariantAC280-D-##. SelectDefault settingfor yourdisplay

variantand saveit again. Whichdisplayvariant doesthesystem propose

when you call upthe open items list again?

a) BychoosingSettings→Choosedisplayvariant

Layout configuration→ User-specific

you canfind your variant AC280-D-##.

By choosing Settings → Save Layout

you can saveyour variantAC280-D-##.

Thevariantmustremainuser-specific. Selectthedefaultsetting.

Choose Continue.

Thesystemissuesthefollowingmessage: “Thislayoutalreadyexists.

Doyouwanttooverwritetheexistinglayout?”

Choose Yes to confirm.

Thesystemissuesthefollowingmessage: “Layoutwassaved.”

Calluptheopenitemlistagain: VariantAC280-D-##isdisplayed.

2. Intheitemtextsfortheopenitems,youwanttobeabletoseehowthesales

revenuewasachieved. Changealltheitemsusingthemasschangefunction

sothatthetextFlatscreens appearsintheitemtext.

a) Mass change:

CalluptheopenitemslistandchooseEdit→Selectall..

Edit → Select all

Environment→Masschange→Newvalues(orchooseMasschange).

Choose Enter.

List → Refresh.

Continued on next page

第 63 页 / 共 319 页

AC280 Lesson: Changing the Screen Layout

Task 2:

G/L account line item list

1. You are asked to look at all the items in the account sales revenue for

domesticproducts(800000). Howmanyitemsaredisplayed?

a) Accounting→FinancialAccounting→GeneralLedger→Account→

Display/Change Line Items (New)

G/L account: 800000

Company code:1000

Item Selection: All Items

Type: Ledger 0L

Program → Execute

2. Tofindthepostingdate,youhavetofirstswitchfromthedocumentitemto

thedocument header. However, youwouldpreferto find theinformation

immediatelywhenyoubranchtothedocument. Whatoptionsdoyouhave?

a) Accounting → Financial Accounting → General Ledger →

Environment→UserParameters→EditingOptions

Tab page Line Items

Itemselection: Goto.... DocumentOverview

3. Youhavealsobeenaskedtocreatealistthatshowsonlytotalsfortheprofit

centerspostedtoandthatdisplaystheamountinlocalcurrency. When

youanalyzethesubtotalsforthelineitems,youwanttoseethedocument

dateanddocumentnumber. Youwantalluserstobeabletousethedisplay

variantAC280-PC-##(##=yourgroupnumber),withthedescriptionProfit

center ##. Can you do this?

a) Call up the line item list again.

Settings→Layout→Current(orchooseSelectLayout)

Inthecolumnset: Selectall(Ctrlbutton+click)

Arrowpointingright(hideselectedfields)

In the column set:

• Profit center

• Amount in local currency

• Document date

• Document no.

Continued on next page

第 64 页 / 共 319 页

Unit2: ListViewer AC280

Arrowpointingleft(addselectedfields)toaddthefieldstothecolumn

selection

Arrangethem in this order (see above)

Sort order tab page

Inthecolumnset: Selectall(Ctrl key+click)

Arrowpointing right (hideselectedfields)

In the column set:

• Profit center

Arrowpointingleft(addselectedfields)toaddthefieldstothecolumn

selection

Choose Sort ascending

Choose Subtotals

Choose Enter

Settings→SummationLevels→DefineBreakdown

Select level 1 (Profit center) (or * ...)

Settings → Layout → Save

Layout: /AC280-PC-##

Name: Profit Center

(*... IfyouhavenotdefinedthebreakdownbychoosingSettings→

Summationlevels→Definebreakdown,onthetabpage,choose“Save

with”:

Select the sort order and subtotals

Breakdowntosummationlevel: 1*ProfitCenter)

4. Auserwantstoseethelineitemsforprofitcenter1600.

a) Choosetheiconforthesubtotal. Selectthe*intheoutputtoopenup

thelineitemsfor the selected profit center.

Continued on next page

第 65 页 / 共 319 页

AC280 Lesson: Changing the Screen Layout

5. InadditiontotheG/Laccountwithnumber,name,andthecompanycode,

in the header item of the list you also want tosee the account groupto

which the account belongs.

a) List header:

Settings →Layout→Current Heading

Insert→Characteristics(orchooseCharacteristics)

Variablecategory: Character-RelatedTextVariable

Characteristic: Account Group

Text type: Name

Value type: Single Value

Format: Select Intense, width 25

Insert→Characteristics(orchooseCharacteristics)

Variablecategory: Character-RelatedTextVariable

Characteristic: Account Group

Text type: Value

Value type: Single Value

Format: Width 4

Save

第 66 页 / 共 319 页

Unit2: ListViewer AC280

Lesson Summary

You should now be able to:

• Changestandard anduser-specificscreen layouts

第 67 页 / 共 319 页

AC280 Unit Summary

Unit Summary

You should now be able to:

• 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

第 68 页 / 共 319 页

UnitSummary AC280

第 69 页 / 共 319 页

第 70 页 / 共 319 页

第 71 页 / 共 319 页

Unit 3

AR/AP Information System

Unit Overview

Employees in Accounts Receivable Accounting want to be able to evaluate

selecteddatarecordsforcustomersandvendorswithouthavingtoexecutereports

online.

Unit Objectives

After completing thisunit, you will beableto:

• Explainhowtheaccountsreceivable/accountspayableinformationsystem

works

• Namethevariousoptionsforcustomizingtheaccountsreceivable/accounts

payable information system and explain the effect of these options on

evaluations

• Createevaluationsin theinformation system

• Use various options to display evaluations and navigate within the tree

structureoftheaccountsreceivable/accountspayableinformationsystem

Unit Contents

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

Exercise 4: The AR/AP Information System.............................63

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

Exercise 5: Customizing the AR/AP Information System..............73

Lesson: Creating and Displaying Evaluations ...............................81

Exercise 6: Customer/Vendor Information System .....................97

第 72 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Lesson: The AR/AP Information System

Lesson Overview

Theaccountsreceivable(AR)/accountspayable(AP)informationsystemisan

informationsystemforanalyzingimportantcustomerandvendorbusinessdata.

Accountingistheprimarydatabasisforthisinformationsystem.

Lesson Objectives

After completingthislesson, you will beable to:

• Explainhowtheaccountsreceivable/accountspayableinformationsystem

works

Business Example

The accounts receivable and accounts payable departments have requested

additional reports for their area. In particular, they want to be able to analyze

combinationsofvariables, suchascompany, businessarea, creditcontrolarea,

and so on.

Figure 28: The A/R Information System

Theaccountsreceivable(AR)/accountspayable(AP)informationsystemisan

informationsystemforanalyzingimportantcustomerandvendorbusinessdata.

Accountingistheprimarydatabasisforthisinformationsystem. Theaimofthe

AP/AR informationsystem isto enableyouto analyzeanextensivedatabase

online,andtodisplaytheinformationinanoverviewtreestructureonthescreen.

第 73 页 / 共 319 页

AC280 Lesson: The AR/AP Information System

YoucanaccesstheanalysesusingtheARandAPreportingtrees. TheAP/AR

informationsystemprovidesspecialtypesofanalyses,including: Theseinclude

analyses of:

• Due date structure

• Payment history

• Currency risk

• Overdue items

• DSOanalysis(howmanydays'salesthecustomerowesmycompany)

• Thecustomer'scashdiscounthistory(daysagreed/actualdays)

The above-mentioned analyses are based on preselected datasets (evaluation

views,representedinfigure33bythetwocubes: Customers: Auditevaluations

andCustomers: Standardevaluations) thatareregularlycreatedorupdatedby

jobs from the SAP database. Using the AP/AR information system, you can

execute analyses for specific business areas as often asyou wish. If you need

currentdataeverymorning,youcanschedulejobstorunduringthenight.

TheAP/ARinformationsystemprovidesanextensivecombinationofvariables

and a classification of reports by document.

Figure 29: Evaluations - MultilevelProcess: Selection

第 74 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Firstly,thedataretrievalreport(RFDRRSELorRFKRRSEL)collectsselected

datafromtheSAPdatabaseusingaselectionvariant(dataretrievalvariant). For

example, it collectsfromaspecificareadatafor customers/vendorsinspecific

companycodes. Thedataispassedontoalloftheevaluationsdefinedthatbelong

totheevaluationviewandthataredefinedforregeneration.

Additionalreports(RFDDRRE01,RFDRRE02orRFKRRE01,RFKKRE02)

createtheevaluations. Forexample, RFDRRE01createstheduedatestructure

of theopen customer items. Youcannot start these reportsonlineor inabatch

session, sincetherequireddatarecordsaresuppliedbythedataretrievalreport

(RFDRRSEL, RFKRRSEL).

Figure 30: Evaluations - Multilevel Process: Display

Thesystemdoesnotdisplaytheresultsofthereports(RFDRRE01,RFDRRE02,

or RFKRRE01, RFKKRE02,) in a list, but saves them in table RFRR to be

displayed later. The data retrieval report (RFDRRSEL or RFKRRSEL)

providesthe data records required to do this.

Thesystemcontinuestoprocessthisdata,andthedisplayreportssendtheresults

to the screen.

RFDRRANZandRFKRRANZcreatethereporttreesthat areusedtodisplay

theevaluationsintheaccountsreceivable/accountspayableinformationsystem.

Sinceyoudonotmakeselectionsyourself,thesereportsdonothaveanyselection

fields or selection variants.

第 75 页 / 共 319 页

AC280 Lesson: The AR/AP Information System

Exercise 4: The AR/AP Information System

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Createevaluationsin theinformation system

• Describevariousdisplayoptionsforevaluations

• NavigateinthetreestructureoftheAR/APinformationsystemandadjust

this to your needs

Business Example

Managersinaccountsreceivablewantbetterreportingfunctions. Inparticular,

theywanttobeabletoanalyzecombinationsofdifferentvariables(forexample,

companycode,businessarea,andcreditcontrolarea). Inaddition,theywanttobe

abletodrilldownfromthetotalslevelstothedetaillevelsofindividualdocuments.

You need to demonstrate that these reporting functions are provided by the

accountsreceivableinformationsystem,whichaccessespredefineddatasets.

Task:

DuedateanalysiswiththeAccountsReceivableInformationSystem

Usingtheaccountsreceivableinformationsystem, displayaduedateanalysis

by business area for company code 1000. Use theevaluation view Standard

CustomerEvaluations. Whenyoudisplaytheevaluation,switchontheDay/Time.

1. Whatisthetotalforallthedueitemsinyourbusinessarea,BA##(##=

your group number)?

__________________________________________________________________

2. WhatisthetotalforalltheopenitemsinyourbusinessareaBA##? (Ifyou

wanttoseethekeyinsteadofthename,youcanchangethecharacteristic

display with the settings).

__________________________________________________________________

3. Inwhattimeintervalaretheitemsthatarenotyetdue?

__________________________________________________________________

4. WhichcustomersinyourbusinessareaBA##(##=yourgroupnumber)

still have liabilities?

__________________________________________________________________

5. Whichofthecustomersisaforeigncustomerandhowmanydaysagowere

this customer's items due?

__________________________________________________________________

第 76 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Solution 4: The AR/AP Information System

Task:

DuedateanalysiswiththeAccountsReceivableInformationSystem

Usingtheaccountsreceivableinformationsystem, displayaduedateanalysis

by business area for company code 1000. Use theevaluation view Standard

CustomerEvaluations. Whenyoudisplaytheevaluation,switchontheDay/Time.

1. Whatisthetotalforallthedueitemsinyourbusinessarea,BA##(##=

your group number)?

__________________________________________________________________

a) Due date analysis using the Accounts Receivable Information

System SAP menu:

Accounting → Financial Accounting → Accounts Receivable →

InformationSystem→Tools→DisplayEvaluations

Choose Customer standard evaluations → Due date analysis →

Evaluationbybusinessarea→Forcompanycode: 1000IDESAG

or Choose the Switch path pushbutton, and then choose Customer

standardevaluations→Forbusinessarea→BA##(##=yourgroup

number) → Due date analysis → By company code (click) search

for 1000 IDES AG.

Choose Extras → Day/Time on/off.

b) PlacethecursorontheBusinessareacolumn.

Choose Setting →Change. Thenchoosecharacteristic displaykey.

NowyoucanseeBA## (##=your groupnumber), secondcolumn:

Due items

2. WhatisthetotalforalltheopenitemsinyourbusinessareaBA##? (Ifyou

wanttoseethekeyinsteadofthename,youcanchangethecharacteristic

display with the settings).

__________________________________________________________________

a) Last column: Total OIs

3. Inwhattimeintervalaretheitemsthatarenotyetdue?

__________________________________________________________________

a) ChooseView→Openitemsnotdue(orchoosetheOpenitemsnot

due button).

Continued on next page

第 77 页 / 共 319 页

AC280 Lesson: The AR/AP Information System

4. WhichcustomersinyourbusinessareaBA##(##=yourgroupnumber)

still have liabilities?

__________________________________________________________________

a) Place the cursor on your business area BA## (## = your group

number).

Choose View → Top N customers by → Total OIs (or double-click

your business area, BA##)

5. Whichofthecustomersisaforeigncustomerandhowmanydaysagowere

this customer's items due?

__________________________________________________________________

a) Placethecursoron theforeign customer.

Choose View → OI due.

Choose View → Line item analysis.

第 78 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Lesson Summary

You should now be able to:

• Explainhowtheaccountsreceivable/accountspayableinformationsystem

works

第 79 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Lesson: Customizing the AR/AP Information System

Lesson Overview

Inthislesson,wewilldiscussevaluationviews,evaluationtypes,andevaluation

versions.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Namethevariousoptionsforcustomizingtheaccountsreceivable/accounts

payable information system and explain the effect of these options on

evaluations

Business Example

The accounts receivable and accounts payable departments have requested

additional reports for their area. In particular, they want to be able to analyze

combinationsofvariables,suchascompany,businessarea,creditcontrolarea,and

soon. YounowhavethetaskoffulfillingtheserequirementsinCustomizingfor

theaccountsreceivable/accountspayableinformationsystem.

Figure 31: Evaluation Views

Eachtableentryatthehighestleveloftheevaluationviewautomaticallycreatesa

separatenodeinthestandardreporttree. Youusetheevaluationviewstocreate

evaluationsfromdifferentperspectivesandtoorganizethemaccordingtoyour

第 80 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

needs. If your company has multiple company codes, business areas, credit

controlareas,andsoon,youcanusethecorrespondingnumberofevaluation

views tocreateseparateevaluations for these.

Usingtheselection variantsfor thedataretrievalprogram(RFDRRSELor

RFKRRSEL)thatyoumaintainhere, youdefineforeachevaluationviewthe

(maximum)datavolumethatisavailabletothedisplayprograms.

Example for a customer evaluation:

You makethreeentries: onefor company codeEurope, onefor companycode

USA, and athirdfor bothcompanycodes. When you makethese settings, the

systemautomaticallycreatesthreenodesintheaccountsreceivableinformation

system. Youthensetupthevariantsforthedataretrievalprogram(inourexample,

RFDRRSEL)suchthatthecorrespondingcompanycodesareincludedinthethree

different variantsof thedataretrieval program.

Hint: Itiseasiertomakethesettingsbycopyingexistingentriesthanto

createnewentries. Whenyoucopyexistingentries,thesystemcopiesthe

completetablehierarchyofthesourceentrytothetargetentry.

Figure 32: Evaluation Types

Depending on the account type you select, you can choose from various

predefined evaluation types in the system.

Theevaluationtypespecifiesthetypeofevaluation(duedateanalysis,payment

history, and so on) within an evaluation view. You can also define your own

reportsforcreatinganddisplayingtheevaluationsfortheevaluationtype.

第 81 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Ifyouhavecopiedanentryonthepreviouslevel(intheevaluationview),onthis

levelyouwillseealltheevaluationtypesthatbelongtothesourceentry. Delete

the entries that you do not need.

Figure 33: Evaluation Versions

Atthelowestlevelofthetableentries,youcanalsocreateyourownevaluation

versions in addition to the evaluation versions delivered. Each entry uses a

differentvariantofthecreationreport,whichispartofthedataretrieval.

To view adefinition of the selection report variant (RFDRRE01,02,03,04,05),

double-click a standard entry.

The evaluation versions within an evaluation type differentiate between the

evaluations according to a grouping criterion that you select. For example,

evaluationsfortheduedateanalysiscouldbegroupedinversionAaccordingto

companycode,andinversionBaccordingtobusinessarea.

第 82 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Figure 34: Evaluations

IfyouactivatetheCreateevaluationcheckbox,thesystemcreatesthedataduring

the next generation run. You can make this specification in Customizing or

in the application.

YouhavetoactivatethecheckboxesintheEvaluationsrequiredareaifyouwantto

defineoneofthesedatabasefieldsasagroupingcriterion(variantconfiguration).

You have to do this because the program does not read the values from the

followingdatabasefieldsunlesspromptedtodoso:

KNA1-KNAS (VAT registration number, taxdata)

KNA1-KNKAandKNA1-KNKK(creditcontroldata,creditcontrolareadata)

KNA1-KNBK (bank data)

KNB1-KNB5 (customer's dunning master data)

第 83 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Figure 35: Variant Maintenance forSelection Report

Youenterthedatabasefieldtobeusedtogrouptheevaluationonthisscreen. For

theevaluationDuedatestructurebycompanycode,youhavetoenterthedatabase

field KNB1-BUKRS(see example onfigure40).

IntheNumberofTopCustomersfield,specifyhowmanyaccountsordocuments

aretobeincludedintherankedlistforthisevaluation.

Usingtheparametersforsortingbynumberofdays,youcanenterdayintervals

forsortingtheselecteditems(forexample,forthedue/notdueitems). Thesystem

wouldgenerateasortedlistusingentries15, 30, and45:

• 0 – 15

• 16 - 30

• 31 – 45

• > 45

第 84 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Figure 36: Additional Variant Attributes

When you activate the parameters, the system creates evaluations on various

levels:

• Client

• Credit control area

• Company code

• Business area

第 85 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Exercise 5: Customizing the AR/AP

Information System

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Customizetheaccountsreceivable/accountspayableinformationsystem

Business Example

Managersinaccountsreceivablewantbetterreportingfunctions. Inparticular,

theywanttobeabletoanalyzecombinationsofdifferentvariables(forexample,

companycode,businessarea,andcreditcontrolarea). Inaddition,theywanttobe

abletodrilldownfromthetotalslevelstothedetaillevelsofindividualdocuments.

YouhavetoshowthatthesereportingfunctionsareprovidedinCustomizingfor

theaccountsreceivableinformationsystem,whichaccessespredefineddatasets.

Task 1:

Analysisofoverdueitemswiththeaccountsreceivableinformationsystem

1. In Customizing, create your own evaluation view, GR##, and your own

selectionvariant, GR##VARI, so thatyoucan subsequently produceand

execute your own evaluation view.

2. Create the new evaluation view.

EnterthenameGR##(##=yourgroupnumber)foryourevaluationview,

and

enter Customer evaluations GR## (## = your group number) as the

description.

CopytheexistingentrySAPevaluationviewforaccounttypeD,standard

customerevaluationsfromthetablewiththeevaluationviews.

Hint: It iseasier tocopy an entrythan to createa newentry and

maintainitindividually. Therefore,usetheentrySAP,D,Standard

customer evaluation as areference.

3. Createthe data retrieval selection variant.

ForthedataretrievalreportRFDRRSEL,createyourowndataretrieval

selection variant, GR##VARI (## = your group number) for your

evaluationviewGR##(##=yourgroupnumber).

Continued on next page

第 86 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

In this variant, choose the customers Customer01 to Customer20 and

Foreign01toForeign20incompanycode1000.

NameyourvariantGroup##variant(##=yourgroupnumber).

Forthe openitemselection,chooseaselectionvariablethatensuresthat

thesystemperformsadynamicdatecalculationwiththecurrentdate.

Task 2:

Yourcompanyiscurrentlyinvestigatinginwhichcitieslatepayersarelocatedso

thatitcanuseacollectionagencytocollectthereceivables.

1. Use the Customer evaluations GR## evaluation view (## = your group

number),whichyoucreatedinthepreviousstep. InevaluationviewGR##

(##=yourgroupnumber),createanevaluationversionfortheevaluation

typeOverdueItems. Intheevaluationversion,youmustbeabletofindthe

itemsduebythecitiesinwhichthelatepayersarelocated. Thisevaluation

versioniscalledversion gand hasthedescriptionOverdueitemsbycity.

In the evaluation version's selection variantCityvari## (## = your group

number)(description: cityvariant)fortheselectionreportRFDRRE04,the

cityisthefieldusedtogroupitems(fieldKNA1-ORT01).

第 87 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Solution 5: Customizing the AR/AP

Information System

Task 1:

Analysisofoverdueitemswiththeaccountsreceivableinformationsystem

1. In Customizing, create your own evaluation view, GR##, and your own

selectionvariant, GR##VARI, so thatyoucan subsequently produceand

execute your own evaluation view.

a) FromtheSAPReferenceIMG,chooseFinancialAccounting(New)

→ Accounts Receivable and Accounts Payable → Information

System→AccountsReceivable→StandardEvaluations→Select

Standard Evaluations.

b) CreateanewevaluationviewGR##(##=yourgroupnumber)and

a selection variant GR##VARI (## = your group number) for the

data retrieval report RFDRRSEL.

2. Create the new evaluation view.

EnterthenameGR##(##=yourgroupnumber)foryourevaluationview,

and

enter Customer evaluations GR## (## = your group number) as the

description.

Continued on next page

第 88 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

CopytheexistingentrySAPevaluationviewforaccounttypeD,standard

customerevaluationsfromthetablewiththeevaluationviews.

Hint: It iseasier to copyanentrythan to createa newentry and

maintainitindividually. Therefore,usetheentrySAP,D,Standard

customer evaluation asa reference.

a) Evaluationview: GR##(##=yourgroupnumber)

Select the entry:

Evaluationview: SAP(Customerstandardevaluations)

Account type: D

Data retrieval report: RFDRRSEL

Data retrieval variant: SAP_VARI

Edit → Copy as (or Copyas pushbutton)

Evaluationview: GR##(##=yourgroupnumber)

Account type: D

Nameofevaluationview: CustomerevaluationGR##

Enter

DialogboxSpecifyobjectstobecopied: SelectCopyall

Confirmtheinformationabout theNumberof copiedentries: 45by

choosing Enter

Save

3. Createthedata retrieval selection variant.

ForthedataretrievalreportRFDRRSEL,createyourowndataretrieval

selection variant, GR##VARI (## = your group number) for your

evaluation viewGR##(##=yourgroupnumber).

In this variant, choose the customers Customer01 to Customer20 and

Foreign01toForeign20incompanycode1000.

NameyourvariantGroup##variant(##=yourgroupnumber).

Forthe openitemselection,chooseaselectionvariablethatensuresthat

thesystemperformsadynamicdatecalculationwiththecurrentdate.

a) DataretrievalselectionvariantGR##VARI(##=yourgroupnumber)

foryourevaluationviewGR##(##=yourgroupnumber)

Select

Continued on next page

第 89 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

Evaluationview: GR##(##=yourgroupnumber)

Account type: D

Nameofevaluationview: CustomerevaluationGR##

→Environment→Maintainvariant(orMaintainvariantpushbutton)

Variant: GR##VARI(##=yourgroupnumber)

Variants→Create(orchoosetheCreatepushbutton)

Forcustomeraccount: Multipleselectionbutton(right):

Choose the Ranges tab page

Inthefirstrange: Customer00toCustomer20

Inthesecondrange: Foreign00toForeign20

Copy

Enter

Execute

Company code: 1000

Edit→Attribute(orchoosetheAttributesbutton)

Description: Variantgroup##(##=yourgroupnumber)

ChoosetheSelectionVariablepushbuttonfortheobjectoftheselection

screen“OpenItemsatKeyDate”andchooseTypeofVariable:

ChoosetheNamederVariablepushbutton(entriesonlypossibleusing

input help)

Choose Current Date

Save (to save the variant GR##VARI)

Go back twice (green arrow).

Enter the following:

Evaluationview: GR##(##=yourgroupnumber)

Account type: D

Nameofevaluationview: CustomerevaluationGR##

Yourvariant: GR##VARI(##=yourgroupnumber)

Save

Continued on next page

第 90 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Task 2:

Yourcompanyiscurrentlyinvestigatinginwhichcitieslatepayersarelocatedso

thatitcanuseacollectionagencytocollectthereceivables.

1. Use the Customer evaluations GR## evaluation view (## = your group

number),whichyoucreatedinthepreviousstep. InevaluationviewGR##

(##=yourgroupnumber),createanevaluationversionfortheevaluation

typeOverdueItems. Intheevaluationversion,youmustbeabletofindthe

itemsduebythecitiesinwhichthelatepayersarelocated. Thisevaluation

versioniscalledversion gand hasthedescriptionOverdueitemsbycity.

In the evaluation version's selection variantCityvari## (## = your group

number)(description: cityvariant)fortheselectionreportRFDRRE04,the

cityisthefieldusedtogroupitems(fieldKNA1-ORT01).

a) NewevaluationbycityfortheOverdueitemsevaluationtype:

Selecttheevaluationviewthatyoupreviouslycreated

Evaluationview: GR##(##=yourgroupnumber)

Account type: D

Nameofevaluationview: CustomerevaluationGR##

DB:VariantGR##VARI(##=yourgroupnumber)

DoubleclickEvaluationTypes(indialogstructure)

Selecttheevaluationtype: 04;name: “Overdueitems”

DoubleclickEvaluations(indialogstructure)

SelecttheevaluationOverdueitemsbycompanycode

Edit → Copy as (or Copy button)

Evaluationview: GR##(##=yourgroupnumber)

Account type: D

Evaluation type: 04 (Overdue items)

Evaluation version: G

Evaluation name: Overdue itemsbycity

Create evaluation: Select

For selection:

Selectionvariant: Cityvari##(##=yourgroupnumber)

ENTER

The following message appears:

Continued on next page

第 91 页 / 共 319 页

AC280 Lesson: Customizing the AR/AP Information System

VariantRFDRRE04CITYVARI##doesnotexist. Pleasecreate.

Button: Maintain variant

Program: RFDRRE04

Variant: Cityvari##

Variant → Create

Field for grouping: KNA1-ORT01

Edit → Attributes

Description: City variant

Saveandchoosethegreenarrowtogobacktothepreviousscreen.

Do not forget to SAVE thenewevaluation.

第 92 页 / 共 319 页

Unit3: AR/APInformationSystem AC280

Lesson Summary

You should now be able to:

• Namethevariousoptionsforcustomizingtheaccountsreceivable/accounts

payable information system and explain the effect of these options on

evaluations

第 93 页 / 共 319 页

AC280 Lesson: Creating and Displaying Evaluations

Lesson: Creating and Displaying Evaluations

Lesson Overview

Evaluationsareperformedanddisplayed. Inthislesson,youwilllearntocreate

evaluations in the information system, and navigate within reports using the

appropriate list functions.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Createevaluationsin theinformation system

• Use various options to display evaluations and navigate within the tree

structureoftheaccountsreceivable/accountspayableinformationsystem

Business Example

The accounts receivable and accounts payable departments have requested

additional reports for their area. In particular, they want to be able to analyze

combinationsofvariables, suchascompany, businessarea, credit controlarea,

and so on.

You need to demonstrate that these functions can be performed by creating

and navigating within a dataset in the accounts receivable/accounts payable

information system.

Figure 37: Report Tree