Skip to Content
Product Information
Author's profile photo I-Lin Hsu

How to integrate SAP Analytics Cloud for planning with SAP S/4HANA for group reporting

 

CUSTOMER

This guide applies to the following SAP S/4HANA Finance for Group Reporting release and above:

  • Version 2208 (cloud)
  • Version 2022 (on premise)

Author

SAP S/4 HANA and SAC Product Engineering

Revision history

 

Date Description
August 2022 Initial
Update

Purpose:

This article is created to help customers and partners understand how to integrate SAP Analytics Cloud for planning with SAP S/4HANA Group Reporting. The scenarios and steps outlined in this article are meant as a guideline to ease deployment of the solutions by customers, which need to be adapted in real life for the specific corporate planning scenarios and requirements of each customer.

This article complements the previous blog issued in year 2020 on the same topic with updates on the new features using examples of financial statement planning.

Table of Contents

 Planning scenarios, process flow, and technical components 

1. Import S/4 HANA Group Reporting transaction data to SAP Analytics Cloud 

1.1 Adapt import script 

1.2 Data transformation during import to SAP Analytics Cloud 

2. Perform corporate planning in SAP Analytics Cloud 

2.1 Planning activities of corporate planning 

2.2 Data harmonization – carryforward and opening balance 

3. Export plan data from SAP Analytics Cloud to S/4 HANA Group Reporting 

3.1 Separate export jobs for B/S and P&L 

3.2 Transformation 

3.3 Filtering

4. Run plan consolidation in S/4 HANA Group Reporting 

5. Configuration in S/4 HANA Group Reporting for plan consolidation

5.1 Document types for data collection task 

5.2 Plan category & consolidation cycle 

5.3 Adjust additional configurations

Summary

More Information

Planning scenarios, process flow, and technical components

There are typical corporate planning scenarios performed in a business organization:

  1. You as a planner of a local entity want to use the entity close of your actual data for this year / month as a starting point for planning next year or the remaining months of the year.
  2. You as a planner of a local entity have already run planning for the local entities and you need to work with your corporate controller to consolidate the plan data and issue comparative consolidated financial statements for next year or the remaining months of the year.
  3. You as a corporate planner for your entire organization want to use the corporate close of your actual data for this year / month as a starting point to set the target for next year or the remaining months of the year.
  4. To continue with 3. above, you need to work with your corporate controller to consolidate the plan data and issue comparative consolidated financial statements for next year or the remaining months of the year.

If you are using S/4 HANA and SAP Analytics Cloud from SAP, the process diagram below breaks down the above scenarios and mirrors them with steps in the combined solution to facilitate your planning process. You might run part or all of these steps depending on the following:

  • Your role in the organization
  • Purpose of your planning
  • Starting point of the planning
  • Overall system architecture in your company
  • Data models you use in both S/4 HANA and SAP Analytics Cloud

In this article we focus on scenarios 3. and 4. above, i.e. to plan on the actual close of the data from S/4 HANA Group Reporting and consolidate the plan data back in S/4 HANA Group Reporting.

Process diagram:

 

Steps in the process diagram:

For corporate planners:

(1) Import actual data from SAP S/4HANA Group Reporting into the corporate planning model in SAP Analytics Cloud and initialize plan data (SAP Analytics Cloud version = Actual).

(2) Perform corporate planning with planning features (spread, distribute, allocate…) for budget, forecast, rolling forecast, etc. Distribute it among entities when needed.

(3) Export corporate plan data to S/4 HANA Group Reporting for plan consolidation.

The rest of this article focuses on the above three steps.

For entity planners:

<1> Import actual data from S/4 HANA Accounting into the company planning model in SAP Analytics Cloud and initialize plan data (SAP Analytics Cloud version = Actual).

<2> Perform entity / local planning with planning features (spread, distribute, allocate…) for budget, forecast, rolling forecast, etc.

<3> Export entity plan data to S/4 HANA Accounting first.

<4> Release entity plan data to S/4 HANA Group Reporting for plan consolidation.

