topic upload problem in Application Development and Automation Discussions

upload problem

Former Member — Fri, 30 Mar 2007 10:59:07 GMT

Hi gurus,

I have to make few changes in an already existing BDC.

The problem is with flat file. the current file is like this.

70000205246 10 SVV 25.10.2006 6500809 -52.2 3 4

70000205246 20 SVV 25.10.2006 6500809 -50.4 1 2

70000205246 30 SVV 25.10.2006 6500809 -52.8

70000205246 40 SVV 25.10.2006 6500809 -45.1

To upload this file there no problem.

But actually the vendor sends the docmt in the below format

Mtr rdg at MTD Type Current rating Volt rating Tested by Tested date

108009 X3D20 50-100 240x3 MYS 05/03/2007

0 X3D20 50-100 240x3 MYS 05/03/2007

405376 E3D109 20-100 240x3 MYS 05/03/2007

8 num 6 al n 8-al n 6 ap n 3 al

The end user is converting this file into the above format.

Now my requirement is to code the progrm such that the second format data is uploaded.

please suggest me how to do.

Thanks and Regards,

Alson.

Re: upload problem

harishaginati — Fri, 30 Mar 2007 11:02:16 GMT

use LSMW maping colum headings,, its easy

Re: upload problem

Former Member — Fri, 30 Mar 2007 11:03:29 GMT

Change your internal table structure according to the present format. check the code to see correct field is being passed to bdc or not.

Re: upload problem

Former Member — Fri, 30 Mar 2007 12:47:12 GMT

Hi,

First you will upload this structure in to one internal table whihc has one field and length of 256.So every line becomes one field in your internal table.

Now you can split this one field internal table into your required internal table.

Let assume itab1 contains one field.

itab 2 contains your requried field.

then

loop at itab1.

split itab1 into itab2-field1

itab2-field1

itab2-field3

itab2-field4

itab2-field5

at seperator 'X'.

append itab2.

endloop.

Now it will works fine and remaining program is also same.

Thanks,

shyla