Technical Articles
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
- 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
– 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. |
FIORI | Activate FIOR application – F1515-Run Advanced Compliance Reports | Run Compliance report
|
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 |
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.
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
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
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
Hi Shweta,
Is it licensed Product?
Regards,
Vinay
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
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
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
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...
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
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
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:
refer the image
Also we are seeing the transactional data in WITH_ITEM is not reconciling with ACR data.
any suggestions on that.
Regards
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
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 .
Regards,
Shweta
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
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.
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
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
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
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
Thanks Shweta.
Can you please share if any documentation you may have, training / configuration / testing / UAT documentation on shuklamukesh @ yahoo . co . in
Thanks,
Mukesh
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.
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?
Hi Shweta,
I am the fresh consultant in ACR,i have a question,
If the adobe PDF service is must need in ACR ??
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
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.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
Dear Shewta,
How to configurate the report to use the XML or PDF format? i only see the XML ,my ADS is ready.
HI Shewta,,
When i click open pdf files, error ,An error occurred while retrieving tokens and URL.
How to deal it??
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
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
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
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
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.
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.
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
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
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
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,
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.