topic Re: Failed in query in Application Development and Automation Discussions

Failed in query

Former Member — Tue, 17 Sep 2013 04:20:02 GMT

Good morning friends, I'm programming with objects the following query, I have as input values the type of material and the center, but I get an error, this is the code:

MODULE user_command_0500 INPUT.

CASE ok_code.

WHEN 'EXECUTE'.

SELECT mapl~werks mapl~plnty mapl~plnnr mapl~plnal mapl~datuv mapl~matnr

plko~ktext mara~mtart

FROM mapl INNER JOIN plko ON mapl~werks = plko~werks

AND mapl~plnty = plko~plnty

AND mapl~plnnr = plko~plnnr

AND mapl~plnal = plko~plnal

INNER JOIN mara ON mapl~matnr = mara~matnr

INTO TABLE t_mapl

WHERE mtart eq mara-mtart

AND werks eq mapl-werks. "HERE THE FAILED"

IF sy-subrc <> 0.

ENDIF.

CALL METHOD r_grid->refresh_table_display.

WHEN 'BACK' OR 'CANCEL' OR 'EXIT'.

LEAVE TO SCREEN 0.

WHEN OTHERS.

ENDCASE.

ENDMODULE.

The following message appears:
The column name "WERKS" is unclear .

The data type MARA can be enhanced in any way. After a structure enhancement, this assignment or parameter might be syntactically incorrect.

Please I hope you can help me. Thank you very much.

Best regards

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:11:18 GMT

You need to specify from which table the werks is taken from

e.g: map1~werks (or map1-werks, check both)

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:18:00 GMT

Hi Brujo ,

From the code you have provided what my assumption is that there is some problem in the WHERE clause of the query .

Have you declared any workarea for mara and mapl tables , if yes , is there any data that you passing into the fields you are referring in the WHERE clause .

if there is no data in the fields used in the WHERE clause the query wil not work .

Regards,

Parth Sharma

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:18:01 GMT

You have to specify the tables in the where condition:

WHERE mara~mtart eq mara-mtart

AND mapl~werks eq mapl-werks.

This make sense only in case you have workareas mara and mapl filled with the values in your program before.

Otherwise remove the where condition.

/Michael

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:18:54 GMT

Hi,

please replace line

AND werks eq mapl-werks.

with

AND mapl~werks eq mapl-werks.

for PLKO~WERKS is defined through JOIN and MTART is unique in the JOIN tables.

Regards,

Klaus

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:21:28 GMT

Hi Brujo ,

The column name "WERKS" is unclear . " says that for which WERKS you are equating for ?.

You have declared WERSK in MAPL & PLKO . So make clear for which WERKS you are equating.

For Example :: AND plko~werks = mapl-werks.

Thanks,

S.Rajendranath Raparthi.

Re: Failed in query

Former Member — Tue, 17 Sep 2013 06:30:14 GMT

Hi,

You are trying to map map1 werks to itself in where condition.

Also there is no werks field in mara table, i think that condition is not required.

Please check and let me know.

Best Regards,

Abirami

Re: Failed in query

RaymondGiuseppi — Tue, 17 Sep 2013 06:43:43 GMT

Always use the syntax filename/id~fieldname, even if you are allowed to use a fieldname if it appears in only one of the joined table, a field may be appended to another table of the JOIN in a future version or in a customer append and the syntax would become invalid.

Regards,

Raymond

Re: Failed in query

Former Member — Tue, 17 Sep 2013 13:52:12 GMT

Thank you very much to all for your responses, all are correct.

Have a great day.