Skip to Content
0
Former Member
Dec 28, 2007 at 10:06 PM

Dynamic select columns

25 Views

I have a Z_Temp table which has 51 colums like NKEY, NTEM001, NTEM002.... NTEM050. This table will be joined on Z_JOIN table (columns NOTE, TXT) ON NTEM*= NOTE.

( NTEM001 = NOTE, NTEM002 = NOTE, NTEM003 = NOTE .....)

For all NTEM* columns that are not initial, I need to get TXT column from Z_JOIN table and send it to a Sapscript form.

What is the best approach in doing this ?

Thanks.