select

[Former Member]

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.

[andreas_mann3]

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.

A.

Message was edited by:

Andreas Mann

[Former Member]

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á

[Former Member]

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

[Former Member]

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