topic Re: selection logic in Application Development and Automation Discussions

selection logic

Former Member — Wed, 19 Nov 2008 08:17:07 GMT

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 — Wed, 19 Nov 2008 08:19:19 GMT

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 — Wed, 19 Nov 2008 08:21:27 GMT

Hi,

make a database view of two tables and use it.

thanks

arjun

Mohamed_Mukhtar — Wed, 19 Nov 2008 08:22:24 GMT

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 — Wed, 19 Nov 2008 08:24:27 GMT

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

Regards

Neha

Former Member — Wed, 19 Nov 2008 08:25:30 GMT

thnkx all its done

Former Member — Wed, 19 Nov 2008 10:30:53 GMT

use inner join

shiva