topic Re: Dynamic Concatenation in Application Development and Automation Discussions

Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 02:51:08 GMT

Hi all

How to have a dynamic concat where user can specify wad fields to concat?

Below code are static and hardcoded where i specify the fields in my program. How to make the field dynamic in the sql statement?

code----

Select fname lname into (value1, value2) from ZSTUDGARY where

admino = '012345'.

endselect.

CONCATENATE value1 value2 INTO NAME.

write:/ name.

Re: Dynamic Concatenation

former_member189059 — Thu, 11 Oct 2007 03:14:57 GMT

one method i can think of is to set a flag for each value (value1, value2 etc)

use if conditions in the concatenate statement

name = ''.
if name1_flag = 'X'.
concatenate name name1 into name.
endif.
if name2_flag = 'X'.
concatenate name name2 into name.
endif.

Re: Dynamic Concatenation

former_member189059 — Thu, 11 Oct 2007 03:17:41 GMT

sorry, because of my unstable net connection, the reply got posted twice

Message was edited by:

Kris Donald

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:24:58 GMT

HI,

see this code.

PARAMETERS:field1(30).

PARAMETERS:field2(30).

DATA:fld_list type string,value1(30),value2(30),val type string.

CONCATENATE field1 field2 INTO fld_list SEPARATED BY space.

SELECT (fld_list) into (value1,value2) from mara.

CONCATENATE value1 value2 into val.

write:/ val.

ENDSELECT.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:25:29 GMT

I think u mistaken my requirement.

I want to concat the field dynamic

select fname lname into (value1, value2) from student where admino = '123'

i wan to make the bold to be dynamic where user can specify the field

fname and lname is not the table field. There are the parameter value.

fname = 'firstname'

lname = 'lastname'

firstname and lastname is the table fields.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:30:33 GMT

Hi i check yr code but i receive this error

"FLD_LIST" is not an internal table.

How to resolve it?

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:31:58 GMT

HI,

check the code as it is.i have checked it on my system it is working fine.

if u have a problem still post ur code here.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:33:50 GMT

Below is my code. I execute but still receive the syntax error say "FLD_LIST" is not an internal table.

REPORT ZGARY_CONCAT1 .

PARAMETERS:field1(30).

PARAMETERS:field2(30).

DATA:fld_list type string,value1(30),value2(30),val type string.

CONCATENATE field1 field2 INTO fld_list SEPARATED BY space.

SELECT (fld_list) into (value1,value2) from ZSTUDGARY.

CONCATENATE value1 value2 into val.

write:/ val.

ENDSELECT.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:38:40 GMT

HI,

here it is working fine for me.is ZSTUDGARY a data dictionary table.

if so it will work surely.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:39:41 GMT

Hi,

Put the field which you want into an internal table. then use the select query, like this

select (itab1) from into (value1, value2) from student where admino = '123'.

For example.

Data: f_bsec_sel(40) type c,

lt_bsec_sel like table of f_bsec_sel.

append 'BUKRS' to lt_bsec_sel.

append 'BELNR' to lt_bsec_sel.

append 'GJAHR' to lt_bsec_sel.

append 'BUZEI' to lt_bsec_sel.

select (lt_bsec_sel) from bsec

into corresponding fields of table lt_bsec

for all entries in it_items

where bukrs = it_items-bukrs

and belnr = it_items-belnr

and gjahr = it_items-gjahr

and buzei = it_items-buzei.

Regards,

Niyaz

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:42:16 GMT

ZSTUDGARY is my create table in database.

I using R3 for my abap.

Is there a possibility that the sql statement cant recognize the below statement

SELECT (fld_list) into (value1, value2) from ZSTUDGARY.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:46:20 GMT

HI,

no chance.it will surely work.

i used it many times.check using some system table like MARA.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:46:37 GMT

Hi,

I think the problem is not with the ZSTUDGARY table. it with the query. try to create an internal table and use the select query like this.

data: lt_ZSTUDGARY type standard table of ZSTUDGARY.

SELECT (fld_list) into corresponding fields of table lt_zstudgary from ZSTUDGARY.

regards,

Niyaz

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:48:53 GMT

HI,

can u write ur full code.i am curious to know how ur code works.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:51:43 GMT

Hi Gary ,

The replace of the fields in the where clause must be an internal table ,.

Here is a small example for the same

data : select1 type table of EDPLINE ,
        wa_sel type edpline .

DATA : V1(30) ,
      V2(3).

