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

第 1 页 / 共 213 页

AC805

Cash Management

mySAP ERP Financials

Date

Training Center

Instructors

Education Website

Participant Handbook

CourseVersion:2006/Q2

CourseDuration:3Days

Material Number: 50078503

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

第 2 页 / 共 213 页

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.

第 3 页 / 共 213 页

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

bothinternal(inthisdocumentation)andexternal(in

other locations, such asSAPNet).

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 bothinternal(inthisdocumentation)andexternal(in other locations, such asSAPNet).
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 页 / 共 213 页

AboutThisHandbook AC805

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 页 / 共 213 页

Contents

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

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

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

Unit 1: Cash Management/Cash Position ............................1

Overview of Cash Management......................................2

Application View: Cash Position....................................10

Customizing: Cash Position ........................................24

Unit 2: Manual Memo Records........................................ 39

Application View: Manual Memo Records.........................40

Customizing: Manual Memo Records..............................50

Unit 3: Check Deposit................................................... 59

Application View: Check Deposit...................................60

Customizing: Check Deposit........................................75

Unit 4: Manual Bank Statement....................................... 85

Application View: Manual Bank Statement........................86

Customizing: Manual Bank Statement............................102

Unit 5: Bank Statement – Electronic Entry........................119

Application View: Electronic Bank Statement Entry.............120

Customizing: Electronic Bank Statement Entry..................136

Unit 6: Cash Concentration...........................................141

Application View: Cash Concentration............................142

Customizing: Cash Concentration.................................149

Unit 7: Liquidity Forecast.............................................161

Application View: Liquidity Forecast...............................162

Customizing: Liquidity Forecast ...................................175

Unit 8: Checking Reports, Data Transfer, Reorganization.....185

Checking Programs..................................................186

Data Transfer and Reorganization.................................192

第 6 页 / 共 213 页

Contents AC805

Appendix 1: Data Sheet .............................................199

Appendix 2: Chart of Accounts ...................................201

Index .......................................................................203

第 7 页 / 共 213 页

Course Overview

Thistrainingcoursedescribesthefunctionsofcashmanagement. Inparticular,it

dealswithshorttomedium-termliquiditymonitoring. Thiscoursedoesnotcover

long-term financial planning.

Target Audience

Thiscourseisintendedforthefollowing audiences:

• Members of the project team

• System managers

• End users in the appropriate departments

Course Prerequisites

Required Knowledge

• PracticalknowledgeofmySAPERPfinancialaccountingfunctions

Recommended Knowledge

• AC010- FinancialAccounting andReporting

Course Goals

This course will prepare you to:

• Understand how and where you can use mySAP ERP cash management

functions

• Gain detailed knowledgeof liquidity monitoring along with learning the

necessary prerequisites for these processes

Course Objectives

After completingthiscourse, youwillbeable to:

• Describehowandwherethefunctionsof mySAP ERP cashmanagement

can be used.

• Setupthestructuresrequiredforshortandmedium-termliquiditymonitoring

in your business

• Explainthevariousoptionsavailableforintegratingexternalbankdatawith

cash management

• Definethesystemsettingsneededtocontrolinternalprocessing

vii

第 8 页 / 共 213 页

CourseOverview AC805

viii

第 9 页 / 共 213 页

Unit 1

Cash Management/Cash Position

Unit Overview

This unit provides an overview of cash management and the tools involved,

namely the cash position and liquidity forecast. The cash position is then

explained in detail.

Unit Objectives

After completing thisunit, you will beableto:

• Explainthepurposeandfunctionofthecashpositionandliquidityforecast

in SAP Cash Management.

• Distinguishbetweenlevels, groups, andaccounts.

• Recognizethespecificfeaturesofthecashposition.

• Outsort bank accounts.

• Accesstheflexibledisplaystructuresforthecashposition.

• IntegrateanewhousebankintoyourCashManagementsetup.

• SetupandconfiguretheG/L accounts(bankandbankclearingaccounts)

you need for short-termcash management.

• Setupthegroupingstructuresusedinthecashpositionandassignthenew

G/L accounts to them.

Unit Contents

Lesson: Overview of Cash Management.......................................2

Exercise 1: Overview of Cash Management...............................7

Lesson: Application View: Cash Position.....................................10

Exercise 2: Application View: Cash Position ............................19

Lesson: Customizing: Cash Position .........................................24

