topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Mon, 28 May 2007 07:41:32 GMT

hi all,

my query is like this, i am extracting some data from table bsid.

parameters:p_kunnr like bsid-kunnr

select kunnr zuonr xblnr from bsid into table itab where kunnr = p_kunnr.

its showing dump.error in select statement.

in table bsid suppose customer no is 1(input)

in table we can find 5 custome numbers with 1.

thanks in advance

venkat

Re: select query

Former Member — Mon, 28 May 2007 07:44:47 GMT

Hi,

what is structure of itab,

try, into corressponding field of itab.

regards

deepak

Re: select query

Former Member — Mon, 28 May 2007 07:45:08 GMT

Hi,

How did you declare the internal table itab..

try using 'into corresponding fields of'

select kunnr zuonr xblnr from bsid into into corresponding fields of table itab where kunnr = p_kunnr. (or)..

declare the internal table only with these three fields..

Regards,

Vidya.

Re: select query

Former Member — Mon, 28 May 2007 07:45:28 GMT

Hi Venkat,

may be your itab is having different fields than your selction, check it or otherwise put the whole code here.

Reward points if useful.

Regards,

Atish

Re: select query

Former Member — Mon, 28 May 2007 07:45:57 GMT

what is the structure of itab??

if there are other fields than mentioned in select statement in itab, then try this..

select kunnr zuonr xblnr from bsid into <b>CORRESPONDING FIELDS OF</b> table itab where kunnr = p_kunnr.

Re: select query

Former Member — Mon, 28 May 2007 07:46:31 GMT

how have you declared your itab? if your internal table declaration order and the order in which you select fields from the database are not of the same sequence, then you have to use "into corresponding fields of" addition in your select

select kunnr zuonr xblnr from bsid into corresponding fields of table itab where kunnr = p_kunnr.

if helpful, reward

Sathish. R

Re: select query

Former Member — Mon, 28 May 2007 07:47:02 GMT

give yopur dump errors

we can solve it..

regards,

nazeer

Re: select query

Former Member — Mon, 28 May 2007 07:48:31 GMT

Check the sequence of the fields in Internal table and in the select Query

both should be same

may be you have declared wrongly, the sequence

see the sample select query

Select the Customer Open Items data from bsid

SELECT l~kunnr

l1~name1

b~waers

b~dmbtr

b~zfbdt

b~zbd1t

b~zbd2t

b~zbd3t

b~belnr

b~xblnr

b~shkzg

b~blart

INTO CORRESPONDING FIELDS OF TABLE int_bsid

FROM knb1 AS l INNER JOIN kna1 AS l1

ON l_{kunnr = l1}kunnr

INNER JOIN bsid AS b

ON l_{kunnr = b}kunnr AND

l_{bukrs = b}bukrs

WHERE l~kunnr IN s_kunnr AND

l~bukrs = p_bukrs and

b~zfbdt le p_allgst.

Reward points if useful

Regards

Anji

Re: select query

gopi_narendra — Mon, 28 May 2007 07:49:19 GMT

DATA : BEGIN OF itab OCCURS 0,
         kunnr LIKE bsid-kunnr,
         zuonr LIKE bsid-zuonr,
         xblnr LIKE bsid-xblnr,
       END OF itab.

PARAMETER : p_kunnr LIKE bsid-kunnr.

SELECT kunnr zuonr xblnr
       FROM bsid
       INTO TABLE itab
       WHERE kunnr = p_kunnr.
IF sy-subrc = 0.
  WRITE : 'Success..!'.
ENDIF.

this worked for me... check out if this is what u missed the itab declaration.

Regards

Gopi

Re: select query

Former Member — Mon, 28 May 2007 08:16:46 GMT

hi all,

thanks for ur response

my requirement is like this,

i had to extract

input is kunnr(parameter)

kunnr,name1,name2,adrnr from kna1

and kunnr zuonr,bldat,xblnr,wrbtr from bsid

and bktxt from bkpf

output table

kunnr name1 name2 adrnr zuonr bldat xblnr wrbtr bktxt

Re: select query

Former Member — Mon, 28 May 2007 08:21:42 GMT

<b>Select

a_{kunnr a}name1 a_{name2 a}adrnr

b_{zuonr b}bldat b_{xblnr b}wrbtr

c~bktxt

Into table ITAB

from kna1 as a join bsid as b

on a_{kunnr = b}kunnr join bkpf as c

on b_{belnr = c}belnr and

b_{gjahr = c}gjahr and

b_{bukrs = c}bukrs

where a~kunnr = p_kunnr.</b>

Reward points if useful

Regards

Anji

Re: select query

Former Member — Mon, 28 May 2007 08:24:47 GMT

selct a~kunnr

a~zuonr

a~bldat

a~xblnr

a~wrbtr

b~name1

b~name2

b~adrnr

into corresponding fields of itab

from bsid as a inner join kna1 as b

on a_{kunnr = b}kunnr

where a~kunnr = p_kunnr.

regards,

Vidya.

Re: select query

gopi_narendra — Mon, 28 May 2007 08:28:18 GMT

declare the internal tables accordingly.

PARAMETER : p_kunnr LIKE bsid-kunnr.

SELECT kunnr belnr zuonr bldat xblnr wrbtr
       FROM bsid
       INTO TABLE itab
       WHERE kunnr = p_kunnr.

SELECT kunnr name1 name2 adrn
       FROM kna1
       INTO TABLE it_kna1
       FOR ALL ENTRIES IN it_bsid
       WHERE kunnr = it_bsid-kunnr.

SELECT belnr bktxt
       FROM bkpf
       INTO TABLE it_bkpf
       FOR ALL ENTRIES IN it_bsid
       WHERE belnr = it_bsid-belnr.

LOOP AT it_bsid.
  move-corresponding it_bsid into it_final.
  READ TABLE it_kna1 WITH KEY kunnr = it_bsid-kunnr.
  IF sy-subrc = 0.
    MOVE it_kna1-name1 TO it_final-name1.
    MOVE it_kna1-it_kna1-name2 TO it_final-name2.
    MOVE adrnr TO it_final-adrnr.
  ENDIF.
  READ TABLE it_bkpf WITH KEY belnr = it_bsid-belnr.
  IF sy-subrc = 0.
    MOVE it_bkpf-bktxt TO it_final-bktxt.
  ENDIF.
  APPEND it_final.
ENDLOOP.

Regards

Gopi

Re: select query

Former Member — Mon, 28 May 2007 08:36:24 GMT

REPORT ZNN001_OTHERS.

data itab type STANDARD table OF bsid.

parameters:p_kunnr like bsid-kunnr.

select kunnr zuonr xblnr from bsid into corresponding fields of table itab where kunnr = p_kunnr.

REWARDS IF HELPFUL