CRFH

[Former Member]

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

[Former Member]

some thing wrong with your where condition..??

and are you reading the internal table IT_TRSFR_123, prior to this select.

[Former Member]

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.

[Former Member]

no response from anyone