Create custom stored procedure in SAP R/3

[Former Member]

Hi,

I have a R/3 system running on WIndows and SQL Server 2000.

We are creating some custom stored procedures and DTS on the SQL Server directly.

From a Basis point of view, I would like to know what is the risk and implication of creating all these custom database objects on the SQL Server.

For anyone kind expert opinion.

Thanks.

Regards,

Mike

[Former Member]

Hi,

actually there is no risk at all. You can create as many objects as you like. But these objects are unknown to the SAP system. So from an SAP point of view you will have inconsistencies between the ABAP dictionary and the database (TX DBACOCKPIT). SAP will surely not support your own development.

Sven

[Former Member]

Hi,

Thanks for your reply.

From a Basis perspective, would there be any implication if we do a SAP upgrade?

For your kind reply.

Thanks.

Regards,

Mike

[clas_hortien]

Hi,

yes, there might be implications, as you might have dependencies between your objects and the SAP objects, so that the SAP could not be changed. If you have in addition your objects in an own schema, this will hinder the migration to new DB releases, as the STM Tools will detect this and will stop until you have fixed (removed) it.

Have you tried to keep all your objects in your own database and use a full qualified syntax as

select * from Database.Schema.Table

Best regards

Clas Hortien

[Former Member]

Hi,

I think we are creating the SQL stored procedure at database level. We are trying to import some data from external Oracle database into the SAP SQL Server. So the custom stored procedure will create a link server to Oracle DB and pull in the data to update the custom tables in SAP SQL Server.

Would there be any implication in terms of upgrade or anything?

Thanks.

mike

[Former Member]

Hi,

you can always drop the SPs before the upgrade and recreate them afterwards. Have you created the SPs yet and tried to make an upgrade? What did the upgrade routine report? Any problems with your SPs? Try it and you will find out. Have you tried Clas' solution (your own DB)?

Please also check table DBCON in your SAP system. You can create custom connections to external non-SAP DBs to import/export data using the ABAP stack.

Sven