topic Re: select single in Application Development and Automation Discussions

select single

Former Member — Wed, 31 Oct 2007 16:31:32 GMT

hi,

i wont to now what is doing this select because it didn't have into




   SELECT SINGLE * 
   FROM tadir
    WHERE pgmid = 'R3TR'
     AND object = 'PROG'
     AND obj_name = tstc-pgmna.

Regards

Re: select single

Former Member — Wed, 31 Oct 2007 16:34:05 GMT

This select statement places the d/b table entry in the TABLES work area declared using the TABLES: TADIR statement

Re: select single

naimesh_patel — Wed, 31 Oct 2007 16:34:09 GMT

It will select the data from the TADIR into TADIR workarea ... you can access the data like TADIR-PGMID.

Regards,

Naimesh Patel

Re: select single

Former Member — Wed, 31 Oct 2007 16:38:38 GMT

Hi,

Just check out there might be a endselect statement, in between select & endselect statement there might be some statement getting executed to move the data to internal table.

Satish

Message was edited by:

Alvaro Tejada Galindo

Re: select single

harimanjesh_an — Wed, 31 Oct 2007 17:33:04 GMT

hi ricardo,

This type of SELECT statements are helpful in validations.

Example consider u have parameter or select-options statement for WERKS which takes input from user. In this case, u want to validate the input value. In such cases, we can use SELECT statement without INTO clause......

Example.:

PARAMETERS : p_werks TYPE marc-werks.

SELECT SINGLE *

FROM t001w

WHERE werks = p_werks.

IF sy-subrc <> 0.

MESSAGE 'Invalid Plant' TYPE 'I'.

ENDIF.

Like this, we can validate user input for plant.

Harimanjesh AN

Message was edited by:

Alvaro Tejada Galindo

Re: select single

former_member656234 — Wed, 31 Oct 2007 17:41:19 GMT

Hi,

SELECT SINGLE returns just one row from a table and store it in a working area, so thats why you don't need an ENDSELECT...

Now, if you have a definition like

TABLES: tadir.

It define a waorking area for table 'tadir' with the same name... and that's why you don't need an INTO clause in your SELECT statement.

cya,

dimas.

Re: select single

Former Member — Wed, 31 Oct 2007 20:50:24 GMT

It defines a Header area internally (not Work Area) and you can make use of TADIR-<field1> to acces the fields.