topic Re: how to update database table using table control with wizard??? in Application Development and Automation Discussions

how to update database table using table control with wizard???

former_member623135 — Thu, 23 Jan 2014 11:44:09 GMT

Dear Experts

I have created a module pool using table control with wizard....

Now i want to modify my database table using this table control with wizard....

i.e.

when i run my module pool it displays a table with data in it...

now i want to update database table through this table control...

kindly guide me how can i do this...

Thanks in advance

Re: how to update database table using table control with wizard???

Former Member — Fri, 24 Jan 2014 05:53:53 GMT

hi sehgal,

in pai

loop at <table control> into <wa>.

append <wa> into <itab>.

endloop.

place one button into ur screen

ex: case sy-ucomm.

when 'SAVE'.

MODIFY <DBNAME> FROM TABLE <ITAB> ACCEPTING DUPLICATE KEYS.

ENDCASE.

Thanks@Regards,

R.Naveen.

Re: how to update database table using table control with wizard???

former_member623135 — Fri, 24 Jan 2014 09:38:25 GMT

Dear Naveen Ji

thanks for ur help...

can u plz elaborate this concept??

u kindly help me in data declaration..

m using following detail:-

CONTROLS: TABD TYPE TABLEVIEW USING SCREEN 0100

TABLES: ZTEMP..

With Lot of Thanks

Sehgal

Re: how to update database table using table control with wizard???

former_member623135 — Mon, 27 Jan 2014 12:40:12 GMT

Hello sir

i m bit confused..

can u plz give me some sample code of this...

m using following :-

TABLES: ZTEMP

TYPES: BEGIN OF T_TABD,

MANDT LIKE ZTEMP-MANDT,

COR_CODE LIKE ZTEMP-COR_CODE,

ORDERNUMBER LIKE ZTEMP-ORDERNUMBER,

ORDERDATE LIKE ZTEMP-ORDERDATE,

ORDERTYPE LIKE ZTEMP-ORDERTYPE,

INV_NO LIKE ZTEMP-INV_NO,

INV_DATE LIKE ZTEMP-INV_DATE,

MARK LIKE ZTEMP-MARK,

END OF T_TABD.

DATA: G_TABD_ITAB TYPE T_TABD OCCURS 0,

G_TABD_WA TYPE T_TABD. "work area

CONTROLS: TABD TYPE TABLEVIEW USING SCREEN 0100.

.........

...........

MODULE TABD_INIT OUTPUT.

IF G_TABD_COPIED IS INITIAL.

*&SPWIZARD: COPY DDIC-TABLE 'ZTEMP'

*&SPWIZARD: INTO INTERNAL TABLE 'g_TABD_itab'

SELECT * FROM ZTEMP

INTO CORRESPONDING FIELDS

OF TABLE G_TABD_ITAB

WHERE ORDERNUMBER IN ORDNMBR

AND ORDERDATE IN ORDDATE

AND DELV_NO NE 'ABC'

AND INV_NO NE ' DEF'

AND LAST_DOC EQ ''...

G_TABD_COPIED = 'X'.

SORT G_TABD_ITAB BY ORDERNUMBER ORDERDATE.

REFRESH CONTROL 'TABD' FROM SCREEN '0100'.

ENDIF.

ENDMODULE.

.............................

...............................

MODULE USER_COMMAND_0100 INPUT.

CASE sy-ucomm.

WHEN 'EXIT'.

LEAVE PROGRAM.

WHEN 'PROCESS'.

READ TABLE G_TABD_ITAB INTO G_TABD_WA WITH KEY MARK = 'X'.

???????????????

?????????????????

ENDCASE.

ENDMODULE.

KINDLY GUIDE ME WAT TO CODE IN "PROCESS" TO UPDATE DATABASE AS TOMORROW IS DEADLINE...

Thanks

Sehgal

Re: how to update database table using table control with wizard???

Former Member — Wed, 29 Jan 2014 05:23:23 GMT

hi sehgal,

when click 'process' button what u will do i.e waht is your requirement and what is mark = 'x'

thanks,

naveen

Re: how to update database table using table control with wizard???

former_member623135 — Wed, 29 Jan 2014 06:38:11 GMT

Dear Sir

my requirement is dat whenever i get output in my table control wizard i want to give user option to modify dat data which in turn effect database table ZTEMP.

m using button "PROCESS" for this thing...i want u to give me code for "PROCESS".

e.g. there is field in table ZTEMP named ORDERDATE...

my program give output value in this field of table wizard 27.01.2014.

i want to give user option to change this date to 28.01.2014 or any date whenever he press "PROCESS" pushbutton...

Can u plz give me ur mail id so dat i can elaborate u my requirement....

m using following code

Kindly guide me where i m lacking.

TABLES: ZTEMP.

CONTROLS: TABD TYPE TABLEVIEW USING SCREEN 0100.

DATA: G_TABD_ITAB TYPE T_TABD OCCURS 0,

G_TABD_WA TYPE T_TABD. "work area

DATA:BEGIN OF ITAB OCCURS 0.

INCLUDE STRUCTURE ZTEMP.

DATA END OF ITAB.

DATA:WA_ZTEMP LIKE LINE OF ITAB.

MODULE TABD_INIT OUTPUT.

IF G_TABD_COPIED IS INITIAL.

*&SPWIZARD: COPY DDIC-TABLE 'ZTEMP'

*&SPWIZARD: INTO INTERNAL TABLE 'g_TABD_itab'

SELECT * FROM ZTEMP

INTO CORRESPONDING FIELDS

OF TABLE G_TABD_ITAB

WHERE ORDERNUMBER IN ORDNMBR

AND ORDERDATE IN ORDDATE.

G_TABD_COPIED = 'X'.

SORT G_TABD_ITAB BY ORDERNUMBER ORDERDATE.

REFRESH CONTROL 'TABD' FROM SCREEN '0100'.

ENDIF.

ENDMODULE.

MODULE USER_COMMAND_0100 INPUT.

CASE sy-ucomm.

WHEN 'PROCESS'.

READ TABLE G_TABD_ITAB INTO G_TABD_WA WITH KEY MARK = 'X'.

SELECT * FROM ZTEMP INTO ITAB WHERE ORDERNUMBER = G_TABD_WA-ORDERNUMBER.ENDSELECT.

Loop at ITAB into WA_ZTEMP.

ENDLOOP.

MODIFY ZTEMP FROM WA_ZTEMP.

COMMIT WORK.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

ENDCASE.

ENDMODULE.

Thanks

Sehgal