1 2 3 10 Previous Next

SAP Sourcing

150 Posts

There are many questions in SCN related to Mass update of Contract Documents fields. This blog will give the insight of how the Contract Document fields can be mass updated through workbook. Hope it will help.


Follow the following steps for updating Contract Document fields:

Step1. Download the Workbook Template from Contract Document and Importer

(Setup-->Document Setup-->Agreements-->Contract Data and Document Importer).

Step2. In the workbook Below 3 Fields are mandatory in order to mass update the CDs



UNIQUE_DOC_NAME: Master Agreement’s Unique ID

DOC_DISPLAY_NAME: It is the Display Name of the CD which has to be updated


Apart from the above fields, other fields which have to be updated are added in the Workbook

For Example, CD phase and some custom fields have to be updated then below is the screenshot of the Workbook. Likewise any field in the Contract Document can be updated.




Note: If phase of CD is updated via workbook then it will not change the Status at the Master Agreement level.

Sample Workbook Attached.

Step4.Login into the System with Enterprise credentials


Step5. Click on Setup-->Document Setup-->Agreements-->Contract Data and Document Importer


Step6. Click on New


Step7. Select “Upload Master Agreement Data” option and click on next


  • Upload the Workbook and click on next



  • Click on Finish in order to complete the import.



Any feedback and suggestions are appreciated J




Release 10.0 of SAP Sourcing/CLM – generally available (GA) since 7-Nov-2014 - provides support for additional ECC Item Categories in its SAP ERP Integration as well as new ECC Item Category configuration capabilities within SAP Sourcing/CLM.


Please note that ECC Item Categories are called Item Types in SAP Sourcing/CLM.



Prior Item Category Support in Release 9.0


In Release 9.0 of SAP Sourcing/CLM, standard support for Material (Standard <blank>) and Service (D) Item Categories were available.


For the Material Item Category, standard support was provided for Material Masters and Free Text Material line items.  For the Service Item Category, standard support was provided for Free Text line items (where the integration supports a single level ECC Service Specification for each SAP Sourcing/CLM Free Text Service line item).



No other Item Categories/Item Types were available in SAP Sourcing/CLM 9.0.



New Release 10.0 Item Category Support



New Item Categories Supported


Now the SAP Sourcing/CLM ERP Integration provides standard support for the ECC Item Categories/Sourcing CLM Item Types of Consignment (K), Subcontracting (L), Material Unknown (M), and Material Group (W).  In addition, SAP Sourcing/CLM provides the ability to integrate up to 3 “custom” ECC Item Categories (requires custom PI mappings). 


These new ECC Item Categories/Item Types are fully supported on SAP Sourcing/CLM Reports and Imports/Exports.



Additional Item Category Configuration Capabilities


  • Automatic update of ECC Purchase Info Record for Consignment Item Type (Category) line items when published to SAP ERP.  Ref. SAP Note 1703392


  • New selected Item Types (Categories) can be activated on the RFx or Master Agreement Document Type level in ERP integrated documents


  • Control of Item Type (Category) visibility to Suppliers on Sourcing RFxs


  • Ability to change Item Type (Category) in RFx Award



If you are interested in learning more about these new capabilities, check out the related SAP Help for the new SAP Sourcing/CLM Release 10.0 ERP Integration features on Working with Item Types in SAP Sourcing on http://help.sap.com:












Release 10.0 of SAP Sourcing/CLM – generally available (GA) since 7-Nov-2014 - provides a new Web Service Framework (WSF) for the development of custom RESTful style web services that leverage the existing SAP Sourcing/CLM Scripting and Query framework.



Now custom integrations can be more easily developed where SAP Sourcing/CLM can be a provider of RESTful style web services.



