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.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to updated the data into Database table

Former Member
0 Likes
511

Hi Guy's,

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

Thanks and

Hi Guy's,

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

Thanks and

2 REPLIES 2
Read only

Former Member
0 Likes
491

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.

Read only

Former Member
0 Likes
491

Hi Chandu,

Thank you very much for your immediate replay.

Thanks and Regards,

Sai.