Manual FSC800

Full text

(1)SAP PORTUGAL | USO EXCLUSIVO | 2013 FSC800 SAP Liquidity Planner. FSC800. SAP Liquidity Planner. THE BEST-RUN BUSINESSES RUN SAP  SAP AG 2008. © SAP AG 2008. SAP ERP Version: 62 Materialnummer 50086719.

(2) SAP PORTUGAL | USO EXCLUSIVO | 2013.

(3) SAP PORTUGAL | USO EXCLUSIVO | 2013 Copyright. Copyright 2008 SAP AG. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice..  SAP AG 2008. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, OS/2, Parallel Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390, OS/400, iSeries, pSeries, xSeries, zSeries, System i, System i5, System p, System p5, System x, System z, System z9, z/OS, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, Informix, i5/OS, POWER, POWER5, POWER5+, OpenPower and PowerPC are trademarks or registered trademarks of IBM Corporation. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Oracle is a registered trademark of Oracle Corporation. UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group. Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc. HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology. Java is a registered trademark of Sun Microsystems, Inc. JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. MaxDB is a trademark of MySQL AB, Sweden..

(4) SAP PORTUGAL | USO EXCLUSIVO | 2013 SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG. This document is a preliminary version and not subject to your license agreement or any other agreement with SAP. This document contains only intended strategies, developments, and functionalities of the SAP® product and is not intended to be binding upon SAP to any particular course of business, product strategy, and/or development. Please note that this document is subject to change and may be changed by SAP at any time without notice. SAP assumes no responsibility for errors or omissions in this document. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, or other items contained within this material. This document is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials. This limitation shall not apply in cases of intent or gross negligence. The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the use of hot links contained in these materials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-party Web pages..

(5) SAP PORTUGAL | USO EXCLUSIVO | 2013 Course Overview. Contents: Course Goals Course Objectives Course Content Course Overview Diagram Main Business Scenario.  SAP AG 2008.

(6) SAP PORTUGAL | USO EXCLUSIVO | 2013 Course Goals. This course will prepare you to: Understand how and where you can use SAP Liquidity Planner functions Obtain detailed knowledge of the entire SAP Liquidity Planner process Use SAP Liquidity Planner independently to develop cash accounting and planning.  SAP AG 2008.

(7) SAP PORTUGAL | USO EXCLUSIVO | 2013 Course Objectives. After completing this course, you will be able to: Describe and use the business requirements of cash accounting and planning with SAP Liquidity Planner Set up the technical structure required for cash accounting and planning Define and implement the system settings in ERP and BI Describe the organizational adjustments required.  SAP AG 2008.

(8) SAP PORTUGAL | USO EXCLUSIVO | 2013 Course Content. Unit 1. LP (SAP Liquidity Planner) in FSCM. Unit 2. Basic Knowledge Business Administration. Unit 3. Customizing in ERP. Unit 4. Application in ERP. Unit 5. Migration TR-CBM for SAP Liquidity Planner. Unit 6. BI Overview (Business Intelligence). Unit 7. Business Content, Modeling, and Extraction. Unit 8. Reporting. Unit 9. Planning. Unit 10. Summary and Outlook Appendix.  SAP AG 2008.

(9) SAP PORTUGAL | USO EXCLUSIVO | 2013 Main Business Scenario. Plan Data. Group. Planning Unit 1. Planning Unit 2. Actual Data Planning? Unit 1. Central Data Storage. Planning Unit 3. Planning Unit 2. Planning Unit 3. Reporting  SAP AG 2008. An enterprise wants to increase the transparency of its financial operations. It wants to display, analyze, and plan cash flows. The enterprise uses liquidity items to display and plan cash flows. The liquidity items can be revenue or expenditure items. To achieve more transparency the enterprise wants to implement SAP Liquidity Planner. This application comprises three areas: • Actual data (in ERP) • Plan data in (BI) • Reporting (in BI).

(10) SAP PORTUGAL | USO EXCLUSIVO | 2013.

(11) SAP PORTUGAL | USO EXCLUSIVO | 2013 LP in FSCM. Contents: Overview of Financial Supply Chain Management (FSCM) Overview of SAP Liquidity Planner Tasks System architecture Differences to Cash Management.  SAP AG 2008. © SAP AG. FSC800. 1-1.

(12) SAP PORTUGAL | USO EXCLUSIVO | 2013 LP in FSCM: Objectives. At the conclusion of this unit, you will be able to: Integrate SAP Liquidity Planner in Financial Supply Chain Management Distinguish SAP Liquidity Planner from Cash Management Name the main tasks of SAP Liquidity Planner Outline the system architecture.  SAP AG 2008. © SAP AG. FSC800. 1-2.

(13) SAP PORTUGAL | USO EXCLUSIVO | 2013 Overview of SAP Liquidity Planner: Business Scenario. Before you start working in the project team, you want to obtain an overview of SAP Liquidity Planner. Which goals are to be attained with SAP Liquidity Planner and how is the system architecture structured?.  SAP AG 2008. You are a member of a project team that has to provide the decision makers at your company with an overview (in good time) of how cash accounting and liquidity planning could be implemented.. © SAP AG. FSC800. 1-3.

(14) SAP PORTUGAL | USO EXCLUSIVO | 2013 SAP Solution MAP – SAP ERP.  SAP AG 2008. In addition to Financial Accounting, Management Accounting, and Corporate Governance, the Financials area also includes Financial Supply Chain Management.. © SAP AG. FSC800. 1-4.

(15) SAP PORTUGAL | USO EXCLUSIVO | 2013 Solution MAP – FSCM.  SAP AG 2008. The task of Cash and Liquidity Management (note: SAP Liquidity Planner is the equivalent to Liquidity Management) is to provide functions for efficient short, medium, and long-term liquidity analysis and planning. SAP Liquidity Planner is therefore part of FSCM (Financial Supply Chain Management).. © SAP AG. FSC800. 1-5.

(16) SAP PORTUGAL | USO EXCLUSIVO | 2013 Interaction Between "Treasury" Components Corporate Headquarter – Treasury Risk Management Credit Risk Analyzer. Money market trading. Market Risk Analyzer. Foreign Derivative exchange. Portfolio Analyzer. Loans. Security. Transaction Manager. In-House Cash. Liquidity Planner Cash Management. IHC. CM. Cash and Liquidity Management. LP. Unit 1. IHC. Data of operational systems. CM. LP. Unit 2. IHC. Bank data. CM. LP. Unit 3.  SAP AG 2008. The most important reporting tasks of Cash Management are to provide: • A value date-dependent cash position • A liquidity forecast The reporting tasks of SAP Liquidity Planner are to provide: • Retrograde liquidity analysis • Liquidity planning. © SAP AG. FSC800. 1-6.

(17) SAP PORTUGAL | USO EXCLUSIVO | 2013 How Cash Management and Liquidity Planner Differ Cash Management. Liquidity Planner. Opening balance. Opening balance. Revenue. Revenue Customer group X. Revenue from sales. Customer group Y. Interest earnings. .... Other revenue. Expenditure. Expenditure. Vendor group X. Personnel. Vendor group Y. Materials. .... Assets ... Closing balance. Closing balance.  SAP AG 2008. The key difference is that Cash Management shows the cash flows on the customer and vendor side in the liquidity forecast ("to whom" or "from whom"). Liquidity Planner shows cash flows according to funds utilization or origin ("for what purpose").. © SAP AG. FSC800. 1-7.

(18) SAP PORTUGAL | USO EXCLUSIVO | 2013 SAP Liquidity Planner – An Overview •. SAP Liquidity Planner provides: Retrograde determination of cash flows Medium to long-term planning of these flows. •. SAP Liquidity Planner (SAP Liquidity Management) consists of two components: Actual Calculation in ERP Planning in BI. •. Reporting for actual and plan data is carried out in SAP Business Warehouse (BI)..  SAP AG 2008. It must be noted that SAP Liquidity Planner consists of two components.. © SAP AG. FSC800. 1-8.

