Skip to Content
0
Former Member
Oct 14, 2005 at 01:18 PM

Data declaration for result of dynamic query

15 Views

Good day,

can you help me with declaration of data for query result that can be from any columns of any tables.

For example (this is from SAP documentation):

DATA: wa TYPE spfli,

ftab TYPE TABLE OF STRING.

APPEND 'CITYFROM' TO ftab.

APPEND 'CITYTO' TO ftab.

SELECT DISTINCT (ftab)

FROM spfli

INTO CORRESPONDING FIELDS OF wa

WHERE

carrid = 'LH'.

WRITE: / wa-cityfrom, wa-cityto.

ENDSELECT.

This is clear to me, but I don't know how to do in case FROM clause is generated dynamically too.

SELECT DISTINCT (ftab)

FROM (tab1)

Thanks