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

第 129 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Thesystemusesthebankdatatocreatetwofiles(STATE.TXTandITEM.TXT)

which are then imported into the SAP system, where more data isadded. The

system looks for the business transaction codes (BTC) and other information

relevant to the posting.

AswithotherCashManagementobjects,youcanworkwithbatchinputsessions

ormakepostingsimmediately. Thepostprocessingactivitiesdifferaccordingly.

Figure 54: Electronic Bank Statement – Features (2)

Ifyouwanttousealternativecurrencykeys(suchasinCSB43formatinSpainand

ETABACformatinFrance),assignacurrencyclassalongwiththetransaction

typetothehousebankaccountinCustomizingfortheelectronicbankstatement.

Currencyclassesareusedtoformpairsfromthealternativecurrencykeyssupplied

inthebankstatementandthoseusedinthesystem(forexample, inaccordance

with the ISO standard).

The note-to-payee fields in the electronic bank statement contain various

informationrelevanttoopenitemclearing. Ifthealgorithmswedeliverarenot

sufficient,itispossibletoprogramacustomerexittailoredtoyourbusiness.

Pleasenote: Allchangesmadeinuserexitsaremadeatyourownrisk.

As an electronic bank statement is being imported, the system identifies the

transactions in it and determines how they are posted. The most important

information for this is usually found using the document number or invoice

number,whichappearsinthe"notetopayee"inthebankstatement.

You can print lists from the SAP system.

121

第 130 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Figure55: ElectronicBankStatement–VariousFormatsSupported

The SAP system can read some formats directly. The SAP system also has

someconversion programs, which you canuseto convert variousformatsinto

MultiCash. You can also use MultiCash software from your bank to convert

certainformats(suchasSWIFTMT940)intoMultiCash.

Furtherprocessingisasforthecheckdepositandthemanualbankstatement.

Weofferthefollowingenhancementforthe“electronicbankstatement”:

FEB00001,usedtoanalyzeeachtransactioninyourbankaccountsperclearing

information(suchasthedocumentnumber); changethepostingrule; influence

accountdeterminationbymeansofaccountmodification; distributepostingsto

different batch input sessions.

122

第 131 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Figure 56: Generating Test Data – RFEBKATX

Program RFEBKATX is designed to help you with the customizing settings

neededwhenyouimplementtheelectronicbankstatement. Itwillalsogiveyoua

feelfortheoptionsavailableintheelectronicbankstatement.

Theelectronicbankstatementisused,amongotherthings,toautomaticallyassign

incoming and outgoing payments to house bank accounts when they relate to

items already posted in the system to customer/vendor/clearing accounts and,

where appropriate, the clearing of them.

Experience has shown that two main obstacles arise during implementation,

particularly in customizing:

It is very difficult to generate the bank statement fields STATE.TXT and

ITEM.TXT.Manyimplementationerrorsresultfromthesefilesbeinggenerated

incorrectly. Itisalsodifficulttousetheactualfilesfromthebankbecausethey

are very large.

Theopenitemstobefoundandclearedusingthebankstatementmustnormally

bepostedmanuallywiththecorrectclearinginformation.

Youcanusethisprogramtocreatebothopenitemsinacompanycodeandthe

relevantbankstatementfilesforahousebankaccountinthiscompanycode. You

can do thisdirectlywith theRFEBKA00import program, therebytestingyour

settingsincustomizingandthegeneralfunctionforRFEBKA00.

123

第 132 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Figure 57: Importing Bank Statement Data

In Germany, bank statement data is accessed by means of the Banking

CommunicationStandard(BCS)asdefinedbythebanks.

Thetransferprogram(forexample: MultiCash)usesthebankdatatogeneratetwo

filesforfurtherprocessing,STATE.TXTandITEM.TXT.

Fortheimport,entertheformat,alongwiththetwofilenames,andstipulatethe

type of further processing. The system then automatically makesthe postings

tothebankaccount, bankclearingaccount, customeraccount, and, ifrequired,

vendoraccount, along withthepayment clearing.

You have two options here:

1. Immediate posting

2. Createand then run a batch input session.

Makeyourselectionforthesearchbydocumentorreferencenumber. Activatethe

interpretation algorithm at the same time.

Work with variants.

124

第 133 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Figure 58: MultiCash Files

TheMultiCashformatisgeneratedusingBCS(BankingCommunicationStandard)

software,takingthedatafrombankstatements(usuallySWIFTMT940).

Thismeansthattheformatisthesameforallfinancialinstitutions,makingchecks

(using a spreadsheet or word processing program) easy. Two filesarecreated,

STATE.TXT and ITEM.TXT. STATE.TXT contains bank statement header

information and ITEM.TXT contains the transaction information. Using this

format,anumberofbankstatementscanbeimportedsimultaneously,evenifthey

are from different financial institutions.

The BCS software is usually MultiCash software. Many credit institutions,

however, call it by different names (Cotel - Commerzbank, Dretec- Dresdner

Bank,ELKO-Sparkassen). IftheBCSprogramisobtainedfromtheDeutsche

Bank, the db-directprogram must beinstalled.

Youcanprintandfilethebankstatementretrospectively.

125