Exercise 3: Customizing: Cash Position .................................31

第 10 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Lesson: Overview of Cash Management

Lesson Overview

This lesson looks at the requirements of Cash Management and the two Cash

Managementtools: thecashpositionandliquidityforecast.

Lesson Objectives

After completingthislesson, you will beable to:

• Explainthepurposeandfunctionofthecashpositionandliquidityforecast

in SAP Cash Management.

• Distinguishbetweenlevels, groups, andaccounts.

Business Example

The project team has been asked to define the requirements for a new cash

management system. The teamwantsto findout which tools are available for

safeguardingliquidityover theshorttomediumterm.

Youareamemberofaprojectteamwhosetaskistoprovidethedecisionmakers

inyourcompanywithinformationontrendsincompanyliquidity.

Problems and Objectives

Mostbusinesseshavetoomanybankaccounts,heldattoomanydifferentbanks.

Thismakesitdifficulttokeepanoverviewoftherelevantaccountbalances.

Asbankssendstatementsdaily,precise,value-dateaccountingoftendoesnottake

place. Businessesmissoutonthefullbenefitsofinvestmentinstrumentsbecause

value date information is lacking.

Paymentsareoftenmadefromoneaccountonly,regardlessofwhetheritcontains

sufficient funds.

Thetasksof acash management systeminclude:

• Analyzingfinancialtransactionswithinagreedpostingperiods.

• Identifyingandmappingfuturetrendsinfinancialbudgetingasaccurately

as possible.

第 11 页 / 共 213 页

AC805 Lesson: Overview of Cash Management

Figure 1: Tools in SAP Cash Management

SAPCashManagementoffersthefollowingtools,designedtomakecashflows

clear:

• Thecashposition,whichillustratesshort-termtrendsinthebankaccounts

• Theliquidityforecast,whichillustratesmedium-termtrendsinsubledger

accounts too

The cash position illustrates trends in your bank accounts over the next few

days. Theliquidityforecast, ontheother hand, illustratesliquiditychangesin

thesubledgeraccounts. Functionsthat enableyoutogain relevant information

on expected forecast payment flows are also supported. This information

appearsintheformofmemorecordsinthecashposition,orasplanneditemsin

the liquidity forecast.

Financial budgeting, which is the long-term cash flow view (target/actual

comparison) at G/L account level, isa component of theliquidity planner and

not of SAP Cash Management.

第 12 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Figure 2: Overview of Functions

SAP Cash Management has the same goalsasconventional cash management

systems, namely to:

• Safeguardcompanyliquiditysothatpaymentobligationscanbemet

• Monitor payment flows

SAP Cash Management uses the cash position to reflect movements in bank

accounts, whilemovementsinthesubledgeraccountsarerepresentedusingthe

liquidity forecast.

The liquidity forecast is based on payments from/to customers and vendors in

accordancewiththeopenitems. Asplanningforincomingandoutgoingpayments

coversalargertimeframe,theprobabilityofthepaymentsoccurringontheday

given is less than in the cash position.

第 13 页 / 共 213 页

AC805 Lesson: Overview of Cash Management

Figure 3: Concepts in SAP Cash Management

Theformatof thecashpositionandtheliquidityforecastisdeterminedbytwo

features:

Both reports contain levels. These supply high-quality information on the

commercial reasons for a movement in an account - that is, they explain how

theaccountopeningandclosingbalancescameabout. Forexample,levelsgive

informationonwhetherabalanceinabankaccountistheresultofabankposting

or of a memo record entered manually.

Theycanalsobeclassifiedaccordingtohowsecurethereceiptis(confirmedor

unconfirmed memo record, for example).

In the cash position, accounts (bank and bank clearing accounts) supply

information on the current balance.

Theliquidityforecastcontainsgroupsinsteadofaccounts. Vendorsandcustomers

areassignedtoaplanninggroupbymeansofanentryinthemasterrecords. Each

groupreflectscertain features, procedures, orrisks.

第 14 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Figure 4: Procedure for Day-to-Day Planning

The main tasks of the fund manager is to:

• Maintain company liquidity

• Clear deficits

• Invest surpluses profitably

第 15 页 / 共 213 页

AC805 Lesson: Overview of Cash Management

Exercise 1: Overview of Cash Management

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Talk about the two Cash Management tools: cash position and liquidity

forecast.

Business Example

The user department is to explain how to use the cash position and liquidity

