Material Grid In Sap (is - Afs) 46y5s

Contents Introduction .................................................................................................................................................. 2 Process Steps ................................................................................................................................................ 2 Create Characteristics ............................................................................................................................... 2 Create Master Grids .................................................................................................................................. 6 Two dimension master grid creation .................................................................................................... 7 Three dimension master grid creation ................................................................................................. 9 Assign master grid to material master .................................................................................................... 15 System Demo .............................................................................................................................................. 17 Sales order creation with two dimension grid material ......................................................................... 17 Sales order creation with three dimension grid material ....................................................................... 19 Grid reports ................................................................................................................................................. 21

Introduction Master Grid is a widely used functionality in IS - AFS (Industry Solution - Apparel and Footwear) to define allowed colours and sizes for a given model number. In the apparel and footwear business world, any given model can be available in different colours and sizes. Therefore we need to store all possible colours and sizes of that model in the SAP article master. Else we will have to create different articles (Material masters) for each colour / size combination. To avoid this, SAP AFS has provided the "Grid Functionality", where you can create one material master per model and store all colour / size combinations in the material grid attached to it. AFS is ing for three dimensional grid creations as well. (Eg: 3 dimensions can use for Bra's, as we need Band size, Cup size and the colour in the grid) Let's see how to create a material grid and attach it to a material master in AFS.

Process Steps Create Characteristics Transaction: CT04 Easy Access menu path:



Give an ID to the characteristic under field "Characteristic" and press the button . For example it can be size, colour, etc. Maintain the "Valid From" date as well. Else system will set today's date.



Set below data under "Basic data" tab o Give the description of the characteristic under field "Description" o Under "Characteristic group" field select "/AFS/SAP-D AFS Characteristics for Dimensions" o Status should be set to "Released"



Under "Data Type" field set the correct value Eg: o If you want to maintain characters -> CHAR o If you want to maintain numbers -> NUM Under "Number of chars" field maintain the allowed length of each characteristic Eg: o If you want to have 3 digit code for colour maintain 3 (RED, BLU, GRN, etc) If you want to maintain the description in many languages, you can do it under descriptions tab







Under "Values" tab, now you can maintain all relevant values (colours) under this characteristic. During material grid creation, you can select which colour is relevant for the grid (Relevant article). Therefore it is advisable to maintain all possible colours here



Save the characteristic

Same manner you can create other characteristics as well. For testing purpose I will create 3 characteristics. These can be used to demonstrate 2 dimension and 3 dimension grid creation.

Eg: o

Band Size

o

Cup Size -

Create Master Grids Transaction: J3AH Easy Access Menu:



Enter grid type as "M"

 

Enter master grid number. This you need to assign in the material master later Enter "Valid From Date"



Now you need to assign relevant characteristics to the material grid. o For 2 dimensions grids, you need to assign characteristics 1 & 2. o For 3 dimensions grids, you need to assign characteristics 1, 2 and 3.

Two dimension master grid creation  Enter characteristics 1, 2 and press Enter key



Now you can give a description for the master grid

   

Go to "Grid Values' tab to maintain relevant grid sizes for this master grid In the above picture, you can see how X & Y axis are assigned Using "F4" help, you can display all sizes in the grid Now based on the valid sizes, you have to mark "Tick" in the correct grid

Eg:

As per above, the valid sizes in this grid are; 28 A, 28 B, 29 B, 29 C, 30 B, 30 C, 30 D, 32 C, 32 D, 34 C, 34 D and 35 D 

Save the grid

Three dimension master grid creation Transaction: J3AH 

Same as above mentioned, give the grid type - M, Grid name and valid from date



Add all 3 characteristics relevant for the grid and press enter key



Give a description to the grid and go to "Grid Values' tab to specify relevant grid sizes

Here you should be able to see the axis are assigned as follows, you can change them if required;



 X - Size  Y - Cup Size  Z - Colour Now in the "Grid Values" tab, first you need to create the "Z" axis dimension (Colour). To do that, click on the button



In the pop up, specify which colour (Third dimension) you want to maintain sizes



Press Enter key. Now you should be able to see the third dimension appears in the top of the grid screen



Now you can maintain sizes (Band size and cup size) for this grid (Mark "Tick" for valid sizes)



Once all sizes are added to the given colour, you have to press the button under third dimension to add the next colour. Once added you will be able to see it in the same area as follows;



Maintain sizes for this colour as well



Same manner you can add relevant colours from the third dimension to the grid



You can switch between different third dimensions by clicking the button under third dimension



Once all dimensions are maintained, save the master grid

Now you can assign these master grids in to your article master (Material master)

Assign master grid to material master Transaction: MM01 During material master creation, we need to assign the master grid to the material master. The material has to be created under "Industry Sector" F - Apparel and Footwear" Eg:



Under "AFS Basic Data" tab, we need to assign the "Master Grid" to the material master



Same manner you can assign the three dimension grid to another material as well.

For testing purpose, I have created below 2 AFS materials. o o

AW100 (With 2 dimension grid) AW200 (With 3 dimension grid)

System Demo Sales order creation with two dimension grid material 

Select the line item and click on the button order



Now you can see only allowed values are ready for data entry. Other grid sizes are not editable as you have not marked them in the grid

o

Relevant Master grid ->

to enter customer ordered sizes in the sales



If you go in to schedule line level, you can see both grid values as follows;

Sales order creation with three dimension grid material 

Same as above enter the article and go in to the grid maintenance view by clicking



In the grid size entry screen, you should be able to see separate tabs for the third dimension. Under each tab, you can specify other 2 dimensions

button

Eg: o

With Colour - RED

o

With Colour - BLK

o

With Colour - BLU

Based on how you have maintained the master grid, the allowed sizes are displayed. 

When you go to schedule line entry level, you should be able to see all 3 dimensions

Grid reports Below grid reports are available in SAP to analyze master grids

Author: Anupa Wijesinghe E-Mail: [email protected] Website: www.learnsaptips.com View my profile in LinkedIn Follow me on Twitter

Disclaimer This article is done based on my research and readings, unless otherwise stated. The views expressed are my own and not of anyone else. Author accepts no liability for the content of the articles in this website or for the consequences of any actions taken on the basis of the information provided. Using this information is at the s own discretion and responsibility.