Monday, 14 June 2021

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

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.

Key features

◉ 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

Prerequisites

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.

Installation, Documentation

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:

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

SAP ABAP Tutorial and Materials, SAP ABAP Exam Prep, SAP ABAP Preparation, SAP ABAP Certification, SAP ABAP Career, SAP ABAP Guides, SAP ABAP Learning

No comments:

Post a Comment