problem in quaries

[Former Member]

Hi

I have made one program , the program has no syntax error and is running properly but in the extwg (external material group)I am not getting data . my queries are as follow

Plz help me its very urgent .

Regards

Rakesh

SELECT mara~matnr extwg werks xchar mtart matkl meins trame umlmc

bwesb glgmg "AC0K020254 "n912093

mara~lvorm as lvorm_mara

marc~lvorm as lvorm_marc

INTO CORRESPONDING FIELDS OF TABLE t_mat

FROM mara INNER JOIN marc

ON mara_{matnr = marc}matnr

for all entries in matnr

WHERE mara~matnr = matnr-low

AND extwg IN extwg

AND werks IN werks

AND mtart IN matart

AND matkl IN matkla

AND ekgrp IN ekgrup.

else.

END INSERT n_759412

SELECT mara~matnr extwg werks xchar mtart matkl meins trame umlmc

bwesb glgmg "AC0K020254 "912093

mara~lvorm as lvorm_mara

marc~lvorm as lvorm_marc

INTO CORRESPONDING FIELDS OF TABLE t_mat

FROM mara INNER JOIN marc

ON mara_{matnr = marc}matnr

WHERE mara~matnr IN matnr

AND extwg IN extwg

AND werks IN werks

AND mtart IN matart

AND matkl IN matkla

AND ekgrp IN ekgrup.

endif. "n759412

[Former Member]

Hi

I have made one program , the program has no syntax error and is running properly but in the extwg (external material group)I am not getting data . my queries are as follow

Plz help me its very urgent .

Regards

Rakesh

SELECT mara~matnr extwg werks xchar mtart matkl meins trame umlmc

bwesb glgmg "AC0K020254 "n912093

mara~lvorm as lvorm_mara

marc~lvorm as lvorm_marc

INTO CORRESPONDING FIELDS OF TABLE t_mat

FROM mara INNER JOIN marc

ON mara_{matnr = marc}matnr

for all entries in matnr

WHERE mara~matnr = matnr-low

AND extwg IN extwg

AND werks IN werks

AND mtart IN matart

AND matkl IN matkla

AND ekgrp IN ekgrup.

else.

END INSERT n_759412

SELECT mara~matnr extwg werks xchar mtart matkl meins trame umlmc

bwesb glgmg "AC0K020254 "912093

mara~lvorm as lvorm_mara

marc~lvorm as lvorm_marc

INTO CORRESPONDING FIELDS OF TABLE t_mat

FROM mara INNER JOIN marc

ON mara_{matnr = marc}matnr

WHERE mara~matnr IN matnr

AND extwg IN extwg

AND werks IN werks

AND mtart IN matart

AND matkl IN matkla

AND ekgrp IN ekgrup.

endif. "n759412

[Former Member]

Hi,

SELECT mara~matnr

mara_{extwg mara}werks mara_{xchar mara}mtart mara~matkl mara_{meins mara}trame mara~umlmc mara~bwesb "AC0K020254 "n912093

mara~lvorm as lvorm_mara

marc~lvorm as lvorm_marc

INTO CORRESPONDING FIELDS OF TABLE t_mat

FROM mara INNER JOIN marc

ON mara_{matnr = marc}matnr

for all entries in matnr

WHERE mara~matnr = matnr-low

AND extwg IN extwg

AND werks IN werks

AND mtart IN matart

AND matkl IN matkla

AND ekgrp IN ekgrup.

You have missed mara~ in selection statement.Add and try it