1、 SAP AGRSAP AGR/3 Treasury R SAP AGROverview of Treasury Functionsbank databusinesspartnermarket dataUS$DEMDownloadMarket Risk Management: interest/currency exposure mark-to-market valuation risk analysis/simulation value-at-riskCash Management: electronic banking liquidity status integrated operati
2、onal systems control functionsTreasury/Loans Management managing financial deals and positions transfer to Financial Accounting flexible reporting datafeed interfaceLogistics SAP AGRMarket RiskManagementSAP TREASURYTreasuryManagementCashManagementTreasury Process SAP AGRIndustries1980l R/3 Launchl I
3、S-IS/DARWIN project for Loans, Securities, Real Estatetoday1992199319941996l Money Market, Forex, Derivatives projectl Market Risk Management projectl Audit l Market release SAP AGRCountries1980l R/3 Launchl IS-IS/DARWIN project for Loans, Securities, Real Estate1992199319941996l Money Market, Forex
4、, Derivatives projectl Market Risk Management projectl Auditl Market releasetoday SAP AGRCustomersl Trade and industrynMultinational corporations:wBroad range of functions across the whole treasury areawVarious organizational structures, such as centralized/decentralized treasurywCovers special nati
5、onal features, such as electronic banking formatswCustomers: Shell, Daimler Benz, Petrofina, Burda, .nMedium-sized companieswAll functions available, regardless of company sizewUniform user interface simplifies training and usabilitywThe Treasury workstation concept allows scaled integration into th
6、e existing system environment using predefined interfaces SAP AGRCustomersl Providers of financial servicesnInsurance companieswManagement of securities, loans and real estatewIntegrated portfolio and risk managementwCustomers: Munich Re, Schweizer Rente, Aachener Mnchner, .nBankswTreasury master da
7、ta used by SAP BankingwTreasury Management is used as a basis for managing loans given and loans taken by mortgage banks (customer project) SAP AGR1) % of all companies surveyed Source: Price Waterhouse Top 500 Survey (Germany) Main Targets of Treasury 1 To ensure liquidity 95 2To optimize financing
8、 costs 92 3To optimize yields on financial assets74 4To hedge costs (e.g. against possible exchange rate fluctuations)61 5To hedge sales (e.g. against possible exchange rate fluctuations)52 6To contribute to profit through active management of open positions 301) SAP AGR 1 using SAP Cash ManagementL
9、iquidity Management Target % SAP AGRCash Management: FunctionsComprehensive analysis of liquidity situationData transfer from operative systems: Financials, Logistics and Treasury Management Electronic banking functionsCash position: daily bank account balances by value date, payment advicesCash con
10、centration: concentrated bank accountsCash pooling: interest paid on bank accountsLiquidity forecast: expected inflows/outflows from customers and vendors, planned dataMonitoring value dates, payment advices, conditions, checks cashed, . SAP AGRElectronic Bankingl Link to payment programl Manual/aut
11、omatic account statementsnVarious formats supportednPostings to G/L and customer/vendor accountsl Bank PollingnProcesses current bank information SAP AGRAim: Monitoring bank account movementscomparing value datesreconciling payment advice andaccount or bank statementcashed checks analysisaccount int
12、erest comparing bank conditionsControl FunctionsMonitoring correct paymentsprocessing for planning SAP AGRGrouping:Banks 09/01 09/02 09/03 _BANKA 90 130 60BANKB 40- 20- 30- :Cash PositionAccounts: Subledger 09/01 09/02 09/03 _Account 1 10 30 10-Account 2 20 70 20-Account 3 10 20- 50Level: BANKA 09/0
13、1 09/02 09/03 _F0 Subledger 40 80 20B2 Incoming checks 60 60 60B1 Outgoing checks 10- 10- 20-Current bank account balances/balances per value date (bank postings, payment advices)Accounts managed in local/foreign currency Planning horizon 0-5 daysDocumentation and audit functions Current liquidity p
14、osition on bank accounts per specific date SAP AGR Status before concentration after concentrationBank 112005Bank 21005Bank 34001337Bank 4-350313501350Cash ConcentrationClearing proposal in accordance with selection criteriaInteractive manual adjustmentCredit transfers and correspondence Concentrate
15、d bank accounts SAP AGRLiquidity ForecastGroups:- Customers with similar payment history - Customers of particular interestLevels:- Balances specified according to level Integrated data basis including customers, vendors and planned itemsExpected cash inflows/outflows over a planning horizon of 1-24
16、 weeksSupport for optimizing financial investment and borrowing Monitoring liquidity situation SAP AGRTreasury Workstation . . . . . R/2R/3R/3AnalysisLiquidityMarket risksFinancial transactionsTradingBack officeFinancial AccountingR/3TreasuryWorkstationFI-ALEFI-ALERFCTR-CM-ALE SAP AGRCompany 2Compan
17、y code 2External bank 2External bank 2External banksExternal bank 2Company 3Company code 3Central TreasuryCompany code 1Company 4Company code 4Liquidity statusCompany codes 2+3Liquidity statusCompany codes 1-4internal financial transactionsexternal financial transactionsexternal financialtransaction
18、sCorporate Group Evaluations SAP AGRImplementation StrategiesTraditional approach with Financial AccountingProcess-oriented with Logistics: Materials Management / Sales & DistributionMMSD SAP AGRTraditional approach with Financial AccountingRationalization: Electronic Banking SAP AGRProcess-oriented
19、 with Logistics: Materials Management / Sales & DistributionMMSDIntegrationGoods receiptOrderIntegration of Logistics SAP AGRCash Position and Liquidity Forecast SAP AGRMarketinformationCash Position and Liquidity Forecast SAP AGRCash Management DecisionMarketinformation SAP AGRIntegration with othe
20、r SAP modulesMMSDMarketinformation SAP AGRTreasury and Market Risk ManagementPriority Target%1To ensure liquidity952To optimize financing costs 923To optimize yields on financial assets 744To hedge costs (e.g. against possible exchange rate fluctuations) 615To hedge sales (e.g. against possible exch
21、ange rate fluctuations) 526To contribute to profit through active management of open positions30 SAP AGRMarket RiskManagementImplementation of SAP Treasury ManagementTreasury and Market Risk Management1To ensure liquidity952To optimize financing costs 923To optimize yields on financial assets 744To
22、hedge costs (e.g. against possible exchange rate fluctuations) 615To hedge sales (e.g. against possible exchange rate fluctuations) 526To contribute to profit through active management of open positions30 SAP AGRTreasury Management: FunctionsComplete financial transaction and position managementSupp
23、ort of trading and back office functionsFunctions to track, check and release transactionsData transfer to Financial Accounting(including accrual/deferral and valuation)Flexible settings to accommodate company-specific transaction and position managementprocessesFinancial transactions assigned to po
24、rtfolios or managed in securities accountsFlexible reporting and portfolio analysisDatafeed interface SAP AGRSelection of Product TypesMoney marketSecuritiesLoansForexl lFixed-termdepositsl lDeposits atnoticel lCommercial Paper l lStocksl lSubscript. rightsl lInvestmentcertificatesl lBondsl lConvert
25、iblebondsl lWarrant bondsl lWarrantsl lMortgageloansl lBorrowersnote loansl lPolicy loansl lForexspotdealsl lForwardexchangedealsl lForeign exchangeswapsl lCap / Floorl lFRAl lSwaps- Interest rate- Currency- Cross currency int.ratel lOTC options / futures- Currency- Currency barrier - Interest rate-
26、 Stockl lSwaption, IRGHedginginstrumentsInvestment/Borrowinginstruments Derivative instruments SAP AGRInstrumentsMethodsMeasurementsIdentificationof appropriatefinancialtransactionsSimulationof alternativeresultsSelection of analternativeTradingBack officeAccountingReportingInternal:- liquidity stat
27、us- risk positionExternal:- market dataAnalysis and Trading Process SAP AGRTransaction and Position Management ProcessPostingsPayment activitiesReversalsAccruals/deferralsValuation Create order/contract Exercise/expiration Give notice Rollovers Exercise rightsUser authorizationLimit managementReleas
28、e Settlement/Control Interest rate adjustment Netting References Confirmation letters Securities account transfers Corporate actions SAP AGRTrading Supportl Company-specific organizational structures represented in the system, internal and external transactions l Uniform trading screen with aids for
29、 data entry and processing as well as fast entry templatesl Trader and user authorizations for financial instruments and functions, change documentsl Limit managementl Standing instructions for specific business partners or organizational units allow bank details and payment details to be assigned t
30、o transactions automatically SAP AGRPartner dataMarket dataStanding Instructions Payment details Correspondence Derived flows- Entry and editing functions - Valuation toolsstanding instructions NPV calculatorcopying functionsoption price calculator shortcuts and tree structuresetc.fast entrycollecti
31、ve/fast processing- Automatic checks- dealer slip working days- limit managementtrader and business partner - change documentsauthorization SAP AGRBasis forupdating Cash Management updating Financial Accounting via flexible account determinationtriggering paymentupdating itemsaccrued/deferred intere
32、stpayment initiationforeign currency valuationyield calculation Financial Transactions: Cash FlowInvestment4/1/YY 1m DEM madeInterest 7/1/YY 10,000 DEM anticipatedRepayment 7/1/YY 1m DEM anticipated Cash flow (example) SAP AGRProduct typeTransaction typeBusiness partnerTransfer flowValuation flowAcc
33、rual/deferral flowFlows describing structure characteristicsPaymentinformationPostinginformationCalculation basesCurrenciesBal. sheet acctTraderTermInterestRepayment SAP AGRSequence Defined using Processing CategorieslOrder expirationlTerminationlContract settlementlExercise/expirationsettlementlKno
34、ck-in/knock-out settlementlTermination settlementlExercise/expirationlKnock-in/knock-outlTerminationwith/withoutorderExample: Derivativeswith/withoutsettlement SAP AGRContractContractExercise/expirationContractAlternativewithout settlementwith/withoutorderExample: Currency optionContractContractAlte
35、rnativewith settlementTradingBack officeExample: Currency barrier option with knock-inContract settlementKnock-in settlementExercise/expiration settlementContractKnock-inExercise/expirationOther Examples for Processing Categories with/withoutorder SAP AGRFinancial Transactions in Cash Management51A
36、SAP AGTB0001 Assign Cash Management levels Fixed-term deposit Subledger time dep.10 Contract 10/0210/03 10/03later10/05 Cash Management: Display LevelsLeDescription TBBalancexxx,xxx xxx,xxxxxx,xxxxxx,xxx132,323 xxx,xxx xxx,xxxxxx,xxxxxx,xxx. . . . . . . . . . . . . . . . . . . . . xxx,xxx xxx,xxx xx
37、x,xxxxxx,xxxxxx,xxxxxx,xxx xxx,xxx xxx,xxxxxx,xxxxxx,xxxTime deposits10/0210/03 10/04 10/05 later SAP AGRBack Office Supportl Check financial transactions upon settlementnStructure characteristics and allocation to portfolios/finance projectsnPayment detailsl Collective processing and editing functi
38、onsl Confirmation management / confirmation status nOutgoing confirmations, option of generating S.W.I.F.T. files and link to FX-Match via user exitnEnter and match incoming confirmations, evaluate overdue counterconfirmationsl Monitor limit utilization as part of end-of-day processingl Netting of f
39、inancial transactions (payment netting) SAP AGRBack Office ProcessingConfirmationConfirmationAccountingCollective processingNettingReferencesInterest rate adjustmentsSecurities acct transfersCorporate actionsConfirmation management (incoming/outgoing)Payment detailsCurr.BankAcct. . . . . . . Settlem
40、ent/control Payment details SAP AGRCorrespondencee.g. confirmation letter, SWIFTFaxe.g. dealing slipExternalInternalConfirmationConfirmation SAP AGRTransaction SettlementCurrencyPayer/eePartnerbank IDPmntmeth.PaymentactivityHousebankAcct IDPaymentdetails IDAccount assignment referenceDB000001 Deutsc
41、he BankFixed-term depositG/L account: 113113DEMUSDDEMCOUNTERP. . .2. . .T. . .BANKBBANKB. . .X. . .GIROUSD. . .010102 SAP AGRBusiness Partner - Payment DetailsFixed-term deposit in DEM at COUNTERPARTYForex purchasein USDOur house bank: Bank BCurrencyPayer/eePartnerbank IDPmntmeth.PaymentactivityHous
42、ebankAcctIDAllocationsIncomingOutgoingPayment details ID010102DEMUSDDEMCOUNTERPARTY. . .2. . .T. . .BANKBBANKB. . .X. . .GIROUSD. . .Fixed-term dep.Deposit at noticeMoney marketForex . . .010101Foreign exchange01 SAP AGRTransfer to Financial Accountingl Posting release optionl Flexible account deter
43、mination at flow type levell Flows transferred to Financial Accountingl Direct posting to clearing accounts, clearing via account statementl Make payments using the extended payment program:nGenerate and process payment requestsnPayment netting, flexible settings for payment methodsl Range of postin
44、g evaluations SAP AGRAccountingFI interfaceSelection of transactionsand flows relevant for posting SAP AGRPosting : Account Determination Fixed-term deposit 1 month 3.5% Acct assignment ref. DB000001Fxd-term dep. acct 113113DepositFinalrepayment D1,000,000 C1,000,000Interest earned 273100Nominalinte
45、rest D C 3,750Bank clearing acct 113100FT depositNominal int.Finalrepayment D C 1,000,000 3,7501,000,000Debit Bal.sht Credit Bank Debit Bank Credit Bal.sht Debit Bank Credit Int. earned Flow typePosting details1100 -1120 +1200 +Sept 1st1100 -Fixed-term deposit 1,000,000Oct 1st1120 +Final repayment1,
46、000,000Oct 1st1200 +Nominal interest 3,750Balance sheet account acc. toaccount assignment reference SAP AGRPosting using Clearing Accountsfixed-term deposit via activity at fixed-term deposit levelpost flows to clearing accountchange to clearing accountschange to bank account levelclearing entry via
47、 account statement SAP AGRPayment Transaction Handling Fixed-term depositAccount statement from bank. using clearing accountsFixed-term dep. account(Deuba)House bank account(Deuba)100 m100 mHouse bankDEUBABank clearing account100 m100 m SAP AGRPosting using Payment ProgramPaymentadviceBank transferE
48、urocheckCheckPaymentsummaryIDOC SAP AGRPayment Transaction Handling1st fixed-term deposit2nd fixed-term deposit.using a clearing account for payment requestsFixed-term dep. account(Citi)House bank account(Deuba)100 m150 mHouse bankDEUBAPayment request clearing acctBank clearing account150 m150 m50 m
49、100 m50 m150 mpayment (trigger payment request run)account statement from bank SAP AGRCross-Application Reporting Common reportingstructureData selection, definition oflayoutIndividual reportingJournalMaturitylistRevenuelist SAP AGRDrilldown reporting structuresPARTNERPRODUCT TYPE Borrowing/sale1PRO
50、DUCT TYPE2PARTNERCURRENCYPRODUCT TYPECURRENCYCompany codeTraderProduct typePortfolioSecurities accountXPartnerTransactionCurrencyAccount assignment referenceXXInvestm./purchaseXPARTNERCURRENCYMultidimensional Flexible Reporting3PARTNERPRODUCT TYPECURRENCY SAP AGRDatafeed ArchitectureSAP Datafeed Pro