DRC - no data selected by "Switzerland VAT return (CH_VAT_DCL)"

[patrick_rohner]

Dear all,

We are trying to implement DRC (document reporting and compliance) in your S4HANA ON PREMISE (2022) system. From my point of view, we have completed the customizing (SPRO path Switzerland->Statutory Reportring->VAT Return->Setting up your statutory reporting), i.e. we have created a new reporting entity, assigned the report categories & org values etc. Additionally, we have completed the tax code mapping settings.

When starting the DRC dashboard, the report (Generate VAT return) is visible and can be started. The result/Document status for the selected period is "Generated Successfully". Anyhow, the XML has no content. I know that there is data in the selected period, because the standard VAT report (RFUMSV00) returns the expected document.

If I am not mistaken, one of the underlying CDS views is I_STRPTAXITEM which contains data as well.

We would like to know how we can debug the selection criteria to figure out the root cause for the missing data. Ideally, DRC would show more data other than just the company code and the date range... For whatever reason it must have excluded the relevant accounting documents. Ideally there is a report which can be used for analyses.

Any proposals?
Regards,
Patrick

[umasaral]

Hi 

Please check the below steps : debug missing data in the DRC (Document Reporting and Compliance) for VAT returns in S/4HANA:

1. Verify Configuration:
Check the DRC customization settings, especially for tax codes and reporting entity assignments.

2. Check Tax Code Mapping:
Ensure all tax codes are correctly mapped in your settings.

3. Access CDS Views:
Use transaction `SE11` to review the `I_STRPTAXITEM` CDS view and confirm the expected data is present.

4. Review DRC Logs:
Check transaction `SLG1` for application logs related to DRC. Look for any warnings or errors.

5. Inspect DRC Dashboard:
Ensure you are selecting the correct reporting period and entity when generating the VAT return.

6. Debugging Tools:
Use transaction `SE80` to navigate the DRCrelated programs. Set breakpoints to analyze data selection processes.

7. Compare with Standard Report:
Run the standard VAT report (RFUMSV00) and compare the output with what is expected in DRC.

8. Data Validation:
Create a custom report or use queries to crosscheck accounting documents from tables like BKPF and BSEG against DRC criteria.

9. Check for SAP Notes:
Search the SAP Support Launchpad for notes related to DRC issues for known fixes or patches.

10. Consult SAP Support:
If issues persist, reach out to SAP Support for further assistance.

Following these steps should help you identify the root cause of the missing data in your DRC reports.

[patrick_rohner]

Hi Umasaral,

[patrick_rohner]

1. Verify Configuration: Check the DRC customization settings, especially for tax codes and reporting entity assignments. Done already before - mentioned above 2. Check Tax Code Mapping: Ensure all tax codes are correctly mapped in your settings. Done already before - mentioned above - but does it not throw errors when a mapping is missing? 3. Access CDS Views: Use transaction `SE11` to review the `I_STRPTAXITEM` CDS view and confirm the expected data is present. Done already before - mentioned above 4. Review DRC Logs: Check transaction `SLG1` for application logs related to DRC. Look for any warnings or errors. I will have a look, but I expect to see errors in the dashboard. It would be strange if SAP would hide them elsewhere 5. Inspect DRC Dashboard: Ensure you are selecting the correct reporting period and entity when generating the VAT return. Done already before - mentioned above 6. Debugging Tools: Use transaction `SE80` to navigate the DRCrelated programs. Set breakpoints to analyze data selection processes. I don't know the programs.... if you can tell me the right ones, I will debug them. 7. Compare with Standard Report: Run the standard VAT report (RFUMSV00) and compare the output with what is expected in DRC. Done already before - mentioned above 8. Data Validation: Create a custom report or use queries to crosscheck accounting documents from tables like BKPF and BSEG against DRC criteria. Does not make sense, for this we can use RFUMSV00 9. Check for SAP Notes: Search the SAP Support Launchpad for notes related to DRC issues for known fixes or patches. Done already 10. Consult SAP Support: If issues persist, reach out to SAP Support for further assistance.