Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 16 at 09:31 AM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

  • May 16 at 02:53 PM

    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... )

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 16 at 12:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 17 at 07:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded