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."
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