on 2024 Jul 30 10:57 AM
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.
Request clarification before answering.
User | Count |
---|---|
34 | |
21 | |
14 | |
8 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.