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: 

error occured after uploading data

Former Member
0 Kudos
149

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

1 ACCEPTED SOLUTION

rejish_balakrishnan
Contributor
0 Kudos
119

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)

9 REPLIES 9

Former Member
0 Kudos
119

hi,

Please check the code that you have written

Regards

Abhijeet

rejish_balakrishnan
Contributor
0 Kudos
120

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)

0 Kudos
119

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

0 Kudos
119

Hi rajesh,

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

Or simply its just an performance issue.

0 Kudos
119

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

0 Kudos
119

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.

0 Kudos
119

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

0 Kudos
119

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

0 Kudos
119

- 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