topic Re: COEP Access in Application Development and Automation Discussions

COEP Access

Former Member — Mon, 01 Dec 2008 22:01:21 GMT

Hi ,

I am accessing coep without key field belnr .It taking hell lot of time.Any suggestions for fast accesing this table without key field.

Regards

Ivneet

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:05:35 GMT

Not unless you can tell us which fields you are using.

Rob

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:07:09 GMT

There are other these key fields also:

KOKRS
BELNR BUZEI

And what fields you are selecting?you can make secondry index too.

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:08:33 GMT

year ,objnr,wrttp as input fields.

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:11:45 GMT

Add:

LEDNR = 0

to the where. this will allow it to use index ~1.

Rob

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:12:09 GMT

Show your query.

Just to confirm again are you using these input

(OBJNR

GJAHR

WRTTP) fields with where condition?

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:17:08 GMT


>LEDNR = 0.

Will this really Improve Performance?

Correct me if i'm wrong.

I think by adding alone LEDNR wont improve performance much casue it has already only One value defined in value range which 00 .

I guess Along this he can add

VERSN
PERIO
VRGNG

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:20:22 GMT

> >


> >LEDNR = 0.
>

> Will this really Improve Performance?

> Correct me if i'm wrong.

> I think by adding alone LEDNR wont improve performance much casue it has already only One value defined in value range which 00 .

> I guess Along this he can add

VERSN
> PERIO
> VRGNG

Try it.

There seems to be a conversion exit. Use:

SELECT        * FROM  coep
       WHERE  lednr  = '00'                           <====== 00
       AND    objnr  = your_objnr..

Rob

Edited by: Rob Burbank on Dec 1, 2008 5:24 PM

Re: COEP Access

Former Member — Mon, 01 Dec 2008 22:46:20 GMT

thks guys it working fast with only lednr "00'