topic Re: How to insert/Update date into customized Table? in Application Development and Automation Discussions

How to insert/Update date into customized Table?

Former Member — Wed, 08 Oct 2008 05:09:31 GMT

Dear Experts,

I have created a table with three fields.fileds are (kunnr,audat,zcost)

now i want to insert and update the table with selection screen kunnar,audat and zcost.

Can you plz tell me how to proceed?

Waiting for ur replies...

Thanks and Regards

sriii

KK07 — Wed, 08 Oct 2008 05:13:05 GMT

hi,

if it is custom table table then u can go for direct statements like insert,update,...

for update just use the satement UPDATE,for insert INSERT,for delete DELETE.

press F1 on those to know how to use.

Former Member — Wed, 08 Oct 2008 05:15:19 GMT

write insert then press F1 You can learn by yourself too easy.

Regards,

Midhun abraham

Edited by: Midhun Abraham on Oct 8, 2008 7:16 AM

Former Member — Wed, 08 Oct 2008 05:17:49 GMT

hii reddy,

selection-screen begin of block sel with frame title text-009.

parameters: objectid TYPE crmd_orderadm_h-object_id OBLIGATORY.

parameters: res_time TYPE Ztable-TIME OBLIGATORY.

selection-screen end of block sel.

UPDATE ZSOLMAN_SLA SET TIME = RES_TIME WHERE OBJECT_ID = OBJECTID AND STATUS = 'E0001'.

IF SY-SUBRC = 0.

WRITE : 'RESPONSE TIME SUCESSFULLY UPDATED '.

ELSE.

WRITE : 'COULDNOT BE UPDATED'.

ENDIF.

Similarly ,

use insert statement.

Regards,

sabari

Former Member — Tue, 11 Nov 2008 02:17:59 GMT

issue completed