第 134 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Figure 59: Electronic Bank Statement – Printout

SAPR/3Enterprisefeaturesarangeofnewpostprocessingfunctions.

ThepostprocessingtransactioniscalledFEBAuptoandincludingRelease4.6.

Asof SAP R/3 Enterprise, it is calledFEBAN.

InSAP R/3 Enterprise, the postprocessingtransaction FEBA hasbeen revised

andreplacedwithtransactionFEBAN.WithFEBAN,statementitemsthathave

not posted automatically by theelectronic bank statement can beselected and

corrected much more quickly.

Figure60: ElectronicBankStatement–PostprocessingwithFEBAN(asof

SAP R/3 Enterprise)

126

第 135 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Thefilter,search,andsortfunctionsintheSAPListViewerenableyoutodisplay

and process bank statement items in a way that best suits your requirements.

Forexample, youcanpostseveralitemsatonceautomaticallyatthetouchofa

button. Thenotetopayee,whichcontainsimportantinformationforpostingbank

statementitemsautomatically,can,ifrequired,bedisplayedinaseparatewindow

while the posting screens are displayed.

Figure61: Screen: BankStatementPostprocessingwithFEBAN

If you have chosen immediate posting, you have to postprocess using the

transactionprovided. Youcanseehowfartransactionpostinghasprogressedby

meansoftheprocessingstatus. Ifbothpostingsandclearingpostingshavebeen

made, the status will be Posted In Full. The “incomplete posting” status will

appearifonlythebankaccountpostingshavebeenmade. Ifnopostinghastaken

place, the status will be Created.

Ifopenitemscannotbeclearedusingtheelectronicbankstatement,youneedto

createpayment advices. Wherepostprocessing hasnot beenhandled properly,

on-accountpostingsaregenerated. Inotherwords,theelectronicbankstatement

generatesitsownpayment advicesfor failedclearingpostingsinthesubledger

area.

If theinterpretation algorithms identified open itemsto be cleared, thesystem

determines the business partner from the relevant document, if this has not

already been determined using the bank details. If no business partner can be

identified,astar(“*”)isentered. Inthisevent,thefirststepinpostprocessingis

theassignmentofthepaymentadvicetotheappropriatebusinesspartner(usethe

ProcessPaymentAdvicepushbutton). Thepaymentadvicecannotbeprocessed

further unless a partner is assigned at header level. In the first postprocessing

step, choose Post. The payment advices must have been processedalready, to

prevent on-account postings.

127

第 136 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

On-accountpostingscanonlybesuppressedifthepaymentadvicesistakenout

oftheposting. Tothisend,youmustsettheDisplayAllScreensmode(F6)and

deletethepayment adviceintheaccount selection.

Bank statement items that have been selected for clearing can now posted

On-Account. Thiscan be an advantage if thecustomerfor theoriginal posting

can beidentifiedasthepayment can bepostedto thecustomerledger for later

clearance. Inaddition,bankclearingaccountscanbeaccessedwithinthesystem

for the purposeof makingthe account posting.

128

第 137 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Exercise 10: Electronic Bank Statement

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Import bank statement data electronically.

• Explainthevariouspostingoptionsandtherelatedpostprocessing.

• Explain andcarry out the transactionsfor clearingopenitems(document

determination).

Business Example

Youusebankingsoftwareeverymorningtoaccessbankstatementselectronically

from one or more of your house banks.

Nowyouwanttofamiliarizeyourselfwiththeoptionsandprocedureforimporting

thesestatementsintoSAPCashManagementelectronically.

Task:

Generate test data for the electronic bank statement and then import the bank

statement.

1. Use the RFEBKATX program to generate the test data and files

STATE##.TXTandITEM##.TXT.Youcancallupthisprogrameitherusing

transactionSE38orbychoosingSystem→Services→Reporting.

CallthefilestobegeneratedSTATE##.TXTandITEM##.TXT(##=your

groupnumber). UsetheaccountswithhousebankID1000andaccount

ID 1000 as your bank clearing accounts. Choose today's date as your

bankstatementdateandtodayminus10daysasyourinvoicedate. Call

up the posting screens if required.

Note: YoucanusevariantAC805. Adjustthevaluesaccordingly

(the company code, for example).

GenerateoneormoreopenitemsforcustomerT-F00B00andgenerateopen

items for your clearing accounts too.

Execute the program.

2. Check the log for program RFEBKATX.

Hint: Havethesubledger posting(s) and G/L account posting(s)

beenmade? Havethebankstatementfieldsbeengenerated? Does

statement information exist?

Continued on next page

129

第 138 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

3. Import the files.

ChooseImmediatePostingand set thenumberrangefor thedocument

numbersfrom 1800000000 to1809999999.

Hint: YoucanusevariantAC805. Adjust thevaluesaccordingly

(the company code, for example).

Nowprintthebankstatement,postinglog,andstatistics.

Execute the program.

4. Checkthepostinglog,theprocessingstatistics,andthebankstatement.

5. Nowyouhavetocheckwhetherallthepostingshavebeenmadeorwhether

any postprocessing is required.

Choose your bank statement. If a red X appears, you have to carry out

