topic Re: tricky question???????? in Application Development and Automation Discussions

tricky question????????

Former Member — Mon, 30 Apr 2007 14:06:44 GMT

Hi ALL,

Hope all are doing fine!!!

This is an interview question ,,,this is as follows:-

if there are some records in internal table ,,,,,i want to upload only selected records ,not all records into the database tables via transaction...thru BDC..how is it possible in session and call transaction methods?? pls remember that only selected records should be uploaded

Pls provide the answer

Quick solutions are highly appreciated and points wil sure be rewarded.

Regards,

ABC XYZ.

Re: tricky question????????

Former Member — Mon, 30 Apr 2007 14:14:19 GMT

HI..,

Use the BDC SESSION method with FOREGROUND Processing ( all screens )...

Now u can watch each and every session and if u dont want a particular record (transaction) to get updated then just give /N in the BDC_OKCODE and press enter.. then this particular record will not get updated and it starts the next record..

if u enter /bend and press enter the whole session ( total records will not get updated )

This works only with BDC SESSION METHOD.

regards,

sai ramesh

Re: tricky question????????

Former Member — Mon, 30 Apr 2007 14:16:17 GMT

what exactly u mena by 'selected'.

are the records, displayed in a table control on a screen, and you want to upload only entries you select. ?

then just add an indicator for select in the internal table, and while calling bdc, do it only for thos elines where indicator is set.

els,e what exactly is ur case ? whatever it is, there must be some indicater which identifies the 'selected' records, right ?

Re: tricky question????????

Former Member — Mon, 30 Apr 2007 14:20:45 GMT

first upload the records and display the same in an ALV report. Also, give a checkbox to teh ALV report. Now, user can select the records.

loop at itab where checkbox = 'X'.

here u need to use these records to upload to SAP using BDC.

endloop.

hope it clears.

reward points and avoid duplicate threads.

Re: tricky question????????

Former Member — Tue, 01 May 2007 13:10:05 GMT

There should be some criteria to eliminate few records.

So set a flag to 'X' for those records.

And upload only those records where flag is initial.

Thanks,

Deepti

Re: tricky question????????

Former Member — Tue, 01 May 2007 18:52:10 GMT

Just call the transaction for those records only which satisify your criteria.

Also, with session method, you can run it in mode-'A' and cancel whichever records you want to skip since you will have the screen running infront of you for every OK-code.

Reward points if helpful

Regards

Re: tricky question????????

Former Member — Wed, 02 May 2007 05:00:19 GMT

hi,

just put one condition in the loop.

first you will have records in internal table.so put one condition depending on your requriement, i.e.for example if you want to upolad only first 20 records in that case

loop at itab where sy-tabix LE 20.

performs for upolading data.

call transaction.......

endloop.

Re: tricky question????????

Former Member — Wed, 02 May 2007 05:03:42 GMT

just give condition at loop at itab where...

Re: tricky question????????

Former Member — Wed, 02 May 2007 05:14:28 GMT

HI,

Display your report to the user using ALV function module then user will check the records which want to be uploaded then process thro' call transaction.

Regards,

Suresh