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
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.