WSF Features



  • High-Level Summary



    • SAP Sourcing/CLM can now be a provider of custom inbound REST query/update web services using the existing SAP Sourcing/CLM Explicitly Called Script feature



    • SAP Sourcing/CLM can now be a provider of custom inbound REST query web services using the existing SAP Sourcing/CLM Report’s Query Definition feature (SAP delivered Query Definitions or custom Query Definitions)



    • Enablement of these new web services can be done through simple run-time configuration.  There is no requirement to deploy custom .jar files that require shutting down the SAP Sourcing/CLM application server.


    • Logging of these custom RESTful web service requests and responses is provided in a new Web Service Request object – that includes detail information about the request as well as both the request and response XML or JSON payload files.  These logging objects are available to view through a System Administration User Interface.  You do not need to get the actual SAP Sourcing/CLM logs to see this information



    • In addition, an SAP delivered standard RESTful web service is provided for SAP Sourcing/CLM User Account maintenance and queries.  This new web service can be used for User Account synchronization between Identity Management servers and/or NetWeaver servers



  • Authentication


    • Directory Configuration Settings provider authentication support:
      • Basic Authentication (User Name & Password)
        • Local (non-Production only), LDAP, and NetWeaver UME
      • SSO using SAP NetWeaver Assertion Tickets
        • NetWeaver UME



    • OAuth 1.0a (“3 legged”) RESTful provider authentication support
      • OAuth is an open standard protocol that is secure, flexible, and extensible
      • User Name & Password do not need to be provided to the client consuming application



  • Security


    • New Web Service Security Profiles
      • Web Service User & Web Service Admin standard Security Profiles delivered
      • User permission required to execute an inbound web service
      • Access Right permissions also required for new web service Configuration Objects



    • Script-based Web Service
      • Document Authorizer Framework IAPIs available for Scripts
      • The “Collaborator model” security is available and is based on the authenticated web service User Session context



    • Query-based Web Service
      • Report & Query Definition “Access List” security supported



    • The OAuth protocol is considered very secure



    • Configurable Throttling Model provided to protect server resources



  • Reference sample Scripts and Schema Files (.xsd files) provided to support custom development of Script-based web services:


    • Sample scripts provided to perform CRUD-like operations (e.g., Create Read, Update…) on CLM Master Agreements, and Souring RFxs and Projects
      • Sample scripts and XML Schema Files (.xsd files) can help “jump start” development of custom integrations
      • For example, custom SRM integration web services could be developed to create an SAP Sourcing Project or RFx from the SRM Sourcing Cockpit or to create an SAP CLM Agreement from an SRM Central Contract from the provided sample scripts and XML Schema Files



    • XML Schema Files (.xsd files) are used to automatically create XML Request and Response java proxy stub classes for the Explicitly Called Scripts used to provision a web service
      • After the XML Schema file is uploaded and saved via the new Web Service Definition UI, you can immediately view the JavaDocs that are automatically generated at run-time
      • The Request and Response java proxy stub classes are immediately available to the SAP Sourcing/CLM Script environment for Script BeanShell coding



    • New Scripting IAPIs provided to support Script-based web services development:
      • New “Adapter” IAPIs for unmarshalling/marshaling XML > Java > XML
        • Provided for the complex SAP Sourcing/CLM Data Types
      • New IAPIs to support CRUD (e.g., Create Read, Update…) operations – e.g., to handle checking document access rights on edit and find, clearing and setting document edit information on edit and release, and releasing memory appropriately.




The reference/sample scripts plus the new IAPIs plus the new Web Services Guide for SAP Sourcing 10.0 – now available on SAP Service Marketplace SAP Sourcing/CLM 10.0 On-Premise - can help illustrate a best practices and efficient approach to developing custom script-based web services.  In addition, please note that there is also a new Web Service Cookbook and Troubleshooting Guide 10.0 that should be read if you intend to use the new Web Service Framework script-based or query-based custom web services feature in SAP Sourcing/CLM Release 10.0.


You can get both of these documents now at SAP Service Marketplace:





samp 1.png





If you are interested in learning more detail about the above SAP Sourcing/CLM Release 10.0 Web Service Framework new features, please check out the recent SCN webinar presentation slides which have additional content and screen shots at the following link:



Scenario: - Master Agreements List Based on Status


DashBoard Report.jpg


When you click on any status in the report or the diagram, then the following report will be displayed

dash board results.jpg

In order to create above dashboard report, please follow as below