(19) SAP PORTUGAL | USO EXCLUSIVO | 2013 System Architecture – Overview. BI Reporting. Planning. Database. Extraction. ERP Operational ERP. Operational ERP.  SAP AG 2008. Actual data is determined in the operational ERP systems through the "actual" calculation. The results are extracted to BI and made available for reporting. Planning is carried out in BI and the data can also be used here for reporting. You can compile various reports in BI: plan-plan comparisons, plan-actual comparisons, variance analyses, and many more.. © SAP AG. FSC800. 1-9.

(20) SAP PORTUGAL | USO EXCLUSIVO | 2013 LP in FSCM: Summary. You are now able to: Provide an overview of Financial Supply Chain Management Outline the key aspects of SAP Liquidity Planner: Tasks System architecture How it differs from Cash Management.  SAP AG 2008. © SAP AG. FSC800. 1-10.

(21) SAP PORTUGAL | USO EXCLUSIVO | 2013 Business Administration – Basic Knowledge. Contents: Concept of cash accounting Tasks of cash accounting and liquidity planning Recipients and the need for information Cash accounting and general accounting.  SAP AG 2008. © SAP AG. FSC800. 2-1.

(22) SAP PORTUGAL | USO EXCLUSIVO | 2013 Business Administration – Basic Knowledge: Unit Objectives. At the conclusion of this unit, you will be able to: Understand the relationships between general accounting and cash accounting that are required to implement SAP Liquidity Planner Explain the business concept behind cash accounting and liquidity planning.  SAP AG 2008. © SAP AG. FSC800. 2-2.

(23) SAP PORTUGAL | USO EXCLUSIVO | 2013 Basic Knowledge Business Administration: Business Scenario. Before you start working in the project team, you want to obtain a business overview of cash accounting and liquidity planning. Which business-related tasks and goals are set for cash accounting and liquidity planning?.  SAP AG 2008. © SAP AG. FSC800. 2-3.

(24) SAP PORTUGAL | USO EXCLUSIVO | 2013 Concept of Cash Accounting. Data source. Incoming/outgoing payments. (SAP) Cash accounting. Expenditure/revenue. Expense/profit. Costs/benefits. Accounting. Controlling. Cash accounting Cash basis accounting. Profit/loss statement. Managerial accounting.  SAP AG 2008. In business literature, the concept of cash accounting and its definition are the subject of much discussion. These discussions also refer to the terms: cash budget management, flow-of-funds analysis, cash flow statement, and cash flow accounting. Cash accounting records changes to cash flows, whereby cash flows are incoming and outgoing payments of liquid funds, such as cash in hand and bank savings. In accordance with national and international accounting standards such as DRS (Accounting Standards of Germany), FASB, and IAS, the term cash flow is used here to refer to changes in the means of payment. Liquidity is therefore referred to as a financial accounting-related concept. Consequently, cash accounting distinguishes itself from accrual accounting.. © SAP AG. FSC800. 2-4.

(25) SAP PORTUGAL | USO EXCLUSIVO | 2013 Time-Based Delimitation. Cash flow accounting. Past. Liquidity planning. Current period. Retrograde determination. Future. t. Reciprocal determination.  SAP AG 2008. Within a certain period, cash accounting records transactions that directly influence the stock of liquid funds, regardless of the period in which payments were made. Cash accounting functions across all periods. SAP Liquidity Planner adopts this concept.. © SAP AG. FSC800. 2-5.

(26) SAP PORTUGAL | USO EXCLUSIVO | 2013 Tasks of Cash Accounting and Liquidity Planning. Solvency information Information about internal financing potential Increase transparency in financial operations by providing information about funds utilization and origin. Why was/is liquidity lost? Why was/is liquidity retained?.  SAP AG 2008. The main task of cash accounting is to provide information about the solvency and internal financing potential of the company. It also forms the basis for creating flow-of-funds analyses and planning. In comparison to balance sheets and profit and loss statements (P&L), it provides a better evaluation of the financial situation of a company. Internal financing potential means that a company can generate more revenue than expenditures from its business activities. This is also referred to as internal financing strength. If a company can continuously build up liquidity in addition to conducting its regular business activities, this surplus is called strategic liquidity.. © SAP AG. FSC800. 2-6.

(27) SAP PORTUGAL | USO EXCLUSIVO | 2013 Profit and Cash Flow. Profit Cash flow. W.T. Grant 1967 - 1975  SAP AG 2008. Comparing the profit and cash flow of the W.T. Grant company demonstrates the importance of analyzing and determining cash flow. Even though the company was profitable up until one year before its insolvency, it could no longer meet its payment obligations. However, cash flow had already been negative in earlier fiscal years. The reason for such a discrepancy can be found in the different ways accounting information can be interpreted. For example, discrepancies can occur due to an increased stocking up of a warehouse, an expansion strategy requiring high investment, or by a difficult economic period during which extended terms of payment are often granted.. © SAP AG. FSC800. 2-7.

(28) SAP PORTUGAL | USO EXCLUSIVO | 2013 Display Methods. There are two methods for displaying cash flows: •. Indirect method This method and form of display is predominantly used for cash flows and flow-of-funds analyses.. •. Direct method Many companies strive to use this method for cash flows since it is used for planning..  SAP AG 2008. The indirect method is currently used the most by companies. However, the direct method is used increasingly more often to improve transparency.. © SAP AG. FSC800. 2-8.

(29) SAP PORTUGAL | USO EXCLUSIVO | 2013 Structure of the Cash Flow (Direct Method). According to national and international regulations, the flow-offunds analysis based on the direct method is divided into three areas: Cash flow from operating activities Cash flow from investing activities Cash flow from financing activities.  SAP AG 2008. The international accounting principles specify the following structure: Ÿ Cash flow from operating activities Ÿ Cash flow from investing activities Ÿ Cash flow from financing activities. © SAP AG. FSC800. 2-9.

(30) SAP PORTUGAL | USO EXCLUSIVO | 2013 Recipients and the Need for Information Investors Lenders. Suppliers. Investment Dividends and withdrawals. Loan. Repayment and interest payments. Payment of activity. Company. Payment of activity. Payment of activity. Employees. Customers Activity. Cash flow.  SAP AG 2008. With regard to liquidity flows, companies are involved with different interested parties and recipients. Employees, customers, suppliers, investors, and lenders have different information requirements.. © SAP AG. FSC800. 2-10.

(31) SAP PORTUGAL | USO EXCLUSIVO | 2013 Financial Accounting and Cash Accounting (I). Chart of accounts Cash accounts. Balance sheet accounts. P&L accounts. Cash accounting. Balance sheet. P&L statement. Revenue. Expenditure. Assets (without LF*). Liabilities and equity. Cash balance. Expense. Profit. P&L account.  SAP AG 2008. The data source for cash accounting is the posting material in financial accounting. In financial accounting, cash accounts, balance sheet accounts, and P&L accounts are integrated to form a threefold accounting system. This account-based integration enables you to determine the cash flow in cash accounting. Accounting and consequently ERP systems are constructed according to the principle of doubleentry accounting. A triple-entry accounting system has not been implemented yet. Note *) LF = Liquid funds. © SAP AG. FSC800. 2-11.

(32) SAP PORTUGAL | USO EXCLUSIVO | 2013 Financial Accounting and Cash Accounting (II). Affecting liquidity Affecting Not net incomeaffecting liquidity Affecting liquidity. Not affecting net incomeNot affecting liquidity. Chart of accounts Cash accounts Balance sheet accounts P&L accounts Cash Cash outflow Asset account Capital/debt Expense Revenue inflow account account account Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 13 13 14 14.  SAP AG 2008. There are 14 different account assignment types that can be explained using the following examples: 1.. Cash payment for office materials. 2.. Revenue from cash sales. 3.. Depreciation of fixed assets. 4.. Posting of supplier invoices. 5.. Invoicing of an activity. 6.. Dissolving of provisions. 7.. Revenue from invoices. 8.. Borrowing (loans). 9.. Payment of supplier invoices. 10. Cash payment for material purchases 11. Accounting exchange on the assets side 12. Contributions in kind from companies 13. Clearing of payables and receivables 14. Accounting exchange on the liabilities side. © SAP AG. FSC800. 2-12.

