Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CRFH

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
Not what you were looking for? View more on this topic or Ask a question