how to update the data from presentation server data via back ground process

[Former Member]

Hi Gurus

I have a requirement updating the data in foreground its working fine,now my requirement is updating the data in background its not updating.

the flat file is excel format.its updating through BAPI,its working fine in foreground.can you please suggest me how to handle this issue.

Hemanth 

[karun_prabhu]

Hello Hemanth kumar.

     Which BAPI are you using?

Regards.

[Former Member]

Hi Arun

This is the bapi Name   BAPI_MATPHYSINV_COUNT .

[karun_prabhu]

Hemanth Kumar,

     Did you write COMMIT WORK after calling this BAPI?

Regards.

[raymond_giuseppi]

I suppose your interactive program executes OLE statements (implicitly if not explicitly) so only works with an Excel task active on the workstation or at least use GUI functions not available in background.

So in background you have TWO problems :

• Accessing the data -> use a tool like FTP
• Converting Excel data to Abap data -> either convert the Excel folder into a flat type like csv or similar format /or/ use a tool like a abap2xlsx.

Regards,

Raymond

[pruthviraz]

Check this out .. similar thread

ALSM_EXCEL_TO_INTERNAL_TABLE | SCN

[raymond_giuseppi]

Look at FM source, it uses OLE, so no use in background, and this (old) thread doesn't provide any solution. (Only the "Don't reward if not helpful!" is funny in the thread, the "assumed answered" status often means the opposite.)

Regards,

Raymond