HOW TO CHANGE DATA IN STANDARD TABLE

[Former Member]

PLEASE HELP AS PER ABOVE.

THANKS,

LALIT

[Former Member]

PLEASE HELP AS PER ABOVE.

THANKS,

LALIT

[Sm1tje]

using the approriate business transaction...??

[Former Member]

Hi,

If u want to change the values i.e., the data in the standard table..........u hav to write a coding using update........it is possible only through coding not through direct....if u want go to se38 and type update and press f1.

Thanks,

Aruprasad.P

[Former Member]

Hi lalit!

For every table there is corresponding transaction to change it.

which table u r talking about?

Also,u can write a code in se38 using UPDATE statement.

Hope it helps.

reward points.

[Former Member]

This message was moderated.

[Former Member]

Quite simply, you shouldn't update data directly in standard SAP tables.

You should use the business transaction as already suggested, or find a suitable function module from SAP specifically for the purpose.

Gareth.

[Former Member]

Hi , PLease find the below options and reward me if usefull.

1. If you want to update a table which usually gets updated using Transaction process, then change the corresponding field in that corresponding document.

Ex: If you want to change the MATKL field in VBEP table, then for that corresponding Sales order, enter into change mode and change the MATKL field and save the document.

2. If you want to change the entries in bulk, then you should create the custom program and use MODIFY statement.

If you want the syntax, press F1 by placing the cursor on the MODIFY statement in ABAP Editor.

[Former Member]

Hi,

You can use the statements UPDATE / MODIFY to change the DATA in a database table

UPDATE

The statement UPDATE changes the content of one or more lines of the database table specified in target. The entries in source determine which columns of which lines are changed, and how they are changed.

System fields

The statement UPDATE sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc Meaning

0 At least one line has been changed.

4 At least one line was not able to be changed, either because no appropriate line was found, or because the change would generate a line that leads to double entries in the primary key or a unique secondary index in the database table.

The statement UPDATE sets sy-dbcnt to the number of changed lines.

The changes are definitively copied to the database with the next database commit. Until that point, they can still be undone using a database rollback.

MODIFY

ex - modify <dbtab> from TABLE it_tab.

The MODIFY statement inserts one or several lines specified in source in the database table specified in target, or overwrites existing lines.

System fields

The MODIFY statement sets the values of the sy-subrc and sy-dbcnt system fields.

sy-subrc Meaning

0 At least one line is inserted or changed.

4 At least one line could not be processed since there is already a line with the same unique name secondary index in the database table.

The MODIFY statement sets sy-dbcnt to the number of processed lines.

The changes are transferred finally to the database table with the next database commit. Up to that point, they can be reversed using a database rollback.

[Former Member]

I'm curious...

Why are you all suggesting that you can change a STANDARD SAP table via ABAP UPDATE commands?!

Do any of you have the first clue what referential integrity is?! Try this to see how you get on - http://www.google.co.uk/search?source=ig&hl=en&rlz=&q=referential+integrity&meta=

You should NEVER EVER perform a direct update of data against a standard SAP table unless you are 100% sure you know exactly what knock-on effect this may have. Typically this means that the only fields on a standard table you can ever update directly in code are custom fields that have been appended to the standard tables.

Gareth.

[ThomasZloch]

Too late, Lalit has done the needful already based on those useful suggestions...we should see some more "career move" questions soon...

[Former Member]

This message was moderated.

[Former Member]

>

> Hi Lalit you can change data in standard table ,
> follow these steps.
> 
> 1)Go to SE16N
> 2)Enter ur Standard table name ex.vbak
> 3)write &sap_edit(where you put t-code)
> 4)hit enter ,hence you can delete or edit data from standard able.
> 
> Please rewards points if this helps you.
> 
> Thanks

Unbelievable.

You explain how to destroy the data integrity of someone's system doing the one thing anyone with any knowledge of SAP knows you shouldn't do and have the cheek to ask for points for it.

Do you even understand what you would potentially do to a system by deleting entries from a standard SAP table?!

[Former Member]

But what if the System did something ****?

[Former Member]

Hi,

Standard SAP tables should never be Updated using MODIFY/UPDATE statement through Z Programs.

It should only be Updated through Standard SAP Transactions.

Updation of Standard SAP tables is not recommended by SAP and it will lead to serious causes.

Regards,

Anbalagan