wa_sel = 'MATNR'.
APPEND WA_SEL TO SELECT1.

wa_sel = 'WERKS'.
APPEND WA_SEL TO SELECT1.


SELECT (SELECT1) INTO (V1 , V2)
FROM MARC.
BREAK-POINT.
ENDSELECT

for more info you can also check the link

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/840ad679-0601-0010-cd8e-9989fd650822#q-16

Regards

Arun

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:52:58 GMT

This is my entire code. My sytnax prompt for "FLD_LIST" is not an internal table.

REPORT ZGARY_CONCAT1.

PARAMETERS:field1(30).

PARAMETERS:field2(30).

DATA: fld_list type string,

value1(30),

value2(30),

val type string.

CONCATENATE field1 field2 INTO fld_list SEPARATED BY space.

SELECT (fld_list) into (value1, value2) from ZSTUDGARY.

CONCATENATE value1 value2 into val.

write:/ val.

ENDSELECT.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 03:53:11 GMT

Hi,

try this code otherwise.

TABLES: VBAK.

DATA: it_vbak TYPE TABLE OF vbak WITH HEADER LINE,

wa_fld(72) TYPE C,

it_fldtab LIKE TABLE OF wa_fld.

wa_fld = 'VBELN'.

APPEND wa_fld TO it_fldtab.

wa_fld = 'VBTYP'.

APPEND wa_fld TO it_fldtab.

wa_fld = 'AUDAT'.

APPEND wa_fld TO it_fldtab.

SELECT (it_fldtab)

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM VBAK.

IF SY-SUBRC = 0.

LOOP AT it_vbak.

write:/ it_vbak-vbeln, it_vbak-vbtyp, it_vbak-audat.

ENDLOOP.

ENDIF.

rgds,

bharat.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 04:01:22 GMT

yes is working but hw to take in from the parameter dynamic. like i only wan the admino and fname only not the lname.

REPORT ZGARY_CONCAT1.

TABLES: ZSTUDGARY.

DATA: it_vbak TYPE TABLE OF ZSTUDGARY WITH HEADER LINE,

wa_fld(72) TYPE C,

it_fldtab LIKE TABLE OF wa_fld.

wa_fld = 'ADMINO'.

APPEND wa_fld TO it_fldtab.

wa_fld = 'FNAME'.

APPEND wa_fld TO it_fldtab.

wa_fld = 'LNAME'.

APPEND wa_fld TO it_fldtab.

SELECT (it_fldtab)

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM ZSTUDGARY.

IF SY-SUBRC = 0.

LOOP AT it_vbak.

write:/ it_vbak-admino, it_vbak-fname, it_vbak-lname.

ENDLOOP.

ENDIF.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 04:05:10 GMT

Hi,

try this code.

TABLES: ZSTUDGARY.

PARAMETERS:field1(30).

PARAMETERS:field2(30).

DATA: it_vbak TYPE TABLE OF ZSTUDGARY WITH HEADER LINE,

wa_fld(72) TYPE C,

it_fldtab LIKE TABLE OF wa_fld.

if not field1 is initial.

wa_fld = field1.

APPEND wa_fld TO it_fldtab.

endif.

if not field1 is initial.

wa_fld = 'ield2.

APPEND wa_fld TO it_fldtab.

endif.

SELECT (it_fldtab)

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM ZSTUDGARY.

IF SY-SUBRC = 0.

LOOP AT it_vbak.

write:/ it_vbak-admino, it_vbak-fname, it_vbak-lname.

ENDLOOP.

ENDIF.

Re: Dynamic Concatenation

Former Member — Thu, 11 Oct 2007 04:07:39 GMT

HI,

try this.

TABLES: ZSTUDGARY.

PARAMETERS:field1(30).

PARAMETERS:field2(30).

DATA: it_vbak TYPE TABLE OF ZSTUDGARY WITH HEADER LINE,

wa_fld(72) TYPE C,

it_fldtab LIKE TABLE OF wa_fld.

APPEND field1 TO it_fldtab.

APPEND field2 TO it_fldtab.

SELECT (it_fldtab)

INTO CORRESPONDING FIELDS OF TABLE it_vbak

FROM ZSTUDGARY.

IF SY-SUBRC = 0.

LOOP AT it_vbak.

write:/ it_vbak-admino, it_vbak-fname, it_vbak-lname.

ENDLOOP.

ENDIF.

rgds,

bharat.