Skip to Content
0
Former Member
Feb 23, 2009 at 07:42 AM

Faching data from Standard table

91 Views

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,