Ref: https://www.scribd.

com/doc/95829697/Material-Grid-in-SAP-IS-AFS

Contents

Introduction

Process steps

Create characteristics

Create master grids

Two dimension master grid creation

Three dimension master grid creation

Assign master grid to material master

System demo

Sales order creation with 2 dimensional grid material

Sales order creation with 3 dimensional grid material

Grid reports
Introduction

Master grid is widely used functionality in IS – AFS (Industry solution – Apparel & Footwear)
to define allowed colours and sizes for a given model number. In the apparel & 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 master) 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 supporting for three dimensional grid creation as well. (Eg. 3 dimensions can be use for Bra’s,
as we need Band size, Cup size, and the colour in the grid).

Let us 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: SAP Menu > Cross application components > Classification system > Master
data > CT04 – Characteristics

1st dimension: COLOUR

 Given an ID to the characteristics under field “Characteristic” and press button “Note”. For
example it can be size, colour etc. Maintain the “Valid from” date as well else system will set
today’s date.

Values in the screen:

 Characteristic ZAW_CLR
 Valid from 22.05.2019

 Set below data under “Basic Data” tab

 Give the description of the characteristic under field “Description”
 Under “Characteristic group” field select “/AFS/SAP-D” : AFS characteristics for dimension
 Status should be set to “Released”

Values in the screen: tab “Basic data”

 Description AW Colour
 Chars group /AFS/SAP-D AFS characteristics for …
 Stats 1 Released

 Under “Data Type” field set the correct value

e.g.
 If you want to maintain character -> CHAR
  If you want to maintain number -> NUM

 Under “Number of Chars” field maintain the allowed length of each characteristic
 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 description
tab.
Values in the screen: Description tab
 Language : EN, Description AW colour

 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). Therefor it is advisable to maintain all possible colours here
Values in the screen: Value tab
 Char value : RED, Description : Red
 Char value : BLU, Description : Blue
 Char value : GRN, Description : Green
 Char value : YLW, Description : Yellow
 Char value : PUR, Description : Purple
 Char value : BLK, Description : Black

Save the characteristics

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.

2nd dimension: BAND SIZE

 Given an ID to the characteristics under field “Characteristic” and press button “Note”. For
example it can be size, colour etc. Maintain the “Valid from” date as well else system will set
today’s date.

Values in the screen:

 Characteristic ZAW_SIZE
 Valid from 22.05.2019

 Set below data under “Basic Data” tab

 Give the description of the characteristic under field “Description”
 Under “Characteristic group” field select “/AFS/SAP-D” : AFS characteristics for dimension
 Status should be set to “Released”

Values in the screen: tab “Basic data”

 Description AW Size
  Chars group /AFS/SAP-D AFS characteristics for …
 Stats 1 Released

 Under “Data Type” field set the correct value

e.g.
 If you want to maintain character -> CHAR
 If you want to maintain number -> NUM

 Under “Number of Chars” field maintain the allowed length of each characteristic
 If you want to have 3 digit code for Band size

 If you want to maintain the description in many languages, you can do it under description
tab.
Values in the screen: Description tab
 Language : EN, Description AW Band size

 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). Therefor it is advisable to maintain all possible colours here
Values in the screen: Value tab
 Char value : 28, Description : 28
 Char value : 29, Description : 29
 Char value : 30, Description : 30
 Char value : 32, Description : 32
 Char value : 34, Description : 34
 Char value : 36, Description : 36

Save the characteristics

3rd dimension: CUP SIZE

 Given an ID to the characteristics under field “Characteristic” and press button “Note”. For
example it can be size, colour etc. Maintain the “Valid from” date as well else system will set
today’s date.

