select issue : not getting output.

[Former Member]

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]

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]

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]

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

[former_member291971]

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]

Your query condition makes no sense at this place:

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

because WA_EKBE has not been initialized yet.

[Sandra_Rossi]

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