Purchase Order Text Upload Program-Performance Tips

[Former Member]

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

[akshatrander1990]

Hi Bhanu,

Do not validate the POs in LOOP.

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

Regards

Akshat

[Former Member]

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

[former_member202818]

Hi Bhanu,

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

WR

Sreekanth

[Former Member]

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

[Former Member]

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