Skip to Content
0
Former Member
Apr 25, 2009 at 06:15 AM

CRFH

243 Views

The issue is that i want to fetch objid (i.e Object types of the CIM resource) against to corresponding line but in this table it stores 1 line and 1 box but actually in ztable the range is maintained for e.g for lines( L1 To L8) and for boxes (B1 to B11) so from crfh i want to get only those between ranges for both boxes and lines

i have written following 2 types of select queries

CLEAR CRFH.

SELECT * FROM CRFH

WHERE ( FGRU1 BETWEEN IT_TRSFR_123-FRGU1 AND IT_TRSFR_123-FRGUL )

and ( FGRU1 BETWEEN IT_TRSFR_123-FRGU2 AND IT_TRSFR_123-FRGUB ).

IT_TRSFR_123 is internal table which stores the records from ztable.

IT_TRSFR_123-FRGU1 Stores (L1) and IT_TRSFR_123-FRGULStores (L8)

IT_TRSFR_123-FRGU2 Stores (B1) and IT_TRSFR_123-FRGUL Stores (B11)

this query fails as it gives complete list of objid rather than specified range

help required same.

thanks