Technical Articles
Business Place Specific Withholding Tax Reporting – Philippines Advance Compliance Reporting
The advance compliance reporting scope item (1J2) offers extensive platform for getting the country wise compliance report to fulfil the countries legal requirement. However, in certain cases the report needs to be tweaked to match the legal entity’s structure. In this blog, we are going to take one such example and explore the basic features with which the compliance reports can be built or modified in S4 Hana Cloud.
In case of Philippines, the following are the reports for Withholding Tax submissions provided by SAP for Advanced Compliance Reporting:
Report ID | Report Name | Periodicity |
PH_WHT_0619E | Philippines Expanded Withholding Tax Reporting | Monthly |
PH_WHT_0619F | Philippines Final Withholding Tax Reporting – 0619F | Monthly |
PH_WHT_1601EQ | Expanded Withholding Tax Quarterly Report | Quarterly |
PH_WHT_1601FQ | Final Withholding Tax Quarterly Report | Quarterly |
PH_WHT_BIR2307 | Certificate of Creditable Withholding Tax Report | Quarterly |
The standard report is designed to run and provide the information at a company code level. However, in Philippines there may be a need to submit the reports at each individual business place level (One company code may have multiple business places underneath).
Let us see how we can create a business place specific reporting for PH. We can use PH_WHT_0619F (Philippines Final Withholding Tax Reporting) as a base in this illustration.
The process involves the following steps:
- Define Advance Compliance Report at Business Place level
- Setting up reporting category
- Assign report category to reporting entities
1. Define Advance Compliance Report
The APP Define Compliance Reports can be used to create new compliance reports or modify existing ones.
We can copy the existing Report PH_WHT_0619F as YY1_PH_WHT_0619F_BP and modify the same to cater to our requirements.
a. Add Parameters to include Business Place as one of the selection parameters in the report run:
Parameter Name: BUSINESSPLACE
Data Element: J_1BBRANC_
Search Help: J_1ABRNCH
Exporting Search Help Parameter: BRANCH
Multiple Selection: No (Based on the requirement)
Optional: No (Based on the requirement)
Hidden: No
Read Only: No
Parameter Definition
b. Business Place needs to be included as one of the queries and a filter needs to set on the query for documents being selected based on the business place.
Query for Business Place
Filter for Business Place Query
Data Source Type: Database Tables/Views
Data Source Name: J_1BBRANCH
Filter Condition (Include):
[Company Code] Report Parameter = COMPANYCODE
[Business Place] Report Parameter = BUSINESSPLACE (Defined in Step a)
Also, the business place needs to be added as a filter parameter for document selection query (DOC_SEL).
Query for Document Selection
Business Place Filter for Document Selection Query
Filter Condition (Include):
[Business Place] Report Parameter = BUSINESSPLACE (Defined in Step1)
c. Document Definition should be performed if the data in the output should be modified. Let’s say it should display the BP Tax Number instead of Company Code tax number.
Document Definition
Field Mapping Change
In the above Illustration, the TIN of PAYER is mapped to Business Place-STCD1 field instead of Company Code TIN Number. The field STCD1 has its data maintained under customizing SSCUI- 103390 (Define Business Places).
2. Setting up reporting category
The standard report category PH_WHT_0619F can be copied as YY1_PH_WHT_0619F_BP and modify the same to include the new report definition.
Report Category
3. Assign report category to reporting entity
This is the final step where the report category created in the previous step will be assigned to the reporting entity at which the compliance report needs to be run.
This is done in customizing under the SSCUI- 101071 (Setting Up Your Compliance Reporting)
Choose the reporting entity and then click on “Assign Report Categories to Reporting Entity”. Add the report category to the list.
Assign Report Category to Reporting Entity
Then, choose the report category and navigate to subsequent tasks to set the periodicity, properties, and any default parameters for the report.
Compliance Report Run
With the above-mentioned steps being completed, there should be a task in the Run Compliance Reports APP for the newly created report.
This should have Business Place as one of the parameters apart from Company Code and Posting Date, based on which the document will be selected as part of the run.
Reporting Task
Business Place Parameter for Report Run
With this we come to the end of this blog. Hope this has given a basic outline of the Creation/Modification of Advance Compliance Reports. Feedbacks or alternate approach to the same are most welcome. Thanks.