Application Development and Automation 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: 
Read only

bdc

Former Member
0 Likes
409

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
376

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..

3 REPLIES 3
Read only

Former Member
0 Likes
377

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..

Read only

Former Member
0 Likes
376

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

Read only

0 Likes
376

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