(33) SAP PORTUGAL | USO EXCLUSIVO | 2013 Basic Knowledge Business Administration: Summary. You are now able to: Describe the concept of cash accounting Classify tasks of cash accounting and liquidity planning Name the recipients of cash accounting and liquidity planning Outline the relationship between financial accounting and cash accounting.  SAP AG 2008. © SAP AG. FSC800. 2-13.

(34) SAP PORTUGAL | USO EXCLUSIVO | 2013. © SAP AG. FSC800. 2-14.

(35) SAP PORTUGAL | USO EXCLUSIVO | 2013 Exercises Unit:. SAP Liquidity Planner and Basic Business Knowledge. Topic:. Basic Background Knowledge. At the conclusion of these exercises, you will be able to: • Provide an overview of SAP Liquidity Planner • Name the relationships required from a business perspective You want to outline SAP Liquidity Planner and be able to name the most important business relationships.. 1-1 How does SAP Liquidity Planner differ from SAP Cash Management?. 1-2 Which components make up SAP Liquidity Planner? Where does reporting take place?. 1-3 Outline the system architecture.. 1-4 How does cash accounting function (with regard to time)?. © SAP AG. FSC800. 2-15.

(36) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-5 Name the main task of cash accounting and liquidity planning.. 1-6 Which methods exist for a flow-of-funds analysis?. 1-7 Name the key sections of a flow-of-funds analysis.. 1-8 From where is the data for cash accounting sourced?. © SAP AG. FSC800. 2-16.

(37) SAP PORTUGAL | USO EXCLUSIVO | 2013 Solutions Unit:. SAP Liquidity Planner and Basic Business Knowledge. Topic:. Basic Background Knowledge. 1-1 SAP Liquidity Planner displays liquidity flows according to funds utilization and origin.. 1-2 SAP Liquidity Planner consists of the Actual Calculation component (ERP) and a planning component in BI. Reporting is also carried out in BI. 1-3 Use the system architecture shown on slide 9 of unit 1. 1-4 Cash accounting functions across all periods. 1-5 The main task of cash accounting and liquidity planning is to provide information about internal financing potential and to increase transparency in financial operations. 1-6 There are both direct and indirect methods. 1-7 A flow-of-funds analysis is divided into: - Cash flow from current activities - Cash flow from investment activities - Cash flow from financing activities 1-8 The data for cash accounting is sourced from accounting.. © SAP AG. FSC800. 2-17.


(39) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing in ERP. Contents: Customizing settings Activation of cash accounting (Actual Calculation).  SAP AG 2008. © SAP AG. FSC800. 3-1.

(40) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing in ERP: Objectives. At the conclusion of this unit, you will be able to: Configure Customizing for the ERP part of SAP Liquidity Planner Carry out the steps required for activation.  SAP AG 2008. © SAP AG. FSC800. 3-2.

(41) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing in ERP: Business Scenario. The Customizing phase of the implementation project has begun. You carry out the required Customizing steps and activation activities..  SAP AG 2008. © SAP AG. FSC800. 3-3.

(42) SAP PORTUGAL | USO EXCLUSIVO | 2013 Master Data. SAP Liquidity Planner contains the following master data: Liquidity item Company code Business area.  SAP AG 2008. The master data of SAP Liquidity Planner includes: Ÿ Liquidity item Ÿ Company code Ÿ Business area. © SAP AG. FSC800. 3-4.

(43) SAP PORTUGAL | USO EXCLUSIVO | 2013 Accessing Customizing. Two main areas have to be configured in Customizing: Basic Settings Assignment From Bank Statement From FI Information From Invoices.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner.. © SAP AG. FSC800. 3-5.

(44) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Basic Settings (I). The basic settings are customized in four activities: Edit Liquidity Items (1) Define Global Data (2) Other Actual Accounts (3) Activate Company Code (4).  SAP AG 2008. You can access the basic settings for Customizing using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner.. © SAP AG. FSC800. 3-6.

(45) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Basic Settings (II). Edit Liquidity Items (1) Here, you define the liquidity items that carry the values. No totals items or summarization line items are maintained. This is carried out in BI.. Define Global Data (2) Default item for incoming and outgoing payments Item for transfer payments Posting date or value date Business area.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. Global data Ÿ Default liquidity items are assigned online, whereby debit items are assigned to the incoming payment item and credit items to the outgoing payment item. Ÿ Liquidity-neutral postings are shown in the transfer items. Ÿ A decision must be made as to whether the posting date or the value date is to be included. Ÿ If the business area is to be included, this must be defined in Customizing.. © SAP AG. FSC800. 3-7.

(46) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Basic Settings (III). Other Actual Accounts (3) Definition of accounts that are not automatically defined as actual accounts. Activate Company Code (4) Activation of the relevant company codes.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. An additional number range must be created when the company code is activated. You can create the number range using transaction OT20.. © SAP AG. FSC800. 3-8.

(47) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Assignment Mechanisms (I). From Bank Statement. From FI Information. Document chains. ERP. From Invoice.  SAP AG 2008. There are two sources for determining cash flows. The first is data from electronic bank statements and the second is accounting data. The "From Bank Statement" mechanism analyzes the data in the electronic bank statement, whereas the "From FI Information" and "From Invoice" mechanisms use the accounting data. The assignment mechanisms can be used separately or together.. © SAP AG. FSC800. 3-9.

(48) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Assignment Mechanisms (II). Definition of the "From Bank Statement" assignment mechanism: Define Query Sequences Assignment to Bank Accounts.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. Under "Define Query Sequences", you define separate queries for each bank since banks often deliver data in different ways. Under "Assignment to Bank Accounts", you specify which query sequence the mechanism uses for which bank account. Every bank account is described in terms of company code, house bank ID, and account ID.. © SAP AG. FSC800. 3-10.

(49) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Assignment Mechanisms (III). Definition of "From FI Information" assignment mechanism: Settings for FI Mechanisms Define Query-Relevant G/L Accounts Define Query Sequences.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. The settings for FI mechanisms are explained separately. Under "Define Query-Relevant G/L Accounts", you map G/L accounts to liquidity items. Under "Define Query Sequences", you define one or more queries for the "From FI Information" mechanism.. © SAP AG. FSC800. 3-11.

(50) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Assignment Mechanisms (IV). The following most important settings are configured in "Settings for FI Mechanisms": Partial reassignment N:M treatment Info accounts in the application Order information.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. If you select "Part. Reassign.", assignment to a liquidity item is carried out also in cases where the payment has only been partly cleared. The actual document is split temporarily, whereby the partial amounts cleared are assigned to the liquidity item determined and the remaining amount stays assigned to the original liquidity item. In standard company accounting, multiple bank statement postings (N) are cleared to the bank subaccounts together with a number of postings (M). This is known as N:M treatment. In this case, the assignment mechanism cannot trace the document chains. This means that no liquidity items can be determined. If you select this entry, a workaround is activated for the case described above. This enables the document chains to be traced. If you select Info Accts in Appl., it specifies that you want to assign G/L accounts to liquidity items in the application rather than in Customizing.. © SAP AG. FSC800. 3-12.

(51) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing: Assignment Mechanisms (VI). Definition of "From Invoices" assignment mechanism: Settings for FI Mechanisms Define Query-Relevant G/L Accounts Define Query Sequences.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner. The options under "Settings for FI Mechanisms" and "Define Query-Relevant G/L Accounts" correspond to those in the Customizing option for the FI mechanism. Under "Define Query Sequences", you define one or more queries for the "From Invoices" mechanism.. © SAP AG. FSC800. 3-13.

(52) SAP PORTUGAL | USO EXCLUSIVO | 2013 Tools in Customizing. Three reports are shipped in Customizing: Delete Flow Data Regenerate Flow Data FI Assignment Analysis.  SAP AG 2008. You can access the Customizing settings using transaction /nflqcust or via the Customizing path: Financial Supply Chain Management -> Cash and Liquidity Management Liquidity Planner. You can use report "Delete Flow Data" to delete the data within the cash accounting (actual calculation). You can use report "Regenerate Flow Data" to regenerate the data within the cash accounting (actual calculation). The report "FI Assignment Analysis" provides support when you set up the "From FI Information" assignment mechanism.. © SAP AG. FSC800. 3-14.