Values in the screen:

 Characteristic ZAW_CUP
 Valid from 22.05.2019

 Set below data under “Basic Data” tab

 Give the description of the characteristic under field “Description”
 Under “Characteristic group” field select “/AFS/SAP-D” : AFS characteristics for dimension
 Status should be set to “Released”
 Values in the screen: tab “Basic data”

 Description AW Cup
 Chars group /AFS/SAP-D AFS characteristics for …
 Stats 1 Released

 Under “Data Type” field set the correct value

e.g.
 If you want to maintain character -> CHAR
 If you want to maintain number -> NUM

 Under “Number of Chars” field maintain the allowed length of each characteristic
 If you want to have 2 digit code for Cup size

 If you want to maintain the description in many languages, you can do it under description
tab.
Values in the screen: Description tab
 Language : EN, Description AW Cup size

 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). Therefor it is advisable to maintain all possible colours here
Values in the screen: Value tab
 Char value : A, Description : A
 Char value : B, Description : B
 Char value : C, Description : C
 Char value : D, Description : D

Save the characteristics

CREATE MASTER GRID

Transaction: J3AH

Path: Easy access > SAP Menu > Logistics > Sales & Distribution > AFS master data > Material grid >
J3AH – Create

 Enter grid type as “M”

 Enter master grid number. This you need to assign in the material master later
 Enter “Valid from date”

Screen value:
Material grid type M (Master grid)
 Material Grid number ZAW_BRA_GRID1
Valid from date 22.05.2019
 Now, you need to assign relevant characteristics to the material grid
 For 2 dimension grid, you need to assign characteristics 1 & 2
 For 3 dimension grid, you need to assign characteristics 1, 2 & 3

Two dimension master grid creation

 Enter characteristics 1, 2 and press ENTER key

Screen value:
Material grid type M
Material grid number ZAW_BRA_GRID1
Valid from date 22.05.2019

Characteristic 1 ZAW_SIZE
Characteristic 2 ZAW_CUP

 Now, you can give a description for the master grid

AFS create material grid – Basic and dimension data

Screen value: tab “Attributes”

Material grid type M

Material grid number ZAW_BRA_GRID1

Tab: Dimension

1st characteristic : ZAW_SIZE, Sort 1, Axis X, Length 3

2nd characteristic : ZAW_CUP, Sort 2, Axis Y, Length 2

CREATE DIMENSION VALUES

 Goto “grid values” tab to maintain relevant grid sizes for the 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

Tab “Grid values”

Screen values:

Material grid type M

Material grid number ZAW_BRA_GRID1

Valid grid values:

1st ZAW_SIZE (AW Size)

2nd ZAW_CUP (AW cup size)

 Pl. tick mark under cell: 28A, 28B, 29B, 29C, 30B, 30C, 30D, 32C, 32D, 34C, 34D, 36D

Save the grid

Three Dimension master grid creation

Transaction: J3AH

 Same as above (two dimension), give the grid type M, Grid name and valid from date
Screen values:
 Material grid type M
 Material grid number ZAW_BRA_GRID2
 Valid from date 22.05.2019
 Add all 3 characteristics relevant for the grid and press enter key
Screen value:
 Material grid type M
 Material grid number ZAW_BRA_GRID2
 Valid from date 22.05.2019
Dimensions tab
 Characteristic 1 ZAW_SIZE
 Characteristic 2 ZAW_CUP
 Characteristic 3 ZAW_CLR
 Give a description to the grid and go to “Grid Values” tab to specify relevant grid sizes

Tab: Attributes

Screen value:

 Material grid type M

 Valid from date 22.05.2019
 Material grid number ZAW_BRA_GRID2

Description AW BRA Grid (Size / Cup / Colour)

Further tab: Dimensions

 1st characteristic ZAW_SIZE sort 1 Axis X Length 3

 2nd characteristic ZAW_CUP sort 2 Axis Y Length 2
 3rd characteristic ZAW_CLR sort 3 Axis Z length 3

CREATE DIMENSION VALUES

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 tab “Grid Values”, first you need to create “Z” axis dimension (Colour). To do that,
click on button “Note”

