2009 Jun 11 2:52 AM
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.
2009 Jun 11 3:36 AM
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.....
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.....
2009 Jun 11 3:36 AM
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.....
2009 Jun 11 3:50 AM
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.
2009 Jun 11 4:00 AM
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..
2009 Jun 11 4:48 AM
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.
-
END
thanq
2009 Jun 11 4:48 AM
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.
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |