Skip to Content

SAP Standard Tables

Hi,

We are migrating ABAP Programs from 3.1i to ECC 5. Unfortunately some of the programs use tables which, apparently, doesn't exist anymore. Particulary, the

statistics table <b>S761</b>.

Can you point me to information on these tables?

Just curious..Does SAP have an <b>official</b> list of all tables and relationships? It seems pretty odd that I cant find one on the net. This would be very useful for it will tell me which tables doesnt exist anymore and if there are substitutes for it.

Thanks.

Add comment
10|10000 characters needed characters exceeded

6 Answers

  • Best Answer
    Posted on Jun 08, 2006 at 09:22 AM

    Hi Emir!

    Table S761 belongs to an infostructure. I don't remember, if customer namespace is between S500 and S999 or just S900-S999 - but very likely your S761 was defined by customer, not SAP.

    So you need to repeat some customizing steps / transport the corresponding requests (advice: manual creation, no transport!).

    Regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Emir,

      You can use program RMCSAUSW to delete custom LIS evaluation structures and evaluations (S501 - S999).

      Hope this helps,

      -Keyvan

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 08:08 AM

    Emir,

    As far as my knowledge, SAP doen't give detailed documentation on upgrade each object wise. However you can get information on upgrade at

    http://service.sap.com/upgrade> where in you can find out comparision between each version more specific to each domain. Unfortunate part is there you cannot find deatils in object wise. But overall it has mentioned about AbapWorkbench objects.

    Comming to your probelm regarding <b>S761</b>, I feel the best way I suggest to find out the new object in latest version is.

    1) Make use of Where-used-list in older version and pick up the list which was using your object. Go to the latest version and go thorugh these list one by one and find out what exactly SAP has used instead of that. Try to adopt that functionaliy for your replacement. However in certain cases you may not be able to find some where-used-object-list in new version.

    2) Second suggestion is you can search the object with its <b>description</b>. Go to object directory entry tables and search for similar descriptions for new object.

    Cheers,

    Thomas.

    Add comment
    10|10000 characters needed characters exceeded

    • Thomas.

      prior to posting, i have done option 2. I already have a work around for the problem so i didnt have to do option 1. I only trying to avoid modifying any of the code.

      Anyways, i really find it pretty odd, why such documention or information doesnt exist.

      Thanks!

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 07:50 AM

    Hi,

    check some tables

    3.1 ecc 5.0

    tvarv tvarvc,

    usr03 usr21,adrp

    scadr adrc

    Regards,

    Nagaraj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 07:53 AM

    Hi,

    check the lik below hope it helps.

    http://www.sapgenie.com

    In sap modules go to functional.

    regards

    Add comment
    10|10000 characters needed characters exceeded

    • hi annie,

      i know this site as well as several other sites with diagrams and stuff. I'm just surprised that there is no official document describing the tables and their relationships considering the fact that most aspects of sap are documented and available for free online.

      thanks.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 08:07 AM

    Emir,

    As far as my knowledge, SAP doen't give detailed documentation on upgrade each object wise. However you can get information on upgrade at

    http://service.sap.com/upgrade> where in you can find out comparision between each version more specific to each domain. Unfortunate part is there you cannot find deatils in object wise. But overall it has mentioned about AbapWorkbench objects.

    Comming to your probelm regarding <b>S761</b>, I feel the best way I suggest to find out the new object in latest version is.

    1) Make use of Where-used-list in older version and pick up the list which was using your object. Go to the latest version and go thorugh these list one by one and find out what exactly SAP has used instead of that. Try to adopt that functionaliy for your replacement. However in certain cases you may not be able to find some where-used-object-list in new version.

    2) Second suggestion is you can search the object with its description.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 05:54 AM

    hi,

    goto SE11,

    select the VIEWS radiobuttion,

    enter a name for view starting with 'Y' or 'Z',

    click on create pushbutton,

    select database view,

    click on copy,

    enter short description,

    select one database table(ekko for example) in tables,

    then click on relationship pushbutton below that,

    then it will display,all the related tables with that selected table,

    try for it,

    regards,

    kcc

    Add comment
    10|10000 characters needed characters exceeded