SAP MM- Master data topics with Pricing related configuration

SAP MM- Master data topics with Pricing related configuration

Before that learn some T-codes Basic, which will be very useful in the Integration:

• /n-To go back to the home screen (SAP home page)
• /nspro-to go to the screen directly without going to the home page
• /ospro-to open the new screen with the new t-code
• /i-to close the existing screen
• /nend-to close the whole SAP session with a pop-up
• /nex-to close the whole SAP without pop-up.

You can open a Maximum of 6 sessions at a time in SAP (For 1 user) to increase the efficiency for speed.

 Every organization will customize the sessions as per their users.

     There are 5 master data in the SAP:

• Material master
• vendor master
• PIR-Purchase info record.
• Source List
• Quota Arrangement

In SAP MM we can use two concepts in Material Master:

• 1. Purchasing
• 2. Inventory

In purchasing we have many things for creating/Defining/Assigning, we will start with a few creation parts:

• Creation of Material type
• Creation of Material Group
• Defining field selection
• Number ranges for the Material types
• Internal/External procurement
• Fixed/Moving average price
• Automatic account determination

Creation of Material type:

Material type is the first part you will define in the material master, where without material type you cannot maintain material group or material-1st mandatory in material master.

The material master will be used by the different departments in the whole organization like sales team, Accounting, purchasing, Costing, Quality, ware house, and Production.

By Material type, we can define the field selection and number ranges.

Creating Material type: we cannot create a new material type, where we can copy cat the existing material type and can make changes respectively and change the Material type to new material type and material description.

We need to maintain the material type starting letters to Z or Y-We cannot define other than that.

• SPRO
• Logistics general
• Material master
• Basic settings
• Material types
• Define attributes of new material types

You can directly use the T-code: OMS2

Once you are done with creating the material type, select the field selection there (The fields you selected will be displayed in the material master for that material type)

Below that you have a check button- maintain Ext material range w/o

You will be selecting this option, so that no need to maintain external number ranges, you can define the externa numbers here, so that material will be created from this sequence.

Below that you have filed the reference and S.reference field:

The field reference and s.field reference will be taken when you copy one material type to another material type and if you don’t change the field reference tab to a new material type then the field selection will not be possible for 2 different kinds.

We need to define the new material type in both fields so that we can maintain separate field settings for both.

We can change the material/Extend the material/Flag the material for deletion/Display by normal T-codes, no need for any configuration for that.

Creation of Material Group: 

The material group defines the equal attributes/group of materials with the same flavour will combine into one group and create a new material group in that.

We can create an N number of materials in one Material Group

We can extract the reports easily by using material groups.

Creation steps of material group:

• SPRO
• Logistics General
• Material master
• Settings for Key fields
• Define a new material group

T-code to enter directly-OMSF

Please select the new entries at the top of the page and select the new material group by entering the new number and mentioning the description of the material (Short text) and the long text which describes the material type.

Creation of Material: https://criccircle143.blogspot.com

Field Selection for Material Master:

In the SAP environment, every transaction and every screen will contain a few fields and a few of the screens will be mandatory to fill by the organization users as per their system, and few fields are optional and a few of them will be greyed out.

As a consultant, we need to define the fields like which fields are optional, mandatory, or grey out.

Every field contains instructions like “what it defines” and to know the instructions you need to place the cursor in the field and press F1 or Fn+F1

Select the technical information from the pop-up tab and press the icon and it will show the field reference name like NMNR_KNLPK(Eg)

Once you get the field reference name we need to find out the field reference number through SAP IMG-SPRO

• SPRO
• Logistic general
• Material master
• Field selection
• Assign fields to field selection-

Here you can place the field name you got from the above step and try to check the field reference number -which will be like a numeric digit.

Once you get the number then follow the below steps to maintain those:

• SPRO
• Logistic general
• Material master
• Field selection
• Assign fields to field selection
• Maintain field selection for Data screens

Once you get the number then go to maintain field selection and mention the number there, so that you will get all the key fields in one screen, where you need to customize everything here.

Always keep MM01, MM02, and MM03 in optional mode if you want the respective field to be one type for all material types

Or else if you require different options for different material types then mention MM01, MM02, and MM03 in optional mode and select the ROH-one option, ZROH-other optioning-other option.

So that each material type will have its respective field selection.

