Maintain History, Track Changes in Layout

[Former Member]

Dear Experts,

We have couple of forecast users sharing forecast system, at time we come across incorrect data which results in wrong calculations and total.

Is there a way in which we can track data entered in layout, i mean when and by which user id values were entered ?? something like maintaining history so that can go back and debug who made mistake ??

Appreciate any ideas and help on this...

Thanks,

Regards...

[Former Member · Accepted solution]

Hi,

You can simply create one master data to capture the details of users and time.

Also create a function module to populate this master data with details like user id, date and time. Include this function module in planning folder and set the property as "Execute on save".

This will track who saved the layout last.

[Former Member · Accepted solution]

Thanks for suggestion, will try this option.

Regards

[chemicala_srimallikarjuna]

Hi,

Pls try this;

1.The user id who is planning and the date,period, on which they are planning will be stored in the cube. Design additional characteristics for User & Date in your RTP to record who changed when and what plan record.

2. Then create a characteristic relationship of type 'Exit Class' to derive User Id(last changed by) and the date(last modified). Itu2019s not necessary to include User-ID and Date in any of the aggregation levels, but the Source Characteristic( for example, Company code in your case) based on which the values are derived for User-ID & Date, must be present in each aggregation level.

3.Then create a custom class say ZCL_LOC_CR_LINE_ITEM by taking class CL_RSPLS_CR_EXIT_BASE as super class and then redefine the method DERIVE of interface IF_RSPLS_CR_METHODS in your class.

The sample code in your method DERIVE:

________________________________________

CLEAR e_t_mesg.

FIELD-SYMBOLS: <l_chavl> TYPE ANY.

ASSIGN COMPONENT '/BIC/ZUSERID' OF STRUCTURE c_s_chas TO <l_chavl>.

<l_chavl> = sy-uname.

ASSIGN COMPONENT '0DATE' OF STRUCTURE c_s_chas TO <l_chavl>.

<l_chavl> = sy-datlo.

________________________________________

4..A simple report can be built on the top of this cube, which gives list of users who have done changes to the data in that Date/period

Also chk this link;

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0e3df0c-c370-2910-a696-96f5f385...

Regards

CSM Reddy