1)    Create a Simple query with result fields such as Master agreement ID and Master Agreement Status and with Status as filter since we are displaying the master agreements based on Status

Query Name: - Z_Master Agreement Status Detailed




Note: -   Make a note of the parameter name which you have given in the filter ex:-status


2)    Create a Report with the above Query Z_Master Agreement Status Detailed.

Report Name: - ZREP_ Master Agreement Status Detailed

3)    Create another Simple Query

                    Query Name: - Z_Master Agreement Status Dashboard





Create three result fields, of which first two are with unique (identical) name as below,


a) Master Agreement Status -->  T1.STATUS_OBJECT_NAME || ': (' || (COUNT (DISTINCT T1.UNIQUE_DOC_NAME)) || ')'    Column Type --- URL

The above SQL statement will show the results as below

dash board UI.jpg

When you click on above status then it will be navigated to the results i.e., first query results which can be achieved with below SQL statement

b) Master Agreement Status--> ('/analysis/report?queryGroupName=ZREP_Master Agreement Status Detailed Report&status='||T1.STATUS_OBJECT_NAME)   Column Type --- Internal Page

Blue color indicates --> Internal Name of the first Report (with first Query)

Brown color indicates --> parameter name of the Filter in the first Query

c) Count --> (COUNT (DISTINCT T1.UNIQUE_DOC_NAME))   Column Type --- Number (this has to be hidden for the users)


The above Number Type column has to be used in Query under Chart definition Tab as shown below

Chart Defination.jpg

4)    Create a Report with the above Query Z_Master Agreement Status Dashboard.

Report Name: - ZREP_ Master Agreement Status Dashboard


5)    Create a desktop channel under below path


                                    Setup --> System setup --> Workbench --> Desktop channel

         and add the above report under parameter definitions as shown below and choose the visibility internal or external or both.

Desktop Channel.jpg

6)    Add the desktop channel in your workbench and it will be displayed as below.

DashBoard Report.jpg

Any suggestions are welcome


Hope it Helps!






SAP Sourcing/CLM has introduced a feature that allows On-Premise SAP Sourcing/CLM System Administrators to set SAP NetWeaver “Debug Mode” and access the SAP NetWeaver logs directly from the SAP Sourcing/CLM application.  This feature was developed for SAP Sourcing/CLM Release 10.0 and back-ported to SAP Sourcing/CLM Release 9.0 Service Pack 17.


In the past, one of the challenges for On-Premise SAP Sourcing/CLM System Administrators has been the need for engaging SAP NetWeaver Basis Administrators when troubleshooting SAP Sourcing/CLM.   An SAP NetWeaver Basis Administrator was required in order to turn on SAP NetWeaver “Debug Mode” when reproducing an SAP Sourcing/CLM problem and also to retrieve the SAP Sourcing/CLM logs from the SAP NetWeaver server.  Retrieving the correct log files for the desired time period has also been a challenge.  Now these activities can be performed just by the On-Premise SAP Sourcing/CLM System Administrator.


Enabling this feature



On-Premise SAP Sourcing/CLM users who have been designated as application System Administrators typically already have the standard delivered “System Administrator” Security Profile assigned to them.  A new Security Profile Access Right has been introduced under the “Super User Rights” group.  Set the new Service Registration NetWeaver Logs View permission to Allow:

access permission.png

Log off and then log on again to refresh your Security Profiles cache.  You should now have access to this new feature.


Note: For SAP Sourcing/CLM “system” and “enterprise” administration users, this feature is automatically available and does not require the use of a Security Profile Access Right permission.  Also, if “multi-tenant” mode has been enabled for the SAP Sourcing/CLM implementation, only the “system” administration user will have access to this feature.


Setting SAP NetWeaver Debug Mode



Go to the Setup System Administration tab and click the System Information link:

sys info link.png

The Service Registration Logs tab should now be visible.  Click on the Logs tab and enter Edit mode.   You can now set the SAP NetWeaver Log Level to Debug Mode directly from within SAP Sourcing/CLM:

debug setting.png

