create and access a table OUTSIDE SAPR3 schema

[former_member360410]

Hi Gurus,

Can you please help me how do I create a table outside SAPR3 schema in the same database, I have a user schema TEST in the sap database (Using SAPR3 4.6C). If any tcode does that? Or I need to use oracle sqlplus.

HOW an ABAP progroam can access and manipulate the data available in this TEST schema?

Reference to some SAP NOTE will be highly helpfull.

Regards,

Soumen.

[fidel_vales · Accepted solution]

Hi,

It is not possible to create tables in a non SAP schema from inside SAP.

The SAP-Oracle license also does not allow you to create the table (see note 581312):

the following actions, among other things, are therefore forbidden at database level:
Creating database users
Creating database segments
Querying/changing/creating data in the database
Using ODBC or other SAP external access methods

[former_member360410 · Accepted solution]

Apart from the licenses etc is it possible technically?

Is there anyone help me out on this?

[former_member204746 · Accepted solution]

possible, yes, by using DBCON.

but you won't get support and you are violating your SAP license. so, this is not good.

[former_member360410 · Accepted solution]

What do U mean by DBCON? Is it a TCODE or short form of database configuration or a command line tool?

[fidel_vales · Accepted solution]

Hi,

I do not think DBCON is a good option about it.

>

> What do U mean by DBCON? Is it a TCODE or short form of database configuration or a command line tool?

DBCO is a transaction that allows you to configure connections to other databases. Check http://help.sap.com for more information.

To do what you want to do (apart from render your license useless as you will doing something your license does not allow you to do) you will need to use open SQL to access the other schema from the current SAP Schema. Also, you will need to give proper authorizations to the SAP schema.

[former_member204746 · Accepted solution]

DBCON is a table that contains connectivity information about external database that you may want to conenct to. it is very interesting when trying to fetch information from another DB.

so, this is a possible workaround to use another schema in your own database. But again, you are not allowed to create additional users or schema in your SAP database. it is against your SAP license.

search help.sap.com for more info.

[former_member360410]

Dear Fiedel and Eric,

Thank you both for your suggestion,

me and my team are are checking up according to your idea....

Actually, I do need to integrate one plant machinery equipment which has the backend database in MS SQL server and our SAP is using the backend Oracle and running on Linux.

As per the need of business data need to be exchanged between these two.

If you have may I request you to share some more information e.g. snotes on DBCO?

But , why DBCON is not the right choice, Fiedel can U thow some more light?

Regards

Soumen.

[fidel_vales]

>

> Dear Fiedel and Eric,

Fiedel, Who?

> 
> Thank you both for your suggestion,
> me and my team are are checking up according to your idea....
> 
> Actually, I do need to integrate one plant machinery equipment which has the backend database in MS SQL server and our SAP is using the backend Oracle and running on Linux.

Very good, now we are getting more information.

The data is NOT on the oracle database but outside.

In this case DBCON (from DB+CONnection) can help

> 
> As per the need of  business data need to be exchanged between these two.
> 
> If you have may I request you to share some more information e.g. snotes on DBCO?
> 

Very easy, follow my mantra (Top right box-Search functionality is very useful, also sap notes search)

Lets chew this a little:

117261 Multiconnect and DB procedure enhancements for 4.0B

323151 Several DB connections with Native SQL

738371 Creating DBCON multiconnect entries for SQL Server

178949 MSSQL: Database MultiConnect with EXEC SQL

> 
> But , why DBCON is not the right choice, Fiedel can U thow some more light?
.

Lets see, in your first request you wanted to access to a different schema in the same database.

you have the licence issues and DBCON is "overkill" (even when it can work) You would be connecting to yourself with a different usser.

Probably it is easier to create synonyms at DB level and provide proper authorizations.

In your second request the DBCON makes much more sense.

You want to access to a different (external) DB. That is the reason DBCON exist.

Now we have a little "issue". I'm not Windows/SQL expert, but, in order to connect to an external DB you need the SAP library "dbslib" (I think dbsmsslib is the correct name for the SQL server)

Unfortunately, SQLServer is a Windows only program and this library is only available for Windows.

To use it (use DBCON) you will have to install an AS on a windows machine and configure the DBCON on this server and execute the program to exchange data from this AS alone (if you execute it from another one it will fail because it does not find the dbslib)

As mentioned, not much experience with non "real" Operating Systems, so perhaps someone else has more information.

[former_member204746]

so, you want to connect your SAP ssytem to an external MSSQL database? This is feasible under normal circumstances. We have a Windows 2003 server with SAP running on Oracle and we are using DBCON to update/edelete/create records on an external MSSQL database.

but you have a problem. you would need a MSSQL DB library for your SAP ssytem to connect to your MSSQL instance. the problem is that SAP does not supply an MSSQL client (DLL/Unix library) to connect your Linux based system to MSSQL.

so, in your case, DBCON is not an option... unless you install a Windows application server and connect to your SAP - CI instance...