Database Configuration

On this screen you provide information used to configure the following datasources in SAP NetWeaver server where SAPMEINT and SAP MII are deployed and running:

SAPMEINT
SAPMEWIP

SAPMEINT Database Vendor

Description

Choose the database vendor from the drop-down list. The following database vendors are supported:

ORACLE
SQLSERVER

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
The Global Configuration property SAPMEINT_DB_Vendor is configured with the database vendor specified on this screen. You can verify this configuration by choosing SAP ME ERP Integration SAPMEINT Configuration Global Configuration in SAP MII Dashboard menu.
SAP NetWeaver
SAPMEINTCTC creates the datasource SAPMEINT for the specified database vendor in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running.
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Not applicable

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

SAPMEWIP Database Vendor

Description

Choose the database vendor from the drop-down list. The following database vendors are supported:

ORACLE
SQLSERVER

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
SAPMEINTCTC creates the datasource SAPMEWIP for the specified database vendor in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running.
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Not applicable

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Host

Description

When configuring the SAPMEINT datasource, enter a valid host name for the database where SAPMEINT tables and data will be created. When configuring the SAPMEWIP datasource, enter a valid host name for the database where SAPMEWIP tables exist.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified host name in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified host name in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Name of a valid host where the SAPMEINT or SAPMEWIP database exists.

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Port

Description

When configuring the SAPMEINT datasource, enter a valid port number for the database where SAPMEINT tables and data will be created. When configuring the SAPMEWIP datasource, enter a valid host name for the database where SAPMEWIP tables exist.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified port number in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified port number in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

A valid port number for the SAPMEINT or SAPMEWIP database server.

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Instance

Description

When configuring the SAPMEINT datasource, enter a valid database instance where SAPMEINT tables and data will be created. When configuring the SAPMEWIP datasource, enter a valid database instance where SAPMEWIP tables exist.

Note Note

This field is only applicable if the database vendor is SQL Server.

End of the note.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified database instance name in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified database instance name in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

A valid instance name for the database where the SAPMEINT or SAPMEWIP database exists.

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

User

Description

When configuring the SAPMEINT datasource, enter a valid user for the database where SAPMEINT tables and data will be created. When configuring the SAPMEWIP datasource, enter a valid user for the database where SAPMEWIP tables exist.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified user in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified user in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

A valid user for the SAPMEINT or SAPMEWIP database

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Password

Description

When configuring the SAPMEINT datasource, enter a valid user password for the database where SAPMEINT tables and data will be created. When configuring the SAPMEWIP datasource, enter a valid user password for the database where SAPMEWIP tables exist.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified password for the database user in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified password for the database user in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Password for the database user for the SAPMEINT or SAPMEWIP database

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Database

Description

When configuring the SAPMEINT datasource, enter the database name for SQL Server database. When configuring the SAPMEWIP datasource, enter the database name for SQL Server database where SAPMEWIP tables exist.

Note Note

This field is only applicable if the database vendor is SQL Server.

End of the note.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified name of the SQL Server database in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified name of the SQL Server database in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Database name for SAPMEINT or SAPMEWIP database

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

SID

Description

When configuring the SAPMEINT datasource, enter the database SID for Oracle database. When configuring the SAPMEWIP datasource, enter the database SID for Oracle database where SAPMEWIP tables exist.

Note Note

This field is only applicable if the database vendor is Oracle.

End of the note.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT datasource, SAPMEINTCTC creates the datasource SAPMEINT with the specified database SID for Oracle database in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. When configuring the SAPMEWIP datasource, SAPMEINTCTC creates the datasource SAPMEWIP with the specified database SID for Oracle database in SAP NetWeaver where SAP MII and SAPMEINT are deployed and running. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Database SID for SAPMEINT or SAPMEWIP database

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification

Oracle Driver Version

Description

Choose the Oracle driver version to be used for the SAPMEINT or SAPMEWIP datasource. The following driver versions are supported:

10.2
11.2

Note Note

This field is only applicable if the database vendor is Oracle.

End of the note.

Usage in Configuration

SAP ME
Not applicable
SAPMEINT
Not applicable
SAP NetWeaver
When configuring the SAPMEINT or SAPMEINT datasource, SAPMEINTCTC loads the database driver in SAP NetWeaver with the name SAPMEINT_ORA_<Driver version>. You can review this configuration in SAP NetWeaver Administrator by choosing Configuration Management Infrastructure Application Resources .
SAP ERP
Not applicable
SAP MII
Not applicable

Recommendation

Choose 10.2 if you are using Oracle 10g, choose 11.2 if you are using Oracle 11g.

Default
None
Impact of Change from the Default
Not applicable

Relevance

This field is relevant for the following SAPMEINT interfaces:

Inbound to SAP ME

Material Master
Material Classification Data
BOM Master
Routing Master
Production Order
Planned Order
HR User
Inventory Order Reservation
Work Center to SAP ME Resource
Work Center to SAP ME Work Center
Service Order
Alarm

Outbound to SAP ERP

Production Order Confirmation
Production Order Scrap
Planned Order Confirmation
Planned Order Scrap
Maintain Inventory
Equipment Usage
Equipment Status Change to Productive
Equipment Status Change to Unscheduled Down
RMA Order Complete
QM Notification