topic Re: select issue : not getting output. in Application Development and Automation Discussions

select issue : not getting output.

Former Member — Sat, 09 Feb 2019 17:43:41 GMT

Hi,

i am doing something wrong in this code ...i guess i am going wrong in select query..please check n let me know where i am going wrong.

Data : it_ekbe type table of ekbe,
wa_ekbe type ekbe.
select-options : s_ebeln for wa_ekbe-ebeln.

select ebeln ebelp bewtp gjahr from ekbe into corresponding fields of table it_ekbe where ebeln in s_ebeln and ebelp = wa_ekbe-ebelp and bewtp = 'E'.

loop at it_ekbe into wa_ekbe.
write:/ wa_ekbe-ebeln ,wa_ekbe-ebelp ,wa_ekbe-bewtp ,wa_ekbe-gjahr.
endloop.

matt — Sat, 09 Feb 2019 22:14:11 GMT

Impossible to answer as we don't know what's in your EKBE, nor do we know what you've given in s_ebeln.

former_member291971 — Sun, 10 Feb 2019 06:52:19 GMT

Change your query like below , It will work.

Tables:ekbe.

Data : it_ekbe type table of ekbe,

wa_ekbe type ekbe.

select-options : s_ebeln for ekbe-ebeln,

s_ebelp for ekbe-ebelp.

select ebeln ebelp bewtp gjahr from ekbe into corresponding fields of table it_ekbe where ebeln in s_ebeln

and ebelp in s_ebelp

and bewtp = 'E'.

loop at it_ekbe into wa_ekbe.
write:/ wa_ekbe-ebeln ,wa_ekbe-ebelp ,wa_ekbe-bewtp ,wa_ekbe-gjahr.
endloop.

Former Member — Sun, 10 Feb 2019 06:56:10 GMT

In the selection screen i dont want ebelp...then how can i pass ebelp ?

former_member291971 — Sun, 10 Feb 2019 07:18:40 GMT

Then you dont want to pass ebelp in selection screen, it will automatically fetch all the values relevant to Ebeln(Purchase Order).

Tables:ekbe.

Data : it_ekbe type table of ekbe,

wa_ekbe type ekbe.

select-options : s_ebeln for ekbe-ebeln obligatory.

select ebeln ebelp bewtp gjahr from ekbe into corresponding fields of table it_ekbe where ebeln in s_ebeln

and bewtp = 'E'.

loop at it_ekbe into wa_ekbe.
write:/ wa_ekbe-ebeln ,wa_ekbe-ebelp ,wa_ekbe-bewtp ,wa_ekbe-gjahr.
endloop.

Sandra_Rossi — Sun, 10 Feb 2019 08:09:55 GMT

Your query condition makes no sense at this place:

... AND ebelp = wa_ekbe-ebelp ...

because WA_EKBE has not been initialized yet.

Sandra_Rossi — Sun, 10 Feb 2019 08:23:41 GMT

The most important question is what do you want to achieve, in plain English words?