Ansicht
Dokumentation
RFFOPT_CBR - Central Bank Reporting
Addresses (Business Address Services) SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3upThis documentation is copyright by SAP AG.
Purpose
You use this report to generate an XML file for the Bank of Portugal. This XML file includes the following details:
- Account balances of your company's house banks, foreign customers, and foreign vendors
- Foreign payment transactions carried out by your company
The Bank of Portugal uses this XML file to report statistical information regarding foreign transactions to international organizations such as European Central Bank (ECB), Statistical Office of European Communities (Eurostat), and International Monetary Fund (IMF).
Integration
Prerequisites
In the Manage Financial Statement Versions app, you have created a financial statement version (FSV) and defined general ledger (G/L) accounts under the following IDs:
- INT
Contains a list of bank G/L accounts in which both foreign and domestic payment transactions are recorded
- EXT
Contains a list of bank G/L accounts in which only foreign payment transactions are recorded
- OTH
Contains a list of G/L accounts in which exchange rates and bank costs are recorded
Assigning State Central Bank (SCB) Codes
You must assign separate State Central Bank (SCB) codes to each vendor account, customer account, and house bank ID: one to identify the credit and the other for the debit values to these accounts. You do this by clicking Assign SCB Indicator at the bottom of the selection screen.
While reporting the balances of your company's foreign vendors, foreign customers, and house banks, the system includes these SCB indicators assigned to these accounts in the output file. This is to comply with the Bank of Portugal’s requirement that only absolute values should be included in the output file. Please note that this does not apply to foreign transactions. The SCB indicator that is displayed in the output on the foreign transaction view is the one entered in the document data.
Example
Assign SCB Indicators to a Vendor Account
| Company Code | Account Number | Account Type | Debit/Credit | SCB Indicator | ||||
|---|---|---|---|---|---|---|---|---|
| PT01 | VEN1 | Vendors | Debit | A00 | ||||
| PT01 | VEN1 | Vendors | Credit | A01 |
If you make entries as shown in the table above, it implies the following:
- SCB indicator A00 in the output file indicates a debit in the vendor account VEN1
- SCB indicator A01 in the output file indicates a credit in the vendor account VEN1
Assign SCB Indicators to a Customer Account
| Company Code | Account Number | Account Type | Debit/Credit | SCB Indicator | ||||
|---|---|---|---|---|---|---|---|---|
| PT01 | CUS1 | Customers | Debit | B00 | ||||
| PT01 | CUS1 | Customers | Credit | B01 |
If you make entries as shown in the table above, it implies the following:
- SCB indicator B00 in the output file indicates a debit in the customer account CUS1
- SCB indicator B01 in the output file indicates a credit in the customer account CUS1
Assign a Common SCB Indicator
| Company Code | Account Number | Account Type | Debit/Credit | SCB Indicator | ||||
|---|---|---|---|---|---|---|---|---|
| PT01 | * | Vendors | Debit | C00 | ||||
| PT01 | * | Customers | Debit | C01 | ||||
| PT01 | * | House Bank | Credit | D00 |
If you want to assign the same SCB indicator to indicate debit to all vendors in a company code, make entries as shown above (the value * indicates that the assigned SCB indicator is valid for all vendors in company code PT01). However, in addition to the above entries, if you explicitly maintain SCB indicators for specific vendors (in the same company code), the system considers these values for those vendors instead of the common SCB value.
Features
This XML file contains details of all foreign payment transactions and account balances recorded for the specified period, in the associated Financial Statement Version for the bank G/L accounts.
Foreign transactions include both incoming and outgoing payments to foreign vendors and customers. Balance details include the account balances of a company's foreign customers, foreign vendors, and house banks.
Selection
On the selection screen, specify the following:
- In the General Selection group box, specify the company code, calendar year, month, financial statement version, and run ID
- In the Other Selection group box, specify the following details:
- Ledger
- Vendor Special G/L
- You can include or exclude vendor documents with special G/L indicators
- Customer Special G/L
- You can include or exclude customer documents with special G/L indicators.
- Vendors
- You can include or exclude certain vendors.
- Customers
- You can include or exclude certain customers.
- In the File Creation group box, specify the following:
- Test run
-
Select this checkbox only if you want to generate a test file before sending the actual XML file to
the central bank. The system generates a test XML file with a special tag
"TEST FILE" , which indicates that the file must not be sent to the central bank for processing. If you do not select this checkbox, the system generates the actual XML file that can be sent to the central bank.
- Local File Path
- In this field you can specify a directory path to save the XML file on the local system. The system automatically generates the file name and saves the file in the specified path.
- Click Assign SCB Indicator to assign SCB indicators to the relevant G/L account, vendors, or customers in your company code. These indicators are then displayed in the Display Balances view.
Standard Variants
Output
Based on your selection criteria, the system generates an XML file and also displays the foreign transaction details and balances in an ALV grid.
If you want to directly navigate to the payment document or invoice document associated with a foreign transaction, click the corresponding document number on the output screen. You can also view the customer, vendor, and the house bank balances for the specified period by choosing the Display Balances button on the report output screen.
The register ID associated with each entry in the output file and ALV indicates the status of a reported foreign transaction or account balance. The possible values for a register are the following:
- C (New)
- Indicates a transaction or account balance that is reported for the first time
- A (Reversed)
- Indicates a reversed transaction
- M (Changed)
- Indicates a modified transaction or modified account balance
When you execute this report for the first time, the register ID associated with all entries in the output file, sent to the Bank of Portugal, is C. If this file contains errors, the Bank of Portugal notifies the sending entities regarding the same.
Once you correct these errors and rerun the report for the same period, the system only includes the following details in the newly generated XML file:
- New transactions recorded after the date of the previous run
- Transaction reversed or modified after the date of the previous run in order to rectify the errors notified by the Bank of Portugal
- Account balances of vendors, customers, and house banks if changed after the date of the previous run
TXBHW - Original Tax Base Amount in Local Currency RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 12402 Date: 20240520 Time: 141736 sap01-206 ( 207 ms )