Important Notes:

  • Normally ONLY Debug needs to be set for Log Level (Java). Do not set Debug for Log Level (SQL) and Log Level (Startup) unless instructed to do so by SAP Support.
  • Normal Log Level settings for running SAP Sourcing/CLM are:
    • Log Level (Java): Info
    • Log Level (SQL):  Error
    • Log Level (Startup): Error
  • Please don’t forget to turn off Debug Mode when you have completed reproducing a problem!


Retrieving SAP NetWeaver Sourcing/CLM Logs



From the same Service Registration Logs tab (you don’t need to be in Edit mode), set the Start Date and End Date date/time filters to only select log data for the desired time period when the problem occurred and then press the Get Logs button:


By clicking the Download link for each file, your default text file editor will launch and you can immediately begin your troubleshooting or save the files so that they can be quickly provided to SAP Sourcing/CLM Support!


Important Notes:

  • Debug Mode does not need to be enabled to retrieve the logs.  Logs can be retrieved anytime and for time periods when Debug Mode is not enabled – as long as the log files for the time period are still on the SAP NetWeaver server file system.
  • If Log Level (Java): Debug has been set for the filter time period specified, then the SAP Sourcing/CLM “debug-specific” log entries will be found in the log file that is named with the prefix eso_trc_, e.g., ‘eso_trc_1195119837835452560.log’. Please make sure to also send this file to SAP Support if they have requested that you reproduce a problem in “Debug Mode”.

Ed Dunne and I are pleased to announce the General Availably of SAP Sourcing / CLM release 10.0 On Premise.


As of November 7th 2014 we have officially passed all required ramp-up milestones and the release is available for download.


We encourage all of our customers to start plans to upgrade to this new release.


Release 10.0 offers many exciting features for our customers.  Please refer to the following SCN blogs for more information on the contents of release 10.0.


Functional 10 Enhancements:



Technical 10 Enhancements:






Anne McClelland and Ed Dunne Product Management




What happens if a potential SAP Sourcing user leaves the company? How will the ownership of their documents they worked on be reflected and tackled going forward?


Typically SAP Sourcing already does, built-in, provide possibilities to do this. I.e. typically you could either do an Ownership change of a business document via the UI (which certainly would only make sense if but a few documents were to be changed) or alternatively for large scale changes imports can be served with this purpose. SAP note 1092321 (Can you update collaborators on documents) does elaborate on this approach. While working however it may be time-consuming to perform the necessary steps to fill the import template and hence, should this be a recurring task, a more proper UI solution could be thought of.


This is where this implementation of a Succession Management Tool (in this context to be understood as a tool handy to change Ownership on business documents within SAP Sourcing) comes in. Note that this is based on this post here (Leavers and joiners policy ideas) if you wanted to investigate the original idea.




This implementation is delivered as follows in the attachment called (SMT with UDO - please rename the .txt extension again to .zip as this had to be done to be able to attach this here):

a) a system manager user workbook (as the SMT tool is using the User Defined Master Data 2 object by default)

b) an enterprise manager user workbook that contains the rest of the logic

c) the actual scripts that are being used and are referenced in the "script_definition" tab of the enterprise manager workbook


For the "script_definition" tab in the enterprise manager workbook make sure to check/adapt this to your local preferences/settings. Note the business context and the location of the scripts. The scripts need to be in a directory that the application server, where SAP Sourcing is deployed, can access.





1) Log in as the Enterprise Manager user and find on the Master Data tab the SMT tool


2) Create new ownership change documents that are being used to trigger the ownership change. Here you can also see the customized columns.


3) The UI is split as follows - the actual logic is to be found under "Scripts" (once in "Edit" mode) whilst the from and to Ownership change is found below. The extension collections do show the Determined Documents for change(s) and also, once updated, will update their respective detail extension collection with the document/template ids that have been changed.


4) Determine the documents by using (in "Edit" mode) the respective "Determine..." scripts


5) This will then look like this


