topic Re: using parallel cursor read with field symbols in Application Development and Automation Discussions

using parallel cursor read with field symbols

Former Member — Wed, 28 Jan 2015 12:51:46 GMT

Hi all.

I am trying to do loop inside a loop with field symbols to add some values checking same Profit center. I am doing loops on a BPC model data

FS : <ct_data> type standard table, <ls_data> type any.

e.g.

assign component of ls_profit_center of structure <ls_data> to <Profit_center>.

assign component of ls_profit_center of structure <ls_data1> to <Profit_center1>.

loop at <ct_data> into <ls_data>.

loop at <ct_data> assigning <ls_data1> where <Profit_center> EQ <ls_data>-<profit_center>

logic...

endloop.

It says Loop where " the row type of the table must be statically defined...

This helps me as I can reduce many number of loops...

Thanks

Krishna

Re: using parallel cursor read with field symbols

SharathYaralkattimath — Wed, 28 Jan 2015 13:03:04 GMT

you have defined the field symbols as TYPE any,

you need to give the exact data type.

for e.g. FIELD-SYMBOLS: <ct_data> type table of mara,

<ls_data> like line of <ct_data>.

Re: using parallel cursor read with field symbols

Former Member — Wed, 28 Jan 2015 13:07:12 GMT

Hi Krishna,

Replace the WHERE statement with IF statement.:

loop at <ct_data> into <ls_data>.

loop at <ct_data> assigning <ls_data1>.

IF <Profit_center> EQ <ls_data>-<profit_center>

logic...

ENDIF.

endloop.

Re: using parallel cursor read with field symbols

Former Member — Wed, 28 Jan 2015 13:16:42 GMT

Hi Krishna,

I think your where condition need correction.

Old code:

loop at <ct_data> into <ls_data>.

loop at <ct_data> assigning <ls_data1> where <Profit_center> EQ <ls_data>-<profit_center>

logic...

endloop.

New Code:

loop at <ct_data> into <ls_data>.

loop at <ct_data> assigning <ls_data1> where Profit_center EQ <ls_data>-profit_center

logic...

endloop.

By the way this is not parallel cursor method. Parallel cursor will have second loop with index and not with where condition.

it should be like,

LOOP AT <ct_data> ASSIGNING <ls_data>.

lv_index = sy-tabix.

LOOP AT <ct_data> ASSIGNING <ls_data1> FROM lv_index.

IF <ct_data>-profit_center EQ <ls_data>-profit_center

<....your code logic...>

ELSE.

EXIT.

ENDIF.

ENDLOOP.

Let me know if I am right.

Regards,

Sid

Re: using parallel cursor read with field symbols

Former Member — Wed, 28 Jan 2015 14:18:15 GMT

Hello guys, thanks for the interest.

John,

I know using if condition is a possibility but wanted to avoid that. If I can get the where condition, i will have less loops so faster performance.

Sid,

I meant loop inside loop, I am aware parallel cursor needs index in 2nd loop.

loop at <ct_data> into <ls_data>.

loop at <ct_data> assigning <ls_data1> where Profit_center EQ <ls_data>-profit_center

this statement also gives the same error message..

Syntax accepts where clause..but not sure what it meant by statically defined...

Sharath,

am using this in getting data from BPC model, backend its a cube data in BW that I am reading using an interface method if_ujo_query~run_rsdri_query and it has returning parameter as Type Standard Table.

Therefore it takes the structure dynamically...

Any other inputs please....

Re: using parallel cursor read with field symbols

SuhaSaha — Wed, 28 Jan 2015 14:47:40 GMT


If I can get the where condition, i will have less loops so faster performance.

I don't know what you mean by this. Fyi, LOOP...WHERE does a full table scan if the appropriate keys are not used.


I am reading using an interface method if_ujo_query~run_rsdri_query and it has returning parameter as Type Standard Table

Afaik you cannot type RETURNING parameters generically. Can you please provide additional details about your code, so that it'll be easier to analyse.

Re: using parallel cursor read with field symbols

jrg_wulf — Wed, 28 Jan 2015 15:12:50 GMT

Hi,

1. there is no way to use where clause with dynamic structure!

If you don't know the structure at design-time, you can't use where.

2. Think again on how (and why) you use field-symbols.


assign component of ls_profit_center of structure <ls_data> to <Profit_center>.

You cannot use this statement. You must either provide the component-name (literally or in an upper-case variable) or the number in the structure, for the assign to take effect.

3. When you successfully managed to assign the desired fields to your field-symbols, you're ready to proceed. But still whithout where clause

data: ld_ix type i.

loop at <ct_data> into <ls_data>.

ld_ix = sy-tabix + 1.

* Assuming previously processed entries are of no further interest

loop at <ct_data> assigning <ls_data1> from ld_ix.

check <profit_center1> EQ <profit_center>.

logic...

endloop.

Alternatively, read about find in table and consider, whether you can benefit from result_tab.

This would allow you to loop on result_tab (containing only matching lines) and then do a

read_table <ct_data> assigning <ls_data1> index result_wa-line.

Best regards - Jörg

Re: using parallel cursor read with field symbols

Former Member — Thu, 29 Jan 2015 12:09:04 GMT

Are you looking for logic like below? Here where clause in loop is dynamic..

DATA lt_t100 TYPE STANDARD TABLE OF t100.

DATA l_string TYPE string.

FIELD-SYMBOLS <ls_work> TYPE any.

FIELD-SYMBOLS <ls_work2> TYPE any.

SELECT *

INTO TABLE lt_t100

FROM t100

UP TO 10 ROWS.

LOOP AT lt_t100 ASSIGNING <ls_work>.

l_string = 'MSGNR = <LS_WORK>-MSGNR'.

LOOP AT lt_t100 ASSIGNING <ls_work2> WHERE (l_string).

* Some logic

ENDLOOP.

Re: using parallel cursor read with field symbols

Former Member — Thu, 12 Feb 2015 09:03:29 GMT

Sorry for coming back on this after long time..

Just one thing, this Dynamic where condition while using field symbols is allowed only after a certain patch level I believe.

I am using BW 7.0 with SP 7.0 and when I try this ..it says it should be statically defined or similar to that but does not allow me to use dynamic where condition.

LOOP AT lt_t100 ASSIGNING <ls_work>.

l_string = 'MSGNR = <LS_WORK>-MSGNR'.

LOOP AT lt_t100 ASSIGNING <ls_work2> WHERE


(l_string).

* Some logic

ENDLOOP.