topic Re: reg select statements in Application Development and Automation Discussions

reg select statements

Former Member — Thu, 19 Apr 2007 11:54:21 GMT

hi,

i had to select swenr,smenr,refno,xmetext from vimi01 on condition cnj_stat-sttxt_int = 'create port zoud'.

cnj_stat-sttxt_int is a structure field.

can any body provide solution.

thanks in advance

siva

Former Member — Thu, 19 Apr 2007 12:01:13 GMT

Hi Siva,

Write the select query like,

select swenr,smenr,refno,xmetext from vimi01 into table it[it name] where nj_stat-sttxt_int = 'create port zoud'.

Thanks.

Reward If Helpful.

Former Member — Thu, 19 Apr 2007 12:09:30 GMT

Hi,

<b>The status Text of the field (sttxt_int ) are stored in TJ02T tables and status is stored in JEST table.

So you have to join VIMI01 with JEST and TJ02T tables for this.

select a_{swenr a}smenr a_{refno a}xmetext into table itab

from vimi01 as a join jest as b on

a_{sadrme = b}objnr join Tjo2T as c on b_{stat = c}istat

where c_{text30 = 'create port zoud' and c}spras = sy-langu.</b>

Reward points if useful

regards,

ANJI