select query ?

[Former Member]

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.

[Former Member]

Check your select query properly

[Former Member]

table taplp

does not have ATEXT field but have KTEXT

[Sandeep_Panghal]

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

[I355602]

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

[awin_prabhu]

hi,

Declare 'taplp' with header line

or

loop at taplp into wa.

write: wa-appl,wa-ATEXT.

endloop.

[sarbajitm]

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

[matteo_montalto]

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?

[Former Member]

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к

[Former Member]

table:taplp.

CLEAR : taplp.

SELECT SINGLE *

FROM taplp.

write: taplp-appl,taplp-ATEXT.

[former_member222860]

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

[Former Member]

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

[Former Member]

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