view updates

[Former Member]

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.

[aris_hidalgo]

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!

[Former Member]

hi

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

update <dbtab> from itab.

regards

Gunjan

[Former Member]

Hi Ambi,

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

(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.

[Former Member]

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,

KK

[Former Member]

HAY GUYS.

<b>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.

[Former Member]

Hi,

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

Regards,

Shashank