Skip to Content

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

Dynamic Concatenation

Hi all

How to have a dynamic concat where user can specify wad fields to concat?

Below code are static and hardcoded where i specify the fields in my program. How to make the field dynamic in the sql statement?

code----


Select <b>fname lname</b> into <b>(value1, value2)</b> from ZSTUDGARY where

admino = '012345'.

endselect.

CONCATENATE value1 value2 INTO NAME.

write:/ name.

Tags:
Former Member
Former Member replied

HI,

if field1 is NOT INITIAL.

append field1 to it_fldtab.

endif.

write like this for all 10 fields.

they don't need to be in the same order as they are in data base

rgds,

bharat.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question