How to updated the data into Database table

Former Member — Wed, 16 Apr 2008 09:22:14 GMT

Hi Guy's,

Please help me Using Tabstrip control how to updated the related infotype records into related database table.

Thanks and

Re: How to updated the data into Database table

Former Member — Wed, 16 Apr 2008 09:31:04 GMT

hi Sai,

u create tab strip in module pool prog in that u create a button

for update and when u click on that button u can fetch the required data from tbstrip-screen and update to the related database table,

ex:

PROGRAM ZB_DIALOG_PROGRAM5.

TABLES : LFA1,EKKO,EKPO.

DATA:BEGIN OF ITAB OCCURS 0,

EBELN LIKE EKKO-EBELN,

AEDAT LIKE EKKO-AEDAT,

ERNAM LIKE EKKO-ERNAM,

END OF ITAB.

DATA:BEGIN OF JTAB OCCURS 0,

EBELP LIKE EKPO-EBELP,

MATNR LIKE EKPO-MATNR,

END OF JTAB.

*DATA:OK-CODE TYPE SY-UCOMM,

DYNNR TYPE SY-DYNNR.

CONTROLS:TS TYPE TABSTRIP.

&----

*& Module USER_COMMAND_0100 INPUT

&----

text

----

MODULE USER_COMMAND_0100 INPUT.

*CASE SY-UCOMM.

WHEN 'PORDER'.
DYNNR = '200'.
WHEN 'ITEM'.
DYNNR = '300'.

ENDCASE.
IF OK-CODE(3) = 'TAB'.
tab_strip-activetab = ok_code.
ENDIF.

CASE SY-UCOMM.

WHEN 'DISPLAY'.

SELECT EBELN AEDAT ERNAM FROM EKKO INTO TABLE ITAB WHERE LIFNR = LFA1-LIFNR.

SELECT EBELP MATNR FROM EKPO INTO TABLE JTAB WHERE EBELN = EKPO-EBELN.

WHEN 'EXIT'.

LEAVE PROGRAM.

ENDCASE.

ENDMODULE. " USER_COMMAND_0100 INPUT

&----

*& Module STATUS_0200 OUTPUT

&----

text

----

MODULE STATUS_0200 OUTPUT.

SET PF-STATUS 'xxxxxxxx'.
SET TITLEBAR 'xxx'.

LOOP AT ITAB.

MOVE-CORRESPONDING ITAB TO EKKO.

ENDLOOP.

ENDMODULE. " STATUS_0200 OUTPUT

&----

*& Module STATUS_0300 OUTPUT

&----

text

----

MODULE STATUS_0300 OUTPUT.

SET PF-STATUS 'xxxxxxxx'.
SET TITLEBAR 'xxx'.

EKPO-EBELN = EKKO-EBELN.

LOOP AT JTAB.

MOVE-CORRESPONDING JTAB TO EKPO.

ENDLOOP.

ENDMODULE. " STATUS_0300 OUTPUT

&----

*& Module STATUS_0100 OUTPUT

&----

text

----

MODULE STATUS_0100 OUTPUT.

SET PF-STATUS 'xxxxxxxx'.
SET TITLEBAR 'xxx'.

*IF TS-ACTIVETAB IS INITIAL OR DYNNR IS INITIAL.

TS-ACTIVETAB = 'PORDER'.
DYNNR = '200'.

ENDIF.

ENDMODULE. " STATUS_0100 OUTPUT.

the above is to display req list in particular tab strip.

like that u create a button and write code for that in PAI.

regards,

chandu.

Re: How to updated the data into Database table

Former Member — Wed, 16 Apr 2008 10:29:00 GMT

Hi Chandu,

Thank you very much for your immediate replay.

Thanks and Regards,

Sai.

topic Re: How to updated the data into Database table in Application Development and Automation Discussions

How to updated the data into Database table

Re: How to updated the data into Database table

Re: How to updated the data into Database table