topic select query in Application Development and Automation Discussions

select query

former_member587342 — Mon, 27 Aug 2018 16:24:42 GMT

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

Re: select query

srikanthnalluri — Mon, 27 Aug 2018 20:48:38 GMT

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.

Re: select query

tan_michael — Tue, 28 Aug 2018 01:37:04 GMT

Hi,

I think you should use SELECT SINGLE..

Re: select query

tan_michael — Tue, 28 Aug 2018 01:38:43 GMT

select single bednr

from ekpo

into lv_po

where ebeln = po_number.

Re: select query

matt — Tue, 28 Aug 2018 05:20:31 GMT

"Getting an error" is not really sufficient detail.