6) Then let`s update (aka change the owner to the from/to values) e.g. the Projects


7) Which yields the ID of the changed document



Note: In general if you have access to it I found it advisable to use the Enterprise Manager user for this task. If you do use a normal user (either of the affected / from the from/to fields) you a) may not get any notifications of the ownership change and b) if the security profile settings are not configured you may run into security issues upon ownership change attempt.


I hope this idea/implementation can help in managing this particular occurrence with the SAP Sourcing application. As always, with all posts, remember that this is provided "as is" and that as such no responsibility for any damages incurred can be taken. If you are in doubt please contact a SAP Sourcing consultant or similar resource.





Joerg Lippmann

SAP currently supports SAP Sourcing/CLM Releases 7.0 and 9.0.  Release 10.0 is in the final stages of Ramp-Up and it is anticipated to be Generally Available within 4 to 6 weeks.


We have recently re-evaluated our end of maintenance dates for Release 7.0 and Release 9.0


  • The end of maintenance for SAP Sourcing Release 7.0 is and remains to be December 31st, 2017.
  • We have however, decided to extend the end of maintenance of Release 9.0 to December 31st, 2016.  With the timing of Release 10.0 GA, we have realized that our customers need more time to upgrade to it.
  • End of Maintenance for Release 10.0 remains to be December 31st, 2018.


SAP still strongly recommends that customers upgrade to the most recent version of SAP Sourcing/CLM regularly.  We hope that, for those customers on Release 9, this increased maintenance support time will help them plan for an upgrade to Release 10 before the end of 2016.   For those customers still on Release 7 we recommend skipping Release 9 and upgrading directly to Release 10.


SAP intends to continue providing customer-driven innovation to its On-Premise SAP Sourcing/CLM customers on a regular cadence of every 18-24 months. With that said, Release 11.0 is in the final stages of planning and design and its development cycle will begin soon.   Release 11.0 Ramp-up, GA and EOM dates will be formally announced soon.


If you have further questions on the SAP Sourcing/CLM release and maintenance plans please contact me at anne.mcclelland@sap.com.


Anne McClelland

Product Management - SAP Sourcing / CLM



In SAP Sourcing, one common question comes up every now and then which is related to Document Links section (MA, project etc.). For convenience, in this blog I am explaining the technical script involved in solving this issue.


What is a Document Links Section?


Under Header Section of a Business Document, we can see the Document Links Sections where the user can add another Business Document in relation to the current one.



While adding another Business Document, the following data needs to be populated.




Technical Scenario


Generally, based on some business requirement, we would require linking a previous Project (Business Document) to the current one. This can be achieved via scripting which is explained in this blog.


//Required imports


import com.sap.odp.api.doccommon.masterdata.DocumentLinkDefinitionIBeanHomeIfc;

import com.sap.odp.api.ibean.IBeanHomeLocator;

import com.sap.eso.api.projects.ProjectIBeanHomeIfc;


// Creating Document Links Home through DocumentLinkDefinitionIBeanHomeIfc



// For instance, let us assume that the document is project

// Creating Project  Home




// Finding the Project which needs to be added in Document Links section


projBean = projHome.findByUniqueDocName("PROCAT-001--2014");


// Find the Relationship with which the Project  should get added. Refer FCI-DocLinkDefList query to view all the relations present in the system.


documentLinkDef = docLinkHome.findUnique("FCI-PROJECT PREVIOUS");


// A line is added with empty fields in Document Links section

newDocumentLink = doc. getDocumentLinkList().create();


// Setting the Type of document which needs to be added (project, RFx, Auction etc.)


newDocumentLink.linkDefinitionType = new DocLinkDefinitionTypeEnumType(1);


// Setting the Relationship of the document which needs to be added (Previous Project, Future Project etc.)


newDocumentLink.linkDefinitionObjRef = documentLinkDef.objectReference;


// Setting the Object Reference of the document which needs to be added


newDocumentLink.LinkDocObjRef = projBean.objectReference;


//A Document is added in the Document Links Section


doc. getDocumentLinkList().add(newDocumentLink);


This Script can be used with any Document Life cycle event or toolbar based on Business requirement.






SAP Sourcing/CLM can use either the Microsoft .NET-based WordService or the JAVA-based SAP Sourcing DOCX Generation Service to generate structured contract documents using clause documents, collection variable documents, and contract document templates.


SAP Sourcing DOCX Generation


The Microsoft .NET-based WordService requires setup of an additional Windows server. Due to this overhead and additional TCO, versions of SAP Sourcing 7.0 SP5/9.0 SP11/10.0 or higher now also support the SAP Sourcing DOCX Generation Service, which is WordService based on JAVA technology. The SAP Sourcing DOCX Generation Service does not require an additional Windows server. As this is lower TCO, we recommend switching to the SAP Sourcing DOCX Generation service. For more information on the JAVA-based generation service, see the following link:


The New SAP Sourcing & CLM DOCX Generation service


Microsoft .NET-based Word Service


The Microsoft .NET-based WordService requires setup of an additional Windows server. It uses MS Word on the Windows server to perform operations on the clause documents and generate a structured contract document.


Follow these steps to install the Microsoft .NET-based WordService:


1. Verify that you meet the prerequisites for the installation of .Net WordService. See the checklist of prerequisites:

Prerequisites to configure .Net based contract Generation service


2. Create an “Office Automation User” user account. This user should perform the operations in MS Word on the Windows machine for the generation of contract documents. We recommend not using this user for any other purpose, as that might disrupt the configuration, resulting in the failure of the contract generation service.

Create Office Automation User


3. Install the WordService. For details, see: Install WordService


4. Configure the WordService. For details, including screenshots, see:

Configure IIS for WordService


5. When the installation is complete, check the whether the WordService is working as desired by following these steps: Verify that Contract Generation WordService is working.


6. If the WordService is not working as desired, refer to the troubleshooting techniques here:

General Contract Generation Checklist for CLM Versions 9.x and Below

Please note that this topic is also covered by the available KBA 1996605 (then application level issues) (SAP Service Marketplace access required)




SAP Sourcing login URLs can be constructed as follows:

[protocol]://[hostname]:[port]/[context]/[login type]/[login path]


Process flow for buyside and sellside logins:


1. Install the Language Pack in question following the official SAP Sourcing documentation


2. Open the SAP Sourcing Login page in question (buyside, sellside)


3. Change the language in the dropdown ("Logon Screen Language") to the language in question and note the changing URL in the browser


4. Copy this URL and find the language pack ID for the selected langage pack at the end of said URL


5. Use this URL as a favorite or in any other manner to pre-default the SAP Sourcing Login Page language for the buyside and sellside logins


As such a buyside URL with a pre-defaulted language pack preference would look like:

Buyside Login Page LP default.jpg


A sellside URL with a pre-defaulted language pack would look ike:

Sellside Login Page LP default.jpg


NOTE: This might not work in SSO scenarios as the login page might not stem from the actual SAP Sourcing application.


Process flow for the Supplier self-registration page:


1. Install the Language Pack in question following the official SAP Sourcing documentation

2. Note the "ISO Language" value of the language pack in question from the SAP Sourcing buyside (or enterprise user) login via Setup - System Setup - User Interface - Language Packs

Language Pack ISO.jpg

3. Open the SAP Sourcing Supplier self-registration page in question (if using multiple UI`s see also KBA 1995822 if in doubt how to call it)