postprocessing. Selecttheitemthatneedstobepostprocessed. Younowsee

alltheinformationyouneed for postprocessing.

Now post the document. You notice that the customer has paid without

deductingdiscount,althoughhewouldhavebeenentitledtoit. Deductthe

amountof thediscountandcontinue posting.

Thegreencheckmarkandthedocumentnumberindicatethattheposting

and open item clearing were successful.

130

第 139 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Solution 10: Electronic Bank Statement

Task:

Generate test data for the electronic bank statement and then import the bank

statement.

1. Use the RFEBKATX program to generate the test data and files

STATE##.TXTandITEM##.TXT.Youcancallupthisprogrameitherusing

transactionSE38orbychoosingSystem→Services→Reporting.

CallthefilestobegeneratedSTATE##.TXTandITEM##.TXT(##=your

groupnumber). UsetheaccountswithhousebankID1000andaccount

ID 1000 as your bank clearing accounts. Choose today's date as your

bankstatementdateandtodayminus10daysasyourinvoicedate. Call

up the posting screens if required.

Note: YoucanusevariantAC805. Adjustthevaluesaccordingly

(the company code, for example).

GenerateoneormoreopenitemsforcustomerT-F00B00andgenerateopen

items for your clearing accounts too.

Continued on next page

131

第 140 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Execute the program.

a) GeneratethetestdataandthefilesSTATE##.TXTandITEM##.TXT

ChooseSystem→Services→Reporting. EnterprogramRFEBKATX.

Enter the following values:

FieldNameorDataType Values

Format M (MultiCash)

Statement File state##.txt

Line Item File item##.txt

Company Code AC##

HouseBank(short key) 1000

Account (short key) 1000

Statement Date <today>

Invoice Date <-10 days>

Posting Mode Set the indicator (as

required)

PostingsGotoCustomer… T-F00B00

First Amount 1000,-

CreateOpenItemsinClearingAccounts Set indicator

Execute the program.

Thesystemgeneratespostingsandbankstatementfiles.

2. Check the log for program RFEBKATX.

Hint: Have thesubledger posting(s) and G/L account posting(s)

beenmade? Havethebankstatementfieldsbeengenerated? Does

statement information exist?

a) Check the log.

Oncetheprogramhas run, the system displaysthereport generated

by the program.

3. Import the files.

Continued on next page

132

FieldNameorDataType	Values
Format	M (MultiCash)
Statement File	state##.txt
Line Item File	item##.txt
Company Code	AC##
HouseBank(short key)	1000
Account (short key)	1000
Statement Date	<today>
Invoice Date	<-10 days>
Posting Mode	Set the indicator (as required)
PostingsGotoCustomer…	T-F00B00
First Amount	1000,-
CreateOpenItemsinClearingAccounts	Set indicator

第 141 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

ChooseImmediatePostingand set thenumberrange for the document

numbersfrom 1800000000 to 1809999999.

Hint: YoucanusevariantAC805. Adjustthevaluesaccordingly

(the company code, for example).

Nowprintthebankstatement,postinglog,andstatistics.

Execute the program.

a) Import the bank statement files.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

Banks→Incomings→ElectronicBankStatement→Import.

Enter the following values:

FieldNameorDataType Values

Import Data Set indicator

Format M (MultiCash)

Statement File STATE##.txt

Line Item File ITEM##.txt

Workstation upload Set indicator

Post Immediately Set indicator

BELNRNumberRange 1800000000 -

1809999999

Print BankStatement Set indicator

Print Posting Log Set indicator

Print Statistics Set indicator

Execute the program.

Thefilesareimportedandimmediatelyupdated.

4. Checkthepostinglog,theprocessingstatistics,andthebankstatement.

a) Checkthepostinglog,theprocessingstatistics,andthebankstatement.

Oncetheprogramhasrun, thesystemdisplaysthereport generated

by the program.

5. Nowyouhavetocheckwhetherallthepostingshavebeenmadeorwhether

any postprocessing is required.

Continued on next page

133

FieldNameorDataType	Values
Import Data	Set indicator
Format	M (MultiCash)
Statement File	STATE##.txt
Line Item File	ITEM##.txt
Workstation upload	Set indicator
Post Immediately	Set indicator
BELNRNumberRange	1800000000 - 1809999999
Print BankStatement	Set indicator
Print Posting Log	Set indicator
Print Statistics	Set indicator

第 142 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Choose your bank statement. If a red X appears, you have to carry out

postprocessing. Selecttheitemthatneedstobepostprocessed. Younowsee

alltheinformationyouneed for postprocessing.

Now post the document. You notice that the customer has paid without

deductingdiscount,althoughhewouldhavebeenentitledtoit. Deductthe

amountof thediscountandcontinue posting.

Thegreencheckmarkandthedocumentnumberindicatethattheposting

and open item clearing were successful.

a) CarryoutpostprocessingfortheG/Laccount.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

Banks→Incomings→BankStatement→Reprocess.

FieldNameorDataType Values

Company Code AC##

House Bank 1000

Account ID 1000

Statement Date <today's date>

Choose Execute.

TheEditBankStatementscreenisthendisplayed.

Double-clicktheitemyouwanttopostprocess. Youcannowseeall

