Hi ,
I want to programatically modify the value of a certain field in the data base table from a program.
Is there some way by which i can only modify that field.
Let me illustrate my condition , assume i have a table which has
-
Material Number |Material Type | Status |
-
i want to set the status of all material of type 'ABC' to 'X' .
the logic i am following is select all data (all 3 fields) from table into an internal table where material type is 'ABC' , then modify the status field of the records and set it to 'X' and then update the table from this internal table.
Is there some way by which i can modify the table directly without accessing all the records from it.
Thanks
Arun