Assortment

Objective

After completing this lesson, you will be able to analyze the terms assortment and listing, and their use in SAP Retail

Assortment Management and Maintenance

The assortment is part of the corporate merchandise offering that is assigned to a specified target group for a particular validity period.

An assortment determines if a store, a distribution center or a customer can receive certain articles at a certain time. The assortment can therefore be used to check purchase orders and sales orders.

By assigning articles to assortments, you determine which assortments and, therefore, which articles a store can buy and sell. A site cannot buy or sell articles that are not included in one of its assortments.

In assortment management, you determine for each site and each article respectively which site may procure an article in which time period. This is also called listing.

The assortment is an SAP Retail object, to which articles are assigned, that is listed, for a particular period of time.

There are two kinds of assortments:

  • Local Assortments

    These are termed category A for stores and category B for distribution centers. The technical key of these local assortments is the same as the customer number of the respective site. When you create a site (in other words, a store or distribution center), the system automatically creates a local assortment and then assigns it to the site. This local assortment is site-specific and cannot be assigned to another site. Each site has one local assortment.

  • General Assortments

    General assortments are category C assortments. They can be assigned to any number of (SD) customers, and every customer can be assigned several general assortments. If you have set the indicator for multiple assignments in Customizing, you can also use assortments of this category to assign stores and distribution centers.

Note

Advantage of using general assortments for sites: Assortments can be defined, which are valid for groups of sites, for example, to reflect regional or seasonal assortments. Moreover, when new sites are created, they only have to be assigned to the relevant assortments in order to define their range of available products. Furthermore, as a side-effect, the number of articles listing conditions in the system can be reduced a lot compared to using local assortments only.

In Customizing (IMG:Logistics-GeneralBasic Data RetailGeneral Control, Retail Master Data) you can determine whether the multiple assignment (n:m) of assortments to sites should be possible, or whether assortments should be limited to a 1:1 combination of the site and the assortment. If you activate multiple assignment in Customizing, a site can have different general assortments and a general assortment can be assigned to different sites.

Nevertheless, when a site master record is created, the system always automatically generates a site-specific local assortment.

  • In the case of 1:1 assignment, every site has exactly one local assortment. No other assortment can be assigned to this site.

  • In the case of n:m assignment, every site still has a local assortment, but there is no limit to the number of general assortments that can be assigned to this site.

Hint

Converting an existing 1:1 assignment to multiple assignment

In earlier releases of the SAP Retail system, only a 1:1 assignment of assortments to sites was possible. Accordingly, every store could only have one assortment, and a certain assortment could only ever be assigned to one store. Now you can choose between the old 1:1 assignment and the new n:m assignment. This less restrictive assignment means that you have the option of assigning previously created assortments to an existing store (for example, when new stores are opened) , and you can more precisely adjust the goods on offer in a store by assigning one or more general assortments to the store. You should only decide on single assignment (1:1) or multiple assignments (n:m) after careful consideration. This is particularly important because changing the assignment method affects all aspects of the listing process.

You can find a detailed description of how to convert the 1:1 assignment to multiple assignments at http://help.sap.com under the menu option Assortment Management and Listing in the SAP online documentation for SAP Retail.

Assortment Management

The assortment management demands of retailers differ greatly. Some require identical assortments in all areas, while others demand assortments unique (for example) to each store. Assortment Management takes account of these differences and offers a variety of tools to allow any combination of article assortments as well as for the structuring of article assortments for wholesale.

The main tasks of assortment management for retail sites or customers are:

  • Determining articles that can be sold at a point of sale in a store

  • Adding these articles to the article assortment that is assigned to this store's distribution center.

  • Determining the distribution centers from which articles are to be distributed, when stores are to be supplied from the warehouse

  • Determining the stores in which the article can be sold at the point of sale

  • Determining the articles that should be included in the customer assortment

In assortment management with the general assortment you can map areas (for example, beverages, sweets) that may reflect the departments in the stores. For each of these areas, you create one or more general assortments with different article assignments.

Then you assign the relevant general assortments to the stores.