(53) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing in ERP: Summary. You are now able to: Configure Customizing for the ERP part of SAP Liquidity Planner Carry out the steps required for activation.  SAP AG 2008. © SAP AG. FSC800. 3-15.


(55) SAP PORTUGAL | USO EXCLUSIVO | 2013 Exercises Unit:. Customizing. Topic:. Setting Up Customizing. At the conclusion of these exercises, you will be able to: • Configure baseline Customizing • Name the relationships required from a business perspective You want to configure baseline Customizing for SAP Liquidity Planner.. 1-1 Which the transaction code calls the Customizing path for baseline Customizing? 1-2. In company code AC##, create a cash account in chart of accounts INT (for example, 101000) as an “Other Actual Account” for your company code AC##.. 1-3 Activate your company code AC## with number range 01. The number range should already exist (if not, you can use transaction ot20). 1-4 For company code AC##, create a query sequence for Deutsche Bank. Since you want this to be valid for your company code only, name the query sequence AC##_DEUBA. 1-5 In your company code AC##, assign the query sequence defined in steps 1-4 for Deutsche Bank (house bank 1000 and account ID 1000). 1-6 Explain the function of the “Part. Reassign.” indicator in transaction FLQC13 (Liquidity Calculation – Settings for FI Mechanisms).. 1-7 Explain the function of the “N:M Treatment” indicator.. 1-8 Explain the function of the “Info Accts in Appl.” indicator.. © SAP AG. FSC800. 3-17.

(56) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-9 Map G/L accounts to liquidity items for your company code AC## using transaction “Query-Relevant G/L Accounts”. When doing so, use chart of accounts INT. The mapping between G/L accounts and liquidity items should be as follows:. © SAP AG. G/L Account. Default Value (Liquidity Item). 1000. 230000. 2000. 230000. 34000. 230000. 43000. 210000. 45000. 210000. 60500. 311000. 70000. 370000. 70001. 370000. 220000. 340000. 273100. 330000. 273300. 330000. 300000. 122000. 300010. 122000. 310000. 122000. 416300. 127000. 416302. 127000. 420000. 121100. 440000. 121200. 473000. 125000. 473110. 125000. 476000. 127000. 477100. 126000. 800000. 111000. 800001. 112000. 800002. 113000. 807000. 330000. 930000. 380000. FSC800. 3-18.

(57) SAP PORTUGAL | USO EXCLUSIVO | 2013 Map your reconciliation accounts to the corresponding “Buffer Items”. Make a note of this mapping, for example: G/L Account. Default Value (Liquidity Item). 140000. DEBTOR. 141000. DEBTOR. 160000. VENDOR. 160100. VENDOR. 1-10 Define a query sequence for the “From FI Information” mechanism. Use the following name: AC##_FIINFO.. 1-11 Define a query sequence for the “From Invoices” mechanism. Use the following name: AC##_INVOICE.. 1-12 As a rule, what is the purpose of report “Regenerate Flow Data” in a project?. © SAP AG. FSC800. 3-19.


(59) SAP PORTUGAL | USO EXCLUSIVO | 2013 Solutions Unit:. SAP Liquidity Planner and Basic Business Knowledge. Topic:. Basic Background Knowledge. 1-1 Transaction FLQCUST calls the Customizing path for SAP Liquidity Planner. 1-2 Go to Customizing (transaction SPRO):. → Financial Supply Chain Management → Cash and Liquidity Management → Liquidity Planner → Basic Settings: Liquidity Calculation → Define Other Actual Accounts Choose “New Entries”. Enter the following values: Chrt/Accts. CoCode. G/L Account. Not Actual. INT. AC##. 101000. Leave blank. and save. 1-3 Go to Customizing:. → Financial Supply Chain Management → Cash and Liquidity Management → Liquidity Planner → Basic Settings: Liquidity Calculation → Activate Company Code Choose “New Entries”. Enter the following values: CoCd. Company Name. Act.. No.. AC##. Copied automatically. Set X indicator. 01. and save. (If required: Create the number range using transaction ot20. Enter your company code (AC##). Choose “Insert Interval”).. © SAP AG. FSC800. 3-21.

(60) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-4 Go to Customizing:. → Financial Supply Chain Management → Cash And Liquidity Management → Liquidity Planner → Assignment → From Bank Statement → Define Query Sequences Choose “New Entries”. Enter the following values: Query Sequence. Query CoCd. Name. Description. AC##_DEUBA. AC##. Query_Deuba. Query_Deuba. and save. 1-5 Go to Customizing:. → Financial Supply Chain Management → Cash and Liquidity Management → Liquidity Planner → Assignment → From Bank Statement → Assignment to Bank Accounts Choose “New Entries”. Enter the following values: CoCd. House Bk. Acct ID. Seq.. AC##. 1000. 1000. AC##-DEUBA. and save. 1-6 Explanation of the “Part. Reassign.” indicator: If you select Part. Reassign. (partial reassignment), assignment to a liquidity item is carried out also in cases where the payment has only been partly cleared. The actual document is split temporarily, whereby the partial amounts cleared are assigned to the liquidity item determined and the remaining amount stays assigned to the original liquidity item. If the Part. Reassign. indicator is not set, a complete assignment is only carried out once the payment and corresponding documents have been completely cleared in the document chain. Up to this point, the total amount remains assigned to the initial liquidity item.. © SAP AG. FSC800. 3-22.

(61) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-7 Explanation of the “N:M Treatment” indicator: In standard company accounting, multiple bank statement postings (N) are cleared to the bank subaccounts together with a number of postings (M). This is known as N:M treatment. In this case, the assignment mechanism cannot trace the document chains. This means that no liquidity items can be determined. If you select N:M Treatment, a workaround is activated for the case described above. This enables the document chains to be traced. 1-8 Explanation of the “Info Accts in Appl.” indicator: You use this indicator to specify that info accounts for cash accounting (that is, accounts for which assignment programs try to derive a liquidity item from the information in the document line item) are entered in the application rather than in Customizing (FLQC7). 1-9 Go to Customizing:. → Financial Supply Chain Management → Cash and Liquidity Management → Liquidity Planner → Assignment → From FI Information → Define Query-Relevant G/L Accounts Choose “New Entries”. Enter all values specified in the task: Chart of Accounts. Company Code. G/L Account. Further. Default Value. INT. AC##. 1000. 230000. INT. AC##. ……. …... ….. …... ……. …... INT. AC##. 140000. DEBTOR. INT. AC##. ….. …... and save.. © SAP AG. FSC800. 3-23.

(62) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-10 Go to Customizing:. → Financial Supply Chain Management → Cash and Liquidity Management → Liquidity Planner → Assignment → From FI Information → Define Query Sequences Choose “New Entries” and enter the following values: Query Sequence. Origin. Query CoCd. Name. Description. AC##_FIINFO. C. AC##. FI INFO. FI INFO. Save your data. 1-11 Go to Customizing:. → Financial Supply Chain Management → Cash And Liquidity Management → Liquidity Planner → Assignment → From Invoices → Define Query Sequences Choose “New Entries” and enter the following values: Query Sequence. Origin. Query CoCd. Name. Description. AC##_INVOICE. C. AC##. Invoice. Invoice. Save your data. 1-12 As a rule, the report “Regenerate Flow Data” is used to generate data created before the activation date of the actual calculation.. © SAP AG. FSC800. 3-24.

(63) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application in ERP. Contents: Using Liquidity Planner.  SAP AG 2008. © SAP AG. FSC800. 4-1.

(64) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application in ERP: Unit Objectives. At the conclusion of this unit, you will be able to: Use and execute the Actual Calculation application of SAP Liquidity Planner This includes: Assignment mechanisms Transfer postings Settings Information system.  SAP AG 2008. © SAP AG. FSC800. 4-2.

