COEP Access

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

year ,objnr,wrttp as input fields.

[Former Member]

Add:

LEDNR = 0

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

Rob

[Former Member]

Show your query.

Just to confirm again are you using these input

(OBJNR

GJAHR

WRTTP) fields with where condition?

[Former Member]

>

>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

.

[Former Member]

>

> >

> >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

[Former Member]

thks guys it working fast with only lednr "00'

[Former Member]

There are other these key fields also:

KOKRS
BELNR BUZEI

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