SCP Event subscription - SPS900

The auto start job Event subscription – SCP Events or SPS900 is used by Infor SCP and Demand Forecasting. SPS900 continuously pushes BE data as events and filters on a SCP Business area. It also filters on warehouse and item level. The item level filtering is set up through an APS policy, which must connect to a SCP Business area. Lastly, (SPS900) filters on specific tables and columns defined by the user in the API program SPS300MI (Manages SCP Business area). The auto start job is triggered when an update, creation, or deletion in M3 BE matches the filtering. This filtering is defined in three tables:

• SCP Business Area table (MSCPDF)
• SCP Business area warehouse table (MSCPCW)
• SCP field selection table (MSCPFS)

This table shows the available tables for SPS900 filtering for MSCPFS table:

Table	Description
CCUDIV	Customer local exceptions
CCURRA	Currency rate table
CMNDIV	Company/Division
CRPDLN	Product line
CSYTAB	System tables file
MITAUN	Alternative units
MITBAL	Item - warehouse
MITHRY	Item hierarchy definitions
MITMAS	Primary item
MITSCH	Search group definitions
MITTTY	Item type file
MITUCV	Unit conversion
MITWHL	Warehouse
OCUSMA	Customer
ODHEAD	CO delivery
ODLINE	Delivery customer order, line
OOHEAD	CO header file
OOLINE	CO line file
OPRBAS	Sales price list - basic