theinformationyouneedfor postprocessing.

Nowpostthedocument. Younoticethatthecustomerhaspaidwithout

deductingdiscount,althoughhewouldhavebeenentitledtoit. Deduct

theamountofthediscountandcontinueposting.

The green checkmark and the document number indicate that the

postingandopenitemclearingweresuccessful.

134

FieldNameorDataType	Values
Company Code	AC##
House Bank	1000
Account ID	1000
Statement Date	<today's date>

第 143 页 / 共 213 页

AC805 Lesson: Application View: Electronic Bank Statement Entry

Lesson Summary

You should now be able to:

• Import bank statement data electronically.

• Explainthevariouspostingoptionsandtherelatedpostprocessing.

• Handlethetransactionsforclearingopenitems(documentdetermination).

135

第 144 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Lesson: Customizing: Electronic Bank Statement Entry

Lesson Overview

ThislessonlooksatCustomizingforelectronicbankstatemententryandposting.

Lesson Objectives

After completingthislesson, you will beable to:

• Seetheconnectionbetweenexternaltransactions(businesstransactioncodes

-BTC)andinternaltransactions(postingandaccountdeterminationrules),

and explain the related posting processes

• Explainhowthenotetopayeeisinterpreted, andwhattheoptionsarefor

clearing open items

Business Example

You want to find out more about the system settings required for using the

electronic bank statement in SAP Cash Management. You have several house

banks that use the same business transaction code (BTC) and you want to

configuretheCustomizingsettingsforthesebanksjustonce. Youwanttoassign

differentmethodsforinterpretingthenotetopayeetoindividualtransactionsat

your house banks.

Figure 62: Transactions

Youusecustomizingtoensurethatallbusinesstransactionscommunicatedtoyou

byyourbankusingtheelectronicbankstatementarepostedcorrectly.

136

第 145 页 / 共 213 页

AC805 Lesson: Customizing: Electronic Bank Statement Entry

You allocate transaction types to group together banks that have identical

external transaction codes.

Youcreatekeysforpostingrules. Thepostingrulesrepresentpostingtransactions

typical of the bank statement.

Youthenassignthebusinesstransactions(BTC)tothesepostingrules,depending

onthetransactiontypes. Itisthisassignmentthatmakesitpossibletorecorddata.

However,ifthebanksuppliesanunknownexternaltransactioncode,theimport

program stops and an error message is displayed. Now you can use the term

UNALLOCATED asan external transaction. Thereisthennoneedtorunthe

importagain. Thepostingshouldbemadetoaseparateinterimaccount,which

theaccountanthastopostprocess. Inaddition,youshouldenterthenewexternal

transactioncodeincustomizing, incaseitcomesupagain.

Accountdeterminationiseffectedusingthepostingrules. Thesystemusesthe

internaltransactiontodeterminetheinformationnecessaryforposting(posting

keys, accounts, document type, and so on).

Youcanuseaccountmodificationstohavepostingssenttoaccountsotherthanthe

standard account assignment.

Figure 63: Account Determination

The internal transactions are used to find the posting rules and necessary

information(postingkeys, accounts, andso on).

Thesystemusesthepostingareatodeterminewhetheritshouldposttheitemsto

thegeneralledger/bankaccounting(1)orsubledger(2).

Thepostingtypecontrolsthedataupdate. Thepostingtypedeterminestheposting

rules(example: G/Lposting, subledgerposting,andsoon).

Theaccountsaresetwiththeiraccountsymbols. TheAccountSymbolsareused

todeterminewhichaccountnumber shouldbeused. Advantage: Nonewtable

entriesarerequiredforpostingsofthesametypemadetodifferentbanks.

137

第 146 页 / 共 213 页

Unit5: BankStatement–ElectronicEntry AC805

Apostingkeyortheaccountremainsfreeforclearingpostings. Thedatarequired

here for the clearing postings is taken from the check information (drawer,

document number, and so on).

Bank statement items that have been selected for clearing can now posted

On-Account. Thiscanbeanadvantageifthecustomerfortheoriginalposting

can beidentifiedasthepayment can bepostedto thecustomerledger for later

clearance. Inaddition,bankclearingaccountscanbeaccessedwithinthesystem

for the purposeof makingthe account posting.

Figure 64: Interpretation Algorithm

Duringtheelectronicbankstatementimport,thesystemidentifiesthetransactions

using the settings you have entered in earlier steps to determine how each

transactionmustbeposted. Thesystemfindsthemostimportantinformationfor

theclearingprocess(forexample,customeropenitemsareclearedwhencashis

received)bymeansofthedocumentnumberorreferencedocumentnumberinthe

note-to-payee line in the bank statement.

Sometimes,theinformationinthenote-to-payeefieldisincomplete–forexample,

thefirstcharactersofthedocumentnumbermaybemissing. Theinterpretation

algorithmcannotdoanythinginsuchcases. Itcannotfindtherelevantdocument

numbers in the system and the document cannot be posted. You then have to

postprocess the transactions manually.

You can increase the success rate of the document number search by defining

modelsfor documentnumbers. Thesystemsearchesusingthesesearchstrings

beforetheinterpretationalgorithmcomesintoplay.

