Business Memo Format Sample

business memo format sample

Migrating Material Master into SAP

Harlex Consulting Services Ltd – http://www.harlex-ltd.com

Migrating Material Master into SAP

1          Overview

1. 1.1        Introduction

This document is intended as a simple guide in how to overcome the common problems in migrating Material Master into SAP.

For a one-time conversion into SAP, we favour using the LSMW tool. It allows you to leverage the full power of ABAP while using standard SAP processing functions, yet it does a lot of the file management and processing work automatically. However, even within LSMW there are a number of possible methods for migrating Materials.

This document will discuss loading Materials using the standard load program RMDATIND with a brief mention of other methods.

1. 1.2        Load methods

1. 1.2.1     Standard load program RMDATIND

This is the approach I favour for the migration of the Material Master into SAP.

The standard load program is not perfect but it is flexible and you do not have to be one hundred per cent accurate with the population of fields, i.e. in BDC a populated field that is not available in the current screen will cause a message to be raised, in RMDATIND we can specify the level at which to report errors and so are able to ‘skip’ these messages.

It is a powerful and flexible program, and it is relatively simple to use. If you are unsure in certain situations (eg. a material with multiple plants and sales organisations) as to how to manipulate your load file in LSMW into the load format for RMDATIND, you can manually create a test material in your development system and then run program RMDATGEN on that material to view a sample file.

The fact that you can run the load step in test mode before creating any data is also a major advantage.

1. 1.2.2     BDC recording of transaction MM01

This solution is only suitable for a very basic upload. If for example you are only creating the basic data or if you want to go further, limit the recording to one material type as screen sequences can and usually do change between material types and this will cause problems in your BDC session. A BDC recording for MM02 (Change) can be a quick way of updating one or two fields for existing materials but again be aware of the different screen sequences that may appear.

1. 1.2.3     BAPI – object type BUS1001006

As always, the BAPI is a flexible and powerful tool though often not particularly intuitive. Using LSMW you could load materials using the Standard Material business object. This uses ALE message type MATMAS_BAPI and BAPI function BAPI_MATERIAL_SAVEDATA. We favour the standard load program RMDATIND as it is fast (direct upload) and simple to use, and also because it can be run in test mode.

1. 1.3        Assumptions

This document assumes a working knowledge of LSMW, and at least some basic understanding of the structure of Material data in SAP.

2          The Basics

1. 2.1        Data structures

There are multiple structures in the Material Master load program RMDATIND, below are listed those commonly used:

1. 2.1.1     BMM00

This structure is mandatory and contains the key information used in creating a Material.

1. 2.1.2     BMMH1

This structure is mandatory and contains most of the remaining data needed to create a Material, e.g. Description, Basic Unit of Measure, Legacy Material Number, plus Purchasing data, Plant data etc.

1. 2.1.3     BMMH2

This structure is used when more than one tax country is required for Sales.

1. 2.1.4     BMMH5

This structure is used when the material short description is required in more than one language.

1. 2.1.5     BMMH6

This structure is used to populate alternate units of measure as required by the business, e.g. Purchasing buy a product in Cases but Sales sell in Pieces, these conversion factors between the different units need to be captured here.

1. 2.1.6     BMMH7

This structure is used to populate long texts for the material, e.g. Sales text, Purchasing text, Long Description, etc.

1. 2.2        Important fields

Structure           Field     Field Name       Details

Key Fields

BMM00-MATNR Material Number-Can be either Internal or External

BMM00-MTART Material Type-Mandatory

BMM00-MBRSH            Industry Sector-Mandatory

BMM00-WERKS            Plant

BMM00-LGORT Storage Location

BMM00-VKORG            Sales Organisation

BMM00-VTWEG            Sales Distribution Channel

BMM00-TCODE SAP transaction-MM01 for creation, MM02 for Change

Basic Data

BMMH1-MAKTX            Short Description-Mandatory field

BMMH1-MEINS             Base Unit of Measure-Mandatory field

BMMH1-MATKL Material Group-Usually mandatory

BMMH1-BISMT              Legacy Material-Usually mandatory for migration

BMMH1-MTPOS_MARA General Item Category Group

BMMH1-PRDHA            General Product Hierarchy-

Purchasing Data

BMMH1-EKGRP            Purchasing Group