4. Use the given URL and append the following: ?language=da&country=da whereas "da" is the ISO Language value of the language pack in question.


5. Use this URL as a favorite or in any other manner to pre-default the SAP Sourcing Supplier self-registration language


A Supplier self-registration page with a pre-defaulted language pack would look like:

Supplier self reg UI default.jpg


If using an alternate Supplier UI with a pre-defaulted language pack this would then look like:

Supplier self reg UI2 default.jpg

The SAP Sourcing/CLM Customer Partner survey invitation was emailed out on Friday, June 6th.  This is your chance to influence the contents of the next release of SAP Sourcing/CLM.


The deadline for survey submissions has been extended to Friday, August 1st.


A separate survey invitation specifically for internal SAP Sourcing/CLM consultants/support network etc. was also sent out.


If you did not receive the survey email and would like to participate please notify me at anne.mcclelland@sap.com.


Anne McClelland

Product Management - SAP Sourcing/CLM

Please note that this topic is also covered by the available KBA 1997275 (then application level issues) (SAP Service Marketplace access required)


  1. Logging Categories (eso.<n>.log) – do not need be altered at any time

    1 Logging Categories.jpg
  2. Tracing Locations (eso.<n>.trc) – default settings (normal settings)

    2 Tracing Locations - default.jpg
  3. Tracing Locations (eso.<n>.trc) – SAP Sourcing (application) debug logs

    3 Tracing Locations - application debug.jpg
  4. Tracing Locations (eso.<n>.trc) – SAP Sourcing SQL debug logs

    4 Tracing Locations - SQL debug.jpg
  5. Tracing Locations (startup.<n>.trc) – SAP Sourcing startup debug logs

    5 Tracing Locations - startup debug.jpg

