Interface Logic

[Former Member]

Hi All,

I have to develop an outboubd interface which will generate a CSV file.

There is a job which creates some material documents (We can see them in MB03) & one more job which creates a reservations (We can see them in MB21).

I have to send a file with status updates of these material documents & reservations in a CSV file to some other system.

The problem is, How to fetch the data, say today the two jbos ran & created the material documents & reservations. I have to get the current status of these & put it in a file, tomorrow there will be new maerial documents & reservations with new status updates. Now I have to send status update for todays metrial documents as well as yesterdays with their updated status.

Can anyone help how I have to build logic for this?

I have written a logic which will fetch all the data from spool for the material documents & reservations posted & so that with these I can go to tables & query for their status but tomorow I will have to read the new spool & as well as send the update for the old material documents & reservations.

Kindly suggest me if I have to proceed with the Spool Logic or to query tables directly but I am not finding date fields in some tables.

This is needed urgently

Regards

Abby.

[JackGraus]

Hi, we have a simular scenario which we solved with:

1) Create a new output type medium A (ALE) or 6 (EDI) for material document or reservation.

2) Create an IDOC message type and IDOC type simular to your interface CSV fields

3) Create an outbound process code and a customer function module that fill the IDOC segments and fields define in step 2. The key field for the function module is material document item numbr (or reservation number). This can be used to select your required date from datbase or by calling a material document of resevation BAPI.

4) Add an entry in the partner profile. Here the outbound process code from step 2 is linked to the output type from step 1.

5) Create a customer IDOC port of type ABAP-PI. ABAP-PI ports can use a customer build function module to create required output from IDOC. Here a CSV file.

Regards jack

[Former Member]

> This is needed u-r-g-e-n-t-l-y

> Total Questions: 9 (8 unresolved)

> Silly subject title

= not -u-r-g-e-n-t and locked.