Kontakt

Ansicht
Dokumentation

RFBVBIC2 - Report RFBVBIC2

RFBVBIC2 - Report RFBVBIC2

General Data in Customer Master   General Data in Customer Master  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

This program uses a global bank directory to import files, compares these files with existing bank data, and saves the new and changed data in the bank master (BNKA table).

Integration

Prerequisites

Features

The file with the bank directory can be imported from the presentation server (PC) or from the application server (host). When the report compares the data, it adds any new banks to the bank master, updates banks whose data has changed (such as addresses), and flags banks for deletion if they are no longer valid. The system displays the changes in an ALV list. More details about the scope of features are described in the next section for the individual parameters.

Selection

  • The "Upload From", "Path and File Name" and "File Structure" parameters determine the file that is to be imported. You can use the input Help to select the file in the directory tree - also when you upload from the application server.
  • The "Country Key" selection option restricts the quantity of data imported from the file to the countries that you specify. This can, for example, be used to split the countries into groups for processing in multiple program runs with different import parameters. If you do not specify a country, the system processes all the data records from the file whose ISO country code matches the two-character ISO country code of a country set up in the SAP system. The system also uses the ISO country code for assigning data records for the country key that you entered. Since the same ISO code can appear for more than one country in the SAP system, you need to uniquely specify the correct country in this selection option, or exclude the other country. If you do not do so, the system issues an error message in the results list and the related data is not processed.
  • "Countries with Bank Key Type X" checkbox: If you deselect this checkbox, you exclude certain countries from processing. These countries are those defined in the bank directory with key types 1, 2, 3, and 4 in country-specific checks.
  • "Test Run" checkbox: If you select this checkbox, the system does not update the data in the database when you execute the report. In a test run, the system processes the data and displays the planned changes in a list. The database is not updated.
  • "Lock Bank Master For Update" checkbox: If you select this checkbox, the system sets a global lock on the database table BNKA in the bank master during the update. Local locks for individual table entries are not possible as these slows the system performance. When you set the global lock, other users or programs are prevented from making changes to the bank master while the program is running.
  • "ALE Distribution" checkbox: If you select this checkbox, the system distributes the created or changed bank data to other systems or clients according to the distribution model that has been set up.
  • "Delta Upload" checkbox: If you select this checkbox, the system imports only the delta file instead of the full file. A delta file contains only new data records or data records that have been changed since the last complete version of the file. If you have selected this checkbox, the system does not compare the imported data with the entire bank master, but only with banks that have matching key information (bank number and SWIFT, see also the text for the "Use BIC Record Key" checkbox). Therefore, the system flags for deletion only the banks that are flagged for deletion in the file. If you do not select the "Delta Upload" checkbox, the system also flags all banks in the SAP system for deletion that are not in the file. In the compatibility mode, the delta upload is not supported (see the text for the "Compatibility Mode" checkbox).
  • The "Bank Key in Type 4" parameter controls which data (fields) is used from the file as the bank key if the bank key type 4 (assigned externally) has been set for the relevant country in the country-specific checks. The following variants are possible:
  • "BIC Code (SWIFT)" - The system uses the BIC as a bank key if it is in the file in the data record. The bank key therefore has the same value as the "SWIFT Code" field in the SAP master record.

  • "Bank Number (National ID)": The national bank ID is used as the bank key (if it is in the file in the data record) as if bank key type 1 were set up for each country. The bank key therefore has the same value as the "Bank Number" field in the SAP master record. This can be useful, for example, if the bank key type is changed from 1 to 4, but the current bank data has not yet been reorganized or deleted.

  • "BIC Code/Bank Number": This is a combination of the first two variants. The system imports all banks with a unique BIC first. This means that the bank key is the BIC. Next, the system adds banks to the bank data that already have a BIC but a different bank number. The system uses the bank number as the bank key for these banks.

  • "Bank Number/BIC Code": The system imports the banks in the same way as the previous variant, but the bank number takes priority. The system imports all banks with a unique bank number first (the bank key is the bank number), and then adds the banks where the BIC is missing (the bank key is the BIC).

  • "BIC Record Key" - The record key unique within the file is used as the bank key. This variant imports all banks that are in the file if this file contains this key, regardless of whether there is a BIC or a bank number in the data record. We recommend that countries do NOT use this setting if the bank number is a fixed part of the account number, but saved separately in the bank master (for example: France, Italy, Spain, Portugal). The bank number assigned to a BIC record key can change if there is a new file version (for example, another branch of the same bank). This would make all the corresponding account numbers invalid.

  • "SEPA Mode (IBAN BIC)" checkbox: This checkbox can only be set if the file contains an IBAN-relevant variant of the BIC and of the bank number and if you want to give preference to these fields; for example, "IBAN National ID" instead of "National ID", and "IBAN BIC" instead of "BIC". For more information, see example 5.
  • "Only Banks with BIC (SWIFT)" checkbox: If you select this checkbox, the system imports only data records from the file that have a BIC (even if the bank number is used as a bank key).
  • "Only BICs Connected to SWIFT Network" checkbox: If you select this checkbox, the system excludes all data records that have a BIC that is not connected to the SWIFT network (with a "1" as the 8th character).
  • "Use IBAN Country Code" checkbox: If you select this checkbox, the system uses the IBAN country code for the bank assignment. The country key of the bank can differ from the IBAN country code, for example, in Jersey (JE and GB) or Réunion (RE and FR). If you select the checkbox, the system saves the bank using the IBAN country code (for example, a bank from Jersey is saved with country code GB) provided the imported file contains the IBAN country code.
  • "Use BIC Record Key" checkbox: If you select this checkbox, the system saves the BIC record key in the BNKA-BICKY field. Since this field is not available in all SAP systems (depending on the installed components), this checkbox is not always ready for input. The BIC record key can help during the delta upload to uniquely identify the relevant bank (see the text for checkbox "Delta Upload" and example 4), without the need for comparing the corresponding bank number and BIC.
  • "Compatibility Mode RFBVBIC_0" checkbox: If you select this checkbox, the system uses the subroutines for data comparison and the results list from the older program.
  • "Use Branch Code XXX for HQ" checkbox: If you select this checkbox, the system uses the dummy branch code XXX from the file to increase the 8-character BIC to the full 11 characters, for example: NDEASESSXXX. If you do not select this checkbox, the system transfers the BIC without the branch identifier, for example, NDEASESS. This parameter does not affect the full 11-character BICs. These are always transferred in full, for example, NDEASESSA21. You can use this parameter, for example, to also import a national bank directory where the dummy ID XXX is not used. This avoids duplicate entries where one has the XXX ID and the other does not.
  • "Set Deletion Flag" checkbox: If you select this checkbox, the system flags banks for deletion that are no longer valid in the SAP system. The system finds these banks when it compares the imported data with the current bank master. Alternatively, it flags these banks for deletion during a delta upload if they are flagged with the deletion indicator "D" in the file.
  • "For Own Data Records Only" checkbox: If you select this checkbox, you restrict the quantity of banks flagged for deletion to those that were created with this program and file format. The system uses the version indicator (BNKA-VERS field) to recognize these banks. The default value corresponds to the format of the imported file. However, you can use this for any version indicator by entering the text element VER in program RFBVBIC2.

Standard Variants

Output

The system displays the bank master changes in an ALV list. If you double-click a changed bank, the system displays the old and new values to enable a comparison.

The system displays a summary for each country at the end of the change overview. This contains the total figures of the banks that have been added, changed, or flagged for deletion. Alternatively, it contains an error message if the data of a particular country could not be processed.

  • "No data selected": There were no banks for this country in the file. To avoid this message, you need to exclude this country by using the selection parameter "Country Key".

  • "ISO country code not unique": There is more than one country that has the same ISO country code. You must set up the ISO country code uniquely, or use the selection parameter "Country Key" to uniquely determine the correct country or to exclude the other country.

  • "There is no ISO country code": The country was not excluded from processing and no ISO country code was set up. To avoid this message, you need to exclude the country by using the selection parameter "Country Key", or by entering an ISO country code.

  • "Enter the bank key type": You did not exclude the country from processing, nor did you select a bank key type (key for the bank directory). To avoid this message, you need to exclude the country by using the selection parameter "Country Key", or by entering a key for the bank directory.

  • "Incorrect bank key type (x)": You did not exclude the country from processing, nor is the bank key type supported or excluded by the settings on the selection screen.

Activities

Example

  • Example 1: The checkboxes on the selection screen are not specific to a particular country. The dummy branch code XXX is, for example, must be used in one country but is not required in another. However, it is not possible to select the "Use Branch Code XX for HQ" checkbox specifically for a particular country. In this case, you need to import the file in two program runs. In the first run, you need to select the checkbox and restrict the processing to the countries that require code XXX. In the second run, deselect the checkbox and exclude the countries that were in the first run. You do not need to split the file since only the required countries are imported.
  • Example 2: Some banks use the bank number of their HQ for all branches, but the SWIFT (BIC) is different for each branch. The bank key in the SAP system is the bank number (type 1) for each country, which means that you cannot save all branches. However, the missing SWIFT codes are necessary for foreign payments. In this case, change the bank key type to 4. The existing bank data does not need to be reorganized. The bank key of the banks already in the system remains as the bank number. The missing banks are added, whereby the SWIFT code is used as the bank key. You need to set the parameter "Bank Key for Type 4" to "Bank Number/BIC Code" when you import the data.
  • Example 3: Some banks use the SWIFT code (BIC) of their HQ for all branches, but the bank number is different for each branch. The bank key in the SAP system is the SWIFT code (type 4) for each country, which means that you cannot save all branches. However, the missing bank numbers are needed for domestic bank transfers. In this case, you can add the missing branches, whereby the bank number is used as the bank key. You need to set the parameter "Bank Key for Type 4" to "BIC Code/Bank Number" when you import the data.
  • Example 4: We recommend that you always import the full files. If you import only one delta file, note the following: A delta file contains only the changes of the last full version of the file. This makes it more difficult to assign the imported data to the data that is already in the SAP system since the appropriate bank key needs to be found. Therefore, you need to select the "Delta Upload" checkbox to ensure that the program uses the special logic for delta files. If, for example, the branch address of a bank changes, and that bank has 12 branches, and only the HQ is saved in the SAP system because all 13 banks have the same bank number, then the program must recognize that this change is to be ignored since the affected branch is not in the system. Without the special logic, the HQ address would be changed since the bank key matches. The same logic is also used for other types of change such as the creation or deletion of a new branch.
  • Example 5: You are planning to transfer funds to a country as a SEPA payment only. In this case, you need to select the "SEPA Mode (IBAN BIC)" checkbox. The system transfers the IBAN-relevant data first (if this data exists in the file). If the SWIFT code (BIC) is used as a bank key, the system saves the "IBAN National ID "in the bank number field (BNKA-BNKLZ) instead of the "National ID", if these differ. If the bank key is the same as the bank number, the system saves the "IBAN BIC" in the SWIFT code field (BNKA-SWIFT) instead of the "BIC", if these differ. This makes it easier to maintain IBANs in the SAP system. For example, it is easier to find a bank that matches a specified IBAN.
  • Example 6: The system imports fewer records than there are in the file. When you import the data, the system skips several records for the following reasons:
  • A record is flagged with the deletion indicator. This type of record is processed only during a delta upload.

  • A record is flagged with an indicator that does not signify a bank (for example: the business code has the values BEID, CORP, MCCO, TRCO, and SWIF). The indicator does not exist in all supported file structures.

  • A record belongs to a country that was excluded from processing on the selection screen.

  • A record was excluded because of another parameter, for example: "Only Banks with BIC (SWIFT)".

  • A record does not contain any unique key information (such as multiple banks with the same bank number or the incorrect bank key type for the country).






Vendor Master (General Section)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 17605 Date: 20240520 Time: 110556     sap01-206 ( 391 ms )