An assortment is an object with article assignments valid for a particular validity period each. This assignment results in listing conditions, which serve as the basis for various evaluations.

Once an assortment user is assigned to an assortment, articles for the assortment user in question can be used in various business functions. The most important assortment user in Retail is the retail site. The assortments of a site include all the articles that are relevant in its business activities.

In many retail companies, the assortments, for example, for a distribution chain or for a particular region, are generally identical or are only slightly different. For this reason, you should only define a few general assortments and then assign them to a group of assortment users.

Depending on how the indicator for the multiple assignment of assortments to sites is set in Customizing, you have the following options:

  • If the indicator is set, stores, distribution centers or customers can be used as assortment users.

  • If the indicator is not set, only customers can be used as assortment users.

You can significantly reduce the number of listing condition records on the database by using multiple assignments, as a general assortment can sometimes be assigned to a large number of sites. This is due to the fact that articles are listed for assortments and not for sites, and therefore, the listing conditions created are valid for all the sites that are assigned to the assortment. Unlike local assortments - which you cannot change using the assortment maintenance and which you therefore cannot assign to other customers or sites - in general assortments (assortment category C) you can assign an unlimited number of sites or customers, provided that the multiple assignment (n:m assignment) of sites to assortments is activated in Customizing.

Exclusion modules can be used to define exceptions for assortments. This means that individual articles are explicitly excluded from being listed in an assortment.

In addition to the individual assignment of a general assortment to an assortment user, you also have the option of defining reference sites for assortment management, and assigning them sites in a 1:m assignment.

The main advantage of the reference site is the one-time assignment of general assortments. All dependent sites (sites that are assigned to the reference site) automatically adopt all the assortments from the reference site. Via this pointer function, changes made to general assortments, and changes relating to assignments of general assortments to the reference site, are automatically valid for the assigned sites.

General assortments can only be assigned by means of reference sites if multiple assignment (n:m) is set in Customizing.

If you delete the assignment of a site to a reference site, all the assignments of the reference site's assortments to the site are also deleted.

In our example, we assume that the three stores A, B and C in the north should have the same assortment assignments. Thus, these stores are assigned to the same reference site (north). The reference site in turn is assigned to the relevant assortments. Any changes to the general assortment affect all assortment users (i.e. the reference site along with its assigned stores). The same logic applies for the stores X and Y in the south: They are grouped under their reference site (south), which is then assigned to the assortments relevant for the southern stores. The reference site concept makes it easy to assign the right assortments to a brand new store: The new store just has to be assigned to the relevant reference site. With that, all assignments to the relevant general assortments are taken care of for the new store.

Every reference site can have several assortments (n:m).

Every store can be assigned to only one reference site for the assortment management (1:m).

A site cannot be assigned to an assortment twice (directly and via the reference site). However, the site can be assigned to an assortment directly and to another assortment via the reference site.

Assortment Maintenance

In the assortment maintenance, you can maintain general assortments, and assign assortment users to general assortments.

In the assortment maintenance, you can assign merchandise categories (and assortment grades, if applicable), a layout or layout module (depends on the assortment type control in customizing), and an article hierarchy (with the corresponding hierarchy node) to the assortment.

Regarding the assignment of assortment users: Customers can only be assigned in the 'Create/Change Assortments' transaction, while sites can be assigned both in the transaction for creating or changing the assortment, and in the tool for assigning assortment users:

A user-friendly assortment assignment tool is available for assigning sites to general assortments. This tool allows you to sort the displayed sites, for example, by region, or to select sites that are not yet assigned to the selected assortments, or new sites that have been created. The system displays two tree structures: a list of the selected general assortments and their already assigned sites on the left, and a list of sites for which assignments are still possible on the right. You drag and drop to assign the selected sites to the desired assortment.

You can also create, change, or display general assortments from that assortment assignment tool, and you can also display which articles are currently listed for the selected assortment.

Display the Control Data for Assortments and a General Assortment

Briefly show the relevant Customizing Setting for multiple assignment:

Steps

  1. IMG:Logistics — GeneralBasic Data RetailGeneral Control, Retail Master Data

    Subscreen: Control, assortments; Flag: Multiple Assignment Is Active

  2. FromExercise — Create General Assortments, demo

    Task — Create a new General Assortment and Assign Assortment Users, steps 1 and 2 (create new assortments)

Assortment Modules

An assortment can consist of one or more assortment modules. An assortment module is a group of articles, which are assigned to the module with their individual validity period. Examples are Household Cleaners or Ladies' Blouses. Assortment modules are used to structure the assortments, as one assortment could have many article assignments.

Assortment modules can be created manually, or automatically from the applications (article maintenance, promotion, etc.). To minimize the time and maintenance effort, modules should be created automatically rather than manually.

A profile module is created automatically using rule-based listing, for example during the article maintenance, for each assortment and merchandise category.

You generate shelf modules during the maintenance of layout modules that are assigned to the assortments.

A promotion module contains the articles that are to be dealt with together in a promotion or a promotion theme.

A standard module contains any articles from any merchandise categories. It contains the regular long-term assortment and is created manually.

You can use an exclusion module to exclude articles from the existing assortment for a certain period of time.

Rack jobber modules are modules for which vendors deliver and present articles in stores themselves. A rack jobber module can only be assigned to exactly one vendor. An article that is listed in a rack jobber module cannot be listed in any other module.

In Sales and Distribution, you use assortment modules to maintain a number of articles for value contracts. Like standard modules, you can also use these modules for assortment functions. You use a different transaction for creating them in Sales and Distribution (WSV2).

Assortments for New Sites

If you open new sites and want to create assortments for them in a very short time, you can select one of the following options:

  • Setup based on Article

  • Assortment Copy

  • Assign the new site to the general assortments (directly or via a reference site)

However, you must check whether or not the multiple assignment is active. The assortment copy is only possible if the indicator is not set, while the site can only be assigned to general assortments when multiple assignment is active.

1. Setup based on Article

You can organize the assortment of the new site by listing the articles of the merchandise categories that are already assigned to the assortment. To do so, you execute transaction WSM3 (Mass Listing With Selection Via Material and Assortment).

You can define one or more merchandise categories and add them to the target assortment. The system checks the existing listing conditions for every combination of articles and assortments. If an article is not in the target assortment, the article is listed there.

The transaction WSM3 can be used for listing articles in both local and general assortments.

2. Assortment Copy

If the indicator for the multiple assignment of assortments to sites isnot set in Customizing, you can simply copy the contents (the assigned articles) of a whole assortment to the local assortment of the new site. This means if the new assortment is to contain the same articles as an assortment that already exists, you only need to copy the listing conditions from the source assortment.

The source assortment can consist of one or more assortment modules. When you copy an assortment into an other assortment, you also copy these assignments. If the source assortment consists of modules A, B and C, the target assortment has the same modules. You can execute the copy program for assortments in dialog mode (transaction WSK1). In both cases, the system checks in advance that there are no problems that would prevent listing.

3. Assignment of General Assortments/Reference Site

If the indicator for the multiple assignments of assortments and sites is set in Customizing, you can assign the new site to existing general assortments. This means that all articles contained in these assortments are also valid for the new site.

In addition to the individual, direct assignment of an assortment user to a general assortment, you also have the option of assigning the new site to an assortment management reference site. This means that the new site has the same assignments to assortments as the reference site. Please note: If a site is already assigned to assortments, it can only be assigned to a reference site if that reference site does not have the same assortment assignments. This is because a site can only be assigned once to an assortment, i.e. not directly and through it’s reference site. The reference site is assigned in transaction REFSITE.

Further Maintenance for the Functional Use of New Sites

To operationally use a new store that has just been created, not only must assortments be assigned to this store, but the right purchasing and logistics data also have to be maintained for this store. To proceed with this as efficiently as possible, you can arrange similar stores into groups and maintain data for a whole group at once, instead of for every individual store.