138

第 147 页 / 共 213 页

AC805 Lesson: Customizing: Electronic Bank Statement Entry

Lesson Summary

You should now be able to:

• Seetheconnectionbetweenexternaltransactions(businesstransactioncodes

-BTC)andinternaltransactions(postingandaccountdeterminationrules),

and explain the related posting processes

• Explainhowthenotetopayeeisinterpreted, andwhattheoptionsarefor

clearing open items

139

第 148 页 / 共 213 页

UnitSummary AC805

Unit Summary

You should now be able to:

• Import bank statement data electronically.

• Explainthevariouspostingoptionsandtherelatedpostprocessing.

• Handlethetransactionsforclearingopenitems(documentdetermination).

• Seetheconnectionbetweenexternaltransactions(businesstransactioncodes

-BTC)andinternaltransactions(postingandaccountdeterminationrules),

and explain the related posting processes

• Explainhowthenotetopayeeisinterpreted, andwhattheoptionsarefor

clearing open items

140

第 149 页 / 共 213 页

Unit 6

Cash Concentration

Unit Overview

ThischapterlooksatcashconcentrationintheapplicationandinCustomizing.

Unit Objectives

After completing thisunit, you will beableto:

• Createand processconcentration proposals.

• Print and send concentration correspondence.

• Handlethepostingproceduresusedincashconcentration.

• EntertheconcentrationspecificationsinCustomizing.

• Carry out cash concentration.

Unit Contents

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

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

Exercise 11: Cash Concentration ........................................153

141

第 150 页 / 共 213 页

Unit6: CashConcentration AC805

Lesson: Application View: Cash Concentration

Lesson Overview

Thislessonlooksatthecashconcentrationapplications.

Lesson Objectives

After completingthislesson, you will beable to:

• Createand processconcentration proposals.

• Print and send concentration correspondence.

• Handlethepostingproceduresusedincashconcentration.

Business Example

At the end of each morning, you want to combine your various bank account

balances in one target account, thereby obtaining a clear overview of your

company'sliquidity. Havinginformedthebanksbytelephone,youusethesystem

toprintyour correspondenceforms(revisedasnecessary)sothatyoucansend

themtothebankstoo. Youthenneedtomakeanadvanceconcentrationproposal

posting,sothatyoucanusethebankstatementthenextdaytomakethepostings

to the current accounts.

Cashconcentrationinvolvesmovingthebalancesfromvariousbankaccountsto

onetarget account, keepingdefined minimumbalancesinthesourceaccounts.

Thesystemcreatesaconcentrationproposalbasedonthegrouping. Theproposal

containsthebalancefor theendoftheday, andtheplanningresult-that as, the

likelyaccounttransfers. Youcancorrecttheconcentrationproposalatanystage

intheprocess. Theresultisprintedandtakestheformofpaymentorderstothe

banks. Paymentadvicesarealsocreated. Theyarenecessaryfor thenewbank

balance at value date.

142

第 151 页 / 共 213 页

AC805 Lesson: Application View: Cash Concentration

Figure 65: Cash Concentration: Overview

The grouping contains only those costs that are to be included in cash

concentration. Youcandefinedifferentgroupingsincaseswheretheconcentration

procedure is different.

Youhavetheoptionof concentratingbalancesforanumberof companycodes

atthesametime. Youdothisbymeansofaworklist,whichcombinesanumber

of company codes.

Cashconcentration can be startedas areport program, which meansvariants

can be used.

143

第 152 页 / 共 213 页

Unit6: CashConcentration AC805

Figure 66: Cash Concentration: Report

Procedure for running the report program:

• Enterthecompanycodeor,ifyouareconcentratingcashformorethanone

company code, the worklist.

• In the Planned to field, enter the planning date up to which you want to

concentrate balances.

• Enter a grouping term in theGrouping field, thereby selecting particular

accountsforconcentration(ACBANK-IST,forexample).

• Enterthecashmanagementnamefortheaccountwheretheamountsareto

beconcentrated(DBGIRO,forexample)alongwiththetargetcompanycode.

• Ifrequired,usetheMinimumBalancefieldtostipulatetheminimumbalance

anaccountmusthavebeforeitisselectedforcashconcentration.

• In the Planning Type field, enter a planning type assigned to cash

concentration.

The plannable amount is the total of the cash management end balances, less

any defined minimum balances applicable. This need not be the case for the

targetaccountbecausethetargetaccountmustnothaveanegativebalance. You

can process the amounts.

Onceyouhaveprocessedtheconcentrationproposal,youcancreatetwopayment

advices for each payment order. Oneadvice is for the sender account and one

is for the receiver.

144

第 153 页 / 共 213 页

AC805 Lesson: Application View: Cash Concentration

Figure 67: Cash Concentration: Posting Processes

Confirmcreationoftheadvicesintheadditionalwindow. Thesystemtellsyou

thatadviceshavebeencreated,andyoureturntotheinitialscreen.

With the posting program, you can post payment advices created during cash

concentrationtotherelevantaccounts. Theprogramcreatesabatchinputsession

for thepostingsandarchivesthepayment advices.

Theprerequisiteforthepostingisthatanaccountforpostingmustbeenteredin

