topic Re: tracking objects and updating a table in Application Development and Automation Discussions

tracking objects and updating a table

Former Member — Mon, 09 Jun 2008 10:53:26 GMT

Hi,

I have 12 programs and whenever i run any of the programs a ztable shoud be updated (created by me) with program name , rundate and no of times it is executed.

This functionality should be written in a separate fumction module.

so could any pls send me some sample code for this

Thanks in advance

Re: tracking objects and updating a table

former_member435013 — Mon, 09 Jun 2008 11:05:37 GMT

Hi,

for reports you may use a user-exit.

Transaction code SMOD:

-> enhancement S38MREP1 -> Function module EXIT_SAPLSABE_010.

regards

Walter Habich

Re: tracking objects and updating a table

Former Member — Mon, 09 Jun 2008 11:31:47 GMT

Hi,

CALL FUNCTION 'z_update_fm'.

EXPORTING

repid = v_repid

check for any entry in table ztab with repid.

IF sy-subrc NE 0. "entry does NOT exist in the table

wa_ztab-rundt = sy-datum.

wa_ztab-repid = v_repid. " prog name

wa_ztab-count = 1.

APPEND wa_ztab TO it_ztab.

CLEAR wa_ztab.

IF it_ztab[] IS NOT INITIAL.

INSERT ztab FROM TABLE it_ztab.

ENDIF.

ELSE.

UPDATE ztab SET rundt = sy-datum

AND count = wa_ztab-count + 1

WHERE repid = v_repid. " prog name

ENDIF.

regards,

teja.