(65) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application in ERP: Business Scenario. You have configured Customizing successfully. You now begin to use the application functions, thereby increasing your knowledge in this area..  SAP AG 2008. © SAP AG. FSC800. 4-3.

(66) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application Areas. The menu is divided into the following application areas: Assignment Transfer Settings Information System.  SAP AG 2008. The main menu areas are: • Assignment • Transfer • Settings • Information System. © SAP AG. FSC800. 4-4.

(67) SAP PORTUGAL | USO EXCLUSIVO | 2013 Cash Accounting – Process. Electronic bank statement Documentbased actual movement. Result logs. Import Import bank bank statements statements or or enter enter document document in in SAP SAP FI FI. Automatic assignment mechanisms. Assignment result satisfactory?. No Postprocess parameters. Yes; manual adjustments if required Analysis reports. Actua l data. Extraction – BI.  SAP AG 2008. In the actual data process, the electronic bank statement is first imported and the accounting documents posted. The relevant assignment reports are then initiated. The result is displayed and written to the database. You can display the data by means of the analysis report or extract the data to BI. The process ends within the ERP system when data is extracted to BI.. © SAP AG. FSC800. 4-5.

(68) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application: Assignment ERP. From FI Information. From Invoice. Document chains. From Bank Statement. Manual.  SAP AG 2008. There are two sources for determining cash flows. The first is the data from the electronic bank statement; the other is the financial accounting data. The "From Bank Statement" mechanism analyses the data in the electronic bank statement, whereas the "From FI Information" and "From Invoice" mechanisms use the financial accounting data. The assignment mechanisms can be used separately or together.. © SAP AG. FSC800. 4-6.

(69) SAP PORTUGAL | USO EXCLUSIVO | 2013 From Bank Statement (I) Sample Company New York --------------------------------------------------------------------------------------------------------------------------------------------------------------------------Postal giro office Manhattan Account holder: John Smith Bank code: 66010075 Account number: 179097-756 Statement number: 00051 Currency: DEM Statement date: 09/24/2000 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------CNo. Val. Dte Pstg Dte Note to Payee. Posting Text. BTC. Daybook. Amount. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------. 00001 09/24 00002 09/24 00003 09/24. 09/24 09/24 09/24. 00004 09/24 00005 09/24. 09/24 09/24. 00006 09/24. 09/24. CHECK DEPOSIT Document 1500000285 ID 8899100 / X4711 EUROTEL GmbH Check 1500000282 Invoice from 06/03/YY Inv. no. 17100008111 Cash discount 3 % Invoice from 06/12/YY. DEBIT MEMO. 070 004 005 001 051. EUROTEL telephone costs. Beginning balance 33,900.00 --------------------------------------------30,000.00 3,300.00 386.16 -. 600.00 10,700.00. 051 1,000,000,000.00 ------------------------------------------------------------Total Debit 4,286.16 Total Credit 1,000,040,700.00 ------------------------------------------------------------Ending balance 1,000,070,314.00.  SAP AG 2008. This mechanism evaluates the actual documents that refer to a manual or electronic bank statement. Queries (rules) must be created that display the information of the electronic bank statement in the liquidity items.. © SAP AG. FSC800. 4-7.

(70) SAP PORTUGAL | USO EXCLUSIVO | 2013 From Bank Statement (II). Three steps must be carried out: 1.. Set up queries. 2.. Generate queries for the query sequences. 3.. Start assignment report "From Bank Statement".  SAP AG 2008. The query is used to evaluate selected fields of the electronic bank statement. The query can also be interpreted as a type of "rule". The defined queries can be set up in a query sequence. When the assignment mechanism is executed, the query sequence is used to call the respective queries and the electronic bank statement is then evaluated.. © SAP AG. FSC800. 4-8.

(71) SAP PORTUGAL | USO EXCLUSIVO | 2013 Function: From FI and Invoices Bank 100 3a. Retrograde determination. Bank subaccount 3a 100. 100 2a Vendor. 2a 100. Posting transactions. 100 1a Rent. LI rent. 1a 100. -100.  SAP AG 2008. The "From FI Information" and "From Invoices" mechanisms function according to the principle of tracing document chains. The chain is traced from the bank document, via the clearing document, right through to the end.. © SAP AG. FSC800. 4-9.

(72) SAP PORTUGAL | USO EXCLUSIVO | 2013 "From FI Information" and "From Invoices" For both assignment mechanisms: From FI Information From Invoices Three steps must be carried out: 1.. Set up queries. 2.. Generate queries for the query sequences. 3.. Start the assignment report "From FI Information" "From Invoices".  SAP AG 2008. The query is used to evaluate selected fields of the accounting document. The query can also be interpreted as a type of "rule". The defined queries can be set up in a query sequence. When the assignment mechanism is executed, the query sequence is used to call the respective queries and the accounting document is then evaluated.. © SAP AG. FSC800. 4-10.

(73) SAP PORTUGAL | USO EXCLUSIVO | 2013 Dynamic Analysis Report for Mechanisms. When assignment mechanisms are executed online, a dynamic report is displayed. This provides: Detailed overview Detailed display of the individual cash flow Detailed analysis right through to the original document.  SAP AG 2008. The "From Invoices" or "From FI Information" assignment reports generate a dynamic online report. This shows all the relevant results of the run.. © SAP AG. FSC800. 4-11.

(74) SAP PORTUGAL | USO EXCLUSIVO | 2013 Transfer Postings. Three transactions are available in the Transfer area: 1.. Create (with template function). 2.. Change. 3.. Display.  SAP AG 2008. As already mentioned in Customizing, the document numbers must be defined beforehand. To do so, use transaction OT20. Under these menu options, postings can be made between the individual liquidity items.. © SAP AG. FSC800. 4-12.

(75) SAP PORTUGAL | USO EXCLUSIVO | 2013 Settings (I). The following functions are available in the Settings area: Edit Query Display Query Test Query Set Up Query Sequence.  SAP AG 2008. The query is used to evaluate selected fields of the electronic bank statement or the accounting document. The query can also be interpreted as a type of "rule". The defined queries can be set up in a query sequence. When the assignment mechanism is executed, the query sequence is used to call the respective queries and the electronic bank statement or accounting document is then evaluated.. © SAP AG. FSC800. 4-13.

(76) SAP PORTUGAL | USO EXCLUSIVO | 2013 Settings (II). The following functions are available in the Settings area: Map liquidity items to G/L accounts Upload/Download Queries Query Sequence (Assignment) Info Account (Application).  SAP AG 2008. Instead of mapping liquidity items and G/L accounts in Customizing, you can also do so in the application menu. You also create queries here that are relevant for tracing the document chain.. © SAP AG. FSC800. 4-14.

(77) SAP PORTUGAL | USO EXCLUSIVO | 2013 Information System. The most important reports are: Payment Report Totals List Line Items Line Item History Queries Query Sequences G/L Account List.  SAP AG 2008. The two most important reports are the payment report and the totals list since you can use them to display the results. The G/L account list report provides a brief overview of your mapping (G/L accounts to liquidity items).. © SAP AG. FSC800. 4-15.

(78) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application in ERP: Summary. You are now able to: Configure the settings required in Actual Calculation and use the functions correctly.  SAP AG 2008. © SAP AG. FSC800. 4-16.

(79) SAP PORTUGAL | USO EXCLUSIVO | 2013 Exercises Unit:. Application in ERP. Topic:. Using Actual Calculation. (In total: 14 exercises – exercises 1 to 7 are optional) At the conclusion of these exercises, you will be able to: • Use Actual Calculation. You want to use Actual Calculation.. 1-1 Generate data using electronic bank statements - optional exercise You can use an auxiliary program to generate files that are normally delivered by the bank with the bank statement and, at the same time, post the FI documents required for the subsequent import of the bank statement. Generate the test data and the files STATEMENT##.TXT and SALES ##.TXT using report RFEBKATX. You can call this report using transaction SE38 or via System Services Reporting. Variant FSC800 contains all input values in the correct format. You can use this variant to simplify the task. You do not download to your PC, but place the files on the application server. Call the files Statement##.TXT and Sales##.TXT to be generated (## = your group number). As bank clearing accounts, post to the accounts of house bank ID 1000 and account ID 1000 that belong to your company code. Select today’s date as the statement date and invoice date. You can decide whether to display the posting screens. Generate one or more open items for customer T-T05A## and also generate open items in your clearing accounts. Execute the report.. © SAP AG. FSC800. 4-17.