forecast. Anexplanationofthetermsisrequiredhere.

Task:

Whichofthefollowingstatementsapplytotheliquidityforecast/cashposition?

1. The liquidityforecast usesbank valuedates.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

2. Thetypicaltimeframeforthecashpositionis1to2days.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

3. Themainobjectiveofthecashpositionistosafeguardcompanyliquidity.

Determinewhetherthisstatementistrueorfalse.

□ True

□ False

第 16 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Solution 1: Overview of Cash Management

Task:

Whichofthefollowingstatementsapplytotheliquidityforecast/cashposition?

1. The liquidity forecast usesbank value dates.

Answer: False

Thecashpositionusesbankvaluedates. Theliquidityforecast,ontheother

hand, uses customer and vendor groups.

2. Thetypicaltimeframeforthecashpositionis1to2days.

Answer: True

3. Themainobjectiveofthecashpositionistosafeguardcompanyliquidity.

Answer: False

Themainobjectiveof thecashpositionistogiveyouacurrentoverview,

correct by value date, of short-term trends in your bank accounts. The

mainobjectiveof theliquidityforecast, ontheotherhand, istosafeguard

company liquidity.

第 17 页 / 共 213 页

AC805 Lesson: Overview of Cash Management

Lesson Summary

You should now be able to:

• Explainthepurposeandfunctionofthecashpositionandliquidityforecast

in SAP Cash Management.

• Distinguishbetweenlevels, groups, andaccounts.

第 18 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Lesson: Application View: Cash Position

Lesson Overview

Thislessonlooks at the cashpositionapplication.

Lesson Objectives

After completingthislesson, you will beable to:

• Recognizethespecificfeaturesofthecashposition.

• Outsort bank accounts.

• Accesstheflexibledisplaystructuresforthecashposition.

Business Example

First, youwantto createan instrument which will giveyouuseful information

aboutyourbankaccounts. Youusethecashpositionforthis,consideringfirstits

specificattributesandaspectsofintegration. Tobeabletousethecashposition

effectively,youmustfirstsetupyourFIbankaccountsinaparticularstructure,

and configure them accordingly. This unit surveys the flexible configuration

options available in the cash position.

Figure 5: Features of the Cash Position

The cash position is the result of the entry, by value date, of all the payments

in a given, short time horizon.

Therearethreesourcesofdatafor thecashposition:

• FIpostingstocash-management-relevantG/Laccounts

• Memo records entered manually

• CashflowsfrombusinesstransactionsmanagedusingtheFSCMcomponent

You use the grouping to set up the display.

第 19 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Figure 6: Integrating the Cash Position

After the bank statements are posted in Financial Accounting, the account

transactionscan bedisplayed inthecash position.

Thebalancesinthebankaccounts,whichyoucandisplayusingthecashposition,

form the basis for planning decisions.

Treasury transactions can also be displayed in the cash position, under certain

conditions.

Figure 7: Bank Account Organization

Bankaccountingprovidesan(actual)bankaccountforeachcurrencyandforeach

account,clearingaccounts(banksubaccount)perprocessingtypeonalowerlevel.

Youcantailortheclearingaccountstotheneedsofyourbusiness.

第 20 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Objectives:

• Accounts can be reconciled at any time

• Foreigncurrencyandlocalcurrencyaremanagedinparallel

• Can be managed by value date

• Interest can be calculated

• Line item analysis possible

• Contingent liabilities can be monitored

• Itemspostedautomaticallyusingautomaticpaymenttransactions

• Automaticbreakdownusingelectronicbankingtransactions

Only transactionswhich are active according to the bank statement are posted

in the (actual) bank accounts.

Figure 8: Prerequisites for Bank Accounting

YouwanttoimplementSAPCashManagementandhavetoconfigurethechart

of accounts.

第 21 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Youneedtocreateageneralledgeraccountforeachactiveaccountyouhaveat

thebank,bycurrencyifapplicable. Inaddition,youneedtocreatebankclearing

accountsforeachbankaccount,alsobycurrencyifapplicable. SAPrecommends

the following grouping here:

• 113100Bank1(currentaccount-domestic-currencyEUR)

• 113101 Bank 1 (outgoing checks)

• 113102Bank1(outgoingbanktransfers, domestic)

• 113103Bank1(outgoingbanktransfers, foreign)

• 113104 Bank 1 (automatic deposit)

• 113105 Bank1(miscellaneousinterimpostings)

