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

第 172 页 / 共 213 页

Unit7: LiquidityForecast AC805

Figure 76: Prerequisite I – Planning Groups

You can freely define the criteria used (net payer, risk payer, according to

geographical location).

Levelsprovideinformationaboutthetypeofaccounttransaction.

Youhavetoenteradefinedplanninggroupinthemasterrecordsothatthesystem

cantransferdatabetweenthecustomer/vendoraccountsandtheliquidityforecast.

Figure 77: Prerequisites II – Account Master

164

第 173 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Figure 78: Payment History – Planning Date

Thesystemtakesintoaccountthecustomerpaymenthistory(cashdiscount)when

determining the planning date if you select theRecord Payment History field

in the customer master record.

Thelastthreeperiodsinwhichpaymentshavebeenmadearetakenintoaccount

(shorttermpaymenthistory). Thecalculationisweightedbyamount.

Youcantracethepaymenthistoryaspartofaccountanalysis.

Theliquidity forecast includesanewparameterfor taking account of payment

dates,andselectionsforcustomerandvendorpaymentdates. Youcanusetheseto

changetheliquidityforecastdisplaysothatamountsarenolongerdisplayedasof

therelevantplanningdate, but asof thepayment date.

Ifyoubranchfromtheliquidityforecasttothelineitems,thesystemtakesaccount

of thechanged display. Thismeansthat thelineitemsassigned to therelevant

payment date are displayed.

Totakeadvantageofthisnewfeature,youneedtomaintaintherelevanttablein

customizing. LookattheF1helpfor theparameter, selections, andviewfields

for more information.

165

第 174 页 / 共 213 页

Unit7: LiquidityForecast AC805

Figure 79: Integration - Payment Block

Inthismenuoption,youcandefinetheassignmenttotheblockedlevelsforthe

levelsintheliquidityforecast. Ifyouthenmakeapostingwithpaymentblocked,

thesystemusestheblockedlevelinsteadofthestandardlevelfor theplanning

group in question.

The payment block on the amounts displayed in the liquidity forecast is then

clearly identifiable.

Figure 80: Integrating special transactions

166

第 175 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Lineitemsresultingfromspecialtransactionsaretransferredtoaspeciallevel.

Itiseasier tomonitor scheduled specialG/L transactionsinCashManagement

than in Accounting.

This makesthereconciliation account irrelevant.

Uselevelsthatbeginwith “F”astheseareFIpostings. Itisagoodideatouse

thespecialG/Lindicatorasthesecondletter(“FF”fordownpaymentrequests,

for example).

167

第 176 页 / 共 213 页

Unit7: LiquidityForecast AC805

168

第 177 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Exercise 12: Liquidity Forecast

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Enteroutgoingandincominginvoicessothatyoucandisplaytheminthe

liquidity forecast

• Ensurethatthecustomerpaymenthistoryisaccuratelyrecorded

Business Example

You want to use the liquidity forecast to obtain an overview of medium-term

liquidity. Boththebankaccountsandsubledgeraccountsshouldbeincluded. You

wanttoreproduceoutgoingandincominginvoicesintheliquidityforecast.

Inaddition,youwanttorecordthecustomerpaymenthistorytotakeaccountof

theeffectsintheliquidityforecastinthesubsequenttransactions.

Task:

Carry out the following tasks.

1. Postthefollowingoutgoinginvoice(documentdate: today):

Customer: T-F00B00, amount: 10,000, output tax: 1O, calculate tax,

payment terms: ZB01

Offset posting: Account 800200

Postthefollowingincominginvoice(documentdate: today):

Vendor: T-F00B00,amount: 10,000,inputtax: 1l,calculatetax.

Offset posting: Account 400020

2. Checkyourentriesbydisplayingmedium-termcashmanagement,liquidity

forecast(grouping: ACPERSONEN/ACGESAMT).

3. Create customer T-F00B## in your company code (AC##) (reference

customer: T-F00B00).

Assign cash management group E2to thiscustomer and set thePayment

History Record checkbox.

4. Use the account analysis to view the customer accounts T-F00B00 and

T-F00B##,thelineitemdisplay. ThenchooseGototoaccessthepayment

history analysis.

Postthefollowingoutgoinginvoice(documentdate: today):

Continued on next page

169

第 178 页 / 共 213 页

Unit7: LiquidityForecast AC805

Customer: T-F00B##, amount: 50,000, output tax: 1O, payment terms:

