topic Select statement in Application Development and Automation Discussions

Select statement

Former Member — Fri, 11 Jul 2008 04:38:40 GMT

Hi All,

I want to fetch language based on Region.How to do it.

u201CEu201D u2013 for English for all customers where field Region on ADDR1_DATA / REGION is not equal to 'CT'. Else u201CFu201D.

How to get it.

Regards,

Sai

Re: Select statement

former_member188827 — Fri, 11 Jul 2008 04:43:37 GMT

select single regio from kna1 into zregion where kunnr eq zkunnr.

if zregion ne 'CT'.

zlang = 'E'.

else.

zlang = 'F'.

endif.

Re: Select statement

Former Member — Fri, 11 Jul 2008 04:44:49 GMT

Hi Sudha,

Try this way :

Select <field-names>
    from <table name>
    into  <itab name>.

Loop at itab.

    if addr1-data/region ne 'CT'.
           
        Write :/ 'English Customers'.

    else.

         Write :/ 'French Customers'.

    endif.

endloop.

Reagrds,

Swapna.

Re: Select statement

Former Member — Fri, 11 Jul 2008 04:45:29 GMT

Hi Sudha,

Try the following:

Select <language>

from <table>

into table <itab>

for all entries in <itab2>

where region eq 'CT'.

<language> - language field

<table> - database table

<itab> - internal table with language field

<itab2> - internal table with customer numbers

Hope this helps you.

Regards,

Chandra Sekhar

Re: Select statement

Former Member — Fri, 11 Jul 2008 04:49:37 GMT

hi,

You can try this.

select distinct <lang> <region>
from <table>
into table <itab>
for all entries in <itab2>
where region EQ <itab2>-region.

Hope this will help.

Regards

Sumit Agarwal

Re: Select statement

Former Member — Fri, 11 Jul 2008 04:53:01 GMT

Hi Sudha,

Check this out;-

Select language
   from dbtab
into table tab2
for all entries in tab1
where region ne 'CT'.

Here,

itab1 - internal table with customer number

itab2 - internal table with language

Regards,

Bhumika