thecustomizingtable(paymentmethodsandminimumbalances).

Youcansimulatethepostingsfirst. Thesimulationdoesnotcreateabatchinput

sessionforthepostings,nordoesitarchivethepaymentadvices. Itdoes,however,

output the list.

Statementsfortheaccountinquestioncomethenextdayandcleartheadvance

postings in the relevant clearing accounts.

145

第 154 页 / 共 213 页

Unit6: CashConcentration AC805

Figure 68: Cash Concentration and Payment Program

Paymentrequestsaredocumentsusedtocreatepaymentmedia. Theyareusually

generatedautomaticallywhentransactionsdueareposted. Theyarethenregulated

(individuallyortogether)usingF111,thepaymentprogramforpaymentrequests.

Figure 69: Payment Program Parameters

Field selection controlenablesyou toregulatewhich inputparameterfields

are shown or hidden.

146

第 155 页 / 共 213 页

AC805 Lesson: Application View: Cash Concentration

Incustomizingforbankaccounting, youcanusetheglobalsettingstostipulate

which of the following fields should appear and be ready for input when you

enter payment parameters:

• Vendor accounts

• Customer accounts

• G/L accounts

• Created on

• Origin

Youcanusetheoriginindicatortodetermineforwhichapplicationpaymentsare

tobegenerated. TR-CM-BTforbankaccountcarryovers.

147

第 156 页 / 共 213 页

Unit6: CashConcentration AC805

Lesson Summary

You should now be able to:

• Createand processconcentration proposals.

• Print and send concentration correspondence.

• Handlethepostingproceduresusedincashconcentration.

148

第 157 页 / 共 213 页

AC805 Lesson: Customizing: Cash Concentration

Lesson: Customizing: Cash Concentration

Lesson Overview

Thislooks at Customizing for cash concentration.

Lesson Objectives

After completingthislesson, youwillbeable to:

• EntertheconcentrationspecificationsinCustomizing.

• Carry out cash concentration.

Business Example

Whencashisconcentrated,minimumbalancesshouldcontinuetobeheldinthe

accounts. ThishastobespecifiedinCustomizing. Youalsohavetodefinethe

clearingaccount fortheconcentrationproposalposting.

Figure 70: Concentration Specifications

To be able to use cash concentration, you must first enter some customizing

settings.

Youmustenteratleastoneclearingaccounttowhichpostingsaremadeduring

cash concentration. You can haveseparateclearing accounts for the debit and

creditpostingsthatarisewhencashconcentrationpaymentadvicesareposted(not

required when payment requestsare created).

149

第 158 页 / 共 213 页

Unit6: CashConcentration AC805

Youcanconcentrateamountsmovingbetweenbanksbymeansofanintermediate

account. Theamountsdonotthenflowdirectlytothetargetaccount,buttothe

interimaccount. Theyarethentransferredfromtheretothetargetaccount. This

meansthatnobodycanusethepaymentadviceandaccompanyingpaymentorder

totracetheaccounttowhichtheamountsarefinallyposted.

You defineamountsforaccounts whenconfiguringthesystem. Bychanging

the minimum balances/planned balances and tolerances as you carry out cash

concentration, you can change the closing balances in your accounts. If the

balanceinanaccountiswithinthetolerancelimits,notransfertakesplace.

Inaddition, you can definepaymentadviceamounts for eachaccount. Inthe

application itself, you can specify a minimum payment advice amount cash

concentration initial screen. This applies to all the accounts involved in the

concentration.

Figure 71: Concentration - Configuration Examples

Example1: Concentrationwithina companycode

Example 2: Concentration for a group

Example3: Concentrationwithinacompanycode,usinganinterimaccount

150

第 159 页 / 共 213 页

AC805 Lesson: Customizing: Cash Concentration

Figure 72: Cash Concentration – Correspondence

Thesystemautomaticallygeneratesconfirmationsforthepaymentordersissued.

Tothisend,youmustcreatetheappropriateformandassignittotheprogram.

Thepaymentrecipientcanbeprintedontheform. Thisisparticularlyimportantin

thecaseofpaymentadvicescoveringmorethanonecompanycode.

Confirmationscan begeneratedfor thebankafter you haveconfirmedthat the

payment advices have been created.

Figure73: ConcentrationConfirmation–AddressandAccountNumber

Thehousebankandaccountkeyinthebankaccountmasterrecordsareusedto

determinethebankkey,bankaccountnumber,andtheaccompanyingaddressdata.

151

第 160 页 / 共 213 页

Unit6: CashConcentration AC805

InCustomizingforbankaccounting,youcanusetheglobalsettingstostipulate

which of the following fields should appear and be ready for input when you

enter payment parameters:

• Vendor accounts

• Customer accounts

• G/L accounts

• Created on

• Origin

Ifyoudonotwanttosetanyrestrictionsandalwayswanttopayallitemsthatare

due, do not select any of these fields.

Use the Customizing settings for the origin indicator to control the following

when processing payment transactions:

• Whetherthepaymentprogramshouldchecktheamountsplanned. Ifyou

set this indicator, the program does not check the amounts planned for

payment requests.

