Skip to Content
Technical Articles
Author's profile photo shweta nargachhe

Advance compliance reporting with SAP S/4 HANA (ACR) – 1909 onPremise

This blog post is summary of first hand experience rolling out Advance compliance reporting (ACR) using FIORI application -F1515 Run Advanced Compliance Reports and detailed activities involved in setup . SAP replaced existing Tcode based legal reports in SAP S/4 HANA 1709 onward with reference to SAP note 2480067/2835863.Hence its now we should look for long term strategy to roll out ACR Reports.

Introduction

Advance compliance reporting (ACR) is centrally managed statutory reporting.

ACR with SAP S/4 HANA on premise 1909 version has pre- delivered legal reports for around 40 countries . We can monitor compliance report submissions globally withogfull audit traceability.

ACR supports legal compliance in reporting around the world like VAT, GST or any other country specific legal requirements .

ACR FIORI applications come with embedded analytics. Countries like UK/India allow direct integration and API interface with government portal.It has optional Flexible workflow approval and manual or automatic update of submission status. ACR Fiori application generates legal reports in diverse output format such as XML, PDF, TXT or XBLR to meet specific government regulations.

ACR activation comes with two types Basic and fully licensed. Basic feature activation will have certain limitations.

Pre Delivered ACR reports

  • List of pre delivered advance compliance reports available at below link

https://help.sap.com/viewer/3cc1da1e1e364fadb9b1af653a9597d2/1909.002/en-US/4975ec570b01f032e10000000a441470.html

  • Chose your SAP S/4 HANA version

  • Select country /region from list – Example United Kingdom

  • Home page for country specific report gives features available into ACR reports for selected country . And individual section provide how to configure report parameters . Link

 

ACR compliance reporting framework  and configuration steps and pre requisite

 

Area   Activity Details
All Keep system in sync for new compliance patches and notes

 SAP Launchpad access to legal announcement feature tile . Setting up email notifications on new announcement of legal change

2382863 – How to use the Announcement of Legal Changes application – SAP ONE Support Launchpad

2381572 – Stay tuned! Do not miss a legal change announcement [VIDEO]

FIORI

Activate FIORI application – F2131-Define Advanced Compliance Reports

 

*Refer FIORI Library for activations and service details

Define advance compliance report application

–          Reporting Definition

  • Parameter – Filter parameters
  • Queries – Provide data source information flow
  • Document – Define document format and mapping of header and item data flow between queries and document variables to generate output.
  • License version of ACR allow define custom classical report integration .

–          Reporting activity define steps or activities for given report definition . This can be give different steps require for specific ACR report submission .

–          Report Category

Report definition in particular gives insight of underlying CDS views,  class (in newer version) , queries , BRF functions / Class for given report. This information can be used further debugging and getting data source and underlying schema and logic.

DemoLink

FIORI Activate FIOR application – F1515-Run Advanced Compliance Reports Run Compliance report

  • Support for multiple compliance report format based on report definition specified in Define compliance report
  •  Allows to monitor submission due date at global level . Details below on SPRO config section .
  • Perform analysis of tax item into report scope using embedded analytics report to get insight of tax items
  •  Schemas used are directly from government which allows static verification of content before actual submission in error section
  • Reporting activities like consolidation and verification . Exception analysis and post tax submission activities like post tax payable manual adjustments .
  • Electronic or manual submission and setting up status as complete . Allow attachments of receipt from government for further reference .
  • Optional workflow before actual submission .
  •  Edit report before submission and Audit trace of changes done to generated report. Download / View analytics option
  • To delete old report and clean up old frequency setup use report SRF_RPG_ENTITY_CLEANER

DemoLink

FIORI

Activate FIOR application – F1597 Post tax payable

And F0717- Manage Journal Entries

You use this app to pay tax amounts by posting the balances of input and output tax accounts to a tax payable account

Make manual adjustments to tax accounts directly.

FIORI F3172-Manage Tax Items for Legal Reporting

The Manage Tax Items reporting activity allows a G/L accountant to move a tax item between reporting periods by changing the tax reporting date. It allows the G/L accountant to include or exclude one or more documents from a specific tax reporting period by changing the tax reporting date . The system retrieves the documents based on the parameters from the reporting task of advanced compliance reporting, or based on the filter values provided in the Manage Tax Items activity screen.

The selection of the tax items is based on the tax reporting date field. Refer to SAP note 1038448. However, if the tax reporting date is not available, the system considers the posting date or the document date. However, the actual tax item selection depends on the country and the functionality.

