Skip to Content
0
Former Member
Mar 24, 2009 at 06:11 PM

modify "select statement" according to the requirement

43 Views

Hi Experts,

On selection screen I have

sales org(vbak-vkorg) (Obligatory)

Matetrial:(vbap-matnr)

Plant(vbap-werks):

I have now added two more select options

Sales grp (vnak-vkgrp):

Customer grp(likp-kdgrp):

Now my requirement is, If entered sales grp, cust grp, sales org.

It should display sales org, material plant of that particular sales grp, cust grp and only.

I have a select statement like this,

  • SELECT SINGLE * FROM vbak WHERE ernam IN s_ernam AND vkorg IN s_vkorg AND

auart NE 'KE'.*

How can I edit this select statement, so that when Input is given as sales grp , customer grp & sales org, all the records should be displayed related to that particular sales group & customer group only.

Thanks in Advance.

Rohan