04-25-2009 7:15 AM
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
04-25-2009 7:25 AM
some thing wrong with your where condition..??
and are you reading the internal table IT_TRSFR_123, prior to this select.
04-25-2009 7:42 AM
iam looping it so that it can validate range
loop at IT_TRSFR_123.
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 ).
endloop.
04-28-2009 7:41 AM