‎2006 Jun 17 9:58 AM
hi,
I have 500 records in flat file. I want to upload only 100 records and the process is to be stopped after uploading the 100 records.
please clarify my problem
thank u in advance.
‎2006 Jun 17 10:26 AM
hi first copy the 500 into internal table then select first first 100 by using sy-tabix value in loop stmt and copied into second internal table...
now you upload the second internal table..
‎2006 Jun 17 10:26 AM
hi first copy the 500 into internal table then select first first 100 by using sy-tabix value in loop stmt and copied into second internal table...
now you upload the second internal table..
‎2006 Jun 17 10:40 AM
Hi Srisaihari,
You can not restrict some of flat file records when you give flat file name to GUI_UPLOAD.
It transfers all records in flat file to internal table.
You can write your own logic on internal table.
Take another interna table of type ITAB as ITAB_100.
Use the following code after GUI_UPLOAD.
<b>LOOP AT ITAB.
APPEND ITAB TO ITAB_100.
CLEAR ITAB_100.
IF SY-TABIX = 100.
EXIT.
ENDIF.
ENDLOOP.</b>
Note: Plz reward points to all helpful answers and close thread if it is solved.
Thanks,
Vinay
‎2006 Jun 17 10:52 AM
hi
in case of ALSM_EXCEL_TO_INTERNAL_TABLE FM...
set the value of I_END_ROW to 100 ..it wont process mmore than 100 records..
Reward points if it helps
Regards
Gunjan