topic Re: online material master upload in Application Development and Automation Discussions

online material master upload

Former Member — Tue, 08 Aug 2006 17:02:24 GMT

Hi friends,

I have got a development where the material master data is directly loaded in to custom table in an online process..

could anyone of you please let me know what diffuclties, this task would undergo if its goin to be an online process and what measures should be taken?

I am new to development , please helpme.

like what if the system fails in middle of this process?

Re: online material master upload

RichHeilman — Tue, 08 Aug 2006 17:09:16 GMT

Hi Tina, not exactly sure of your requirement, but if you are updating a custom table in a loop for 500000 records, and your system crashes during this, no records will be permenantlly saved to the DB, unless you are specifying a COMMIT WORK for every so many records or for every record(not recommended). If it is ok, that no update happens if the program is ended abnorally, then you do not need to do anything. Otherwise, you should use COMMIT WORK to commit to the db.

Regards,

Rich Heilman

Re: online material master upload

Former Member — Tue, 08 Aug 2006 17:15:54 GMT

Hi Rich,

How would you indicate the users that these are the records that failed?? should we build a alv report by dispalying those failed records?

we should make sure that these records are updated,or how would you put checks ,, like if suppose there are totally 500 records & for every 50 records we save it in database as it get uploaded...

is it possible to put cheks and save it in that way?

Re: online material master upload

RichHeilman — Tue, 08 Aug 2006 17:41:22 GMT

Sure when looping thru your internal table and updating your custom database, you would just keep track of a counter, then it reaches 50, commit work, and clear the counter.

loop at itab into xtab.

.....

insert ztable from xtab.

<b>counter = counter + 1.
if counter = 50.
  commit work.
  clear counter.
endif.</b>

endloop.

Regards,

Rich Heilman

Re: online material master upload

Former Member — Wed, 09 Aug 2006 04:35:30 GMT

Hi !

To Upload Material-Master-Data without programming anything you could use the SXDA.

Create an new project using the object-type BUS1001006.

Look at the SXDA-Manual - it's not as difficult as it may look...

Regards

Rainer

Some points would be nice if that helped a bit...