topic Re: Performance issue while update the variant table using Fm : CAMA_TABLE_MAINTAIN_ENTRIES in Application Development and Automation Discussions

Performance issue while update the variant table using Fm : CAMA_TABLE_MAINTAIN_ENTRIES

Former Member — Mon, 06 Oct 2014 10:24:01 GMT

Hi,

I have a varinat table with more then 5000 entries.

When this variant table is updated , it takes around 6 seconds approx. to update a single record of the variant table.

So if i want to update 100 records of the table, it will take 600 sec (10 min) appeox. to update the variant table.

This is too long time and has performance issue.

Do ypu know how can i improve the performance?

Is there any other Fm to update the variant table?

Thanks in advance,

Regards,
Sonam.

rajkumarnarasimman — Mon, 06 Oct 2014 11:03:36 GMT

Hi Sonam,

Please find the report program RS_CHANGE_VARIANT in SE38. I hope we can modify the variant using FM RS_VARIANT_CHANGE.

Regards

Rajkumar Narasimman

RaymondGiuseppi — Mon, 06 Oct 2014 11:35:05 GMT

AFAIK there are officially only two tools to update those data

As you got performance problem with the API, you could try to use the IDoc soluton (no warranties, no refunds)

Regards,

Raymond