topic Re: Purchase Order Text Upload Program-Performance Tips in Application Development and Automation Discussions

Purchase Order Text Upload Program-Performance Tips

Former Member — Tue, 07 Apr 2015 05:04:43 GMT

Hi Experts,

I have around 800K purchase orders in a file which i will be accessing from application server to upload PO header note.

This is a one time upload and I have built a custom program and used READ_TEXT, SAVE_TEXT F.M to read existing text and append the new text to old text.

That's about the program but there are couple of PO's which may not exist in SAP and i was validating them like as below:

loop at file. (800K) records

select single ebeln

from ekko

endloop.

1. I don't want to use FAE , just to avoid memory/space issues.

2. Since i am using KEY , it is not too bad during runtime , i have tested with around 30,000 entries in Dev but it will hit the database everytime.

My Question is considering it is a 1 time upload , is select single justifiable here ? If you guys think no what can be a optimum way to do this?

I am not considering LSMW as an option because we will have to write a select single there also to validate the PO.

Thanks

Bhanu

Re: Purchase Order Text Upload Program-Performance Tips

akshatrander1990 — Tue, 07 Apr 2015 05:11:37 GMT

Hi Bhanu,

Do not validate the POs in LOOP.

you can use FOR ALL ENTRIES to feth data from EKKO Table.

Regards

Akshat

Re: Purchase Order Text Upload Program-Performance Tips

Former Member — Tue, 07 Apr 2015 05:23:28 GMT

I think i mentioned the number of records and the reason to not use FAE

Re: Purchase Order Text Upload Program-Performance Tips

former_member202818 — Tue, 07 Apr 2015 05:31:04 GMT

Hi Bhanu,

How about fetching all POs(EBELN) into an internal table from EKKO and read from it for validation?

Sreekanth

Re: Purchase Order Text Upload Program-Performance Tips

Former Member — Tue, 07 Apr 2015 05:34:40 GMT

That is about 1 million records, i mean Total EKKO records in database

Re: Purchase Order Text Upload Program-Performance Tips

Former Member — Tue, 07 Apr 2015 06:38:51 GMT

Guys,

Closing this thread i think i will get more information from BASIS on the memory allocated in the system and will take it from there.

Thanks

Bhanu