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: 

Unknown column name not determined untill runtime,you cannot specify a field list.

Former Member

Hi,

I have written this query in ABAP (smartform):

SELECT SINGLE ltext
 INTO gv_currwords
 FROM tcurc
 WHERE waers = is_vbdka-waerk.

I am getting the following error.

"Unknown column name "ltext" not determined untill runtime,you cannot specify a field list."

Can some one help me resolve this.

Thank you.

1 ACCEPTED SOLUTION

horst_keller
Product and Topic Expert
Product and Topic Expert

There simply is no column ltext in tcurc, or?

6 REPLIES 6

horst_keller
Product and Topic Expert
Product and Topic Expert

There simply is no column ltext in tcurc, or?

matt
Active Contributor

Probably saw it in SE16...

horst_keller
Product and Topic Expert
Product and Topic Expert

Amazing, it is never too late to learn.

In fact, I never noticed that SE16 overeagerly selects more than actually demanded (as an excuse, I mostly write my own SELECTs in $TMPs instead of using SE16).

In this case, there's an additional SELECT * FROM TCURT.

@Yesmine, better use SE11 to see the truth. In order to achieve what you want to do, you have to join TCURC with TCURT. There's also a predefined view V_CURC that does the join for you.

matt
Active Contributor
0 Kudos

Additionally, she can see TCURT, by using menu option Goto->Text Table from within SE11 on TCURC.

horst_keller
Product and Topic Expert
Product and Topic Expert

That's clear, even to me ...

0 Kudos

The error message is not very clear though.