Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
data: i_aad_tab type standard table zxxv_aad_tab
IF NOT i_aad_tab[] IS INITIAL .
UPDATE zxxv_aad_tab FROM TABLE i_aad_tab[].
IF sy-subrc EQ 0.
* MESSAGE successful update.
LEAVE TO SCREEN '1000'.
ENDIF.
ENDIF.
please help the update doesn't work . can anyone advise
i_aad_tab contain same structure as the update database table and it contain value selected on the selection screen
Check SY-DBCNT value after UPDATE, it will give the number of records updated
Also check SY-SUBRC
If, in the database, there is no row with the same content of the primary key for a row in the internal table, or if the change would lead to a double entry in a unique secondary key, the respective row is not changed and sy-subrc is set to 4. If the internal table is empty, sy-subrc is set to 0
i am updating a field which is also a primary key in my database table
. i used modify and it created a new record which i don't want . and with update it won't undate since if i make changes to primary key it doesn't find the record .
not being able to use update and modify . i think the only option is to remove promary key in the field that i am updating . i need your advise?
you can select all entries from table zxxv_aad_tab into an internal table and than loop through i_aad_tab and check if the entry you created exists already in the DB (i. e. READ TABLE with key fields), than if sy-subrc is not zero, than you can delete from your internal table.
something like this:
DATA : gt_aad_tab TYPE HASHED TABLE OF zxxv_aad_tab
WITH UNIQUE KEY (list key fields here).
SELECT * FROM zxxv_aad_tab INTO gt_aad_tab.
LOOP AT i_aad_tab.
READ TABLE gt_aad_tab WITH KEY all key field TRANSPORTING NO FIELDS.
Just to make sure, have you checked if that Z table has the keys defined correctly (SE11), otherwise your abap statements won't work as expected if table definition is not defined as required.
Bluesky
