Hi friends,
i want the correct syntax of the following query
SELECT ABEDAT AEBELN Bmatkl BWERKS BMATNR BTXZ01 ARESWK BMENGE B~EBELP
INTO CORRESPONDING FIELDS OF TABLE ITAB
FROM EKKO AS A INNER JOIN EKPO AS B ON AEBELN = BEBELN
WHERE a~reswk IN SUP_PLNT
and A~BEDAT IN STO_DATE
AND B~MATKL IN mat_grp
AND B~MATNR IN MAT_CODE
AND A~BSART = 'KRUB'.
thanks & regards
vallamuthu.M