Problem with search criteria

[Former Member]

hi,

i am using the module pool program.

in the first screen i am using two fields and one table control.

1st field is:partner no.

2nd partner name.

in the table control also 5 fields.

if i enter the name in the name field,in the back end it sholud search for two fields(firstname and lastname),and get the data ,search senarios are like this.

here i am using the inner join because number and name is from different tables.

1)search only with number.

2)search only with name.

3)search with combinations(both number and name).

4)search with wild charecter.

if any one have any idea pls let me know.

4)

[Former Member]

can you explain it more clearly...

wht is ur requirement..?

[uwe_schieferstein]

Hello Rammohan

If field "partner no" means the number of the <b>SAP business partner</b> (data element BU_PARTNER) then you could use search help <b>BUPA</b>.

Regards

Uwe

[Former Member]

hi,

i am using two fields to search .

1) is partner number

2) partner name.

partner number has to be come from ztable,

partner name has to be come from but000.

but in the fron end only one field should be there.

if i give the input inthe front end,in the back end it has to search two fields (ex:first name and last name) and get the data.

for this i am using the inner join.

following is the code.

SELECT F_{partner F}Z_CLASS_LEVEL_ID F~Z_CLASS_RANGE_ID

f_{Z_CLASS_TYPE_ID F}SEQNO F_{Z_IND_SECTOR F}Z_OBJID F~Z_CUP_SUB_CLASS

P_{NAME_FIRST p}NAME_LST2 FROM Zclient_CLASS AS F

INNER JOIN but000 AS

P ON F_{partner = P}partner

INTO CORRESPONDING FIELDS OF TABLE itab_name WHERE

F_{partner = partnerno and P}name_first in r_name. "or p~name_lst2 in r_name.

how to handle this.

[Former Member]

Check by changing below.

SELECT F_{partner F}Z_CLASS_LEVEL_ID F~Z_CLASS_RANGE_ID

f_{Z_CLASS_TYPE_ID F}SEQNO F_{Z_IND_SECTOR F}Z_OBJID F~Z_CUP_SUB_CLASS

P_{NAME_FIRST p}NAME_LST2 FROM Zclient_CLASS AS F

INNER JOIN but000 AS

P ON F_{partner = P}partner

INTO CORRESPONDING FIELDS OF TABLE itab_name WHERE

F~partner = partnerno and

( P_{name_first in r_name or p}name_lst2 in r_name ).