Hi Abaper,
In my standard table there is a field concepto and it value are
'ALLOWOTH
'ALLOWROOM'
'ALLOWFB'
In this way all the values of this concepto field starts wit ALLOW.
Right now there are only 3 values as mentioned above. So we used the below Query(Harded coded)
SELECT xconcepto
FROM /ccsht/rs_linfol
INTO TABLE it_linfol
FOR ALL ENTRIES IN it_comp_hotel
WHERE xhotel_id EQ it_comp_hotel-xhotel_id
*WHERE xhotel_id IN p_hotid "it_comp_hotel-XHOTEL_ID
AND xfecha_prest IN p_date
AND ( xconcepto) EQ 'ALLOWOTH' OR xconcepto EQ 'ALLOWROOM' OR xconcepto EQ 'ALLOWFNB' ).
But Some more values are going to add in future. So we don't want to hard code the concepts.
Can any one help us to rectify this prolem.
Thanks and regards,