topic Re: pls help in Application Development and Automation Discussions

pls help

Former Member — Thu, 08 Sep 2005 08:17:41 GMT

hi all,

Im loading sales transaction in text format where roughly containing 1000 lines, and its going to run in background every night using BAPI.

The inbound file looks like these:

I,"20050808","ZA","10","customer po".

I am facing difficulty to map those each field to my internal table as the actual data looks funny with the code " ".

For your information, as per requirement, we cant change the text format, thats the current format that has to be read from server and loaded to transaction code VA01.

What is the quickes way to remove the code " "? Any idea will be really helpful.

many thanks.

Alia

Re: pls help

Former Member — Thu, 08 Sep 2005 08:22:08 GMT

Alia,

Did you try this in your program that picks up the file? Before passing to the BAPI use the REPLACE command and removed the "".

REPLACE

[ FIRST OCCURRENCE OF | ALL OCCURRENCES OF ]

[ SUBSTRING ] old

IN [ SECTION OFFSET off LENGTH len OF ] text

WITH new.

Regards,

Ravi

Re: pls help

Former Member — Thu, 08 Sep 2005 08:31:22 GMT

The following may help you

split <C> at <del> into C1 C2 C3...

The system searches the field <c> for the separator <del>. The parts before and after the separator are placed in the target fields <c1> ... <cn>.

To place all fragments in different target fields, you must specify enough target fields. Otherwise, the last target field is filled with the rest of the field <c> and still contains delimiters.

You can use ' " ' in place of <del>

Re: pls help

guillaume-hrc — Thu, 08 Sep 2005 08:32:34 GMT

Make sure that your business do not use the code " " as content for the fields !! Otherwise, the REPLACE statement could be hazardous...

One way to do it would be to use the SPLIT ... INTO TABLE statement to cut each line on the "," character and then remove the leading and tailing code " " for each entry in the table.

That is not ideal anyway, for the coma is much more often used in the data that the code " "

Re: pls help

andreas_mann3 — Thu, 08 Sep 2005 08:33:33 GMT

Hi,

try this:

1) read file into wa

2) manipulate every field of your wa with :

assign component sy-index of structure wa to <f>.
   translate <f> using '" '.
   shift <f> by 1 places left.

Andreas

Re: pls help

Former Member — Thu, 08 Sep 2005 09:02:08 GMT

Hi,

Many thanks for all. I will try to manipulate in the loop.

alia

Re: pls help

Former Member — Thu, 08 Sep 2005 09:14:27 GMT

Alia,

Please do NOT forget to reward points. It is one of the motivation factors we all have to answer queries.

Regards,

Ravi