Please note that this topic is also covered by the available KBA 1997890 (SAP Service Marketplace access required)





SAP Sourcing 7.0 and SAP Contract Lifecycle Management 7.0
SAP Sourcing and SAP Contract Lifecycle Management 9.0


and WordService Installation performed on a supported Windows OS



Reproducing the Issue

  1. Set Log Severity
  2. Reproduce Issue
  3. Reset Log Severity
  4. Acquire Logs
  5. Validate Logs
  6. Provide validated Logs to Support


SAP Sourcing Contract Generation issues.jpg





Make sure to have the appropriate access rights to the involved applications/functions:


  • OS level access / contact your local IT and/or system administrator


ESSENTIAL FILES to be provided to SAP Sourcing Support:


  • log_<date>.log and log_<date>.trc files contained within the directory given during the installation of the WordService



  1. Set Log Severity

    This step is only necessary if you are being asked to provide the Contract Generation Logs in "debug" severity. If this is the case then:

    a) Find the file located at: [www root]\WordService\Web.config and open it in a text editor

    b) Find the section "<appSettings>" and look for the string "<add key = “logLevel” value=”info”/>"

    NOTE: If you did not revert previous settings it might not read "info" for the value

    c) Change the value to "debug" and save.

    d) Restart the WordService.

    Example of a debug configured Web.config:

    Untitled 3.jpg
  2. Reproduce Issue
  3. Reset Log Severity

    Revert the changes made in step 1 by modifying the Web.config to its previous original value.
  4. Acquire Logs

    Navigate to the directory defined during the installation of the WordService.

    Example at

    Untitled 1.jpg

    and copy those files which are needed (see next step).
  5. Validate Logs

    NOTE: DEBUG entries will only be found in the respective log_<date>.log files. Nonetheless the log_<date>.trc files of the same timeframe are required.

    a) Open the files to see if the desired severity logging is there (you would see DEBUG, the screenshot only shows INFO and ERROR entries).
    Contract Generation log example.jpg

    b) Make sure that the timeframe is matching with the reproduction.
  6. Provide validated Logs to Support

    Once you have identified the relevant log files do provide them to SAP Sourcing Support

Calling all workflow gurus for SAP Sourcing / SAP CLM !We have some good news for you. The news is also good for the folks who were a bit gun-shy with creating and maintaining workflows in SAP Sourcing / SAP CLM.


With SAP Sourcing / SAP CLM version 9 SP 16+ (and, of course, with our upcoming release SAP Sourcing / SAP CLM 10.0), we will be introducing a brand new and extremely intuitive, easy to use, highly functional, wizard driven visual workflow editor. Ah OK! I will lay off the adjectives and get down to brass tacks. But yes, we are excited about this long-standing request from a number of our customers, and consultants.


I will not go into the capabilities and functionality of the Workflow in SAP Sourcing / SAP CLM, which has been covered extensively and synopsized wonderfully in this webcast (recording, and presentation), but focus more on the creation of the Workflow, and the features being introduced.


Throw away those old 3rd-party workflow editors


