topic Re: ABAP SQL Doubt in Application Development and Automation Discussions

ABAP SQL Doubt

Former Member — Wed, 14 Dec 2005 20:22:47 GMT

Hi ABAP Gurus,

Please help me in solving following ABAP SQL doubt.

In the table Zonfig there are two fields: FNAME and REQFLAG

FNAME.....REQFLAG

S1...........X

S2...........X

S3..........._

S4...........X

Other table T_Zconfig has one field : XNAME

XNAME

Now I have to select REQFLAG from Zconfig table for the values of field XNAME in T_Zconfig table.

That is in this case for FNAME S1 and S2 in Zonfig I need to fetch REQFLAG since in XNAME in T_Zonfig we just have S1 and S2.

Points will be surly awarded...

Thanks.

Re: ABAP SQL Doubt

Former Member — Wed, 14 Dec 2005 20:23:38 GMT

Hi ABAP Gurus,

Please help me in solving following ABAP SQL doubt.

In the table Zonfig there are two fields: FNAME and REQFLAG

FNAME.....REQFLAG

S1...........X

S2...........X

S3..........._

S4...........X

Other table T_Zconfig has one field : XNAME

XNAME

Now I have to select REQFLAG from Zconfig table for the values of field XNAME in T_Zconfig table.

That is in this case for FNAME S1 and S3 in Zonfig I need to fetch REQFLAG since in XNAME in T_Zonfig we just have S1 and S3.

Points will be surly awarded...

Thanks.

Re: ABAP SQL Doubt

RichHeilman — Wed, 14 Dec 2005 20:27:35 GMT

Do a join...

Select zonfig~fname zonfig~regflag into table izonfig
      from zonfig
         inner join t_zconfig
            on zonfig~xname = t_zconfig~xname.

Regards,

Rich Heilman

Re: ABAP SQL Doubt

Former Member — Wed, 14 Dec 2005 20:30:33 GMT

try this

data: itab like Zonfig occurs 0 with header line.

data: v_xname like T_Zonfig-xname.

select xname into v_xname T_Zonfig.

seleect FNAME REQFLAG appending itab from Zonfig.

enselect.

Let me know if it helped.

Re: ABAP SQL Doubt

Former Member — Wed, 14 Dec 2005 20:32:58 GMT

HI Tushar,

Check this code.

SELECT REQFLAG

FROM ZCONFIG

INNER JOIN T_ZCONFIG

ON T_ZCONFIG_{XNAME = ZCONFIG}FNAME

INTO TABLE ITAB

WHERE ......