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.