select query

[Former Member]

Can anyone suggest a better select statement for the below code as it is taking much runtime…as I m not using any primary key for selection…so I created index for below 4 selection fields…still it is taking more time…

SELECT guid object_id created_by FROM crmd_orderadm_h

INTO TABLE gt_orderh

WHERE object_type EQ c_tran

AND posting_date IN so_scdat

AND object_id IN so_scart

AND created_by IN so_sccrt.

[Former Member]

Try using function module

BBP_PD_SC_GETLIST

This will cater for differing values in your select options itab. Its very difficult to cater for all types of data entry i.e. will there be one object_id or many.

The function module tries to cater for multiple selection types and, I think, uses differing dBase views.

Cheers

Rob