Let’s step back a little and understand our decision to bring this capability into the application. Well,

  • The 3rd-party tools and editors (visual or text based), which can construct the workflow process definition in a format as supported by SAP Sourcing / SAP CLM, are becoming difficult to find. Additional licensing issues (LGPL, GPL, etc.) associated with these tools which complicate the matter further.
  • Using 3rd-party tools meant that after creating the workflow process, a file needed to be saved and then imported into the SAP Sourcing / SAP CLM Workflow definition interface
  • The visual tools our customers and consultants were using were pretty clunky and required a number of extension attributes to be added, and/or had some attributes that were not mandatory and just plain confusing
  • For the type of functionality that a solution like SAP Sourcing / SAP CLM provides, adhering to the open industry standard XPDL or BPMN is a bit more cumbersome than necessary


So is it as easy as you claim?

You can be the judge.

Setting up a workflow process, is as easy as 1, 2, 3, and you are done.

Step 1 - Define the Workflow Process


The Workflow definition task has not changed, except for one very important and useful addition, allowing the associated workflow process to be created and saved in Draft status before publishing.


Figure 1.png


Once the details for the workflow have been defined, and the option to "Add New Version" has been selected, you will now be presented with 4 options to help give your workflow process definition a great starting point, and doing most of the initial heavy lifting for you. The 4 choices are:

  1. Use our automated workflow process generator. All you have to do is provide the number of approval steps you would like, and we will do the rest. One limitation: you cannot define more than 20 approval steps, but if you need more than 20 approval steps, then get in touch with us so that we can look at the use case, and maybe provide some useful alternatives. This is the best option for starting a new workflow process definition.As a bonus, with this option, you can now also define a default Prescript and a default Postscript to be used in the entire workflow process. The scripts defined as default, will be associated with the generated appropriate steps in the workflow process
  2. Use the last published workflow process definition. If you have created versions, and have perhaps used a version of the workflow process, and then realized that a small tweak needs to be made to make the process compliant with the expectations of the users of the system, then this is the option for you.
  3. Use the last published version of another workflow. Well, you have done it before, and now it’s time to create a new workflow, but, why reinvent the wheel? Use the working published workflow process that exists and works perfectly.
  4. Use an existing workflow schema file. We would like you to use our new visual workflow process flow editor, but of course there is always a need to support and allow workflow process schema files (.xpdl or .sswp) to be imported and used.


Figure 2.png

Step 2 - Build the Workflow Process

Here you define all the details of the workflow process in one screen, by populating an optimized and necessary list of fields only, with most fields already populated with default values. We have also ensured that all the approval steps are given default names, and if you have used the default script population option, then hey, presto, you are well on your way, and can finish the whole definition really very quickly.


Of course, all the names and labels can be easily changed, and additionally, the visual workflow works almost like any other visual tool, with clickable approval steps and icons.




Defining additional approval steps or deleting approval steps is easy with the clear buttons, and of course you select where the additional approval steps should be placed.

Figure 3.png


Step 3 - Add the Scripts please


Now that the stage has been set, all that is required is to start adding the scripts to suit your specific scenarios and processes for each of the approval steps. Simply click on the icons that are provided for defining Prescripts, Precancel, and Postscripts for each approval step and you will be able to enter your script or copy and paste from your favorite editor. The icons are also colored differently depending on whether a script has been defined for an approval step or not.


A capability to define a Global Precancel script is also provided


And that’s it .......

Figure 4.png


SSWP!?! What is this SSWP?


One new aspect that we are introducing is a file format that is truly SAP Sourcing. All the workflow processes defined or modified will now be available in the .sswp format. SSWP stands for SAP Sourcing Workflow Process, is still an XML file, and just like the user experience is optimized for the SAP Sourcing / SAP CLM workflow capabilities.


Voila! Workflow process definition in a box.


There you have it


But wait, there's more "Help" on the way. The Help section for workflow definition has been comprehensively updated to include details on all the features and functionality for our upcoming Release 10 (for all the features of Release 10, please refer to this blog). For Release 9, we will be updating our Scripting and Workflow guide, which will be available on Service Marketplace.


If there is any more information that you need, please feel free to get in touch.


Filter Blog

By author:
By date:
By tag: