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 wocould
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 transactionRsbkdtpTo delete DTP directly.(RsbkdtpIs a tabe if "delete" in the table is gray, you can use ABAP in se38Program
Delete from rsbkdtp
Where DTP = 'dtp _ 07dskgxkg6fhjkz0qz1icpv01'
To execute,
Or use/h to enter the debug mode for deletion. However, you have to consider using the background table to perform this operation. tr won't remember this operation. Will it be a problem if it is passed to 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 shocould be deleted too.
RstranTransformation
RstranfieldMapping of rule parameters-structure Fields
RstranruleTransformation rule
RstransteproutRule type: Routine
RstranrulestepRule steps for a transformation rule
RstranstepmapMapping for rule step within a rule
Source: http://www.sapks.com/2010/01/dtp-tables.html