Skip to Content
avatar image
Former Member

Customized PO History Extractor performance issues

Hi Friends,

We are facing performance issue while pulling the data to PSA from one of our Customized PO History Extractor from ECC.

Extractor was created based on View (Tables EKPO, EKBE, EKKO)

Note: Info Package does not have routines in Data Selections.  However currently we are splitting the loads based on Purchasing Organizations.

Currently it is pulling more than 8 lakh records on daily basis for purchasing organization 0076 itself, which is consuming more than 3 hours for single purchasing organization.  Moreover it is a full load.

Appreciate if any one come up with any suggestions in this regards,

Best Regards

Sudhakar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 21, 2015 at 06:52 AM

    8 lakh = 800000?

    That's actually not that much... if it takes more than 3 hours to load, I would actually look at system availability around the time it loads (maybe some other "heavy" stuff is going on).

    Depending on how long your POs can be "open" (I worked at a client where that could be a couple of years and this work around was not an option) you could work with "pseudo" deltas (based on EKKO-AEDAT) and only pull POs created and/or changed since yesterday.

    Add comment
    10|10000 characters needed characters exceeded