topic Re: field unknown in Application Development and Automation Discussions

field unknown

Former Member — Sat, 11 Apr 2020 17:32:19 GMT

Hi All,

In this code, i have an error if someone can help :

lt_cat99 type standard table of zcategorie99

select distinct matkl as categorie wgbez as description
  from t023t
  into corresponding fields of table lt_cat99
  where matkl in ('001', '00103', '002', '00207', '004')
  and spras = 'F'.

select m~matnr as id_produit kt~maktx as description m~meins as unite b~stprs as prix m~matkl as categorie
  up to 100 rows
  from mara as m
  inner join makt as kt on ( m~matnr = kt~matnr )
  inner join mbew as b  on ( b~matnr = m~matnr )
  into corresponding fields of table lt_prd99
  for all entries in lt_cat99
  where llt_cat99-categorie = m~matkl
  and b~bwkey = 1000.

It says : Field "LT_CAT99-CATEGORIE" unknown

and in the table "zcategorie99" I have a column name "CATEGORIE"

Re: field unknown

pfefferf — Sat, 11 Apr 2020 18:01:49 GMT

It would be good if you would share the structure definition for zcategorie99 too.

But looking at your code - which is by the way not complete, e.g. the missing data keyword at the beginning - one issue is that in the where clause of your second query you named the table LLT_CAT99 instead of LT_CAT99. Changing the name to LT_CAT99 in where clause too, should resolve the issue.

Re: field unknown

geert-janklaps — Sat, 11 Apr 2020 18:05:27 GMT

Hi,

In your where clause you have a typo (llt_cat99 instead of lt_cat99) and a wrong statement (m~matkl should be before lt_cat99).

This should solve your problem:

select m~matnr as id_produit kt~maktx as description m~meins as unite b~stprs as prix m~matkl as categorie
  up to 100 rows
  from mara as m
  inner join makt as kt on ( m~matnr = kt~matnr )
  inner join mbew as b  on ( b~matnr = m~matnr )
  into corresponding fields of table lt_prd99
  for all entries in lt_cat99
  where m~matkl = lt_cat99-categorie
  and b~bwkey = 1000.

Best regards,

Geert-Jan Klaps

Re: field unknown

Sandra_Rossi — Sat, 11 Apr 2020 18:11:45 GMT

Typo llt_cat99 - that should be:

  where m~matkl = lt_cat99-categorie

Re: field unknown

geert-janklaps — Sat, 11 Apr 2020 18:14:22 GMT

My mistake! Corrected! Thanks Sandra!

Re: field unknown

Former Member — Sat, 11 Apr 2020 18:14:49 GMT

Thank you a lot.

But why "m~matkl = lt_cat99-categorie" and not "lt_cat99-categorie = m~matkl" ????

Re: field unknown

Sandra_Rossi — Sat, 11 Apr 2020 21:57:32 GMT

Please use the COMMENT button for comments, questions, adding details, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

Re: field unknown

Sandra_Rossi — Sat, 11 Apr 2020 21:59:42 GMT

Because ... it's how it works.

Other examples:

Valid: where column = 'literal'
Error: where 'literal' = column

And many more.

Re: field unknown

Former Member — Sun, 12 Apr 2020 11:02:23 GMT

Thanks 🙂