Skip to Content
0

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

Jun 25, 2017 at 07:08 PM

47

avatar image

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.....

capture.png (2.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers