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

[dhruv_shah3]

Hi,

Check whether the records are there in the Table for extwg.

Also its better to use FOR ALL ENTRIES statement when comparing the tables for records.

HTH

Regards,

Dhruv Shah

[Former Member]

hi

thanks for replay .

yes there are records in that fields .

Regards

rakesh

[Former Member]

Hi,

Try out the modified Query.

SELECT mara_{matnr mara}extwg marc_{werks marc}xchar mara_{mtart mara}matkl mara_{meins marc}trame marc~umlmc

marc_{bwesb marc}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 mara}extwg marc_{werks marc}xchar mara_{mtart mara}matkl mara_{meins marc}trame marc~umlmc

marc_{bwesb marc}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

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

Regards,

Morris Bond.

Reward Points if helpful.

[Former Member]

hi

i tried it but the same result .

regards

Rakesh