How to find the Where Used List of Common BW Objects?

Business Scenario

Often, we find ourselves in a situation, where we need to find the where used list of objects to perform an impact assessment before a development or a modification to an existing design to avoid or minimize the magnitude of impact. That is when we rely on Design documents or other project documents where we keep a track of this. On the other hand, if there is no such document maintained, we check for SAP tables or function modules that can help. One such function module is AKB_WHERE_USED_LIST.

AKB_WHERE_USED_LIST is a standard SAP function module available within R/3 SAP systems depending on your version and release level.

Interface

AKB_WHERE_USED_LIST is a simple function module to use. There are just two inputs needed to find the where used list of Objects.

Object Type

Object Name

How to use?

Follow the simple steps below to find the Where Used List of an Object.

• Go to Transaction SE37.

• Pass the name of Function Module – AKB_WHERE_USED_LIST and click on Execute.

• Pass the “Object Type” and “Object Name” in the corresponding fields.

• Click on Execute and wait for the Output to display.

• Click on the table for “Export Parameters” to get the “Where Used List”.

Note that, in the Output, you also get other additional information like the “Last Changed Date”, “Last Changed Time”,  “Last Changed By” etc.,.

Objects that can be searched for in AKB_WHERE_USED_LIST.

This function module covers a wide range of objects within the SAP system.

Each object has an Object Type.

Common objects that can be searched using AKB_WHERE_USED_LIST are

TABL – Table

PROG – Program

FUNC – Function Module

DTEL – Data Elements

CUBE – Infocube

ODSO – Data Store Object

IOBJ – Info-Object

For a detailed list of Object Types, please refer to the table TADIR.