topic bdc in Application Development and Automation Discussions

bdc

Former Member — Sat, 17 Jun 2006 08:58:28 GMT

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.

Former Member — Sat, 17 Jun 2006 09:26:09 GMT

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

Former Member — Sat, 17 Jun 2006 09:40:43 GMT

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

Former Member — Sat, 17 Jun 2006 09:52:56 GMT

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