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