ZB01.

Offset posting: Account 800200

Now use the account analysis again to view the line item display for

customer account T-F00B##.

Thepaymenthistoryanalysis(viaGoto)isstillemptybecausenopayments

have been received.

Calluptheliquidityforecast(incrementindays,grouping: ACGESAMT).

Theinvoiceisplanned for 14 days from now.

The customer has paid.

Posttheincomingpaymentwithposting,document,andvaluedates20days

fromnow(bankaccount113102,amount49,000-customerT-F00B##).

ThesystemnowdisplaysthepaymenthistoryforcustomerT-F00B##.

Ifyounowpostanotheroutgoinginvoice(documentdate: “today”),what

planning date would then appear?

170

第 179 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Solution 12: Liquidity Forecast

Task:

Carry out the following tasks.

1. Postthefollowingoutgoinginvoice(documentdate: today):

Customer: T-F00B00, amount: 10,000, output tax: 1O, calculate tax,

payment terms: ZB01

Offset posting: Account 800200

Postthefollowingincominginvoice(documentdate: today):

Vendor: T-F00B00,amount: 10,000,inputtax: 1l,calculatetax.

Offset posting: Account 400020

a) Solution for posting the invoices.

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsPayable/AccountsReceivable→DocumentEntry→Invoice.

Enter your data.

2. Checkyourentriesbydisplayingmedium-termcashmanagement,liquidity

forecast(grouping: ACPERSONEN/ACGESAMT).

a) Solutionforcheckingtheentriesintheliquidityforecast.

ChooseSAPEasyAccess→Accounting→FinancialSupplyChain

Management→CashandLiquidityManagement→CashManagement

→InformationSystem→ReportsforCashManagement→Liquidity

Analyses → Liquidity Forecast.

Enter your selections.

Notethatapaymenthistoryhasalreadybeenrecordedforcustomer

T-F00B00.

3. Create customer T-F00B## in your company code (AC##) (reference

customer: T-F00B00).

Continued on next page

171

第 180 页 / 共 213 页

Unit7: LiquidityForecast AC805

Assign cash management groupE2 to this customer and set the Payment

History Record checkbox.

a) Choose

SAPEasyAccess→Accounting→FinancialAccounting→Accounts

Receivable →MasterRecords →Create.

Customer: T-F00B##

