topic Re: select statement issue in Application Development and Automation Discussions

select statement issue

Former Member — Thu, 14 Jun 2007 06:52:18 GMT

Is it possible to write select st like

select field1 field2 from tab

i want to combine <b><b>field1 and field2</b> into single field</b> in result

Thanks

Venkat

Re: select statement issue

Former Member — Thu, 14 Jun 2007 06:54:18 GMT

Hi,

Yes..some how it can be achieved..

DATA: BEGIN OF WA,

FIELD1,

FIELD2,

END OF WA.

SELECT FIELD1 FIELD2 INTO WA

FROM TABLE.

Now if you use WA ...the values are combined..

WRITE: / WA.

Please make sure to reward points for helpful answers..

Thanks

Naren

Re: select statement issue

Former Member — Thu, 14 Jun 2007 06:55:07 GMT

hi,

After selecting field1 and field2, concatenate both into Field3.

THanks,

Deepti

Re: select statement issue

former_member772790 — Thu, 14 Jun 2007 06:57:33 GMT

its not possible in the select statement it self.

u can achieve it after retrieving the data into the local fields only.

-Pesi.

Re: select statement issue

Former Member — Thu, 14 Jun 2007 06:57:57 GMT

Hi Deepti,

Thanks for your reply.

My requirement is the select statement itself combine 2 fields and assign to single variable.

Is it possible.

Thanks

Venkat

Re: select statement issue

Former Member — Thu, 14 Jun 2007 07:08:07 GMT

it is possible to represent the both fields in single field by just writing the complete WA rather than individual field as told by someone but provided the DATA TYPE shud permit. Bcos sometimes u will get a messij that the data type is not convertable....

Re: select statement issue

Former Member — Thu, 14 Jun 2007 07:15:01 GMT

Hi,

Can u be more clear.

What is the problem if u select first and then concatenate.

Thanks,

Deepti

Re: select statement issue

Former Member — Thu, 14 Jun 2007 07:24:35 GMT

In the below code i am using 2 loop . first concatenate the fields , then using select for all entries and againg one loop.

I want to fine tune this .

create a new internal table with the two fields..

data: begin of wa_obj,

loobj1 TYPE dfkklocks-loobj1,

gpart TYPE dfkklocks-gpart,

PROID TYPE dfkklocks-PROID,

LOCKR TYPE dfkklocks-LOCKR,

end of wa_obj.

data: t_obj like table of WA_OBJ.

data: t_obj_1 like table of WA_OBJ.

process the internal table to prepare the internal table T_OBJ.

loop at idfkkop into waDfkkop.

concatenate waDfkkop-opbel

waDfkkop-opupw

waDfkkop-opupk

waDfkkop-opupz

into w_loobj1.

wa_obj-loobj1 = w_loobj1.

wa_obj-gpart = waDfkkop-gpart.

append wa_obj to t_obj.

ENDLOOP.

if NOT T_OBJ[] Is initial.

Select the data from the database table.

SELECT PROID LOCKR LOOBJ1 GPART

INTO TABLE T_OBJ_1

FROM dfkklocks

FOR ALL ENTRIES IN T_OBJ

WHERE LOOBJ1 = T_OBJ-LOOBJ1

AND GPART = T_OBJ-GPART.

ENDIF.

loop at idfkkop into waDfkkop.

concatenate waDfkkop-opbel

waDfkkop-opupw

waDfkkop-opupk

waDfkkop-opupz

into w_loobj1.

READ TABLE LT_OBJ_1 INTO WA_OBJ

WITH KEY loobj1 = w_loobj1

gpart = waDfkkop-gpart.

if sy-subrc = 0.* modify idfkkop from waDfkkop.

endif.

clear w_loobj1.

endloop.

Thanks

Venkat