cn47n performance

[ansar_shaikh2]

Dear PS gurus,

this is regarding cn47n performance, as we are getting very long time.

As our input selection is EN* this means the Project coding starting with EN will shows the result & dynamic selection is given as Plant.

But we are getting Maximum runtime exceeded.

Regards,

AHS

[virendra_pal · Accepted solution]

You must be having lots of projects with EN*

Try and narrow the selection

[ansar_shaikh2 · Accepted solution]

Already i did it, with Workcenter, Plant, Person Responsible

How can we optimize the selection ?

Regards,

ahs

[former_member496398 · Accepted solution]

Hi,

Also select using selection profile which contains selection status as REL OR CRTD and not TECO or CLSD or LKD. This will filter many projects which has been closed or TECO.

Regards,

Harish

[ansar_shaikh2 · Accepted solution]

Can you please elaborate, how to go for selection profile with status selection.

Regards,

ahs

[former_member203108 · Accepted solution]

apply this note 953051 this may improve the performance. For status selection profile, refer SAP Help.

[ansar_shaikh2 · Accepted solution]

I checked the status selection profile, even though run time exceeded.

[former_member203108 · Accepted solution]

did you try the note?

[ansar_shaikh2 · Accepted solution]

Yes i tried that note 953051, but its not applicable to my system, our system is 603 & the note not is for 6.

Regards,

ahs

[Former Member · Accepted solution]

What exactly do you want to see in that report Ansar??

[ansar_shaikh2 · Accepted solution]

The project details

I have checked the status selection, ie: status selection profile is given in Activity: Z000016 (Not TECO & Not CNF)

Even though its taking so much time.

Regards,

ahs

[ansar_shaikh2]

OSS replied & the prob was solved.

please find below solution:

After further analysis, I have a few suggestions to provide to you:

1)Can you create a new index containing the following fields and retest? MANDT, LEAD_AUFNR, AUFNR, MAUFNR

Please note that the order of the fields in the index is important - I'drecommend to use the following order: MANDT, LEAD_AUFNR, AUFNR, MAUFNR.

Alternatively, you could add fields AUFNR, MAUFNR to AFKO index 6 which already contains MANDT, LEAD_AUFNR.

2) Could you also review notes 1161411 and 1449807?

regards,

ahs