<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 5 6 2 2 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.l1s311
{mso-style-name:l1s311;
font-family:"Courier New";
color:gray;
background:white;
font-style:italic;}
span.l1s521
{mso-style-name:l1s521;
font-family:"Courier New";
color:blue;
background:white;}
span.l1s321
{mso-style-name:l1s321;
font-family:"Courier New";
color:#3399FF;
background:white;}
span.l1s331
{mso-style-name:l1s331;
font-family:"Courier New";
color:#4DA619;
background:white;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Dale, below is the code I wrote to get the approval levels and approvers.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span class=l1s311><span style='font-size:10.0pt'>*&---------------------------------------------------------------------*</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>*& Report ZGETAPPROVERS</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>*&---------------------------------------------------------------------*</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s521><span style='font-size:10.0pt'>REPORT</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> ZGETAPPROVERS.<br></span><span class=l1s311><span style='font-size:10.0pt'>* Data declarations</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br><br></span><span class=l1s311><span style='font-size:10.0pt'>* Internal table contains shopping carts that are approved</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s521><span style='font-size:10.0pt'>data</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: </span><span class=l1s521><span style='font-size:10.0pt'>begin</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>of</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_approved </span><span class=l1s521><span style='font-size:10.0pt'>occurs</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s321><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>,<br> sc_no </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-object_id ,<br> guid </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-guid,<br> created_by </span><span class=l1s521><span style='font-size:10.0pt'>type</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmt_created_by,<br> posting_date </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-datum,<br> description </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-description,<br> status </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> tj02t-txt30,<br> </span><span class=l1s521><span style='font-size:10.0pt'>end</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>of</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_approved.<br> <br></span><span class=l1s311><span style='font-size:10.0pt'>* Internal table for approved shopping carts with each level of approval</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s521><span style='font-size:10.0pt'>data</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: </span><span class=l1s521><span style='font-size:10.0pt'>begin</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>of</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels </span><span class=l1s521><span style='font-size:10.0pt'>occurs</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s321><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>,<br> wi_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwwihead-wi_id,<br> top_wi_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwwihead-top_wi_id,<br> wi_rh_task </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwwihead-wi_rh_task,<br> guid </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-guid,<br> sc_no </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-object_id ,<br> created_by </span><span class=l1s521><span style='font-size:10.0pt'>type</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmt_created_by,<br> posting_date </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-datum,<br> description </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> crmd_orderadm_h-description,<br> resolver_name </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_003-resolver_name,<br> wi_aed </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwwihead-wi_aed, </span><span class=l1s311><span style='font-size:10.0pt'>"Date approval was processed</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* wi_ct LIKE swwwihead-wi_ct,</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>end</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>of</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels.<br> <br>START-</span><span class=l1s521><span style='font-size:10.0pt'>OF</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>-SELECTION. <br> </span><span class=l1s521><span style='font-size:10.0pt'>sort</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_approved </span><span class=l1s521><span style='font-size:10.0pt'>by</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sc_no.<br> </span><span class=l1s521><span style='font-size:10.0pt'>loop</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>at</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_approved.<br> <br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_approved </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> lt_sc_appr.<br> </span><span class=l1s521><span style='font-size:10.0pt'>at</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>new</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sc_no. </span><span class=l1s311><span style='font-size:10.0pt'>"Get SC from first line only</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> <br> </span><span class=l1s521><span style='font-size:10.0pt'>refresh</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: lt_sww_wi2obj, gt_sc_apprv_all_levels.<br> </span><span class=l1s521><span style='font-size:10.0pt'>clear</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: lt_sww_wi2obj, gt_sc_apprv_all_levels.<br> <br></span><span class=l1s311><span style='font-size:10.0pt'>* Get work item ID from the workflow</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>select</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> * </span><span class=l1s521><span style='font-size:10.0pt'>from</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sww_wi2obj<br> </span><span class=l1s521><span style='font-size:10.0pt'>into</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>table</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> lt_sww_wi2obj<br> </span><span class=l1s521><span style='font-size:10.0pt'>where</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> instid = lt_sc_appr-sc_no<br> </span><span class=l1s521><span style='font-size:10.0pt'>and</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> catid = </span><span class=l1s331><span style='font-size:10.0pt'>'BO'</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br><br> </span><span class=l1s521><span style='font-size:10.0pt'>perform</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> get_levels </span><span class=l1s521><span style='font-size:10.0pt'>tables</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> lt_sww_wi2obj </span><span class=l1s521><span style='font-size:10.0pt'>using</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> lt_sc_appr.<br> <br> </span><span class=l1s521><span style='font-size:10.0pt'>endat</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endloop</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br></span><span class=l1s311><span style='font-size:10.0pt'>*&---------------------------------------------------------------------*</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>*& Form GET_LEVELS</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>*&---------------------------------------------------------------------*</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s521><span style='font-size:10.0pt'>form</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> GET_LEVELS </span><span class=l1s521><span style='font-size:10.0pt'>tables</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> pt_sww_wi2obj </span><span class=l1s521><span style='font-size:10.0pt'>structure</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sww_wi2obj<br> </span><span class=l1s521><span style='font-size:10.0pt'>using</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> p_sc_appr.<br> </span><span class=l1s521><span style='font-size:10.0pt'>data</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: l_swwwihead </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> swwwihead,<br> l_rslv </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/c_wf_l-resolver_name,<br> l_eval_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/c_wf_l-evaluation_id,<br> lvl_stat </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_003-level_status,<br> l_scheme </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_000-scheme,<br> idx </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-tabix </span><span class=l1s521><span style='font-size:10.0pt'>value</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s321><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>,<br> l_first_lvl_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_000-first_lvl_id,<br> l_next_lvl_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_003-next_level_id,<br> l_next_id </span><span class=l1s521><span style='font-size:10.0pt'>like</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_003-next_level_id.<br><br></span><span class=l1s311><span style='font-size:10.0pt'>* For each approval level, get the workflow details</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>sort</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> pt_sww_wi2obj </span><span class=l1s521><span style='font-size:10.0pt'>by</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> wi_id.<br> </span><span class=l1s521><span style='font-size:10.0pt'>loop</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>at</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> pt_sww_wi2obj.<br> </span><span class=l1s521><span style='font-size:10.0pt'>clear</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: l_first_lvl_id, l_next_lvl_id.<br></span><span class=l1s311><span style='font-size:10.0pt'>* First read the header table for all work items</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>call</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>function</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s331><span style='font-size:10.0pt'>'BBP_PDH_WFL_WI_DETAILS_GET'</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>exporting</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> iv_workitem_id = pt_sww_wi2obj-wi_id<br> </span><span class=l1s521><span style='font-size:10.0pt'>importing</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> es_wi_header = l_swwwihead<br></span><span class=l1s311><span style='font-size:10.0pt'>* EV_WI_TASK =</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* EV_WI_WEBTA =</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* TABLES</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* ET_WI_AGENTS =</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>exceptions</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> wi_read_failed = </span><span class=l1s321><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>others</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> = </span><span class=l1s321><span style='font-size:10.0pt'>2</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br><br> </span><span class=l1s521><span style='font-size:10.0pt'>if</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-subrc <> </span><span class=l1s321><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br></span><span class=l1s311><span style='font-size:10.0pt'>* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>continue</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endif</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br><br></span><span class=l1s311><span style='font-size:10.0pt'>* Move the workflow related fields</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>-corresponding p_sc_appr </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels.<br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: l_swwwihead-wi_aed </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels-wi_aed,<br> l_swwwihead-wi_id </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels-wi_id,<br> l_swwwihead-top_wi_id </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels-top_wi_id,<br> l_swwwihead-wi_rh_task </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels-wi_rh_task.<br> </span><span class=l1s521><span style='font-size:10.0pt'>append</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels. </span><span class=l1s521><span style='font-size:10.0pt'>clear</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endloop</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br><br></span><span class=l1s311><span style='font-size:10.0pt'>* Now determine what each level of approval represents, that is, the</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* resolver_name - bookkeeper, manager, budget, etc</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>sort</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels </span><span class=l1s521><span style='font-size:10.0pt'>by</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> wi_id.<br></span><span class=l1s311><span style='font-size:10.0pt'>* Get the first level of approval</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>select</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>single</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> scheme first_lvl_id<br> </span><span class=l1s521><span style='font-size:10.0pt'>from</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_000<br> </span><span class=l1s521><span style='font-size:10.0pt'>into</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> (l_scheme, l_first_lvl_id)<br> </span><span class=l1s521><span style='font-size:10.0pt'>where</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> document_type = </span><span class=l1s331><span style='font-size:10.0pt'>'BUS2121'</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s311><span style='font-size:10.0pt'>"Or BUS2201 for POs</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>and</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> workflow_inst_id = l_swwwihead-top_wi_id.<br><br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_first_lvl_id </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_next_id.<br> </span><span class=l1s521><span style='font-size:10.0pt'>while</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_next_id </span><span class=l1s521><span style='font-size:10.0pt'>is</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>not</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>initial</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>clear</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>: l_rslv, lvl_stat, l_next_lvl_id.<br></span><span class=l1s311><span style='font-size:10.0pt'>* Get resolver for each level</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>select</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>single</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> resolver_name level_status next_level_id<br> </span><span class=l1s521><span style='font-size:10.0pt'>from</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> /sapsrm/d_wf_003<br> </span><span class=l1s521><span style='font-size:10.0pt'>into</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> (l_rslv, lvl_stat, l_next_lvl_id)<br> </span><span class=l1s521><span style='font-size:10.0pt'>where</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>id</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> = l_next_id.<br><br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_next_lvl_id </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_next_id.<br></span><span class=l1s311><span style='font-size:10.0pt'>* COMPLETED statuses indicate a valid and completed</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br></span><span class=l1s311><span style='font-size:10.0pt'>* approval level for the shopping cart</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'><br> </span><span class=l1s521><span style='font-size:10.0pt'>if</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> lvl_stat = </span><span class=l1s331><span style='font-size:10.0pt'>'COMPLETED'</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>read</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>table</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels </span><span class=l1s521><span style='font-size:10.0pt'>index</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> idx.<br> </span><span class=l1s521><span style='font-size:10.0pt'>if</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> sy-subrc </span><span class=l1s521><span style='font-size:10.0pt'>ne</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s321><span style='font-size:10.0pt'>0</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>clear</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_next_id.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endif</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>move</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> l_rslv </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels-resolver_name.<br> </span><span class=l1s521><span style='font-size:10.0pt'>modify</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> gt_sc_apprv_all_levels </span><span class=l1s521><span style='font-size:10.0pt'>index</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> idx.<br> </span><span class=l1s521><span style='font-size:10.0pt'>add</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s321><span style='font-size:10.0pt'>1</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> </span><span class=l1s521><span style='font-size:10.0pt'>to</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'> idx.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endif</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br> </span><span class=l1s521><span style='font-size:10.0pt'>endwhile</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>.<br></span><span class=l1s521><span style='font-size:10.0pt'>endform</span></span><span style='font-size:10.0pt;font-family:"Courier New";color:black;background:white'>. </span><span class=l1s311><span style='font-size:10.0pt'>" GET_LEVELS</span></span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><i><span style='font-size:12.0pt;font-family:"Arial Narrow","sans-serif"'>Marcia Magalhaes</span></i><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><i><span style='font-size:12.0pt;font-family:"Arial Narrow","sans-serif"'>Orange County Public Schools</span></i><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p><p class=MsoNormal><i><span style='font-size:12.0pt;font-family:"Arial Narrow","sans-serif"'>Orlando, FL</span></i><o:p></o:p></p></div>
<HR>The information contained in this e-mail message is intended solely for<BR>
the recipient(s) and may contain privileged information. Tampering with<BR>
or altering the contents of this message is prohibited. This information<BR>
is the same as any written document and may be subject to all rules<BR>
governing public information according to Florida Statutes. Any message<BR>
that falls under Chapter 119 shall not be altered in a manner that<BR>
misrepresents the activities of Orange County Public Schools.<BR>
[References: Florida State Constitution I.24, Florida State Statutes<BR>
Chapter 119, and OCPS Management Directive A-9.] If you have received<BR>
this message in error, or are not the named recipient notify the sender<BR>
and delete this message from your computer.<BR>
</body></html>