Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
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:

  1. Define Advance Compliance Report at Business Place level

  2. Setting up reporting category

  3. 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:

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.
Labels in this area