BMMH1-PLIFZ               Planned delivery time-Also appears in MRP

BMMH1-WEBAZ            GR processing time

BMMH1-BSTME            Purchasing Unit of Measure (Only if purchasing unit <> base unit)

Sales data

BMMH1-SPART Division-Also appears in Basic Data

BMMH1-VRKME            Sales Unit of Measure-Only used if Material sold in a unit different to the base unit

BMMH1-DWERK           Delivering plant

BMMH1-KTGRM            Account Assignment Group

BMMH1-KONDM           Material Pricing Group-If specified must exist in customizing

BMMH1-PRODH            Sales Area Product Hierarchy-If specified must exist in customizing

BMMH1-MTPOS            Item Category Group-If specified must exist in customizing

BMMH1-VERSG            Material Statistics Group-If specified must exist in customizing

BMMH1-MTVFP            Availability Check-Also in MRP. If specified must exist in customizing

MRP data

BMMH1-DISPO             MRP Controller-If specified must exist in customizing

BMMH1-DISMM            MRP Type-If specified must exist in customizing

BMMH1-DISLS              Lot size-If specified must exist in customizing

BMMH1-BSTMI              Minimum lot size-Not always used – depends on Lot Size

BMMH1-BSTMA            Maximum lot size        -Not always used – depends on Lot Size

BMMH1-BSTFE             Fixed lot size          -Not always used – depends on Lot Size

BMMH1-MABST            Maximum stock level

BMMH1-BESKZ            Procurement type-If specified must exist in customizing

BMMH1-SOBSL            Special Procurement -If specified must exist in customizing

BMMH1-LGPRO            Production Storage Location-If specified must exist in customizing

BMMH1-LGFSB Storage Location for External Procurement-If specified must exist in customizing

BMMH1-EISBE              Safety Stock

Accounting data

BMMH1-BKLAS             Valuation Class-If specified must exist in customizing

BMMH1-STPRS Standard Price

BMMH1-PEINH              Price Unit

BMMH1-VPRSV            Price Control

Costing data

BMMH1-PRCTR Profit Centre-If specified must exist in customizing

BMMH1-LOSGR            Costing Lot Size

BMMH1-NCOST            Do Not Cost

Foreign Trade data

BMMH1-STAWN            Commodity Code-If specified must exist in customizing

BMMH1-HERKL Country of Origin-If specified must exist in customizing

BMMH1-HERKR            Region of Origin-If specified must exist in customizing

Tax data

BMMH2-ALAND            Tax Country-If specified must exist in customizing

BMMH2-TATY1              Tax type for Country (upto 9)-If specified must exist in customizing

BMMH2-TAXM1 Tax Class for Tax Type-If specified must exist in customizing

Description data

BMMH5-SPRAS            Language of Description-This must be in internal format, e.g. ‘D’ for German

BMMH5-MAKTX            Short Description-

BMMH5- SPRAS_ISO    Language in ISO code-Specify this as an alternative to SPRAS

Alternate Unit of Measure data

BMMH6-MEINH             Alternate Unit of Measure-This must be in internal format

BMMH6-UMREN            Numerator-For standard measurements these MUST be specified as per SAP.

BMMH6-UMREZ            Denominator-For standard measurements these MUST be specified as per SAP.

Long Texts

BMMH7-TDID                Text ID              ‘GRUN’ = Basic text

‘BEST’ = Purchasing text

‘0001’ = Sales text

‘PRUE’ = Inspection text

‘IVER’ = Internal comment

‘LTXT’ = Material memo

BMMH7-TDSPRAS        Language key

BMMH7-TDLINE            Text line

BMMH7-TDSPRASISO  Language in ISO code   Specify this as an alternative to SPRAS

1. 2.3        Modifying the standard structures

It is possible to upload customer specific fields with RMDATIND. You will need to create/modify the structures, usually ZMMH1 and CI_MMH1, if additional fields have been added to a SAP table or the field(s) you require are not currently available in RMDATIND.

For full details please see OSS note 44410.

3          Common Problems

1. 3.1        Legacy Material Number

It is crucial when migrating Materials into SAP that a reference to the Legacy number be stored.

It is important both for business and technical reasons; business users will initially want to be able to find materials based on the legacy code, it is the one they know; technical users will need the link such that subsequent objects can be successfully loaded, e.g. open purchase orders, Inventory load.

