Thursday, 10 June 2021 15:57

Load FI document from Excel/CSV with ODIN (Open Document Interface)

Written by Bernhard Haberstetter
Rate this item
(0 votes)
Source https://blogs.sap.com/2021/06/11/load-fi-document-from-excel-csv-with-odin-open-document-interface/
“© 2020. SAP SE or an SAP affiliate company. All rights reserved.” “Used with permission of SAP SE”

ODIN is a flexible, extensible, easy to use, multi-purpose import interface for SAP FI documents.

It is suitable for postings as they can be entered in the dialog transaction fb01, such as incoming and outgoing invoices or G/L account postings.

  • Can be used in frontend or as background job (with local or server side files)
  • Flexible dataset structure
  • Suitable for mass processing
  • Highly extensible with BAdI enhancements
  • Various input interfaces such as Excel and csv, further options are planned
  • Open Source, community based, free to use

If Excel files are processed, abap2xlsx must be installed. For processing of csv files, abap2xlsx is not required and doesn’t need to be installed.

ABAP releases older than 7.40 will not work. Release 7.40 might be ok; however it has not been tested. Release 7.50 and later should be fine. S/4 releases should work as well, however test is missing. Feedback at that point is very welcome.

On our Github page you can find information about the installation (with abapGit), a quick start guide and a wiki with extensive user documentation including the catalog of available fields and alias names. Developers that want to apply custom logic should check out the BAdI reference.

Once ODIN installed, you can easily import booking files with transaction ZODIN. The tool is also explained in the following video, mainly from the user’s point of view:

The screenshots below demonstrate how ODIN (Transaction ZODIN) easily turns your excel or csv list into SAP FI documents:

Check out the quick start section on the ODIN Github page.

If you have any questions or feedback please use the comment section below!

Continue reading here
Read 79 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.