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

Custom table on portal database

I am writing a portal service and my requirements are such that I need to create some custom tables on the portal database. There is a naming convention for differentiating customer tables from SAP supplied tables in the R3 environment (start with Z). Does the same convention exist for creating a table in the portal database?

Or, since we are using Oracle, should I create another schema outside of the SAPxxxDB schema and put my tables there?

Thanks,

Ray

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2005 at 05:31 PM

    I think its better to create a separate schema and not make changes to the Portal DB Schema.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 08, 2005 at 05:38 PM

    If you are using the NWDS, you have access to the java dictionary, You create you table there, and when you deploy to your engine, it will create the table in the underlying database, regardless of what it is(oracle, sql, etc). In this case, you must precede the name of the table with 2 letters and underscore, the default is TMP_

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      In looking at the tables, I noticed these prefixes are being used:

      BC_

      EP_

      J2EE_

      MM_

      SP_

      TC_

      UME_

      WCR_

      If I choose not to use TMP_, how do I know which prefix outside of the ones listed above would be safe and not conflict with any future prefixes provided by SAP? Is there a "customer" prefix?

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.