BAPI_MATERIAL_SAVEDATA PERFORMANCE ISSUE

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Solved

note 80913 can sloved this issue.

skip the FM GET_STPO_INDRK.

Note 80193 - Performance when creating plant material

[Former Member]

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.