Join Internal Table for all entries

[Former Member]

Hi,

I have put the LIKP data in the internal table and then use the for all entries statement to join the table with LIPS. Besides, i specifiy an additional condition to filter empty batch.

But, i found that the empty batch record still exist in the result. Any idea??

 
    SELECT *
    FROM LIPS INTO  TABLE I_DELIVERY_INFO
    FOR ALL ENTRIES IN I_DELIVERY
    WHERE
    VBELN = I_DELIVERY-VBELN.
    AND
    CHARG IS NOT NULL.

Regards,

Kit

[gopi_narendra]

Hi Kit,

If you are using LIKP and LIPS then you can directly join them since these tables are HEADER & ITEM table.

regd ur query you can use CHARG NE ' '.

Regards

Gopi