select query

[former_member587342]

Hi Experts

I have one scenario i need to pass ebeln to ekpo so we need to get bednr associated with it.then i need to pass this bednr to ekpo-bednr so we will get all po's assocaited with this bednr.

I ma getting error. could you please help me out to achieve this.

so i have write query like this

data: lv_po type ekpo-bednr.

select bednr from ekpo into lv_po where ebeln = po_number.(po_number is the attriubute

[srikanthnalluri]

Read the Documentation - https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abapselect.htm

Either you need to write SELECT SINGLE or Close the set using ENDSELECT.

[tan_michael]

Hi,

I think you should use SELECT SINGLE..

[tan_michael]

select single bednr

from ekpo

into lv_po

where ebeln = po_number.

[matt]

"Getting an error" is not really sufficient detail.