• :

• 113108 Bank 1 (incoming checks)

• 113109 Bank 1 (customer cash receipts)

Processing sequence

1. Payment transactionsareposted against theclearingaccountsusingthe

payment program.

2. Bankstatementsbalancetheclearingentriesagainstthebankaccount.

3. CashManagementdisplaysormonitorspostings,withthehelpofvarious

groupings.

Figure 9: Bank Accounts

Bank accounts must be configured so that the bank postings are included in

planning.

第 22 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Ifyouwanttoderivethebalanceinthecashposition,whichisalwaysmanaged

byvaluedate,youshouldmanagedthebank(actual)accountsbyvaluedatealso.

DataisrecordedinG/Laccountcurrency. Allbank(actual)accountsshouldbe

assignedtoauniqueplanninglevel,wherebankstatementsand, withthem,the

actual bank balance are represented.

Ontheotherhand, youshouldmanagebankclearingaccountsonanopenitem

basis. Theycan,forexample,besortedbylocalcurrencyamount. Dependingon

the type of bank clearing account, a specific planning level is then assigned -

for example, for:

• 113102-Bank1(outgoingbanktransfers,domestic)B2level

• 113109-Bank1(customercashreceipts) B9level

Figure 10: Planning Levels

Planning levels explain the beginning and ending balances in an account and

supply information on what brought them about. You can define them in a

customizing table.

In the master record for the bank and clearing accounts, you should set the

Planning Level field as a required entry field.

Thebalancesaredisplayedattheappropriatelevelinthecashposition.

第 23 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Figure 11: Cash Position Display

Youusethegroupingto definehow thedataisto be displayed. Thegrouping

determineswhichlevelsandaccountsaretobedisplayedforthecashposition.

On the initial screen specify the selection options for the following accounts

analysis:

• CompanyCode: whosebankdatayouwanttodisplay.

• CashPosition: Xdisplaysthebankdata(bankandbankclearingaccounts).

• Grouping: Specialviewfor selectingtheaccounts.

• Displayby: (aggregated)startingdateoftheaccountforecast.

• Planned Currency: USDor EUR(asrequired)

• Displayin: currency code, whichdefineshowtheamountsareconverted

(currency risk).

• Increment: Incrementtimeframe(1-99)indays(D),weeks(W),ormonths

(M).

• DisplayType: Inadditiontotheaggregateddisplay,youcancallupinflows

andoutflowsusingadeltadisplay. Youcanalsospecifythebeginningand

end balances in the delta display.

• Scaling: Here,youcanspecifythenumberofdecimalplacesinthedisplay.

The first thing you see is a partial selection, which shows the most important

entries. ChooseAllSelectionstoviewtheotherselectionstoo. UseVariants!

第 24 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Figure 12: Accounts and Levels in the Cash Position

Thegroupingtermspecifieshowthesystemsummarizesthedata.

The next screen after the initial screen is a basic screen, whose format is

determined by the grouping and summarization termsentered in customizing.

Fromhere,youcanbranchtothelevels,andfromtheretotherelevantaccounts,

orviceversa. Variousinformationappears,dependingonthesettings.

The total bank balance is broken down by:

• Groups(=accounts) towhichpostingshavebeenmade. Thesearealways

listedwiththeircashmanagement accountname(Customizing). If you

select the Account Instead of Account Name parameter, the accounts

(accountnumbers)aredisplayedinsteadofthecashmanagementaccount

names.

• Levels(=sources)ofabankoraccounttransaction.

第 25 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Youcan branch to the FI line items(top down).

Hint: When you migrate to 4.5B from an earlier release, you must

completely reconstruct cash management because the update logic is

different. In the caseoftheG/Laccount, theG/L account currencyis

not always adopted; either the document currency (for G/L accounts

managedonanopenitembasis)ortheG/Laccountcurrency(forother

G/L accounts) is used instead.

Todeleteandthenreconstructthecashmanagementdata,usetheData

Setup in the new transaction FDFD. See the last unit of this course

documentation for details.

Figure 13: Currency Display

AmountsenteredareshowninthecurrencyyouspecifiedintheDisplayinfield.

Youcanusethecurrencyfieldstodisplaytheforeignexchangerisk.

Ontheonehand,youcanshowthecashpositionsplitbycurrency,dependingon

thespecificationsenteredintheinitialscreen. Youcanalsodisplaytheextentof

