工作生活与爱好

工作中的记录; 生活中的记忆; 业余爱好的记载。

2007-02-01

 

Variances between material and account of stock when you use MB5L

First of all, what MB5L works was that this transaction looks in the table T030, the accounts assigned to the inventory, and computes the total values based on the accounts. The values shown in the 1st column in the table, belongs to the values in the MBEW table. The FI values are build up based on the BSEG table. The point is that sometimes some postings are set in the MBEW table without being posted on BSEG (and vice versa).

There have been several reasons which are well attributable to this problem -

1) Change in the Valuation Class of the Material Master which results in the fact that the account determination or account used in the automatic posting was changed;

2) Maintenance of GR/IR clearing account via Transaction MR11 after executing the month-end closing (Transaction MMPV);

3) Adjustment of G/L account (JV process) for direct posting;

4) Price adjustment via Transaction MR21;

5) Manual posting of costs directly to inventory account via LIV.


 

Automate the opening of MM periods

How can you automate the monthly opening of MM periods (transaction MMPV - program RMMMPERI) with
SM36?

RMMMPERI accepts a period/year or a date.

If you enter a date the period is derived by it.

1. create a variant and check the attribute 'selection variable' for the parameter date. Then click the button 'Selection variables' and set the current date. Every time this variant is used the parameter DATE is filled with the current date.

2. create a job for RMMMPERI with the variant created in the preceding step. Set it as periodic.
If you're not using a fiscal year variant simply schedule it as monthly (to be executed the first day of the month).
If you are using a fiscal year variant you'd have to define a calendar with only the first day of each period defined as working
day and use it in the periodicity restrictions.

Another possibility:
Write a very simple ABAP which run daily to check if the period has changed and submit RMMMPERI.

 

Planned Delivery Time as Workdays

Is there a way to change the planned delivery time to workdays instead of calendar days? If not, does anyone have a way (other than adding two days to all planned delivery times) to start the planning process two days earlier when a weekend is involved in planning.

Yes, there is the possibility for you to define the Plnd Delivery Time exclusive of weekend (Saturday and Sunday). What you have to do is:

1) Maintain the Calendar via the following path: SPRO ----> General Settings -----> Maintain Calendar. This step will help define the appropriate calendar that you would prefer to set.

2) Define the Plant parameters via the following path: SPRO ----> Enterprise Structure -----> Definition --------> Logistics - General ------> Define, copy, delete, check plant. Select the Plant that you would like to define the Plnd Delivery Time and then, in the Factory Calendar, select the calendar that you have defined in step 1.

If you have already have our plants assigned to a factory calendar(Z1). Is it possible to get the planned delivery time to plan according to this calendar? If so, how?

Once you have assigned the appropriate calendar to your plant location, then you can start maintaining your material master data records with referecne to this Plant and the Plnd Delivery

Time of these master data will be calculated based on the Calendar that you have set for this particular plant.

My understanding was that Plannned Delivery time is always 'real' days, where as GR time considers the factory calendar. Perhaps that is just the way we have configured it?

The way we use it is that goods do travel over the weekend, but GRs are only done according to the factory calendar - so it works well for us.

Delivery time is only calculated in calendar days, not working days.


 

Physical Inventory Item Class

My question is about Physical Inventory. In general we do PI once in a year. Well for which item class ( A, B, C or none) we mostly do this excercise and why. I know what PI is but as far as industrial practice and logic behind selection of the item is concerned, I have a doubt.

Dakshita

Managing your physical inventory is a crucial part of running your business, if it is not monitored correctly you could have large variances, both negative or positive. A physical inventory count is carried out to determine the exact physical quantity of an article that is in your store at a particular time.

Stock quantities are then updated based on the actual level determined during the physical count.

It is important to monitor the accuracy of your stock levels, not only to identify any stock loss that may be occurring, but also to avoid processing sales against stock that you physically do not have, also to know when it is necessary to replenish stocks that run low.

George Sewmungal

I think you are asking about the stratification analysis: i.e.: after the unit cost X annual volume is calculated for all items, you sort the list and mark off the strata from the top down:

A = 70% - 85% of accumulated value
B = 10% - 20% of accumulated value
C = 5% - 10% of accumulated value
D or Blank = fasteners, no cost/low cost items etc.

The logic is that the A items will be comprised of costly or high volume items that account for the majority of the company’s inventory assets. These are usually only about 15 – 20% of the material numbers in the database. They are usually counted 4 times or more per year. Some companies count these every month. Mismanaging these items can bankrupt the company and they deserve special attention. Anyway that is the conventional wisdom.

B items are middle value/volume and are usually counted twice a year or thereabouts.

C items are low cost/volume items and are usually counted only once per year. They usually account for about 80% of the number of items in inventory but only 20% of the value. The most important thing about C items is to keep them in stock so you don’t run out.

The selection within each stratum is usually random but not necessarily. Some companies will store the items in segregated shelving and count by shelf, for example.

I hope this more completely answers your question. If not, please ask for clarification.


 

Physical Inventory Process

What are the step to do physical inventory process? I want to make zero stock and then upload the actual stock?

First you can use the trn. MI01 there put all the material save, then use T-Code MI04 there you have to enter the count the if you want put 0, put it and make the tick then save then use MI22 post the difference.

About Physical inventory process you have another way :
1. Use t-code MI31 instead of using MI01 , it will give you a document number of all your stock.
2. If you did not get the document number use t-code MI24 .
3. MI21 to print the document.
4. MI04 to enter the count if you want put 0.
5. MI07 post.

Create PI document using MI01 (MI31 -Using Batch)
Enter Count Using MI04 (Select Zero Stock Indicator)
Post Count results using MI07
Check Results using MI24
Upload initial Stock using MB1C 561

Tips by : Phani

Note: For the first initial upload, the best options is to get your abapers to write a simple BDC upload program from the SAP screen mb1c (mvt type 561) using the file type csv (format save in excel).

If you freeze wrongly, you can used MI02 to manually delete the freeze physical inventory documents number.


 

What is A, B, C and D Indicator for a material for cyclic count?

All the material may not be important for cyclic count purpose, it may be required to count
some items frequently and some items rarely.

A cyclic count indicator A or B or C or D is allocated to material in the material master
based on either consumption value (consumption X rate) or forecast value
(forecast quantity X rate).

The item with more consumption value are classified as A, and with minimum as D.

“A” indicator items will be counted frequently (say every month), D will be less frequently
(say every 6 months or every one year). Daily a number of items will be taken for count, some
may be with A indicator, some with B and so on.

Mark all materials that are to be included in cycle counting with a cycle counting indicator
in the material master record (storage data). The cycle counting indicator is used to group
the materials together into various cycle counting categories (for example, A, B, C, and D).

There is an option in SAP to have a fixed indicator for a material say A for a material which
does not have a high consumption value but it is important to count it every month, then the
material can be marked as A indicator in material master with indicator “fixed”


In Customizing OMCO, for Inventory Management, you can define for each category the time
intervals at which the materials are to be counted.


Fields : No. of phys. inventories per fiscal year for cycle counting

For e.g. A - 12, B - 6, C - 3, D - 1

Specifies how often during the fiscal year a physical inventory is to be carried out for a
material subject to cycle counting.

The system uses this specification to convert the count interval into workdays.


Fields : Physical inventory interval (in workdays) for cycle counting

For e.g. A = 12 times per year and your Total Factory Calendar days = 300

The interval will be calculated as 300 / 12 = 25 days

Specifies after how many workdays following the last inventory count another physical
inventory has to be carried out for a given material.

The count interval is determined automatically on the basis of the number of physical
inventories specified for the fiscal year.


Fields : Float time (in workdays) for cycle counting

For e.g. A - 10, B - 20, C - 30, D - 0

Indicates the number of workdays by which the planned count date may vary from the current
date.

For examples :-

For the plant, the float time is five days.

A physical inventory has been planned for a material belonging to category C for June, 1.
On expiration of the float time (after June, 6), the physical inventory has not yet been
carried out.
Irrespective of the category, the material is parked for the next cycle counting run.


