Skip to Content
0

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

Oct 22, 2017 at 09:50 AM

1.2k

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Horst Keller
Oct 22, 2017 at 10:13 AM
1

There simply is no column ltext in tcurc, or?

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Probably saw it in SE16...

2

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.

1

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

0

That's clear, even to me ...

1