<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1479" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
}
SPAN.emailstyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial
}
SPAN.EmailStyle20 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=586401121-08092005>We had
the similar problem auditors wanted to track all the changes made to the org.
chart and substitutions for workflow. if we delete the entries of the
assignments in PPOMW, entry from HRP1001 is missing and was not able to track
any changes. after a long research I figured out that there is a table
DBTABLOG which keeps track of all the changes made to update the logs. if
you are designing something for the auditing reporting you can refer to this
table to get most of the information. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=586401121-08092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=586401121-08092005>If we
BYPASS the workflow functionality I don't know if the system would automatically
terminate the workflow's if it does then we have the log of it also.
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=586401121-08092005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=586401121-08092005>Hope
this helps. </SPAN></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial color=#ff00ff size=1><EM>Regards,
</EM></FONT></DIV>
<DIV align=left><FONT face=Arial color=#ff00ff
size=1><EM></EM></FONT> </DIV>
<DIV align=left><FONT size=2><EM><FONT face=Arial><FONT color=#ff00ff><FONT
size=1>Koti,</FONT> </FONT></FONT></EM></FONT></DIV>
<DIV align=left><FONT face=Arial size=2><FONT face=Arial color=#ff0080
size=1><EM>PPC Rockwall DTC, </EM></FONT></DIV>
<DIV align=left>
<DIV align=left>
<DIV align=left><FONT face=Arial color=#800040 size=1><FONT face=Wingdings
color=#804000 size=2>(</FONT>: 972-290-2624</FONT></DIV></DIV>
<DIV> </DIV></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B>On Behalf Of
</B>Gregory Utley<BR><B>Sent:</B> Thursday, September 08, 2005 4:00
PM<BR><B>To:</B> SAP Workflow Users' Group<BR><B>Subject:</B> RE: Workflow
Substitution Report<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">…very nice, accurate
summary. The application is the only reliable source for auditable
information, not workflow. Workflow logs are transitory and not
guaranteed to be the source of the update. T&E is another
application where an approver can (and sometimes does) approve directly in
PR05, bypassing workflow altogether.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Greg</SPAN></FONT></P>
<DIV>
<P class=MsoNormal><FONT face=Tahoma color=navy size=1><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Tahoma"></SPAN></FONT> </P></DIV>
<DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 0.5in; TEXT-ALIGN: center"
align=center><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><B><FONT face=Tahoma
size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Trant, David<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, September 08, 2005 4:16
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> SAP Workflow Users'
Group<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Workflow
Substitution Report</SPAN></FONT></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Will
that definitely show who did the actual approval, though? This issue has
been in the back of my mind for some time now. We wrote some reports
that go directly against some workflow log tables … a big no-no since they
probably won’t work whenever we upgrade from 4.6C. Two years ago, SAP
brought this subject up in an ASUG meeting. At that time, customers
really weren’t using the workflow information system and due to this lack of
interest, SAP made no plans to replace it in BW. Since SOX came along,
I’ve suspect this issue will start to get more visibility. It goes
beyond the mere technical ability to properly read workflow logs, which of
course may be archived long before audit reports require their data.
Since theoretically workflow merely connects the dots of existing processes,
it’s always possible for someone to take action outside the workflow.
Without application-level tracking, we could never be certain who did
what. For example, if a purchase order approval workflow uses release
strategy, or a sales order approval workflow uses the status network to block
and unblock orders, someone could conceivably go directly into the PO release
transaction or the sales order change transaction and modify the release level
or the status. If I’m writing a report, should I look at the workflow
log or the change log? For sales orders, I’m not sure it’s even possible
to track status changes (JEST) via the change log (CDHDR/CDPOS), but that’s
another topic.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Bottom
line, if you want to report on who actually did something rather than who had
the capability of doing something, my thinking at the present is that it is
safest to always go all the way back to the application. Of course, many
applications don’t support digital signatures, change tracking, or other
mechanisms for storing this data, so in those cases it’s simply not
possible.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Best of
luck,</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">David</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV class=MsoNormal style="MARGIN-LEFT: 0.5in; TEXT-ALIGN: center"
align=center><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><B><FONT face=Tahoma
size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Toledo, Joe (NBC
Universal)<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday,
September 08, 2005 12:53 PM<BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> 'SAP Workflow Users'
Group'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Workflow
Substitution Report</SPAN></FONT></P></DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi there
Bob.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I've
used table HR_USD2 to generate a report to show active
substitutions.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I hope
this helps.</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=navy
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
sap-wug-bounces@mit.edu [mailto:sap-wug-bounces@mit.edu] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Schmidt, Bob<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, September 08, 2005 10:00
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B>
sap-wug@mit.edu<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
Workflow Substitution Report</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 1in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 1in"><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt">We are allowing users to create substitution rules in
their workflow inboxes usually a manager delegating to their admin. The issue
we are having is that auditors are requesting a report of workitems processed
by each user and additionally if a substitution rule was involved and whom it
was performed on behalf of.<BR><BR>Has anyone encountered similar requirements
and how was it satisfied?<BR><BR>Regards,<BR>Bob Schmidt </SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"><BR>------------------------------------------------------------------------------------------------<BR>This
message is for the designated recipient only and may<BR>contain privileged,
proprietary, or otherwise private information. <BR>If you have received it in
error, please notify the sender<BR>immediately and delete the original. Any
unauthorized use of<BR>this email is
prohibited.<BR>------------------------------------------------------------------------------------------------<BR>[mf2]</SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>