topic Re: how to update the ztable by using table handling function in Application Development and Automation Discussions

how to update the ztable by using table handling function

Former Member — Tue, 26 Jun 2007 04:20:49 GMT

how to update the ztable by using table handling function

It is very urgent ...............................

thanks in advance

Re: how to update the ztable by using table handling function

Former Member — Tue, 26 Jun 2007 04:25:17 GMT

Hi,

Jus check out this link.

may b it'll b useful.

All the best

http://help.sap.com/saphelp_nw04/helpdata/en/22/042d85488911d189490000e829fbbd/frameset.htm

****Reward points if useful

Re: how to update the ztable by using table handling function

Former Member — Tue, 26 Jun 2007 04:33:57 GMT

good

go through this link,hope this ll help you to solve your probelm

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/snippets/tableMaintaenanceProgram&

thanks

mrutyun^

Re: how to update the ztable by using table handling function

Former Member — Tue, 26 Jun 2007 06:43:16 GMT

see the below code for the direct ztable update

Report  ZUPDATE_PRPS.

tables: zprps.

parameter: p_wbs like zprps-pspnr,
           p_value like zprps-fakkz default 'X'.

data: wa_fakkz type zprps-fakkz.


************************************************************************
*START-OF_SELECTION
start-of-selection.

call function 'CONVERSION_EXIT_ABPSP_INPUT'
     exporting
         input     = p_wbs
    importing
         output    = p_wbs
    exceptions
         not_found = 1
         others    = 2.

select single fakkz
  into wa_fakkz
  from zprps
 where pspnr eq p_wbs.
if sy-subrc eq 0.
   update zprps set fakkz = p_value where PSPNR eq p_wbs.
   if p_value is initial.
     message i999(za) with 'Billing element field has been unchecked'.
   else.
     message i999(za) with 'Billing element field has been checked'.
   endif.
else.
  message i999(za) with 'WBS element not found'.
endif.

reward points if it is usefull .....

Girish