topic view updates in Application Development and Automation Discussions

view updates

Former Member — Mon, 26 Jun 2006 03:04:32 GMT

hai guys,

I have view generated program for table ZIF002. which displays all record in table at the screen.

now i want to add new selection screen before that and update view as per the input of select-options.

Can you please suggest me how to update the view.

thanks

ambichan.

Re: view updates

aris_hidalgo — Mon, 26 Jun 2006 03:16:12 GMT

Hi,

After you have generated the view for your z table, you can modify/update your table using tcode SM30. Just put in the table name and click maintain and you can now add/delete/modify records from your z table using a table control.

Regards!

Re: view updates

Former Member — Mon, 26 Jun 2006 04:55:56 GMT

Hi Ambi,

The database update can be done manually by using transaction SM30. If u want a selection screen type of option, you need to design a screen in SE51

(Screen Painter) and then call that screen.

Refer to this Weblog on Table Maintainence.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

Regards,

Arun Sambargi.

Re: view updates

Former Member — Mon, 26 Jun 2006 04:56:43 GMT

select all the records in an internal table ( of the same type as ur db table) and say:

update <dbtab> from itab.

regards

Gunjan

Re: view updates

Former Member — Mon, 26 Jun 2006 05:55:30 GMT

Hi Ambi,

Please create a transaction (type: parameter transaction) for your view maintenance using SE93. Please refer to transaction OBA7 as an example in a R/3 system.

Under "Default values" section in SE93 (whilst creating the new transaction) you can add parameter "UPDATE_LTD" with a value of X. I think that will suit your requirement wherein a selection screen would appear to limit the data displayed on the view maintenance.

Regards,

Re: view updates

Former Member — Mon, 26 Jun 2006 06:23:20 GMT

HAY GUYS.

I HAVE CREATED PROGRAM ZXXX001 USING SE51 WITH SCREEN 9000.

THEN I CALL SCREEN 9000.

>> THIS SCREEN HAS 4FIELDS AS INPUT. AND EXECUTE BUTTON.

IF I EXECUTE THIS BUTTON IT SHOULD CALL THE VIEW SCREEN UPDATING THE RECORDS WITH RESPECT TO SELECTION SCREEN 9000.

BUT I AM NOT GETTING VIEW SCREEN UPDATED WITH MY CURRENT QUERY.

PLEASE CONFIRM.

I HAVE WRITTEN BELOW CODE TOO.

ACUTALLY I HAVE TABLE ZIF002 AND VIEW GENERATED AS *ZIF002.

THIS VIEW I HAVE ASSIGNED TO TRANSACTION "ZIF02". SO I AM CALLING THE TRANSACTION AS BELOW.

PLEASE CORRECT ME WHERE I AM GOING WRONG..[/b

]*&---------------------------------------------------------------------*
*&      Module  USER_COMMAND_9000  INPUT
*&---------------------------------------------------------------------*
MODULE USER_COMMAND_9000 INPUT.
OK_CODE = SY-UCOMM.

CASE OK_CODE.
WHEN 'EXECUTE'.
SELECT * FROM ZIF002 INTO TABLE IT_ZIF002 WHERE KUBUN = '22'.
LOOP AT IT_ZIF002 INTO TW_ZIF002.
UPDATE *ZIF002 FROM TW_ZIF002.  "HERE *ZIF002 IS VIEW AND ZIF002 IS TABLE
ENDLOOP.
CALL TRANSACTION 'ZIF02'.
WHEN 'BACK'.
LEAVE TO SCREEN 0.
WHEN 'EXIT'.
LEAVE SCREEN.
WHEN 'CANCEL'.
LEAVE SCREEN.
ENDCASE.
REGARDS
AMBICHAN.

Re: view updates

Former Member — Mon, 26 Jun 2006 06:29:04 GMT

Hi,

Try using UPDATE ... SET f1 = v1..... fn = vn WHERE...

Regards,

Shashank