Problem in FOR ALL ENTRIES IN statement

Hi Abaper,

I have a problem in FOR ALL ENTRIES IN statement.

I have a table /ccsht/na_estadi in this table for the particulat date there are 14 records, but my internal table read only 5 record.

Below is my code:

SELECT sociedad

xhotel_id

FROM /ccsht/mt_photel

INTO TABLE it_comp_hotel

WHERE sociedad IN p_comp

AND xhotel_id IN p_hotid.

BREAK-POINT.

SORT it_comp_hotel BY sociedad.

SELECT xhotel_id

xfecha_id

xocupacion

tot_habs_hotel

xnum_pax1

FROM /ccsht/na_estadi

INTO TABLE it_estadi "CORRESPONDING FIELDS OF TABLE it_estadi

FOR ALL ENTRIES IN it_comp_hotel

WHERE xhotel_id EQ it_comp_hotel-xhotel_id

AND xfecha_id IN p_date.

Can any one help me this issue.

Thanks in advance.

Thanks & Regards,

Amit