The intended and normally used field for this purpose is BISMT but note that some materials are duplicates of one another and this cannot be handled solely by using BISMT.

As mentioned it will be necessary to retrieve the SAP material for not only subsequent objects but also to ensure duplicate materials are not created within SAP. It is therefore recommended to create a routine that can be called by all the required programs; we suggest GET_SAP_MATNR.

1. 3.2        Duplicate Materials

The existence of duplicate master data is often a problem when migrating data from legacy systems. It will normally be required to setup a simple translation table in LSMW to handle duplicate material master records.

This translation will need to be accessed in the above mentioned GET_SAP_MATNR routine to ensure the correct SAP material number is returned.

1. 3.3        Alpha conversion

When loading materials (or any object) it is good practice to validate customised fields and the master data itself. To this end you should always be aware of the format of the data as stored within the database, e.g. It is possible to pass ‘123456’ as the MATNR but to check if that material all ready exists you will need to pass it as 18 characters with the leading zeroes as this is how it is stored in the database tables.

1. 3.4        Taxes

In multi-country organisations it can often be the case that Taxes are required for multiple countries. The way to determine which countries is to call function STEUERTAB_IDENTIFY. You will still need to know which Tax Class to use for each Tax type.

1. 3.5        Multiple Plants

It is normal for a material to exist in more than one plant and a common error is to try to re-populate the sales data at the same time, which results in a message that can be mis-leading. When creating a material in more than one plant for which both plants exist in the same sales area reset BMM00-VKORG and BMM00-VTWEG to the ‘NODATA’ flag, default ‘/’.

1. 3.6        Units of Measure

You should only specify the BMMH1 alternate units, e.g. Purchasing unit, Issuing Unit, if they differ from the base unit otherwise an error will be flagged. Once an alternate is specified structure BMMH6 must be created for each alternate.

N.B. the values specifies in UMREN and UMREZ must be accurate, no automatic correction takes place in direct-input mode unlike online mode.

1. 3.7        Background Load

For high volume loads it is usual to submit the load in background. To do this it is required to setup a job via BMV0 and submit via the same transaction. A typical error comes during the production load as multiple processors are usually present and the job is routed to the ‘background’ processor but the input file for RMDATIND has been created on the ‘dialog’ processor; the key is to either specify the ‘dialog’ processor on which the file is converted at the job submit phase or perform the import and convert phases on the ‘background’ processor.

4          Footnote

This guide should be viewed as a starting point for discussions and is not intended as an exhaustive examination of the various methods available. There will inevitably be circumstances specific to individual situations that cannot be covered here.

For further information on the migration of materials into SAP or indeed on any data conversion topic, please contact Harlex Consulting Services Ltd at info@harlex-ltd.com.

Find more guides to SAP data migration here at http://www.harlex-ltd.com/downloads.html.

About the Author

Harlex Consulting Services are specialists in SAP Data Migration.
http://www.harlex-ltd.com

Effective Business Writing: A Guide For Those Who Write on the Job (2nd Edition Revised and Updated) $5.00 Effective Business Writing, now in a new, revised and updated edition, willh elp you write the letters and memos that are so important to your career: persuasive memos, goodwill letters, complaint letters, sales letters, executive summaries… Whether you’re writing an email message to a co-worker or a proposal to an international colleague, this book will help you choose an appropriate format, st…

1001 Business Letters for All Occasions: From Interoffice Memos and Employee Evaluations to Company Policies and Business Invitations – Templates for Every Situation $9.99 We live in a world of instant and constant communication, yet business still demands that we choose our words carefully and express ourselves clearly. Whether you’re sending a quick IM or a formal proposal, 1001 Business Letters for All Occasions ensures that you’ll convey your message effectively.Inside you’ll find proven templates and model letters for every type of business situation-and text f…

101 Sample Write-Ups for Documenting Employee Performance Problems $35.00 101 Sample Write-Ups for Documenting Employee Performance Problems makes this job easier by providing ready-to-go model documents that cover every kind of problem you can imagine – substandard work quality, absenteeism, insubordination, sexual harassment, e-mail misuse, drug or alcohol abuse, and more. 101 Sample Write-Ups for Documenting Employee Performance Problems also includes a diskette in M…