CompanyCode: Yourcompanycode(AC##)

Reference Customer: T-F00A00

Reference Company Code: AC##

Address: Enter the relevant address

Search Term: AC805

Companycodedata(AccountingManagement):

Cash Management Group: E2

Companycodedata–PaymentTransactions

Payment HistoryRecord: Set checkbox.

Choose Save.

4. Use the account analysis to view the customer accounts T-F00B00 and

T-F00B##,thelineitemdisplay. ThenchooseGototoaccessthepayment

history analysis.

Postthefollowingoutgoinginvoice(documentdate: today):

Customer: T-F00B##, amount: 50,000, output tax: 1O, payment terms:

ZB01.

Offset posting: Account 800200

Now use the account analysis again to view the line item display for

customer account T-F00B##.

Thepaymenthistoryanalysis(viaGoto)isstillemptybecausenopayments

have been received.

Calluptheliquidityforecast(incrementindays,grouping: ACGESAMT).

Theinvoiceisplanned for 14 days from now.

The customer has paid.

Posttheincomingpaymentwithposting,document,andvaluedates20days

fromnow(bankaccount113102,amount49,000-customerT-F00B##).

ThesystemnowdisplaysthepaymenthistoryforcustomerT-F00B##.

Continued on next page

172

第 181 页 / 共 213 页

AC805 Lesson: Application View: Liquidity Forecast

Ifyounowpostanotheroutgoinginvoice(documentdate: “today”), what

planning date would then appear?

a) Solution foranalyzingthepayment history.

Account analysis:

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→Account→Analysis.

Enter your data and choose Enter. Thenchoose Goto to call up the

payment history.

ThepaymenthistoryhasalreadybeenrecordedforcustomerT-F00B00,

but not for T-F00B## yet.

Changing master data:

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→Changemasterdata.

Enter your data (cash management group E2) and select Payment

History Record.

Outgoing invoice:

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→DocumentEntry→Invoice.

Enter your data.

Account analysis:

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→Account→Analysis.

Enter your data and choose Enter. Thenchoose Goto to call up the

payment history.

Liquidity forecast:

ChooseSAPEasyAccess→Accounting→FinancialSupplyChain

Management→CashandLiquidityManagement→CashManagement

→InformationSystem→ReportsforCashManagement→Liquidity

Analyses → Liquidity Forecast.

Enter your selection (increment in days).

Incoming payment:

ChooseSAPEasyAccess→Accounting→FinancialAccounting→

AccountsReceivable→DocumentEntry→IncomingPayments.

Notethelaterdatedeterminedusingthepaymenthistory.

173

第 182 页 / 共 213 页

Unit7: LiquidityForecast AC805

Lesson Summary

You should now be able to:

• Explainthefeaturesandintegrationaspectsofmedium-termplanning.

• Explain thesignificanceof planning groups.

• Configure subledger accounts.

174

第 183 页 / 共 213 页

AC805 Lesson: Customizing: Liquidity Forecast

Lesson: Customizing: Liquidity Forecast

Lesson Overview

ThislessonlooksatCustomizingfortheliquidityforecast.

Lesson Objectives

After completingthislesson, youwillbeable to:

• Configurefieldselectioncontrolforthesubledgeraccounts.

• Configureandaccessthedisplayoptionsfornoteditems.

• Configurescreencontrol for document entry.

• Ensureintegrationofspecialgeneralledgertransactions.

• EnsureintegrationofdatafromMM/SDandTreasury.

Business Example

Before activating the liquidity forecast, you must make a number of settings

in Customizing. You are considering how blocked items and special G/L

transactionsareto bedisplayed intheliquidity forecastand howLogisticsand

RiskManagementdataistobedisplayedintheliquidityforecast/cashposition.

Figure 81: Master Data: Subledger Accounts

175

第 184 页 / 共 213 页

Unit7: LiquidityForecast AC805

You can control the field status on particular screens directly in the Cash

ManagementIMG.Youcandothisat differentlevels:

• Forallcustomers/vendorsinanaccountgrouporcompanycode.

• Forallcustomers/vendorswhoarecreatedorchangedinAccounting(Sales,

centrally).

Figure 82: Planning Data: Screen Control

Planning groups differentiate customers and vendors according to particular

characteristics (customer in France), behavior (takes cash discount), or risks

(creditrating). Theyareuser-definableandareenteredintheCashManagement

Groupfield in thecustomer or vendormasterrecord.

Ifyouselect theScreen controloption (SCn), thePlanning DateandPlanning

Levelfieldsarereadyforinputwhendocumentsareenteredorchanged. Youcan

overwritethevaluesthesystemautomaticallydefaultsforthesefields.

Figure 83: Blocked Documents

176

第 185 页 / 共 213 页

AC805 Lesson: Customizing: Liquidity Forecast

Youcanallocateblocked levelsor blockindicatorstothestandardlevels. The

system then assigns the amount to the blockedlevel when theposting is made

withapaymentblock. Ifthedocumentisunblocked,theamountistransferredto

the standard level.

Figure 84: Integration – SpecialGeneralLedger(SGL)

Special G/L postings can be displayedand monitored at a special level in the

liquidityforecast. Twolevelsarealreadydefinedinthestandardsystem:

• Down payment request (FF)

• Bill of exchange receivable (FW)

Notetheincomingpaymentinthebankclearingaccountinthecashposition. The

discountedamount of thebillofexchangeisdisplayedinthisaccountuntil the

commitment is deleted.

177

第 186 页 / 共 213 页

Unit7: LiquidityForecast AC805

Figure 85: Integrating Orders and Purchase Orders

Procedure

1. Maintain the sourceindicators(MMF, SDF)

2. Maintain planning levels(M1, M2, M3, S2)

3. Maintain Logistics levels (M1, and so on)

4. Activate Cash Management

5. Activate MM & SD Update Functions

Figure 86: Integrating Orders and Purchase Orders

178

第 187 页 / 共 213 页

AC805 Lesson: Customizing: Liquidity Forecast

Purchaseorders(MM)andsalesorders(SD)aredisplayedinspeciallevelswithin

planning.

Youcanfreelydefinetheselevels. Theyrequireaspecialsourcesymbol(optional).

Theinternalcodeyouspecifyintegratessalesordersandpurchaseorders,purchase

requisitionsandschedulingagreementsintoCashManagement. Agencybusiness

from Logistics(vendor invoices, invoice lists, settlement requests) can alsobe

recorded in the liquidity forecast.

Figure 87: Integration with Other SAP Processes

Figure 88: Selection of Financial Instruments

Short-termmoneymarketorforeigncurrencydealsareonewayofdealingwith

liquidityshortfallsor surpluses. Forthemediumtolong-term, investmentsand

borrowingsarerepresentedbysecurityandloantransactions.

Derivatives,ontheotherhand,areameansofhedginginterestandcurrencyrisks.

179

第 188 页 / 共 213 页

Unit7: LiquidityForecast AC805

Figure 89: Trading: Create Fixed-Term Deposit

TheupdatetoCashManagementdistinguishesbetweentwocases:

• Option 1 (liquidity forecast):

Ifnopaymentdetailshavebeenmaintainedinthetransactions,thatis,the

bank accounts are not known, the cash flow for a bank account or bank

clearingaccountcannotbedisplayed. Toensurethatthecashflowappears

inCashManagement,theamountforsubledgeraccountsisdisplayed. The

systemthendrawsontheplanninggroupspecifiedinthemasterrecordfor

the business partner.

• Option 2 (cash position):

Ifpaymentdetailsarespecifiedinthetransaction,thatis,thebankaccounts

areknown,thecashflowappearsinCMonthelevelassignedtotherelevant

bank bank (clearing) account.

180

第 189 页 / 共 213 页

AC805 Lesson: Customizing: Liquidity Forecast

Figure 90: Posting Using Bank Clearing Accounts (Interaction of Risk

Management/Cash Management)

Thegraphicillustrateshowprocessingshouldideallywork,showinghowTreasury

ManagementandCashManagementusuallyworktogetherandhowtheFinancial

Accounting posting is made.

Payments are usually triggered by the business partner (bank) and further

processedinCashManagementbymeansoftheelectronicbankstatement.

Figure91: TransfertoFinancialAccounting–LogicalProcess

181

第 190 页 / 共 213 页

Unit7: LiquidityForecast AC805

Every activity in a business transaction is displayed automatically in Cash

Management. If you so stipulate, each onecan bedisplayed andanalyzed ina

specific level.

Cash flows resulting from transactions become visible in Cash Management

immediately, whether or not they havealready been posted. You can then use

them in planning.

UsecustomizingtomaintaintheplanninglevelsforG/Land/orsubledgeraccounts

wheretherelevantproducttypesandtransactionsaretobedisplayed.

Example:

• Closedfixed-termdeposit: TBlevel-timedeposit

• Postedforeignexchangetransaction: levelB5-bankclearingaccount

• Oncethebankstatementhasbeenreceived: LevelF0-Bankaccount

182

第 191 页 / 共 213 页

AC805 Lesson: Customizing: Liquidity Forecast

Lesson Summary

You should now be able to:

• Configurefieldselectioncontrolforthesubledgeraccounts.

• Configureandaccessthedisplayoptionsfornoteditems.

• Configurescreencontrol for document entry.

• Ensureintegrationofspecialgeneralledgertransactions.

• EnsureintegrationofdatafromMM/SDandTreasury.

183

第 192 页 / 共 213 页

UnitSummary AC805

Unit Summary

You should now be able to:

• Explainthefeaturesandintegrationaspectsofmedium-termplanning.

• Explain thesignificanceof planning groups.

• Configure subledger accounts.

• Configurefieldselectioncontrolforthesubledgeraccounts.

• Configureandaccessthedisplayoptionsfornoteditems.

• Configurescreen controlfor document entry.

• Ensureintegrationofspecialgeneralledgertransactions.

• EnsureintegrationofdatafromMM/SDandTreasury.

184

第 193 页 / 共 213 页

Unit 8

Checking Reports, Data Transfer,

Reorganization

Unit Overview

Thischapterlooksatsomeimportantcheckingreports,aswellasdatatransferand

reorganization in cash management.

Unit Objectives

After completing thisunit, you will beableto:

• HandlethevariousmonitoringtoolsinSAPCashManagementsothatthe

data is managed correctly in the system

• Explainhowthecashingtimeofcheckstovendorsisdetermined,andhow

you transfer them tothevendor master record

• Activate Cash Management

• Transfer datafrom oldsystemsorfeeder systems

• Distinguishbetweenthevariousreorganizationtransactions

Unit Contents

Lesson: Checking Programs..................................................186

Exercise 13: Extended Bank Processing: Checking Programs......189

Lesson: Data Transfer and Reorganization .................................192

185

第 194 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

Lesson: Checking Programs

Lesson Overview

Thislessonlooksatsomeimportantcheckingprograms.

Lesson Objectives

After completingthislesson, you will beable to:

• HandlethevariousmonitoringtoolsinSAPCashManagementsothatthe

data is managed correctly in the system

• Explainhowthecashingtimeofcheckstovendorsisdetermined,andhow

youtransfer them tothevendor master record

Business Example

To ensure that payment flows are not duplicated in the system, you want to

comparethestatementpostingsdailywiththepaymentadvices. Inaddition,you

want to monitor the value dates set by the bank. By determining the maturity

periodofvendorchecks,youcanmaintainthepaymentprogramandthevendor

masterrecord,sothatyoucanthenusethemforplanninginrespectofupcoming

transactions.

Figure92: ComparingPaymentAdviceswiththeBankStatementorAccount

186

第 195 页 / 共 213 页

AC805 Lesson: Checking Programs

Individual records which are no longer valid can be archived with the help of

thecomparisonreport. Thepayment advicecomparisonselectsadvicesfrom

theselectedplanningperiodandcomparesthemwiththebankpostings. Ifyou

workwiththeelectronicbankstatementandmanualindividualrecords,youmust

run the payment advice comparison.

• With Account

The With Account option enables memo records to be manually or

automaticallycomparedwith account postings.

• With Bank Statement

TheWithBankStatementoptionenablesmemorecordstobemanuallyor

automatically compared with bank data store information. You can also

select archived memo records.

Individual records cleared by bank postings can be archived, manually or

automatically. Archived advices are no longer active - that is, they no longer

appearinthecashposition. Thispreventsthesameitemappearingtwiceinyour

planning.

Inthemanualcomparison,postingsandadvicesarelistedinascendingorder,by

amount.

In both program, conversion of the payment advices into the relevant account

currencyispossibleusingtheappropriateparameter. Thismeansthat payment

advicesenteredincurrenciesotherthantheaccountcurrencycanbeautomatically

cleared against the bank account or bank account statement, and, if required,

archived.

Figure 93: Comparing Value Dates

You usethe value date comparison to comparethe planned/agreed valuedate

(forexample,fromthecheckdepositorpreliminaryposting)withthevaluedate

postedbythebankinthebankstatement. Theprogramsearchesforthebalance

sheetaccountpostingsrelatingtoallthecleareditemsinabankclearingaccount.

Iftherearedifferences,theprogramlistsbothpostings. Ifthereismorethanone

clearingitemforaposting,theprogramtakesthefirstoneitfinds.

187

第 196 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

Ifyouwanttoseeallthevariancesrelatingtoabankaccount,youshouldcreate

avariantcontainingall therelevantbankclearing accountsintheG/LAccount

selection.

Figure94: CashedChecksAnalysis–G/LAccountandVendor

Youcandeterminetheaveragecashingtimeforyourchecksforeachoutgoing

checkaccountand,usingthisaccount,foreachvendor. Aprogramisavailableto

this end:

The program determines the following data:

• Averagecashing time for checksdeposited

• Averagecashing time for checksstill open

• Numberandtotalamountforallcheckscurrentlyoutstanding

Theaveragecashingtimeisalwayscalculatedweightedbyamount. Ifyouselect

morethanoneoutgoingcheckaccount,theaveragecashingtimeacrossallbanks

isalsodetermined. Tocomparethecashingtimefordifferentamounts,youcan

havethesystemsortthechecksbyamount. Ifyouwanttoderivethecashflow

daterelevantforthecashpositiononthebasisofthecheckingtimescalculated,

youmustsetthedaysuntilthevaluedateinthepaymentprogram. Thisnumberis

addedtothepostingdate. Theoutgoingfundsappearinthecashpositionasofthe

value date resulting from this calculation.

The program also uses the outgoing check accounts to calculate the average

differentbetweenthecheckdepositdateandpostingdate,foreachvendor. You

alsohavetheoptionofcreatingabatchinputsessionwiththevaluescalculatedfor

eachvendor. Ifthesevaluesdifferfromtheentryinthemasterrecord,themaster

recordfieldCheckCashingTimeisupdatedaccordingly.

188

第 197 页 / 共 213 页

AC805 Lesson: Checking Programs

Exercise 13: Extended Bank Processing:

Checking Programs

Exercise Objectives

After completingthisexercise, youwillbeableto:

• Compare payment advices

Business Example

Toensurethatpaymentflowsarenotduplicatedinthesystem,carryoutapayment

advicecomparisonregularlyafterthebankstatementhasbeenposted.

Task:

Topreventtransactionsfrombeingdisplayedtwice,theavailablepaymentadvices

need to be checked.

1. Afterthebankstatementhasbeenposted,therelevantpaymentadvicesmust

bearchived. Createmorethanonepaymentadviceifrequired.

Startthepaymentadvicecomparisoninyourcompanycodeforyourbank

accountsandpayattentiontotheconstraintsonplanningorpostingdates.

Manuallyarchivepaymentadvicesthatyounolongerneed.

189

第 198 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

Solution 13: Extended Bank Processing:

Checking Programs

Task:

Topreventtransactionsfrombeingdisplayedtwice,theavailablepaymentadvices

need to be checked.

1. Afterthebankstatementhasbeenposted,therelevantpaymentadvicesmust

bearchived. Createmorethanonepaymentadviceifrequired.

Startthepaymentadvicecomparisoninyourcompanycodeforyourbank

accountsandpayattentiontotheconstraintsonplanningorpostingdates.

Manuallyarchivepaymentadvicesthatyounolongerneed.

a) Solution for comparing payment advices.

