topic Problem in select statement in Application Development and Automation Discussions

Problem in select statement

Former Member — Mon, 16 Jul 2007 08:52:30 GMT

Hi guyz,

I need help on this one.

I was asked to create a new table named T9S20. it has mandt, kunnr, vkorg and vtweg fields in it. it is a maintanable table, so i set it as one.

however when i try to select fields on it, the internal table doesn't retrieve anything. I already put TS920 sample data which means it should be equal to 0,which means it has retrieved data.

here is the select statement that i coded.

SELECT kunnr vkorg vtweg

INTO table i_t9s20

FROM t9s20

WHERE kunnr = vbpa-kunnr.

i hope someone can help me.

thanks!

Re: Problem in select statement

Former Member — Mon, 16 Jul 2007 08:56:36 GMT

Hi,

Try like this,

<b>SELECT kunnr vkorg vtweg

INTO CORRESPONDING FIELDS OF table i_t9s20

FROM t9s20

WHERE kunnr = vbpa-kunnr.</b>

Regards,

Padmam.

Re: Problem in select statement

Former Member — Mon, 16 Jul 2007 08:56:59 GMT

Hi tina,

Maybe you are running on a client box without test data. For example client 130 for ABAP development only without test data & you also have a different client let's say client 150 for testing with data.

Hope it helps

Re: Problem in select statement

Former Member — Mon, 16 Jul 2007 08:57:17 GMT

Hi,

First select the data from VBPA. then use for all entries and in where condition specify as

<b>KUNNR = I_VBPA-KUNNR.</b>

Re: Problem in select statement

S0025444845 — Mon, 16 Jul 2007 08:59:52 GMT

Hi,

try with this.

select kunnr into it_vbfpa from vbpa.

if it_vbpa[] is not initial.

SELECT kunnr vkorg vtweg

INTO table i_t9s20

FROM t9s20

for all entries in it_vbpa

WHERE kunnr = it_ vbpa-kunnr.

endif.

regards,

sudha