topic problem in query in Application Development and Automation Discussions

problem in query

Former Member — Wed, 10 Sep 2008 12:46:58 GMT

Hi Experts

we have developed a Module pool program, that program is working fine in QA, but it is going to dump in Production.

can someone tell what is the problem, the message which was given in dump is -> "The field "T_KONV" is unknown, but there is a field with the similar name "KONV" . . . ."

it is showing error on " INTO TABLE t_konv " but t_konv is declared which evident that it is working in QA properly.


SELECT     knumv
            kwert
             FROM konv
            INTO TABLE t_konv
             FOR ALL ENTRIES IN t_zcform
             WHERE knumv = t_zcform-knumv
             and KSCHL = 'ZTOT'.

Regards

Rajnesh

Re: problem in query

andre_kster — Wed, 10 Sep 2008 13:41:50 GMT

Hello,

Most likely you are missing one of you transports in production. The declaration of t_konv might be in a different transport than the select.

Can you navigate to the declaration in production by doubleclicking?

Easiest solution might be to add the whole pool to a new transport (by rightclicking it in SE80)

Regards

Andre

Re: problem in query

Former Member — Thu, 11 Sep 2008 06:20:05 GMT

Thanks Andre

you just hit the nail on Head.

the problem is solved

Thanks and Regards

Rajnesh