Work Instruction

Functional Area: F2F
Process Name : Material Master Maintenance
System : SAP PE1 – client 300
Change History
Instructions for creation of this document
Instructions for changing / updating of this document
Purpose
Process Flow
Process description
Process description - for DMO
1. New Material Code (no code presently in SAP)
1.1. Preliminary checks and request validation
1.2. Check for potential duplicates
1.3. Create material - MM01
2. Mass update MM17
3. Deactivate/activate MM06
4. List multiple Storage locations MMSC
5. Creating Plant views MM01 / Extending to another plant
5.1. Sales View
5.2. Purchasing View
5.3. Purchase Order Text view
5.4. MRP views
5.5. Work Scheduling view (not visible for ZROH)
5.6. Plant Data View
5.7. Warehouse mgmt. views
5.8. Quality management view
5.9. Accounting views
5.10. Costing Views
6. Creating material with reference
7. Validate/report/search
7.1. MM03 – view material master
7.2. MM04 – material based changes
7.3. ZCYMAT_QUERIES – view based report
7.4. MM60 – field report
7.5. ZCYMAT_CD – display changes
Appendixes
Appendix 1 – List of Plant Data Stewards for both Structural and Process Materials
Appendix 2 – Material Request form
Appendix 3 – Material Types
Appendix 4 – Material number ranges
Appendix 5 – Material type definition
Appendix 6 – Required Documentation for Material Maintenance Requests Based on the Type of Change


Change History


Version
(yyyy-mmm-dd)

Author

Reviewed

Approved

Change description

 

A.Lietaunieks (Sen.Specialist)

E.Leisans

M.Scerbakova (Supervisor)

Initial version

12/09/2015

E.Leisans (Sen.Specialist)

 

M.Scerbakova (Supervisor)

PDS update

03/07/2016

E.Leisans (Sen.Specialist)

 

M.Scerbakova (Supervisor)

PDS update for SFS - R.Mendoza removed

04/05/2016

E.Leisans (Sen.Specialist)

 

M.Scerbakova (Supervisor)

PDS update for Tolouse - Carole Cartier Lange

08/03/2016

E.Leisans (Sen.Specialist)

 

M.Scerbakova (Supervisor)

PDS update – added C.Dickerson as data steward for procured materials

08/23/2016

E.Markus (Sen.Specialist)

E.Leisans (Sen.Specialist)

M.Scerbakova (Supervisor)

WI review and various improvement implementation

05/18/2017

E.Leisans (Sen.Specialist)

 

V.Kaluznaja (Team lead)

J.Rebensdorf replaced by Gilbert Alvarado as data steward for SFS

09/10/2017

S.Pastare (Specialist)

 

V.Kaluznaja (Team lead)

Version update

11/09/2017

E.Leisans (Sen.Specialist)

 

V.Kaluznaja (Team lead)

PDS update Keighley – C.Dickerson replaced by M.Barton



Instructions for creation of this document
Creation



Instructions for changing / updating of this document



Purpose


This work instruction describes the process for maintaining (creation, changes) in SAP for the following material types including samples:



Process Flow

Finished Goods/Intermediates creation (Material Type: ZPRO)

Finished Goods/Intermediates change (Material type: ZPRO)

Factory Goods creation (Procured Materials) (Material type: ZROH, ZHBE, ZUNW, ZLAG, ZHRS)

Factory Goods change (Procured Materials) (Material type: ZROH, ZHBE, ZUNW, ZLAG, ZHRS)

Process description


Requestor (can be from various functions, for example R&D, planning, etc.) initiates business request and submits it to the Plant Data Steward depending on:


