error occured after uploading data

[Former Member]

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

[Former Member]

hi,

Please check the code that you have written

Regards

Abhijeet

[rejish_balakrishnan]

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)

[Former Member]

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

[rejish_balakrishnan]

Hi rajesh,

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

Or simply its just an performance issue.

[Former Member]

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

[rejish_balakrishnan]

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.

[rejish_balakrishnan]

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

[rejish_balakrishnan]

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

[Former Member]

- 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