Skip to Content

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

field symbol

Hi all,

I'm creating a applications for improving performance in which we break the any long join sql in to different small sql . for doing this firstlly i break a sql in to a short sql according to several conditions .

problem is that when i pass a sql in to a zfunction module then it back the result in a buffer table( means a table in which there is only one long field type CHAR4000 n whose 1st row specify that data for different fields is copy through offset .

like data for fields maramatnr n maramandt is

E-1006 800

E-1201 800

E-1202 800

E-1203 800

E-1203A 800

my requirement is that firstlly read that data in a fields symbol n provide that data for second sql as a where conditions n then next .

now i'm using that code

PERFORM FETCH_DATA1 TABLES DATA1 TABLE_STRUCTURE USING QLIST QFROM QWHERE.

FIELD-SYMBOLS: <WA> TYPE ANY,

<COMP> TYPE ANY.

READ TABLE DATA1 ASSIGNING <WA> .

regards,

Anuj

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