topic Re: editable alv ? in Application Development and Automation Discussions

editable alv ?

Former Member — Mon, 20 Aug 2007 08:59:04 GMT

hi friends..

i have one basic doubt.

we can edit the data in grid.

my question is is it reflected in database.

ie the modified data will updated in database or not ?

can you send me sample program for this scenario ?

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:01:00 GMT

HI,

no it will not be reflected in DB.

it will be reflected only in the internal table which u r using to hold the data in alv.

reward if helpful

rgds,

bharat.

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:03:05 GMT

Hi,

you can modify the data base tables from alv

but it is not suggestable as the std tables should be modified through

std transactions or bdc programs or bapi ..

through alv

in the fiedl catalog you have the option for edit

for a particular field

catalog-edit = 'X'.

and then display it

after seeing the display you can edit that field

when you clik the save button

capture the sy-ucomm code and do the coding accordingly

and in the user command you have to take those values and modify your

internal table and

then you can use the statements

modify ztable from table itab.

or update ztable from table itab.

thanks & regards,

Venkatesh

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:03:08 GMT

Hi,

The Update won't reflect in Database Tables.Because while displaying the Grid,u will use only the Internal Table & not the Database Table.

If u modify the grid,it will affect only the Internal Table & not the Database Table.

U just display the Internal Table Values & Database Table Values after Updating the Grid.U come to know this.

Regards,

Padmam.

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:03:12 GMT

Refer to this report

BCALV_FULLSCREEN_GRID_EDIT

Regards

Ravish

Reward if helpful

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:03:21 GMT

H selva,

No it will not be reflected in Database,

and AS as friend i want to tell one thing,

this question was answerd number of times in this forum itself,

before posting any question plz plz verfiy carefully, if ur not satisfied then u post it.

sorry selva if u feel bad .

Reward points if u think there is some useful meaning in this thread.

Thanks

Naveen khan

Message was edited by:

Pattan Naveen

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:04:15 GMT

Hi Selva,

check out this thread,

hope this helps.

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:04:31 GMT

Hello,

follow this link for sample program on editable ALV.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webas/abap/abap%20code%20samples/alv%20grid/abap%20code%20sample%20to%20edit%20alv%20grid.doc

Regards,

Deepu.K

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:05:13 GMT

good

yes if you r editing any data in the grid than it ll update the data accordingly.

http://www.erpgenie.com/abap/controls/alvgrid.htm

thanks

mrutyun^

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:22:08 GMT

k naveen..

sorry 4 this..

i will correct it future

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:24:39 GMT

suppose i want to edit the data in alv..this should be reflected in database ?

how i do this ?

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 09:42:40 GMT

Hi Selva,

If the changes should reflect in the Database means,first u have to update the Internal Table Values.After that using Internal Table Values u can update the Database Values.

If u edit some Field in Grid,it wont reflect in the Internal Table.For that u have to call one method CHECK_CHANGED_DATA

For Eg.,

CASE OKCODE.

WHEN 'UPDATE'.

CALL METHOD <ur grid name>->CHECK_CHANGED_DATA.

ENDCASE.

It will Update only the Internal Table Values.U have to write codings for Updating the Database Tables.

In my Scenario,I used BAPI for Updating the Database Tables from Internal Table.

Regards,

Padmam.

Re: editable alv ?

Former Member — Mon, 20 Aug 2007 11:30:52 GMT

hi padman..

which Bapi you used for your program can you please...

As u mentioned

CASE OKCODE.

WHEN 'UPDATE'.

CALL METHOD <ur grid name>->CHECK_CHANGED_DATA.

ENDCASE.

to use this should i need to use class. if s pls let me know the class name and how to use?

in my scenario i am using the reuse_alv_grid_display. Function module.

after changing the data in the output of result. how could i change my internal table