reg select statements

[Former Member]

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]

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]

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