Example of a step by step to create Material master record

2) Example of a step by step to create Material master record.

Internal number assignment is considered here.

Key in Transaction code MM01 in the command field.

Select Industry sector is Mechanical Engineering and material type is Raw Material ROH Press Enter

Select views Basic data 1 Basic data 2 Purchasing

General Plant data Accounting 1

Click on check symbol or press Enter

Key in plant and storage location codes in the populated screen then press Enter.

Enter description of the material (e.g. Ball bearing with specification), base unit of measure, material group

Press enter, basic material is e.g. steel

131 | P a g e

We are maintaining the mandatory fields first then additional fields.

In purchasing view select purchasing group "001".

Press enter and in the next screen of accounting view 1 enter Valuation Class as e.g. 3000 and any standard price then on saving it MMR is generated.

New Material is now created in the given Plant.

Movement Type and GL Account Determination

Any report to show which account with what movement type? As we have too many movement type with different account, we want to download it from system and check.

By: Roger

In transaction OMWB (it require to input material no.), go to the simulation mode, then in menu Simulation --> Go to Report. There, you can give the plants, valuation classes and movement types and execute the report. Then you can download it to excel and analyze.

or

In the initial screen input the plant, material number and movement type and then go to simulation --> report. It will take you to simulation of automatic account assignments : Inventory Management which is independent of materials and there you can get the desired report.

Account no. with movement type

Different materials will use different accounts during movement. This is defined by the Valuation Class the material is assigned to. Also, movement definition also differs with the type of movement, i.e., a consumption on a production order has a different movement than a consumption on a sales order. These movements are therefore linked to

Transaction/Event Keys, which are the accounting reflection of the movement.

Call transaction OMWN, Account Grouping for Movement Types. This table will provide you with the Transaction/Event Keys for the movement. Withine a movement

type, these will differ based on the movement, consumption type, etc. The tables behind this are T156X and T156W.

With this Transaction Key information, read the table T030 (OBYC) using the Val Class and the Chart of Accounts to get the GL Accounts.

132 | P a g e

How to find out how G/L account is determined with respect to movement type for various material types?

G/L a/c is decided not only by Movement type, but also material master/plant/type of transaction(transaction key). Movement type in OMJJ is contains transaction key / Account modifier which is the link for GL a/c.

In material master we maintain valuation class. Hence when we do let us say GR for Purchase order(101), the G/L account is decided as below:

Let us say movement type 101 Account modifier = space Check in OBYC

As you are aware for any transaction there will be +ve and -V entry in GL a/c

Which a/c has to be -ve and which has to be + is decided by posting key depending on transaction. Hence When we do GR...Stock a/c will be +, GR/IR will be -Ve and any price difference(if price control is -S) will be posted to price difference account.

Inventory posting is done through BSX Price difference will goto PRD

GR/IR will goto WRX

In OBYC, check the transaction BSX, for a given Chart of A/c, for a given valuation modifier(it is nothing but plant grouping) and valuation class, you can see the G/L account.

This data is available in table T030

You can see the posting key for debit and cr. That means when we do 101, then Stock will be credited and that posting key is used, if you do reverse GR-102, then same stock a/c will get debited with that posting key

For the transaction PRD, you will get addition to the above, one more column General modifier, this is nothing but the account modifier in OMJJ for that movement type, i.e.

Same transaction i.e. GR, if i define a different account modifier, I can change the G/L account so that new movement type PRD (variance) can be collected at different G/L account.

133 | P a g e

Like that WRX, in which it is maintained at client level no a/c modifier, no valuation class etc...that means GR/IR account determination will not depend on movement

type/material/plant etc.

Movement Error - Posting Only Possible Between

This is a very common Goods Movement error that SAP end users will face and it is related to posting period. You can easily solve by checking your posting period configuration again.

These tcodes will help you to solve the posting period error:

OMSY OB52 MMPV

Support Ticket 1:

While doing goods receipt for order, the following error occurs, it says POSTING ONLY POSSIBLE BETWEEN 11/2012 AND 10/2012

Movement type: 101 Order: 60002765 Plant: 1000

Storage Location: 0002 Support Ticket 2:

I am trying to do GR after creating PO. It is showing an error message "posting only possible during 11/2012 and 10/2012". I went into open and close posting periods in FI (IMG) and tried opening new periods but it is still not allowing me to proceed further and is showing the same message.

Go to T.Code MMPV :

1. Enter your company code.

2. Fiscal year of the current period (in your case 2012).

3. Put the period as 12.

4. Check the radio button for check and close period.

5. Execute.

6. The system does say it is not current calendar year. (do not worry about this).

7. Hit Esc and

8. Now change the Fiscal year to 2013 and 9. Period to 1

10. Execute

Continue these steps until you reach your period and fiscal year.

134 | P a g e

Support Ticket 3:

I am facing a problem with fiscal year. When I am trying to close the periods with MMPV, it is saying that 'specify a present calendar'. It is not allowing me to receipt GR and post the invoice. And also when I am trying to change the next period

through navigation (SPRO/Logistics General/Material master/Maintain company codes for matl management) it is saying that this company code can no longer be initiated.

Our SAP was installed recently.

To maintain fiscal year

SPRO - Logistics General - Material Master - Basic Settings - Maintain Company Codes for Materials Management - Execute - Select Company Code and Define the Fiscal Year Year = 2013

P(month) = current month F/yr = 2013

M = Previous Month

ABP = Allow Back Posting (tick this to allow user to post to Previous month), DBP = Disallow back posting

SAP Split Valuation for Materials

The SAP R/3 System allows you to valuate stocks of a material either together or separately, that is, according to different valuation criteria. Split valuation is necessary if, for example:

1. Stock from in-house production has a different valuation price than externally procured stock.

2. Stock obtained from one manufacturer is valuated at a different price than stock obtained from another manufacturer.

3. Different batch stocks of a material have different valuation prices.

4. Value damaged and repair part differently from a new part.

To used split valuation, you have to activate it using 'OMW0'.

To change split material valuation once it has been set, you must