uploading sequential file to sap

[Former Member]

hi,

Can we upload a sequential file to sap which is separated by comma.

The file consists of three fields ,but in a single colume these three fields are repeated.

Then can we upload this using lsmw or bdc...

regards

[Former Member]

hi,

Can we upload a sequential file to sap which is separated by comma.

The file consists of three fields ,but in a single colume these three fields are repeated.

Then can we upload this using lsmw or bdc...

regards

[Former Member]

Hello,

Yes. We can upload a Sequential File using BDC as well as LSMW. You can use the Function Modules GUI_DOWNLOAD or the Method CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD to serve your purpose.

You need to specify the separator as 'X' in your Function module call to indicate that the Flat File has a Separator.

Thanks and Regards,

Venkat Phani Prasad Konduri

[Former Member]

thanks for your reply..

but my query is ..

for ex: data in flat file is

customer saleorg division customer salesorg division

1000 10 20 2000 20 30

then who to upload this sequential data into sap?

[BH2408]

Hi,

we can upload the sequential file with comma seperator, use the GUI_UPLOAD .... and mention , seperator tab....

Both ways we can do ....

regards,

Bharani

[former_member761936]

Hi Geetha,

Is the numer of records for line is fixed , or all the customers will gien in the same line

And split record at ',' into internal table. then loop tha tinternal table and Append record for every three records.

Hope this will help you

Regards,

Narendra.Soma

[Former Member]

hi,

No the number of records are not fixed for a line,

Then how to upload them through lsmw.

Thanks for your reply.