i sow here exmple of working with dynamic table
but i didnt find any example of modify .
most of the example is like :
select * into table <dyn_table>
from (p_table).
but i need to do like (example):
SELECT SINGLE BUDAT USNAM FROM MKPF
INTO (<dyn_table>-BUDAT , <dyn_table>-USNAM )
WHERE MBLNR = IT_YMM_ST_TNUOT_MLY-MBLNR
AND MJAHR = IT_YMM_ST_TNUOT_MLY-MJAHR
AND BUDAT IN SL_BUDAT .
i get message that i cant do it .
how can i do it ?
2 Answers
-
Best Answer
Former MemberPosted on Oct 11, 2006 at 10:21 AMu cant do like that,
u have to do it by using assign component.
declare
tables: mkpf.
field-symbols: <fs> type any, <fs1> type any.
select single budat usnam from mkpf where mjahr = ....
and budat in sl_budat.
assign component budat of structure <dyn_table> to <fs>.
<fs> = mkpf-budat.
assign component usnam of structure <dyn_table> to <fs1>.
<fs1> = mkpf-usnam.
Add a comment
Add a comment