(80) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-2 Import the data (import the electronic bank statement) - optional exercise Now import the files you have just generated (STATEMENT##.TXT and SALES##.TXT). When importing the files, you can also use report variant FSC800, which contains all the required settings. Select Immediate Posting and restrict the Number Range for Document Numbers to 1800000000 to 1809999999. Print out the bank statement, posting log, and statistics. Execute the report. 1-3 Display the imported bank statement - optional exercise You can do so via the menu or using transaction FF.6 1-4 Which business transaction code was used to import the transactions? - optional exercise The business transaction code is: ________________ . Create a query for the BS mechanism. Name the query as follows: AC##_revenue with corresponding names. Assign the liquidity item 111000 to the query. Use business transaction code 051 as a condition - optional exercise 1-5 Assign the query to your query sequence AC##-DEUBA - optional exercise 1-6 Start report “From Bank Statement” with today’s date and document the result - optional exercise. © SAP AG. FSC800. 4-18.

(81) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-7 Now generate postings as a basis for the accounting assignment report. You can create the following account assignments using transaction FB01 or the relevant accounting posting transactions. In addition to the posting examples below, you can enter other postings. The more postings exist, the more evaluations are included in Actual Calculation. Use: - For input tax, use indicator V0 (or VN) - For output tax, use indicator A0 Use cost center. T-A20A##.. Use customer. T-T05A## or T-F00A##.. Use vendor. T-F00A00.. Use document type. SA.. If you post via a clearing account or customer/vendor (in other words, the document chain is set up this way), you clear the documents accordingly. You can select the value date of your choice. Today’s date is specified in the following table. BS. © SAP AG. Account. Amount. Value Date. 40. 113100. 10000. Today. 50. 273100. 10000. 40. 220000. 12000. 50. 113100. 12000. 40. 45000. 250000. 50. 113100. 250000. Today. 40. 113100. 750000. Today. 50. 70000. 750000. 40. 416300. 11000. 50. 100000. 11000. 40. 420000. 20000. 50. 113100. 20000. 40. 476000. 9000. 50. 113100. 9000. Today. Today. Today. Today FSC800. 4-19.

(82) SAP PORTUGAL | USO EXCLUSIVO | 2013. © SAP AG. 40. 478000. 21000. 50. 113100. 21000. 40. 930000. 125000. 50. 113100. 125000. Today. 40. 113100. 99000. Today. 50. 800200. 99000. 40. 43000. 85000. 50. 113102. 85000. 40. 113102. 85000. 50. 113100. 85000. 31. T-F00A00. 23000. 40. 476000. 23000. 25. 1000. 23000. 50. 113100. 23000. Today. Today. Today. Today. FSC800. 4-20.

(83) SAP PORTUGAL | USO EXCLUSIVO | 2013 Make a note of your document numbers:. © SAP AG. FSC800. 4-21.

(84) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-8 Start report FLQAC for your company code. Make a note of the most important results from the run:. Also navigate to the relevant accounting documents. 1-9 Carry out one or more transfer postings. To do so, navigate to the “Transfer” menu node. Carry out the following transfer postings for your company code: Company code: Date: Currency:. AC## Today Euro. For your company code AC## Liquidity item:. 127000. Amount: - 5,000. Liquidity item:. 112000. Amount: + 5,000. Liquidity item:. 126000. Amount: - 1,000. Liquidity item:. 127000. Amount: + 1,000. 1-10 Execute the payment report. To do so, go to the “Information System” menu node. 1-11 Call the totals list. To do so, go to the “Information System” menu node. 1-12 Call the G/L account list. Which liquidity item is assigned to G/L account 62110? Make a note of the liquidity item:. If the account is not assigned to a liquidity item, assign liquidity item 311000 to it.. © SAP AG. FSC800. 4-22.

(85) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-13. Develop a query for loan account 62110 for a loan repayment. Which indicator (Debit/Credit) is used for posting in the case of a loan repayment? Make a note of your answer.. Go to Settings Assignment from FI and develop your query. Name your query AC##_REPAY. Add the description/name. Assign the query to the query sequence of your company code. Post a loan taken of EUR 500,000. Make a note of the document number.. Post a loan repayment of EUR 50,000. Make a note of the document number.. Now start the “From FI Information” assignment mechanism (FLQAC). What is the result? Make a note of this:. © SAP AG. FSC800. 4-23.


(87) SAP PORTUGAL | USO EXCLUSIVO | 2013 Solutions Unit:. Application in ERP. Topic:. Using Actual Calculation. 1-1 Solution for generating test data and the files STATEMENT##.TXT and SALES##.TXT. System Services Reporting Program “RFEBKATX” (to call variant FSC800, choose “Get Variant” in the application function bar). Field Name or Data Type. Values. Format. M - MultiCash. Statement file. Statement##.txt. Line item file. Sales##.txt. Company code. AC##. House bank (ID). 1000. Account (ID). 1000. Statement date. Today. Invoice date. - 10 days. Posting method. Set indicator. Customers to be posted to. T-T05A##. First amount. For example, 1000. ... Generate open items in clearing accounts. Set indicator. ... Execute the report. Postings and bank statement files are now generated.. © SAP AG. FSC800. 4-25.

(88) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-2 Solution for importing bank statement files. Accounting Financial Supply Chain Management Cash and Liquidity Management Incomings Import Electronic Bank Statement (to call variant FSC800, “Get Variant” in the application function bar) Field Name or Data Type. Values. Import data. Set indicator. Format. M - MultiCash. Statement file. Statement##.txt. Line item file. Sales##.txt. Workstation upload. Do not set indicator. Post immediately. Set indicator. BELNR number interval. 1800000000 - 1809999999. Print bank statement. Set indicator. Print posting log. Set indicator. Print statistics. Set indicator. choose. Execute the report. The files are imported and posted immediately. 1-3 Solution for displaying bank statement data. Use transaction FF.6 or the menu path Accounting Financial Supply Chain Management Cash and Liquidity Management Cash Management Incomings Electronic Bank Statement Display Enter company code AC##, house bank ID 1000, and bank ID 1000. 1-4 The business transaction code for the imported data is: 051.. © SAP AG. FSC800. 4-26.

(89) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-5 To create the query, you can use transaction FLQQB1 or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Assignment from Bank Statement Edit Query Enter AC##_REV as the query ID and assign the relevant names. Then choose “Conditions”, enter 051 in the “Business trans code” field, and save your entry. To assign the query to the query sequence, you can use transaction FLQQB5 or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Assignment from Bank Statement Set Up Query Sequence Select query AC##-DEUBA and enter the query in position 5. Then save your entry. 1-6 To start the “From Bank Statement” assignment mechanism, use transaction FLQAB or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Assignment From Bank Statement Information 1-7 You can update the posting records using transaction FB01.. © SAP AG. FSC800. 4-27.

(90) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-8 To start the “From FI Information” assignment mechanism, use transaction FLQAC or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Assignment From FI Information 1-9 To make transfer postings between liquidity items, use transaction FLQT1 or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Transfer Create Now enter your data and save. 1-10 To call the payment report, use transaction FLQREP or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Information System Payment Report 1-11 To call the totals list, use transaction FLQLS or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Information System Totals List. © SAP AG. FSC800. 4-28.

(91) SAP PORTUGAL | USO EXCLUSIVO | 2013 1-12. To call the G/L account list, use transaction FLQLACC or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Information System G/L Accounts List Map account 62110 with liquidity item 311000 using transaction FLQC7.. 1-13 A repayment is posted to the debit side. This means that the debit indicator must be set in the “Conditions” settings. To assign the query to the query sequence, you can use transaction FLQQC1 or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Assignment from FI Edit Query Now enter query ID “AC##_REPAY” and assign liquidity item 312000. Then select the conditions and enter the debit indicator here. Save the conditions and the query. To assign the query to the query sequence, you can use transaction FLQQC5 or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Settings Assignment from FI Set Up Query Sequence. © SAP AG. FSC800. 4-29.

(92) SAP PORTUGAL | USO EXCLUSIVO | 2013 Post the loan taken with transaction FB01: Debit 113100 to Credit 62110. Post the repayment with transaction FB01: Debit 62110. to Credit 113100.. To start the “From FI Information” assignment mechanism, use transaction FLQAC or the following menu path: Accounting Financial Supply Chain Management Cash and Liquidity Management Liquidity Planner Assignment From FI Information. © SAP AG. FSC800. 4-30.

(93) SAP PORTUGAL | USO EXCLUSIVO | 2013 Migration from TR-CBM to LP. Content: How migration is carried out from TR-CBM to SAP LP.  SAP AG 2008. TR-CBM (SAP Cash Budget Management) SAP LP (Liquidity Planner). © SAP AG. FSC800. 5-1.

(94) SAP PORTUGAL | USO EXCLUSIVO | 2013 Application in ERP: Unit Objectives. At the conclusion of this unit, you will be able to: Understand the process of migrating from TR-CBM to SAP LP Name and use the relevant programs.  SAP AG 2008. © SAP AG. FSC800. 5-2.

(95) SAP PORTUGAL | USO EXCLUSIVO | 2013 Introduction. As of mySAP ERP 2004, the SAP Liquidity Planner (LP) application is used for liquidity management. Customers that use SAP Cash Budget Management (CBM) have to migrate from TR-CBM to SAP LP when upgrading mySAP ERP 2004..  SAP AG 2008. As of mySAP ERP 2004, the SAP Liquidity Planner (LP) application is used for liquidity management. Customers that use SAP Cash Budget Management (CBM) have to migrate from TR-CBM to SAP LP when upgrading mySAP ERP 2004.. © SAP AG. FSC800. 5-3.

(96) SAP PORTUGAL | USO EXCLUSIVO | 2013 Migration from TR-CBM to LP (Overview) TR-CBM. LP Liquidity item. Commitment item. Liquidity item. Commitment item FMFPO Text FMFPOT. Fin. trans. “30-70”. Accounts SKB1. RFLQ_XCB_INFACC (RFLQ_UPLOAD_INFACC). Accounts with financial trans.. LP: Info accounts. FLQACC_INFO_APP. Actual accounts T-cd:FLQC4. "90" Fin. trans. Comm. item fin. trans. “90” FMFPO- FIVOR Accounts SKB1. Text. FLQLPOST Info accounts T-cd:FLQINFACC. Accounts with financial trans. "30 – 70" Comm. item fin. trans. FMFPO- FIVOR. FLQLPOS. RFLQ_XCB_MASTER. RFLQ_XCB_ACTACC. LP: Actual accounts. FLQACC_ACT.  SAP AG 2008. The main tasks of migration are: 1) Migrate master data 2) Migrate info accounts 3) Reconciliate actual accounts 4) Regenerate actual data. © SAP AG. FSC800. 5-4.