your currency exposurefrom the cash position.

The average rate is usually used for converting the planning currency to the

displaycurrency. Ifyouwanttouseadifferentrateforthetranslation,makethe

appropriate specification intheRate Type field.

第 26 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

第 27 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Exercise 2: Application View: Cash

Position

Exercise Objectives

After completingthisexercise, youwillbeableto:

• CheckG/Laccountsandcorrectthemasnecessary.

• EnterG/Laccountpostingssothatyoucanseetheminthecashposition.

Business Example

Toobtainanoverviewofthestructureanddisplaycapabilitiesofthecashposition,

youwillnowenteranumberofG/Laccountpostings. Theseshowthepostings

tothebankaccounts,whicharenormallygeneratedwhenthebankstatementis

read. Any earlier postings are ignored.

Task:

1. Check and correct the field content required for Cash Management (for

example,openitemmanagement,planninglevel)inaccountmasters113100,

113101,113108,113109,and113200inyourcompanycode.

2. Today'sbankstatementresultsinthefollowingG/Laccountpostings:

Outgoingcheck, vendor: 30,000, valuedate: today

Transfer fromcustomer: 50,000, valuedate: today

Postagainsttheclearingaccounts113101and113109(postingrecords: Dr

113101/Cr 113100and Dr 113100/Cr113109).

3. Check the effects of your entries in the cash position (grouping:

ACBANK-IST).Thisdisplaycontainsonlythebankaccounts,withoutbank

clearing accounts.

第 28 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Solution 2: Application View: Cash

Position

Task:

1. Check and correct the field content required for Cash Management (for

example,openitemmanagement,planninglevel)inaccountmasters113100,

113101,113108,113109,and113200inyourcompanycode.

a) Solutionforcheckingandcorrectingaccountmasters113100,113101,

113108,113109,113200withregardtothefieldcontentrequiredfor

Cash Management.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

General Ledger→ Master Records→ G/L Accounts → Individual

Processing → Centrally.

Entertheaccountnumberandcompanycodeandthencheckorchange

your values.

Choose Change or Display.

113100. 113108, 113200

113101, 113109

AC##

OntheType/Descriptiontabpage,youcanseethedescriptionofthe

accounts. Thisaccountisdescribedasabalancesheetaccount.

OntheControlDatatabpage,youcansee,amongstotherthings,the

account currencyandtheaccountmanagementdatarequiredinthe

companycode. Thebankaccounts–unlikebankclearingaccounts–

arenot managed on an open item basis.

OntheCreate/Bank/Interesttabpage,youcanseetheplanninglevel

andtheassignmentofthehousebankandaccountID.

Account .100 .101 .108 .109 .200

113...

Control data

Lineitemdisplay X X X X X

Open item - X X X -

management

Continued on next page

Account 113...	.100	.101	.108	.109	.200
Control data
Lineitemdisplay	X	X	X	X	X
Open item management	-	X	X	X	-

第 29 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Account .100 .101 .108 .109 .200

113...

Create/bank/interest

Planninglevel F0 B1 B8 B9 F0

Housebank 1000 - - - 1200

Acct ID 1000 - - - 1200

2. Today'sbankstatementresultsinthefollowingG/Laccountpostings:

Outgoingcheck, vendor: 30,000, valuedate: today

Transfer fromcustomer: 50,000, valuedate: today

Postagainsttheclearingaccounts113101and113109(postingrecords: Dr

113101/Cr 113100and Dr 113100/Cr113109).

a) Solutionforpostingagainstclearingaccounts113101and113109(Dr

113101/Cr 113100andDr113100/Cr113109).

Choose SAP Easy Access → Accounting → Financial Accounting

→ General Ledger → Posting → Enter G/L Account Document -

(company code AC##)

(Ifnecessary,chooseChangeCompanyCodetochangethecompany

code.)

Enter your data.

Notethecurrency(EUR)andthevaluedatespecificationforthedebit

and credit postings.

Outgoingcheck– 113101 Debit 30.000 Value Date:

vendor: Today

113100 Credit 30.000 Value Date:

Today

Transfer – 113100 Debit 50.000 Value Date:

customer: Today

113109 Credit 50.000 Value Date:

Today

Continued on next page

Account 113...	.100	.101	.108	.109	.200
Create/bank/interest
Planninglevel	F0	B1	B8	B9	F0
Housebank	1000	-	-	-	1200
Acct ID	1000	-	-	-	1200

Outgoingcheck– vendor:	113101	Debit	30.000	Value Date: Today
	113100	Credit	30.000	Value Date: Today

Transfer – customer:	113100	Debit	50.000	Value Date: Today
	113109	Credit	50.000	Value Date: Today

第 30 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

3. Check the effects of your entries in the cash position (grouping:

ACBANK-IST).Thisdisplaycontainsonlythebankaccounts,withoutbank

clearing accounts.

a) Solutionforcheckingentriesinthecashposition.

