help in SQL syntax

Former Member — Mon, 13 Nov 2006 07:13:19 GMT

SELECT MARA_{MATNR MARA}PRDHA MARA_{MEINS MARD}LGORT

MARD_{LABST MARD}INSME

INTO CORRESPONDING FIELDS OF TABLE ITAB_TEM_NORMAL

FROM MARA INNER JOIN MARC ON MARC_{MATNR = MARA}MATNR

INNER JOIN MARD ON MARD_{MATNR = MARA}MATNR

INNER JOIN MSEG ON MSEG_{MATNR = MSEG}MATNR

INNER JOIN MKPF ON MKPF_{MBLNR = MSEG}MBLNR

WHERE MARA~MATNR IN Z_MATNR

AND MARA_{SPART IN Z_SPART AND MARA}MATKL IN Z_MATKL

AND MARA_{MTART IN Z_MTART AND MARA}PRDHA IN Z_PRDHA

AND MARC_{EKGRP IN Z_EKGRP AND MARC}DISPO IN Z_DISPO

AND MARD~LGORT IN STR_LOC1

AND MKPF~BUDAT IN SHIP_D

AND NOT MARD~LGORT IN ('L001','L002','L003','V001','V002','V003')

AND ( MSEG~BWART IN ('901','902','101','102','106','105') AND

MSEG_{LGORT = 'L002') OR ( MSEG}BWART IN ('311','312') AND

( MSEG_{LGORT = 'L001' OR MSEG}UMLGO = 'L001')).

ENDFORM.

what's wrong with above coding? it said "(" has no closing ")".

thx

Re: help in SQL syntax

Former Member — Mon, 13 Nov 2006 07:21:14 GMT

It seems you have an error:

INNER JOIN MSEG ON MSEG_{MATNR = MSEG}MATNR

haven't you ment

INNER JOIN MSEG ON MSEG_{MATNR = MARA}MATNR

Regarding syntax error perhaps you should put a space between two closing brackets et the end of your statement...

Former Member — Mon, 13 Nov 2006 07:25:33 GMT

thanks for pointing out the error.. n thx4 the help