ChooseSAP EasyAccess→Accounting→Financial SupplyChain

Management→CashandLiquidityManagement→CashManagement

→Checking→ComparingPaymentAdvices→WithAccount

Enter your dataand execute the program.

FieldNameorDataType Values

Chart of Accounts: INT

G/L Accounts 113100 - 119999

Company Code AC##

OpenItemsatKeyDate <today>

Posting Date <from two days ago to

today>

Planning Date <from two days ago to

today>

190

FieldNameorDataType	Values
Chart of Accounts:	INT
G/L Accounts	113100 - 119999
Company Code	AC##
OpenItemsatKeyDate	<today>
Posting Date	<from two days ago to today>
Planning Date	<from two days ago to today>

第 199 页 / 共 213 页

AC805 Lesson: Checking Programs

Lesson Summary

You should now be able to:

• HandlethevariousmonitoringtoolsinSAPCashManagementsothatthe

data is managed correctly in the system

• Explainhowthecashingtimeofcheckstovendorsisdetermined,andhow

you transfer them tothevendor master record

191

第 200 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

Lesson: Data Transfer and Reorganization

Lesson Overview

Thischapterlooksatthedatatransferandreorganizationprocedure.

Lesson Objectives

After completingthislesson, you will beable to:

• Activate Cash Management

