topic Re: error occured after uploading data in Application Development and Automation Discussions

error occured after uploading data

Former Member — Sat, 28 Feb 2009 06:34:30 GMT

Hi experts,

i have dveloped bdc for mmo1 while uploadind data the performance is poor in my excel 75,000 records are there any one give some idea....

Thanks in advance...

rajesh

Re: error occured after uploading data

Former Member — Sat, 28 Feb 2009 06:57:07 GMT

hi,

Please check the code that you have written

Regards

Abhijeet

Re: error occured after uploading data

rejish_balakrishnan — Sat, 28 Feb 2009 08:21:41 GMT

Hi,

Use session methods for the same .Also run the session in background mode.

Session Method Updates the Database Synchronously. Call Transaction Method Updates the Database Asynchronously. (Note: Asynchronous updation is Faster than Synchronous)

Re: error occured after uploading data

Former Member — Sat, 28 Feb 2009 11:45:14 GMT

Hi,

i used both methods (call transaction & session method) again same problem is occured my client didnt accept the such kind of performance they are expecting good performance.... can anybody tell me how to reduce timing to upload data.....

Thanks

rajesh

Re: error occured after uploading data

rejish_balakrishnan — Sat, 28 Feb 2009 11:49:40 GMT

Hi rajesh,

You have mentioned that you getting error after uploading .what was the error ?

Or simply its just an performance issue.

Re: error occured after uploading data

Former Member — Sat, 28 Feb 2009 12:01:19 GMT

Hi,

its performance issue only....i heard that first upload data from presentation server to application server and then upload to mm01 and xko1 transaction. in this case we need to write the coding for split the work process but i dont know how to do it .... please guide me how to do it...

Thanks

Rajesh

Re: error occured after uploading data

rejish_balakrishnan — Sat, 28 Feb 2009 12:07:30 GMT

Hi,

That was a good idea too.

First upload the file from presentation server in to an

internal table using gui_upload.

2.open dataset

3.loop the internal table

4.use transfer statement to write into application server.

And then proceed with uploading to MM01.

Re: error occured after uploading data

rejish_balakrishnan — Sat, 28 Feb 2009 12:11:26 GMT

Hi ,

Also try to have structure defined for all tables individually and dont directly refrence it.

Try to have the order of fields in file(application or presentation) matching exactly with internal table and order of filling columns in MM01.

Try to aviod Deep types in structures such as string or nested structure .

<< cut and paste from:

http://www.sap-img.com/basis/sap-system-performance-issues.htm

removed >>

<< Points unassigned >>

Edited by: Rob Burbank on Feb 28, 2009 10:32 AM

Re: error occured after uploading data

rejish_balakrishnan — Sat, 28 Feb 2009 12:50:18 GMT

HI,

See the sample code for Uploading a Tab delimited file from application server into internal table

<<Cut and paste code without attribution from

http://www.sapdevelopment.co.uk/file/file_uptabpc.htm

removed>>

Edited by: Rob Burbank on Feb 28, 2009 10:28 AM

Re: error occured after uploading data

Former Member — Sat, 28 Feb 2009 17:11:44 GMT

- is it compulsory that, u hv to go with report prog.? we hv LSMW with IODC for MM01, and also there is(i guess) DIRECT INPUT for MM01.

- There is BAPI.....but,(i guess) still, for some part u hv to write BDC, like for Material Caharacteristics.

- And also u can find a alsmost complete BDC for MM01 in google, actually, i had it, but, some how i lost that link!!

thanq