topic Re: Select Statement in Application Development and Automation Discussions

Select Statement

Former Member — Thu, 26 Mar 2009 04:25:55 GMT

HI All,

I want to get three field values from the Table.

Select single Field1 fields from X_Table into X_Field1 X_field2 where Field3 = 'YYYYYY'.

I tried to get two field values Field1 and Field2 to the X_Field1 X_field2(Variables)

I am getting error.

how to use the syntex.

Thanks in advance.

Bye

sha

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:29:36 GMT

Hi,

Check the below code,...

Select single Field1 Field2 from X_Table into (X_Field1, X_field2) where Field3 = 'YYYYYY'

Thanks!

Brunda

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:30:38 GMT

Hi,

Try like this...


    SELECT SINGLE <fld1>
                  <fld2>
                  FROM <table>
                  INTO (<fld1>,<fld2>)      "<-----variables
                  WHERE <conditions>.

Re: Select Statement

GauthamV — Thu, 26 Mar 2009 04:30:44 GMT

Plz SEARCH in SCN before posting basic questions.

You can get such information from SAP help also.

Use something like this.


tables : e070,e071.

SELECT SINGLE trkorr
                 trstatus
                 as4user
                 as4date
                 as4time
                   FROM e070
                   INTO
                   (e070-trkorr,
                 e070-trstatus,
                 e070-as4user,
                 e070-as4date,
                 e070-as4time)
                   WHERE trkorr = e070-trkorr.

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:30:46 GMT

Hi,

You have to declare 3 variables of those types in which you

want your selected fields value to come like:



data: v_field1(15),
        v_field2(15),
        v_field2(15).

Then give your select query like:

SELECT SINGLE FIELD1 FIELD2 FIELD3 FROM TABLE NAME INTO 
(V_FIELD1) (V_FIELD2) (V_FIELD3) WHERE YOUR CONDITION.

Hope it helps

Regards

Mansi

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:30:56 GMT

Hi,

can you tell more specific, that is table name and field name so that i can help u.

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:34:17 GMT

Hi,


select  field1 field2 from X_Table into (X_Field1, X_Field2) where Field3 = 'YYYYYY'

Regards

Arun

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:51:16 GMT

Thanks to all.

Re: Select Statement

Former Member — Thu, 26 Mar 2009 04:51:46 GMT

hi do like this,

SELECT SINGLE field1, field2 FROM table

INTO (<field1>,<field2>)

WHERE condition = yyyyyy.

please provide ur code and error. so that wecan help u more.

if resolved plz close the thread.