topic Re: select in Application Development and Automation Discussions

select

Former Member — Wed, 09 May 2007 12:41:15 GMT

Below is my select statement:

It is not working. Could you make it right.

data: wa_bkpf like bkpf.

select single * from bkpf into corresponding field of wa_bkpf.

where belnr= p_belnr.

select * from bseg into table itab

where belnr= wa_belnr.

Re: select

andreas_mann3 — Wed, 09 May 2007 12:44:50 GMT

data: wa_bkpf like bkpf.

"here you should add bukrs and gjahr to where-clause

select single * from bkpf into corresponding field of wa_bkpf.

where belnr= p_belnr.

select * from bseg into table itab

where belnr = wa_bkpf-belnr

and bukrs = wa_bkpf-bukrs

and bukrs = wa_bkpf-gjahr.

Message was edited by:

Andreas Mann

Re: select

Former Member — Wed, 09 May 2007 12:45:19 GMT

Hi!

data: wa_bkpf like bkpf.

select single * from bkpf into corresponding field of wa_bkpf.

where belnr= p_belnr.

select * from bseg into table itab

where belnr= wa_bkpf-belnr "<<< add here

and gjahr = wa_bkpf-gjahr "<<< add here

and bukrs = wa_bkpf-bukrs. "<<< add here

Regards

Tamá

Re: select

Former Member — Wed, 09 May 2007 12:45:35 GMT

While using select single you need to give all the key fields in the where condition

data: wa_bkpf like bkpf.

select single * from bkpf into corresponding fields of wa_bkpf.

where bukrs eq p_bukrs

belnr= p_belnr and

gjahr = p_gjahr.

select * from bseg into table itab

where belnr= wa_belnr-belnr.

but BSEG is a big tab;e , may cause performance issues

Re: select

Former Member — Wed, 09 May 2007 12:48:53 GMT

Hi Abhay,

Try this :

data: wa_bkpf like bkpf.

select single * from bkpf into corresponding field of wa_bkpf.

where belnr= p_belnr.

select * from bseg into corresponding fields of itab

where belnr= wa_bkpf-belnr.

append itab.

endselect

Reward points if helpful.

Regards,

Hemant