Skip to Content
0
Former Member
Feb 10, 2008 at 11:16 AM

Can anybody help me to check my code !

14 Views

In my following code I am getting data repeatedly !

please help me to correct it.

SELECT

VBAP~VBELN

VBAP~POSNR

VBAP~MATNR

VBAP~VKAUS

VBAP~SPART

VBAP~NETWR

VBAP~WAERK

VBAP~KWMENG

VBAP~KONDM

VBAP~MVGR1

VBAP~MVGR2

VBAP~MVGR3

VBAP~MVGR4

VBAP~MVGR5

VBKD~KONDA

VBKD~BSTDK

VBKD~BSTDK_E

VBKD~KDKG2

FROM VBAP AS VBAP JOIN VBKD AS VBKD

ON VBAPVBELN EQ VBKDVBELN

INTO CORRESPONDING FIELDS OF TABLE I_ITEM

WHERE VBAP~VBELN EQ S_VBELN

and vbap~matkl NOT IN r_matkl.