Skip to Content
0
Former Member
Jan 15, 2008 at 09:29 AM

search help

20 Views

Hi Experts,

I have a master z table zsection_mst and transaction table zsection_tst.

zsection_mst have fiels

-sectioncode

-parametercode

-secdesp ( section description)

-paradesp ( parameter description).

zsection_tst having fields

-sectioncode

-parametercode

-budat

-quantiy

-remarks

so i hv desinged screen 100 whre i hv given fields from zsection_tst.

and also i created zsectionsch search help taking fields rom zsection_mst taking SECTIONCODE and SECDESP fields in search help and assinged to the field zsection_tst-sectioncode in screen 0100.

the data in zsection_mst is like this

sectioncode parametercode secdesp paradesp

H2SO4 SA01 SULPHUICACID PITLEVL

H2SO4 SA02 SULPHURICACID PITLEVEL2

H2SO4 SA03 SULPHURICACID STOCKLEVEL

like this i hv values up to SA30.

fro same sectioncode and section description the paramtercode and pardesp varies in zsection_mst.

so the problem here is in screen 0100 when i click possible values for field sectioncode it is showing 30 values i.e same h2so4 and sulphuric acid. so i dont want same values to repat in the search help. i want ony single section code and description. in futrue i may give cs2 as section code in master table so it should no show all the values. it show show only distinct values in search help. How can i dot it...

please help me its urgent...

<b>points will be rewarded</b>

Regards,

priyanka reddy.