SAP FI is the accounting module of the SAP R/3 product. The ]po[ SAP import interface allows to import SAP cost elements into ]po[ on the level of "internal orders" (Innenauftrag).
Please note that this import is similar to the [SAP Project System (PS) integration]. The SAP PS integration is an extended version of the SAP FI integration, including information about SAP WBS (Work Breakdown Structure) elements, employe rates etc.
The scenario for this integration consists of a project-oriented department of a large company or division (for example: the IT department) that manages projects via a number of Excel sheets or stand-alone applications for project management or timesheet management. The corporate SAP system is used for procurement on the project level. A controller manually collects data from various sources, performs budget checks and elaborates management reports.
In this scenario, ]po[ will become the main source for project management related information and handle areas including project tracking, budget tracking, timesheet management and absence management. Using this information, ]po[ will be able to perform budget checks and to create management reports.
However, ]po[ in order to deliver precise data, ]po[ is lacking information about:
The SAP FI import is designed to cover exactly this gap.The ]po[ SAP FI import expects a flat CSV file from SAP FI with cost elements per "internal project" with the following fields:
Auftrag Belegnr BuZ Kostenartenbezeichn Bezeichnung Gegenkonto Gegenkontobezeichnung Jahr Per BuchDatum Wert/BW
These columns are available in several SAP FI reports, so they are easy to extract manually from SAP. A small ABAP program is necessary to automate the generation of the CSV file.
The manager of each project is responsible to maintain the correct internal project number in ]project-open[.
The entire SAP FI -> ]po[ integration link exists of the following elements:
The SAP FI import requires the ]project-open[ team to configure the integration link manually. This step has not yet been automated.
Please contact us for further information about the process.