![]() |
|
|||||||
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Performance Monitoring | sapen | SAP CRM | 0 | 11-26-2009 06:35 PM |
| how to tune the performance of following query? | sapen | SAP ABAP | 0 | 09-30-2009 08:43 PM |
| Aprenda SAP! |
|
|
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Hi experts!
How to increase performance for the following query BSIS? Code:
select a~saknr b~txt50
into corresponding fields of table it_table
from skb1 as a
inner join skat as b
on a~saknr = b~saknr
where a~saknr in v_variable
and a~bukrs eq company.
if sy-subrc eq 0.select bukrs hkont augdt
augbl zuonr gjahr
belnr buzei
budat
werks
kostl
aufnr
shkzg
dmbtr
prctr
into corresponding fields of table it_bseg
from bsis
for all entries in it_final
where bukrs eq company
and prctr eq s_center
and gjahr eq s_gjahr
and hkont eq it_table-glcode
and budat in s_budat "BETWEEN fromdt AND todt.
|
| Sponsors |
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|