• Whethertheaccountdeterminationintheapplicationorthatinthepayment

programshouldbeusedtodeterminethebankclearingaccountforpayments.

If you do not set thisindicator, theaccount determination function in the

programisusedtodeterminethebankclearingaccount. Theresultofthe

applicationaccount determination isignored.

• Whether the characteristics alreadydefined for theorigin should beused

whenpaymentrequestswithdifferentsourcesarebeingcleared. Ifyouset

thisindicator,thepaymentprogramusesthecharacteristicsforthissource

whenclearingpaymentrequestswithdifferentsources.

The origins whose payment requests are allocated against each other must be

assignedtoeachother. YoudothisinCustomizingforbankaccounting.

152

第 161 页 / 共 213 页

AC805 Lesson: Customizing: Cash Concentration

Exercise 11: Cash Concentration

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Create a bank clearing account for cash concentration and complete the

payment method table in Customizing.

• Create a cash concentration proposal.

• Print the cash concentration proposal.

• Post the cash concentration proposal.

Business Example

Youhavedecidedtoconcentratethedailyaccountbalancesinyourvariousbank

accountsinatargetaccount(DRGIRO).Youwillnowenterthenecessarysystem

settingsandcarryoutcashconcentration. Thenprintoutthecashconcentration

proposaltosendit tothebankswhoseaccountsyouwanttoconcentrate. Then

posttheproposalbywayofthebankclearingaccounts,andcomparethemwith

the next day's bank statement.

Task:

Youwanttobeabletoincludeyournewaccountincashconcentrationandthen

carry out cash concentration.

1. IntheSAPReferenceIMG,addyournewbankdetails(11##00)tothecash

concentration table. Do not concentrate cash via an interim account.

Entertheplannedbalance/plannedminimum(1,000/100)andtheclearing

account(11##05)towhichpostingswillbemadewhenthepaymentrequests

generated during bank cash concentration are converted to accounting

documents.

Ifyouhavenotyetcreatedaccount11##05, dosonow.

2. Onceallthecashmanagementtransactionshavebeenprocessed,youmust

decidewhatitistobedonewiththebankbalances. Youdecidetotransfer

theaccountbalancestoaccountDRGIRO(113200). Youwanttotransfer

infullthousandsonly(groupingACBANK-IST,advicetype: CL).Please

notethatyouhavetoenterthecashmanagementaccountnameandnotthe

G/L account number.

3. Createcorresponding confirmations tothebanks(simulatetheseon your

screen).

4. YounowwanttocreateFIpostingsfromtheconcentrationpaymentadvices.

Continued on next page

153

第 162 页 / 共 213 页

Unit6: CashConcentration AC805

Thenposttheconcentrationmemosforyourcompanycode,payingattention

totheaccountspostedto(+++++5). Runthebatchinputsession.

5. Assignaccounts11##00and11##05togroupingACCLEARING.Display

thecashposition(grouping: ACCLEARING).Theconcentrationpostings

are on level B5.

154

第 163 页 / 共 213 页

AC805 Lesson: Customizing: Cash Concentration

Solution 11: Cash Concentration

Task:

Youwanttobeabletoincludeyournewaccountincashconcentrationandthen

carry out cash concentration.

1. IntheSAPReferenceIMG,addyournewbankdetails(11##00)tothecash

concentration table. Do not concentrate cash via an interim account.

Entertheplannedbalance/plannedminimum(1,000/100)andtheclearing

account(11##05)towhichpostingswillbemadewhenthepaymentrequests

generated during bank cash concentration are converted to accounting

documents.

Ifyouhavenotyetcreatedaccount11##05, dosonow.

a) Solution for completingthepaymenttable.

Customizing: Treasury

SAP Reference IMG → Financial Supply Chain Management →

CashandLiquidityManagement→CashManagement→Business

Transactions→CashConcentration→DefineIntermediateAccount,

Clearing Accounts and Amounts

Copyanentryorenteryourdata. ChooseNewEntries.

FieldNameorDataType Values

Company Code AC##

Bank Account 11##00

Planned Balance/Planning 1000/ 100

Minimum

ClearingAccountDebit/Credit 11##05

ThebankclearingaccountiscreatedintheFIapplicationcomponent.

2. Onceallthecashmanagementtransactionshavebeenprocessed,youmust

decidewhatitistobedonewiththebankbalances. Youdecidetotransfer

theaccountbalancestoaccountDRGIRO(113200). Youwanttotransfer

Continued on next page

155

FieldNameorDataType	Values
Company Code	AC##
Bank Account	11##00
Planned Balance/Planning Minimum	1000/ 100
ClearingAccountDebit/Credit	11##05

第 164 页 / 共 213 页

Unit6: CashConcentration AC805

infullthousandsonly(groupingACBANK-IST,advicetype: CL).Please

notethatyouhavetoenterthecashmanagementaccountnameandnotthe

G/L account number.

a) Solution for cash concentration.

ChooseSAP EasyAccess→Accounting→Financial SupplyChain

Management→CashandLiquidityManagement→CashManagement

→Planning→CashConcentration→Create.

Enter your selections (including grouping ACBANK-IST, target

account DRCURRENT, target company code, payment advice

specifications).

FieldNameorDataType Values

Company Code AC##

Grouping ACBANK-IST

Currency EUR

Minimum Balance Your option

TargetAccountName DRGIRO

TargetCompanyCode AC##

Planning Type CL

Planning Currency EUR

Choose Execute.

Save the payment advices (disk icon). (Confirm that you want to

createthepaymentadvicesbychoosingYes). Youcandisplaythenew

concentrationpaymentadvicesinthecashposition.

3. Createcorresponding confirmationsto thebanks(simulatetheseonyour

screen).

a) Solutionforcreatingtheconfirmationforthebanks.

ChooseSAP EasyAccess→Accounting→Financial SupplyChain

Management→CashandLiquidityManagement→CashManagement

→Planning→CashConcentration→PrintConfirmations.

EnterAC## as your company code.

4. YounowwanttocreateFIpostingsfromtheconcentrationpaymentadvices.

Continued on next page

156

FieldNameorDataType	Values
Company Code	AC##
Grouping	ACBANK-IST
Currency	EUR
Minimum Balance	Your option
TargetAccountName	DRGIRO
TargetCompanyCode	AC##
Planning Type	CL
Planning Currency	EUR

第 165 页 / 共 213 页

AC805 Lesson: Customizing: Cash Concentration

Thenposttheconcentrationmemosforyourcompanycode,payingattention

totheaccountspostedto(+++++5). Runthebatchinputsession.

a) Solution for posting the concentration payment advices in your