To use full functionality of this application Inclusion and Exclusion Activate tax reporting date for specific entity into OBY6

SPRO – Backend functional config.

Basic SPRO configurations

 

Make the required settings in Customizing for Financial Accounting under Advanced Compliance Reporting  Setting Up Your Compliance Reporting. Refer SAP documentation link and setup steps for individual report ID configuration and reporting activity.

 Default parameter values can be set into SPRO . These parameters can be changed and regenerate new report   in ACR run compliance report .

Submission of report and set ADhoc or Fixed Frequency – Monthly / Daily / Yearly etc. Ensure you add Fiscal year variant while setting up fixed frequency .

Entity specific parameters can be added manually

Submission due date can be set as fixed values example 25 day of next month or it can be derived from Tax calendar

SPRO – Backend functional config. Other Supporting configuration and tax box structure

Based on SAP document setup tax box structure if applicable

SPRO -> Financial Accounting (New) -> Advanced Compliance Reporting  Sales/Purchase Tax Returns -> Define Tax Box Structure, you define the Tax Box Structure

Basis Activate require pre requisite business functions

Consult your basis consultant for below configurations

Business function activation

Transaction -> SWF5 -> FIN_LOC_SRF

Activate license analytics refer to SAP Note : 2879813

Basis BgRFC / Inbound destination

Background RFC

SBGRFCCONF ->Define in bound dest. -> SRF_REPROT_RUN

Basis PDF generation Adobe Acrobat Reader to download and view the PDFs. Check FP_TEST_00 test PFD output generated successfully .
Basis Contentserver service activation

 Ensure content server service is active and technical user setup is complete to process documents request

 

SICF -> service name = contentserver set with technical user

Basis

DMS – Default SAP / Attachment services

 

DMS configuration and manage documentation setup based on SAP note 2868459

OAC0 -> DMS_C1 (Based on DMS config) -> Details ensure HTTPS on frontend is set to HTTPS require for frontend and backend.

Enable PC server configuration

Cross application component -> Document management -> General data-> Define data carrier -> Define Data carrier type “server ,frontend” -> Type = PC .-> Identify frontend computer set PC as default

Authorization  

 Refer to SAP STD catalogues given in FIORI library Link

** = Country code

SAP_BR_GL_ACCOUNTANT_**

SAP_BR_AP_ACCOUNTANT_**

SAP_BR_AP_MANAGER_**

In case we further want to divide create custom tile config with reference above and add or remove  REpCatID from tile configurations . Ensure F
_SRF_RNTM activities assigned to user to create change delete ,process , submit  report

 

In Summary rolling out Advance compliance report require sync between business and finance  functional consultant . Advance compliance report in FIORI is easy to use with dashboards and due to date reminder. 

Blog post provide details of ACR functionality for all SAP Finance / Basis consultants who support applications of the legal reports for the customer’s business to remain compliant.