If you copy any material type while creating a new material type, then the system will allow only 1 type of field setting for both material types.

If you want to overcome that, then create a new entry by taking the copy option from the existing material type and creating the new material type you defined in the new material type screen.

After that change the field reference and preference in material type creation and mention the new one you defined.

So that you can define the different types of options for Copied material type.

Note: To make the below scenario work, please maintain the new material type in maintain field selection and close the SAP after going to OMS2 and changing the field reference to the new material type, then it will work.

2nd scenario: if you want to select the same table options for different things(No:52 contains purchase group and gross weight), so if you make mandatory for 1 option then automatically 2nd field will be also mandatory. To avoid this please make a new entry in the assigned field selection change the number to a new number and try the same process, now you can process the field selection.

T-code for filed selection for material master-OMS9

Number ranges for the Material types:

Each material in the material master must contain material numbers except for services, so we need to define the material number ranges as per the material type.

As we spoke in the last blog, material type controls a few functions in that material number range in one.

We have 2 types of number ranges:

• Internal
• External

Internal: where internal numbers will be given by the system, but we need to define the number range like a series of numbers eg:1000100-1000500

While arranging the number range please try to check that numbers are already defined in the system, if yes please maintain the new range.

Internal numbers should be always maintained with numbers that will not accept the alpha-num or any special char.

External number range: External numbers are two types one is you should define the number range which can be Alpha-numerical or Alphabetic.

The second one is while creating the material type we have one check option like External number W/o, if we check that option then we need to maintain the material name as per our wish, like alphanumerical or Alpha.

If we don’t check that option, then we need to define the new internal or external range for that material type.

To define the material number ranges, we need to follow the following steps:

• SPRO
• Logistics general
• Material master
• Basic settings
• Material types
• Define the number of rays for each material group

The t-code to enter directly is: TA04

Once you have entered the t-code and opened the screen, select the groups where you want to maintain a new number range for your organization for a material type.

Eg: your organization requires a number range as follows:

• Raw material -ROH= 1000100-1000200
• Semi-finished- HALB=2000100-2000300
• Finished- FERT=3000100-3000200

Create a new group(insert) and mention the group name, and below that enter the number range from -to and next to that you can see one-tab Ext, will be for explain that’s for internal or external number range.

Maintain the internal number range and save and click on the + icon on the top of the screen to maintain the external number ranges.

Maintain the external number ranges eg: A111-Z111

Once you finish with all these then you need to assign the material type to the group you have created.

Click on the material type Fn+F2 then go to the group and press Fn+F5, so that material type will move to that group.

Please save the screen and let’s test.

As we already defined the number ranges to the group then no need to maintain again.

The system will pick the numbers you mentioned for that material type.

Internal/External procurement:

Internal/external procurement defines whether the procuring of goods from vendors is allowed or not and it explains it’s a production order or external purchase order and we can control those settings.

There are 3 numbers to define the procurement type:

• Not allowed any purchase order
• Allowed but with a warning
• Allowed

We can maintain the number as per our wish 1 defines no purchase orders allowed 2 defines purchase orders are allowed but with a warning and 3 defines all purchase orders are allowed.

Fixed/Moving average price:

Every material has a certain price which will be used for certain reasons for the organisation, every material has either a fixed price or a moving price.

Fixed price: it describes the price for the material that will not be changed for a certain period like raw materials will be the same.

Moving Average price: it describes the price of the material which will be changed frequently, like semi-finished and finished products

S-defines the fixed price

V-defines moving average price

If we buy a material for which we already defined a fixed price and not moving price, in those cases if we purchase the product for 15 for which the material price is 10, the difference will be posted in the price difference account

While coming to the same material if we maintain the moving average price then the price difference will be posted in the purchase account for that particular GL account.

Output Format of Material numbers:

       The output format of material numbers describes the output of material display, like how the material should look like.

The maximum number of digits of material we can maintain is 18 and the minimum is as per the company standards.

If we want any format we can define it in the next tab as

• _____@____(9 characters)
• ____-_____(8 numbers with semicolon)

Once we maintain all these then we can see the number format of a material creation.

Leading Zeros-it will cover the remaining digits of space to the mentioned digits

For if we maintain the maximum digits as 12 and in the material range you have created the material sequence with only 8 then the remaining 4 digits will be mentioned with Zeros by the system automatically.