SAP BW : Cannot delete DTP

Problem:

Cannot delete Data Transfer Process (DTP) from DSO/CUBE to DSO/CUBE. Despite all the pre-conditions have been met, such as deleting data and requests in the target and source.

Error Message:

Delta DTP cannot currently be deleted (see long text)
Message no. RSBK037

Diagnosis
You want to delete a delta DTP that has been successfully used to load requests from the source into the target. If you delete the DTP, you will also delete the information on the source data that was successfully transferred. As a result the source data would be transferred again, if you create a new delta DTP that links the same source with the same target.

Procedure
You have two options:
1. Delete all the requests loaded with this DTP from the target and then delete the DTP.
2. Do not delete the DTP and continue to load deltas using this DTP.

Solution:

Go To Transaction RSBKDTP to delete DTP directly.(RSBKDTP is a tabe 如果在表中"删除"是灰色的，可以在SE38中用ABAP程序

DELETE from RSBKDTP

WHERE DTP = 'DTP_07DSKGXKG6FHJKZ0QZ1ICPV01'

来执行，

或者用/H 进入DEBUG模式下删除，但得考虑这样通过后台表来操作，TR不会记得这一操作，传到QAS会不会有问题？  )

Source: http://forums.sdn.sap.com/thread.jspa?threadID=1568522&messageID=8581401

Additional Note:

Data Transfer Process (DTP) is related to various object such as Target, Source and Transformation. Here’s an extra table check for transformation. After deleting DTP, Cube or DSO  than the transformation should be deleted too.

RSTRAN Transformation
RSTRANFIELD Mapping of Rule Parameters – Structure Fields
RSTRANRULE Transformation Rule
RSTRANSTEPROUT Rule Type: Routine
RSTRANRULESTEP Rule Steps for a Transformation Rule
RSTRANSTEPMAP Mapping for Rule Step Within a Rule

Source:http://www.sapks.com/2010/01/dtp-tables.html