Version 1.0 Updated: 08/26/2008
SAP Material Master Maintenance
LOG-MD-002 Aug 27, 2008
SAP Material Master SAP Material Master Maintenance Maintenance
LOG LOG-
- MD
MD-
- 002
002 Aug 27, 2008 Aug 27, 2008
LaGov LaGov Version 1.0 Updated: 08/26/2008 Agenda Logistics, - - PowerPoint PPT Presentation
SAP Material Master SAP Material Master SAP Material Master Maintenance Maintenance Maintenance LOG- -MD MD- -002 002 LOG LOG-MD-002 Aug 27, 2008 Aug 27, 2008 Aug 27, 2008 LaGov LaGov Version 1.0 Updated: 08/26/2008 Agenda
Version 1.0 Updated: 08/26/2008
SAP Material Master Maintenance
LOG-MD-002 Aug 27, 2008
SAP Material Master SAP Material Master Maintenance Maintenance
LOG LOG-
MD-
002 Aug 27, 2008 Aug 27, 2008
Friday, November 07, 2008 2 Friday, November 07, 2008 2
Agenda
– SAP terms glossary – Process improvement opportunities – SAP concepts & functionality – Leading practices – Enterprise readiness challenges
Friday, November 07, 2008 3 Friday, November 07, 2008 3
Before we get started ... Logistics
Friday, November 07, 2008 4 Friday, November 07, 2008 4
Ground Rules
spectator sport
close laptops
Friday, November 07, 2008 5 Friday, November 07, 2008 5
Introductions
Leads and facilitates the discussions; drives design decisions
support the formal meeting minutes (to be sent by the Process Analyst to all participants for review and feedback)
process discussions; addresses key integration touch points
detailed business processes and participates in the decisions required to design the future state business processes Around the Room Introductions:
Friday, November 07, 2008 6 Friday, November 07, 2008 6
Blueprint Objectives
Business Processes:
business requirements
integration points with other processes
based on:
Friday, November 07, 2008 7 Friday, November 07, 2008 7
Blueprint Objectives (continued)
Impact / Enterprise Readiness Challenges
wide Training Requirements
Friday, November 07, 2008 8 Friday, November 07, 2008 8
Today’s Workshop Objectives
Material Record (Stock item no.) maintenance
To-Be Processes:
– Creation – Change general (central), local – Block – Flag for deletion
Friday, November 07, 2008 9
Project Phases
Five Key Phases
Project Preparation Business Blueprint Realization Go Live and Support Final Preparation
Friday, November 07, 2008 10
Functionality Tentative Implementation Date Budget Prep October 2009 DOTD February 2010 Core Modules All Agencies July 2010 Additional Modules January 2011
Tentative Project Timeline
Project Start-Up
May – June 2008 July 2008 August – Dec 2008 January 2009
Blueprint
Phased deployment will be confirmed/updated before completion
Friday, November 07, 2008 11 Friday, November 07, 2008 11
Blueprint Schedule - Tentative
Blueprint sessions.
Friday, November 07, 2008 12
Finance Leads Beverly Hodges – Finance Lead Drew Thigpen – Finance Lead Mary Ramsrud – Consulting Lead Logistics Leads Belinda Rogers – Logistics Lead Jack Ladhur – Logistics Lead Brad Denham – Consulting Lead Linear Assets Leads Mark Suarez – Agile Assets Lead Charles Pilson – Consulting Lead
Procurement Contracting Facilities Maintenance Fleet Maintenance Mobile Solutions Materials / Inventory Warehousing
Project Organization - Functional Teams
Belinda Rogers Karen Pierce Sterrie Elliott Adam LaTour Sudhir Deshmukh
Friday, November 07, 2008 13 Friday, November 07, 2008 13
Friday, November 07, 2008 14 Friday, November 07, 2008 14
As-Is Discussion of Material record maintenance for DOTD and DPS
Friday, November 07, 2008 15 15
DOTD “As-Is” Create or Change Material
Friday, November 07, 2008 16
DOTD “As-Is” Deletion Process for Material
Material Deletion process for DOTD
Procurement Manager Procurement Specialist USER
Delete material Required Approve Deletion Request Material deletion notification Delete material / Stock number from PIMS Delete material in Web App STOP Request Valid Is the material in Inventory No Stop Communicate with requestor with denial of deletion Mark item for future deletion (i.e. when stock goes to zero) Notify user of deletion Yes No Print & File material deletion documentation YesFriday, November 07, 2008 17
DOTD Initial Request Form
Friday, November 07, 2008 18
DOTD Material Specification Example
stock items in PIMS.
Stock Number MS Spec. No 195-001 24-16-9600 Dated 2/17/2003 LOUISIANA DEPARTMENT OF TRANSPORTATION AND DEVELOPMENT SPECIFICATIONS DRY BAGGED CONCRETE MIX DESCRIPTION: This specification covers dry bagged concrete to be used for minor concrete repairs, installing sign posts, installing fence posts, installing guard rail posts, etc. MATERIALS: Aggregate: Aggregate shall be dried, screened sand and pea gravel. Cement: Cement shall be Type 1 Portland Cement Blended Product: The above materials shall be blended according to the manufacturers’ directions. The blended product shall have a minimum proportion of 12:20:48 (12 pounds cement: 20 pounds pea gravel: 48 pounds sand). When tested, test specimens Shall be molded and cured in accordance with DOTD TR-226 and tested in accordance with DOTD TR-230, the minimum average compressive strength shall be 3,000 psi. PACKAGING: The mixture shall be packaged in 80 pound bags. The bags shall be a minimum of double-layer Kraft paper suitable of containing the concrete mix under normal handling conditions. The bags shall be shipped on polyethylene-covered pallets containing 40 bags per pallet. SAMPLING: Sampling shall be in accordance with the Department’s Materials Sampling Manual.
Friday, November 07, 2008 19
DPS “As-Is” Create or Change Material
Create/Change Material Master Process for DPS
Warehouse Manager End User
Identified new item for inventory Review information in e- mail E-mail received from End User Inquiry/Analysis performed to determine an addFriday, November 07, 2008 20
DPS “As-Is” Inactivation Process for Material
Friday, November 07, 2008 21
DPS Initial Material Request Form
individual to submit a request for a specific form by Form No., Form Name, Quantity, Size, etc.
Friday, November 07, 2008 22 Friday, November 07, 2008 22
Friday, November 07, 2008 23
SAP Glossary
(blonde hair, blue eyes, 5’2” tall, 120 lbs…are all attributes of a human)
administrative units with a common purpose; a self-contained unit in an SAP system with separate master records and its own set of tables (“The State of Louisiana”)
Each company code has its own balance sheet and its own profit and loss statement. Example : a subsidiary company, member of a corporate group (“The State”)
logistics transactions are processed
database
enterprise according to the requirements of Purchasing
Friday, November 07, 2008 24
Storage Location A003 Storage Location A003 Storage Location A003 Storage Location A003
“Going In” Logistics Structure
Company Code 0001 (State of LA) Company Code 0001 (State of LA)
Plant
C003(DOTD Sec 45)
Plant
C003(DOTD Sec 45)
Plant A001 (DOA) Plant A001 (DOA)
Plant B002
(DPS Mgmt & FIN)
Plant B002
(DPS Mgmt & FIN)
Storage Location A001 Storage Location A001
Department Level
Storage Location A002 Storage Location A002 Storage Location A003 Storage Location A003
Agency Level
Storage Location B001 Storage Location B001 Storage Location B002 Storage Location B002 Storage Location C001 Storage Location C001 Storage Location C002 Storage Location C002 Storage Location A003 Storage Location A003 Storage Location A003 Storage Location A003 Storage Location B003 Storage Location B003 Storage Location A003 Storage Location A003 Storage Location A003 Storage Location A003 Storage Location C003 Storage Location C003
Guiding Principle: If a given
wants to track the financial costs of that inventory at a given level, then that
Note: Physical inventory taking (conducting an inventory and cycle counting) takes place at the Storage Location level! Note: Physical inventory taking (conducting an inventory and cycle counting) takes place at the Storage Location level!
Friday, November 07, 2008 25 Friday, November 07, 2008 25
Friday, November 07, 2008 26
“To–Be” Create or Extend Material Request Process Flow
Friday, November 07, 2008 27 Friday, November 07, 2008 27
Material Master Record Creation
Records.
small group of people who are referred to as the Material Master Record Maintainers (MMRM).
Friday, November 07, 2008 28
Material Master Creation (Continued)
record to be created.
required information to create new material master and forwards the request to Material Master Record
exists in the system or not. If it exists but is not extended to the organization (Plant/Purchasing Org) of the requester, MMRM will proceed to extend the master record to that organization.
Friday, November 07, 2008 29
Material Master Creation (Continued)
not exist, then MMRM will create the record using the data provided by the requester.
record and will notify the requester to verify the data.
requester will notify MMRM.
will send a general SAP mail to the requestor.
Friday, November 07, 2008 30
“To–Be” Change Material Request Process Flow
Friday, November 07, 2008 31 Friday, November 07, 2008 31
Material Master Record Change
Records.
a small group of people who are referred to as the Material Master Record Maintainers (MMRM).
Friday, November 07, 2008 32
Material Master Record Change (Continued)
1. The requester identifies the need to change the material master
requesting agency. 2. If the requester identifies the need to change the basic material master data view, the requester will send the change request with the data to MMRM. 3. MMRM will send the requested changes by email to all the agencies using the material for their review. 4. If none of the agencies has any comment, MMRM will make the changes in SAP and will notify the requester and all the agencies
requested change and will send an email to the requester in that effect.
Friday, November 07, 2008 33
“To–Be” Delete Material Request Process Flow
Friday, November 07, 2008 34
Material Master Deletion
will not be used by the agency in the future and sends a request for deletion to MMRM.
approve deletion request.
for deletion in SAP, providing none of the agencies are using that material.
that have decided not to use this material in the future.
Friday, November 07, 2008 35
Material Master Maintenance Processes Summary
centrally by MMRM using transaction code MM01.
requesting agencies using transaction MM02.
performed by MMRM using transaction code MM02.
by MMRM using transaction code MM06.
by MMRM on Basic data 1 view – field “x-plant matl status”.
Friday, November 07, 2008 36
Sample Material Request Form
Friday, November 07, 2008 37 Friday, November 07, 2008 37
Questions?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?