topic Re: Check before update in table in Application Development and Automation Discussions

Check before update in table

mrahhaoui — Wed, 06 May 2009 12:34:18 GMT

Hi Guru's,

I am a new developper in abap. I have a question concerning the check before the update in a table.

I uploaded a csv file by the function module GUI_DOWNLOAD but now before to do the update I have to check if the correct value for the controlling area and profit centre are used .

I don't know where do my test.

Anyone can help me?

Regards,

Mohamed.

UPDATE

- fill table --> check all values of the file and if one error stop processing and do not update anything in the table

- check if controlling area is correct

- check if profit center is correct

/.....

.....

LOOP AT it_datatab INTO wa_datatab.

split wa_datatab at ';' into

wa_cepc_segm-KOKRS

wa_cepc_segm-PRCTR

wa_cepc_segm-DATBI

wa_cepc_segm-DATAB

wa_cepc_segm-SEGMENT.

APPEND i_cepc.

CLEAR i_cepc.

ENDLOOP.

END-OF-SELECTION.

Re: Check before update in table

Former Member — Wed, 06 May 2009 12:37:14 GMT

Just locate the tables that data is stored in and select it. Then check the value of sy-subrc. If it's 0, the data's been located, thus it's valid.

Re: Check before update in table

Former Member — Wed, 06 May 2009 12:40:01 GMT

Before updating , you can loop the data table and check.

You can filter the wrong inputs.

Otherwise during updation only you will come to know this.

Re: Check before update in table

Former Member — Wed, 06 May 2009 12:40:23 GMT

This message was moderated.

Re: Check before update in table

Former Member — Wed, 06 May 2009 12:57:21 GMT

Hi,

Updating a database table

Single-line updates

SELECT * FROM TABLE

COLUMN-UPDATE STATEMENT

UPDATE TABLE

ENDSELECT

Column updates

UPDATE TABLE SET COLUMN-UPDATE STATEMENT

Regards

Re: Check before update in table

mrahhaoui — Wed, 06 May 2009 14:11:40 GMT

I have to check if the record is alread present in the table and check if the record already present in table for profit center/controlling area

If yes I should have an error

Re: Check before update in table

matt — Wed, 06 May 2009 14:31:42 GMT

The answer marked as corrrect was cut and pasted from http://www.henrikfrank.dk/abaptips/databasetablesandopensql/updating_a_databasetable.htm and has been rejected.