Kontakt

Ansicht
Dokumentation

RFBVCA_0 - Bank Data Transfer (Canada)

RFBVCA_0 - Bank Data Transfer (Canada)

TXBHW - Original Tax Base Amount in Local Currency   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Description

The program is used for transferring the bank directory for banks in Canada (stored in a file) into the SAP system (table BNKA).

Description of the Data Records Used:

The following data attributes were transmitted by Reed Information Services and taken as a basis for the program:

  1. The data used is stored in ASCII format.
  2. The individual records are marked by carriage returns and have a fixed length of 400 bytes ("fixed length records").
  3. Record layout for record type:
Field Name   Length in Bytes Byte Position
Filler   9   001-009
Institution Type   2   010-011
Identification Number   10 012-021
Status Indicator   1   022-022
Cross_Reference number   10 023-032
Language Preference Code   1   033-033
Institution Name (English)   36 034-069
Institution Name (French)   36 070-105
Branch Domicile   36 106-141
Civic Address   36 142-177
Postal Address   36 178-213
Town/City   36 214-249
Province Code   4   250-253
Postal Code   10 254-263
Country   20 264-283
Institution Identification Number   22 284-305
for Routing Indirect Clearer Credits  
Indirect Clearer MICR Encoding   22 306-327
Serviceability Code   1   328-328
Exchange Point   6   329-334
Foreign Bank Transit Number   10 335-344
Effective Date   6   345-350
Filler   50 351-400

Program flow

The program compares the data from the input file with the data that already exists in the SAP system and carries out the following activities.

  1. If the bank data does not exist in the SAP system, the data is transferred from the input file. Not all data fields are transferred in full but generally the field lengths used are adequate and none of the field contents go missing.

Data is transferred in the following way:

  1. Identification Number in the BNKA-BANKL and BNKA-BNKLZ fields,
  2. Institution Name in the BNKA-BANKA field
  3. Civic Address (first 35 Bytes) in the BNKA-STRAS field,
  4. Town (first 24 Bytes) and Postal Code (in full) in the BNKA-ORT01 field,
  5. Province Code in the BNKA-PROVZ field,
  6. Branch Domicile (in full) in the BNKA-BRNCH field.
  • If the bank data does exist in the SAP system, then it is updated if there are any changes when compared with the data from the input file, compared for each sort code.
  • If a bank which is marked with a deletion flag in the SAP system was delivered in the input file, then the deletion flag is cancelled again.
  • All banks managed in the BNKA but which are not in the input file are seen as no longer existing. They are marked with a deletion flag if the "Mark for deletion" parameter is activated and can then be reorganized.

    • No banks are deleted. The programs "Reset Bank Data" (SAPF023) and "FI Bank Master Data Archiving" (SAPF061) are used to do this.

    The Bank Sort Code is used for the BNKA-BANKL key field. According to the Canadian Payments Association the Bank Sort Code is unique for each main office.

    The program can be started in test mode (without updating the BNKA file) or in production mode (with updating the BNKA file).

    The number of records read from the file can be limited for test purposes.

    Output

    Statistics are generated so that you can see how many banks were created or changed.

    A detailed list can also be requested. It contains all banks which were changed successfully or added.






    ABAP Short Reference   General Material Data  
    This documentation is copyright by SAP AG.

    Length: 7603 Date: 20240520 Time: 122416     sap01-206 ( 58 ms )