topic Problem with Querying.. in Application Development and Automation Discussions

Problem with Querying..

Former Member — Thu, 01 Nov 2007 10:20:32 GMT

I Used FModule.. "IHCLSD_PROCESS_SEARCH"

CALL FUNCTION 'IHCLSD_PROCESS_SEARCH'

EXPORTING

I_KLART = '002'

I_CLASS = 'DT'

I_LANGUAGE = SY-LANGU
I_KEY_DATE = SY-DATUM
CHANGING

CT_OBJECTS = CT_OBJECTS

EXCEPTIONS

NO_OBJECTS_FOUND = 1

INCONSISTENT_PARAMETERS = 2

NO_AUTHORITY_CLASSTYPE = 3

CT_OBJECTS Contains all the List of Equipment for the class "DT".

Now I want to Query From the List of Equipments which is executed after that FM for the Weight= xyz from those list of equipment.

Its Table is EQUI and Fiels is BRGEW.

Can Any one will write the Query So, that I can Execute Immediately.

Its Very Urgent..

Points will be awarded.

Regards,

Jayasimha

Re: Problem with Querying..

kesavadas_thekkillath — Thu, 01 Nov 2007 10:29:03 GMT

just loop at ct objects.

select single brgew into (equi-brgew) where equi_number = ' ( eqno) '.

and brgew = 'xyz'.

if sy-subrc = 0.

then it matches u r criteria.

move it to another itab.

then u will get the list wheich satisfies ur condition.

reward if useful

Re: Problem with Querying..

Former Member — Thu, 01 Nov 2007 10:46:25 GMT

Hi Mohammed ,

I need to find Eq No for those eq.no which as weight xy.

Loop at CT_objects cannot be put. Because it is a changing type and it is not a table kind of this.

Can u write the logic and send me if possible.\

Regards,

jayasimha

Re: Problem with Querying..

kesavadas_thekkillath — Thu, 01 Nov 2007 11:39:14 GMT

whether this functional module is inside a loop?

If so.

you just write the code below the FM.

declare a internal table with 2 fields.

data:begin of itab occurs 2000,

eeqno type itob-eqno,

end of itab.

select single brgew into (equi-brgew) where equi_number = CT_OBJECTS

and brgew = 'xyz'.

if sy-subrc = 0.

move CT_OBJECTS to itab-eqno.

append itab.

clear equi.

endif.

Re: Problem with Querying..

Former Member — Thu, 01 Nov 2007 11:54:56 GMT

CT_OBJECT is an changing table.

In that table a field called objects which stores the equipment value.