• Transfer datafromoldsystemsorfeeder systems

• Distinguishbetweenthevariousreorganizationtransactions

Business Example

You have now made all the system settings and want to reproduce financial

accounting and logistics (MM/SD) transactions in Cash Management. What

settings must you make and how is the data transfer carried out? You want to

reorganizethedatabasefromtimetotime,whichinvolvesdeletingoldorexpired

data and creating summary records.

Figure 95: Implementation Support

This function makes it easier to implement Cash Management and use it

productively. Thefollowingactivitiesarenowquickerandeasiertoimplement:

ThemostimportantstepsinactivatingCashManagementinacompanycode

nowappear in justone view. Activating Cash Management for each company

code now involves selecting a single switch.

192

第 201 页 / 共 213 页

AC805 Lesson: Data Transfer and Reorganization

Thesystemstorestherelevantdatainthecustomer/vendormasterrecords. This

is done automatically, according to selection criteria and priorities you define

yourself. Youdonotneedtoleavethisscreentoenterthenecessarysettings. To

ensurethat cash managementgroupsareentered inall themaster records, you

needtospecifyatleastoneprofile(withthelowestpossiblepriority)thatmatches

a vendor/customer if no other profile does.

YouusetheFDFDinitialscreentoaccessindividualprogramsthatsetupthecash

