Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unknown Column Name "XYZ" not detemined untill runtime.Select query.


I have written a query in ABAP.I am getting following error.Can some one help me resolve this.There is a column "LANDX" in standard table T005 of PI which i need to get values from. The problem is that the column is visible only at runtime and not otherwise.How can i fetch data from this coulmn writing a select query for this.

Query written is:

SELECT landx from T005 into table it_t005.


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

Former Member
Former Member replied

Hi Deepika u were right. that there is a landx field but it is included in that table.

so u cant exactly get it.

now u can get ur country name and iso code just like this.

tables: t005t  , t005.
data: BEGIN OF it OCCURS 100,
        landx like t005t-landx, 
        intca like t005-intca,
        END OF it.

SELECT t005t~landx t005~intca   into CORRESPONDING FIELDS OF TABLE it
  from T005t
  INNER JOIN t005 on ( t005t~land1 = t005~land1 ).

it is fulfilling ur need.

Edited by: Matt on Feb 3, 2009 7:49 AM - Please don't use txtspk

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question