The second diagram below shows the key technical components needed to run the above processes based on S/4 HANA Group Reporting and SAP Analytics Cloud. We touch upon some of them in the sections that follow in this article.

 

1. Import S/4 HANA Group Reporting transaction data to SAP Analytics Cloud

You might know already that you can run a full-blown consolidated financial statement in SAP Analytics Cloud for data from SAP S/4HANA Group Reporting that apply features such as IC elimination during report run-time, consolidation in multiple Group currency, group dependent properties, and so on. These same CDS views plus the OData services on top were also delivered as Application Programming Interface (“API” in short) and packaged into an API service (APIs & Communication scenarios (SAP_COM_0370)) and work along with the import function in SAP Analytics Cloud to pull S/4 HANA Group Reporting data into SAP Analytics Cloud for planning purpose. Depending on the planning frequency you can schedule regular job runs in SAP Analytics Cloud to import data.

1.1 Adapt import script

When creating an import job in SAP Analytics Cloud based on the aforementioned import API for S/4 HANA Group Reporting, you can add or remove parameters in the script to fit it to your planning scenario.

For example, for a typical top-down planning process you want to start with the consolidated financial statement of the actual version. To do this you can simply specify a specific consolidation group and a specific consolidation version in the import script. It looks like this:

GROUP REPORTINGTransactionData(P_ConsolidationUnitHierId=’$’,P_ConsolidationPrftCtrHierId=’$’,P_ConsolidationSegmentHierId=’$’,P_KeyDate=datetime’2022-01-01T00:00:00′)/Results?$select=FiscalYearPeriod,ConsolidationUnit,PartnerConsolidationUnit,FinancialStatementItem,ProfitCenter, PartnerProfitCenter,SubItem,SubItemCategory, AmountInLocalCurrency, AmountInGroup ReportingoupCurrency &$filter=ConsolidationVersion eq ‘Y10’ and PeriodMode eq ‘PER’ and ConsolidationGroup Reportingoup eq ‘CG0’ and FiscalYear eq ‘2022’ and (FiscalPeriod ge ‘000’ and FiscalPeriod le ‘012’)

 

If you would rather plan on the unconsolidated data from S/4 HANA GROUP REPORTING for bottom-up planning, you can add filtering on posting levels and consolidation units so it looks like this:

GROUP REPORTINGTransactionData(P_ConsolidationUnitHierId=’$’,P_ConsolidationPrftCtrHierId=’$’,P_ConsolidationSegmentHierId=’$’,P_KeyDate=datetime’2022-01-01T00:00:00′)/Results?$select=FiscalYearPeriod,ConsolidationUnit, PartnerConsolidationUnit, FinancialStatementItem,ProfitCenter,Partner ProfitCenter,SubItem,SubItemCategory,AmountInLocalCurrency,AmountInGroup ReportingoupCurrency&$filter=ConsolidationVersion eq ‘Y10’ and PeriodMode eq ‘PER’ and ConsolidationGroup Reportingoup eq ‘CG0’ and FiscalYear eq ‘2022’ and (FiscalPeriod ge ‘000’ and FiscalPeriod le ‘012’) and ConsolidationUnit eq “1710” and (startswith(PostingLevel , ‘0’) or startswith(PostingLevel , ‘1’) or PostingLevel eq ” 

 1.2 Data transformation during import to SAP Analytics Cloud

In 2021 SAP delivered SAP Analytics Cloud content for planning on S/4 HANA Group Reporting. This content includes basic S/4 HANA Group Reporting dimensions, a model called “SAP_FI_IM_GroupFinance”, data actions, and planning stories. You can use this content as a reference for creating your own planning scenario. It is undergoing continuous enrichment taking into account product innovations in both S/4 HANA Group Reporting and SAP Analytics Cloud and also feedback from customers.

Given a few differences between S/4 HANA Group Reporting and the delivered SAP Analytics Cloud model, there are a few transformations needed in moving data between S/4 HANA Group Reporting and SAP Analytics Cloud when you use the import and export functions in SAP Analytics Cloud. Let’s look at the transformations needed based on the content model for the import first:

a) Posting period

