topic Re: BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE in Application Development and Automation Discussions

BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

Former Member — Thu, 10 Oct 2013 06:51:01 GMT

I want to create material by BAPI_MATERIAL_SAVEDATA.

I have about 60 thousand meterials should be upload to the system.But it is very slow(1 material more than one second ) when i use the bapi BAPI_MATERIAL_SAVEDATA,I use SE30 to check the time and found that FM GET_STPO_IDNRK takes a lot time,I dont know why it will check stpo when I create a material.(table STPO has more than 2million records)

Please help me to resolve this issue performance..

Thanks in advance.

Re: BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

Former Member — Thu, 10 Oct 2013 07:39:20 GMT

Hi Ethan,

As this BAPI is standard and the checking is predefined with the standard method we cannot modify it.

The material can have parts which is saved as component of BOM.

That must be the reson for the check.

Re: BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

Former Member — Thu, 10 Oct 2013 07:55:08 GMT

Solved

note 80913 can sloved this issue.

skip the FM GET_STPO_INDRK.

Note 80193 - Performance when creating plant material

Re: BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

Former Member — Thu, 10 Oct 2013 07:56:25 GMT

Hi Ethan,

you can only increase the performance by following points on consideration:

if the bapi is called in loop then don't commit for each entry instead call commit outside the loop. In this case all will updated together.

2nd thing you can do is that don't call commit, use "set local update on" before the loop then it will automatically locally updated when your program gets finished for time for commit get saved.

Re: BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

Former Member — Thu, 10 Oct 2013 08:56:11 GMT

Hi Nivedita Menon,

You're right,the meterial can have parts which is saved as component of BOM,but I was trying to create a new material which is not exist in system before,So I think the logic of SAP is weired.

And after I used note 80913 ,it skip the logic of checking STPO.So I think it is a bug of sytem.