Hw to insert data into database table using table control

Former Member — Mon, 24 Mar 2008 11:24:05 GMT

Hi friends,

Hw to insert data into database table using table control.

Thanks & regards,

Madhu

Re: Hw to insert data into database table using table control

Former Member — Mon, 24 Mar 2008 11:34:44 GMT

hi,

in user_command module of PAI, write this on SAVE button..

WHEN 'SAVE' OR 'SV'.

LOOP AT itab_det INTO wa_det.

INSERT INTO zform_track_det VALUES wa_det.

ENDLOOP.

Re: Hw to insert data into database table using table control

Former Member — Mon, 24 Mar 2008 11:49:46 GMT

to do this in PAI do coding fr save button say take an example of storing data into database table z14_eket with data entered in tablecontrol G_TABCTRL2_ITAB

IF OK_CODE EQ 'SAVE'.

LOOP AT G_TABCTRL2_ITAB INTO G_TABCTRL2_WA.

(here G_TABCTRL2_WA is work area of table control G_TABCTRL2_ITAB )

IF G_TABCTRL2_WA-ETENR IS NOT INITIAL AND G_TABCTRL2_WA-EINDT IS NOT

INITIAL AND G_TABCTRL2_WA-MENGE IS NOT INITIAL.

Z14_EKET-EBELN = Z14_EKKO-EBELN .

Z14_EKET-EBELP = G_TABCTRL2_WA-EBELP.

Z14_EKET-ETENR = G_TABCTRL2_WA-ETENR.

Z14_EKET-EINDT = G_TABCTRL2_WA-EINDT.

Z14_EKET-MENGE = G_TABCTRL2_WA-MENGE.

MODIFY Z14_EKET.

ENDIF.

ENDLOOP.

MESSAGE 'SUCCESSFULLY SAVED ! ' TYPE 'I'.

This way data is saved succesfully into database table z14_eket from corresponding fields entered in table control

try it out..this would surely help

reward if useful

where ok-code=sy-ucomm is declared in top include of module program

topic Hw to insert data into database table using table control in Application Development and Automation Discussions

Hw to insert data into database table using table control

Re: Hw to insert data into database table using table control

Re: Hw to insert data into database table using table control