Tab: Grid Values

Screen values:

Material grid type M

Valid from 22.05.2019

Material grid number ZAW_BRA_GRID2

Description AW Bra Grid (Size / Cup / Colour)

3: (ZAW_CLR) AW colour

Dimension value RED (in the POPUP, 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.

Further tab: Valid grid values (for dimension 2 & dimension 1)

2: (ZAW_CUP) AW cup size

1: (ZAW_SIZE) AW Size

Now you can maintain sizes (Band size & Cup size) for this grid (Mark “Tick” for valid sizes)

A28, B28, C28, D28, B29, C29, D29, C30, D30, C32, D32, D34, D35

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

3: (ZAW_CLR) AW colour

Dimension value : POP down values & selected values viz. RED, BLK,…

 Maintain sizes for this colour as well

A28, B28, C28, B29, C29, D29, C30, D30, C32, A34, B34, C34, D34, A35, C35, D35

 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 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 material master. The material
has to be created under “Industry Sector” F – Apparel and Footwear

Screen variables:

Material AW100

Industry sector F Apparel & Footwear

Material type FERT Finished product

 Under “AFS Basic Data” tab, we need to assign the “Master Grid” to the material master

Screen variable: Tab “AFS Basic Data”

Master Grid ZAW_BRA_GRID1

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

For testing purpose, created below 2 AFS materials:

 AW100 (with 2 dimension grid)

 AW200 (with 3 dimension grid)

SYSTEM DEMO
Sales Order creation with two dimensional grid material
 Select the line item and click on the button (enter line) to enter customer ordered sizes in the
sales order

Screen variables:

 Sold-to party A300

 Ship-to party A300
 Purchase order Master Grid Test
 Delivery date 01.06.2019

Under line item:

 Item: 00010
 Material: AW100
 Plant: A300
 UOM: EA
 Required delivery date: 01.06.2019
 Short text: AW100 (2D Grid)

 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

Y: (ZAW_CUP) AW Cup size

X: (ZAW_SIZE) AW Size

Line item entry against the grid: relevant master grid

 A28 – enter (10)

 B28 – enter (10)
 B30 – enter (10)
 C34 – enter (10)
 D35 – enter (10)

 If you go into schedule line level, you can see both grid values as follows:
 Tab: AFS Item overview

 Item: 00010
 Material: AW100
 Plant: A300
 Quantity: 50
 UOM: EA
 Required delivery date: 01.06.2019
 Short text: AW100 (2D Grid)

Similarly, Sales Order creation with three dimension grid material

 Same as above enter the article and go in to the grid maintenance by clicking line button

Screen variables:

 Sold-to party A300

 Ship-to party A300
 Purchase order Master Grid Test
 Net 5000
 Delivery date 01.06.2019

Under line item:

 Item: 00020
 Material: AW200
 Plant: A300
 UOM: EA
 Required delivery date: 01.06.2019
 Short text AW200 (3D Grid)

 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 dimension

Z: (ZAW_CLR) AW colour

Y: (ZAW_CUP) AW Cup size

X: (ZAW_SIZE) AW Size

Line item entry against the grid: relevant master grid – with colour RED

 A28 – enter (10)

 B28 – enter (10)
 C29 – enter (10)
 C32 – enter (10)
 D35 – enter (10)

Line item entry against the grid: relevant master grid – with colour BLK

 A34 – enter (10)

 B35 – enter (10)
 B28 – enter (10)
 C30 – enter (10)
 Line item entry against the grid: relevant master grid – with colour BLU

 A28 – enter (10)

 D29 – enter (10)
 B32 – enter (10)
 C35 – enter (10)

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

Tab: AFS Item overview

 Item: 00010
 Material: AW100
 Plant: A300
 Quantity: 130
 UOM: EA
 Required delivery date: 01.06.2019
 Short text: AW200 (3D Grid)

GRID Report
Below grid reports are available in SAP to analyse master grids

SAP Menu > Logistics > Sales & Distribution > AFS master data > Grid reports

 /AFS/SR_J_3AGRD0 – where-used list for Materials Grids

 /AFS/SR_J_3AGRD1 – Associated material grid
 /AFS/INFGRID3 – Changes to material grids
 /AFS/PPBW_EF_DISPLAY – AFS BW: Text characteristics value elementary fields
 /AFS/PPBW_EF_FUELLEN – AFS BW: Full texts for elementary fields
Ref: https://wiki.scn.sap.com/wiki/display/Retail/AFS+Tabs+in+Material+Master

AFS Tabs in Material Master

There are five AFS specific tabs in the material master 6.4 as below:

1> AFS Basic Data Tab: this tab has details pertaining to the Master Grid that is created for the
material. Assign the Master Grid that was created with the characteristics of the material in
this field. Assign the MM MM Grid Det Proc and SD Grid Det Proc and activate the AFS status.
2> AFS Sales Data tab: The second AFS specific tab in the Material Master is the AFS Sales data,
here you can maintain SKU level pricing, status packing data and Target group.
3> AFS MRP tab: The third AFS specific tab in the Material Master is AFS MRP.
This has further 4 tabs viz.: General Control, Presizing, SKU data, Discontinuation control
within it. You can activate Batch management and the MRP indicator for the material here.
4> AFS WM tab: The fourth AFS specific tab in the Material master is AFS WS, under this tab you
have the flexibility to maintain the WM related data at the SKU level.
5> AFS valuation: The fifth AFS specific tab in the Material master is the AFS valuation tab, where
the valuation for each variant of the material can be maintained.
SAMPLE FLOW CHART TO PREPARE FOR EVERY PROCESS
Ref:https://help.sap.com/doc/saphelp_afs60/6.0/en-
US/23/967244d32f11d2aca80000e829fbfe/content.htm?no_cache=true

AFS MRP List

Use
You use the display of the AFS MRP list to evaluate the result of the result of the latest planning run.
AFS has developed its own function for this. This function displays the result of the latest planning run
taking the AFS – specific data into account (grid value and categories). The objective of the AFS MRP
is to determine if there is a requirements shortage for an AFS material. The AFS MRP list displays the
requirements shortage at SKU level with any corresponding MRP – relevant information.

Functions
You can select which data should be displayed in the MRP list, so that the AFS – specific data (grid
values and categories) is easier and clearer to read (see Single – Item Planning). You can also include
or exclude certain MRP statues as well as certain stock and requirement number in the view.

The AFS MRP list contains the following data for each SKU:

 Stock / requirements category

 Grid values
 Quantity
 Requirements date
 Availability date
 Requirement type, such as planned independent requirement
 Stock type, such as production order
 Requirement number, such as the batch number or the number of the planned order
 Indicator showing whether a certain stock element is fixed
 Item number in the corresponding document
 Storage location for batches
 Number of the exception message
 Additional information, such as the status of the production order or the end of the SKU
horizon

The MRP statues help you better understand the stock / requirement situation after the most recent
planning run per SKU of the planned AFS material (see Importance of the AFS MRP status).

The evaluation of the exception messages helps to indicate exceptional situations per SKU, such as
absence of a BOM or Routing.

To optimize the production cycle, you can form SKU groups using the AFS lot-sizing procedures during
the planning (compare Lot Size Overview). That means that you can combine several SKUs of the
planned AFS material to an SKU group during the AFS MRP run. Only a procurement proposal is then
created for the grouped SKUs, for example a planned order number (material master). You can also
create a procurement proposal for each SKU. For example, you can create a separate planned order
number (material master) for each SKU. The AFS MRP list displays the result according to the settings
you have made.
A further function especially developed for AFS MRP is the technical log (J_3AMPRO). Using this log
you can make an error analysis of the AFS MRP run in the background, considering the MRP module
((AFS customizing).