Skip to Content

UWL provides standard item attributes like Subject, From, Sent Date, Priority etc., that can be used as attributes for defining views. Sometimes there may be business requirement to show additional business specific attributes also in the UWL table. Like if I take example of SRM, the Object type BUS2121 has many item attributes like Plant, Material Group, Purchasing Group, Total Value etc. Business may require us to display values for Plant, Material Group etc. in the UWL table. We can display values for these custom attributes in the UWL, by customizing the standard UWL XML file.

In this blog I would explain in detail how to add columns for custom attributes in UWL View, and how to fetch values for those custom attributes.

<u>Steps:</u>

1. Downloading the UWL XML file to be customized for custom columns<br />Login to the portal.

Go to System Admin –> System Config –> Universal Worklist and Workflow –> Universal Worklist Administration –> Click to Manage Item Types and View Definitions

Go to Current Configurations Tab. Select the xml file you want to customize.

Click on Download Configuration button and save the file.

<p>2. Customize the UWL XML file </p>

A. Define a custom view for UWL, which would have columns for custom attributes.

You can get list of all attributes associated with an Object Type through the transaction SW01. Like, for BUS2121, the list is:

Here the custom view is named as SRMCCDUWLView. The columns added are: REQUIREMENTREQUEST,<br />PLANT, <br />MATERIALGROUP, <br />TOTALVALUE, <br />ACCTASSCAT, <br />department

The xml coding for the view with custom attribute columns is like:

<View name=”SRMCCDUWLView” selectionMode=”SINGLESELECT” width=”98%” supportedItemTypes=”uwl.task.webflow.srm”

columnOrder=”subject,REQUIREMENTREQUEST, creatorId, createdDate, PLANT, MATERIALGROUP, TOTALVALUE, ACCTASSCAT, department”

sortby=”dueDate:ascend, createdDate:descend” tableDesign=”ALTERNATING” visibleRowCount=”10″ headerVisible=”no”

queryRange=”undefined” tableNavigationFooterVisible=”yes” tableNavigationType=”CUSTOMNAV” refresh=”300″ dueDateSevere=”86400000″

dueDateWarning=”259200000″ emphasizedItems=”new” displayOnlyDefinedAttributes=”yes” dynamicCreationAllowed=”yes”

actionPosition=”bottom” referenceBundle=”com.sap.pct.srm.core.tasks”>

<DisplayAttributes><br /><DisplayAttribute name=”createdDate” type=”datetime” width=”” sortable=”yes” format=”short” referenceBundle=”created_date” <DisplayAttribute name=”department” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” vAlign=”BASELINE” <DisplayAttribute name=”PLANT” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” vAlign=”BASELINE” <DisplayAttribute name=”MATERIALGROUP” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” vAlign=”BASELINE” <DisplayAttribute name=”REQUIREMENTREQUEST” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” <DisplayAttribute name=”TOTALVALUE” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” vAlign=”BASELINE” <DisplayAttribute name=”ACCTASSCAT” type=”string” width=”” sortable=”yes” format=”default” hAlign=”LEFT” vAlign=”BASELINE” </DisplayAttributes>

B. Select the item id for which you want to fetch the custom attributes. For that selected item id define the custom attribute properties.

The data source for custom attributes: REQUIREMENTREQUEST, PLANT,  MATERIALGROUP,  TOTALVALUE,  ACCTASSCAT is ABAP, so value for parameter CustomAttributeSource id is “ABAP_BOR“.

Object Type is “BUS2121”, and Object Id Holder is “BOR_OBJECT”.The data source for attribute department is UME, so value for parameter CustomAttributeSource id is “UM” and Object Id Holder is “creatorId”.

<ItemType name=”uwl.task.webflow.srm.TS40007953.SAP_SRM” connector=”WebFlowConnector” defaultView=”SRMCCDUWLView” defaultAction=”com.sap.pct.srm.core.action.launchWD.WDCLFPOIF” executionMode=”default”><Attribute name=”BOR_OBJECT” type=”string” displayName=”BOR Object”/>

<CustomAttributeSource id=”UM” objectIdHolder=”creatorId” objectType=”user” cacheValidity=”final”>

<Attribute name=”department” type=”string” displayName=”Department”/><br />

<CustomAttributeSource id=”ABAP_BOR” objectIdHolder=”BOR_OBJECT” objectType=”BUS2121″ cacheValidity=”default”><br /><Attribute name=“CREATEDATE” type=”string” displayName=”Creation Date”/>

<Attribute name=“REQUIREMENTREQUEST” type=”string” displayName=”Request No”/>

<Attribute name=“PLANT” type=”string” displayName=”Location”/>

<Attribute name=“MATERIALGROUP” type=”string” displayName=”Procurement Type”/>

<Attribute name=“TOTALVALUE” type=”string” displayName=”Total Value”/>

<Attribute name=“ACCTASSCAT” type=”string” displayName=”Type Of Request”/>

3. Upload the new UWL XML file

Go to Upload New Configuration tab. Select the xml file you want to upload. Give a suitable name for the configuration.

We generally choose priority ‘High’.

Select the system for which the configuration is to be uploaded.

*4. Creating iView for customized UWL </p><p>Create a new iView for the customized UWL View.<br />Change the property: sap_uwl_viewname. Here the uwl view name is SRMCCDUWLView.</p><p>Add this new iView to the Role in which you want to get the custom UWL. </p><p><br />5. Testing the customized UWL View in Portal

*Go to the role to which you have assigned the custom UWL iView. Click on the iView.
You would be able to see the additional columns for custom attributes populated with their values.

 !https://weblogs.sdn.sap.com/weblogs/images/251970502/8.JPG|height=285|alt=|width=693|src=https://weblogs.sdn.sap.com/weblogs/images/251970502/8.JPG|border=0!

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Chintan Virani
    Well the stuff which you have mentioned has been discussed in Forums at length and also present in SAP Help.

    Also this should be a wiki and not a blog, wonder how this got approved?

    (0) 
  2. Mark Komaragiri
    Hi,

    I have some issues with accessing custom attributes.

    I followed your blog. It is not showing up and also I tried Wizard too. It is adding the column but is not showing data.

    Please help me out.

    Regards
    Mark

    (0) 

Leave a Reply