How to delete table T604/T604T in S/4 HANA

[Former Member]

I have to rebuild table T604, T604T and /sapsll/clsnr, /sapsll/clsnrt in a S/4 HANA system with T604, T604T data out of a R/3 system. So I must delete the complete Content of T604 and T604T in S/4 HANA. But the delete doesn't work. I get always a SY-SUBRC = 4. The ABAP for this command is "delete from t604 up to 10000 rows." in a loop with a commit.

[satinder_singh]

Did you try SE14 with Activate and Adjust with Delete Data option ? I am not aware of dependencies of the tables listed so I am assuming that you have evaluated the same. Also out of curiosity I wanted to know if your S/4HANA system is already built then why are you now trying to bring over the data from ECC to S/4 ? If you can share more details ?

[Former Member]

I've tried SE14. SE14 works and gives the message "Request for T604 executed successfully". But the table still contains 478525 entries. If I try to delete one record with SE16 the result is "Error when deleting database record".

The building of the S/4 HANA system is in progress. But the data transfer of the R/3 table T604 into the HANA system should run periodically (after GoLive). Target is the rebuild of HANA tables T604, T604T, /sapsll/clsnr and /sapsll/clsnrt with data of the R/3 T604 and T604T.

[raymond_giuseppi]

Did you (search and) read 2432527 - KBA: S/4HANA 1610 - Define Commodity Codes and (re-)classify products? (this obsolete table should already been empty, but... )

[Former Member]

The Problem is solved.

Table T604 is in HANA a CLS view. You can see it in SE11 in menu entry "replacement object" (in german "Vertreterobjekt"). If table /SAPSLL/CLSNR becomes deleted or entries inserted table T604 changes automatically.