SAP ABAP, NW ABAP Gateway (OData)

Generate Custom Supplier Certificates via Generic Withholding Tax in SAP Document and Reporting Compliance(formerly known as Advanced Compliance Reporting – ACR)

Generic withholding tax reporting helps you configure based on your country/region-specific or company-specific requirements.

The report identifies withholding tax-relevant transactions for the reporting period and generates an ALV output that lists these transactions and groups them based on organizational unit, business partner, tax type, and tax code.

This report can be used to report only extended withholding tax documents or line items. However, withholding tax certificate cannot be generated with the standard solution.

In this blog post, I will cover a simple way to extend the generic withholding tax report (GENC_WHT) and add new correspondence section to generate withholding tax certificate.

1. Go to Tcode SEGW and create SAP Gateway Service. For this example, we will refer Mexico Gateway Service. Gateway service FDP_FIWTMX_CERT (which is available from SAP S/4HANA 1809 OP Onwards).

Figure 1: Mexico Gateway Service

2. Expand the SAP Gateway Service and go through the Data Model, Associations, Entity Sets and Association Sets. In Entity Type – Query Node will be used for passing filter from DRC(Formerly known as ACR ). In case of Mexico we will generate the certificate for every Unique Supplier, company code, language and Withholding tax Income Type

Figure 2: Query Node – to be exposed in Document and Reporting Compliance

3. Navigate to Runtime Artifacts and Use class CL_FDP_FIWTMX_CERT_DPC_EXT to populate data in the certificate

Figure 3: SAP Gateway Artifacts

4. Implement the method MXWHTHEADERSET_GET_ENTITY to populate data in the certificate

Figure 4: Sample Data provider Implementation

5. Note the Service name and maintain it in the Adobe Form.

Figure 5: SAP Gateway Service – to be consumed in Adobe Forms

6. Go to Tcode SFP, enter the form name as FIWTMX_CERT to refer already developed Mexico Certificate.

Figure 6: Form Builder

7. The Form should be of type XFA2, maintain the SAP Gateway Service Name FDP_FIWTMX_CERT_SRV.

Figure 7: Mexico Adobe Form for reference

8. Go to Utilities and download the form layout. The layout should be downloaded with XDP extensions.

Figure 8: Download Form layout

9. Extend the generic withholding tax reporting (GENC_WHT_V0)

Figure 9: Extend Generic Withholding Tax Reporting

10. Create a New document in the correspondence section in your report definition and provide the following details.

i. Correspondence ID – ZCORSP
ii. Form Template – FIWTMX_CERT
iv. Correspondence Name – Mexico Supplier Certificate
v. Output Type – ACCT_WHT(Specifically created for Withholding tax certificate)

Figure 10: Correspondence Section

11. Click on the correspondence line and map the query columns. This unique combination will decide on number of output forms in the correspondence section.

Figure 11: Map Query columns to be passed to SAP Gateway Service

12. Download XSD as shown below(The report should be open in Edit Mode)

Figure 12: Download Schema

13. After downloading the XSD, open Adobe LiveCycle Designer. Open the earlier downloaded layout for Form and perform mapping

Figure 13: Adobe Form Layout in Adobe LiveCycle Designer

14. Right click on the data connection and add New data connection, choose XML schema and upload the XSD(which was downloaded from Extended Report Definition).

Figure 14: Import Schema
Figure 15: Map fields from the Imported Schema

15. Perform the mapping and upload the layout in Tcode SFP and activate the Form.

Figure 16: Upload the Form and Activate

16. Go to SPRO and navigate to path below, click on New Entry and maintain the custom form details: Cross-Application Components > Output Control > Assign Form Templates

Figure 17: Maintain Custom Form Details

17. Extend generic reporting category and maintain the extended report definition in the activity section.

Figure 18: Extended Generic Withholding Tax Report Category

18. Go to Run Compliance section and enter the report name

Figure 19: Run Compliance Report

19. Choose the extended reporting activity and execute the report

Figure 20: Execute the Extended Activity

20. You can view the correspondence form in the business partner Reporting Section

Figure 21: Partner Correspondence

21. Once you click on the display Icon, it will trigger the class CL_FDP_FIWTMX_CERT_DPC_EXT and the form will be populated

Figure 22: Generated Partner Certificate


Figure 23: Summary