工作生活与爱好

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.

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.

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.

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.

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.

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.

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.

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.