Fields :- Percentage of performance measure for cycle counting ind.

Specifies the percentage allocation of the materials to the individual cycle counting
categories.

The percentage value is used for automatic assignment of the cycle counting indicator.

For example :-

In the given plant, 200 materials are subject to the cycle counting physical inventory
procedure.

In Customizing for Inventory Management, the following percentage allocation has been defined
for the plant:

A materials: 50%
B materials: 25%
C materials: 15%
D materials: 10%
----
100%
----

In the cycle counting analysis, the materials are sorted by consumption. After completion
of the analysis, the cycle counting indicator is assigned as follows:

The first 3 materials (sorted in descending order according to consumption) represent 50% of
the consumption and have the indicator A.

The next 12 materials represent 25% of the consumption and have the indicator B.

The next 49 materials represent 15% of the consumption and have the indicator C.

The remaining 136 materials represent the rest (10%) of the consumption and have the
indicator D.


You can use the program ABC Cycle Counting Analysis (MIBC - RMCBIN00) to perform an analysis.
In this analysis, the system assigns the materials to the individual categories according to
consumption or requirements (forecasts).

You can also specify whether this analysis is to consider only the materials with cycle
counting indicator or all materials. The cycle counting indicator in the material master
records can be updated automatically by this program.


Marking Materials for Cycle Counting

This step is only required if you perform cycle counting for the first time or if you want
to update the cycle counting indicators.

In the material master record (storage data), maintain the cycle counting indicator for all
the materials that are to be included in cycle counting.

You can set the indicator in one of the following two ways:

1. manually in the material master record. To do this, choose
Material -> Change from the Material Master menu.

2. automatically using ABC analysis To do this, choose
Special procedures -> Cycle counting -> Set CC indicator from the Physical Inventory menu.

 

Allow/Disallowed Backposting of Inventory Posting

Maintain the Material Master company code in OMSY.

This is done when you want :

1. To create a material master record, the control record must exist for the company code
for which you want to create your master record.

2. To set up a company code, enter the current period here.

3. When changing the Allow backposting or Disallow backposting indicators

You can also use MMRV to set the Allow/Disallowed backposting indicators.

The current and previous period is shown on both transaction codes.

 

Valuation Category

All of the valuation groupings work together.

You specify whether valuation occurs at plant or company code level in transaction OX14 (Define Valuation Level). Then whichever one you have defined becomes a Valuation Area. These areas can be grouped together for ease of account assignment, in which case they become valuation groups.

Account Category Reference codes are associated to material types.

Valuation Classes are associated to material types in account determination.

Also an explicit association of Account Category Reference number to Valuation Class is made in Account Determination.

For example, Material HALB - Semifinished Goods. Account Category Ref in Material Type is 0008. Valuation Class 7900 is linked to Account Category Reference 0008.

When a material is created, it is associated to the appropriate Valuation Class on Accounting View 1 of Material Master.

The automatic account determination facility looks up a posting based on the rules defined - whether to look at only Valuation Class, or Valuation Class and an additional Valuation Modifier for BSX postings for example. It will check the rules, look at the material, material type and valuation area and the rules for the movement itself (where the system is expecting to see the account definitions). All of the definitions need to be consistent. If you've defined a new Account Category Reference, you need to make sure that's associated to the Valuation Class and Material Type.

The fastest and best way to tell if something is going to post the way you want it to is to simulate the posting. You can do that in the initial screen with the simulate button. Choose the plant, the movement type and the system will ask for a material and then tell you where everything will post, or if there's a posting account that is missing.

 

MBST: Reversal of cleared items in FI

When canceling a material document or an invoice posted with Transaction MR1M (Logistics Invoice Verification), the system generates error message F5802: 'Document includes already cleared items - reversal not possible'

This situation occurs if both goods receipt and an invoice for a purchase order item (scheduling agreement item) exist and the GR/IR clearing account has been cleared in this regard.

If you still want to cancel goods receipt with Transaction MBST or an invoice with Transaction MR8M, you must reset the corresponding cleared items beforehand in the accounting document using Transaction FBRA 'Reset cleared items.

