Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Performance issue on AFPO

Former Member

‎2008 Sep 23 4:50 PM

0 Kudos
152

Performance issue on AFPO

We are trying to get process order number(AUFNR) based on planned order(PLNUM) from AFPO.

As we donu2019t have index on PLNUM in AFPO, Program is getting a performance issue.

Is there any other alternative to get the process order number (AUFNR) based on planned order (PLNUM) with out creating a Index.

Regards,

Ram.

3 REPLIES 3

valter_oliveira
Active Contributor

‎2008 Sep 23 6:19 PM

0 Kudos
74

Please, do not duplicates posts!

Do you realy only have PLNUM? If you have MATNR, KDAUF or PROJN the performance will be good. If not, try to get data from AUFK, and then restrict in AFPO using AUFNR and PLNUM.

Regards,

Valter Oliveira.

Former Member

‎2008 Sep 23 6:23 PM

0 Kudos
74

Duplicate post:

Former Member

‎2008 Sep 23 6:30 PM

0 Kudos
74

This is not a good start for you at SDN...

What made you post here (there is a dedicated performance forum) and then double post the thread?

Please tell me. I would realy like to know.

Cheers and welcome,

Julius