problem in query

[Former Member]

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

[andre_kster]

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

[Former Member]

Thanks Andre

you just hit the nail on Head.

the problem is solved

Thanks and Regards

Rajnesh