Hi All,
Can any one let me know which of the below code will give more performance.
As you knew that BKPF has 3 primary keys, <b>BUKRS, BELNR and GJAHR.</b> but in the selection screen we have only one selection field that is S_bukrs.
-
Select * from bkpf
into table i_bkpf
where bukrs in s_bukrs.
-
Select * from bkpf
into table i_bkpf
where bukrs in s_bukrs
and belnr in r_belnr [Passing no value]
and gjahr in r_gjahr. [Passing no value]
-
where r_belnr & r_gjahr are ranges - with no value.
Thanks
Jaya