In S/4 HANA we use posting period “000” to store the data (mainly for balance sheet accounts) being carried forwarded to the new year upon year end close. Since posting period “000” is not recognized in SAP Analytics Cloud, you need to replace it with period value “001” during import for all opening balances.

 

b) Transaction type, functional area, subitems, and subitem category

For simplicity the SAP Analytics Cloud model “SAP_FI_IM_GroupFinance” for S/4 HANA Group Reporting planning was delivered with basic dimensions that include transaction type, functional area, and a few dimensions based on S/4 HANA Group Reporting. It does not include subitem or subitem category which are solely used for consolidation purpose and not known for typical planners. And not all processes in S/4 HANA Group Reporting update transaction type or functional area while subitem is needed and updated each time you run transactions in S/4 HANA Group Reporting. To bridge the difference between the solutions, you can either add subitem and subitem category into your own SAP Analytics Cloud planning model for S/4 HANA Group Reporting. You can also create simple transformations during import to derive the correct values for transaction type and functional areas based on subitem and subitem category for planning purpose. It looks like this:

Transform transaction type for balance sheet FS items:

 

Transform functional area for income statement FS items:

 

Check out the following for details:

2. Perform corporate planning in SAP Analytics Cloud

Once you have the S/4 HANA Group Reporting data loaded into a planning model in SAP Analytics Cloud, you can start your corporate planning activities in SAP Analytics Cloud.

2.1 Planning activities of corporate planning

SAP Analytics Cloud content model SAP_FI_IM_GroupFinance, related data actions and stories enable you to do the following typical planning activities. You can copy and adapt the content to cater for your own planning scenario.

a. Set corporate target based on consolidated data of the actual version.

b. Perform top-down as well as bottom-up planning for legal as well as management views. The content model is shipped with consolidation unit and consolidation profit center dimensions to denote these two views.

 

 c. Simple allocation to spread corporate targets among individual consolidation units as well as               consolidation profit centers along the hierarchy. See an example below:

 

d. Simple currency translation to convert corporate targets set in group currency to the local  currency of the respective consolidation unit. Simple translation from local currency to group currency is also possible in the case of bottom-up planning.

 

e. Essential data administration tasks such as harmonizing actual data (see section 2.2 below), copying actual data to the plan version, calculating retained earnings and balancing books, and so on.

2.2 Data harmonization – carryforward and opening balance

In S/4 HANA Group Reporting you carry forward the balance sheet accounts typically once a year and store the opening balance in a dedicated subitem (subitem “900” is delivered in 1SG business content in S/4 HANA Group Reporting for this purpose) in the new year. In contrast monthly carryforward is used in SAP Analytics Cloud (transaction types “X00” and “X99” are used in the delivered SAP Analytics Cloud content to store the opening and ending balance each month). In view of the different way of handling balance carryforward, two conversion rules embedded in two data actions are used to harmonize both the incoming S/4 HANA Group Reporting data to SAP Analytics Cloud and outgoing data from SAP Analytics Cloud to S/4 HANA Group Reporting.

By running data action Prepare actuals (SAP_FI_GFP_IM_Group ReportingoupFinance_PrepareActuals) after you import the actual data from S/4 HANA Group Reporting to SAP Analytics Cloud, transaction type “900” of imported data is copied to “X00” so that the opening balance from S/4 HANA Group Reporting can be processed correctly throughout the planning process in SAP Analytics Cloud. And vice versa by the end of planning when you run another data action called Calculate balance sheet for closing (SAP_FI_GFP_IM_Group ReportingoupFinance_CalculateBSClosing), it then copies all plan data that is in “X00” to “900” before it’s ready for you to export it to S/4 HANA Group Reporting for plan consolidation.

Conversion rule to copy data from transaction type “900” to “X00”:

 

Conversion rule to copy data from transaction type “X00” to “900”:

