Query's generating error

Former Member — Thu, 28 Jun 2007 16:17:20 GMT

Hi guys,

I have a problem with a query in an upgrade.

In the old version it works OK, but i get a short dump when i try to execute this in te new 6.0 version. I've checket the infoset and the it activates without problem. But when i go to see one of the self-generated function modules for this query; i see that one of them can't be activated.

I get an statement not accessible error message; i when i doble-click it it takes me to this source-code point:


Tables: zntcomisiones.
data: begin of itab occurs 0.
        include structure zntcomisiones.
data end of itab.
select * from zntcomisiones appending table itab.
select * from zntregular appending corresponding fields of table itab.

DATA D_ABGRU LIKE VBAP-ABGRU.

data IMPORTE(016) type P decimals 02.
data SOCIEDAD like KNB1-BUKRS.

I dont know so much about Querys, but i think it's not normal. I cannot solve the problem editing the code c'ause it's self-generated by the query and can be erased if anyone decides to reactivate it. And it demands me a key too (that I haven't got). I've tried to reactivate the infoset and the query and the systems says "ok" but the problem persists.

¿Can anyone please give me a clue?

Thank-you.

Message was edited by:

Artur Rodriguez

Re: Query's generating error

Former Member — Thu, 28 Jun 2007 16:30:11 GMT

Hello,

On tcode SQVI check the query you have, and check that the tables zntcomisiones and zntregular have the corresponding fields with the same element data.

Bye

Gabriel

Re: Query's generating error

Former Member — Thu, 19 Jun 2008 14:56:03 GMT

I don't need this any more.

topic Re: Query's generating error in Application Development and Automation Discussions

Query's generating error

Re: Query's generating error

Re: Query's generating error