10-22-2017 10:50 AM
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-22-2017 11:13 AM
10-22-2017 11:13 AM
10-22-2017 1:28 PM
10-23-2017 7:22 AM
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.
10-23-2017 10:47 AM
Additionally, she can see TCURT, by using menu option Goto->Text Table from within SE11 on TCURC.
10-23-2017 10:50 AM
07-19-2021 1:46 PM