topic Re: update standard table in Application Development and Automation Discussions

update standard table

Former Member — Thu, 07 Apr 2011 14:34:34 GMT

Hi all.

I have issue to update sap database table from ALV.

Can I update table with internal table which is not type table of that standard table. I have some same fields not all. Only one fileld is for update.

Is it possible if is, please how.

Kind regards.

Re: update standard table

Former Member — Thu, 07 Apr 2011 14:41:54 GMT

Hi Nick

Here is a sample piece of code just for your reference.

<<Dangerous sample code removed by moderator>>

Thanks & Regards

Moderator Message: If you are not sure of the answer - Stay away!

Edited by: kishan P on Apr 8, 2011 12:15 PM

Re: update standard table

Former Member — Thu, 07 Apr 2011 14:46:28 GMT

Which table?

Rob

Re: update standard table

Former Member — Thu, 07 Apr 2011 14:47:47 GMT

But one remembers, the better way to update standard table is using BAPI's.

[ ]'s

Douglas Sant'Ana Santos | SAP ABAP

Linkup SAP

Re: update standard table

RaymondGiuseppi — Thu, 07 Apr 2011 14:48:16 GMT

First the following text only apply to Customer Database Tables, not SAP standard tables that MUST be updated through SAP tools like BAPI or BDC.

There are only two syntaxes allowed for [UPDATE dbtab|http://help.sap.com/abapdocu_70/en/ABAPUPDATE_SOURCE.htm]

- [FROM wa |http://help.sap.com/abapdocu_70/en/ABAPUPDATE_SOURCE.htm#&ABAP_ALTERNATIVE_2@2@] or [FROM TABLE itab|http://help.sap.com/abapdocu_70/en/ABAPUPDATE_SOURCE.htm#&ABAP_ALTERNATIVE_3@3@] require that you first read the whole data as it will replace every non-key field.

- [SET set_expression|http://help.sap.com/abapdocu_70/en/ABAPUPDATE_SOURCE.htm#&ABAP_ALTERNATIVE_1@1@] can change a subset of fields, but you have to use it in a LOOP/ENDLOOP as it change each specified field of every record satisfying the condition of the WHERE option to the same value.

Regards,

Raymond