Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
singhpras3
Product and Topic Expert
Product and Topic Expert
1,709

The purpose of withholding tax is to ensure that the government receives tax revenue in a timely manner and to facilitate tax compliance. It is commonly applied to various types of income such as wages, salaries, interest, dividends, royalties, and payments to contractors or freelancers. The rates of withholding tax and the types of income subject to withholding tax vary depending on the tax laws of each jurisdiction.

While SAP provides standard reports for reporting withholding tax, custom requirements may arise for specific needs. This blog focuses on the development of a custom certificate to address such requirements. Developing a custom certificate requires knowledge in DRC extensibility and Adobe Form development.

In this scenario, a custom Adobe form is being created within the system, extending the Thailand 50 BIS certificate.

Go to t-code SFP to create the Adobe Form. The form can be developed using the default interface SOMU_DEFAULT_INTERFACE, with XFA2 chosen as the layout technology.

Picture29.png

Once the form layout is created, save and activate it.
Then, navigate to Define Compliance Application and initiate the creation of a new report definition. For this example, an existing report definition is duplicated. Provide a name for the new report definition and specify a package for its storage.

Create custom report definitionCreate custom report definition

 

Save it in local packageSave it in local package

After creating a new report definition, Add a new document according to the specified requirements. In this instance, a PDF document is presented as an example.

Add new legal documentAdd new legal document

 

Create it as a PDFCreate it as a PDF

Provide details for the document such as the document name, file name, code page, etc.

Document DetailsDocument Details

Select a schema for this document, which defines the format and structure of the document. Various options for creating a schema are available, including using XSD, JSON, or ABAP dictionary. For this particular example, the schema is generated using the ABAP dictionary. Alternatively, an existing schema can also be utilized.

Create SchemaCreate Schema

 

Enter the Custom Form DetailsEnter the Custom Form Details

After finalizing the schema, proceed to the Mapping section. The structure of the document, based on the schema, will be displayed, allowing for mapping according to the requirements. Data can be mapped from various sources such as CDS, tables, class methods, or system fields.

Perform MappingPerform Mapping

Save and Activate the report definition.

Save and ActivateSave and Activate

Now the schema needs to be downloaded in order to perform mapping in the Adobe form. Select the "Export Schema" option and then choose "Export as Simplified XSD". Ensure that the report definition is in editable mode before attempting to download the schema.

Download XSD as shownDownload XSD as shown

The layout for the Adobe form can be created using the Adobe LiveCycle Designer (ALD). Develop a custom layout, and if there's a requirement for a fixed company logo, watermark, or signature, it can be directly incorporated. For dynamic company logo, watermark, or signature needs, include an image field in the Adobe Form. The value of this field can be manipulated during form generation

Create Custom LayoutCreate Custom Layout

In this example, an already developed Thailand 50 BIS form has been downloaded. It contains existing bindings. To remove these bindings, navigate to the data view, right-click, and select "Delete Data Connection". During deletion, you have the option to retain or delete the existing bindings. In this instance, the existing bindings are kept intact while mapping new fields in the form.

Delete Data ConnectionDelete Data Connection

 

Do not remove existing bindingDo not remove existing binding

To establish a new data connection, right-click in the Data View and select "New Data Connection". Upload the previously downloaded schema from the steps above and utilize it for mapping the new fields.

Create New Data ConnectionCreate New Data Connection

 

Choose XML schemaChoose XML schema

 

Upload the earlier downloaded schemaUpload the earlier downloaded schema

Next, proceed with the new mapping process as demonstrated below. The newly added fields from the schema will be displayed, allowing them to be mapped within the form layout.

Perform MappingPerform Mapping

After completing the layout, upload it in transaction code SFP. Change the existing custom form and select "Upload Layout". This action will replace the existing layout with the new one.
Save and Activate the Form.

Now create a new report category , for this example exisiting report category is copied . Enter the Report category name and save it designated package .

Create New Report categoryCreate New Report category

Maintain the report activity details by assigning the already developed report definition to this report category. Enter additional information such as description, phase, submission mode, valid form, and validity period.

Add new activityAdd new activity

Save and Activate the report category

Activity detailsActivity details

 

The Custom legal certificate generation involves several steps related to working with Adobe Forms and Report Definitions:

  1. Develop Custom Adobe Form: Design and create a personalized Adobe form tailored to specific needs or requirements.

  2. Create a New Report Definition: Create a new definition for a report, outlining its structure, content, and parameters.

  3. Create Schema for the Document: Develop a schema outlining the structure and format of the document to ensure consistency and compatibility.

  4. Download the Schema: Retrieve the schema for integration purposes.

  5. Perform Mapping In Form: Map data fields or elements within the Adobe form to corresponding elements in the schema or report definition.

  6. Create a New Report Category: Create a new category to classify or organize reports based on specific criteria or characteristics.

  7. Assign Report Definition to the Report Category: Link  the newly created report definition with the designated report category for generation of custom output.

Overall, these steps involve the creation, customization, and organization of Adobe forms and report definitions to effectively manage data and generate custom report within DRC framework.

Summary:

SummarySummary

Thank you for reading!

Drop a like or comment below if you found the above steps useful and do let me know in the comments section if you are looking for any other specific use case of US report extensibility.

3 Comments