topic Re: For all entries Problem in Application Development and Automation Discussions

For all entries Problem

Former Member — Mon, 07 Jul 2008 14:06:02 GMT

Hi,

i use for all entries and i have problem.

i do this select for 50 cost centers and

when i use for all entries commend i get in act 3 wrong fields(i check in se11 for all cost centers in let table )

But when i use Range table for this 50 CC i get it O.K.

what it can be ?

CLEAR : act.REFRESH: act.
        SELECT (sel)
        FROM /bic/0cz 
        INTO  TABLE act
        FOR ALL ENTRIES IN let
         WHERE dim0costcenter =  let-dim0costcenter
        AND dim0calquarter = year_q.


             CLEAR : act.REFRESH: act.
        SELECT (sel)
        FROM /bic/0cz 
        INTO  TABLE act
        WHERE dim0costcenter IN ty_range
        AND dim0calquarter = year_q.

Regards

Re: For all entries Problem

Former Member — Mon, 07 Jul 2008 14:09:25 GMT

Check if U have all the key fields in where condition ..

Re: For all entries Problem

Former Member — Mon, 07 Jul 2008 14:10:57 GMT

i don't understand :key field of what?

FOR ALL ENTRIES IN let

WHERE dim0costcenter = let-dim0costcenter

Regards

Re: For all entries Problem

Former Member — Mon, 07 Jul 2008 14:27:12 GMT

Hi friends ,

Any idea?

Regards

Re: For all entries Problem

vinod_vemuru2 — Mon, 07 Jul 2008 14:51:40 GMT

Hi,

Two reasons.

First thing r u checking below condition.

CHECK NOT let[] IS INITIAL. "If not it will selet all the records if let[] is initial.

SELECT (sel)

FROM /bic/0cz

INTO TABLE act

FOR ALL ENTRIES IN let

WHERE dim0costcenter = let-dim0costcenter

AND dim0calquarter = year_q.

Second This select will automatically deletes duplicate records based on let-dim0costcenter. This is property of FOR ALL ENTRIES and we can't change it.

Check these things and get back.

Thanks,

Vinod

Edited by: Vinod Reddy Vemuru on Jul 7, 2008 8:24 PM

Re: For all entries Problem

Former Member — Mon, 07 Jul 2008 15:01:48 GMT

Hi Vinod,

i do that, the table let is with 50 CC and i remove duplicates .

i do it in BI7 system maybe this is the problem ,i use for all entries many times but i never face this problem.

Regards

Re: For all entries Problem

vinod_vemuru2 — Tue, 08 Jul 2008 04:37:20 GMT

Hi Ricardo,

I was talking about Duplicates deletion in driven table(i.e the table from where u r selecting data).When we use For all entries this select will automatically deletes duplicates based on the driver table keys in where clause(One field in ur case).

eg: for the key mentioned in where clause(Consider only driver table fields in where clause) if u have 2 entries u will get only one entry in to internal table. that is what i am trying to say.

Driver table duplicates deletion is just to gain performance. Nothing else.

Hope it is clear.

Thanks,

Vinod.

Re: For all entries Problem

venkatasriram_mygapula — Tue, 08 Jul 2008 04:47:27 GMT

Hi,

whenever if ur using fro all entries in your program u have to use key fields in where condition. and

if not 1sttable[] is intial.

select.....

endif.