topic Re: Update Ztable in database in Application Development and Automation Discussions

Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:28:29 GMT

hai,

i want to update the database of a ztable with one condition.wht i need to do now.

regards,

Max

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:30:56 GMT

Use

IF <DATA> EQ <CONDITION>.

UPDATE <TABLE> FROM <WAREA>.

ENDIF.

or UPDATE proj SET txtsp = sy-langu WHERE pspid = wa_project-pspid.

Please post your code for better response.

Regards

Kathirvel

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:31:06 GMT

just write a program ,demo is -

update ztable set field1 = '123' where field2 = '2' and

field3 = '3' .

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:32:51 GMT

Hi,

Write a program and using UPDATE the field with the condition.

UPDATE <filed> where <condition>

regards

Sabu

Re: Update Ztable in database

former_member508729 — Thu, 28 Dec 2006 09:33:20 GMT

Hi,

you can update ur z table like

update ztable

set fields to be updated

where ur condition

Regards

Ashutosh

Reward points if helpful

Message was edited by:

ashutosh ambekar

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:33:23 GMT

loop at itab.
update ztable set field1 = value1
where field2 = itab-value2 .
endloop.

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:33:46 GMT

UPDATE sflight SET   seatsocc = seatsocc + 3 
               WHERE carrid   = 'LH'   AND 
                     connid   = '0400' AND 
                     fldate   = '20010228'.

Re: Update Ztable in database

Former Member — Thu, 28 Dec 2006 09:34:53 GMT

HI Raju,

welcome to SDN.

just have a button ,so when u press the button ,hav the screen fields like ur screen and statement like

_______________________

tables Ztable.

case sy-ucomm.

when 'button1'.

INSERT ZTABLE .

endcase.

_______________________

regards,

siva

Re: Update Ztable in database

alex_m — Thu, 28 Dec 2006 09:40:53 GMT

write a code for that condition, if success update the table.

Alex