Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

About DB Table

Former Member
0 Likes
834

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.

by

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
796

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.

7 REPLIES 7
Read only

Former Member
0 Likes
797

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.

Read only

0 Likes
796

Hi VAnia,

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

Not to schedule.

Regards,

Jayasimha

Read only

Former Member
0 Likes
796

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.

Read only

0 Likes
796

Hi Puneet,

Can U help me in Designing the work flow.

I dont know the process.

Regards,

Jayasimha Jangam

Read only

Former Member
0 Likes
796

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.

Read only

0 Likes
796

Hi Puneet Jhari ,

My Mail ID is jayasimhaj@infotechsw.com.

U can Design the flow and guide me.

Thanx & Regards,

Jayasimha Jangam

Read only

Former Member
0 Likes
796

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.