topic Direct SAP table update issues in Application Development and Automation Discussions

Direct SAP table update issues

Former Member — Sat, 12 Jul 2014 16:42:04 GMT

Hello Experts,

Currently, in my customer system i see one custom program which is updating SAP standard table (SCM EWM) directly using below statement.

"update /SAPAPO/MATLWH set rsqty = zmax_qty where matid = mat_wa_chunk-matid and scuguid = mat_wa_chunk-entitled_id."

I see that program is there in production from last almost 2 years and that is a product quantity update program which has to run periodically.

As per my knowledge, this is not at all acceptable. Can you please share me your thoughts, what kind of problems will occur and pre-defined

errors with direct data base table update?

What should we do now on this?

Thank you in advance.

Re: Direct SAP table update issues

paul_bakker2 — Sun, 13 Jul 2014 03:58:44 GMT

Hi,

SAP usually provides a BAPI or some kind of update routine for updating standard tables.

It is recommended that you use these routines, because they handle all the consistency checks, locking, errors, LUWs etc for you.

What to do now? Try to find a SAP routine for updating this table and use that instead.

cheers

Paul

Re: Direct SAP table update issues

Former Member — Sun, 13 Jul 2014 08:35:15 GMT

Hi Sridhar,

Updating directly in SAP tables is not recommended.Yes as mentioned it may create some inconsistencies.

Use the help of where used list by clicking on the field of the table /SAPAPO/MATLWH and see any Bapis/Function modules are available for doing this.Worst case you can go for a BDC upload.

Also you can request SAP via OSS to help providing an appropriate code.

Regards,

Kannan