Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

select query ?

former_member1349771
Participant
0 Kudos
226

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.

12 REPLIES 12

Former Member
0 Kudos
141

Check your select query properly

former_member228751
Contributor
0 Kudos
141

table taplp

does not have ATEXT field but have KTEXT

Sandeep_Kumar
Product and Topic Expert
Product and Topic Expert
0 Kudos
141

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

I355602
Advisor
Advisor
0 Kudos
141

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
Active Contributor
0 Kudos
141

hi,

Declare 'taplp' with header line

or

loop at taplp into wa.

write: wa-appl,wa-ATEXT.

endloop.

sarbajitm
Contributor
0 Kudos
141

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
Contributor
0 Kudos
141

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
0 Kudos
141

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
0 Kudos
141

table:taplp.

CLEAR : taplp.

SELECT SINGLE *

FROM taplp.

write: taplp-appl,taplp-ATEXT.

former_member222860
Active Contributor
0 Kudos
141

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
0 Kudos
141

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_member1349771
Participant
0 Kudos
141

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