topic Re: Alternative Logic - Required !!! in Application Development and Automation Discussions

Alternative Logic - Required !!!

Former Member — Wed, 25 Feb 2009 07:30:55 GMT

hi guys,

i have to write a function module for search the matching records in the table ekko.

field names : ebeln,bukrs,lifnr (3 fields).

the user will give any values from these three fields that may (all three fields or 1 field or 2 fields).

when he clicks execute it should come out the matching selection from the user.

My logic for the above requirment is :

*step-1 :

select ebeln bukrs lifnr from ekko into CORRESPONDING FIELDS OF TABLE lt_ekko1.

*step-2

if po_no is not initial.

delete lt_ekko1 where ebeln ne po_no.

endif.

*step-3

if co_code is not INITIAL.

delete lt_ekko1 where bukrs ne co_code.

endif.

*step-4

if vendor is not INITIAL.

delete lt_ekko1 where lifnr ne vendor.

endif.

*now my internal table contains the final output in lt_ekko1 internal table.

*this is perfecftly working for me.

But in the case of more fields i need to use more lines of code , instead of this , could you suggest

alternative logic to minimise the code for achieving this result.

regards,

Giri

Re: Alternative Logic - Required !!!

Former Member — Wed, 25 Feb 2009 07:36:28 GMT

in select query use Where ebeln ne PO_NO....for all the 3 fields

Re: Alternative Logic - Required !!!

Former Member — Wed, 25 Feb 2009 07:40:27 GMT

hi. thanks for your reply.

but it won't solve my problem. if if the user fills only bukrs and lifnr field alone and leaves the po_no FIELD as blank. then it will fetch wrong no of records.

Re: Alternative Logic - Required !!!

Former Member — Wed, 25 Feb 2009 07:44:15 GMT

Hi Giri,

Declare ranges for all your search fields and fill your input values in ranges. and use it in selct query.

for e.g. select lifnr from lfa1 into table it_lfa1 where lifnr in r_lifnr. similarly all other fields.

Re: Alternative Logic - Required !!!

Former Member — Wed, 25 Feb 2009 07:50:04 GMT

Yes. This is what i wanted ... thank you ....very much....

if you have the code for this you please post it here, it could be helpful for the forum.

regards,

Giri