As an alternative, you can also carry out the correction described in Note 326707.


 

What is the technical difference between Client , Purchasing Org , Plant , Company code?

Client : Unit within SAP system, self-contained, separate master data with independent set of tables. It represent corporate group.

Company Code : Smallest organisational unit of external account for which a complete, self-contained bookkeeping system can be replicated. eg, company within a corporate group.

Plant : An organisational unit within logistics, subdivides an enterprise from the viewpoint of production, procurement and materials planning.

Purchasing Org : Organisation within logistics which subdivides an enterprise according to purchasing requirements.

The procurement business process uses this organisational structure:

Client--->Company Code--->Plant--->Storage Location--->Purchasing Org/ Purchasing group

SAP MM Tips by : Mabaile Mashao

The standard procedure for creating a new plant in SAP:

SPRO -> Enterprise Structure -> Logistics - General -> Define, copy, delete, check plant


 

Maintain the user default settings when creating Material Master

Default values while creating Material Master.
Is it possible to define default values for certain fields, while creating the material master?
I know about the MRP profile and the forecast profile. I am looking for something similar for defaulting values for certain fields in the basic view.

You can define the following defaults for each user with transaction code OMT3U in 4.6c :

Default Industry sector (Industry only)

Where in the config can you default the Industry sector in MM01?

You can define that a particular industry sector is proposed whenever the user creates a material master record. However, this setting cannot be made for the material master for retail since retail is itself the industry sector.

You can hide the industry sector if you do not want the user to change it. SAP will take the default Industry sector you specify in the IMG.

Goto your user profile, own data (tranx SU3), click on [Parameters] tab, place MTP under parameter and your desired
industry code, say M (for Mech/engr) in values and save. You should see your default in mm01.

A second possibility is in MM01 directly. In the menu Settings -> Industry (Default -> Industry Sector 4.6c) you can enter your default and can even flag a box that it should not be shown anymore.

In 4.6c, you have another choice, that is tcode OMT3U where you can Maintain the user settings for the default Industry
Sector.

So what you do depends on your preference and project cycle. If you have not yet gone live, and all of most of the materials is of a certain industry, then use the parameter option during user maintenance. If you have gone live, and then maintain in MM01 for a default.

Organizational levels (Industry and Retail)

You can define for a combination of user and screen sequence the organizational levels that are proposed whenever the user creates, changes, or displays a material master record, and the organizational levels and profiles that are proposed whenever the user creates a material master record.

Views that are preselected in the Select View(s) dialog box (Industry and Retail)

You can define for a combination of user and screen sequence that certain views appear as preselected in the Select View(s) dialog box.

Finally, if you create your material master record by referencing to the other material number, then several fields will be defaulted.


 

Maintain relation between Alternatives Materials

Hi Sappers, this is a typical situation I am facing. Ours is an auto industry & we have materials that are alternatives to other materials. These materials are perfect substitutes of each other & are known as alternatives. (the user can consume either of the materials or both). How to maintain the relation between the alternatives in SAP? How the MRP considers the quantity of each alternative for the MRP calculation?

Priya Rao

You can have 2 options:

1) Create only one generic material in your system and while placing orders for different equivalent materials, mention the equivalent product name in the vendor info record Under vendor prwhich will get copied to Purchase order. Thus in your system you will have only one material.

2) If this is not suitable for you, than you can configure Manufacturer Part Number functionality.

Option No 1 . Pl take this scenario of a Chemical co.

Step 1 - Creation of Material in SAP

Genaric Material Vendor
(Silicon Surfactant)

Alt.Material 1 Vendor X
Alt.Material 2 Vendor Y
Alt.Material 3 Vendor Z

In this case, you will create material in SAP as Silicon Surfactant. This material will be used in BOM.

You will not create 3 different alt.materials like Material 1,2 and 3 in system.

Step 2 - Vendor Inforecord will have Vendor Material No i.e Material 1 etc.

Thus whenever you will print PO, PO will be printed with reference to your internal SAP material no i.e of Silicon Surfactant and will also have vendor material no. If you want only Vendor material to be printed then you have change the print format.