managementfiguresandschedulethemforbackgroundprocessing. Thismeans

youdonotneeddetailedknowledgeofthesetupprogramsinSAPcomponents.

Note that each setup program begins by deleting all Cash Management data.

If there is any any manual planning data, the system will ask you about this

separately,becausesuchdatadoesnotneedtobechangedordeleted.

Thesystemalsoofferssupportforcleaningupdataerrorsandreorganizingcash

management data in master records.

Figure 96: DataSetup: AccountsWith/Without OpenItems

Data for Cash Management should be set up per batch input as thismakes for

better system performance.

You can simulate the data transfer online. When doing this, make as many

selections as possible.

You can transfer data from customer or vendor accounts without making any

specifications (batch only).

Thesystemproposestheminimumselections(fields: ValueDateandDocuments

Updated From) for transferring accountswithout open items (resident). These

minimumselectionsarerequiredforsummarizingtheaccountbalancesandcanbe

overwritten.

193

第 202 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

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

reconstructcashmanagementbecausetheupdatelogicisdifferent. Inthecase

of the G/L account, the G/L account currency is not always adopted; either

the document currency (for G/L accounts managed on an open item basis) or

the G/L account currency (for other G/L accounts) is used instead. To delete

andthenreconstructthecashmanagementdata,usethe DataSetupinthenew

