19 Answers

• 00

  

  Plucinski 10/20/23, 12:10 PM

  Hello,
  as far as I remember, there is an OSS HW that says where to get BLZ directories for BRD, A and CH among others.
  The table BNKA is always a topic, in every project.
  We have spoken once with our house bank and this could send us even a file, which one could upload per country with SAP transaction BIC or BIC2 DIRECT, if I remember correctly. The file is of course huge !!! It is difficult to send it by mail. Ask at Commerzbank.
  I have heard that there should be something like that at swift.com. COSTS but ...
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  sapfi 10/20/23, 12:10 PM

  Hello Together,
  one day I found a very good site on the internet for bank signs (international). I will look for this one for you.
  But here is a report for banks in Spain. It is called (RFBVES_0)
  Many greetings
  Short text
  Transfer of bank data Spain
  Description
  This program can be used to transfer a bank directory stored as a UNIX file for the bank country Spain into the SAP system (table BNKA) or to revise banks already existing in the SAP system.
  Prerequisites
  The file must exist as a UNIX file. The path name of the file must be specified when the program is run.
  The file must be structured in lines, i.e. it must contain carriage return characters.
  The standard format according to the Consejo Superior Bancario (Norm 13bis) is processed. The record length is 264 bytes.
  Three record types are distinguished:
  00 Tape start
  Field Content Length in bytes (from-to)
  A Código registro 2 (1-2)
  E Fecha proceso 6 (259-264)
  01 Branch data
  Field Content Length in bytes (from-to)
  A Código registro 2 (1-2)
  B Número entidad 4 (3-6)
  C Número oficina 4 (7-10)
  E1 Nombre entidad 36 (15-50)
  E2 Nombre oficina 36 (51-86)
  E3 Domicilio oficina 40 (87-126)
  F1 Nombre plaza (cast.) 40 (129-168)
  G Tipo oficina 1 (209)
  K Código postal 5 (243-247)
  99 End of tape
  Field Content Length in bytes (from-to)
  A Código registro 2 (1-2)
  D Número registros 6 (259-264)
  If bank master data already exists in the system, the existing bank master record is updated with the data from the UNIX file if differences are detected.
  If banks are marked as no longer active in the UNIX file (indicator in record type 01), they are marked for deletion in the BNKA file.
  The program can be started in test mode (without updating the BNKA file) or in live mode (with updating the BNKA file).
  For test purposes, the number of records to be read from the UNIX file can be limited.
  The program does not lock the file BNKA. Therefore, care must be taken that the file BNKA is not accessed by any other user or program while the program is running.
  Output
  Statistics are output showing how many banks have been created or changed.
  If errors occur, the affected banks are listed in an error log.
  Additionally, a detailed list can be requested. It contains all successfully changed or inserted banks.
  The following data appears in both lists:
  Bank code
  Bank name
  Processing type (I=Insert, U=Change, D=Delete)

  report
• 00

  

  Plucinski 10/20/23, 12:10 PM

  Hello
  I have now also looked in the OSS and for Spain I have not found a source where you can find a directory.
  But important is in the context of the following HW
  Note 1012293 - IBAN and maintenance of bank master data
  Note 132012 - Addresses for obtaining bank sort code master data
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  sapfi 10/20/23, 12:10 PM

  Hi,
  here is a web address.
  http://www.swiftbic.com/swift-code.html?country=SPAIN
  hope it helps.
  many greetings
  

  twagener:

  ---

  Hello everyone,
  does anyone know where to get an official bank directory for the countries Spain and Slovakia?
  We would like to update our master data in the system by uploading a corresponding file, but unfortunately I can't find any hints where I could download such an up-to-date directory (preferably free of charge).
  For Switzerland and Germany there is a corresponding download from the Bundesbank and the banking association respectively. I am looking for something similar for Spain and Slovakia.
  Thanks & Greetings
  

  report
• 00

  

  sapfi 10/20/23, 12:10 PM

  This one may be better.
  http://www.theswiftcodes.com/spain/
  Greetings

  report
• 00

  

  twagener (Author)10/20/23, 12:10 PM

  Thanks for the tips, but they don't really help yet.
  I have already read all the OSS hints, the possible programs for the upload are known.
  The real question, where to get an official valid file (bank directory with the necessary data) for the countries Slovakia and Spain, which can be uploaded to SAP, is still open.
  Greetings

  report
