topic Re: update query? in Application Development and Automation Discussions

If you have defined any key field in this table, and you want to modify / add record in this table then this code chage little bit. In that case, firt you have to check if the entry exist in table ZT1 with same key field. If entry exist then you do UPDATE otherwise you do INSERT.

*----------------------------------------------------------------------*
*----------------------------------------------------------------------*
DATA: lit_zt1 LIKE STANDARD TABLE OF zt1 WITH HEADER LINE.

lit_zt1-f1 = 'A'.
lit_zt1-f1 = 'B'.
lit_zt1-f1 = 'C'.
APPEND lit_zt1.

lit_zt1-f1 = 'D'.
lit_zt1-f1 = 'E'.
lit_zt1-f1 = 'F'.
APPEND lit_zt1.


lit_zt1-f1 = '1'.
lit_zt1-f1 = '2'.
lit_zt1-f1 = '3'.
APPEND lit_zt1.

lit_zt1-f1 = '4'.
lit_zt1-f1 = '5'.
lit_zt1-f1 = '6'.
APPEND lit_zt1.

INSERT zt1 FROM TABLE lit_zt1.
*----------------------------------------------------------------------*
*----------------------------------------------------------------------*

Let me know if you have any question.

Regards,

Re: update query?

Former Member — Fri, 06 Apr 2007 15:08:35 GMT

Hi Gopi,

Why to go for Coding?If the Table Maintenance Generator is set, you can update the table using Tcode : SM30 itself.

Hope this helps.

Thanks,

Srinivas

Re: update query?

Former Member — Mon, 09 Apr 2007 04:32:34 GMT

Hi,

I have a function mudule like.

FUNCTION Ztable_update.

*"----

*" IMPORTING

*" VALUE(Zf1) LIKE Ztable-Zfield1

*" VALUE(Zf2) LIKE Ztable-Zfiled2 OPTIONAL

*" VALUE(Zf3) LIKE Ztable-Zfield3 OPTIONAL

*"----

here i need to write code for table update

ENDFUNCTION.

I WANTED TO UPDATE DATA USING FUNCTION MODULE.

Regards

Gopi

Message was edited by:

Gopi Tiyyam

Re: update query?

Former Member — Mon, 09 Apr 2007 04:46:05 GMT

hI Gopi,

in your ABAP editor where you write actual code,

1.on toolbar--->Pattern. CLick on "Pattern" push button.

2. you will get dialog box asking CALL FUNCTION.

3. write your FM "Ztable_update" and press ENter.

4.your FM will be displayed on Editor asking the fields to be exported.

CALL FUNCTION Ztable_updateEXPORTING

Zf1 = Ztable-Zfield1

Zf2 = Ztable-Zfiled2 OPTIONAL

Zf3= Ztable-Zfield3 OPTIONAL

IMPORTING

F1 =
F2 =

In FM "Ztable_update"...

write code with the values to be inserted..like:

data: wa like Ztable.

wa-Zf1 = 'val1'.

wa-Zf2 = 'val2'.

wa-Zf3 = 'val3'.

insert Ztable_update from wa.

Re: update query?

Former Member — Mon, 09 Apr 2007 04:50:16 GMT

FUNCTION Ztable_update.

*"----

*" IMPORTING

*" VALUE(Zf1) LIKE Ztable-Zfield1

*" VALUE(Zf2) LIKE Ztable-Zfiled2 OPTIONAL

*" VALUE(Zf3) LIKE Ztable-Zfield3 OPTIONAL

*"----

DATA : WTAB LIKE Ztable.

WTAB-Zfield1 = ZF1.

WTAB-Zfield2 = ZF2.

WTAB-Zfield3 = ZF3.

UPDATE ZTABLE FROM WTAB.

COMMIT WORK.

OR YOU CAN USE INSERT INTO ZTABLE VALUES WTAB.

ENDFUNCTION.

REGARDS

SHIBA DUTTA

Re: update query?

Former Member — Mon, 09 Apr 2007 04:56:04 GMT

Hi Rammohan,

thank you for immediat resp.

but I wanted to write my own logic/function for this requirement.

Regards

Gopi

Re: update query?

Former Member — Mon, 09 Apr 2007 05:09:59 GMT

SHIBA DUTTA ,

DATA IS NOT UPDATED

GOPI

Message was edited by:

Gopi Tiyyam

Re: update query?

Former Member — Mon, 09 Apr 2007 05:47:58 GMT

IF YOU WANT TO INSERT A NEW ROW THEN USE INSERT AND CHECK WHETHER THE DATA IS UPDATED OR NOT... FIRST OF ALL CHECK IN SE11 WHETHER YOU CAN ABLE TO INSERT THE DATA OR NOT .. GO TO SE11 GIVE ZTABLE NAME AND CHECK IN DELIVERY AND MAINTENANCE TAB WHETHER YOU DEFINE THE MAINTENANCE ALLOWED OR NOT ? THEN CHECK IN MENU UTILITIES--~~> TABLE CONTENTS~~->CREATE ENTRIES TO SAVE A DATA WHETHER YOU CAN INSERT THERE OR NOT... IF IT IS WORKING THEN USE WITH INSERT COMMAND...

REGARDS

SHIBA DUTTA