These store groupings can be formed on the basis of different criteria, for example according to geographical location, size and demographic aspects. Some retail companies use the same store groupings for all functional areas, while other retail companies use different store groupings for different functional areas. Large and rapidly expanding retail companies may open a new store every other day or even more often. It is critical that such store openings run smoothly, as this has a significant influence on the mark that a retail chain leaves in a new market. Therefore, simple and efficient data maintenance is very important in this process, both when setting up the master data of the new store and when processing the first purchase orders.

You can use store groupings for the maintenance of purchasing data (vendor/site data, purchasing info records and purchase conditions), assortment data, and logistics & replenishment data. In the system, these store groupings are defined by assigning stores to the relevant reference site of these functional areas (assortment, purchasing, logistics & replenishment.

After you used reference stores to set up the relevant (article listing/logistics and purchasing) master data for a new store, and after having determined a multiplier for the consumption data, you can carry out the forecast for the new store and then start a replenishment run to automatically generate the first store orders.

The reference stores for assortment management, purchasing, and logistics data are defined and assigned in transaction REFSITE.

Reference Site for Purchasing Data

You can maintain vendor and site data, purchasing info records and purchasing conditions for a purchasing reference site. Such a reference site represents all sites that are assigned to it. The data is only stored at reference site level and is always used if there is no specific corresponding data at store level.

Purchasing reference sites are defined at purchasing organization level.

As an extension of the supply source determination, the vendor and site data can also be used to limit vendors to only the assigned sites. If a vendor is assigned to a reference site, this vendor supplies all sites that are assigned to the reference site.

Reference Site for Logistics and Replenishment Data

You can maintain logistics and replenishment data for all stores (general reference store) or for all stores of a certain distribution chain (reference store at distribution chain level). You can now also use transaction REFSITE to create a store grouping according to customer-specific criteria. Since the replenishment and logistics data usually do not differ in different distribution chains, but rather between groups of sites (that are defined by common attributes such as size, geographical location, and so on), you could define logistics and replenishment reference sites for mass maintenance: There is a separate mass maintenance tool that can be used to maintain logistics and replenishment data at this level (transaction: MASS_MARC).

The section Create Assortments for New Sites already dealt with the various ways you can create assortments for new stores.

Maintain a Reference Site

Exercise — Create General AssortmentsFrom , demo

Task — Create a new General Assortment and Assign Assortment Users, steps 3 and 4 (maintain reference site and assign to assortment).

Task — Assign Articles to the Assortment

Task — (optional): Create a Purchase Order

Steps

  1. From Exercise — Create General Assortments the participants perform

    Task — Create a new General Assortment and Assign Assortment Users
    Task — Assign Articles to the Assortment
    Task — (optional): Create a Purchase Order

Subsequent Listing of Articles

Under certain circumstances, in the case of a shipment from a vendor, or a stock transfer, articles may be delivered to a site in which they are not listed. A promotion article may be listed in a distribution center, which then delivers the article to stores for which this article is not listed. Or a vendor sends a new article instead of an old article that is no longer carried. The site may accept the new article, even if it is not currently contained in the assortment of the site.

For each site you can specify whether the goods receipt is allowed for deliveries of this kind. If the goods receipt is allowed, the system automatically creates the corresponding article master data and listing conditions ("Subsequent Listing"), so that the goods receipt can be posted for this delivery. If subsequent listing is not allowed, the delivery cannot be accepted and must be returned to the sender.

To make subsequent listing possible, you must define under what circumstances subsequent listing should be carried out, by making the relevant settings in the site master data.

Introducing SAP Fiori

SAP Fiori is SAP's central, role-specific and intuitive user experience (UX), which runs on any device. You can use various user interface (UI) technologies such as the SAPUI5 framework, UI5 Web Components, or the mobile iOS and Android SDKs to build SAP Fiori apps. As the SAP Fiori UX focuses on the individual user roles, new SAP Fiori apps are specifically created for individual roles. For example, in Retail, there are apps for store associates, and for store managers.

The SAP Fiori Launchpad (FLP) is a shell that hosts SAP Fiori apps, and it is the single point of entry for a user to access the assigned applications.

Note

You can find further information about this topic in the training course S4IRT: Overview of Functions in SAP S/4HANA Retail.

New Assortment Module Management

You can also manage assortments and list articles by using the new assortment module management function.

The app Manage Assortment Modules (F4892) allows you to create assortment modules and assortment module versions, to assign articles to the versions, and to assign stores (assortment users) to assortment modules.

The Assign Store to Assortment Module (F4893) app allows you to copy the assortment of an existing store to a target store, to select a store, and to display the existing assortment module assignments as well as to add further assortment modules.

The Assign Product to Assortment Modules (F4894) app allows to connect articles and assortment modules. As articles and assortment users are assigned to assortment modules with individual periods, the listing conditions are created for the intersections of both periods.

You use the app Assign Products to Distribution Centers (F4543) to list articles for your distribution centers (DC), that is, for the local assortments of your DCs. As for the stores, also for each DC, the system automatically creates a local assortment in the background when the DC is fully maintained, that is, including the business partner (customer data).

Note

Note: You can find further information about this topic in the learning journey Exploring SAP S/4HANA Cloud Public Edition Retail at: https://learning.sap.com/learning-journeys/exploring-sap-s-4hana-cloud-public-edition-for-retail

Create General Assortments

Business Example

In a workshop, you and your colleagues have developed a concept for future assortment management. You have defined the different product ranges such as fresh food, dairy, and so on. Now you want to define two new general assortments for each of these article areas, large (L) and small (S). For each store, depending on the size, you decide, if the large or small general assortment will be assigned.

To make this assignment process more efficient, you group the stores using assortment management reference sites.

Task 1: Create a new General Assortment and Assign Assortment Users

You start by implementing your concept in the Food area.

Steps

  1. Create two new assortments FOOD-L## by copying the existing assortment FOOD-L, and FOOD-S##, by coping FOOD-S. Confirm the info popup. Do not copy the assortment users. Make the following settings:

    Field name or data type

    FOOD-S##FOOD-L##
    Reference assortmentFOOD-SFOOD-L
    Assortment TypeBASIBASI
    Basic Data  
    Assortment DescriptionFood, Small Assortment ##Food, Large Assortment ##
    Control Data  
    Sales OrganizationRG10RG10
    Distribution ChannelR1R1
    Mat. Groups.  
     Check: 7 merchandise categories should be assigned. Do not make any changes.There should be more than 7 merchandise categories.

    Note

    Add merchandise category RS12310 Chicken.
    Assortment User  
    CustomerPlantR1##R2##
    1. Retailing: Master DataAssortment/ListingAssortmentGeneral AssortmentCreate

      Make your settings as specified in the task. Confirm the first upcoming message Creating Material Segments with Create Job Without Parameter Control. Then choose Immediate and Save. Don’t leave the transaction. Choose AssortmentDisplay.

  2. What is the assortment category of the two new assortments?

    _________________________________________________________

    1. C - Customer assignment category

  3. In order to efficiently assign further stores to your new large assortment FOOD-L##, you define store RS## as an assortment management reference site for your large stores. Assign stores R4## and R5## to this reference site.

    1. Retailing: Master DataAssortment/ListingMass MaintenanceReference Plants Management.

      Choose Creation of a New Reference Site, and select Group Type 01 Assortment. Enter RS## as your reference site.

      From the Plants to be Assigned area, drag and drop R4##, then R5## to the List of Assigned Plants for Assortment Reference Plant RS## area.

      Save your entries and choose Update Process in the popup. Also confirm the info-popup (Continue) .

  4. Now use the Assign Assortment User tool to add the newly defined reference site RS## to your assortment FOOD-L##. In the application, choose the Display Options for Plants, and select 2 Reference Plant for the Grouping of Plants. Drag and drop RS## to your assortment.

    Save your entries.

    1. Retailing: Master DataAssortment/ListingAssortmentGeneral AssortmentAssign Assortment User

      In the Selection area, enter your assortment, then Execute. Make your settings as specified in the task. In the pop-up, choose Create job without parameter control and then immediately.

Task 2: Assign Articles to the Assortment

Once you have defined the assortments with the relevant merchandise categories and assortment users, assign articles to the assortment. Use the mass maintenance function Setup Based on Article to do this.

Steps

  1. List article R1TA60 in merchandise categories RS12110 to RS12320 in the assortments FOOD-L## and FOOD-S## with listing procedure B1. Note that article R1TA60 is also listed in the supplying sites of the stores. However, local assortments should not be selected for listing.

    Check the results for merchandise category RS12310: Which assortment has listing conditions for article R1TA60 and why?

    ___________________________________________________

    1. Retailing: Master DataAssortment/ListingMass MaintenanceAssortmentSetup Based on Article

      Field name or data type

      Values
      AssortmentFood-L## and Food-S##
      MaterialR1TA60
      Material GroupRS12110 to RS12320
      Listing ProceduresB1
      Also List Supplying PlantX
      Issue LogX
      List Local Assortments Also<blank>
      Execute the listing. The following result is displayed for article R1TA60 merchandise category RS12310:

      AssortmentMaterialMatl GroupMessage Text
      FOOD-S##R1TA60RS12310Rules Do Not Allow Listing
      FOOD-L## now carries article R1TA60 of merchandise category RS12310, because the merchandise category was assigned to this large assortment, but not to FOOD-S##. Listing Procedure B1 checks the merchandise category assignments.

  2. Now you want to see for which assortment users the new article listings are valid. You choose article R1TA60 as an example to check this. The Tree Display of Listing Conditions report in the evaluations for the article provides this information.

    Then stay in this view for the next step.

    1. Retailing: Master DataAssortment/ListingEvaluationsFor MaterialTree Display of Listing Conditions

      Select Material R1TA60.

      You’ll see that all the stores, which are assortment users of the FOOD-L## assortments created during the exercise, are displayed, as well as the relevant supplying sites. The stores use the listing condition created for the relevant FOOD-L## assortment: Also note the assortment module number, which was generated for each combination of assortment and merchandise category.

      Stay in this view to continue with the next step.

  3. Check the assortment module. To do so, copy (Ctrl + C) the module number in the previous report (step 2), so you can paste (Ctrl + V) it in the Assortment Module Display.

    Which article is displayed? _______________________________________________________

    What is the module type? __________________________ Also check the module type description.

    1. Copy the assortment module number, then choose this menu path: Retailing: Master DataAssortment/ListingAssortmentModuleDisplay

      Paste the module number and Execute.

      The material is R1TA60.

      You can find the Module type above the module’s validity period in the module’s header. The module type is 4. Use the F4 Help to find the description: Listing profile material group and assortment. Select line item R1TA60 and choose Extras → Information → Material for assortment: Here, you can see the assortment, for which your assortment module was generated.

Task 3: (optional): Create a Purchase Order

You now want to check the result of your assortment management activities by creating a purchase order: Only listed articles can be ordered.

Steps

  1. You want to test if you can order article R1TA60 for stores R4## and R3##. Create your purchase order for vendor RS1301.

    Make the following entries in the item table:

    Field name or data type

    Values
    MaterialR1TA60
    PO Quantity / Order Unit1 CSE
    PlantR4##
    Storage Location0001

    Now create a second order item with the same data, except for the recipient: Instead of store R4##, now enter R3##. Press enter. What happens?

    _____________________________________________

    _____________________________________________

    Then exit the PO without saving.

    1. Retailing: PurchasingPurchase OrderPurchase OrderCreateVendor Known.

      If necessary, maintain the Org. datain the Header area as follows: Purchasing Organization R300, Purchasing Group R30.

      Enter the item data as specified in the task.

      The system displays an error message for the second item: Article R1TA60 not maintained in plant R3##. In contrast to store R4##, the store R3## is not an assortment user of your assortment FOOD-L##. Thus, there’s no valid listing condition for store R3##.

      Exit the PO without saving.