• 00

  

  Maike 10/20/23, 12:10 PM

  Hello,
  so you can get all European banking data on the official site of the European Central Bank:
  European Credit Institutions ECB
  However, the Fromat is not SAP compatible and as far as I know there is no transaction (yet) to import the data. So you would have to write yourself an LSMW to import the data.
  PS: If someone knows a transaction, with which you can import the data directly, I am grateful for hints.
  Greetings from Bremen
  Maike

  report
• 00

  

  Plucinski 10/20/23, 12:10 PM

  Hello,
  I have had a look at the link. I think the key problem here is that the BIC is prefixed in the file,
  Example :
  DE01834 GENODES1DHB DE Darmsheimer Bank eG Karlstr. 1 71069 Sindelfingen Credit Institution Yes No
  DE04174 GENODES1DBE DE Dettinger Bank eG Volks- und Raiffeisenbank Karlstr. 74 72581 Dettingen an der Erms Credit Institution Yes No
  This means that the 8-digit bank code in BRD, which we all probably still have in our SAP systems, is completely missing!
  There will be hardly anyone among us who has maintained the BIC as BLZ. This would be then also probably fatal, since one could generate then no IBAN. Therefore one should see the topic BLZ directory always in connection with the maintenance of the IBAN and NEVER isolated from each other.
  There are some formats , so also the file, which one made available to us from the house bank of the customer, could I DIRECTLY !!!! with the transaction BIC or BIC2 in SAP.
  Example below from Targobank BLZ 30020900
  BI U DE000407 TARGOBANK AG UND CO KGAA DUESSELDORF CIPRDEDD XXX CIPRDEDD XXX CMCI DE 30020900 30020900 DE 30020900 30020900 314124 SUPE FINTGT 10, KASERNENSTRASSE 40213 DUESSELDORF GERMANY 20100306
  The thing went right through in SAP with transaction BIC or BIC2 if I remember correctly. No LSMW no Batch.
  Got this for all countries. File is 94.000 KB.
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  Plucinski 10/20/23, 12:10 PM

  Twagner,
  I mean in the HW but it says where you get BLZ for Slovakia. For Spain there was no source in the HW.
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  twagener (Author)10/20/23, 12:10 PM

  Hello,
  that sounds great with the large file. That's how I had imagined it, get / download the file from somewhere and then just upload it to SAP.
  The customer has obtained the file via the house bank (which one?)?
  The link to the Slovak bank in the SAP note unfortunately went nowhere, so it is out of date.
  Greetings

  report
• 00

  

  Plucinski 10/20/23, 12:10 PM

  Hello
  the file was already there when I came into the project.
  I mean but file came from Commerzbank. Ask there please times
  The good thing is that you can load it with transaction BIC or BIC2 directly per country into SAP. No programming, no LSMW, no batch INPUT !
  Simply ingenious !!!!!!!!
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  Plucinski 10/20/23, 12:10 PM

  For further questions please call me. Am now on 0170 2952198
  That would be easier than typing
  With kind regards
  Jens Plucinski
  www.jensplucinski.de
  Consultant Business Economist SAP FI

  report
• 00

  

  ploegerdieter 10/20/23, 12:10 PM

  Hello,
  so if there is still interest in the data from Spain and Slovakia, I can provide them.
  I can provide them.
  I have a database with all SWIFT/BIC codes.
  Good luck

  report
• 00

  

  ieeks 11/27/23, 2:22 PM

  Hello Dieter

  do you still have the file?

  report
• 00

  

  ploegerdieter 12/1/23, 2:38 PM

  Hello too,

  since someone is still in touch after a year, hats off.

  Please send me your EMAIL.

  report
• 00

  

  ieeks 12/1/23, 7:02 PM

  Super thanks! Yes, this is a hot topic for us at the moment :)

  gladly to ieeks@hotmail.com

  LG

  report
• 00

  

  ploegerdieter 12/2/23, 5:18 PM

  Hello ieeks,

  Data has been sent to the MAIL address.

  Please just give me a short feedback :-)

  I have a total of 144000 entries in my database for all countries :-)

  report
• 00

  

  ieeks 12/2/23, 9:28 PM

  super thanks! has already been processed :)

  thanks again dieter!

  report
• 00

  

  SoerChr92 1/27/25, 5:34 PM

  Hello Dieter

  this will still be relevant in 2025. :-) Do you still have the file?

  VG

  Christian

  report