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

[former_member623135]

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

[Former Member]

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.

[former_member623135]

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

[former_member623135]

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

[Former Member]

hi sehgal,

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

thanks,

naveen

[former_member623135]

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