Assigned Tags

      38 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sridhar Rao Bolisetti
      Sridhar Rao Bolisetti

      Hi Shweta,

       

      Thanks for the detailed information.  I could configure accordingly.  But when I execute the report, it's showing error "No items to be reported found. Query ACCT_SRF_REP_ITM doesn't return data."

       

      However, manage tax line items App is showing lines to be reported and I didn't exclude any.

       

      We are in 1909 (SAPK-10402INS4CORE).

       

      Can you help to provide a direction to resolve this.  It would be helpful.

       

      Rao

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Rao,

      All items which are relevant for tax reports will be visible in  manage tax flori app.

      Manage tax item is common application to view tax items. Items that shows in manage tax items does not signify  that it will be considered into specific tax reporting id.

      You need to complete require prerequisite setup of tax box structure. And filter parameters setup correctly. Please specify  report name/reporting id configured. 

      Regards,

      Shweta

      Author's profile photo Sridhar Rao Bolisetti
      Sridhar Rao Bolisetti

      Hi Shweta,

       

      Thanks for reply.  Report category ID is TH_VAT_PP36.

       

      I will also check the concept behind tax box structure as I am not aware on this.

       

      Sridhar

      Author's profile photo v s
      v s

      Hi Shweta,

      Is it licensed Product?

      Regards,

      Vinay

       

       

       

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Vinay,

      For S4hana 1809 version onwards on premises it can be activated as out of box function with above limited functions. As multiple single GUI local reports went out of support ACR reports need to be activated.

      ACR cloud version is licensed products. If any confirmation require raise OSS for component FI-LOC-SRF-RUN to understand licensing pre-requisite

       

      Regards,

      Shweta

      Author's profile photo Sanjay Kumar
      Sanjay Kumar

      Hi Shweta

      thanks for info - do you functional blue print which can be shared? I am more interested from tax side and it’s document compliance.

      regards Sanjay

      sanjay.sota@gmail.com

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Sanjay,

      Every country tax box structure and related best practices defined example sap note 2728767 UK vat report. It all depends on local reporting requirements

      Regards,

      Shweta

      Author's profile photo Sanjay Kumar
      Sanjay Kumar

      Thanks Shweta - I do have this note - but i wanted to have process flow document from ACR prospective - how the transactions flows whether be AP or AR side...

      Author's profile photo RAHUL SURI
      RAHUL SURI

      HI Sweta,

      Kindly share any experience on the configuration to be done for content repository and content category. I am working on ACR for US, file generation is failing on account of content category BUS2032 not known, In OACT it is not there and not provided by SAP too. Kndly advise on how to set up the missing content category in KM.

      Regards

      Rahul Suri

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Rahul,

      1. Please provide exact error from Fiori screen.Please refer to DMS attachment services section in blog.

      2.S/4 we can use DMS_C1-ST sap default content repository.

      Goto OAC0 select DMS_C1

      Give %https in box where you type transaction code

      Please ensure https on front end and https on backend it set explicitly https on this repository on DMS_C1

       

      3. Refer to  sap note 2868459

      4. Refer to sap note define data carrier type 2557617 for network default error

       

      5. Spro - cross application components- document management  -control  data

      Document type SRF

      Object  SRF_REPRUN

      DYNPRO 201 IS SET

       

      Regards,

      Shweta

      Author's profile photo RAHUL SURI
      RAHUL SURI

      Hi Sweta,

      Thanks for your response, which was in line with what sap also replied on the incidents.

      we are now facing issues as below:

      1. the functionality of corrrespondence form generation for the BP is not showing any output post the file generation, the error is as below:

      refer the image

      Also we are seeing the transactional data in WITH_ITEM is not reconciling with ACR data.

      any suggestions on that.

      Regards

      Author's profile photo Rodrigo Garrilha
      Rodrigo Garrilha

      Hi there.

      My client will use the ACR in the future and we are doing some tests in the application, but so far there is differencies in both systems that we are using.

      I am working on S4/HANA 1909 on Fiori Launchpad.

      In the DEV system i get the following display, where when i try to open the PDF it opens a new page with diverse information and when i click in the graphic icon (right side of the image) i go to a new page with tables and information (i think) about the client.

      Now in the Quality and Production System the display is different and so far i couldn't find out why.

      The display is the following:

      When i open the PDF, the browser opens a new page with a form (it's not what happens in the DEV) and there is no action (the graphic icon).

      The name of the action missing is "Analyze Data - Design Studio".

      What am i missing here?

       

      Thank you very much,

      Rodrigo

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Rodrigo,

      Kindly share which reporting id which you are trying to configure and network tab + console tab snapshot with developer tools .When there is no data return via query PDF is generated with unmapped values . Refer to Define compliance report to check mappings and query details for specific reporting category and ID.

      Analyze Data options is not appearing into your report possibly due to below .

      1. Check your report definition and require configurations are moved and it is in sync with development and other environment .
      2. Your analytic application running independently into quality system without error . Simple test scenario is take link from system where it is working and replace quality system host and port details. In most of definitions query paramter XQUERY = 2CC*** is already mention . Check same parameter and query data into backend system with RSRT.
      3. Refer blog in case you face issue with design studio application https://blogs.sap.com/2017/03/17/s4-hana-embedded-analytics-design-studio-template-vs-webdynpro-grid-visualization-of-analytical-queries/

       

      Regards,

      Shweta

      Author's profile photo Rodrigo Garrilha
      Rodrigo Garrilha

      Thank you for your reply.​

      After some digging I found out what the problem was and i will leave the answer here just in case someone ever runs in the same problem.

      The Business Function was not activated in the Quality system thus the problem of the missing actions and the different display of the PDF.

       

      Once again thank you,

      Rodrigo

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Good to hear switch transport helped you .Please be careful when you transport as it will brings out all switches  from your system automatically to next environment.

      Author's profile photo Tanjin Samira
      Tanjin Samira

      Hi Sweta,

       

      thanks for the article. It really helps a lot.

       

      If i understand correctly, the country specific reports are include in standard SAP S/4 Hana package & does not  require any extra cost. Please correct me if my understanding is wrong. additionally i have the questions below -

      1.If i need to have additional country specific report which are not in the list does it comes under extension?

      2. Does the standard reporting are completely compliant to the legal reporting requirement?

       

      Thanks in advance.

       

      Thanks,

      Priya

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Country specific reports are included from 1709 onwards .

      You can refer link below to identify complaince reports which are out of box for your version.

      https://help.sap.com/viewer/3cc1da1e1e364fadb9b1af653a9597d2/1909.002/en-US/4975ec570b01f032e10000000a441470.html

      1. ACR Cloud version has more out of box functionality rolled out. Extensions are only allowed based on SAP license agreements. Please raise OSS to understand restrictions if your system is on premise. Note extendeding applications in ACR reports require good Knowledge of framework.

      2. If complaince report is already included into for your SAP S4Hana version then it is in complaint with legal reporting based on countries government complaince requirements.Sap support queries in case you see GAP with countries requirements and sap ACR report

       

      Regards,

      Shweta

      Author's profile photo Mukesh Shukla
      Mukesh Shukla

      Hi Shweta,

      What are the logical timeline and resource requirement to implement this tool. I need to use this tool for UK, Italy, Spain, France, Germany, Austria, Portugal on 1809 (FPS02).

      Thanks,

      Mukesh

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Mukesh,

      For simple first country roll out will take 6-8 weeks.  Assuming your system is already on latest patch level, no workflow and direct connection to tax authorities involved.

      You need functional expertise with tax reporting requirements understanding  and fiori/abap expertise in team.

      After first basic setup next country rolling should not take more than 3-4 weeks deployment . Enabling takes 1 week however more efforts require on testing of reports.

       

      Regards,

      Shweta

      Author's profile photo Mukesh Shukla
      Mukesh Shukla

      Thanks Shweta.

      Can you please share if any documentation you may have, training / configuration / testing / UAT documentation on shuklamukesh @ yahoo . co . in

      Thanks,

      Mukesh

      Author's profile photo Sanjay Kumar
      Sanjay Kumar

      Hi Shewta

       

      Do you know if there can be any connection can be made between ACR and SAP Analytic Cloud and it should be real time.

      Author's profile photo Andrzej Wieciech
      Andrzej Wieciech

      Hi Shweta,

      Using free license and VAT Return report for UK, is it possible to display line items (financial documents + tax code + VAT amount details etc) similar to ECC rfumsv00 report?

      Author's profile photo Patrick Wu
      Patrick Wu

      Hi Shweta,

      I am the fresh consultant in ACR,i have a question,

      If the adobe PDF service is must need in ACR ??

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Patrik ,

      In your project of scope is to generate out of box compliance reports as TXT or CSV then you can skip pdf configurations.

      You can go to define compliance reports fiori application and verify output type attached in configurations for particular report.

      Only In scenario of pdf output file generation will fail rest all scenarios should work as expected.

      Regards,

      Shweta

      Author's profile photo Patrick Wu
      Patrick Wu

      Dear Shewta,

      Thanks for your kindly reply.

      and how  to configuration the adobe PDF service??Because the BG country need PDF format report for submit.

       

       

       

      Author's profile photo Sanjay Kumar
      Sanjay Kumar

      Hi Patrick

      Check this

      Check the newest printable version of this Configuration Guide in the SAP Service Marketplace, available at  http://www.sdn.sap.com/irj/sdn/adobe  Installation & Configuration  SAP Interactive Forms  –  Configuration Guides  Configuration Guide for SAP Interactive Forms by Adobe

      Regards

       

       

      Author's profile photo Ryan Yang
      Ryan Yang

      Dear Shewta,

      How to configurate the report to use the XML or PDF  format? i only see the XML ,my ADS is ready.

      Author's profile photo Bernard Chen
      Bernard Chen

      HI Shewta,,

      When i click open pdf files, error  ,An error occurred while retrieving tokens and URL.

      How to deal it??

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Bernard,

      Based on given screenahot it shows that file generated and stored correctly. However reading it back as stream function causing issue.

      May able to try below or share developer network tab http response to under more details.

      I see you are generating romania GL trial balance .

      1. If you have abap debug skill  Set breakpoint at class CL_SRF_Reporting_task_dpc_ext => method get_stream_document line 33.

      Check at line 103 retrieve attach content  or continue debug till you identify error.Make sure browser pop up enabled and automatic download as it start new window to show content stream as response.

      2.If you go down on same screen scroll down where error there is log section to see any issues on pdf generation. Or try manual upload in attachment  section and retietrive pdf there may point you to error.

      Regards,

      Shweta

      Author's profile photo Aleksandr karpov
      Aleksandr karpov

      Hi Shweta.

      Could you explain how to debug ACR reports generation?

      In some cases some reports doesn't generates but there are no dumps and no error in /IWFND/ERROR_LOG

      Author's profile photo Jonathan Walters
      Jonathan Walters

      Shweta or other knowledgeable user,

      I am trying to connect a custom content repository ("AM") that our Basis team created in t-code OAC0 to Advanced Compliance Reporting - in other words, when the documents (PDS, data files) are created in the app Run Compliance Reporting, these documents should be stored in content repository AM.

      I believe that we need to assign the content repository AM to a category (i.e. storage category?) in t-code OACT, but I am not sure if there is a specific category that I should use.

      What is the specific, pre-defined storage category for ACR?

      If there is not one, how do I map a storage category to ACR?

      Thanks for your help

      Jonathan

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Hi Jonathan,

      Complaince reports run usage mainly exists setups for attachments services.
      Transaction Sicf->contentserver .

      This refers default activated content storage repository in Document management.

      Document management->additional settings->attachment services storage repository activation you set active content storage you want to use in content services. You try to change here default activation point to 'AM'. Make sure services

      Document type : SRF
      Object table Table : SRF_REPRU
      Content repository:DMS_C1 default any any ensure https enabled for content repository

      Regards,

      Shweta

      Author's profile photo Jonathan Walters
      Jonathan Walters

      Shweta,

      Thanks for the response.  I have a couple more questions...sorry 🙂

      In t-code OACT, I have content repository "AM" linked to Category "DMS_C1".  What should the Document Area be?  Should it be blank?

      In Document Management, Additional Settings - Simplification, Attachment Services - Storage Repository Activation, the only two fields on this screen are Storage Category and Activation Indicator.  if I understand correctly, I should add storage category "DMS_C1" as active, correct?  See below.

      Doc%20Mgmt%2C%20Add%20Settings%20-%20Simplification%2C%20Attachment%20Services%20-%20Storage%20Repository%20Activation%20screen

       

      My last question...You mentioned to "make sure services"

      Document type : SRF
      Object table Table : SRF_REPRU
      Content repository:DMS_C1 default any any ensure https enabled for content repository

      In what t-code or SPRO path do you find this?  I am pretty sure I have seen this screen before, but I cannot find it now.

      Again, thank you for your help.  I am trying to get this set up and I am struggling with it for some reason.

      Author's profile photo shweta nargachhe
      shweta nargachhe
      Blog Post Author

      Please find answers inline

       

      1. Document area is DMS Document management system

      2. DMS_C1 is sap default storage category you need to add based on your request. This can default point to external content server as well which can be used in configuration. Note DMS_C1 uses hana database for file storage.

      3. Spro-》cross application components-》document management-》additional settings _simplification-》attachment services _storage repository activation  To find path for configuration

       

      Regards

      Shweta

       

      Author's profile photo Michael Heine
      Michael Heine

      Hello,

       

      since our last upgrade to S4HANA 2021, the download for VAT return no longer works.

      Before the upgrade a file was downloaded.

      After the upgrade, the file is only displayed in an additional tab.

      Does anyone have an idea what the cause could be?

      Thanks for your help

      Michael

      Author's profile photo Alex Huaraca Apaza
      Alex Huaraca Apaza

      Hi Shweta,

      In the SAP S/4HANA 1809 version for Advanced Compliance Reporting Mexico, I have an error downloading the generated file.

      Thanks for your help

      Alex

      Author's profile photo Jorge Luis Gutiérrez Juárez
      Jorge Luis Gutiérrez Juárez

      Hi Alex,

      I see that you have already progressed in the implementation of the ACR reports for Mexico.

      Can you help me with the following question?

      Is it necessary to implement both apps Run and Define compliance reports in Fiori?

      If I want to get only the standard legal reports defined for Mexico, DIOT, E-Accounting, etc, Is an additional license needed?

      Best Regards,

      Author's profile photo isa bal
      isa bal

      Hi Shweta,

      I could run this report but when ı click any row , it doesnt redirect next page and I couldnt display detail of the row. what should I do in this situation?

      thanks a lot.