selection logic

[Former Member]

Hi all,,

On my selection screen i have

aufnr-aufk

vblen-vbap

now i want to select data from aufk and the corresponding values from vbap.

so i wrote the below select

select data from aufk where aufk in my selection screeen

select data from vbap for all entries in above table.

But if the user just gives vbeln on selection then , my 1st select wont work because there is no selection based on vbeln on auk

How do i handle the situation?

I c'nt write inner join also.

Any suggestions?

[h_senden2]

use a inner join on the two tables. You can read them at once.

For more info on INNER JOIN, use the search functionality of forum and wiki.

regards,

hans

[arjun_subhash]

Hi,

make a database view of two tables and use it.

thanks

arjun

[Mohamed_Mukhtar]

Hi Malik,

Do validations at selection screen for the field aufnr-aufk .

try like this, hope it hleps u.

select-options : s_aufk for aufnr-aufk .
at selection-screen on s_aufk. 
if aufnr-aufk  is inital.
message 'enter a value' type 'E'.
endif.

Thanks & Regards

[Former Member]

Hi

You can make aufnr an obligatory field in the selection screen.

Regards

Neha

[Former Member]

thnkx all its done

[Former Member]

use inner join

shiva