Note that if you use different subitem / transaction type instead of “900” / “X00” for opening balances, you have to adapt the scripts in the corresponding data actions.

Check out the following for details:

 3. Export plan data from SAP Analytics Cloud to S/4 HANA Group Reporting

Once you set the corporate target in SAP Analytics Cloud, you can compare the target with the upcoming actual close coming from SAP S/4HANA Group Reporting for reporting purpose. If you perform a top-down planning or start with planning on entity (local) level in SAP Analytics Cloud and need to consolidate this plan data, you can also export the plan data back to S/4 HANA Group Reporting and consolidate in there, this is the so called “plan consolidation”. Either step (3) or <3> in the process flow in section 1 allows for exporting plan data back to S/4 HANA, depending on the dimensions you use for planning – if you plan on dimensions of S/4 HANA accounting such as company code, GL account, cost center, profit center, and so on, you export the plan data to the planning table in S/4 HANA accounting (step <3>) and then release it to S/4 HANA Group Reporting for consolidation; if you plan instead on dimensions of S/4 HANA Group Reporting such as consolidation unit, FS items, consolidation profit center, and so on, then you can export it directly to S/4 HANA Group Reporting, which is the focus of this section (step (3)) .

Note that both import into and export out of SAP Analytics Cloud are triggered at SAP Analytics Cloud side with job loads. While the import API was delivered prior to year 2022, SAP delivers the export API for S/4 HANA Group Reporting officially in year 2022 with S/4 HANA CE 2208 / OP 2022. The export API pushes SAP Analytics Cloud planning data to S/4 HANA Group Reporting based on the definition of the export job at SAP Analytics Cloud. Towards the end of the export job run, it triggers the data collection task in S/4 HANA Group Reporting to receive, check, and update the plan data for the corresponding plan version, fiscal year / period(s), FS items, subitems, consolidation units, consolidation profit centers, and so on. You can use the task log for data collection, display group journals, or reports to analyze load details in the same way as closing the actual version when you load reported financial data with a flat file, GRDC, or bulk import APIs.

Differences between SAP Analytics Cloud and S/4 HANA data models and the ensuing transformation for import described in section 1 of this article apply also to the export process. See some transformations and filtering needed when defining the export job below.

3.1 Separate export jobs for B/S and P&L

Due to different ways of processing document types between SAP Analytics Cloud and SAP S/4HANA, if you need to export planning of the whole financial statement (i.e. for both balance sheet and income statement accounts) to SAP S/4HANA Group Reporting, create at least two export jobs and use different consolidation document types in each job, e.g. load balance sheet FS items in the 1st export job with document type “01” chosen in there and load income statement FS items in the 2nd export job with document type “02”. Once you define the export jobs you can repeat each job run to load B/S and P&L separately whenever you change the planning amount

3.2 Transformation

For the same explanation outlined in section 1.2 of this article, define a simple transformation in the export job so that it copies the value of transaction type to the subitem of each balance sheet FS item.

 

And in the same way map subitem to the functional area for subitem category “2” in the export job for P&L FS items.

 

3.3 Filtering

Different ways of handling carryforward and opening balance (see section 2.2 of this article) between SAP Analytics Cloud and S/4 HANA Group Reporting also requires you to filter the export job by the correct transaction types. This is especially relevant when you export balance sheet FS items to S/4 HANA Group Reporting.

Select transaction type “900” and “C99” (a hierarchy node that includes all changing amount of a period) when filtering transaction type:

Sample filtering of balance sheet load to S/4 HANA Group Reporting:

  • Filter on plan version and balance sheet FS items:

 

  • Filter on transaction types “X00” and “C99”

 

Sample filtering of P&L load to S/4 HANA Group Reporting:

 

Check out the following for details:

4. Run plan consolidation in S/4 HANA Group Reporting

Once you get plan data in the plan version in S/4 HANA Group Reporting, you can run through related tasks in the monitors in the same way that you close the actual version. After that you can use various reporting tools in S/4 HANA, SAP Analytics Cloud, or any other reporting tools available to you for comparative analysis between actual and plan. We do not detail these processes in this article. Check SAP S/4HANA Group Reporting Help Portal for details.

