Skip to Content
author's profile photo Former Member
Former Member

view/table T000 can only be displayed and maintained with restrictions

Hi All,

After the system refresh of (Quality) from (Production)Tcode SCC4 is not running and showing below message:"view/table T000 can only be displayed and maintained with restrictions"When we go to Tocde Se11 and tried to check table T000 it says "table doesnot exit".However when we check at the DB level from sqlplus table is present.Kindly see the attachment for the same.Please help us to rectify the same as we cannot see any help.Even we are able to login in the system with our user id and password.



Request you all to kindly help.





Regards,

Ashutosh

pastedImage_0.png (28.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 03:39 PM

    Hi All,

    Sory for the late update. Our issue got fixed and it was not due do authorization. Infact when we check, we found the entire Data Dictionary was missing in Tcode SE11 (be it KNA1, MARA, LFA1)..where as we were able to check the records at the DB level:

    Reason: One of the DD table DD02L was accidently kept in one of the export script. So after the restore we truncated all the tables which was present in the script and reimported it from the exports of the tables taken before the restore using R3trans(exp/imp)

    Later when we truncated this table and imported it, the import finished fine but somehow the data of table DD02L couldn't be exported and imported via R3trans/Se01 even thought the RC was = 0.

    We even tried to take the export of this table from Production using R3trans and reimport the same in Quality..but despite gettinng RC =0 in the export when we checked the logs( no data was captured).

    Solution: we had to redo the refresh in Quality...:)

    Learing : As a Basis admin: double check all the tables in the scripts before doing a truncate.

    Regards,


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 25, 2013 at 01:48 PM

    Hi Ashutosh

    If you login as a user like DDIC into the QA system - are you still getting the same message after running SCC4. Looks like an authorization issue .

    Thanks

    Rishi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 25, 2013 at 01:38 PM

    Hello

    Are you able to view the table using Tx SM30 ?

    Does the use you use have the relevant authorisations ?

    What does the work process trace file say about this ?

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.