ChooseSAP EasyAccess→Accounting→Financial SupplyChain

Management→CashandLiquidityManagement→CashManagement

→InformationSystem→ReportsforCashManagement→Liquidity

Analyses → Cash Position.

Enter your data.

FieldNameorDataType Values

Company code AC##

Grouping ACBANK-IST

Display as of <today>

Display in EUR

ChooseAllSelections. Youcanmakefurtherselectionshere. Specify

the required increment ("daily" in the example) and choose Delta

Display With Balances as the display type so that you can identify

your postings more easily.

Execute the program.

You now see your postings under the appropriate bank account.

NavigatethroughthecashpositionbyDouble-Clicking.

FieldNameorDataType	Values
Company code	AC##
Grouping	ACBANK-IST
Display as of	<today>
Display in	EUR

第 31 页 / 共 213 页

AC805 Lesson: Application View: Cash Position

Lesson Summary

You should now be able to:

• Recognizethespecificfeaturesofthecashposition.

• Outsort bank accounts.

• Accesstheflexibledisplaystructuresforthecashposition.

第 32 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Lesson: Customizing: Cash Position

Lesson Overview

Nowthatyouhavebeenintroducedtothecashpositionapplication,thissection

looks at Customizing for the cash position.

Lesson Objectives

After completingthislesson, you will beable to:

• IntegrateanewhousebankintoyourCashManagementsetup.

• SetupandconfiguretheG/Laccounts(bankandbankclearingaccounts)

you need for short-term cash management.

• Setupthegroupingstructuresusedinthecashpositionandassignthenew

G/L accounts to them.

Business Example

InSAPCashManagement,younowwanttomapahousebank. Thatis,abank

whereyouhaveanaccountandfromwhichyouwanttocallupbankstatement

information. YoumayalreadyhavecreatedthebankwhenyouimplementedSAP

Financial Accounting. You must also create the relevant G/L accounts in the

systemandconfigurethemaccordingtodefinedcriteria.

Toreproducetheseaccountsinthecashposition,givethemasuitabledescription

andassignthemtoagroupingtermwhichisresponsibleforsettingupthecash

position.

第 33 页 / 共 213 页

AC805 Lesson: Customizing: Cash Position

Figure 14: Account Groups: G/L Accounts

EveryG/Laccountisassignedtoanaccountgroup. Thisdeterminesthestructure

of themaster recordscreen andmust beformatted usingthefieldstatus. Each

accountgroupwithinachartofaccountscanhaveadifferentfieldstatus.

Figure 15: Field Status and Value Date (Documents)

Thefieldstatusgroupisresponsibleforthedocumentformatifyouarepostingto

aparticularaccount. Forthisreason,youmustdefinetheappropriatefieldstatus

group in the appropriate G/L account.

第 34 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

To manage bank postings by value date, you must enter the value date in all

postings tothebankaccount. Tothisend, youcan configuretherelevantfield

statusgroupinsuchawaythattheValueDatefieldisarequiredentry.

Youcanhavethesystemautomaticallyproposethecurrentdateasthevaluedate.

Thismakesthingseasierintrainingcoursesandsystemdemonstrations,butnot

in commercial usebecauseerrorsoccur frequently.

Figure 16: Configuring the Bank Balance Sheet Account

The configuration of bank accounts determines how account transactions are

allocated in the cash position:

• Openitemmanagementinclearing/subaccounts

• Lineitemdisplayinbankbalancesheetaccountsandbankclearingaccounts

• Sortkey005(localcurrencyamount)or027(valuedate)

• Theplanningleveliscopiedtothedocumentfromthemasterrecord,isan

assignmentcharacteristic,andqualifiestheaccountmovement

InCashManagement, correspondencewithbanks istriggeredbymeansof the

housebank andaccount ID (cashconcentration).

第 35 页 / 共 213 页

