topic Upload to Internal table in Application Development and Automation Discussions

Upload to Internal table

Former Member — Mon, 16 Apr 2007 10:41:54 GMT

Hello Everyone,

I have afile format as followes.

A B C100 200 300

100 200 100

200 100 300

300 200 100.

Now i have declared a internal table with deep structure..

data: begin of x_data occurs o,

X like 100,

Y like 200,

Z like 300,

end of x_data.

data: begin of i_data,

M like A,

N like B,

O like C,

it_data like table of x_data,

end of i_data.

Now how i can upload given file so tht al the records are in deep structure i_data.

Regards

Re: Upload to Internal table

Former Member — Mon, 16 Apr 2007 10:54:54 GMT

Hi..

better take an itab of field 1 of type string.

<b>data:

begin of itab occurs 0,

line type string,

end of itab.</b>

now upload data into itab using <b>GUI_UPLOAD</b>.

later move ur data to respective fields into ur itabs.

Re: Upload to Internal table

Former Member — Mon, 16 Apr 2007 11:00:02 GMT

Hi,

Try to upload data in itab having fileds like A B C100 200 300, process data using loop statement considering blank uploaded in ABC if any.

May be this iwll help you

Re: Upload to Internal table

Former Member — Mon, 16 Apr 2007 11:09:47 GMT

u have to first read the data in a internal table with single field

then loop at that table sending the fields to WA which is defined as a string

data wa like string

eg loop at itab into wa.

now use move corresponding statement to move the data from wa to ur deep structured internal table

eg move-correspondoing wa+ 0(3) to i_data-m

and so on...

Re: Upload to Internal table

Former Member — Tue, 17 Apr 2007 12:22:02 GMT

Thanks all for your inputs.

I have resolved on my own.

Regards