How to replace obsolete tables and fields in inner join with new tables and fields

Hi Experts,

i have requirement on Inner join,

SELECT ZOBS1~ERNAM ZOBS1~MATNR ZOBS2~POSNR ZOBS2~MAKTX INTO TABLE IT_ZOBS1 FROM ZOBS1 INNER JOIN ZOBS2 ON ( ZOBS1~MATNR = ZOBS2~MATNR ) UP TO 50 ROWS.

ZOBS1, ZOBS2 are Obsolete Tables

ERNAM MATNR POSNR MAKTX -> obsolete fields

ZRP1 ZRP2 are new Tables,

ERNAM_N MATNR_N POSNR_N MAKTX_N are new fields

so now how to replace the old tables, fields with respective new tables and fields automatically.

please help me asap.....