company code.

ChooseSAPEasyAccess→Accounting→FinancialSupplyChain

Management→CashandLiquidityManagement→CashManagement

→Planning→CashConcentration→Post. (Rememberthetestrun

indicator).

Enter AC## as your company code.

The batch input session is generated.

ChooseSystem→Services→BatchInput→Sessions→(Selectthe

session and run it in the foreground).

5. Assignaccounts11##00and11##05togroupingACCLEARING.Display

thecashposition(grouping: ACCLEARING).Theconcentrationpostings

are on level B5.

a) Solutionfordisplayingyourdatainthecashposition.

See the previous solutions.

157

第 166 页 / 共 213 页

Unit6: CashConcentration AC805

Lesson Summary

You should now be able to:

• EntertheconcentrationspecificationsinCustomizing.

• Carry out cash concentration.

158

第 167 页 / 共 213 页

AC805 Unit Summary

Unit Summary

You should now be able to:

• Createand processconcentration proposals.

• Print and send concentration correspondence.

• Handlethepostingproceduresusedincashconcentration.

• EntertheconcentrationspecificationsinCustomizing.

• Carry out cash concentration.

159

第 168 页 / 共 213 页

UnitSummary AC805

160

第 169 页 / 共 213 页

Unit 7

Liquidity Forecast

Unit Overview

Thischaptertakesadetailedlookattheliquidityforecast.

Unit Objectives

After completing thisunit, you will beableto:

• Explainthefeaturesandintegrationaspectsofmedium-termplanning.

• Explain thesignificanceof planning groups.

• Configure subledger accounts.

• Configurefieldselectioncontrolforthesubledgeraccounts.

• Configureandaccessthedisplayoptionsfornoteditems.

• Configurescreencontrol for document entry.

• Ensureintegrationofspecialgeneralledgertransactions.

• EnsureintegrationofdatafromMM/SDandTreasury.

Unit Contents

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

Exercise 12: Liquidity Forecast...........................................169

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

161

第 170 页 / 共 213 页

Unit7: LiquidityForecast AC805

Lesson: Application View: Liquidity Forecast

Lesson Overview

Thislessonlooksattheliquidityforecastapplications.

Lesson Objectives

After completingthislesson, you will beable to:

• Explainthefeaturesandintegrationaspectsofmedium-termplanning.

• Explain thesignificanceof planning groups.

• Configure subledger accounts.

Business Example

Nowthat you have acomprehensiveoverviewof howbank andbank clearing

accountsdevelopandhowtomakethenecessarysystemsettings,younowwantto

knowhowtoobtainamedium-termviewofthesubledgeraccounts.

Thecashpositionshowshowyourbankaccountswillmoveinthenextfewdays.

Meanwhile, theliquidityforecastillustratesliquiditychangesinthesubledger

accounts. Functions are also supported which you can use to obtain relevant

information on forecast payment flows. This information appears as planned

items in the liquidity forecast.

Figure 74: Features of the Liquidity Forecast

Theinformationisbasedonpaymentsinandoutfrom/tocustomersandvendors,

pertheopen items. Asplanningforincomingandoutgoingpaymentscoversa

largertimeframe, theprobabilityofthepaymentsoccurringonthedaygivenis

less than in the cash position.

162

第 171 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Thefollowingareexamplesofsourcesofplanninginformationfortheliquidity

forecast:

• Receivablesandcommitmentsasexpectedincomingandoutgoingpayments

• Planned wage and salary payments

As with the cash position, you use groupings to set up the liquidity forecast

structure. Thegroupingterm isusedtocombineparticular levelsandplanning

groups for display purposes.

Figure 75: Integration - Liquidity Forecast

Likevendors,customersaredividedintoplanninggroups

163