Balance-of-Payments Reporting

Use

In Belgium, you may be required, if selected, to report balance of payments (BOP) directly to the National Bank of Belgium. This invoice-based reporting, which includes foreign sales and purchases, is used to collect information on the gross national income and gross national product.

To prepare the balance of payments, you run the Foreign Trade Declaration report (RFIDITSR00). It generates a DME file in CSV format, fulfilling Belgian reporting requirements.

Integration

Report RFIDITSR00 replaces the former Belgian reports RFDBLIWO, RFKBLIWO, and RFSBLIWO.

Prerequisites

Make Customizing settings as described in the report documentation, and note the following details for Belgium:

●     Define Reporting Categories

Enter the reporting categories required in the BOP file, as defined by the National Bank of Belgium. In Belgium, the reporting category is referred to as survey code.

●     Define Reporting Subcategories

Enter the reporting subcategories required in the BOP file, as defined by the National Bank of Belgium. In Belgium, the reporting subcategory is referred to as survey transaction.

●     Assign Reporting Categories to DMEE Format Trees

SAP delivers the format tree, ITSR_BE_BOP2006_CSV, which creates the DME file according to Belgian requirements. Assign this format tree to each of the reporting categories you defined in the corresponding activity.

Activities

On the SAP Easy Access screen, choose Accounting ® Financial Accounting ® General Ledger  ® Reporting ® Foreign Trade Regulations ® Foreign Trade Declaration (Generic).

In addition to required entries, make the following settings:

●     Under General Selection Criteria, set the Select G/L Line Items indicator.

●     Under Additional Selection Criteria, you can restrict which documents are selected by entering specific customers and vendors. 

●     Under File Creation, set the Create File indicator, enter a file name, and enter CSV in the File-Name Extension (Item) field.

The report generates one DME file in CSV format for each survey code (reporting category).  

For more information, see SAP Note 903239.