Process step by step:

  1. Plant Data Steward and/or product steward submits a request to PSRA for MSDS (if required), HTS and ECCN codes.
  2. Plant Data Steward submits a request to Data Management (providing a filled out Request Form) to set up a global view (at this time the material is also temporarily blocked until all local views have been created). We make sure that there are no duplicates already existing in the system, and if all required data has been provided, set up the Global view as requested. Then the DM ticket is closed and the Plant Data Steward receives a notification that the Global view is completed.
  3. Plant Data Steward gathers all information required for the local views (using the Collection form).
  4. Plant Data Steward populates all the collected data for the local views.
  5. Plant Data Steward advises Manufacturing, QM, Procurement and Logistics that a new item has been created so they can set up additional data (BOMs, routings, inspection plans, QIR's, Source List, etc.)
  6. Once all additional data is created, the Plant Data Steward advises Finance that a new item was created.
  7. Finance runs Costing.
  8. Plant Data Steward then releases the block.


Data Governance is responsible for material maintenance process and its changes.

Process description - for DMO


New Material Code (no code presently in SAP)

Preliminary checks and request validation




Check for potential duplicates


Please refer to chapter 7.1
Validate/report/search

Create material - MM01




PLEASE NOTE! DM should only populate GLOBAL views – BASIC DATA 1, 2 and Classification
In case there is a need to populate PLANT views, please refer to the PLANT view instruction below.




Basic Data View:


Basic Data text view is located in Additional Data:




Please Note!
For all sold materials AUoM PER is mandatory
1 PER = 1 BUoM
If the Sales Indicator in Classification view is marked as SOLD, please enter AUoM – PER
To Exit 'Units Of Measure tab' press „Main Data"








Batch class is mandatory for ZROH materials (except packaging) and ZPRO materials (including packaging).
1 millimeter = 1000 micrometers

Mass update MM17






Deactivate/activate MM06



For global deactivation change the following values of the Material:

For local deactivation change the following values of the Material:


Deactivation in MM06:



P.S. It is possible to deactivate/activate materials for specific Plant/ Stor.location/ Sales org./ Distr. Channel/ Warehouse Nr, that is usually performed by the Plant Data Steward

List multiple Storage locations MMSC





Creating Plant views MM01 / Extending to another plant


The process of creating plant views and extending to another plant are very similar – both are performed using MM01 and the user has to select the Plant Views + Organizational levels!




Following chapters will cover each plant view separately and provide defaulted values as a reference.

Sales View








Purchase Order Text view



MRP views







Work Scheduling view (not visible for ZROH)


Production Supervisor – choose from table ONLY if the Procurement Type = E:

Plant

Prod Superv.

Prod Scheduler

 

Plant

Prod Superv.

Prod Scheduler

2010

103

MTS- TC1

 

2040

104

MTS- TC2

2010

104

MTS- TC2

 

2040

YB2

MTS PI valuated

2010

YB2

MTS PI valuated

 

2045

104

MTS- TC2

2015

101

MTS-ITAR

 

2045

YB2

MTS PI valuated

2015

103

MTS- TC1

 

2050

104

MTS- TC2

2015

104

MTS- TC2

 

2050

YB2

MTS PI valuated

2015

106

MTO-ITAR

 

2055

YB2

MTS PI valuated

2015

108

MTO-TC1

 

2065

YB2

MTS PI valuated

2015

109

MTO-TC2

 

2070

YB2

MTS PI valuated

2015

YB2

MTS PI valuated

 

2075

YB2

MTS PI valuated

2020

102

MTS-EUML

 

2085

YB2

MTS PI valuated

2020

103

MTS- TC1

 

2090

YB2

MTS PI valuated

2020

104

MTS- TC2

 

2095

102

MTS-EUML

2020

YB2

MTS PI valuated

 

2095

103

MTS- TC1

2025

104

MTS- TC2

 

2095

104

MTS- TC2

2025

YB2

MTS PI valuated

 

2095

105

MTS-TAA

2030

YB2

MTS PI valuated

 

2095

YB2

MTS PI valuated

2035

104

MTS- TC2

 

2100

104

MTS- TC2

2035

109

MTO-TC2

 

2100

YB2

MTS PI valuated

2035

YB2

MTS PI valuated

 

 

 

 


Production Scheduling Profile – choose from table below, ONLY if the Procurement Type = E or Procurement Type = X:

Plant

Prod Profile

Description

 

Plant

Prod Profile

Description

2010

YB0002

MTS Process Manufacturing

 

2045

YB0002

MTS Process Manufacturing

2010

ZSTC1

MTS- TC1

 

2045

ZSTC2

MTS- TC2

2010

ZSTC2

MTS- TC2

 

2050

YB0002

MTS Process Manufacturing

2015

YB0002

MTS Process Manufacturing

 

2050

ZSTC2

MTS- TC2

2015

ZOITAR

MTO-ITAR

 

2055

YB0002

MTS Process Manufacturing

2015

ZOTC1

MTO-TC1

 

2065

YB0002

MTS Process Manufacturing

2015

ZOTC2

MTO-TC2

 

2070

YB0002

MTS Process Manufacturing

2015

ZSITAR

MTS-ITAR

 

2075

YB0002

MTS Process Manufacturing

2015

ZSTC1

MTS- TC1

 

2085

YB0002

MTS Process Manufacturing

2015

ZSTC2

MTS- TC2

 

2090

YB0002

MTS Process Manufacturing

2020

YB0002

MTS Process Manufacturing

 

2095

YB0002

MTS Process Manufacturing

2020

ZSEUML

MTS-EUML

 

2095

ZSEUML

MTS-EUML

2020

ZSTC1

MTS- TC1

 

2095

ZSTAA

MTS-TAA

2020

ZSTC2

MTS- TC2

 

2095

ZSTC1

MTS- TC1

2025

YB0002

MTS Process Manufacturing

 

2095

ZSTC2

MTS- TC2

2025

ZSTC2

MTS- TC2

 

2100

YB0002

MTS Process Manufacturing

2030

YB0002

MTS Process Manufacturing

 

2100

ZSTC2

MTS- TC2

2035

YB0002

MTS Process Manufacturing

 

4055

YB0002

MTS Process Manufacturing

2035

ZOTC2

MTO-TC2

 

2035

ZOTC2

MTO-TC2

2035

ZSTC2

MTS- TC2

 

2035

ZSTC2

MTS- TC2

2040

YB0002

MTS Process Manufacturing

 

2100

ZSTC2

MTS- TC2

2040

ZSTC2

MTS- TC2

 

2045

ZSTC2

MTS- TC2


Plant Data View






Warehouse mgmt. views




Please note Storage Strategies section is visible only if Warehouse Number is filled in selection screen of Organizational Levels.

Quality management view







Inspection Type

Description

Criteria for Selection

01

If the Material will have a Goods Receipt

If the ZPRO Material can be sub-contracted

03

If the Material just got Manufactured and needs to be inspected

If ZPRO Material

04

If the Materials is currently getting Manufactured and needs to be inspected

IF ZPRO Material

09

If it will be in stock over a period of time and may need re-inspection

If ZPRO Material


For Inspection types 01, 04 & 09 average inspection duration needs to be entered by the user. The other settings are Default and will be populated automatically.
Maintain 01 and 09 for Raw materials.

Inspection Type

Description

Criteria for Selection

01

If the Material will have a Goods Receipt

For all ZROH Materials

09

If it will be in stock over a period of time and may need re-inspection

If ZROH Material


For Inspection types 01 & 09 average inspection duration needs to be entered by the user. The other settings are Default and will be populated automatically.
ZHBE/ZLEH – for Structural Materials Quality Management Data view should not be created

Accounting views


PLEASE NOTE FOR ZROH: Please change Price Determination to 2 for all materials except Re-sale Items. If saved by mistake, please notify the FI team to change via CKMM. Once entered, this will be un-editable via material master.

PLEASE NOTE FOR ZROH: Please change Price Control Indicator to V for all materials except Re-sale Items. If saved by mistake, please notify the FI team to change via CKMM. Once entered, this will be un-editable via material master.


*re-sale ZROH – value RESALE MATERIAL - Purchased Finished Good in Material Planning Subtype field in Classification

Costing Views



Materials can be created using reference material (already existing one). The system will copy all the information from the old to the new one except:




Validate/report/search

MM03 – view material master





MM04 – material based changes








List of program names:

ZDM_MAT_QUER10Texts
Exporting the report



!worddavdf2027bc7f8c4c6ecc059cebbc158305.png|height=191,width=180!Export to excel

ZCYMAT_CD – display changes





Appendixes


Appendix 1 – List of Plant Data Stewards for both Structural and Process Materials


IM

Co.Cd. / Sales Org.

 

ZPRO; ZDEN

ZROH; ZUNW; ZHBE; ZLAG

Structural Materials

1237

Tulsa

Shannon ParkersonPatrick Lightsey
Vanessa Gonzalez

Laura Testa Chazz Pelfrey
Clint Baker (backup)

 

 

 

 

 

 

 

 

 

 

 

7218

Heanor

Alexandra WheatleyJames Taylor
Graham Hill
Lauren Kavanagh

James Taylor
Graham HillAmanda Brown
Lauren Kavanagh
(requests can be accepted from Alexandra Wheatley)

 

 

 

 

 

 

 

 

 

 

 

7223

Manchester

 

 

 

 

 

 

 

 

 

 

 

 

Process Materials

1246

Santa Fe Springs

Jennifer DominguezTracy Ng
Gilbert Alvarado
Mehrdad Nikamalfard
Demitri Wimalaratne
Caleb Lin

Jennifer DominguezTracy Ng
Gilbert Alvarado
Mehrdad Nikamalfard
Demitri Wimalaratne
Caleb Lin

 

 

 

 

 

 

 

 

 

 

 

7250

Keighley

Alan Fothergill
Marie Woodhouse

Alan FothergillMarie WoodhouseMelanie Greenfield

 

 

 

 

 

 

 

 

 

 

 

7252

Toulouse

Guillaume Garnier

Guillaume Garnier

 

 

 

 

 

 

 

 

 

 

 

7257

Mondovi

Andrea PeanoCristian Vallazza
Gianni Ronco

Andrea PeanoElena Vinai

 

 

 

 

 

 

 

 

 

 



Appendix 2 – Material Request form


Appendix 3 – Material Types

Material Types

 

 

 

 

 

 

 

Available Views

Produce Material
(ZPRO)

Procured Material
(ZROH)

Capitalized Spares For Projects
(ZUNW)

Spares
(Repairs and Consumables, MRO)
(ZHBE)

Service Items
(ZDEN)

Manufacturing Part Number
(ZHRS)

Non Stock Material
(ZLAG)

Returnable Packaging
(ZLEH)

 

Sales

Purchasing

MRP

Forecasting

Work Scheduling

Accounting

Costing

QM

Plant / St. Loc.

Import

Export

WM

EHS (N/A)

Label (N/A)

Quantity Update

Value Update



Appendix 4 – Material number ranges



Appendix 5 – Material type definition

Description

Material Type Definition

 

 

 

 

Produced Materials
(ZPRO)

Finished Goods and Intermediate items
 
Valuated                 = Yes
Tracked in Inventory = Yes

 

Procured Materials
(ZROH)

Raw Materials, Re-sale Items, Packaging (included in Production BOM)
 
Valuated                 = Yes
Tracked in Inventory = Yes

 

Non-Valuated Materials
(ZUNW)

Non-Valuated Materials, such as Capitalized Spares for Projects, with inventory tracking.
 
Valuated                 = No
Tracked in Inventory = Yes

 

Spares (Consumable Supplies, MRO)
(ZHBE)

MRO (Maintenance/Repair/Operating) materials, Consumable Supplies, Engineering Spares, etc.
 
Valuated                 = Yes
Tracked in Inventory = Yes

 

Service Items
(ZDEN)

Services provided to customers, such as Annual Fee in MSA contracts, Miscellaneous Charges, Testing Fee, etc.
 
Valuated                 = Yes
Tracked in Inventory = No

 

Manufacturer Part Numbers
(ZHRS)

Used by Procurement & Quality; Manufacturer Part Number materials are set up as children assigned to Parent Raw Materials; created to manage manufacturer contracts
 
Valuated                 = No
Tracked in Inventory = No

 

Non-Stock Material (Consumable Supplies, MRO)
(ZLAG)

MRO (Maintenance/Repair/Operating) materials, Indirect (non-production/non-BOM) procured materials, such as Office Supplies and other Consumable Supplies
 
Valuated                 = No
Tracked in Inventory = No

 

Returnable Packaging
(ZLEH)

Returnable Cylinders
 
Valuated                 = No
Tracked in Inventory = Yes

 



Appendix 6 – Required Documentation for Material Maintenance Requests Based on the Type of Change


Type of set up/change

Plant data steward approval required?

Required documentation/information

Responsible party

Finished Good / Intermediate creation (Global Views)

YES

Request form

DMO

Factory Good (Raw Material) creation (Global Views)

YES
(except for Heanor and Manchester)

Request form

DMO

Material extension to plants

YES

Collection form

Plant Stewards

Material Global view specific field changes (Material Group; Resin Type; Resin Name; Reinforcement Type; Fiber Twist; Fiber Tow Size; Fiber Sizing; Recommended Storage Statement; Resin Lot Definition; Fiber/Fabric definition; Material Planning Subtype)

YES

Request form

DMO

Material Global view specific field changes (any other fields not mentioned in the p. above)

YES

Request form

DMO

Alternative Units of Measure (conversion change)

YES

Conversion expressed in format of Base UoM vs Alternative UoM

DMO
Procurement and Pricing to be informed

Alternative Units of Measure (adding an additional/missing UoM)

YES

Conversion expressed in format of Base UoM vs Alternative UoM

DMO

Material extension (to storage locations)

YES

Plant and location numbers

Plant Stewards / DMO

Manual / Automatic Mass Changes

YES

Mass Change Request form

DMO

Any Local view field changes that involve default values per Job Aid (if the field is currently blank).

NO (but they need to be informed)

No documentation required

DMO

Description change

YES

Request form

DMO