cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Splitting Ranges/SQL Statement for avoiding dumps of a job

ABAPDev_1337
Discoverer
0 Kudos
170
  • SAP Managed Tags

Hey, 

 

I have the following problem: 

I have a Job that dumps monthly, due to analysis of st22 it is because DBSQL_Stmnt_too_large

I researched a little and came to the conclusion that the ranges are too large for the statement. 

The statement goes sth like this: 

Select x y sum( z ) as profit from dfkkop
into corresponding fields of table rt_profit
where x in it_range_x and 
y in ms_sel-s_y and 
w in ms_sel-s_w and
q in lt_range_q 
group by gpart bukrs. 

Since there are only itabs with type standart table of range with default key and not "real" ranges, im unsure whether i can split the itabs like ranges or not. Im also unsure about how i can split this statement or use for all entries. 

Accepted Solutions (0)

Answers (0)