topic Re: Track user changes in customized transparent table in Application Development and Automation Discussions

Track user changes in customized transparent table

Former Member — Thu, 11 Jun 2009 01:52:00 GMT

Greetings..

How do i to track user changes in my table ? is there any master table that keep track changes made by user on the specific field.? Is there possible if the table have the original and changed data.

Re: Track user changes in customized transparent table

madan_ullasa — Thu, 11 Jun 2009 02:36:50 GMT

Hi,

Create a table maintenence and then in the code of this generated view update another table with the user name, date and old value when ever the table is maintained.

regards,

Madan.....

Re: Track user changes in customized transparent table

Former Member — Thu, 11 Jun 2009 02:50:12 GMT

is it possible to retrieve data from table maintenance ? This mean i need to create another table to fill the changes value, sorry I'm bit lost here.

Re: Track user changes in customized transparent table

madan_ullasa — Thu, 11 Jun 2009 03:00:01 GMT

It is possible. You can access the field in the generated code of the table maintenence... Once you get these values, update the username, date and old values in another custome table..

regds,

Madan..

Re: Track user changes in customized transparent table

Former Member — Thu, 11 Jun 2009 03:48:16 GMT

Hi,

From your requirement some of the terms are not much clear. What do you mean by Customized Transparent Table? What kind of changes you want track in the Table?

In the Transparent Table -> Technical Settings -> You can check the Log data Changes Checkbox. Please go through the documentation for the dependency scenarios which you need to take care.

You can use the TX : SCU3 to evaluate the log of the changed Table.Have a look at the following link for some details:

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c7/69bcd2f36611d3a6510000e835363f/frameset.htm

Hope this helps.

Thanks,

Samantak.

Re: Track user changes in customized transparent table

Former Member — Thu, 11 Jun 2009 03:48:31 GMT

i got the below explanation from other thread, which has explained by an expert, so, take it as reference and interprete according to ur req.

BEGIN

Table Events:

Go to SE11 and open your Ztable

click on the Table maintenance generator.

you can find the function group. right

Take the Function group name and go to Tcode SE37

and open the Function Group.

In the Status of the small window of the Function

group display

you can find out change requests , Main program and

Function group Docu tabs.

Click on Main program and create user defined Include.

check the sample code below

Click on main program

Create user defined include

***********************************************************

********

User-defined Include-files (if necessary). *

***********************************************************

********

INCLUDE LZPHIRF... " Subprograms

INCLUDE LZPHIRO... " PBO-Modules

INCLUDE LZPHIRI... " PAI-Modules

Create the below include.

INCLUDE LZPHIRI01. " PAI-Modules

Double click on the Include name. you have the below

code

Loop at Extract.

module liste_init_workarea.

chain.

field fild1

field fild2

---

field fild n

module set_update_flag on chain_request.

*********************************************

You have to add a new module here

check the below code

*********************************************

*----User defind module

Module user_defind_validation.

endchain.

Double click on module write code in that.

Include <Include Name> *

&----

*& Module user_defind_validation

&----

Module user_defind_validation.

Here you can write your own validations.

field2 = field1 /2.

field4 = field1 /4.

if field4 field3.

message.

endif.

EndModule. "user_defind_validation

Events allow you to change the generated table

maintenance dialog at predefined positions, which

cannot be reached by user modules in the screen flow

logic.

The user routines are called dynamically at runtime.

For this reason, the routines must be in a user include

in the table/view maintenance dialog function group.

All extended table maintenance global data is available.

An interface is only required for events 22 and AF.

The events can be additions or replacements.

Additional events

Event 01 before saving the data in the database

This event occurs before new, changed or deleted

entries are written to the database

FORM abc.

DATA: F_INDEX LIKE SY-TABIX. "Index to note the

lines found

LOOP AT TOTAL.

IF <ACTION> = desired constant.

READ TABLE EXTRACT WITH KEY <vim_xtotal_key>.

IF SY-SUBRC EQ 0.

F_INDEX = SY-TABIX.

ELSE.

CLEAR F_INDX.

ENDIF.

(make desired changes to the line TOTAL)

MODIFY TOTAL.

CHECK F_INDX GT 0.

EXTRACT = TOTAL.

MODIFY EXTRACT INDEX F_INDX.

ENDIF.

ENDLOOP.

SY-SUBRC = 0.

ENDFORM.

thanq