topic Re: concatenate in Application Development and Automation Discussions

concatenate

Former Member — Fri, 12 Dec 2008 17:56:58 GMT

I have 3 fields in table p0021 (FAMSA, FANAM and FAVOR). I need concatenate this tree fields ins one string, igual this example

v_string = '   1FERREIRA                               MARCOS', but, when I concatena with comand

CONCATENATE p2001-famsa p2001-fanam p2001-favor INTO v_string, the result is

v_string = '1FERREIRAMARCOS'.

How to solve this problem? I work in version 4.6C of SAP.

Tks,

Marcos Ferreira

Edited by: Marcos Abreu Ferreira on Dec 12, 2008 6:57 PM

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:00:06 GMT

Use Respective blanks with Concatenate

REPORT test.

data:field1 type char15 VALUE 'Amit',
      field2  type char15 VALUE 'Gujargoud',
result type char30 .
CONCATENATE field1 field2 INTO result RESPECTING BLANKS.
write result.

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:13:13 GMT

If the below command is not supported :

CONCATENATE field1 field2 INTO result RESPECTING BLANKS.

then you may want to use

CONCATENATE field1 field2 INTO result separated by SPACE .

Here instead of space , you can use a varaible and introduce multiple spaces .

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:13:29 GMT

RESPECTING BLANKS don´t exists in 4.6C.

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:19:00 GMT

CONCATENATE field1 field2 INTO result SEPARATED BY space.

This Is SAP help(F1) Example from 4.6

REPORT test.

DATA: ONE(10)   VALUE 'John',
      TWO(3)    VALUE 'F.',
      THREE(10) VALUE 'Kennedy',
      NAME(20).
CONCATENATE ONE TWO THREE INTO NAME SEPARATED BY SPACE.
write name.

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:20:26 GMT

The field has 40 positions eacch, I need 40-len(field) spaces between fields. This is the correctly result

'   1FERREIRA                               MARCOS                                  '

Edited by: Marcos Abreu Ferreira on Dec 12, 2008 7:21 PM

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:23:04 GMT

REPORT test.

DATA: ONE(10)   VALUE 'John',
      TWO(3)    VALUE 'F.',
      THREE(10) VALUE 'Kennedy',
      NAME(150),
      blank(40) .
CONCATENATE ONE TWO THREE INTO NAME SEPARATED BY blank.
write name.

Re: concatenate

former_member156446 — Fri, 12 Dec 2008 18:24:34 GMT

v_string = ' 1FERREIRA MARCOS', but, when I concatena with comand

CONCATENATE p2001-famsa p2001-fanam p2001-favor INTO v_string, the result is

v_string = '1FERREIRAMARCOS'.

you can try this:

V_string+0(12) = p2001-famsa

V_string+13(40) = p2001-fanam   "check the field length and then use 40 or **

v_string+54(40) =  p2001-favor

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:25:44 GMT

try to use OFFSETTING, but before that, u need to find out the correct SPACE positions in each field........dont use constant values for offsetting,meaning, it shuld b variable, like offsettest+x(y).

At the same point of secong, me and JAY was posted!! i did not see his reply, bfor am starting to write!!

thanq

Edited by: SAP ABAPer on Dec 12, 2008 7:26 PM

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:26:28 GMT

DATA: ONE(10) VALUE 'John',

TWO(3) VALUE 'F.',

THREE(10) VALUE 'Kennedy',

NAME(100),

blank(40) .

CONCATENATE ONE TWO THREE INTO NAME SEPARATED BY blank.

write name.

ONE has 4 caracteres, I need 36 spaces. THREE has 7 caracters, I need 33 spaces. That is the problem...

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:27:10 GMT

Hi,

Before you concatenate the string, fill the empty blanks with a dummy character say * or #. Use replace SPACE with # statment.

Sam########...

Mills############...

Then concatenate the 3 fields into the string.

Sam########...Mills############...

Then again replace the special characte with SPACE. so that you will get the desired result.

Sam ....Mills ....

regards,

Advait

regards,

Advait

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:28:19 GMT

Okay Than User Coversion Exit Before Concatenating.

Re: concatenate

former_member156446 — Fri, 12 Dec 2008 18:28:41 GMT

Hi check the solution I posted.. that should solve ur issue, which will respect the spaces..

use strlen command to find the string length..

data: lv_len(2) type i.

lv_len = strlen( p_wa-field ).

Re: concatenate

former_member194669 — Fri, 12 Dec 2008 18:31:25 GMT

Try this way


types : begin of t_string.
data :  famsa like p0021-FAMSA, 
        FANAM like p0021-fanam,
        FAVOR like p0021-favor.
types : end of t_string.

data : wa_string type t_string.
move : p0021-famsa to wa_string-famsa,
       p0021-fanam to wa_string-fanam,
       p0021-favor to wa_string-favor.

move wa_string to v_string.

a®

Re: concatenate

Former Member — Fri, 12 Dec 2008 18:32:31 GMT


ONE has 4 caracteres, I need 36 spaces. THREE has 7 caracters, I need 33 spaces. That is the problem...

Make a structure having all the fields with the length of 40

types :

begin of name,

fname(40) type c,

mname(40) type c,

lname(40) type c,

end of name.

Now if you move the respective fields to fname, mname and lname, each of the field will have a length of 40 with required blanks.

Then use the above logic of replacing the space with * or # and so on.

regards,

Advait

Edited by: Advait Gode on Dec 12, 2008 7:32 PM

Re: concatenate

Former Member — Fri, 12 Dec 2008 19:05:39 GMT

perfect J@Y

tks