topic Re: How to insert alv grid data into database in Application Development and Automation Discussions

How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 07:28:20 GMT

Hi,

How to insert alv grid data into database.

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 07:31:27 GMT

hey,

Can you please make your question clear?your requirement?.

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 07:37:31 GMT

insert your alv records from internal table to database dable using INSERT.

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 07:53:55 GMT

hi priya

1.)Take the backup and after the values changed

compare both the tables....

and find the records which are changed.....

and update them to database.

2.)Check the Program BCALV_GRID_EDIT in se38.

Thanks

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 08:11:17 GMT

Hi,

Purpose why we use ALV grid is to display the output,and Database can hold data in Transparent tables,so you can insert records in ALV grid to database in Tables but you can not insert Grid in database.I hope this answers your question,if you have some other requirement,then do let us know.

Regards,

Neha

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 08:18:57 GMT

Hi,

I have one alv grid and one push button, my question is , whever the use press the push button then only my alv grid data store into the data base. How it is .

Re: How to insert alv grid data into database

Former Member — Mon, 01 Dec 2008 08:34:57 GMT

REPORT ZTEST_DATABASE .

type-pools: slis.

*Table declaration

tables: vbak,vbap.

*internal table

data: begin of i_sales occurs 0,

vbeln like vbak-vbeln,

erdat like vbak-erdat,

audat like vbak-audat,

kunnr like vbak-kunnr,

vkorg like vbak-vkorg,

matnr like vbap-matnr,

netpr like vbap-netpr,

check type c, "checkbox

end of i_sales.

data: begin of i_final occurs 0,

vbeln like vbak-vbeln,

erdat like vbak-erdat,

audat like vbak-audat,

kunnr like vbak-kunnr,

vkorg like vbak-vkorg,

matnr like vbap-matnr,

netpr like vbap-netpr,

end of i_final.

data: v_fieldcat type slis_fieldcat_alv,

gt_fieldcat type slis_t_fieldcat_alv,

gt_layout type slis_layout_alv,

gt_sort type slis_sortinfo_alv,

fieldcat like line of gt_fieldcat.

*Selection screen

parameters: p_vkorg like vbak-vkorg.

select-options: s_vbeln for vbak-vbeln.

*start of selection.

start-of-selection.

perform get_data.

perform fill_fieldcatalog.

perform write_data.

*----

get data

*----

FORM get_data .

select a~vbeln

a~erdat

a~audat

a~kunnr

a~vkorg

b~matnr

b~netpr

into corresponding fields of table i_sales

from vbak as a inner join vbap as b on a_{vbeln = b}vbeln

where a~vkorg = p_vkorg

and a~vbeln in s_vbeln.

ENDFORM. " get_data

*----

write_data

*----

FORM write_data .

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

I_CALLBACK_PROGRAM = sy-repid

I_CALLBACK_PF_STATUS_SET = 'GUI_SET'

I_CALLBACK_USER_COMMAND = 'USER_COMMAND'

IS_LAYOUT = gt_layout

IT_FIELDCAT = gt_fieldcat

TABLES

T_OUTTAB = i_sales .

ENDFORM. " write_data

*----

fill catalog

*----

FORM fill_fieldcatalog .

sort i_sales by vbeln.

clear v_fieldcat.

*for check box

v_fieldcat-col_pos = 1.

v_fieldcat-fieldname = 'CHECK'.

v_fieldcat-seltext_m = 'chek'.

v_fieldcat-checkbox = 'X'.

v_fieldcat-input = 'X'.

v_fieldcat-edit = 'X'.