SPP Plan Name
After the necessary pre-requisite setups are created the next step is to create the SPP plan.
Functional Details
Navigation -- Service Supply Chain Planner --> Service Parts Planning --> Names
If the system asks to choose the organization, select the organization in which the SPP plan needs to be created.
Important Fields
Name - Enter the SPP plan name.
Description - Enter the SPP plan description
Technical Details
The SPP plan details will be stored in the tables
1) MSC_PLANS
2) MSC_DESIGNATORS
SQL Query
SELECT *
FROM msc_plans
WHERE compile_designator = 'SPP Plan Name'
SELECT *
FROM msc_designators
WHERE designator = 'SPP Plan Name'
After the necessary pre-requisite setups are created the next step is to create the SPP plan.
Functional Details
Navigation -- Service Supply Chain Planner --> Service Parts Planning --> Names
If the system asks to choose the organization, select the organization in which the SPP plan needs to be created.
Important Fields
Name - Enter the SPP plan name.
Description - Enter the SPP plan description
Technical Details
The SPP plan details will be stored in the tables
1) MSC_PLANS
2) MSC_DESIGNATORS
SQL Query
SELECT *
FROM msc_plans
WHERE compile_designator = 'SPP Plan Name'
SELECT *
FROM msc_designators
WHERE designator = 'SPP Plan Name'
