Balance-of-Payments Reporting in Belgium

The National Bank of Belgium requires that certain companies periodically submit balance-of-payments reports, which are used for compiling information on the gross national income and gross national product in Belgium. To extract the necessary data for a balance-of-payments report in your SAP system and to prepare the data for submission, you can use the Foreign Trade Declaration (RFIDITSR00) program. This program supports the extraction of data corresponding to the following surveys:

All services (F01DGS survey code)
Trading goods (F03MER survey code)
Commercial credits (S03CCR survey code)
Specific services (F03CMS survey code)
Triangular trades (F01MER survey code)

The Foreign Trade Declaration program allows you to generate an XML file for upload to the National Bank of Belgium’s official website. For more information about the exact reporting requirements, see the National Bank’s website.

To start the program, on the SAP Easy Access screen, choose Start of the navigation path Accounting Next navigation step Financial Accounting General Ledger Reporting Foreign Trade Regulations Foreign Trade Declaration (Generic) End of the navigation path . Alternatively, use the ITSR00 transaction.

Prerequisites

Make the necessary settings in the following Customizing activities:

Customizing Activity	Belgium-Specific Information
Define Reporting Categories	A reporting category corresponds to a Belgium-specific survey. Enter each survey code required for your balance-of-payments report as a reporting category.
Define Reporting Subcategories	A reporting subcategory corresponds to a Belgium-specific survey transaction. Enter each survey transaction code for your balance-of-payments report as the reporting subcategories.
Define Criteria for Selecting Data for Foreign Trade Declaration	Enter the G/L account intervals for the corresponding reporting categories and subcategories.
Assign Reporting Categories to DMEE Format Trees	The program uses a Data Medium Exchange Engine (DMEE) format tree to generate the XML file for your report. The DMEE tree delivered for Belgium balance-of-payment reporting is ITSR_BE_BOP_XML, ITSR tree type. Assign this tree to all of your reporting categories.

You find these activities in the Customizing for Financial Accounting under Start of the navigation path General Ledger Accounting Next navigation step Periodic Processing Report Foreign Trade Regulations Generic End of the navigation path . If you have not activated the new General Ledger, the path is as follows: General Ledger Accounting Business Transactions Closing Report Foreign Trade Regulations Generic

Alternatively, you can use the links in the system documentation (open the program and click on the i-button).

Activities

Selection Screen

Before you execute the program, enter the following values:

General Selection Criteria
Field Name	Value to Be Entered	Required for Following Declaration Type
Reporting Country	Enter `BE`.	all
Company Code	Enter the ID of the relevant company code.	all
Posting Date	Enter the required interval.	F01DGS, F03MER, F03TRP, F03CMS, F01MER
Country	Exclude `BE`.	all
Key Date	Enter the end date of the reporting period. The system uses this date to determine which postings are still open on this date and have to be included in the extraction.	S03CCR, F01MER Note: F01MER requires both posting date interval and a key date that is equal to the To posting date
Reporting Category	Enter the relevant code that you entered in Customizing	all

Additional Selection Criteria
Field Name	Value to Be Entered	Required for Following Declaration Type
Select G/L Accounts	Do not select this checkbox.	all
Select customers	Select this checkbox.	all
Select vendors	Select this checkbox.	all

File Creation
Field Name	Value to Be Entered	Required for Following Declaration Type
Create File	Select this checkbox so that the system generates an XML file for each required reporting category.	all
File name	Enter the name that you require.	all
File-Name Extension (Item)	Enter `XML`.	all
File-Name Extension (Item)	This field is optional. If you do not make any entries here, then the system saves the file on the default application server directory on your application server. You can then download the file from the application server using the Payment Medium International ‑ Load Data Medium Exchange File to Disk (RFASLDPC) program.	all

XML Fields
Field Name	Value to Be Entered	Required for Following Declaration Type
E-mail Address ‑ Receiver	Enter your e-mail address.	all