5. Configuration in S/4 HANA Group Reporting for plan consolidation

Plan consolidation in S/4 HANA Group Reporting follows similar configuration steps needed for closing the actual data. There are a few additional steps to watch out for:

5.1 Document types for data collection task

You need to flag document types with “external reported financial data” to make these document types available on the list of export mapping screen in SAP Analytics Cloud and recognizable by the API to push plan data to S/4 HANA Group Reporting.

 

5.2 Plan category & consolidation cycle

If you need to run monitor tasks including data collection for multiple periods for the plan version in one go, you need to do the following:

a. Flag the version used for plan consolidation as an S/4 integrated version and assign a plan category. Doing this allows you to use this version to retrieve plan data from SAP S/4HANA plan table as well as from SAP Analytics Cloud, plus other external data sources. It is also a prerequisite to run multi-period plan consolidation for all data sources.

 

b. Assign the above consolidation plan version to a consolidation cycle:

 

 

5.3 Adjust additional configurations

The versioning concept in S/4 HANA Group Reporting allows you to reuse similar configurations across different versions and adapt them easily in the target version. See the following example for plan consolidation version YB3 which uses configurations from other versions for different consolidation processes:

Check details in S/4 HANA Group Reporting on-line documentation.

 

Summary

With S/4 HANA CE 2208 / OP 2022 we close the last mile of integrating plan data for financial consolidation. You can now perform entity planning as well as corporate planning using S/4 HANA and SAP Analytics Cloud based on built-in integration on planning functions and analytics reporting. We look forward to hearing your feedback through the post of this blog.

More information

Documentation

Product release slide deck

