Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there an alternative solution to import invoices into SAP ?

oliver_ried
Explorer
0 Kudos
193

Hi,

we are working with two ERP-systems. One of them is SAP, but we use the SAP financial accounting for both ERP-systems.

To insert the invoices from the other ERP-system, we create every day a ASCII-file with the foreign invoices in the following format:

0UEBFAKTURALE100sipdatenuebn

1FB01 24.02.11DI000924.02.1102EUR 1,0000/.....

2ZBSEG 01/ 1897,00**/ /....

2ZBSEG 50/ 1897,00A5/.....

2BBTAX 0,00A550/.....

In SAP we have created the structure ZBSEG. This is a subset of fields from BSEG. To import the foreign invoices from the other ERP-system into SAP, we use the transaction OBG4.

OBG4 reads in the ASCII-file from above and creates a batch-input which uses FB01 to create the SAP invoices.

This approach works for years, but it is a tedious and boring work, because we must do the OBG4 step every day by hand. After that, we must launch the newly created batch input manually.

We want to automate this import, and we are still searching for an alternative.

There is one big advantage of OBG4 and ZBSEG: It's a standardized interface for the SAP financial accounting, and it works really good.

We have considered to write a new ABAP-program with our own batch input which uses FB01. In a daily job this ABAP-program could run automatically. But I think, this approach is error-prone. It would not be a standardized SAP-interface, and it would be difficult to write a new FB01-batch-input-routine that works correct in all cases.

Is there another standardized interface for the SAP financial accounting which we can use programmatically?

Does exist a SE37-function module for this problem?

Kind regards

Oliver

1 ACCEPTED SOLUTION

oliver_ried
Explorer
0 Kudos
98

How can I pick a batch input session with a report?

6 REPLIES 6

Former Member
0 Kudos
98

Transaction OBG4 simply runs standard SAP program RFBIBL00. You can easily put this program in a background job and schedule it automatically.

Rob

oliver_ried
Explorer
0 Kudos
98

Thank you for the tip.

The SAP program RFBIBL00 creates a batch input session.

Is it possible to programmatically start this batch input session?

Sandeep_Kumar
Product and Topic Expert
Product and Topic Expert
0 Kudos
98

You can pick this session( created for RFBIBL00) via a simple report and start the jobs or schedule the jobs.

oliver_ried
Explorer
0 Kudos
99

How can I pick a batch input session with a report?

0 Kudos
98

In one job, you have two steps. The first one runs RFBIBL00; the second step runs standard SAP program RSBDCSUB to process the batch input sessions.

Both programs are documented and have been discussed many times before in the forum.

Rob

oliver_ried
Explorer
0 Kudos
98

Thank you, Rob. I will give it a try.