Peachtree By Sage Premium Accounting for Distribution 2007 5-User $1,169.99 Peachtree by Sage Premium Accounting for Distribution 2007 Multi-User Value Pack provides 5-named user access, advanced acounting and analysis tools, Crystal Reports for Peachtree, and distribution-specific reports. Consists of 1 CD and 5 user license….

Memo™ Medium $54 Download the Memo™ Medium font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Regular $54 Download the Memo™ Regular font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Bold $54 Download the Memo™ Bold font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Light $54 Download the Memo™ Light font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo Complete Family Pack $389 Download the Memo Complete Family Pack font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Medium Italic $54 Download the Memo™ Medium Italic font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Regular Italic $54 Download the Memo™ Regular Italic font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Bold Italic $54 Download the Memo™ Bold Italic font for Mac or Windows in OpenType, TrueType or PostScript format.

Memo™ Light Italic $54 Download the Memo™ Light Italic font for Mac or Windows in OpenType, TrueType or PostScript format.

01437 – Sparco Book Rings – 1.25 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 100 / Box – Silver $8.46 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01437] UPC: 035255014373 UNSPC: 44122117 1.02 LB

01438 – Sparco Book Rings – 1.5 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 100 / Box – Silver $6.64 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01438] UPC: 035255014380 UNSPC: 44122117 1.5 LB

01439 – Sparco Book Rings – 2 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 50 / Box – Silver $5.01 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01439] UPC: 035255014397 UNSPC: 44122117 1.09 LB

01436 – Sparco Book Rings – 1 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 100 / Box – Silver $7.29 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01436] UPC: 035255014366 UNSPC: 44122117 0.89 LB

01441 – Sparco Book Rings – 3 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 10 / Box – Silver $2.28 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01441] UPC: 035255014410 UNSPC: 44122117 0.57 LB

01435 – Sparco Book Rings – 0.75 inch Diameter – For Loose-Leaf, Memo Filing, Key Ring, Sample Holder – Nickel Plated – 100 / Box – Silver $4.96 these Book Rings Feature Bright Nickel-plated Finish. Great Variety Of Uses Such As Loose-leaf, Memo Filing, Key Rings And Sample Holders. [SPR01435] UPC: 035255014359 UNSPC: 44122117 0.6 LB

Sample Design in Business Research $161.85 No Synopsis Available

Small Square Memo-Black Zebra Stripes $31.49 • Small Square Memo-Black Zebra Stripes • Set includes: Customized Memo Pad; Acrylic Holder; Green Ribbon • Cardstock Color: White • Envelope Color: • Font Style as shown • Size: 4” x 4” The cute little memo holders are perfect for quick notes or reminders – stick them in lunch bags, briefcases, pocketbooks or backpacks. The Small Square Memo pad comes with a fun Black Zebra Strips pattern around the trim. Green ribbon and acrylic holder included with customized memo pad. There is one line of text at the top of the paper for you to customize as you like. Text comes in black ink only, and font style appears as shown in sample. Sheets measure 4″ x 4″.

Clemson Tigers Desktop Memo Set $9.99 Get organized! The Clemson Tigers Desktop Memo Set features a slot for a note pad- a slot for your business cards- hand enameled school emblem and comes with a stylish pen. Everything you need to keep up with the day-to-day life of a sports fan. Pen Included Officially licensed

Arkansas Razorbacks Desktop Memo Set $9.99 Get organized! The Arkansas Razorbacks Desktop Memo Set features a slot for a note pad- a slot for your business cards- hand enameled school emblem and comes with a stylish pen. Everything you need to keep up with the day-to-day life of a sports fan. Pen Included Officially licensed

Kansas Jayhawks Desktop Memo Set $9.99 Get organized! The Kansas Jayhawks Desktop Memo Set features a slot for a note pad- a slot for your business cards- hand enameled school emblem and comes with a stylish pen. Everything you need to keep up with the day-to-day life of a sports fan. Pen Included Officially licensed

Tennessee Volunteers Desktop Memo Set $9.99 Get organized! The Tennessee Volunteers Desktop Memo Set features a slot for a note pad- a slot for your business cards- hand enameled school emblem and comes with a stylish pen. Everything you need to keep up with the day-to-day life of a sports fan. Pen Included Officially licensed

This entry was posted on Sunday, October 26th, 2008 at 10:53 pm and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.