How to Find DTPs and Source Systems in Process Chains (SAP BW)

This article describes how to find in which process chains certain DTPs and/or source systems are used in SAP BW on HANA or BW/4HANA.

The following example describes how to find process chains loading from the example source system EXSRCSYS into a specific target namespace ZDOM:

Procedure

Step 1

DTPs contain the source system name in the description. Also their SAP BW system table contains a target field, for when i.e. the target namespace or target InfoProvider is known.

T-Code SE16 → Table RSBKDTP

Selection:

Field	Sign	Operator	Low	High
OBJVERS	I	EQ	A
SCR	I	CP	*EXSRCSYS*
TGT	I	CP	ZDOM*

Result is a list of DTPs matching the search criteria.

Step 2

Next step is to find out in which process chains the DTPs from step 1 are built in.

Open new T-Code SE16 → Table RSPCCHAIN

Use DTPs from field ID from result from step 1 before as variant filters:

Selection:

Field	Sign	Operator	Low	High
OBJVERS	I	EQ	A
VARIANTE	I	IN	list of DTPs from step 1

Further reading: Tabellen (SAP BW)