Daily Archives: April 1, 2008

Assortment and listing

TCODES – WSM3 (Mass maintenance), WSP4 (Individual listing)

This component allows you to create merchandise assortments and assortment modules and assign articles to them. Articles can be automatically assigned directly to assortments as a result of checking rules during article maintenance or assortment maintenance functions. Alternatively, you can manually assign articles to assortment modules and then in turn assign the modules to assortments. In both cases, the system automatically generates listing conditions for each valid combination of article and assortment.

By assigning assortments to sites you control which assortments — and which articles — a store can purchase or sell. A site cannot purchase or sell an article that is not contained in one of its assortment.

When you create listing conditions, you also specify a listing period. This determines the timeframe during which sites can procure and sell the articles.

Listing conditions

The assignment of the individual articles to assortments is recorded in what are called listing conditions. These listing conditions contain the following:

  • The periods of time for which an article is to be assigned to an assortment
  • Inclusive or exclusive assignment (that is, whether an article is to be listed or excluded from listing)
  • The number of the module which caused the listing conditions to be generated
  • Whether the listing is for a promotion listing
  • Whether the module is assigned to a rack jobber
  • Whether an article is listed as a component of a structured article

In the case of manual listing using manually created assortment modules, the system creates listing conditions based on the assignment of the assortment module to an assortment.

In the case of automatic listing, the system uses listing rules to create listing conditions.




Retailers often have to centrally distribute merchandise among a large number of recipients (for example, stores). One example would be fashion merchandise or promotional items. Using allocation tables, you can plan the distribution of this type of merchandise and then trigger the necessary goods movements.

You can have the merchandise delivered directly from the vendor to the recipient, from the vendor to a distribution center and then to the recipient, or from a distribution center to a recipient.

After you have completed the planning stage, you can then have the system automatically create documents for procuring or delivering the goods.

Allocation table – wa01, wa02, wa03

Allocation Rule – wa21, wa22, wa23

Follow-on documents – wa03, wa08

Components of an Allocation Table –

The allocation table in made up of various components. The following is a short description of the main ones:

  • Allocation Table Header

An allocation table has one header.

The header contains information such as the allocation table number, the organizational levels for which it is valid (purchasing organization and purchasing group) and a header text.

  • Allocation Table Item

An item is assigned to the header.

Each allocation table can have a number of items. An item contains information such as the items category, the article number, the planned quantity, the allocation rule or site group used and the item status.

  • Site Group

A site group is assigned to an allocation table item.

The information displayed on the site group includes the number of the site group, the number of sites assigned to it, the quotas and the planned quantities.

  • Site

A site is assigned to a site group.

The information displayed on the site includes the number of the site, the planned quantity for the site and supply source.

  • Distribution Center

A distribution center is assigned to one or more sites.

The information displayed on the distribution center includes the number of the distribution center, the planned quantity and the external vendor supplying the distribution center.

  • Delivery Phase for a Site or Distribution Center

A delivery phase is assigned to a site/distribution center.

The information displayed on the delivery phase includes the delivery date, the order date and the delivery quantity.

Allocation Table Set-Up

The following is a simplified example of how an allocation table can be set up. Allocation rule 17 is used to determine how merchandise in a particular merchandise category is split up among the sites in site group R0021. The merchandise is split up in the ratio 6:4 between the two sites R151 and R152 in the site group. Variants 1 and 2 are to be allocated for the generic article 1.



Alloc. rule

Site group




Single article 1










Generic article 1










Variant 1 of item 20










Variant 2 of item 20









Synchronising Allocation table for Order changes –

You usually define allocation tables at an early stage in your business processes because you plan and order fashion goods, for example, with a long lead time. If your requirements change after you have created a purchase order but before the goods are delivered, for example, due to new stores opening, you can change the existing purchase order.

The system updates allocation-relevant changes in purchase orders to the relevant allocation tables.


You make changes to allocation-relevant purchase order items in purchase order processing for Seasonal Procurement. A log provides you with information about changes and about the synchronization of the allocation table.

The system synchronizes an allocation table in the background when purchase orders are changed.


· You have generated a vendor order (Seasonal Procurement) as a follow-on document for an allocation table, manually created an allocation table with reference to a purchase order (Seasonal Procurement), or generated an allocation table with reference to a purchase order based on operational assortment planning and control.

· Apart from the vendor order there are no other follow-on documents for recipients of the corresponding allocation table item.

Direct delivery orders cannot be synchronized.

· The purchase order item that you change must be uniquely linked to a delivery phase of the distribution center for an allocation table, otherwise synchronization is not possible.


When the following data is changed, the system updates the changes to the allocation table:

· Purchase order quantity and order unit

· Delivery date in distribution center

· Distribution center

· Flag for allocation table relevance

· Deletion of a purchase order item

You can use a Business Add-In (BAdI) to specify that when the allocation table is synchronized, the data for the distribution center be adjusted, but not the data for the recipient.

For more information, see Customizing for Logistics – General under Merchandise DistributionAllocation Allocation Table Business Add-Ins for the Allocation Table BAdI: Synchronizing Allocation Table for Changes to PO Items.


If you change purchase order items in purchase order processing for Seasonal Procurement and confirm your changes, the system first simulates synchronization of the corresponding allocation items. The changes are only effective in the database once you have saved them.

In both cases, you can check the results of changes in a log.

Synchronization is performed in several steps:

1. The system checks whether follow-on documents exist for recipients of the allocation table item. If they do, the system cannot change the allocation table and it issues a message to purchase order processing stating this.

2. The system copies the changes in the purchase order item to the distribution center of the relevant allocation table item.

3. The system copies changes that are relevant for the allocation table item from the purchase order item. While changes to the delivery date are not relevant, changes to quantities, for example, are.

4. The system transfers changes that are relevant for recipients for the individual allocation items .

You can use a BAdI to deactivate synchronization of recipient data.

5. It is possible that after the system transfers changes from the purchase order item to the allocation table items, these allocation table items will be incomplete. To ensure that the items are complete again and you are able to generate follow-on documents, you must post process incomplete allocation table items in the item overview of the allocation table.

Deleting Allocation Table

Choose the ‘Delete Allocation Table’ screen.

  1. In the Deletion for frame, choose Alloc tbl.
  2. Enter the required criteria for selecting the allocation tables to be deleted, for example purchasing organization, purchasing group or the allocation table number
  3. Enter the status of allocation tables you want to select. A distinction is made between:
    • Status Not active

An allocation table has this status if no follow-on documents have been generated for it. This type of deletion is used in cases where you have just created an allocation table but you realize immediately that it is not required (because the data entered was not correct or the allocation is not needed after all) and can be deleted.

    • Status Done

An allocation table has this status if all follow-on documents have been generated for it.

  1. Choose Program