User Tools

Site Tools


implementation:wms:install_standardstoredprocedure

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
implementation:wms:install_standardstoredprocedure [2020/01/17 12:55]
vise
implementation:wms:install_standardstoredprocedure [2020/01/17 14:35] (current)
vise
Line 5: Line 5:
 === 3.4.1.1. With Microsoft SQL Server === === 3.4.1.1. With Microsoft SQL Server ===
  
-After the configuration is done you need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TransactionNotification”.+After the configuration is doneyou need to enable the (custom) stored procedures in the stored procedure of SAP named “SBO_TransactionNotification”.
  
-When applying the Produmex Add-on the first time to a database you also need to adapt the stored procedure “SBO_SP_TransactionNotification”+When applying the Produmex Add-on the first time to a databaseyou also need to adapt the stored procedure “SBO_SP_TransactionNotification”.
  
-1. Open SQL Server Management Studio” and connect to your database server.+1. Open SQL Server Management Studio and connect to your database server.
  
 2. Expand the “Databases” folder and locate the database to which you want to apply the Produmex Add-on. 2. Expand the “Databases” folder and locate the database to which you want to apply the Produmex Add-on.
Line 17: Line 17:
 4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. ​ 4. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select “Modify”. ​
  
-{{:​implementation:​5.1.1.png?​nolink|}}+{{:​implementation:​5.1.1.png?​nolink|Enable the standard PMX stored procedure}}
  
 5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below) 5. Locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below)
    
-{{:​implementation:​5.1.2.png?​nolink|}}+{{:​implementation:​5.1.2.png?​nolink|Enable the standard PMX stored procedure}}
  
 6. Copy the “Produmex Logex Addon Code”. \\ 6. Copy the “Produmex Logex Addon Code”. \\
Line 28: Line 28:
 7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and select''​Modify''​. 7. Locate the “dbo.SBO_SP_TransactionNotification” stored procedure, right-click it and select''​Modify''​.
    
-{{:​implementation:​5.1.3.png?​nolink|}}+{{:​implementation:​5.1.3.png?​nolink|Enable the standard PMX stored procedure}}
  
 8. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “-- ADD YOUR CODE HERE”. 8. Paste the “Produmex Logex Addon Code” at the end of it. With a new installation you will see a marked area like “-- ADD YOUR CODE HERE”.
Line 34: Line 34:
 {{ :​implementation:​install:​boyum:​25._add_your_code_here.png |}} {{ :​implementation:​install:​boyum:​25._add_your_code_here.png |}}
  
-9. Uncomment the SP by clicking on the ''​Uncomment''​ button in SQL management studio.+9. Uncomment the SP by clicking on the ''​Uncomment''​ button in SQL Management Studio.
  
-{{:​implementation:​5.1.5.jpg?​nolink|}}+{{:​implementation:​5.1.5.jpg?​nolink|Enable the standard PMX stored procedure}}
  
 10. Execute the SBO_SP_TransactionNotification stored procedure. ​ 10. Execute the SBO_SP_TransactionNotification stored procedure. ​
Line 52: Line 52:
 2. Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on. 2. Expand the “Catalog” folder and locate the schema to which you want to apply the Produmex Add-on.
  
-3. Right-click on this schema and select “SQL Console” to open a new SQL console+3. Right-click on this schema and select “SQL Console” to open a new SQL console.
  
-{{:​implementation:​hanastudio5.png?​nolink|}}+{{:​implementation:​hanastudio5.png?​nolink|Enable the standard PMX stored procedure}}
  
 Keep this SQL console open during the whole process. Keep this SQL console open during the whole process.
Line 62: Line 62:
 5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​ 5. Locate the “SBO_SP_TRANSACTIONNOTIFICATION” stored procedure, right-click it and select “Open Definition”. ​
  
-{{:​implementation:​hanastudio3.png?​nolink|}}+{{:​implementation:​hanastudio3.png?​nolink|Enable the standard PMX stored procedure}}
  
 6. Open its content by opening the //Create Statement// tab: 6. Open its content by opening the //Create Statement// tab:
  
-{{:​implementation:​hanastudio4.png?​nolink|}}+{{:​implementation:​hanastudio4.png?​nolink|Enable the standard PMX stored procedure}}
  
 7. Copy the content into the SQL console. 7. Copy the content into the SQL console.
Line 72: Line 72:
 8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”. 8. Locate the “PMX_SP_TransactionNotification” stored procedure, right-click it and select “Open Definition”.
  
-{{:​implementation:​hanastudio1.png?​nolink|}}+{{:​implementation:​hanastudio1.png?​nolink|Enable the standard PMX stored procedure}}
  
 9. Open its content by opening the //Create Statement// tab, and locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below). 9. Open its content by opening the //Create Statement// tab, and locate the “Produmex Logex Addon Code” at the end of this stored procedure (see illustration below).
    
-{{ :​implementation:​install:​boyum:​26._produmex_logex_addon_code_hana.png |}}+{{ :​implementation:​install:​boyum:​26._produmex_logex_addon_code_hana.png |Enable the standard PMX stored procedure}}
  
 10. Copy the “Produmex Logex Addon Code”. 10. Copy the “Produmex Logex Addon Code”.
Line 87: Line 87:
 ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​ ''​DROP PROCEDURE SBO_SP_TransactionNotification;''​
  
-Now the SQL console should look like this:+The SQL console should look like this:
  
-{{ :​implementation:​install:​boyum:​27._produmex_logex_addon_code_hana_2.png |}}+{{ :​implementation:​install:​boyum:​27._produmex_logex_addon_code_hana_2.png |Enable the standard PMX stored procedure}}
  
 14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure. 14. Execute the code in your SQL console to modify the SBO_SP_TRANSACTIONNOTIFICATION procedure.
implementation/wms/install_standardstoredprocedure.txt · Last modified: 2020/01/17 14:35 by vise