Tutorial videos

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Assigned Tags

      27 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Madhusekhar Gupta Gadamsetty
      Madhusekhar Gupta Gadamsetty

      Excellent blog I-Lin! Thanks for sharing.

      Regards

      Madhu

      Author's profile photo Mark Sargent
      Mark Sargent

      Great blog post! 💪

       

      Quick question:

      Am I correct in presuming that the special (virtual elimination) logic built into the Group Reporting ABAP CDS views for matrix consolidation cannot be fully reproduced in SAC native models?

      In other words, SAP's suggested approach for matrix consolidation reporting is still based on back-end queries based on those CDS views (i.e. SAC live models), not SAC native/import models?

       

      Thanks,

      Mark

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Mark,

      Virtual elimination logic in the same CDS views ( e.g. A_CNSLDTNTRANSACTIONDATA) is used for both live story (for real-time reporting) and import model (for canned reporting and / or planning). It's just that for the planning purpose, SAP also delivers API and oData services on top of the CDS view(s) to smooth the data transfer. I'm copying the overview for the same API here that you'll see in help.com:

      Group Reporting Planning Integration (SAP_COM_0370)

      This communication scenario is dedicated to the integration of SAP S/4HANA Cloud for group reporting with SAP Analytics Cloud (SAC). It offers the following OData services to read SAP S/4HANA Cloud for group reporting data. SAC users can use this scenario to import SAP S/4HANA Cloud for group reporting master data and transaction data into SAC dimensions and models:

      • API_GRMASTERDATA: Master Data for Group Reporting – Read

      • API_CNSLDTNGRPJRNLITEM: Transaction Data for Group Reporting – Read

      • IWFND_SG_MED_CATALOG_0002_IWSG: Catalog Service Version 2

      Let me know if this address your question.

      Thanks and regards,

      i-lin

       

      Author's profile photo Mark Sargent
      Mark Sargent

      Hi i-lin,

      Many thanks for your quick answer!

      It's very interesting to know that GR reporting is possible on an import model in case a real-time live connection is not desired. I was under the impression that the logic tied up in the GR CDS Views couldn't be replicated directly as it is rather complex (i.e. query run-time eliminations).

      Regards,

      Mark

      Author's profile photo James Lim
      James Lim

      Hi I-Lin

      For the import data to SAC using GRTransactionDataResults API, I know we used Dynamic script  before as you explained in section 1.1  but I could not see that option any longer.

      Instead of using complex scripts, now it is possible to use drag and drop which is much better UI 🙂

      I believe SAC development team finally enhanced it so that we can remove that complex script and can use Drag and Drop with filtering.

      My SAC version is 2022.8.17. Please let me know your comment after you check it.

      Thank you!

      James Lim

       

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi James,

      Freehand SQL is still available if the SAC connection is of the type “OData Services”.  If the SAC connection type is “SAP S/4HANA”, there is only an option to build a query using the “Build SAP S/4HANA Query” wizard, which is not working yet for GRTransactionDataResults since hierarchy parameters cannot be added to the fitler part of the SAC wizard.  We're hoping to lift this limitation early next year for a better UI for the import step.

      Regards,

      i-lin

       

      Author's profile photo James Lim
      James Lim

      Thanks for making it clear!

      Author's profile photo Dmitrij Rempel
      Dmitrij Rempel

      Hi I-Lin,

      thank you very much for this detailed and very informative blog.

      Our customers were interested in group planning wit usage of SAC and Group Reporting. We were waiting for functionality of writing back of plan data from SAC into Group Reporting.

      We still have 2 questions:

      1. Export from SAC into GR: is it always full export? Or is there a possibility to transfer only the data changed in SAC since last transfer?
      2. Intercompany reconciliation. We can use ICMR in S/4HANA (on the level of ACDOCA), we can use it in Group Reporting (on the level of ACDOCU). Is it planned to make it usable in SAC? So that you can reconcile your planned intercompany values? Or is it necessary to transfer data into Group Reporting, reconcile it there with ICMR and transfer back to SAC for further planning rounds?

      Kind regards,

      Dmitrij

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Dmitrij,

      Great to receive your feedback. Regarding the two questions, here's the current status:

      1. Yes SAC always exports full amount. And the write-back API reverses the old data and posts new in full too in S/4 HANA GR.
      2. To use full-blown ICMR functions, you need to have the data in S/4 HANA. Though you can also script basic reconciliation in SAC.

      Regards,

      i-lin

      Author's profile photo Dmitrij Rempel
      Dmitrij Rempel

      Hi I-Lin,

       

      thank you for clarification.

       

      Kind regards,

      Dmitrij

      Author's profile photo Marijn Bax
      Marijn Bax

      Thank you for this great blog. It comes in very handy to already have the transformation steps and some sample import scripts.

      We have decided not to load planned data back into Group Reporting (as we are not eliminating anything in our plan, (we simply do not plan intercompany transactions). Instead we have decided to combine the planned and consolidated data in SAC. This way a planner can immediately see what is planned and does not have to wait for the data to be loaded into S4 GR, process the steps of the data monitor and consolidation monitor etc before they can see can see any data.

      Kind Regards,

      Marijn

      Author's profile photo Cristina Talmaciu
      Cristina Talmaciu

      Hi! We need to integrate ACDOCU table with SAC to upload the actual consolidated data in SAC. Why do you recommend doing the integration via APIs? Is not possible to connect straight to the CDS view using the native S/4HANA connection? I'd like to mention that in our case we don't need to write the data back to S/4HANA. Please, let us know which is your recommendation.

      Author's profile photo Henry Banks
      Henry Banks

      Hi Cristina Talmaciu

      SAC connects to S/4HANA CDS Views using an intermediary layer called ‘Analytical queries’ (essentially an embedded BW runtime)

      Help guide for the Live/Online connection starts here: https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/d2a1edf7cda74315a2c5052de8a3a4eb.html

      only CDS View of Type CONSUMPTION were consumable and they needed to have the annotation @Analytics.query:true (to generate a transient query) set in the ABAP development tools. Also, this query needed to run successfully in backend, via GUI transaction RSRT.

      For IMPORT connections, they needed to have the OData annotation @ODATA.PUBLISH:true (to generate an OData service) and the "API-state=released". More info here in Notes https://userapps.support.sap.com/sap/support/knowledge/en/2595552 and https://userapps.support.sap.com/sap/support/knowledge/en/2761862

      you can use the ‘View browser’ Fiori app to find these CDS views, by filtering by Released = YES and Category = Query. The ones that are consumable by SAC have a naming convention that starts with 2C*. (Whereas by default, an S/4 CDS view starts with C_*.)

      Going further, you can publish new custom queries in S/4 (based on existing queries) using the “Custom Analytical Queries” app in the SAP Fiori launchpad: https://help.sap.com/viewer/b4367b1cec3243c4989f0ff3d727c4ab/7.51.5/en-US/b8dd49e489f347c4b3ff88c4793fd27a.html

      Hope this helps.

      Regards, H

      Author's profile photo Amrita Goswami
      Amrita Goswami

      Thanks for the excellent blog I-Lin!

      Is there any way to use a Live Connection for GR data visualization in SAC ?

      I assume planning will not be possible in that case ?

       

      Regards,

      Amrita

      Author's profile photo Henry Banks
      Henry Banks

      Hi Amrita Goswami

      Sure, you can use SAC Live connectivity to connect to these S/4 CDS views.

      It can either be a Direct CORS connection or routed via the Cloud Connector using the “Tunnel” option.

      More info here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/d2a1edf7cda74315a2c5052de8a3a4eb.html

      Regards, H

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Cristina Talmaciu,

      If you do not use the delivered API APIs & Communication scenarios (SAP_COM_0370) noted in section 1 of this blog and simply retrieve data out of CDS views, you'll miss out crucial consolidation logics (IC elimination e.g) and just get a flat list of data records into SAC, which is no good for reporting or planning purpose.

      Regards,

      i-lin

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Amrita Goswami,

      This blog is mainly about planning, not reporting. And the best practice for planning is to use a physical model with meta data in SAC. This is when APIs & Communication scenarios (SAP_COM_0370)  comes into play.

      And of course live connection works for running reports in SAC.

      Regards,

      i-lin

      Author's profile photo Amrita Goswami
      Amrita Goswami

      Thank you for clarifying. The Freehand quiery is giving me an Invalid URI error although I am using it as described above and I have changed the filter values as per the setting in our system.

      I am able to see data in GR Analysis Fiori app using the same filters, but there is an error when using the freehand query-

      GRTransactionData(P_ConsolidationUnitHierId=’$’,P_ConsolidationPrftCtrHierId=’$’,P_ConsolidationSegmentHierId=’$’,P_KeyDate=datetime’2022-01-01T00:00:00′)/Results?$select=FiscalYearPeriod,ConsolidationUnit,PartnerConsolidationUnit,FinancialStatementItem,ProfitCenter, PartnerProfitCenter,SubItem,SubItemCategory, AmountInLocalCurrency, AmountInGroup ReportingoupCurrency &$filter=ConsolidationVersion eq ‘A0L’ and PeriodMode eq ‘PER’ and ConsolidationGroup Reportingoup eq ‘#’ and FiscalYear eq ‘2022’ and (FiscalPeriod ge ‘000’ and FiscalPeriod le ‘012’)

       

      Author's profile photo Hari Venkatesh Subramanian
      Hari Venkatesh Subramanian

      HI Amrita,

       

      Can you check this: "and ConsolidationGroup Reportingoup eq ‘#’ "? Also, with OP 22 we have an improved version of the API: API_CNSLDTNGRPJRNLITEM

       

      Regards,

      Hari

      Author's profile photo Bertrand Lefevre
      Bertrand Lefevre

      Hi I-lin,

      Thank you for your very useful blog post!

      Can you please tell if the exort functionality from SAC to Group Reporting (FINCS_PLNG_INTEG_SRV) can or cannot be added into an older on-prem S/4 version (SAP S/4HANA 2020 FP02) via a package or other?

      Thank you,

      Bertrand

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Bertrand,

      The export API FINCS_PLNG_INTEG_SRV works ONLY as of S/4 HANA CE 2208 / OP 2022 so you'll need to upgrade to this level to use it out of the box.

      Regards

      I-Lin

      Author's profile photo Veronika Muellerova Fransaer
      Veronika Muellerova Fransaer

      Hi I-Lin,

      Thank you for the great article. Very clear and useful!

      I have a question on the usage of S/4HANA custom fields in the context of integration with SAC. Are there any limitations when:

      • importing transactional and master data from ACDOCA and ACDOCU custom fields to SAC
      • exporting transactional data from SAC to ACDOCU custom fields
      • consuming live data in SAC Analytics on S/4HANA custom fields?

      Thank you for your response,

      Veronika

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Veronika,

      Right now the three cases you inquired above work except for exposing custom attributes of master data, which requires technical enhancements on the extensibility framework of S/4 HANA.

      Regards,

      i-lin

      Author's profile photo Haris Karabulut
      Haris Karabulut

      Excellent blog I-Lin! Thanks for sharing.

      I have a question regarding Importing plan data from SAC to S/4HANA. I would like to plan my production cost in SAC and then import them to S/4HANA.

      For this I would use the Plan Category for the Application Type "Product Cost Controlling" when importing. However, the system does not allow import with this application type, similarly I cannot enable the Import function in S/4HANA for this plan category.

      Do you know why this is not possible, because I would also like to import the price rates and there this application type is best suited. Is there any other solution?

      Many greetings

      Haris

      Author's profile photo Hartmut Koerner
      Hartmut Koerner

      Hi Haris,

      product cost rates from the IFP product cost planning cannot be written back into S/4HANA. The application type "product cost controlling" is used for production orders in S/4HANA that write into table ACDOCP.

      The only rates that you can write-back are the activity cost rates from cost center planning.

      Background is that the product cost planning in SAC shall not and cannot replace the cost estimate in S/4HANA. Instead, product cost planning in SAC shall be used for planning and simulation only.

      Best regards
      Hartmut

      Author's profile photo Syed Ali
      Syed Ali

      Hi I-Lin,

      Thank you for this excellent post. We have been trying to understand how to integrate planning in SAC with GR reporting for plan consolidation. Can you help us understand the below please.

      1. We want to use SAC for planning (both entity level & corporate planning). We want to perform plan_consolidation in S4H/GR on the same basis as actuals. There are different groups/organizations who handle actuals and planning and they typically run these processes in silos.
      2. Once actuals close, we can pull the data from GR to SAC to bring the opening balances etc as you highlighted. Then the planning users will adjust some assumptions for the future periods at individual entity level. Now there is a need to perform plan_consolidation to generate the revised corporate/group level financial statements. We can export the data to S4H/GR as you highlighted.
      3. We understand from your post that plan_consolidation will be performed in the same way as “actuals” which means that the planning teams will need to also upskill themselves on S4H/GR consolidation monitor / data monitor etc. Is this correct?
      4. Is there a way for SAC to automatically trigger/perform plan consolidation once a data action is triggered by planning user.

      Typically, the planning users come from FPA background and we want to make the user experience of “plan_consolidation” is seamless and automated for them. We want the planning users to simply adjust the assumptions in SAC and click a button that will not only export the data to S4H/GR but also perform plan_cosnolidation without any further intervention from the planning user. Is this possible with SAC?

       

      Regards,

      Syed

      Author's profile photo I-Lin Hsu
      I-Lin Hsu
      Blog Post Author

      Hi Syed,

      Specific to your questions 3) and 4), right now in the standard SAP solutions the full-blown consolidation functions run only in S/4 GR. To ease user handling the administrators can schedule jobs that'll run through the tasks in the monitors w/o user intervention. After that users can simply analyze the reports (in FIORI analytics, SAC stories, etc.) for plan v.s actual comparison.

      There're project solutions to script basic IC elimination and currency translation functions in SAC alone but these can cover only basic needs for management consolidation, not full-blown legal consolidations.

      Thanks and regards,

      i-lin