Thus for MRP, only 1 material will be cionsidered. Hope this is clear.

Option No2 -Manufacturer's Part Number
Step 1 -
In customisng under Lo General - Material Master - You have to create a MPN profile.

Step 2 -
Create normal material under material type ROH or Traded as required. Under purchasing tab , maintain MPN Profile,Manufacturer's part number(Vendor material number) and Manufacturer's code.(Vendor Code)
This is a material in which you will maintain stock, use in BOM etc. This is your internal material number. This number will not be used in the PO.

Step 3
Create a new material each for your alternative materials under Material type HERS. Under this you will create material which is supplied by your vendor.In this material you will link the internal material number as created in step 2 above.

Step 4
Create a PO by using material number created under material type HERS.

Step 5 - Do a GRN

MPN process works like this :
Order is created for HERS material but whenever you will do GR against this PO, stock and other reports will get updated under material code created in step 2 i.e normal material created under material type ROH or traded. Thus HERS material is used only for ordering purpose.


 

SAP Inventory - Allow Negative stocks

In order to use negative stocks, you have to allow negative stock in customizing.

Only those materials for which negative stocks is activated in the material master, will be allowed to have negative stocks.

Customizing: transaction OMJ1 - Allowing Negative Stocks.

First level: Valuation area.

Choose for which valuation area you want to allow negative stocks and activate the flag.
Select the line of that valuation area and go to the plant level.

Second level: Plant.

When only one plant exists for that valuation area (this will always be the case in case the valuation area is defined as a plant), you see immediately a details screen with special stocks.
Choose the special stocks that may go negative. Next use F3 or the green arrow to return to the overview of the plants. Select the plant and go the the storage location level.

Third level: Storage Locations.

Select for which storage locations negative stock is allowed.

Save the whole lot.

Negative stock will now be allowed in the selected storage locations for all materials that have the negative stock indicator activated in the material master in the storage 2 view.

 

Controlling the Fields in Material Master

Define whether a field is hidden or displayed, or whether an entry is mandatory or optional in material master maintenance by assigning the field to a field selection group in OMSR.

Each field selection group has a number between 1 and 240.

The values of the field selection groups have been preassigned as follows:

001-110 Material master for industry
111-120 Reserved for customers (except where the values are already in use)
121-150 Material master for industry
151-210 Material master for retail
211-240 Reserved for customers

Create and maintain field references (OMS9).

All the fields in the same fields group will have the same field selection option.
(hide, display, required entry, or optional entry)

You can see where a field reference is used by choosing Where-used list.

Define or change the field references as required (except for field references with the prefix SAP which must not be changed). New field references must begin with Y or Z.

Changing the Field Selection Options for a Field Selection Group

1. Specify the field selection group .
2. Select the field selection option (hide, display, required entry, or optional entry)
for each field reference as required.
3. Save.

Creating a Field Reference

1. Choose New entries.
2. Specify a field reference beginning with Y or Z.
3. Select the field selection option for each field selection group as required.
4. Save.

Changing a Field Reference

1. Double-click the relevant field reference.
2. Change the field selection option for each field selection group as required.
3. Save.

Define industry sectors and industry-sector-specific field selection in OMS3.

Define plant-specific field selection and screen selection in OMSA.


 

Control the Output Format of your Material Numbers

In OMSL, you can define the following:

1. Input and output length of material numbers
(A material number can have a maximum of 18 characters).

2. Template for displaying or printing material numbers.
You indicate with an underscore any position in the material number that you do not want
to contain a template character.

3. Form in which material numbers are stored

4. Output with or without leading zeros

The settings are client independent.

Archives

1990-1-15   2007-1-14   2007-1-15   2007-1-16   2007-1-17   2007-1-18   2007-1-19   2007-1-20   2007-1-22   2007-1-23   2007-1-24   2007-1-25   2007-1-26   2007-1-27   2007-1-29   2007-1-30   2007-1-31   2007-2-1   2007-2-2   2007-2-3   2007-3-13   2007-5-15   2007-5-16   2007-6-2  

This page is powered by Blogger. Isn't yours?