SAP Technical

Performance of SBWP (Available BAdI's)

Anon. — Tue, 31 May 2011 22:08:00 +0000

If you are experiencing performance issue in SBWP the main reason being that users have far too many work items in their inboxes (Several thousand). Some customers have a business need to have all work items in their inboxes rather than use more specific agent assignment (Call Centre scenario). Therefor several BAdI's were provided to improve performance e.g. reduce the number of work items in users inboxes

WF_BWP_SELECT_FILTER
This BAdI enables you to limit the number of the work items displayed by filtering. It is mainly suited to scenarios where all users are working on the same inventory of work items (for example, call center).
WF_BWP_DYN_COLUMN
Hiding the dynamic columns improves performance in the Business Workplace. If this is not possible, you can implement the BAdI WF_BWP_DYN_COLUMN to determine the values of the dynamic columns directly from the application data.
WF_BWP_OBJ_ATTRIBUTE
With this BAdI, it is possible to set the default attributes of the dominant object (_WI_Object_ID) and the grouping characteristic (_WI_Group_ID). The default attributes are used for grouping according to content, and grouping according to sort key and for hiding the group object column and work item content.

Workitem stuck in READY status but the workflow is COMPLETE

Anon. — Tue, 31 May 2011 22:00:00 +0000

If a work item is being executed and the workflow runtime system tries to access the work item then it will not be successful due to the lock or enqueue currently on the work item.

Example 1

An asynchronous task is being executed by a user. While the work item is being executed the terminating event is raised in the system and tries to set the work item status to COMPLETE but cannot due to the lock/enqueue.In this case the event is buffered in the event queue. As soon as the work item is released, it will deliver the buffered event immediately.

Example 2

You use parallel processing where you have a fork with 2 branches (1 Branch necessary for completion). In one branch is a dialog activity step and in the other is a 'Wait for Event' step. While the dialog step is being executed by a user the Wait for Event step receives its event and continues along the branch and completes the fork (Remember only 1 branch needed for completion). Once the end of fork is reached the dialog work item should be set to status Logically Deleted but this does not occur due to the lock/enqueue on the work item

When to use PI, BPM and Business (ABAP) Workflow

Kevin Wilson — Tue, 12 Apr 2011 22:42:00 +0000

Matt Harding has written a great blog detailing the question as to when to us SAP NetWeaver PI vs. BPM vs. SAP Business Workplace (ABAP Workflow).

Check out the article on SCN.

Working with files on SAP

Kevin Wilson — Tue, 11 Jan 2011 02:47:00 +0000

The following are useful transactions for manipulating files on the directories of the SAP server:

CG3Y - Download a file from SAP (e.g. /usr/sap/file.txt) to your computer
CG3Z - Upload a file from your computer to an SAP directory
AL11 - Browse files located on the SAP directories

Revelation Software Concepts Releases Salt Apps for SAP®

Kevin Wilson — Wed, 08 Dec 2010 11:28:00 +0000

Revelation Software Concepts Pty Ltd (RSC), an SAP® software partner and creator of the widely used Rev-Trac® change control technology has released its new ‘Salt Apps for SAP’ solution. Salt is a free application platform to power and deliver innovative, highly useful ”mini-apps” to SAP developers, Basis and other project team members.

To download Salt, visit: www.saltapps.com

The initial release includes:

Version Vault App:

It keeps copies of custom object source versions safe but accessible, providing a centralized repository for custom ABAP and data dictionary objects from all SAP systems. This makes it easy for users to compare versions across systems, view objects and object code, and provide assurance that a persistent audit exists of all changes to all ABAP objects and data dictionary objects. Team members can easily browse all information through an intelligent hierarchy, or restore a system or run a refresh and keep a copy of the prior state for reference, comparison or audit.

Matrix App:

This app shows a matrix-like table of objects highlighting differences between existing systems and allowing drilldown to specific issues. Users can easily visualize any differences between object versions across the

Displaying old Output using NAST and SOST

Kevin Wilson — Wed, 01 Dec 2010 06:56:00 +0000

Problem Description:

Business users often want to look at old output and if you do the normal print preview it actually shows you the output with the latest data and not necessarily the data that was sent initially. E.g. A quote confirmation was sent and then the quote is changed and the pricing changed and now the user wants to see what he quoted the customer and wants to look at the old printout. Here's how you can do it programmatically.

Program Description:

The following is a very quick and dirty (yet it works) program that takes an object key (e.g. Sales Order number), output type (e.g. BA00) as input. It then searches for historical records in NAST and if it finds some goes and looks in SOST and SOOD to see if the output was generated. If it has been then it selects one to display it.

This program can be easily modified to provide an ALV grid of the applicable output that you could then select to display. This program just displays the output for the first entry found.

*&---------------------------------------------------------------------*
*& Report ZCA_SOST
*&---------------------------------------------------------------------*

REPORT zca_sost.

TABLES: sost,
sood,
nast.

DATA: it_sost TYPE STANDARD TABLE OF sost,
wa_sost TYPE sost,
it_sood

Read more...

Testing an Inbound Proxy if the test interface is unavailable

Kevin Wilson — Wed, 17 Nov 2010 22:20:00 +0000

If the menu entry test interface is not available, you can use transaction SXI_SUPPORT.

Select service selection and check the proxy inbound processing box.

In the next screen select your interface and namespace and check XML editor.

Upload the payload that you can pull from SXMB_MONI

Maintaining a workflow substitute for someone else

Kevin Wilson — Thu, 04 Nov 2010 20:18:00 +0000

As an administrator of workflow you may want to assign a substitute for someone else (e.g. if they are out sick)

To do this use T-Code RMPS_SET_SUBSTITUTE

What tables store the workflow rule's responsibilities and values?

Kevin Wilson — Fri, 29 Oct 2010 01:19:00 +0000

For reporting reasons you may need to pull out the values that are stored in your responsibilities that are tied to rules (transaction PFAC and OOCU_RESP)

First, take your rule number (E.g. 91000001) and select on table HRP1218 where EXT_OTYPE = AC and EXT_O BJID = 91000001.

Then take HRP1218-TABNR and use it to select on HRT1218 to get the ELEMENT and vales (EXPR_LOW)

If you want further details on the responsibility then take HRP1218-PLVAR, OTYPE and OBJID and select on HRP1001 and HRP1240.

Dynamic where clauses for selects

Renier — Fri, 22 Oct 2010 18:55:00 +0000

Use the following function modules to help build your dynamic where clauses for your select statements....

DYNSQL_GENERATE_WHERE_CLAUSE

CONVERT_SELECT_INTO_WHERE

FREE_SELECTIONS_RANGE_2_WHERE

ADSPC_CREATE_WHERE_CLAUSE