AC805 Lesson: Customizing: Cash Position

Figure 17: House Banks - Correspondence Banks

House banks for each company code are stored under a freely definable ID

(maximum five characters).

Allthespecificationsfor thehousebanks(address, controldata,andsoon)are

maintained in the bank directory.

Figure 18: Bank Accounts

第 36 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

For the house banks that you have defined, you define the associated bank

accountsinthecompanycodeunderanaccountID.Youentertheexternalaccount

number and its currency with the bank, along with the relevant G/L account

number,therebyensuringthatpostingsgototherightaccounts.

AG/Laccountmasterrecordiscreatedforeachbankaccount.

In the G/L account master record, you can enter the house bank key and the

accountID,sothat youhaveaccessfromthegeneralledgertotheaddressdata

storeforthehousebank. Thisisnecessaryforbankcorrespondence,forexample

duringcashconcentration: thesystemusesthebankIDandaccountIDtoobtain

the addressinformation fromthebank directory.

If you maintain foreign accounts, thecurrency key in the G/L account master

recordmustbethesameasthecurrencyintheforeigncurrencyaccount.

Figure 19: Planning Levels

YoudefineaplanninglevelintheG/Laccountmasterrecordsothatpostingsto

this account can be seen in the cash position.

Planninglevelsprovideinformation on the typeofaccounttransactionand the

reasonfor thetransaction. Theyarefreelydefinable.

Thesourceindicatorchecksthatthedataforthespecifiedlevelispermittedinthe

cashposition. TheBNKsourcesymbolisdefinedinsuchawaythatallplanning

levelsassignedtoitaredisplayedinthecashpositionandnottheliquidityforecast.

Youcandefinenewplanninglevelsbyselectingandcopyingthestandardentries

or by entering a completely new level.

第 37 页 / 共 213 页

AC805 Lesson: Customizing: Cash Position

Figure 20: Cash Management Account Name

InCashManagement,thecashmanagementaccountnameisamnemonicname

that replaces the account number.

Theaccountnameisuniqueineachcompanycode. WithinCashManagement,it

enablesyoutodifferentiatethesameaccountnumbersindifferentcompanycodes.

Thecashmanagementaccountnameisusedinalltransactionsandreports(for

example, the cash position) instead of the account number. The cash position

includesanewparameter: AccountInsteadofAccountName. Whenyouselect

it, the system displays the accounts (account numbers) instead of the cash

management account names.

Usingcashmanagementaccountnamesisadvisablewhenyouareplanningacross

severalcompanycodes. Youmustusethemwhenworkingwithmanualmemo

records or with cash concentration.

Figure 21: Grouping Structure

第 38 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

Groupingsareusedtocombineaccountsandassignsummarizationtermstothem.

Theirbalancescanbedisplayedperaccountorasanaggregate. Youcanrestrict

thedisplaytoparticularcompanycodesandchartsofaccounts.

Groupingtermsarefreelydefinable. Thismeansyoucantailorthecashposition

display toyour ownindividualrequirements. Thelevelsselected appear inthe

display.

Thetypeshowswhetherlevels(E)orgroups(G)aredisplayed. Ineachgrouping,

youmustconfigureatleastonelineoftypeEandoneoftypeG.

The selection determines which levels (2 digits) or groups (10 digits) are

combined. Youcanconfiguremaskingsorpartialmaskingsforindividualvalues.

Groupsmustbetencharacterslongand,ifnecessary,enteredwithleadingzeros.

The summarization term determines whether the individual value or the

cumulative value is displayed.

Whenyoucreatenewgroupingentries,youhavetodefineheadingsforthem.

Figure 22: Grouping Function

Youusegroupingtermstocombineaccountsanddisplaythemcumulativelyoras

individual values.

Partial maskings are possible at any point.

When defining groupings for cash concentration, you can enter both a

summarizationaccountandasummarizationcompanycode.

第 39 页 / 共 213 页

AC805 Lesson: Customizing: Cash Position

Exercise 3: Customizing: Cash Position

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Set up a new house bank.

• SetuptheaccompanyingG/Laccountsandtheircashmanagementaccount

names.

• AddthenewG/L accountsto yourgroupings.

Business Example

You now want to set a house bank in your system. A house bank

is a bank where you hold a customer/vendor account for which you

receive external bank data (via an electronic bank statement, for

example). House banks are usually set up as part of the FI project.

You may, however, need to integrate new house banks after going live.

Youhaveenterednewbankdetailsfor yourcompanycode(housebankGR##,

accountIDCURR).Youusethisbanktoprocessongoingtransactionsandcheck

payments.

Task:

CreatetheG/Laccountsyouwillrequirelaterandintegrateyourhousebank.

1. Youdecide toreserve accounts11##00and 11##01for thisbank. Create

theappropriateG/Laccounts,takingaccounts113100and113101asyour

guide. Checkandchangethecashmanagement-relevantfieldsinthecurrent

account(bankID:GR##,accountID:CURR).Deletethealternativeaccount

numbers.

2. Add the new bank details to the house banks for your company code

(bankID:GR##,accountID:CURR).usingtheexistingentriesasabasis.

NotethatyoualsohavetospecifyG/Laccount11##00whencreatingthe

associated account.

3. Addthenewbankaccounts(foryourcompanycode)tothecashmanagement

account names.

4. AddyouraccountstothegroupingsACBANKENandACBANK-IST,using

the existing entries as a basis.

5. Thefirstbankstatementforthenewaccountshowsadebitforanoutgoing

check.

Post this transaction (11##01/11##00).

Continued on next page

第 40 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

6. Call up the new accounts in the cash position. Choose grouping

ACBANK-IST and then ACBANKEN.

第 41 页 / 共 213 页

AC805 Lesson: Customizing: Cash Position

Solution 3: Customizing: Cash Position

Task:

CreatetheG/Laccountsyouwillrequirelaterandintegrateyourhousebank.

1. Youdecide toreserve accounts11##00and 11##01for thisbank. Create

theappropriateG/Laccounts,takingaccounts113100and113101asyour

guide. Checkandchangethecashmanagement-relevantfieldsinthecurrent

account(bankID:GR##,accountID:CURR).Deletethealternativeaccount

numbers.

a) Solution for creating new G/L accounts.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

General Ledger →Master Records →G/L Accounts→ Individual

Processing → Centrally.

Create centrally:

Bank balance sheet account 11##00 in your company code (with

reference account 113100)

Bankclearingaccount11##01inyourcompanycode(withreference

account 113101)

Nowenterthedata(11##00,forexample)andchooseWithTemplate.

Useaccounts113100and113101astemplates. Changethenameto

GR## Bank,forexample. UnderControlData,deletetheAlternative

Account Numberandchecktheaccountmanagemententries. Under

Bank,changethehousebankIDandaccountIDforthecurrentaccount

andcheckthePlanningLevelentries. Youcanenteryourhousebank

ID(GR##)andaccountID(CURR)hereeventhoughyouhavenotyet

definedthem. Toskipthewarningmessage,pressEnter.

Continued on next page

第 42 页 / 共 213 页

Unit1: CashManagement/CashPosition AC805

2. Add the new bank details to the house banks for your company code

(bankID:GR##,accountID:CURR).usingtheexistingentriesasabasis.

NotethatyoualsohavetospecifyG/Laccount11##00whencreatingthe

associated account.

a) Solutionforaddinganewhousebank(bankID:GR##)andnewbank

details (account ID: CURR).

Choose SAP Reference IMG → Financial Accounting → Bank

Accounting→BankAccounts→DefineHouseBanks.

EnterAC## as your company code.

Enter your data.

ChooseNewEntries. EnterhousebankGR##,bankcountryDE,and

then an 8-digit bank key. Create the address data. If the Financial

Accountingbankdirectoryhasalreadybeenimportedandyouenter

anexistingbanknumber, thesystementerstherelevantaddressdata

automatically.

Choose Save.

Double-click Bank Accounts.

ChooseNewEntriestoenteryour bankaccount.

Choose account ID CURR as the associated bank account, enter a

6-digit account number, currency EUR, and G/L account 11##00

that you have just created.

Choose Save.

3. Addthenewbankaccounts(foryourcompanycode)tothecashmanagement

account names.

a) Solution for addingthenewbankaccountsto the cashmanagement

account names.

ChooseSAPReferenceIMG→FinancialSupplyChainManagement

→ Cash and Liquidity Management → Cash Management →

Structuring→DefineCashManagementAccountName.

EnterAC## as your company code.

Nowaddanewcashmanagementaccountname(##CURRfor11##00

and##checkfor11##01,forexample)tothenewaccountsforyour

company code and a description.

Choose Save.

Continued on next page