Explaining the Treasury Workstation Cash Integration (34P)

Objectives

After completing this lesson, you will be able to:

  • Describe the scope of Treasury Workstation Cash integration
  • Use the Treasury Workstation Cash integration
  • Identify Treasury Workstation Cash integration configuration steps

Treasury Workstation Cash Integration Overview

Treasury Workstation Cash Integration Overview

The Treasury Workstation Cash Integration makes it possible for the SAP S/4HANA treasury workstation, normally set up in a group headquarters, to receive the cash flow data from any remote systems of the subsidiaries. This data is incorporated into the various cash reports (for example, Cash Position, Check Cash Flow Items, Cash Flow Analyzer) for the cash disposition analysis.

With SAP S/4HANA Cloud or On-premise on either side of the communication, the house bank and account master data can be replicated from one end to the other. 

Treasury Workstation Cash Integration Process

The service contains cash flow information, such as keys for cash flows, value date, amount, currency, company code, certainty level, bank account, and account assignment information, such as G/L account and liquidity item.

When data validation and business data mapping have been performed in the SAP Application Interface Framework, the information is then saved in the cash management system. If there are any issues during validation and business data mapping, the system displays error messages in response. If all of the information is fine it can be released and will thereby be incorporated into the Cash Reports.

Furthermore House Bank Data can be replicated between the SAP S/4HANA Cloud and On-Premise System. Consistency of the master data is secured at all times.

Treasury Workstation Cash Integration Cash Flow

A customer may run several SAP ERP systems as well as non-SAP ERP systems, all of which are able to share Cash Flow information with the Treasury Workstation.

This cloud application receives cash flow information. After data validation and business data mapping are performed, data is stored in One Exposure.

Technically, the inbound SOAP service is an asynchronous service. The specific name of the webservice is CASHFLOW_IN.

The service enables you to Create, Update, and Delete cash flows with the data provided in a payload.

The service contains cash flow information, such as keys for cash flows, value date, amount, currency, company code, certainty level, bank account, and account assignment information, such as G/L account and liquidity item. After data validation and business data mapping are performed in the SAP Application Interface Framework (AIF), the information is then saved in the cash management system. Any issues during validation and business data mapping result in the system displaying an error message.

AiF Framework

It is possible to send e-mail notification (automatically) if there is any error in AIF, and even possible to define groups of recipients for different entities so that the business user is notified only if there is an error connected to his responsible entities.

In standard delivery, you cannot adjust values in the AIF framework. On-premise customers can perform customizing to define editable fields and make their own adjustments. This is not possible with Cloud.

The AIF framework handles the serialization of information according to the GenericKey field.

The GenericKey is used to define a specific business data set. In this case, the same generic key reflects the same set of data.

Serialization of requests is considered according to the Generic Key.

All requests will be first come, first processed. Further requests with same generic key will be pending.

Release Cash Flow

The SAP Fiori app Release Cash Flows helps cash managers to release cash flows after checking the correctness of forecast flows submitted by subsidiary cash managers so that released cash flows can be shown in the cash position report for decision-making.

The process is particularly important where forecast cash flows are collected from different sources by different responsible people. In this case, information needs to be reviewed and released afterwards so that the information for decision-making is reliable.

You can set the release mechanisms in Manage your Solution via the configuration step, Define Criteria for Manual Release. For more information on this, see the configuration section of the Treasury Workstation Cash Integration.

All processes set the release flag according to the configuration.

  1. If remote cash flow is updated or deleted by a later call of SOAP Webservice, the system checks the configuration and sets the default status, regardless of whether or not the previous flow is released.
  2. If a memo record is updated in the SAP Fiori app, Manage Memo Records, the default status is set by checking the configuration, despite the previous release status of the memo record.

The additional Lock mechanism for release cash flow will ensure the data consistency for remote flows and memo records.

It will prevent the data to be changed by several users at the same time.

  1. Release could fail if the to-be-released memo record is locked for editing in Manage Memo Records.

  2. The opposite also applies; if the to-be-released memo record is being released, editing in the Manage Memo Records will fail due to the lock.

  3. If one remote flow is being released and at the same time, this updated flow is being importing into the system, the newly imported flow will be locked and held on in AIF.

Treasury Workstation Cash Integration Bank Accounts

This integration scenario reuses the existing ALE/IDOC (Message type BAMMAST and HBHBAMAST) in SAP S/4HANA, on-premise, to replicate bank account master data between an SAP S/4HANA, on-premise system and SAP S/4HANA Cloud system.

The data replication is performed using IDOC via SOAP.

The following master data objects are included as part of this integration scenario:

  • Bank Account
  • House Bank
  • House Bank Account

From your SAP Fiori launchpad, choose the Replicate by Replication Model tile. On the screen, you can select the replication model, the target system, or the replication mode.

Select the Filter Criteria at the top to replicate only specific house banks.

In the filter criteria, you can set specific account numbers to be replicated by the model. This data is then taken over in the replication.

Monitoring

Through the Interface Monitor, you will get an overview of the transferred messages and their status.

With the calendar, you can filter for specific dates. The result list can be filtered by messages. For example, you can choose to view only messages relating to you.

Finally, when the replication is successful, the new Bank Account can be displayed in the SAP S/4HANA system.

Go to the Manage Bank Accounts app to check for the data coming from your replication scenario.

Treasury Workstation Cash Integration Configuration Steps

Manage your Solution

To access the Configuration screen, select the Manage your Solution app.

The task Configure Your Solution allows you to maintain certain processes.

Self-Service-Configuration tasks

With this activity, you can define rules for manual release of cash flows, such as logical system, company code and planning level. Flows with these attributes are selected for further review and release.

In the On-Premise system, you need to perform the configuration to reassign company codes and convert planning groups and planning levels.

For example, you can assign the company codes of the subsystem to the ones in the central system.

Go to Manage your Solution in your Cloud system. Select the Finance area, then the sub-area Cash and Liquidity Management. In Cash Operations check the step: Define Criteria for Manual Release. With this activity, you can define rules for manual release of cash flows, such as logical system, company code and planning level. Flows with these attributes are selected for further review and release. Other flows will be automatically released and do not need the end user to operate in this app.

Log in to track your progress & complete quizzes