(97) SAP PORTUGAL | USO EXCLUSIVO | 2013 Master Data Comparison I “Commitment item”– TR-CBM master data Attributes: 1. Financial transaction 30: Revenue/expense 60: Receivables/payables 80: Bank subaccounts 90: Cash 2. Commitment item category 1. Balance sheet 2. Revenue 3. Expense. The commitment item is assigned to every G/L account.  SAP AG 2008. The commitment item has two important attributes: • 1. Financial transaction • 2. Commitment item category If Cash Budget Management is activated, all G/L accounts must be assigned to a commitment item.. © SAP AG. FSC800. 5-5.

(98) SAP PORTUGAL | USO EXCLUSIVO | 2013 Master Data Comparison II "Liquidity item" – LP master data Attribute: "Name" and "Description" only.  SAP AG 2008. Only the "Name" and "Description" columns are required for the liquidity item master data.. © SAP AG. FSC800. 5-6.

(99) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 1: Master Data Migration I. TR-CBM Commitment item Commitment item FMFPO. Batch input session generated. ①. ②. Text FMFPOT. Execute RFLQ_XCB_MASTER LP Liquidity item Liquidity item FLQLPOS. ④. ③ Execute batch input session (T-cd;SM35). Text FLQLPOST.  SAP AG 2008. ①② RFLQ_XCB_MASTER reads the TR-CBM commitment item and generates a batch input session. ③④ The session is executed using transaction SM35 and the liquidity item is generated. Transaction FLQC1 is used to check the result.. © SAP AG. FSC800. 5-7.

(100) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 1: Master Data Migration II 1. Execute RFLQ_XCB_MASTER. (T-cd:FLQC1). ①. ②. Batch input session generated. ④ ③. Execute batch input session (T-cd;SM35)  SAP AG 2008. The migration process • ① Start RFLQ_XCB_MASTER • ② The master data can be checked here • ③ Execute session with SM35 • ④ Check the master data with FLQC1. © SAP AG. FSC800. 5-8.

(101) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 2a: Migration of Info Accounts I – RFLQ_XCB_INFACC. CBM G/L accounts with financial transaction "30 – 70" Fin. trans. Commitment item: Fin. trans. “30”-”70” FMFPO- FIVOR. Generate proposal list. ①. ②. RFLQ_XCB_INFACC. G/L account SKB1. LP Info accounts T-cd:FLQINFACC. Download list. ④. LP: Info accounts FLQACC_INFO_APP. ③ Upload local file to table FLQACC_INFO_APP with RFLQ_UPLOAD_INFACC.  SAP AG 2008. Step 2: "Migration of info accounts". The program steps in detail: • ①② RFLQ_XCB_INFACC generates a proposal list with the info accounts. Commitment items with category "30-70" should be included. • ③ A local file is generated • ④ RFLQ_UPLOAD_INFACC(T-cd; FLQUPINFAC) -> The local file is uploaded to table FLQACC_INFO_APP.. © SAP AG. FSC800. 5-9.

(102) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 2b: Migration of Info Accounts II – RFLQ_XCB_INFACC RFLQ_XCB_INFACC. ①. ②. List. Select G/L accounts with commitment item and transaction "30-70". T-cd: FLQINFACC. Upload local file. ④. Download list. RFLQ_UPLOAD_INFACC. ③  SAP AG 2008. Process: • ①② Data can be checked in the list before it is downloaded • ③. Save the list locally. • ④. Data can be checked in FLQINFACC. © SAP AG. FSC800. 5-10.

(103) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 3: Comparing Actual (Cash) Accounts RFLQ_XCB_ACTACC TR-CBM. LP. G/L accounts with transaction "90" Commitment item FMFPO- FIVOR. Other actual accounts T-cd:FLQC4. Fin. trans. “90”. G/L account SKB1. RFLQ_XCB_ACTACC. LP: Other actual accounts. FLQACC_ACT. RFLQ_XCB_ACTACC. G/L account entry with transaction FLQC4. 画. G/L account entry in table T012K. 面.  SAP AG 2008. The program RFLQ_XCB_ACTACC generates a comparison list for actual accounts. Missing accounts must be entered manually (FLQC4).. © SAP AG. FSC800. 5-11.

(104) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 4: Regenerating Cash Flows in LP I. ①. (Check). Master data and Customizing for Basis Complete LP Customizing Activate company codes FI. LP. FI documents. LP tables. ②. FI doc BKPF. LP: Totals table. FLQSUM FI doc BSEG. RFLQ_REBUILD. LP: Line item. FLQITEMFI. ③ Generation of cash flows with RFLQ_ASSIGN_REX (FLQAD)  SAP AG 2008. Generation of flow data: • ① Check LP Customizing • ② Update the data in LP • ③ Create flow data (cash flows) As an alternative to step 3, you have to copy the flow data using a report. To do so, use the program RFLQ_ASSIGN_EXIT with function module FLQ_STANDARD_ASSIGN_TRCB.. © SAP AG. FSC800. 5-12.

