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.