topic Re: select query ? in Application Development and Automation Discussions

select query ?

Former Member — Wed, 18 Mar 2009 10:58:34 GMT

I wish to select the text from this table ATEXT but my query is not working please guide.

table:taplp.

CLEAR : taplp.

SELECT SINGLE *

FROM taplp

WHERE appl = wa_zprohdr-appl.

write: taplp-appl,taplp-ATEXT.

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:01:15 GMT

Check your select query properly

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:01:26 GMT

table taplp

does not have ATEXT field but have KTEXT

Re: select query ?

Sandeep_Panghal — Wed, 18 Mar 2009 11:02:17 GMT

Do you have an entry in the table with wa_zprohdr-appl.???

Re: select query ?

I355602 — Wed, 18 Mar 2009 11:02:17 GMT

Hi,


> I wish to select the text from this table ATEXT but my query is not working please guide.
> 
>   table:taplp.
> 
>   CLEAR : taplp.
>     SELECT SINGLE *
>       FROM taplp
>       WHERE appl = wa_zprohdr-appl.
> 
> 
> 
> write: taplp-appl,taplp-ATEXT.

Make sure that the parameter wa_zprohdr-appl has a valid value.

Also check the data in database table for the passing value entry.

Hope this helps you.

Regards,

Tarun

Re: select query ?

awin_prabhu — Wed, 18 Mar 2009 11:02:39 GMT

hi,

Declare 'taplp' with header line

loop at taplp into wa.

write: wa-appl,wa-ATEXT.

endloop.

Re: select query ?

sarbajitm — Wed, 18 Mar 2009 11:03:21 GMT

table:taplp.

CLEAR : taplp.

SELECT SINGLE *

FROM taplp

WHERE appl = wa_zprohdr-appl.

write: taplp-appl,taplp- KTEXT.

Notice the change.

Regards

Edited by: Sarbajit Majumdar on Mar 18, 2009 4:33 PM

Re: select query ?

matteo_montalto — Wed, 18 Mar 2009 11:03:46 GMT

please provide some more info. E.g., what's the sy-subrc code after that select? are you sure that wa_zprohdr-appl has a proper value @ runtime?

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:05:05 GMT

dont use tables it is obsolete.

use as

data: it_taplp type of taplp.


SELECT SINGLE *
FROM taplp
into taplp
WHERE appl = wa_zprohdr-appl.

кu03B1ятu03B9к

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:05:33 GMT

table:taplp.

CLEAR : taplp.

SELECT SINGLE *

FROM taplp.

write: taplp-appl,taplp-ATEXT.

Re: select query ?

former_member222860 — Wed, 18 Mar 2009 11:06:01 GMT

Check

tables:taplp.

SELECT SINGLE appl atext 
into (taplp-appl, taplp-atext)
FROM taplp
WHERE appl = wa_zprohdr-appl.


write: taplp-appl,taplp-atext.

Edited by: Mahesh Reddy on Mar 18, 2009 12:06 PM

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:07:02 GMT

The field name is not ATEXT its KTEXT.

table:taplp.

CLEAR : taplp.
SELECT SINGLE *
FROM taplp
" into <workarea> missing
WHERE appl = wa_zprohdr-appl.

thanks

sarves

Re: select query ?

Former Member — Wed, 18 Mar 2009 11:09:18 GMT

have used another table TAPLT & yes table TAPLP also have ATEXT please see.