ABAP SQL Doubt

[Former Member]

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

S1

S3

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.

[Former Member]

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

S1

S3

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.

[RichHeilman]

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

[Former Member]

HI Tushar,

Check this code.

SELECT REQFLAG

FROM ZCONFIG

INNER JOIN T_ZCONFIG

ON T_ZCONFIG_{XNAME = ZCONFIG}FNAME

INTO TABLE ITAB

WHERE ......

[Former Member]

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.