topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Tue, 05 Jun 2007 05:38:03 GMT

Hi all,

select smenr swenr intreno from vimi01 into table itab1 on p_vbeln.

select sobjekt usr04 usr05 from vzsort into table itab2 for all entries in itab1 where

sobjket = itab1-intreno.

i am getting dump in the second select statement.

data is like this.

in itab1 when i give p_vbeln as 1.

interno are

im01000000001

im01000000024

imo1000000027

like this.

can any body help me in this regard.

Re: select query

Former Member — Tue, 05 Jun 2007 05:42:18 GMT

in 1st select, what's on p_vbeln? change it to eq if p_vbeln is parameters or in if it's select-options...use itab1[] is not initial before for all entries

select smenr swenr intreno from vimi01 into table itab1 -- eq or in p_vbeln.

if itab1[] is not initial.

select sobjekt usr04 usr05 from vzsort into table itab2 for all entries in itab1 where

sobjket = itab1-intreno.

endif.

if helpful, reward

Sathish. R

Re: select query

Former Member — Tue, 05 Jun 2007 05:42:21 GMT

What exactly it is indicating for the dump analysis?

check the dump in St22

Reward points if useful

Regards

Anji

Re: select query

Sougata — Tue, 05 Jun 2007 05:42:26 GMT

before the second select, try:

IF NOT itab1[] IS INITIAL.

Re: select query

Former Member — Tue, 05 Jun 2007 05:42:36 GMT

Hi,

Check the structure of itab2 .

it shud contain only the follwing fields :

sobjekt usr04 usr05

revert back if any issues,

reward wif helpful.

Regards,

Naveen

Re: select query

Former Member — Tue, 05 Jun 2007 05:45:07 GMT

Hi Siva ,

What is the dump message you are getting.

Regards

Arun

Re: select query

Former Member — Tue, 05 Jun 2007 05:45:11 GMT

Hi,

Internal table ITAB2 should have the smae fields which you are selecting from the table VZSORT and in the where condition the field SOBJKET shoulb have the same format

Regards

Sudheer

Re: select query

Former Member — Tue, 05 Jun 2007 05:45:31 GMT

Hi,

The dump states "Invalid Interruption of database"

then this is not becoz of your query. The query is fine

and correct.

This dump is as you must debugged the select statement

Re: select query

S0025444845 — Tue, 05 Jun 2007 05:52:01 GMT

Hi,

please check the order of fields you are retrieving in the tables is same as in the sructure declared by u I mean to say in itab1 order of field is

smenr swenr intreno and

itab2 is

sobjekt usr04 usr05 .

regards,

sudha