FDFD transaction.

Youdonotneedtochangeordeletememorecordsenteredmanually. TheData

Setup function in transaction FDFD displays a confirmation prompt, asking

whetherthedatarecordsshouldbeirretrievablydeleted. Answer“No”. However,

allothercashmanagementdatamustbereconstructed. Otherwise,thevaluesin

the system will be incorrect.

Figure 97: Data Reconciliation

Thesystemincludesadatareconciliationfunctionthatcanbescheduledfrom

transaction FDFD as a batch job. This program compares the totals records

from tables FDSR and FDSB with the corresponding memo records from the

applicationsorfromtheFIaccountingdocuments. Ifthecashmanagementand

forecasthasbeenreorganized,youmustspecifythesummarizationdatespecified

in thelast reorganizationrun(programRFFDIS00).

Ifthereconciliationdoesnotfindanyerrors,thereisnosystemoutput. However,

wheredifferences between the totals records and the memo records are found,

the totals records are highlighted in the display and followed by a list of the

relevantmemorecords. Theoutputfromthisprogramcanhelpminimizeanydata

inconsistenciesandtheneed for datareconstruction.

Ifthedataincashmanagementisnotconsistentwiththeactualdata,youcanuse

theCorrectDatafunctionintransactionFDFDtocorrectthedata,avoidingthe

need for a complete data reconstruction. Depending on what caused theerror,

194

第 203 页 / 共 213 页

AC805 Lesson: Data Transfer and Reorganization

you may be able to restrict the reconstruction to certain areas. If a complete

reconstructionisnecessary,however,usetheDataSetupfunctionintransaction

FDFD to effect it.

Figure 98: Reorganization

TablesinCashManagementmustbereorganizedonaregular basistoincrease

memory and improve access times.

The reorganization program:

• Deletes expired summary records

• Ignores blocked records

• Summarizessummaryrecordsatthesummarizationdate(ifthevaluedateis

earlier than (<) the summarization date)

• Deletesmemorecords(if theexpirationdateisbeforetheexpirationdate

specified for the reorganization run)

• Deletesarchivedmemorecordsaftertheretentionperiodhasrunout

• Listsallsummaryrecordsandmemorecords(ifyouselectthisoption)

195

第 204 页 / 共 213 页

Unit8: CheckingReports,DataTransfer,Reorganization AC805

Lesson Summary

You should now be able to:

• Activate Cash Management

• Transfer datafromoldsystemsorfeeder systems

• Distinguishbetweenthevariousreorganizationtransactions

196

第 205 页 / 共 213 页

AC805 Unit Summary

Unit Summary

You should now be able to:

• HandlethevariousmonitoringtoolsinSAPCashManagementsothatthe

data is managed correctly in the system

• Explainhowthecashingtimeofcheckstovendorsisdetermined,andhow

you transfer them tothevendor master record

• Activate Cash Management

• Transfer datafrom oldsystemsorfeeder systems

• Distinguishbetweenthevariousreorganizationtransactions

197

第 206 页 / 共 213 页

CourseSummary AC805

Course Summary

You should now be able to:

• DescribehowandwherethefunctionsofmySAPERP cashmanagement

can be used.

• Setupthestructuresrequiredforshortandmedium-termliquiditymonitoring

in your business

• Explainthevariousoptionsavailableforintegratingexternalbankdatawith

cash management

• Definethesystemsettingsneededtocontrolinternalprocessing

198

第 207 页 / 共 213 页

Appendix 1

Data Sheet

Type of Data DataintheTrainingSystem

Company codes AC00 to AC20

