topic Re: About DB Table in Application Development and Automation Discussions

About DB Table

Former Member — Mon, 17 Sep 2007 05:44:43 GMT

Hi,

I am Using a Standard SAP DB Table "SWFREVTLOG"

I am Writing a Program"ZABC" To call the Last Event ID Which is last generated.

DATA : ID LIKE SWFREVTLOG-EVENT_ID.

SELECT MAX( EVENT_ID ) INTO ID FROM SWFREVTLOG.

Now My Object is ,

When Ever a New EVENT_ID Created then "ZABC" Programme should trigger and run automatically in background.

Wat is the Procedure to do this,

Points will be awarded.

regards,

jayasimha Jangam

Re: About DB Table

Former Member — Mon, 17 Sep 2007 05:50:21 GMT

Your requirement wud be tough to fulfill.

However a workaround wud be to schedule your report in the background to run say every 5 mins. and it shud give you the list of event run since the past 5 mins.

Hope this helps. Award points if so.

Regards.

Re: About DB Table

Former Member — Mon, 17 Sep 2007 05:54:33 GMT

Hi VAnia,

My Requirement is when ever a Event_ID is inserted it should trigger .

Not to schedule.

Regards,

Jayasimha

Re: About DB Table

Former Member — Mon, 17 Sep 2007 05:58:32 GMT

Hi Jayasimha,

Since there is no procedure of triggering a report as soon as there is a new entry in the DB table,it would be better to use Workflow in this case wherein the logic would be to trigger the report as soon as there is a new entry in the DB table.

Ask any of the guys who have worked on workflows or if you know them.

In case, you have any further clarifications,do let me know.

Regards,

Puneet Jhari.

Re: About DB Table

Former Member — Mon, 17 Sep 2007 06:03:22 GMT

Hi Puneet,

Can U help me in Designing the work flow.

I dont know the process.

Regards,

Jayasimha Jangam

Re: About DB Table

Former Member — Mon, 17 Sep 2007 06:08:51 GMT

Hi,

Creating a workflow requires some knowledge about it so that you do not define wrong activities and the triggering events.

You can refer to any of the documents on workflows.

If you want I can forward you the document,please let me know the email ID.

The T-code to start wth is SWDD.

Regards,

Puneet Jhari.

Re: About DB Table

Former Member — Mon, 17 Sep 2007 06:11:30 GMT

Hi Puneet Jhari ,

My Mail ID is jayasimhaj@infotechsw.com.

U can Design the flow and guide me.

Thanx & Regards,

Jayasimha Jangam

Re: About DB Table

Former Member — Mon, 17 Sep 2007 06:19:33 GMT

Hi Jayasimha,

I have forewarded the docuemnts to you.

It would be good if you read them,understand them and also take the help of some workflow guy in your company to build it.

It is very difficult to do it remotely and I guess for your requirement,it is an easy one.

Regards,

Puneet Jhari.