Wednesday, October 12, 2005

[BW] Select variable table for different system

CASE SY-HOST.
WHEN 'ABIW3'.
I_TABNAME = '/1FB/MD___2S003L'.
WHEN 'ABIW2'.
I_TABNAME = '/1FB/MD___2S003J'.
WHEN 'ABIW1'.
ENDCASE.
......
SELECT * INTO CORRESPONDING FIELDS OF TABLE I_CS_ITEM
FROM (I_TABNAME) WHERE AREA = 'L1'.