Treasury reporting with SAP Analytics Cloud (SAC)

Use the integrated data management for optimal reporting

Dates & Place

15.05.2024 in Düsseldorf
08.11.2024 in Düsseldorf

Level

Special knowledge

Duration

1 day

Costs

EUR 1.650,- plus VAT.

Speakers
Sebastian Alfery

Sebastian Alfery

Senior Manager

Schwabe, Ley & Greiner

Georg Glöckner

Georg Glöckner

Partner

MMG Treasury

Content

The "SAC Treasury Reporting" seminar offers you a practice-oriented introduction to the creation of SAP Treasury Reporting with the help of SAP Analytics Cloud.

We start with an introduction to the world of data in SAP Treasury. We will first give you an overview of how data is stored in SAP in general and in the relevant treasury modules. The spectrum ranges from data storage for financial transactions and payment transactions to cash and liquidity management.

Based on data storage in SAP, we discuss possible variants of data extraction and how these can be transferred to SAC, depending on the use case. We then demonstrate the different variants of SAC data connections, including import methods, in order to discuss their advantages and disadvantages.

With the data now available in SAC, we will discuss the principles of sensible data modeling. To give you a better feel for the subject matter, you will build your own treasury data model in SAC directly during the seminar.

With the data model complete, it's time to create the report. Here, too, you can "lend a hand". We use the previously created treasury data model and create an initial treasury report. Our standard report forms and best practices from numerous treasury projects serve as a guide. Finally, we give you an insight into the world of SAC formulas and scripts so that you can add your own calculations directly in SAC.

We conclude the seminar day with typical implementation pitfalls and venture an outlook on your future treasury reporting.

Our SAP Treasury seminars are held in cooperation with MMG Treasury.

Main topics

Basics

  • What are the tasks of the cash manager in the company?
  • What are the minimum standards to be taken into account in the organizational structure & process organization?
  • What are the differences in the accounting or treasury perspective? Which business management approaches do you need to understand?
  • What are the requirements vis-à-vis banks?
  • What are the current trends in cash management for large and small companies?

Treasury data management in SAP and data export

  • Overview of data management in SAP
  • Presentation of SAP table structures according to treasury modules
  • Variants of data extraction

Data import into SAC

  • Options for connecting SAP systems to SAC
  • Integration of treasury data via data import
  • Integration of third-party tools via API
  • Advantages and disadvantages of using SAP Standard

Create treasury data model in SAC

  • Basics of data modeling in SAP
  • Joint development of a treasury data model
  • Optimization of the data model for efficient reporting

    Create treasury reporting in SAC

    • Introduction to the principles of reporting in SAC
    • Joint development of our own treasury reporting system
    • Data actions, scripting and formulas in SAC
    • Best Practice Reporting

      Currency translation in treasury reporting

      • Understanding currency conversion in SAP
      • Performing currency conversions for analyses and reports
      • Consideration of exchange rates and conversion factors

      Group of participants

      Employees and managers from the Treasury department who are interested in the possibilities that SAP offers in the area of reporting.

      Targets

      Participants will learn about the application possibilities of SAP in the area of treasury reporting and see some practical examples of meaningful treasury reporting with SAP Analytics Cloud.

      Do you have any questions?

      Marc Baumgärtner

      Marc Baumgärtner

      Seminar organization

      Treasury Training

      Other seminars

      Cash pooling from a legal perspective

      Tax and legal aspects of the use of cash pooling

      Cash and liquidity management

      Freeing up liquidity through efficient cash management

      The new world of payment transactions

      Organization and trends around payment transactions

      Liquidity planning: simple, system-supported, future-proof

      What to look out for when setting up modern liquidity planning

      SAP: S/4HANA - what you need to know in Treasury

      We help you find the right strategy

      Liquidity planning and cash flow analysis in SAP

      Evaluate, plan and forecast liquidity with SAP

      Digitization in treasury: new technologies and system functionalities

      Concrete digitization projects, background knowledge on new technologies, new functions on the treasury system market

      Treasury Training

      Registration