Regarding Fetching values from CKIS table

[Former Member]

Hi,

I am fetching data from CKIS table.

I am using For all entries in table for fetching the data.

I am passing the BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR and KKZMA in the where clause.

But the time taken for the selection is huge.

Please suggest a way to enhance the performance of the select.

Thanks

Abhijit.

[Former Member]

Hi,

I am fetching data from CKIS table.

I am using For all entries in table for fetching the data.

I am passing the BZOBJ,KALNR,KALKA,KADKY,TVERS,BWVAR and KKZMA in the where clause.

But the time taken for the selection is huge.

Please suggest a way to enhance the performance of the select.

Thanks

Abhijit.

[Former Member]

Hi,

Make sure the internal table being used with the 'for all entries' addition is not empty before making the select.

Regards,

madhusudhan.

[Former Member]

The check is there for veryfing the table is not empty.

Thanks.