How to capture date and time of a particular value in a look up table ?

[Former Member]

Hi All,

I have a look up table- Initial, Approved and Rejected on the main table and I need to store the approved date on the main table..

So Process is : Initially a record is created it will be in initial mode and after some days approval will check the record and approves it.. Once it approved I need to store the date and time.. Is it possible wiht out workflow?

There may be a situation where a record can go to rejected status after some day once approved and again after making some changes it will come back to approved staus but I need to store the first time approved date and time.. Please adivise how to get this acheived.

Thanks

Rajeev

[Former Member]

Hi Rajeev,

A simple solution would be creating a Tuple/Qualified table/Other table with Userstamp and timestamp,this table should get popuated everytime record is changed.This will be good for Audit Trail.

Let me know if any other details are required.

Thanks,

Ravi

[Former Member]

Hi,

Even if I create three more datetime fileds how can I track the initial approval timestamp? Can you please give me more information on this.

Thanks

Rajeev

[Former Member]

Hey Rajeev,

Its a simple solution,Just make UserStamp field and timestamp field in Main Table,this will be named as Created by and this is created by default if you are using Standard content.

And for the other requirement create a Tuple/Qualified table which will hold all the update information with time.

The data import to this tuple will be based on update time and updated by fields,which are also present in Main table.

So basically what I am trying to say is,Create by is main table field and as there are multiple stages of approval/rejection there can be multiple updated by's.So create a tuple to hold these various values as normally MDM only captures last updated info.

Thanks,

Ravi

[Former Member]

Hi Ravi,

Thanks for your reply.. But my query is

I have a look up table- Initial, Approved and Rejected on the main table and I need to store the approved date on the main table..

So Process is : Initially a record is created it will be in initial mode and after some days approval will check the record and approves it.. Once it approved I need to store the date and time.. Is it possible wiht out workflow?

There may be a situation where a record can go to rejected status after some day once approved and again after making some changes it will come back to approved staus but I need to store the first time approved date and time.. Please adivise how to get this acheived.

Records in MDM can be created using import Manger or manually in MDM Data Manager..

Finally I need to send to legacy system if the record is created or updated and I can distinguish only when I get the Approved date and time.. If it is approved then its create.. from then on if user updates any other fields then update......and after some days they change to reject and then aprpove the look up table then its update..

Any inputs please..

Thanks

Rajeev

[Former Member]

Hi Rajeev,

For ur requirement,create a text field(for date) say T_Date and user stamp field in main table.Now cerate an assignment for this text field T_Date which will check if lookup value is approved and T_Date is null and if both holds true return current system time.

Whenever u start new workflow reset the T_Date value to null through assignment.

If you want to capture user stamp then concatenate the userstamp value with this date field .

Regards,

Neethu Joy

[Former Member]

HI Neetu,

I dont want to use any workflow and assignment (whcih requires manuall interaction)... So Is it possible with out having any workflow and assignments?

Regards,

Rajeev

[Former Member]

Hi Rajeev,

Can you please explain how your lookup value is changing from initial to approved or rejected.

Is it manual or based on some workflow.

Regards,

Neethu Joy

[Former Member]

HI Neetu,

Scenario is as below:

I have a look up table- Initial, Approved and Rejected on the main table and I need to store the approved date on the main table..

So Process is : Initially a record is created it will be in initial mode and after some days approval will check the record and approves it.. Once it approved I need to store the date and time.. Is it possible wiht out workflow?

There may be a situation where a record can go to rejected status after some day once approved and again after making some changes it will come back to approved staus but I need to store the first time approved date and time.. Please adivise how to get this acheived.

Records in MDM can be created using import Manger or manually in MDM Data Manager..

Thanks

Rajeev

[Former Member]

Hi Rajeev,

Technically it is possible that approver logs into the MDM Data Manager and will set the value as approved.But who will monitor if record is approved in the specified time, or it is rejected.

When u have set governance rules or a process it is imp to have workflow which guides each and evry user in the loop whith right activity.

I dont know about the limitations you have in using a workflow but automatically if u want time stamp to set based on some value it is not possible u need to use assignments as Time stamp is field dependent not value.

If you need any further help do post .

Regards,

Neethu Joy

[Former Member]

Hello,

Create 3 Date(time stamp) field in the main table, which will capture the date and time.

also create 3 assignments, and call this assignments from your portal application.

regards,

Abhishek

[Former Member]

Abhishek

Can you please reply to my thread scn.sap.com/thread/3467367.

Samething regarding to capture the intial user and modifed user.

Regards

Shifali