10-07-2008 6:56 AM
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
10-07-2008 7:26 AM
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
10-07-2008 7:23 AM
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
10-07-2008 9:49 AM
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?
10-07-2008 7:26 AM
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
10-07-2008 11:36 AM
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
10-07-2008 1:20 PM
hi,
No the number of records are not fixed for a line,
Then how to upload them through lsmw.
Thanks for your reply.