topic uploading sequential file to sap in Application Development and Automation Discussions

uploading sequential file to sap

Former Member — Tue, 07 Oct 2008 05:56:32 GMT

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

Re: uploading sequential file to sap

Former Member — Tue, 07 Oct 2008 06:23:18 GMT

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

Re: uploading sequential file to sap

BH2408 — Tue, 07 Oct 2008 06:26:57 GMT

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

Re: uploading sequential file to sap

Former Member — Tue, 07 Oct 2008 08:49:21 GMT

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?

Re: uploading sequential file to sap

former_member761936 — Tue, 07 Oct 2008 10:36:02 GMT

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

Re: uploading sequential file to sap

Former Member — Tue, 07 Oct 2008 12:20:37 GMT

hi,

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

Then how to upload them through lsmw.

Thanks for your reply.