G/L accounts 113100, 113101, 113102, 113105,

113108, 113109, 113200, 800200,

400020,

Customers T-F00B00

Vendors T-F00B00

Groupings ACBANKEN, ACBANK-IST,

ACPERSONEN, ACGESAMT,

ACCLEARING

199

Type of Data	DataintheTrainingSystem
Company codes	AC00 to AC20
G/L accounts	113100, 113101, 113102, 113105, 113108, 113109, 113200, 800200, 400020,
Customers	T-F00B00
Vendors	T-F00B00
Groupings	ACBANKEN, ACBANK-IST, ACPERSONEN, ACGESAMT, ACCLEARING

第 208 页 / 共 213 页

Appendix1: DataSheet AC805

200

第 209 页 / 共 213 页

Appendix 2

Chart of Accounts

Figure 99: Chart of Accounts (1)

201

第 210 页 / 共 213 页

Appendix2: ChartofAccounts AC805

Figure 100: Chart of Accounts (2)

Figure 101: Chart of Accounts (3)

202

第 211 页 / 共 213 页

Index

A Comparing Payment Advices,

Account Assignment Variant, 187

62, 64, 77, 87 Comparing Value Dates, 187

Account Determination, 76 Concentration Payment

Account Determination - Advice, 145

Bank Statement, 105 Concentration Proposals, 142

Account Determination for Configuring Bank Accounts,

Bank Statement, 104 13

Account Group, 25 Currency, 17

Account Symbol, 103 D

Accounts, 15

Data Setup, 193

ActivatingCashManagement,

Day-to-Day Planning, 6

192

Display Currency, 17

Archive Retention Period, 51

Archiving Category, 50 E

Electronic Bank Statement

B

Processing, 120

bank account organization, 11

ExpectedPaymentFlows,162

bank accounts, 10

External Memo Records, 43

Bank Determination, 87

ExternalPaymentAdvices,43

Bank Statement, 86

Bank Subaccounts, 11 F

Banking Software, 120 Fast entry, 77

BTC, 136 Field Status, 25

Business Transaction Codes, Field Status Group, 25

136 Financial Budgeting, 3

C G

Cash Concentration, 142 G/L Account, 13

Cash flow, 3 grouping, 10, 15

Cash Management Account Grouping, 30, 163

Name, 16 Groups, 5

Cash Management Group, 5

H

Cash Position, 3, 10

House Bank, 24, 88

Chart of Accounts:, 12

Check Deposit, 60 I

Check Deposit List, 61, 65

Interpretation Algorithm, 138

Clearing Accounts, 11

L

Clearing Accounts - Cash

Concentration, 149 Level, 15, 50

203

第 212 页 / 共 213 页

Index AC805

Levels, 5 Postprocessing Transaction -

Liquidity Forecast, 3, 162, Electronic Bank Statement,

175 126

Processing Type, 87

M

Purchase Orders (MM), 179

Manual Bank Statement

R

Entry, 86

Manual Memo Records, 40 Retention Period, 42

Monitoring Cashed Checks,

S

188

Search String, 138

N

Short-Term Planning, 40

Note to Payee, 127 Single Cash Management

Notified Incoming and Records, 41

Outgoing Payments, 40 source indicator, 28

SpecialG/LTransactions,167

O

Special General Ledger, 177

On-Account, 76, 103, 128

Special Transactions, 167

Orders (SD), 179

Standard Variant, 77

P Start Variant, 62, 64, 87

Payment Advice - Bank Subledger Accounts, 162

Statement, 88 Summarization Term, 30

Payment Advice Journal, 44 T

Payment Advice Type, 50

Target account, 142

Payment Block, 166, 177

Tasks of a Cash Management

Payment History, 165

System, 2

Planned Currency, 17

Tasks of a Fund Manager, 6

Planning Group, 176

Transaction, 89

Planning Groups, 163

Transaction Name, 102

Planning Level, 14, 28

Transaction Type, 89

Planning Type, 41, 50

Transaction Types, 137

Posting Area, 76, 103

V

Posting Rule, 137

Posting Rules, 75, 102 Value Date, 26

Posting Type, 103

204

第 213 页 / 共 213 页

Feedback

SAP AG has made every effort in the preparation of this course to ensure the

accuracy and completeness of the materials. If you have any corrections or

suggestionsforimprovement,pleaserecordthemintheappropriateplaceinthe

course evaluation.

205