(105) SAP PORTUGAL | USO EXCLUSIVO | 2013 Step 4: Regenerating Cash Flows in LP II RFLQ_REBUILD. FI data is updated in LP with RFLQ_REBUILD. ①. ②. ③. Generate cash flows via RFLQ_ASSIGN_REX (FLQAD).  SAP AG 2008. Process: • ①② A check can be carried out here to determine the number of documents updated in LP. • ③. © SAP AG. Actual data is generated using transaction FLQAD.. FSC800. 5-13.

(106) SAP PORTUGAL | USO EXCLUSIVO | 2013 Summary Master data and Basis rules (steps 1-3): 1.RFLQ_XCB_MASTER – Generation of liquidity items from commitment items 2.RFLQ_XCB_INFACC –. Maintenance of info accounts from commitment items (30…70). 3.RFLQ_XCB_ACTACC – Comparison of TR- CBM actual accounts (90) with LP actual accounts The reports above generate master data and Basis rules (no queries) for the FLQAD assignment mechanism. Exceptions: taxes and cash discounts.. Cash flows (step 4): RFLQT_REBUILD: FI documents are updated in LP. Cash flows can then be generated for the liquidity items (FLQAD)..  SAP AG 2008. You must carry out two key activities: • Generate master data • 2. Generate flow data and assign the cash flows to the liquidity items.. © SAP AG. FSC800. 5-14.

(107) SAP PORTUGAL | USO EXCLUSIVO | 2013 Customizing in ERP: Summary. You are now able to: Understand the process of migrating from TR-CBM to SAP LP Name and use the relevant programs..  SAP AG 2008. © SAP AG. FSC800. 5-15.


(109) SAP PORTUGAL | USO EXCLUSIVO | 2013 BI Overview: Liquidity Planning and Cash Accounting. Contents: Overview of SAP NetWeaver Basic structures of SAP NetWeaver BI Reporting functions of SAP NetWeaver BI.  SAP AG 2008. © SAP AG. FSC800. 6-1.

(110) SAP PORTUGAL | USO EXCLUSIVO | 2013 BI Overview of Liquidity Planning and Cash Accounting: Unit Objectives. At the conclusion of this unit, you will be able to: Provide an overview of SAP NetWeaver Explain the basic structures of SAP NetWeaver BI Explain the reporting functionsSAP NetWeaver BI.  SAP AG 2008. © SAP AG. FSC800. 6-2.

(111) SAP PORTUGAL | USO EXCLUSIVO | 2013 BI Overview of Liquidity Planning and Cash Accounting: Business Scenario. Before you prepare and implement liquidity planning and cash accounting in BI, you want to obtain an overview of SAP NetWeaver BI..  SAP AG 2008. © SAP AG. FSC800. 6-3.

(112) SAP PORTUGAL | USO EXCLUSIVO | 2013 The SAP NetWeaver Platform. SAP NetWeaver™ PEOPLE INTEGRATION Multi channel access. …. Collaboration. INFORMATION INTEGRATION Bus. Intelligence. Knowledge Mgmt. Master Data Mgmt PROCESS INTEGRATION Integration Broker. Business Process Mgmt. Life Cycle Mgmt. Composite Application Framework. Portal. APPLICATION PLATFORM J2EE. ABAP. DB and OS Abstraction.  SAP AG 2008. SAP NetWeaver provides an integration architecture for all business applications and processes in a modern company. This architecture integrates people, information, and processes within a framework, allowing step-by-step implementation of its functions. Business Intelligence is a basic component of the Information Integration layer of SAP NetWeaver. The SAP NetWeaver Portal is a component of the People Integration layer. These two components work closely together and offer the user comprehensive functions for analyses and Business Information Reporting. SAP NetWeaver 2004s is the mySAP Business Suite edition of SAP NetWeaver 2004. The following key areas are relevant for liquidity planning in most projects: • From Information Integration: Business Intelligence and BI Content • From People Integration: Portal • Application Platform. © SAP AG. FSC800. 6-4.

(113) SAP PORTUGAL | USO EXCLUSIVO | 2013 SAP NetWeaver IT Practices. Enterprise Service Architecture. DB and OS Abstraction. Consolidation. APPLICATION PLATFORM J2EE ABAP. Unified Life-Cycle Management. PROCESS INTEGRATION Integration Business Broker Process Mgmt. Custom Development. Knowledge Mgmt. Master Data Mgmt. End-to-End Process Integration. Bus. Intelligence. Data Unification. INFORMATION INTEGRATION. User Productivity Enablement. Collaboration. Life Cycle Mgmt. Composite Application Framework. Portal. Business Event Management. Multi channel access. Business Information Management. PEOPLE INTEGRATION. Application governance and Security. SAP NetWeaver™.  SAP AG 2008. Business Information Management refers to the management of all types of information (structured and unstructured), from integration to delivery, with the aim of creating transparency and making information available within and outside the company. Companies can implement IT practices in stages so that the most urgent IT problems can be solved first. For each of these IT practices, SAP ships a selection of IT scenarios, all of which can be easily implemented.. © SAP AG. FSC800. 6-5.

(114) SAP PORTUGAL | USO EXCLUSIVO | 2013 SAP NetWeaver – IT Practices and Scenarios IT Scenarios. IT Practices User Productivity Enablement Data Unification Business Information Management Business Event Management End-to-End Process Integration. Running an Enterprise Portal. Enabling User Collaboration. Master Data Harmonization. Business Task Management. Master Data Consolidation. Enterprise Reporting, Query, and Analysis. Mobilizing Business Processes. Central Master Data Management. Business Planning and Analytical Services. Business Event Resolution Enabling Applicationto-Application Processes. Enterprise Knowledge Management. Enterprise Data Warehousing. Enterprise Data Warehousing. Business Task Management. Enabling Business-toBusiness Processes. Business Process Management. Enabling Platform Interoperability. Business Task Management. Custom Development. Developing, Configuring, and Adapting Applications. Enabling Platform Interoperability. Unified Life-Cycle Management. Software Life-Cycle Management. SAP NetWeaver Operations. Application Governance & Security. Authentication and Single Sign-On. Integrated User and Access Management. Consolidation. Enabling Platform Interoperability. SAP NetWeaver Operations. Enterprise Service Architecture – Design & Deployment. Master Data Consolidation. Enterprise Knowledge Management. Enabling Enterprise Services.  SAP AG 2008. The IT practice of Business Information Management is divided into three IT scenarios. • Enterprise Reporting, Query, and Analysis • Business Planning and Analytical Services • Enterprise Data Warehousing These IT scenarios describe how companies can use the functions of SAP NetWeaver to complete tasks in the IT practice of Business Information Management. Each IT scenario covers everything that companies require to carry out the Discovery, Evaluation, Implementation, and Operations life cycle phases.. © SAP AG. FSC800. 6-6.

(115) SAP PORTUGAL | USO EXCLUSIVO | 2013 Business Intelligence Scenarios in NetWeaver 2004s BI scenarios in SAP NetWeaver 2004s Enterprise Reporting, Query, and Analysis Stronger focus on user productivity Formatted reporting Intuitive ad-hoc analysis Enhanced Excel integration Model-based BI applications Business Planning and Analytical Services Business Planning – integrated in BI Platform and Suite Enterprise Data Warehousing Increased performance due to BI Accelerator Flexibility through improved data modeling functions Data transfer process Real-time data acquisition Web-based Administrator Cockpit.  SAP AG 2008. SAP NetWeaver BI creates a basis for reporting and analytics in business applications. It provides information to multiple end users, integrates planning in user interfaces and services, and strengthens its role as a strategic data warehouse platform. The IT scenarios focus directly on these goals: • Enterprise Reporting, Query, and Analysis. Increase availability. • Business Planning and Analytical Services. Integrate planning. • EDW. © SAP AG. Strategic data warehouse platform. FSC800. 6-7.

No results found